June 5, 2005 at 5:16 pm
Hi,
I've got a scenario, as many ecommerce websites do, whereby our customer wishes to sell many different types of products - from bikes to CD's. A design i've used before in this type of scenario is a three table approach....a table listing all the possible attributes, a products table which lists the common attributes across all the product ranges such as title,price...and then a productattributes table which stores a list of attributes for each product...
Although this method has worked for me in the past, it is a complete and utter pain....theres far more work involved in the coding, much harder to maintain data integrity, and to get comparable speeds to a normalized table approach takes forever....and a lot of testing and reworking....
Is this really the sort of approach other large online ecommerce websites such as amazon adopt? Is there no clever methods for mapping product categories to specific tables without having to use dynamic SQL???
Any thoughts anyone???
Thanks
Al
June 7, 2005 at 7:14 am
I can't talk on the behalf of amazon, but if you could post the tables definition, maybe we could give you some pointers.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply