jueves, 7 de agosto de 2014

Monday Aug 04, 2014

In part two of this series on getting started with Oracle Database In-Memory I’ll explain how and when objects are populated into the In-Memory column store (IM column store) and exactly how you can control it.

Which objects are populated into the IM column store?

As I mention last week, only objects with the INMEMORY attribute are populated into the IM column store. TheINMEMORY attribute can be specified on a tablespace, table, (sub)partition, or materialized view. In this example the INMEMORY attribute is specified on the CUSTOMERS.

Tuesday Jul 22, 2014

Oracle Database 12.1.0.2 was officially release today and is now available for download, which mean Oracle Database In-Memory is officially here!

Along with the software release comes a whole new set of collateral that explains in detail how all of the new Oracle Database In-Memory functionality works. The In-Memory page on Oracle.com has all of the juicy details including the official whitepaper.

Sunday Jul 06, 2014

As we continue our series of Q&A style blogs on Oracle Database In-Memory, I've got a chance to go back to my old life as the optimizer lady as I've been inundated with questions about the In-Memory option and the Optimizer.

Below are the answers to the questions I gotten so far.

If there is something else you want to know about how these two fascinating pieces of the Oracle technology work together just email me and I will include it in an upcoming post.

Is there a new Optimizer to deal with queries against the In-Memory column store?

Wednesday Jun 25, 2014

Thanks to all those who have sent me questions on the new Oracle Database In-Memory. Below are the answers to some of the questions you have sent. Don't worry if you don't see the answer to your question in this particular blog post, as there has been a huge interest and a lot of questions!

I have grouped the questions into categories and will publish a different category every couple of days for the next few weeks. In this post I focus on questions around the population of the In-Memory column store (IM column store).

I have spent this week on the road participating in launch events all over Europe and have gotten a lot of question about the In-Memory option and how it works. So, I thought it would be a good idea to begin our In-Memory blog with the answers to some of the most commonly asked questions about Oracle Database In-Memory.

Sunday Feb 16, 2014

At Oracle Open World 2013 Larry Ellison announced the upcoming availability of Oracle Database In-Memory, a solution for accelerating database-driven business decision-making to real-time. Unlike specialized approaches that are restricted to particular workloads or applications, Oracle leverages a new In-Memory Column Store format to speed up analytics.

But how does it work? What performance improvements can you expect? How do you enable it?