Paper Unlock

Authors: Niloy Mukherjee ; Kartik Kulkarni ; Hui Jin ; Jesse Kamp and Tirthankar Lahiri

Affiliation: Oracle Corporation, United States

ISBN: 978-989-758-114-4

Keyword(s): Oracle RDBMS in-Memory Option, Dual-format Distributed in-Memory Database, Scale-out, in-Memory Compression Units (IMCUs), Automated Distribution, Distributed SQL Execution.

Related Ontology Subjects/Areas/Topics: Artificial Intelligence ; Business Analytics ; Cardiovascular Technologies ; Computing and Telecommunications in Cardiology ; Data Engineering ; Decision Support Systems ; Decision Support Systems, Remote Data Analysis ; Distributed and Mobile Software Systems ; Distributed Architectures ; Health Engineering and Technology Applications ; Knowledge-Based Systems ; Parallel and High Performance Computing ; Software Engineering ; Symbolic Systems

Abstract: The Oracle RDBMS In-memory Option (DBIM), introduced in 2014, is an industry-first distributed dual format in-memory RDBMS that allows a database object to be stored in columnar format purely in-memory, simultaneously maintaining transactional consistency with the corresponding row-major format persisted in storage and accessed through in-memory database buffer cache. The in-memory columnar format is highly optimized to break performance barriers in analytic query workloads while the row format is most suitable for OLTP workloads. In this paper, we present the distributed architecture of the Oracle Database In- memory Option that enables the in-memory RDBMS to transparently scale out across a set of Oracle database server instances in an Oracle RAC cluster, both in terms of memory capacity and query processing throughput. The architecture allows complete application-transparent, extremely scalable and automated in- memory distribution of Oracle RDBMS objects across multiple instances in a cluster. It seamlessly provides distribution awareness to the Oracle SQL execution framework, ensuring completely local memory scans through affinitized fault-tolerant parallel execution within and across servers without explicit optimizer plan changes or query rewrites. (More)

PDF ImageFull Text

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
Mukherjee, N.; Kulkarni, K.; Jin, H.; Kamp, J. and Lahiri, T. (2015). How does Oracle Database In-Memory Scale out?.In Proceedings of the 10th International Conference on Software Engineering and Applications - Volume 1: ICSOFT-EA, (ICSOFT 2015) ISBN 978-989-758-114-4, pages 39-44. DOI: 10.5220/0005497900390044

author={Niloy Mukherjee. and Kartik Kulkarni. and Hui Jin. and Jesse Kamp. and Tirthankar Lahiri.},
title={How does Oracle Database In-Memory Scale out?},
booktitle={Proceedings of the 10th International Conference on Software Engineering and Applications - Volume 1: ICSOFT-EA, (ICSOFT 2015)},


JO - Proceedings of the 10th International Conference on Software Engineering and Applications - Volume 1: ICSOFT-EA, (ICSOFT 2015)
TI - How does Oracle Database In-Memory Scale out?
SN - 978-989-758-114-4
AU - Mukherjee, N.
AU - Kulkarni, K.
AU - Jin, H.
AU - Kamp, J.
AU - Lahiri, T.
PY - 2015
SP - 39
EP - 44
DO - 10.5220/0005497900390044

Login or register to post comments.

Comments on this Paper: Be the first to review this paper.