This short post is intended to provide a quick warning regarding in-memory columnar and cpu requirements… with a longer post to follow. When a row is inserted or bulk-loaded into a DBMS, if there are no indexes, the amount of cpu required is very small. The majority of the time is spent committing a transaction…
In many of my posts I refer to the issues associated with building “extra” data structures to meet performance goals (see one of my first posts ever here). These extra structures are always a trade-off… slowing the performance of one function in order to speed up another. I thought that it might be helpful to be…
There seems to be a sort of odd tradition for bloggers to look back at the past year as the New Year starts to unfold. Here is my review of my posts and some presents … Top Post Far and away the most viewed post was Exalytics vs. HANA What are they thinking? This simply notes…
I posted a blog on the SAP site here that discussed the implications of mobile clients. I want to re-emphasize the issue as it is crucial. While at Greenplum we routinely replaced older EDW platforms and provided stunning performance. I recall one customer in particular where we were given a query that ran in 7…
As you may have noticed I’m looking at in-memory databases (IMDB) these days… Here are some quick architectural observations on VMWare‘s SQLFire, Oracle’s Exalytics and TimesTen offerings, and SAP HANA. It is worth noting up front that I am looking to see how these products might be used to build a generalized data mart or…
Here are links to several commercial posts on the Experience HANA Blog FYI… The Five Minute Rule and HANA: This is a rehash of my posts here applying the famous Five Minute Rule to in-memory databases. HANA & Exalytics: There is Barely Any Comparison: This is a rehash of my post here pointing out that…
I was recently reminded of a couple of papers written by Jim Gray and Gianfranco Putzolu that calculated the cost of keeping data in memory vs the cost of paging it in from disk. I was happy to see that the thread was being kept alive by Goetz Graefe. These papers used the cost of…
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...
