I attended Oracle OpenWorld last week and of course the main story-line was the Exadata X3 In-Memory Machine with Oracle Database 12c. The highlights were the expansion of memory use by this system as well as the use of columnar storage for compression, the container database system for cloud and multi-tenant, and the automatic data optimization into Hot Data, Warm Data, and Archive Data.
Container databases are very powerful for any cloud vendor who builds on top of Oracle database because multi-tenancy now becomes much easier. In fact, Enterprise IT shops that run Oracle databases will also find this a powerful tool to simplify their lives.
In-memory and column storage are not new. SAP HANA has been doing this for some time now and generating a lot of buzz and traction within the industry. It is nice to see Oracle recognize and respond.
The Automatic Data Optimization feature is something that looks very similar to what Teradata has been doing for years. I wrote about what Teradata is doing in a blog post earlier this year: what data to put into memory. I don’t know what Oracle’s ratios are and I could not find anyone that could tell me what studies the design of X3 is based on but worth reviewing what Teradata does.