Data Modeling Problem
Posted by: John Wills
Date: November 09, 2007 11:56AM

Hello all. I was hoping someone could give me some direction in a data modeling problem I have. Any help would be greatly appreciated. Here is how my data lays out:

- I have 200 categories (these are static -- no more, no less)
- Every week a have a new performance value for each category

I am trying to track weekly performance, but I cannot seem to figure out how to manage this data efficiently. The only options I can think of are 200 different tables (which seems difficult to manage), or one large table (probably the most inefficient).

I been looking for weeks now and I am relatively new to MYSQL. Could someone help me with a little direction?

Thank you in advance.

Options: ReplyQuote


Subject
Written By
Posted
Data Modeling Problem
November 09, 2007 11:56AM
November 09, 2007 12:20PM
November 09, 2007 12:23PM


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.