Database In-Memory

Oracle Database In-Memory adds columnar functionality to Oracle Database for transparently accelerating analytic queries by orders of magnitude. Oracle Database In-Memory enables decision-making based on real-time data to lower costs, improve productivity, and increase competitiveness.

Improve database reporting by 100x with Oracle Database In-Memory (6:46)

Accelerating applications with Oracle Database In-Memory

Database In-Memory features

In-memory columnar format

Oracle Database In-Memory implements state-of-the-art algorithms for in-memory scans, joins, and aggregation. These optimizations, along with SIMD vector processing, enable Oracle Database In-Memory to run queries at billions of rows per second for each CPU core. Analytics that previously took hours or longer to run can now complete in seconds, enabling real-time business decisions.

Dual-format architecture

The dual-format architecture of Oracle Database In-Memory represents tables simultaneously using a traditional row format and a new, in-memory column format. With it, you can run transaction processing and analytics reporting on the same data in the same database.

Scale out

Oracle Database In-Memory enables transparent, in-memory scale out across Oracle Real Application Clusters (RAC). Not limited by memory on a single node, Oracle Database In-Memory can transparently access the memory across all the nodes in a cluster, providing you with the ability to create a columnar store larger than a single node.

High availability

You can create, populate, and maintain an in-memory column store on a standby database in an active data guard configuration. This allows full use of the CPU and memory resources on the standby database for analytic workloads as well as flexible placement of the in-memory column store across the primary database and its affiliated standby databases.

In-memory fault tolerance

Oracle Database In-Memory distributes and duplicates in-memory data across the nodes of an Oracle Exadata cluster, eliminating any slowdown due to node failures. If a node fails, queries can transparently use the duplicate copy of data on surviving nodes.

Compatibility

No application changes are required when deploying Oracle Database In-Memory with any Oracle Database–compatible application. All of Oracle’s extensive features, data types, and APIs continue to work transparently.

Automatic in-memory

Automatically manages the contents of the in-memory column store based on usage, maximizing use of database memory without requiring manual intervention.

Real-time reporting across multiple data sources

Enables direct population of external data sources to allow users to run analytic queries on all sources of data, both internal and external to Oracle Database.

Customer success stories

Die Mobiliar

Die Mobiliar discusses the simplicity of setup and performance benefits or Oracle Database In-Memory for complex reporting.

Lufthansa

Lufthansa benefits from the simplicity of setup, performance improvements and storage savings with Oracle Database In-Memory.

Database In-Memory benefits

MARCH 18, 2022

Oracle Database 21c In-Memory Hybrid Scans

Andy Rivenes, Senior Principal Product Manager, Oracle Database In-Memory

In-Memory Hybrid Scans is a new feature in Oracle 21c. With In-Memory Hybrid Scans, if you exclude columns for a table from being populated the query can still access that table in the in-memory (IM) column store.

Read the complete post

Related products and technologies

Oracle Real Application Clusters

High availability and scalability for Oracle Databases

Active Data Guard

Disaster recovery and data protection for enterprise data

Exadata

Enables higher availability, greater performance, and up to 40% lower cost

Partitioning

Enhances the manageability, performance, and availability of large databases

Get started with Oracle Database In-Memory


Tutorials

Learn about key Oracle Database In-Memory concepts.


Contact us

Find out how Oracle Database In-Memory can help you.