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.
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
Lufthansa
Lufthansa benefits from the simplicity of setup, performance improvements and storage savings with Oracle Database In-Memory.
Database In-Memory benefits
-
Real-time analytics
Run analytics reporting directly on operational data in real time without impacting transaction processing.
-
Reduced overhead
Database In-Memory enables users to speed up transaction processing by allowing them to drop analytics reporting indexes.
-
Improved reporting performance
Achieve up to 10X performance improvements for business-critical reporting.
Oracle Database 21c In-Memory Hybrid Scans
Andy Rivenes, Senior Principal Product Manager, Oracle Database In-MemoryIn-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 postFeatured Database In-Memory blogs
- DECEMBER 15, 2021 Oracle Database 12c enhanced in-memory external table support
- NOVEMBER 9, 2021 Oracle Database 21c In-Memory Full Text Columns
- NOVEMBER 1, 2021 Oracle Analytics Cloud uses Oracle Database In-Memory
Resources
Access Database In-Memory documentation
Related products and technologies
Oracle Real Application Clusters
High availability and scalability for Oracle Databases
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.