Oracle Database In-Memory
E486215
Oracle Database In-Memory is an optional feature of the Oracle Database that accelerates analytic and mixed workloads by storing data in a dual-format architecture, including a highly optimized in-memory columnar format.
Statements (47)
| Predicate | Object |
|---|---|
| instanceOf |
Oracle Database option
ⓘ
database feature ⓘ |
| benefit |
improves analytic throughput
ⓘ
offloads analytic processing from row store ⓘ reduces query response time ⓘ |
| compatibleWith | Oracle Real Application Clusters NERFINISHED ⓘ |
| controlledBy | In-Memory column store size parameter ⓘ |
| developer | Oracle Corporation NERFINISHED ⓘ |
| documentationURL | https://docs.oracle.com/en/database/oracle/oracle-database/ ⓘ |
| hasArchitecture | dual-format architecture ⓘ |
| hasFeature | in-memory column store ⓘ |
| integratesWith |
Oracle Exadata
NERFINISHED
ⓘ
Oracle Optimizer NERFINISHED ⓘ Oracle Real Application Clusters (RAC) NERFINISHED ⓘ |
| introducedInVersion | Oracle Database 12c Release 1 (12.1.0.2) NERFINISHED ⓘ |
| keepsCopy | in-memory columnar format for query acceleration ⓘ |
| maintains | full transactional consistency with row store ⓘ |
| optimizesFor |
analytic queries
ⓘ
scans of large data sets ⓘ |
| partOf | Oracle Database NERFINISHED ⓘ |
| persistsData | on disk in traditional row format ⓘ |
| primaryGoal |
accelerate analytic workloads
ⓘ
accelerate mixed workloads ⓘ |
| requires | additional Oracle Database license ⓘ |
| storesDataFormat |
in-memory columnar format
ⓘ
row format ⓘ |
| supports |
OLTP and analytic workloads on the same database
ⓘ
automatic in-memory management ⓘ column-level in-memory population ⓘ partition-level in-memory population ⓘ priority-based population ⓘ real-time analytics ⓘ table-level in-memory population ⓘ |
| supportsFeature |
In-Memory Aggregation
ⓘ
In-Memory Column Store on Exadata Flash NERFINISHED ⓘ In-Memory Dynamic Scans NERFINISHED ⓘ In-Memory Expressions ⓘ In-Memory External Tables ⓘ In-Memory FastStart NERFINISHED ⓘ In-Memory Joins ⓘ In-Memory Optimized Arithmetic ⓘ In-Memory Virtual Columns ⓘ In-Memory on Active Data Guard standby ⓘ |
| transparentTo | applications ⓘ |
| usesTechnique |
SIMD operations
ⓘ
in-memory columnar compression ⓘ vector processing ⓘ |
Referenced by (1)
Full triples — surface form annotated when it differs from this entity's canonical label.