Re: Column stores

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