The next wave in BI

Topic: TPC-H fun with Greenplum

Date: 28/01/2010

By: mark

Subject: mixing storage types

Interesting that they offer a column option for table storage. I think the future of databases is likely be to have both storage types. It's hard to do because of the query optimization needed to deal with row and column stored tables in the same place. Since the physical storage is different, it's no surprise that you have to unload. Heck, not too long ago you had to unload and reload DB2 tables for certain table changes (not that DB2 has ever been the most friendly or easy to administer).

I am surprised at no CSQs. I thought they were better than that. Given the types of queries needed for BI, it's hard to position a product as an analytic database if CSQs can't be handled.