Sciweavers

Share
SIGMOD
1992
ACM

Extensible/Rule Based Query Rewrite Optimization in Starburst

9 years 2 months ago
Extensible/Rule Based Query Rewrite Optimization in Starburst
This paper describes the Query Rewrite facility of the Starburst extensible database system, a novel phase of query optimization. We present a suite of rewrite rules used in Starburst to transform queries into equivalent queries for faster execution, and also describe the production rule engine which is used by Starburst to choose and execute these rules. Examples we provided demonstrating that these Query Rewrite transformations lead to query execution time improvements of orders of magnitude, suggesting that Query Rewrite in general -- and these rewrite rules in particular -- are an essential step in query optimization for modern database systems.
Hamid Pirahesh, Joseph M. Hellerstein, Waqar Hasan
Added 10 Aug 2010
Updated 10 Aug 2010
Type Conference
Year 1992
Where SIGMOD
Authors Hamid Pirahesh, Joseph M. Hellerstein, Waqar Hasan
Comments (0)
books