The Community for Technology Leaders
2015 IEEE 31st International Conference on Data Engineering (ICDE) (2015)
Seoul, South Korea
April 13, 2015 to April 17, 2015
ISBN: 978-1-4799-7964-6
pp: 1253-1258
Tirthankar Lahiri , Server Technologies, Oracle America, 400 Oracle Parkway, Redwood Shores, CA 94065, USA
Shasank Chavan , Server Technologies, Oracle America, 400 Oracle Parkway, Redwood Shores, CA 94065, USA
Maria Colgan , Server Technologies, Oracle America, 400 Oracle Parkway, Redwood Shores, CA 94065, USA
Dinesh Das , Server Technologies, Oracle America, 400 Oracle Parkway, Redwood Shores, CA 94065, USA
Amit Ganesh , Server Technologies, Oracle America, 400 Oracle Parkway, Redwood Shores, CA 94065, USA
Mike Gleeson , Server Technologies, Oracle America, 400 Oracle Parkway, Redwood Shores, CA 94065, USA
Sanket Hase , Server Technologies, Oracle America, 400 Oracle Parkway, Redwood Shores, CA 94065, USA
Allison Holloway , Server Technologies, Oracle America, 400 Oracle Parkway, Redwood Shores, CA 94065, USA
Jesse Kamp , Server Technologies, Oracle America, 400 Oracle Parkway, Redwood Shores, CA 94065, USA
Teck-Hua Lee , Server Technologies, Oracle America, 400 Oracle Parkway, Redwood Shores, CA 94065, USA
Juan Loaiza , Server Technologies, Oracle America, 400 Oracle Parkway, Redwood Shores, CA 94065, USA
Neil Macnaughton , Server Technologies, Oracle America, 400 Oracle Parkway, Redwood Shores, CA 94065, USA
Vineet Marwah , Server Technologies, Oracle America, 400 Oracle Parkway, Redwood Shores, CA 94065, USA
Niloy Mukherjee , Server Technologies, Oracle America, 400 Oracle Parkway, Redwood Shores, CA 94065, USA
Atrayee Mullick , Server Technologies, Oracle America, 400 Oracle Parkway, Redwood Shores, CA 94065, USA
Sujatha Muthulingam , Server Technologies, Oracle America, 400 Oracle Parkway, Redwood Shores, CA 94065, USA
Vivekanandhan Raja , Server Technologies, Oracle America, 400 Oracle Parkway, Redwood Shores, CA 94065, USA
Marty Roth , Server Technologies, Oracle America, 400 Oracle Parkway, Redwood Shores, CA 94065, USA
Ekrem Soylemez , Server Technologies, Oracle America, 400 Oracle Parkway, Redwood Shores, CA 94065, USA
Mohamed Zait , Server Technologies, Oracle America, 400 Oracle Parkway, Redwood Shores, CA 94065, USA
ABSTRACT
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.
INDEX TERMS
Indexes, Memory management, Buffer storage, Servers, Optimization, Acceleration
CITATION
Tirthankar Lahiri, Shasank Chavan, Maria Colgan, Dinesh Das, Amit Ganesh, Mike Gleeson, Sanket Hase, Allison Holloway, Jesse Kamp, Teck-Hua Lee, Juan Loaiza, Neil Macnaughton, Vineet Marwah, Niloy Mukherjee, Atrayee Mullick, Sujatha Muthulingam, Vivekanandhan Raja, Marty Roth, Ekrem Soylemez, Mohamed Zait, "Oracle Database In-Memory: A dual format in-memory database", 2015 IEEE 31st International Conference on Data Engineering (ICDE), vol. 00, no. , pp. 1253-1258, 2015, doi:10.1109/ICDE.2015.7113373
80 ms
(Ver 3.3 (11022016))