MySQL Forums
Forum List  »  Newbie

SHOPPING.com browsing
Posted by: Roman Gershman
Date: April 06, 2005 09:28AM

Hi !

I would like to know how it is possible to implement "parametric browsing" like in amazon, shopping.com etc.

In these sites, it is possible to browse the same table by the different attributes in any order. Suppose, I have a table "computers" with columns "brand", "price_level", "processor_type" etc. It these sites possible to see:
1) brand=IBM, 100<price_level<200, processor_type=P4 or
2) 300<price_level<400, brand=HP, processor_type=P3

and at each step see relevant results FAST.

If we would use indexing for each combination we would end up with N^K indices for K attributes and N values for each attribute.

And if we use independent index for each attribute then we will need to intersect queries which is relatively slow.

So, how it is possible to do it?

Options: ReplyQuote


Subject
Written By
Posted
SHOPPING.com browsing
April 06, 2005 09:28AM
April 06, 2005 10:50AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.