In my blog yesterday (Part 1) I suggested that we could evaluate RDBMS-Hadoop integration architecture using three criteria: How parallel are the pipes to move data between the RDBMS and the parallel file system; Is there intelligence to push down predicates; and Is there more intelligence to push down joins and other relational operators? But…
I changed the picture to show you the billboard SAP bought on US101N right across from the O HQ… – Rob Larry Ellison announced a new in-memory capability for Oracle 12c last night. There is little solid information available but taken at face value the new feature is significant… very cool… and fairly capable. In…
In my last post here I suggested that there were three levels of maturity around column orientation and described the first level, PAX, which provides columnar compression. This apparently is the level Exadata operates at with its Hybrid Columnar Compression. In this post we will consider the next two levels of maturity: early materialized column…
There are three forms of columnar-orientation currently deployed by database systems today. Each builds upon the next. The simplest form uses column-orientation to provide better data compression. The next level of maturity stores columnar data in separate structures to support columnar projection. The most mature implementations support a columnar database engine that performs relational algebra…
In the post here I listed the units of parallelism (UoP) applied by various products on a single node. Those findings are summarized in the table below. Product Version/HW Cores per Node UoP per Node Notes Teradata EDW 6700H 16 32 Uses hyper-threads. Greenplum DCA UAP Edition 16 8 Recommends 1 Segment for each 2…
6 May… There is a good summary of this post and on the comments here. – Rob 17 April… A single unit of parallelism is a core plus a thread/process to feed it instructions plus a feed of data. The only exception is when the core uses hyper-threading… in which case 2 instructions can execute…
Since my blogs tend to be in response to some stimulus they may not reflect a holistic view on any particular product. The “My 2 Cents” series will try to provide a broader view… To help pay the bills please consider this as you read on… Summary OK, I hate Oracle marketing (see here and here).…
The SAP Business guy at Virtustream including EMC Federation
A melting pot for Enterprise Software, Analytics, Food, Sports, Politics and everything else that interests me
database research in the real world
Platform, Database and Storage Topics
Research into current database technology
It is about Architecture... not about Marketing...
