Query Optimization by Simulated Annealing.
Yannis E. Ioannidis, Eugene Wong:
Query Optimization by Simulated Annealing.
SIGMOD Conference 1987: 9-22@inproceedings{DBLP:conf/sigmod/Ioannidis87,
author = {Yannis E. Ioannidis and
Eugene Wong},
editor = {Umeshwar Dayal and
Irving L. Traiger},
title = {Query Optimization by Simulated Annealing},
booktitle = {Proceedings of the Association for Computing Machinery Special
Interest Group on Management of Data 1987 Annual Conference,
San Francisco, California, May 27-29, 1987},
publisher = {ACM Press},
year = {1987},
pages = {9-22},
ee = {http://doi.acm.org/10.1145/38713.38722, db/conf/sigmod/Ioannidis87.html},
crossref = {DBLP:conf/sigmod/87},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
Abstract
Query optimizers of future database management systems
are likely to face large access plan spaces in their
task. Exhaustively searching such access plan spaces is
unacceptable. We propose a query optimization algorithm based on simulated annealing, which is a probalistic hill climbing algorithm. We show the specific
formulation of the algorithm for the case of optimizing complex non-recursive queries that arise in the study of linear recursion. The query answer is explicitly
represented and maniputated within the closed semiring
of linear relational operators. The optimization algorithm is applied to a state space that is constructed from the equivalent algebraic forms of the query answer. A prototype of the simulated annealing algorithm has been built and few experiments have been performed for a
limited class of relational operators. Our initial experiment is that, in general, the algorithm converges to processing strategies that are very close to the optimal. Moreover, the traditional processing strategies (e. g., the semi-naive evaluation) have been found to be, in general, suboptimal.
Copyright © 1987 by the ACM,
Inc., used by permission. Permission to make
digital or hard copies is granted provided that
copies are not made or distributed for profit or
direct commercial advantage, and that copies show
this notice on the first page or initial screen of
a display along with the full citation.
Online Version (ACM WWW Account required): Full Text in PDF Format
CDROM Version: Load the CDROM "Volume 1 Issue 2, SIGMOD '75-'92" and ...
DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...
Printed Edition
Umeshwar Dayal, Irving L. Traiger (Eds.):
Proceedings of the Association for Computing Machinery Special Interest Group on Management of Data 1987 Annual Conference, San Francisco, California, May 27-29, 1987.
ACM Press 1987
,
SIGMOD Record 16(3)
Contents
References
- [Ackl85]
- ...
- [Aho79]
- Alfred V. Aho, Yehoshua Sagiv, Jeffrey D. Ullman:
Equivalences Among Relational Expressions.
SIAM J. Comput. 8(2): 218-246(1979)

- [Aho84]
- Alfred V. Aho, John E. Hopcroft, Jeffrey D. Ullman:
The Design and Analysis of Computer Algorithms.
Addison-Wesley 1974, ISBN 0-201-00029-6

- [Arag84]
- ...
- [Astr76]
- Morton M. Astrahan, Mike W. Blasgen, Donald D. Chamberlin, Kapali P. Eswaran, Jim Gray, Patricia P. Griffiths, W. Frank King III, Raymond A. Lorie, Paul R. McJones, James W. Mehl, Gianfranco R. Putzolu, Irving L. Traiger, Bradford W. Wade, Vera Watson:
System R: Relational Approach to Database Management.
ACM Trans. Database Syst. 1(2): 97-137(1976)

- [Banc85]
- ...
- [Banc86a]
- François Bancilhon, David Maier, Yehoshua Sagiv, Jeffrey D. Ullman:
Magic Sets and Other Strange Ways to Implement Logic Programs.
PODS 1986: 1-15

- [Banc86b]
- François Bancilhon, Raghu Ramakrishnan:
An Amateur's Introduction to Recursive Query Processing Strategies.
SIGMOD Conference 1986: 16-52

- [Banc86c]
- ...
- [Bern81]
- Philip A. Bernstein, Nathan Goodman, Eugene Wong, Christopher L. Reeve, James B. Rothnie Jr.:
Query Processing in a System for Distributed Databases (SDD-1).
ACM Trans. Database Syst. 6(4): 602-625(1981)

- [Blas76]
- ...
- [Codd70]
- E. F. Codd:
A Relational Model of Data for Large Shared Data Banks.
Commun. ACM 13(6): 377-387(1970)

- [Epst78]
- Robert S. Epstein, Michael Stonebraker, Eugene Wong:
Distributed Query Processing in a Relational Data Base System.
SIGMOD Conference 1978: 169-180

- [Gall78]
- ...
- [Gall84]
- Hervé Gallaire, Jack Minker, Jean-Marie Nicolas:
Logic and Databases: A Deductive Approach.
ACM Comput. Surv. 16(2): 153-185(1984)

- [Gran81]
- John Grant, Jack Minker:
Optimization in Deductive and Conventional Relational Database Systems.
Advances in Data Base Theory 1979: 195-234

- [Haje85]
- ...
- [Ioan86a]
- Yannis E. Ioannidis:
On the Computation of the Transitive Closure of Relational Operators.
VLDB 1986: 403-411

- [Ioan86b]
- Yannis E. Ioannidis, Eugene Wong:
An Algebraic Approach to Recursive Inference.
Expert Database Conf. 1986: 295-309

- [Ioan86c]
- Yannis E. Ioannidis:
A Time Bound on the Materialization of Some Recursively Defined Views.
Algorithmica 1(3): 361-385(1986)

- [Jark84]
- Matthias Jarke, Jürgen Koch:
Query Optimization in Database Systems.
ACM Comput. Surv. 16(2): 111-152(1984)

- [Kers86a]
- ...
- [Kers86b]
- ...
- [Kim86]
- ...
- [Kirk83]
- ...
- [Kooi80]
- Robert Kooi:
The Optimization of Queries in Relational Databases.
Ph.D. thesis, Case Western Reserve University 1980

- [Kris86]
- Ravi Krishnamurthy, Haran Boral, Carlo Zaniolo:
Optimization of Nonrecursive Queries.
VLDB 1986: 128-137

- [Mack86a]
- Lothar F. Mackert, Guy M. Lohman:
R* Optimizer Validation and Performance Evaluation for Distributed Queries.
VLDB 1986: 149-159

- [Mack86b]
- Lothar F. Mackert, Guy M. Lohman:
R* Optimizer Validation and Performance Evaluation for Local Queries.
SIGMOD Conference 1986: 84-95

- [Mitr85]
- ...
- [Naug86]
- ...
- [Rich83]
- ...
- [Rome84]
- ...
- [Rome85]
- ...
- [Rose80]
- Daniel J. Rosenkrantz, Harry B. Hunt III:
Processing Conjunctive Predicates and Queries.
VLDB 1980: 64-72

- [Sacc86]
- Domenico Saccà, Carlo Zaniolo:
The Generalized Counting Method for Recursive Logic Queries.
ICDT 1986: 31-53

- [Sagi86]
- ...
- [Sech86a]
- ...
- [Sech86b]
- ...
- [Seli79]
- Patricia G. Selinger, Morton M. Astrahan, Donald D. Chamberlin, Raymond A. Lorie, Thomas G. Price:
Access Path Selection in a Relational Database Management System.
SIGMOD Conference 1979: 23-34

- [Sell86]
- Timos K. Sellis:
Global Query Optimization.
SIGMOD Conference 1986: 191-205

- [Ston76]
- Michael Stonebraker, Eugene Wong, Peter Kreps, Gerald Held:
The Design and Implementation of INGRES.
ACM Trans. Database Syst. 1(3): 189-222(1976)

- [Vald86]
- Patrick Valduriez, Haran Boral:
Evaluation of Recursive Queries Using Join Indices.
Expert Database Conf. 1986: 271-293

- [Wile83]
- ...
- [Wong76]
- Eugene Wong, Karel Youssefi:
Decomposition - A Strategy for Query Processing.
ACM Trans. Database Syst. 1(3): 223-241(1976)

Copyright © Fri Dec 18 18:42:28 2009
by Michael Ley (ley@uni-trier.de)