Does anyone have any experience with column store databases? http://en.wikipedia.org/wiki/Column-oriented_DBMSI have a looming situation where I will be generating up to 3 million rows of numbers per minute, and need to store them. table schema something like this:create table GrowsFast ( TimeKey int not null ,SegmentID int not null ,Speed tinyint not null ,Error tinyint not null -- a few other things ,primary key (TimeKey, SegmentID))
Much of the data in a given column will be the same, for example each minute, all values of TimeKey will be the same. From minute to minute, the similar SegmentID will appear (there are about 40 million possible values for SegmentID, but only approx 3 m will actually be present any particular minute). Speed can only range from 1 to 75 say. Same for Error. So lots of same values.So I was thinking may be a column store db may be a good way to go. I've never used one though so though I'd poll for opinions. 
elsasoft.org
column store databases
Posted - 2010-06-16 : 19:06:03
