Re: [GENERAL] Array columns vs normalized table

2010-03-02 Thread Lee Hachadoorian
Pavel, the idea of using arrays to store long time-series data sounds good, but I take your point that normalized tables might be better and are easier to query. I suppose the choice will be between normalizing or using the denormalized industry int, year    smallint, emp_q1  int, emp_q2  int, emp

Re: [GENERAL] Array columns vs normalized table

2010-03-02 Thread Scott Bailey
Lee Hachadoorian wrote: I work with state labor data which is reported to us in the form industry, year, quarter1, quarter2, quarter3, quarter4 where each quarter represents an employment count. Obviously, this can be normalized to industry, year, quarter, employment Can anyon

Re: [GENERAL] Array columns vs normalized table

2010-03-02 Thread Peter Hunsberger
On Tue, Mar 2, 2010 at 11:21 AM, Lee Hachadoorian wrote: > I work with state labor data which is reported to us in the form > >        industry, year, quarter1, quarter2, quarter3, quarter4 > > where each quarter represents an employment count. Obviously, this can > be normalized to > >        ind

Re: [GENERAL] Array columns vs normalized table

2010-03-02 Thread Pavel Stehule
Hello 2010/3/2 Lee Hachadoorian : > I work with state labor data which is reported to us in the form > >        industry, year, quarter1, quarter2, quarter3, quarter4 > > where each quarter represents an employment count. Obviously, this can > be normalized to > >        industry, year, quarter, e

[GENERAL] Array columns vs normalized table

2010-03-02 Thread Lee Hachadoorian
I work with state labor data which is reported to us in the form industry, year, quarter1, quarter2, quarter3, quarter4 where each quarter represents an employment count. Obviously, this can be normalized to industry, year, quarter, employment Can anyone comment on, or point to