Oracle Database In-Memory Reviews

Laurent Leturgez

Owner - Consultant at a tech services company with 51-200 employees

Aug 01 2017

Combined with Exadata, it makes a solution that will deliver the best performance related to the volume of data.

What is most valuable?

Oracle has a lot of features embedded. In my opinion, Oracle In-Memory offers a lot of improvements in database performance specially for data warehouses and analytics workloads. Combined with Exadata, it makes a solution that will deliver… more»

How has it helped my organization?

Each time I've implemented the In-Memory option, the improvements have been on the performance side. This option offers a way to drastically reduce batch duration with a minimum of work because we only need to enable it on columns we… more»

What needs improvement?

They need to improve the Decision Support System with analytics workloads.

If you previously used a different solution, which one did you use and why did you switch?

I tested the In-Memory equivalent in DB2 or SQL Server 2014, but they both have limitations in their uses. SAP HANA is one of the most concurrent of Oracle’s solution, but I have never used it.

What other advice do I have?

Implementing Oracle In-Memory is very easy, but the tuning phase is mandatory to optimize it.

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

Martin Klier

Senior Database Consultant at Performing Databases

Mar 12 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»

If you previously used a different solution, which one did you use and why did you 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 (449 Words) »

IT Director at a manufacturing company with 1,001-5,000 employees

Jul 31 2017

It scales really well.

What is most valuable?

Performance. That's probably the number one. When we use it for OLTP, which is the Online Transaction Processing, the response for the end-user is pretty fast, which is a good thing, especially if the… more»

How has it helped my organization?

I think it still goes back to the user benefiting the most out of this, it's basically a good customer experience, the product.

What needs improvement?

Nothing right now.

If you previously used a different solution, which one did you use and why did you switch?

No, we always needed something like this, and I've looked at Microsoft, they have a similar solution, I think they have something similar,

What other advice do I have?

Try it out first. See if it meets your expectations and go from there.

Which other solutions did I evaluate?

We did evaluate a few other vendors, but again this wasn't a product on it's own. It's part of the bigger ecosystem. So the decisions are for other reasons.

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

Director at a tech vendor with 10,001+ employees

Jul 30 2017

The most valuable features are its real time performance and consistency.

What is most valuable?

The most valuable features are its real time performance and consistency.

How has it helped my organization?

We are not using it for our internal systems, but rather for our customer solutions. We can provide a high standard with this solution to our customers by using such products.

What needs improvement?

We are waiting for new features in the next release.

If you previously used a different solution, which one did you use and why did you switch?

We had started to use this solution from the beginning. We haven't switched from another solution. When selecting a vendor, we want someone who has a long term road map. This demonstrates… more»

What other advice do I have?

I recommend using this solution, just as we are using it.

Which other solutions did I evaluate?

We haven't used other vendors. We have a long relationship with Oracle and we have had a good experience with them in the past.

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

Articles

User Assessments By Topic About Oracle Database In-Memory

Oracle Database In-Memory Questions

Oracle Database In-Memory Projects By Members

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