Devel-op: An optimizer development environment

Recent advances in the underlying architectures of database management systems (DBMS) have motivated the redesign of key DBMS components such as the query optimizer. Optimizers are inherently difficult to build and maintain, and yet there exists no software engineering tools to facilitate their deve...

Full description

Saved in:
Bibliographic Details
Published in2014 IEEE 30th International Conference on Data Engineering pp. 1278 - 1281
Main Authors Zhibo Peng, Cherniack, Mitch, Papaemmanouil, Olga
Format Conference Proceeding
LanguageEnglish
Published IEEE 01.03.2014
Subjects
Computer architecture
Debugging
Generators
Grammar
Optimization
Query processing
Visualization
Online AccessGet full text

Cover

More Information
Summary:Recent advances in the underlying architectures of database management systems (DBMS) have motivated the redesign of key DBMS components such as the query optimizer. Optimizers are inherently difficult to build and maintain, and yet there exists no software engineering tools to facilitate their development. In this paper, we introduce a [Devel]opment Environment for Query [Op]timizers (Devel-Op) designed to facilitate the rapid prototyping, profiling and benchmarking of optimizers. Our current version of the tool permits declarative specification and generation of two key optimizer components (the logical plan enumerator and physical plan generator) as well as debugging and visualization tools for profiling generated components.
ISSN:1063-6382
2375-026X
DOI:10.1109/ICDE.2014.6816760