How does Oracle Database In-Memory Scale out?

Niloy Mukherjee, Kartik Kulkarni, Hui Jin, Jesse Kamp, Tirthankar Lahiri

2015

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.

References

  1. Oracle Database In-Memory, an Oracle White Paper, Oracle Openworld, 2014.
  2. Lahiri, T. et. al. Oracle Database In-Memory: A Dual Format In-Memory Database. Proceedings of the ICDE (2015).
  3. W. Bridge, A. Joshi, M. Keihl, T. Lahiri, J. Loaiza, and N. MacNaughton, "The Oracle Universal Server Buffer Manager", in Proceedings of VLDB 7897, pp. 590-594, 1997.
  4. Oracle12c Concepts Release 1 (12.0.1). Oracle. Corporation (2013).
  5. Parallel Execution with Oracle 12c Fundamentals, An Oracle White Paper, Oracle Openworld, 2014.
  6. Laprie, J. C. (1985). "Dependable Computing and Fault Tolerance: Concepts and Terminology", Proceedings of 15th International Symposium on Fault-Tolerant Computing (FTSC-15), pp. 2-11.
  7. R. Greenwal, M. Bhuller, R. Stackowiak, and M. Alam, Achieving extreme performance with Oracle Exadata, McGraw-Hill, 2011.
Download


Paper Citation


in Harvard Style

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


in Bibtex Style

@conference{icsoft-ea15,
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)},
year={2015},
pages={39-44},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0005497900390044},
isbn={978-989-758-114-4},
}


in EndNote Style

TY - CONF
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