This is the second post (see Part 1 here) on how vendors adjust their architecture without admitting that the previous architecture was flawed. This time we’ll consider Teradata and in-memory…. When SAP HANA appeared Teradata went on the warpath with a series of posts and statements that were pointed but oddly miscued (see the references below).…
Back to more geeky topics… although my Mom loved the videos… When very high performance is required to return key performance metrics derived from large volumes of data to a very large number of clients… in other words when volume and velocity are factors and the results are to be delivered to thousands of users (I…
I’m working on a new idea… it may or may not pan out… but here are some concepts for your consideration… with some thoughts on their performance implications. First a reminder… a reality check. In my experience if you POC two databases at about the same price point…and one is 30% faster than the other, 1.3X, then…
I would like to point out a very important section in the paper on Hekaton on the Microsoft Research site here. I will quote the section in total: 2. DESIGN CONSIDERATIONS An analysis done early on in the project drove home the fact that a 10-100X throughput improvement cannot be achieved by optimizing existing SQL…
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…
IBM is presenting a DB2 Tech Talk that compares the BLU Accelerator to HANA. There are several mistakes and some odd thinking in the pitch so let me address the issues as a way to explain some things about HANA and about BLU. This blog will consider what data needs to be in-memory. IBM like…
I recently listened to a session by Juan Loalza of Oracle on the 12c In-memory option. Here are my notes and comments in order… There is only one copy of the data on disk and that is in row format (“the column format does not exist on disk”). This has huge implications. Many of the…
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...
