Micro-specialization in DBMSes

Research output: Chapter in Book/Report/Conference proceedingConference contribution

10 Scopus citations

Abstract

Relational database management systems are general in the sense that they can handle arbitrary schemas, queries, and modifications, this generality is implemented using runtime metadata lookups and tests that ensure that control is channelled to the appropriate code in all cases. Unfortunately, these lookups and tests are carried out even when information is available that renders some of these operations superfluous, leading to unnecessary runtime overheads. This paper introduces micro-specialization, an approach that uses relation- and query-specific information to specialize the DBMS code at runtime and thereby eliminate some of these overheads. We develop a taxonomy of approaches and specialization times and propose a general architecture that isolates most of the creation and execution of the specialized code sequences in a separate DBMS-independent module. Through three illustrative types of micro-specializations applied to Postgre SQL, we show that this approach requires minimal changes to a DBMS and can improve the performance simultaneously across a wide range of queries, modifications, and bulk-loading, in terms of storage, CPU usage, and I/O time of the TPC-H and TPC-C benchmarks.

Original languageEnglish (US)
Title of host publicationProceedings - International Conference on Data Engineering
Pages690-701
Number of pages12
DOIs
Publication statusPublished - 2012
EventIEEE 28th International Conference on Data Engineering, ICDE 2012 - Arlington, VA, United States
Duration: Apr 1 2012Apr 5 2012

Other

OtherIEEE 28th International Conference on Data Engineering, ICDE 2012
CountryUnited States
CityArlington, VA
Period4/1/124/5/12

    Fingerprint

ASJC Scopus subject areas

  • Information Systems
  • Signal Processing
  • Software

Cite this

Zhang, R., Snodgrass, R. T., & Debray, S. K. (2012). Micro-specialization in DBMSes. In Proceedings - International Conference on Data Engineering (pp. 690-701). [6228125] https://doi.org/10.1109/ICDE.2012.110