Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-26 : 12:37:48
|
Joe writes "I am writing a report for school about the database architecture of price comparison sites and am trying to figure out how do product search engines like mySimon or DealTime store the data and show results in an alternating manners. For example, when you search for a 'camera' and hundreds of matching results are returned, they are shown 3 at a time from each merchant. 3 from amazon, 3 from ritzcamera...you get my point. How is the data stored in the database? Are all the products stored in a single table? Or are products from every store stored in a separate table? Then, when the matches are found, how is the order arranged in the alternating manner? Do they use cursors to build a temporary table with the recordset sorted in the desired way?
Here is one sample of the results:
http://www.mysimon.com/isrch/index.jhtml?c=cameras&InputModel=&pgid=shop&InputManufacturer=&InputKeyword=&InputPriceMin=&InputPriceMax=&_ttag=b1clk&InputType=35mm&key=UC_20001225_123819_0101174438
Thanks
Joe" |
|
|
|
|
|
Puzzled Student...