MySQL Forums
Forum List  »  MySQL Workbench

Need modeling help
Posted by: Richard Dalton
Date: April 05, 2009 08:10PM

I'm somewhat of a newbie at databases so please be gentle ;-)

I'm trying to construct a model for this situation:

Lets say I have thousands of retail stores, and a product catalog of thousands of items and each store carries some (hundreds) of those items.

I want to be able to look at a store and see which other stores carry the same items (they might also carry more).

I can think of very brute-force ways of doing this, but i'm a little concerned about processing time and i'm wondering if there isn't an elegant way of doing it?

- Richard

Options: ReplyQuote


Subject
Views
Written By
Posted
Need modeling help
2700
April 05, 2009 08:10PM
2436
April 06, 2009 01:21AM
2243
April 06, 2009 06:54PM
2178
April 07, 2009 10:18PM
2053
April 11, 2009 08:36PM
2228
April 14, 2009 01:34AM
1993
April 17, 2009 07:03PM


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.