CHICAGO: A Test and Evaluation Environment for Coarse-Grained Optimization

Relational OLAP tools and other database applications generate sequences of SQL statements that are sent to the database server as result of a single information request issued by a user. Coarse-Grained Optimization is a practical approach for the optimization of such statement sequences based on rewrite rules. In this demonstration we present the CHICAGO test and evaluation environment that allows to assess the effectiveness of rewrite rules and control strategies. It includes a lightweight heuristic optimizer that modifies a given statement sequence using a small and variable set of rewrite rules.

• Type: Conference
• Year: 2004
• Where: VLDB
• Authors: Tobias Kraft, Holger Schwarz
• Keywords: Applications Generate Sequences, Database, Rewrite Rules, Statement Sequence, VLDB 2004