The Fittest Survives: An Adaptive Approach to Query Optimization.
Hongjun Lu, Kian-Lee Tan, Son Dao:
The Fittest Survives: An Adaptive Approach to Query Optimization.
VLDB 1995: 251-262@inproceedings{DBLP:conf/vldb/LuTD95,
author = {Hongjun Lu and
Kian-Lee Tan and
Son Dao},
editor = {Umeshwar Dayal and
Peter M. D. Gray and
Shojiro Nishio},
title = {The Fittest Survives: An Adaptive Approach to Query Optimization},
booktitle = {VLDB'95, Proceedings of 21th International Conference on Very
Large Data Bases, September 11-15, 1995, Zurich, Switzerland},
publisher = {Morgan Kaufmann},
year = {1995},
isbn = {1-55860-379-4},
pages = {251-262},
ee = {db/conf/vldb/LuTD95.html},
crossref = {DBLP:conf/vldb/95},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX
Abstract
Traditionally, optimizers are "programmed" to optimize queries following aset of build- in procedures.
However, optimizers should be robust to its changing environment to generate the fittest query execution plans.
To realize adaptiveness, we propose and design an adaptive optimizer with two features.
First, the search space and search strategy of the optimizer can be tuned by parameters to allow the optimizer to pick the one that fits best duringthe optimization process.
Second, the optimizer features a "learning" capability for canned queries that allows existing plans to be incrementally replaced by "fitter" ones.
An experimental study on large multi- join queries based on an analytical model is used to demonstrate the effectiveness of such an approach.
Copyright © 1995 by the VLDB Endowment.
Permission to copy without fee all or part of this material is granted provided that the copies are not made or
distributed for direct commercial advantage, the VLDB
copyright notice and the title of the publication and
its date appear, and notice is given that copying
is by the permission of the Very Large Data Base
Endowment. To copy otherwise, or to republish, requires
a fee and/or special permission from the Endowment.
Online Paper
CDROM Version: Load the CDROM "Volume 1 Issue 5, VLDB '89-'97" and ...
DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...
BibTeX
Printed Edition
Umeshwar Dayal, Peter M. D. Gray, Shojiro Nishio (Eds.):
VLDB'95, Proceedings of 21th International Conference on Very Large Data Bases, September 11-15, 1995, Zurich, Switzerland.
Morgan Kaufmann 1995, ISBN 1-55860-379-4
Contents BibTeX
References
- [CG94]
- Richard L. Cole, Goetz Graefe:
Optimization of Dynamic Query Evaluation Plans.
SIGMOD Conference 1994: 150-160 BibTeX
- [DKO+84]
- David J. DeWitt, Randy H. Katz, Frank Olken, Leonard D. Shapiro, Michael Stonebraker, David A. Wood:
Implementation Techniques for Main Memory Database Systems.
SIGMOD Conference 1984: 1-8 BibTeX
- [GD87]
- Goetz Graefe, David J. DeWitt:
The EXODUS Optimizer Generator.
SIGMOD Conference 1987: 160-172 BibTeX
- [IK90]
- Yannis E. Ioannidis, Younkyung Cha Kang:
Randomized Algorithms for Optimizing Large Join Queries.
SIGMOD Conference 1990: 312-321 BibTeX
- [IK91]
- Yannis E. Ioannidis, Younkyung Cha Kang:
Left-Deep vs. Bushy Trees: An Analysis of Strategy Spaces and its Implications for Query Optimization.
SIGMOD Conference 1991: 168-177 BibTeX
- [IN92]
- Yannis E. Ioannidis, Raymond T. Ng, Kyuseok Shim, Timos K. Sellis:
Parametric Query Optimization.
VLDB 1992: 103-114 BibTeX
- [Koo80]
- Robert Kooi:
The Optimization of Queries in Relational Databases.
Ph.D. thesis, Case Western Reserve University 1980
BibTeX
- [LV91]
- Rosana S. G. Lanzelotte, Patrick Valduriez:
Extending the Search Strategy in a Query Optimizer.
VLDB 1991: 363-373 BibTeX
- [OL90]
- Kiyoshi Ono, Guy M. Lohman:
Measuring the Complexity of Join Enumeration in Query Optimization.
VLDB 1990: 314-325 BibTeX
- [RR82]
- Arnon Rosenthal, David S. Reiner:
An Architecture for Query Optimization.
SIGMOD Conference 1982: 246-255 BibTeX
- [SAC+79]
- 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 BibTeX
- [SD90]
- Donovan A. Schneider, David J. DeWitt:
Tradeoffs in Processing Complex Join Queries via Hashing in Multiprocessor Database Machines.
VLDB 1990: 469-480 BibTeX
- [SG88]
- Arun N. Swami, Anoop Gupta:
Optimization of Large Join Queries.
SIGMOD Conference 1988: 8-17 BibTeX
- [Sha86]
- Leonard D. Shapiro:
Join Processing in Database Systems with Large Main Memories.
ACM Trans. Database Syst. 11(3): 239-264(1986) BibTeX
- [SYT93]
- Eugene J. Shekita, Honesty C. Young, Kian-Lee Tan:
Multi-Join Optimization for Symmetric Multiprocessors.
VLDB 1993: 479-492 BibTeX
- [TL91]
- Kian-Lee Tan, Hongjun Lu:
A Note on the Strategy Space of Multiway Join Query Optimization Problem in Parallel Systems.
SIGMOD Record 20(4): 81-82(1991) BibTeX
Referenced by
- Lionel Brunie, Harald Kosch:
ModParOpt: A Modular Query Optimizer for Multi-Query Parallel Databases.
ADBIS 1997: 97-106
BibTeX
ACM SIGMOD Anthology - DBLP:
[Home | Search: Author, Title | Conferences | Journals]
VLDB Proceedings: Copyright © by VLDB Endowment,
ACM SIGMOD Anthology: Copyright © by ACM (info@acm.org), Corrections: anthology@acm.org
DBLP: Copyright © by Michael Ley (ley@uni-trier.de), last change: Sat May 16 23:46:05 2009