September 22, 2011
Hybrid-columnar soundbites
Busy couple of days talking with reporters. A few notes on hybrid-columnar analytic DBMS, all backed up by yesterday’s post on Teradata columnar:
- Oracle does not actually offer columnar I/O; the other three systems do. But see the “I won’t be surprised” part in yesterday’s Teradata post.
- Aster does not offer columnar compression; the other three do.
- EMC Greenplum and Teradata offer different kinds of ways to mix column and row storage in the same table; each has its advantages.
- Teradata generally has a more mature and capable offering than EMC Greenplum, for most purposes, whichever way you choose to organize your tables.
Edit: The Wall Street Journal got this wrong, writing that Teradata was the first-ever hybrid columnar system. Specifically, they wrote
While columnar technology has been around for years, Teradata says its product is unique because it allows users to include both columns and rows in the same database.
Googling on “Teradata To Unveil New Analytics Product To Speed Business Adoption” might get you around the paywall to see the offending piece.
Categories: Aster Data, Columnar database management, Data warehousing, Database compression, Greenplum, Teradata
Subscribe to our complete feed!
Comments
2 Responses to “Hybrid-columnar soundbites”
Leave a Reply
Hi Curt,
Why when you talk about columnar compression, you never mention Netezza? It also has columnar compression, as far as I know.
Andrey,
Force of habit. I remember when Netezza had no compression at all, and then when it had lame compression. Netezza has also used odd phrasing around compression.
http://www.dbms2.com/2010/06/21/netezza-ibm-db2-compression/