Devel-op: An optimizer development environment

Author

Zhibo Peng ; Cherniack, Mitch ; Papaemmanouil, Olga

Author_Institution

Comput. Sci. Dept., Brandeis Univ., Waltham, MA, USA

fYear

2014

fDate

March 31 2014-April 4 2014

Firstpage

1278

Lastpage

1281

Abstract

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.

Keywords

data visualisation; database management systems; formal specification; program debugging; DBMS components; Devel-op; database management systems; debugging tools; declarative specification; logical plan enumerator; optimizer benchmarking; optimizer development environment; optimizer profiling; optimizer rapid prototyping; physical plan generator; query optimizer; visualization tools; Computer architecture; Debugging; Generators; Grammar; Optimization; Query processing; Visualization;

fLanguage

English

Publisher

ieee

Conference_Titel

Data Engineering (ICDE), 2014 IEEE 30th International Conference on

Conference_Location

Chicago, IL

Type

conf

DOI

10.1109/ICDE.2014.6816760

Filename

6816760