MySQL Forums :: General :: Time series database design


Advanced Search

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


Subject Written By Posted
Time series database design Jack Groetzinger 08/03/2008 05:20PM
Re: Time series database design Peter Brawley 08/03/2008 08:46PM
Re: Time series database design Jack Groetzinger 08/03/2008 09:46PM
Re: Time series database design Peter Brawley 08/03/2008 10:47PM
Re: Time series database design Max Hrabrov 06/12/2009 07:35AM
Re: Time series database design Rick James 06/12/2009 09:53AM
Re: Time series database design Peter Brawley 06/12/2009 11:21AM


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.