Abstract

Imagine yourself standing in front of an exquisite buffet filled with numerous delicacies. Your goal is to try them all out, but you need to decide in what order. What exchange of tastes will maximize the overall pleasure of your palate? Although much less pleasurable and subjective, that is the type of problem that query optimizers are called to solve. Given a query, there are many plans that a database management system (DBMS) can follow to process it and produce its answer. All plans are equivalent in terms of their final output but vary in their cost, i.e., the amount of time that they need to run. What is the plan that needs the least amount of time? Such query optimization is absolutely necessary in a DBMS. The cost difference between two alternatives can be enormous. For example, consider the following database schema, which will be...

Citations

6921	Genetic Algorithms - Goldberg - 1989
3316	Optimization by Simulated Annealing - Kirkpatrick, Gelatt, et al. - 1983
461	Access path selection in a relational database management system - SELINGER, ASTRAHAN, et al. - 1979
202	Query optimization in database systems - JARKE, KOCH - 1984
177	Equidepth histograms for estimating selectivity factors for multi-dimensional queries - MURALIKRISHNA, DEWIIT - 1988
163	The volcano optimizer generator: Extensibility and efficient search - Graefe, McKenna - 1993
156	The EXODUS Optimizer Generator - Graefe, DeWitt - 1987
151	Randomized Algorithms for Optimizing Large Join Queries - IOANNIDIS, KANG
148	Practical Selectivity Estimation through Adaptive Sampling - Lipton, Naughton - 1990
139	Accurate Estimation of the Number of Tuples Satisfying a Condition - Piatetsky-Shapiro, Connell - 1984
136	Dynamic Query Evaluation Plans - Graefe, Ward, et al. - 1989
131	Balancing Histogram Optimality and Practicality for Query Set Size Estimation - Ioannidis, Poosala - 1995
117	Optimization of Non-Recursive Queries - Krishnamurthy, Boral, et al. - 1986
115	On the Propagation of Errors in the Size of Join Results - Ioannidis, Christodoulakis
103	Grammar-like functional rules for representing query optimization alternatives - Lohman - 1988
101	Multiple query optimization - SELLIS - 1988
95	Optimization of Large Join Queries - Swami, Gupta
88	Tradeoffs in Processing Complex Join Queries via Hashing - Schneider, DeWitt - 1990
84	Sequential Sampling Procedures for Query Size Estimation - Haas, Swami - 1992
84	Query optimization by simulated annealing - Ioannidis, Wong
83	R* optimizer validation and performance evaluation for distributed queries - Mackert, Lohman - 1986
80	Universality of serial histograms - Ioannidis - 1993
79	Measuring the Complexity of Join Enumeration in Query Optimization - Ono, Lohman - 1990
78	Optimization of Large Join Queries: Combining Heuristics and Combinatorial Approach - Swami - 1989
76	The optimization of queries in relational databases - KOOI - 1980
75	Optimization of parallel query execution plans in xprs - Hong, Stonebraker - 1991
72	Implications of certain assumptions in database performance evaluation - CHRISTODOULAKIS - 1984
71	Statistical profile estimation in database systems - Mannino, Chu, et al. - 1988
68	Query Processing in a System for Distributed Databases - Bernstein, Goodman, et al. - 1981
67	Quist: A system for semantic query optimization in relational databases - King - 1981
63	The Design of XPRS - Kalz, Patterson, et al. - 1988
56	On the effectiveness of optimization search strategies for parallel execution spaces - Lanzelotte, Valduriez, et al. - 1993
53	Optimal histograms for limiting worst-case error propagation in the size of join results - Ioannidis, Christodoulakis - 1993
51	On the Optimal Nesting Order for Computing N-Relational Joins - Ibaraki, Kameda - 1984
51	Simple random sampling from relational databases - Olken, Rotem - 1986
39	Simulated annealing and combinatorial optimization - Nahar, Sahni, et al. - 1989
36	Dynamic Query Optimization in Rdb/VMS - Antoshenkov - 1993
35	Multi-Join Optimization for Symmetric Multiprocessors - Shekita, Tan, et al. - 1993
30	A Polynomial Time Algorithm for Optimizing Join Queries - Swami, Iyer - 1992
23	Integration of Buffer Management and Query Optimization in Relational Database Environment - Cornell, Yu - 1989
22	A genetic algorithm for database query optimization - Bennett, Ferris, et al. - 1991
22	randomized joinorder selection - why use transformations - Fast - 1994
21	Query rewrite optimization in starburst - Hasan, Pirahesh - 1988
19	Astrahan et.al. System R: Relational Approach to Database Management - M - 1976
19	Randomized algorithms for query optimization - Kang - 1991
16	Sampling-based selectivity estimation for joins using augmented frequent value statistics - Haas, Swami - 1995
11	Optimization by Simulated Annealing. Science 220(4598):671–680 - Kirkpatrick, Jr, et al. - 1983
8	The Volcano optimizer generator: Extensibility and e cient search - Graefe, McKenna - 1993
8	et al. Starburst mid ight: As the dust clears - Haas - 1990
8	Statistical pro le estimation in database systems - Mannino, Chu, et al. - 1988