Yes, it sounds very attractive. I think they realized that many people were adding CDC and Vertica to Oracle databases and decided to add Vertica-like data store (columnar store with compressed and sorted columns) to Oracle.
Availability date wasn't announced, normally Oracle doesn't introduce major new features between releases so I guess we have to wait till 12.2.
Also pricing wasn't announced - I expect it to be separately licensed option like partitioning.
Not many details in the presentation, for example: how Optimizer will work with columnar store? Once a table has been placed in memory - will Optimizer direct all queries to this in-memory copy? Or some queries (single-row queries using unique index) will still use traditional db cache and data on disk? How it will work for joins between conventional and in-memory tables? What will happen if in-memory table has grown and no longer fits in the memory area reserved for columnar store?
Received on Thu Oct 10 2013 - 08:20:32 CEST
