I’m riffing on database design and modeling in an agile methodology. In the previous post here I suggested that we … More
Tag: Database management system
Refactoring Databases P2.5: Scoping the Cheats
One of the side-effects of the little cheat posted here is that, if we are going to design early we … More
Refactoring Databases P2: Cheating a Little
In this post I am going to suggest doing a little design a little upfront and violating the purity of … More
How DBMS Vendors Admit to an Architectural Limitation: Part 2 – Teradata Intelligent Memory
This is the second post (see Part 1 here) on how vendors adjust their architecture without admitting that the previous … More
Dynamic Late Binding Schemas on Need
I very much like Curt Monash’s posts on dynamic schemas and schema-on-need… here and here are two examples. They make me … More
Specialized Databases vs. Swiss Army Knives
Michael Stonbreaker has suggested several times… and again in this interview… that databases will become more specialized and that “one size … More
CPUs and HW for HANA, BLU, Hekaton, and Oracle 12c
This short post is intended to provide a quick warning regarding in-memory columnar and cpu requirements… with a longer post … More
HANA Memory Utilization
The current release of HANA requires that all of the data required to satisfy a query be in-memory to run … More
Who is How Columnar? Exadata, Teradata, and HANA – Part 1: Column Compression
There are three forms of columnar-orientation currently deployed by database systems today. Each builds upon the next. The simplest form … More
Indexes are not a good thing… A blog on TCO
In many of my posts I refer to the issues associated with building “extra” data structures to meet performance goals … More