Re: [GENERAL] Design Question (Time Series Data)

2007-10-04 Thread Andreas Strasser
Ted Byers wrote: If you really have such a disparity among your series, then it is a mistake to blend them into a single table. You really need to spend more time analyzing what the data means. If one data set is comprised of the daily close price of a suite of stocks or mutual funds, then it

Re: [GENERAL] Design Question (Time Series Data)

2007-10-04 Thread Andreas Strasser
Pavel Stehule schrieb: 2007/10/4, Jorge Godoy <[EMAIL PROTECTED]>: On Thursday 04 October 2007 06:20:19 Pavel Stehule wrote: I'd use the same solution that he was going to: normalized table including a timestamp (with TZ because of daylight saving times...), a column with a FK to a series table

[GENERAL] Design Question (Time Series Data)

2007-10-03 Thread Andreas Strasser
Hello, i'm currently designing an application that will retrieve economic data (mainly time series)from different sources and distribute it to clients. It is supposed to manage around 20.000 different series with differing numbers of observations (some have only a few dozen observations, other