Oracle Database In-Memory Reviews

Martin Klier

Senior Database Consultant at Performing Databases

Aug 08 2019

It helps to build successful mixed-workload environments

What is most valuable?

In recent versions, Oracle implemented storing the In-Memory column store contents in the database, to resurrect the IMCS quicker and in a repeatable way.

How has it helped my organization?

It helps to build successful mixed-workload environments. Thus, for smaller setups, it's enough to have one database setup, not two, and it saves one interface in between.

What needs improvement?

One very nice side-effect is the in-memory index. If this would be developed a bit more into being configurable, users could use it as a kind of in-memory partitioning… more»

What's my experience with pricing, setup cost, and licensing?

The setup cost is not a big factor, but the engineer should have decent experience with Oracle's In-Memory system. License cost is a factor; the benefit has to be… more»

Which solution did I use previously and why did I switch?

No, since there was no other solution offering in-memory without changing the SQL syntax.

What other advice do I have?

It is always worth testing or running a proof of concept to check its value.

Which other solutions did I evaluate?

We tried several ways to offload OLAP queries from the database, especially using a second DB system. We evaluated this product throughout the beta1 and beta2 phase.

See Entire Oracle Database In-Memory Review (443 Words) »

Articles

User Assessments By Topic About Oracle Database In-Memory

Oracle Database In-Memory Questions

What is Oracle Database In-Memory?

Oracle Database In-Memory transparently accelerates analytics by orders of magnitude while simultaneously speeding up mixed-workload OLTP. With Oracle Database In-Memory, users get immediate answers to business questions that previously took hours.

Oracle Database In-Memory delivers leading-edge in-memory performance without the need to restrict functionality, or accept compromises, complexity and risk. Deploying Oracle Database In-Memory with any existing Oracle Database compatible application is as easy as flipping a switch - no application changes are required. Oracle Database In-Memory is fully integrated with the Oracle Database’s renowned scale-up, scale-out, storage tiering, availability, and security technologies making it the most industrialstrength offering on the market.

The ability to easily perform real-time data analysis together with real-time transaction processing on all existing applications enables organizations to transform into Real-Time Enterprises that quickly make data-driven decisions, respond instantly to customer demands, and continuously optimize all key processes.

For more information on Oracle Database In-Memory, visit Oracle.com

Oracle Database In-Memory customers

Shanghai Customs