Title :
Devel-op: An optimizer development environment
Author :
Zhibo Peng ; Cherniack, Mitch ; Papaemmanouil, Olga
Author_Institution :
Comput. Sci. Dept., Brandeis Univ., Waltham, MA, USA
fDate :
March 31 2014-April 4 2014
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;
Conference_Titel :
Data Engineering (ICDE), 2014 IEEE 30th International Conference on
Conference_Location :
Chicago, IL
DOI :
10.1109/ICDE.2014.6816760
