A Short DW DBMS Market History: HANA, Oracle, DB2, Netezza, Teradata, & Greenplum

Here is a quick review of tens years of data warehouse database competition… and a peek ahead… Maybe ten years ago Netezza shook up the DW DBMS market with a parallel database machine that could compete with Teradata. About six years ago Greenplum entered the market with a commodity-based product that was competitive… and then…

Hadoop and ETL

My last post (here) blathered about the effect that Hadoop must have on database vendor profits. An associate wrote me with the reminder that Hadoop is also impacting revenues and profits of ETL companies. If you think about Hadoop as both an inexpensive staging area for an EDW and as a parallel compute engine that can…

More Database Supercomputing Technology

Last year two associates from Greenplum suggested that I read a very smart academic paper titled “Efficiently Compiling Efficient Query Plans for Modern Hardware” by Thomas Neumann. Having reiterated the idea of database supercomputing in my last blog (here)… I can now suggest this paper to you. In short this paper suggests that the classic…

Database Super-computing

Today I am going to focus on a topic that I’ve suggested previously without the right emphasis: the new database architecture that uses vector processing on compressed columns to significantly accelerate performance. This is the final post inspired by Bityota (bityota.com). They reminded me that the use of vectors, once implemented by only a few vendors,…