MySQL Forums
Forum List  »  General

Time series database design
Posted by: Jack Groetzinger
Date: August 03, 2008 05:20PM

I'm creating a database that will store time series pricing data for online auctions (tracking how auction prices change over time). I'm wondering how to properly design this database so that it conforms to the normal forms. Specifically, my "price data" table includes columns for:

1) Price observation ID (primary key)
2) Auction ID (foreign key)
3) Price
4) Time of observation

Does the "time of observation" variable need to be moved to a separate table, such that a instead of including the time of observation in the above table I would include a foreign key that relates to a time of observation table? I'm worried that in the design above, multiple records would have the same time of observation, which seems to violate 2NF.

Options: ReplyQuote

Written By
Time series database design
August 03, 2008 05:20PM

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.