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

Written By
Need modeling help
April 05, 2009 08:10PM
April 06, 2009 01:21AM
April 06, 2009 06:54PM
April 07, 2009 10:18PM
April 11, 2009 08:36PM
April 14, 2009 01:34AM
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.