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
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.
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.
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.
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.
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.
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.
Automatically manages the contents of the in-memory column store based on usage, maximizing use of database memory without requiring manual intervention.
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.
Die Mobiliar discusses the simplicity of setup and performance benefits or Oracle Database In-Memory for complex reporting.
Lufthansa benefits from the simplicity of setup, performance improvements and storage savings with Oracle Database In-Memory.
Run analytics reporting directly on operational data in real time without impacting transaction processing.
Database In-Memory enables users to speed up transaction processing by allowing them to drop analytics reporting indexes.
Achieve up to 10X performance improvements for business-critical reporting.
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