Repository logo

Infoscience

  • English
  • French
Log In
Logo EPFL, École polytechnique fédérale de Lausanne

Infoscience

  • English
  • French
Log In
  1. Home
  2. Academic and Research Output
  3. Journal articles
  4. Query Optimization in Oracle 12c Database In-Memory
 
research article

Query Optimization in Oracle 12c Database In-Memory

Das, Dinesh
•
Valluri, Ramachandra Satyanarayana  
•
Yan, Jiaqi
Show more
2015
Proceedings of the Vldb Endowment International Conference on Very Large Data Bases

Traditional on disk row major tables have been the dominant storage mechanism in relational databases for decades. Over the last decade, however, with explosive growth in data volume and demand for faster analytics, has come the recognition that a different data representation is needed. There is widespread agreement that in-memory column-oriented databases are best suited to meet the realities of this new world. Oracle 12c Database In-memory, the industry’s first dual-format database, allows existing row major on-disk tables to have complementary in-memory columnar representations. The new storage format brings new data processing techniques and query execution algorithms and thus new challenges for the query optimizer. Execution plans that are optimal for one format may be sub-optimal for the other. In this paper, we describe the changes made in the query optimizer to generate execution plans optimized for the specific format – row major or columnar – that will be scanned during query execution. With enhancements in several areas – statistics, cost model, query transformation, access pat h and join optimization, parallelism, and cluster - awareness – the query optimizer plays a significant role in unlocking the full promise and performance of Oracle Database In-Memory.

  • Details
  • Metrics
Type
research article
DOI
10.14778/2824032.2824074
Author(s)
Das, Dinesh
•
Valluri, Ramachandra Satyanarayana  
•
Yan, Jiaqi
•
Zaït, Mohamed
•
Vyas, Nirav
•
Krishnamachari, Ramarajan
•
Gaharwar, Prashant
•
Kamp, Jesse
•
Mukherjee, Niloy
Date Issued

2015

Published in
Proceedings of the Vldb Endowment International Conference on Very Large Data Bases
Volume

8

Issue

12

Start page

1770

End page

1781

Editorial or Peer reviewed

NON-REVIEWED

Written at

OTHER

EPFL units
IIF  
Available on Infoscience
August 24, 2015
Use this identifier to reference this record
https://infoscience.epfl.ch/handle/20.500.14299/117306
Logo EPFL, École polytechnique fédérale de Lausanne
  • Contact
  • infoscience@epfl.ch

  • Follow us on Facebook
  • Follow us on Instagram
  • Follow us on LinkedIn
  • Follow us on X
  • Follow us on Youtube
AccessibilityLegal noticePrivacy policyCookie settingsEnd User AgreementGet helpFeedback

Infoscience is a service managed and provided by the Library and IT Services of EPFL. © EPFL, tous droits réservés