Abstract

There has been extensive work in query optimization since the early ‘70s. It is hard to capture the breadth and depth of this large body of work in a short article. Therefore, I have decided to focus primarily on the optimization of SQL queries in relational database systems and present my biased and incomplete view of this field. The goal of this article is not to be comprehensive, but rather to explain the foundations and present samplings of significant work in this area. I would like to apologize to the many contributors in this area whose work I have failed to explicitly acknowledge due to oversight or lack of space. I take the liberty of trading technical precision for ease of presentation. 2.

Citations

630	Data cube: A relational aggregation operator generalizing group-by, cross-tab, and sub-totals - Gray, Bosworth, et al. - 1996
592	Query evaluation techniques for large databases - Graefe - 1993
296	Combining fuzzy information from multiple systems - Fagin - 1999
234	An overview of data warehousing and olap technology - Chaudhuri, Dayal - 1997
217	Optimizing queries with materialized views - Chaudhuri, Krishnamurthy, et al. - 1995
211	Improved histograms for selectivity estimation of range predicates - Poosala, Ioannidis, et al. - 1996
193	Understanding the New SQL: A Complete Guide - Melton, Simon - 1993
181	Ioannidis: Selectivity Estimation Without the Attribute Value Independence Assumption - Poosala, E - 1997
173	Equi-depth histograms for estimating selectivity factors for multi-dimensional queries - Muralikrishna, DeWitt - 1988
157	The volcano optimizer generator: Extensibility and efficient search - Graefe, McKenna - 1993
153	The EXODUS Optimizer Generator - Graefe, DeWitt - 1987
143	Fast Incremental Maintenance of Approximate Histograms - Gibbons, Matias, et al. - 1997
135	Predicate migration: optimizing queries with expensive predicates - Hellerstein, Stonebraker - 1993
134	Accurate estimation of the number of tuples satisfying a condition - Piatetsky-Shapiro, Connell - 1984
132	On optimizing an SQL-like nested query - Kim - 1982
128	Dynamic Query Evaluation Plans - Graefe, Ward
103	Grammar-like functional rules for representing query optimization alternatives - Lohman - 1988
102	Query optimization - Ioannidis - 2004
101	Including group-by in query optimization - Chaudhuri, Shim - 1994
101	Extensible/Rule Based Query Rewrite Optimization in Starburst - Pirahesh, Hellerstein, et al. - 1992
97	Sampling-based estimation of the number of distinct values of an attribute - Haas, Naughton, et al. - 1995
96	Of nests and trees: A unified approach to processing queries that contain nested subqueries, aggregates, and quantifiers - Dayal - 1987
91	Random sampling for histogram construction: how much is enough - Chaudhuri, Motwani, et al. - 1998
91	Query transformation for PSJ-queries - Yang, Larson - 1987
83	Extensible Query Processing in Starburst - Haas, Freytag, et al. - 1989
80	Universality of serial histograms - Ioannidis - 1993
79	G.M.: R* Optimizer Validation and Performance Evaluation for Distributed Queries - Mackert, Lohman - 1986
78	Measuring the complexity of join enumeration in query optimization - Ono, Lohman - 1990
74	Optimizing Queries over Multimedia Repositories - Chaudhuri, Gravano - 1996
73	Optimization of queries with user-defined predicates - Chaudhuri, Shim - 1999
71	Optimization of parallel query execution plans in xprs - Hong, Stonebraker - 1993
68	Optimization of Nested SQL Queries Revisited - Ganski, Long - 1987
67	The cascades framework for query optimization - Graefe - 1995
59	Eager aggregation and lazy aggregation - Yan, Larson - 1995
55	Optimization Algorithms for Distributed Queries - Apers, Hevner, et al. - 1983
55	expression analysis in database applications - Finkelstein, “Common - 1982
51	Fundamental techniques for order optimization - Simmen, Shekita, et al. - 1996
43	Improved unnesting algorithms for join aggregate SQL queries. VLDB - Muralikrishna - 1992
42	Query optimization by predicate move-around - Levy, Mumick, et al. - 1994
39	R ∗ optimizer validation and performance evaluation for local queries - Mackert, Lohman - 1986
34	Magic is relevant - Mumick, Finkelstein, et al. - 1990
29	Towards an open architecture for LDL - Chimenti, Gamboa, et al. - 1989
26	Complex query processing in multiprocessor database machines - Schneider - 1990
19	An Overview of Cost-based Optimization of Queries with Aggregates - Chaudhuri, Shim - 1995
18	Optimization of SQL queries for parallel machines - Hasan - 1996
16	Parallel Query Processing Using Shared Memory Multiprocessors and Disk Arrays - Hong - 1992
13	Implementation of Magic-sets in a Relational Database System - Mumick, Pirahesh - 1994
7	Improved Histograms for Selectivity Estimation - Poosala, Ioannidis, et al. - 1996
6	Harinarayan V., Quass D. Aggregate-query processing in data warehousing environments - Gupta - 1995
5	Magic sets and other strange ways to execute logic programs - Bancilhon, Maier, et al. - 1986