Re: Column stores

[Seth Grimes <grimes(at)altaplana(dot)com>]

No, not all column stores are MPP.  I believe that Brighthouse from 
Infobright isn't although the company is looking into it.

Compression and a columnar storage are separate things that can go 
hand-in-hand.  Does Greenplum have both or just compression?

Thanks,

					Seth

On Wed, 30 Jan 2008, Luke Lonergan wrote:

> Hi Seth,
>
> On Mon, 2008-01-28 at 12:04 -0800, Seth Grimes wrote:
> > Column stores are all the rage now in the data warehousing world as an
> > alternative to traditional approaches and to MPP approaches that include
> > Greenplum.  There's one company, InfoBright, that's offering a
> > column-store engine, not open source, for MySQL.
>
> That's funny - all of the column approaches that are "the rage" in DW 
> are MPP in addition to column store.  If people wanted a non-MPP column 
> store they buy Sybase IQ.
>
> So - not only do the raging column companies have to do a new version of 
> the old column idea (that avoids the big drawbacks of near read-only 
> behaviors, specialized "projection" operations, etc), but they also have 
> to get the MPP part right.  Speaking from our experience - of the two, 
> it's a lot harder to get all the MPP parts right than it is to add a 
> column store module.
>
> Not that there aren't some good ideas coming from these discussions - 
> our point of view at Greenplum is that column store / compression isn't 
> a company or product, it's a feature.  Further, it's one we've also got 
> covered :-)
>
> - Luke

--
Seth Grimes   Alta Plana Corp, analytical computing & data management
              Intelligent Enterprise magazine (CMP), Contributing Editor
grimes(at)altaplana(dot)com       http://altaplana.com    301-270-0795