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