Session ID: 457
Oracle Database In-Memory introduces a new in-memory columnar format that is compatible with all existing applications. Join Oracle Product Management to learn in detail what motivated Oracle to develop this new technology and how it works alongside the traditional row format to provide a unique "dual format" architecture. This session will explore how Database In-Memory enables "Real-Time Analytics" by allowing analytic style queries to be run directly on source data. It will also explore the key performance enhancing features of Database In-Memory including in-memory scans, predicate push down, hash joins with bloom filters, vector group by aggregation, and new high-performance features like In-Memory Expressions and Join Groups.
The session will conclude by exploring how the new in-memory functionality interacts with key database performance features such as Real Application Clusters (RAC), Partitioning, parallel execution, and much more.
Objective 1: Learn why columnar formatting is so much faster than traditional row based formats for analytic queries.
Objective 2: Learn how existing applications can take advantage of Database In-Memory without changing any application code including E-Business Suite, J.D. Edwards and other commercial applications.
Objective 3: The attendee will learn how Database In-Memory's features can be used to further improve performance.