Oracle Database In-Memory: A dual format in-memory database

The Oracle Database In-Memory Option allows Oracle to function as the industry-first dual-format in-memory database. Row formats are ideal for OLTP workloads which typically use indexes to limit their data access to a small set of rows, while column formats are better suited for Analytic operations...

Full description

Saved in:
Bibliographic Details
Main Authors: Lahiri, Tirthankar, Chavan, Shasank, Colgan, Maria, Das, Dinesh, Ganesh, Amit, Gleeson, Mike, Hase, Sanket, Holloway, Allison, Kamp, Jesse, Teck-Hua Lee, Loaiza, Juan, Macnaughton, Neil, Marwah, Vineet, Mukherjee, Niloy, Mullick, Atrayee, Muthulingam, Sujatha, Raja, Vivekanandhan, Roth, Marty, Soylemez, Ekrem, Zait, Mohamed
Format: Conference Proceeding
Language:English
Subjects:
Acceleration
Buffer storage
Indexes
Memory management
Optimization
Servers
Online Access:Request full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:The Oracle Database In-Memory Option allows Oracle to function as the industry-first dual-format in-memory database. Row formats are ideal for OLTP workloads which typically use indexes to limit their data access to a small set of rows, while column formats are better suited for Analytic operations which typically examine a small number of columns from a large number of rows. Since no single data format is ideal for all types of workloads, our approach was to allow data to be simultaneously maintained in both formats with strict transactional consistency between them.
ISSN:1063-6382
2375-026X
DOI:10.1109/ICDE.2015.7113373