Optimizing Boolean Expressions in Object-Bases.
Alfons Kemper, Guido Moerkotte, Michael Steinbrunn:
Optimizing Boolean Expressions in Object-Bases.
VLDB 1992: 79-90@inproceedings{DBLP:conf/vldb/KemperMS92,
author = {Alfons Kemper and
Guido Moerkotte and
Michael Steinbrunn},
editor = {Li-Yan Yuan},
title = {Optimizing Boolean Expressions in Object-Bases},
booktitle = {18th International Conference on Very Large Data Bases, August
23-27, 1992, Vancouver, Canada, Proceedings},
publisher = {Morgan Kaufmann},
year = {1992},
isbn = {1-55860-151-1},
pages = {79-90},
ee = {db/conf/vldb/KemperMS92.html},
crossref = {DBLP:conf/vldb/92},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
Abstract
In this paper we address the problem of optimizing the evaluation of boolean expressions in the context of object-oriented data modelling.
We develop a new heuristic for optimizing the evaluation sequence of boolean expressions based on selectivity and cost estimates of the terms constituting theboolean expression.
The quality and efficiency of the heuristic is evaluated based on a quantitative analysis which compares our heuristic with the optimal, but infeasible algorithm and other known methods.
The heuristic is based on the selectivity and evaluation-cost estimates of the terms of which the boolean expression is composed.
Deriving these inputs of the heuristics, i.e., the selectivity and cost estimates, is then addressed.
We use an adaptation of well-known sampling for estimating the selectivity of terms.
The cost estimation is much more complex than in the relational context due to the possibility of invoking functions within a boolean expression.
We develop the decapsulation method that derives cost estimates by analysing the implementation of (encapsulated) functions.
Copyright © 1992 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 ...
Printed Edition
Li-Yan Yuan (Ed.):
18th International Conference on Very Large Data Bases, August 23-27, 1992, Vancouver, Canada, Proceedings.
Morgan Kaufmann 1992, ISBN 1-55860-151-1
Contents
References
- [ASU86]
- Alfred V. Aho, Ravi Sethi, Jeffrey D. Ullman:
Compilers: Princiles, Techniques, and Tools.
Addison-Wesley 1986, ISBN 0-201-10088-6
![bibliographical record in XML](../../xml.gif)
- [Chr83]
- Stavros Christodoulakis:
Estimating record selectivities.
Inf. Syst. 8(2): 105-115(1983)
![bibliographical record in XML](../../xml.gif)
- [Dem80]
- Robert Demolombe:
Estimation of the Number of Tuples Satisfying a Query Expressed in Predicate Calculus Language.
VLDB 1980: 55-63
![bibliographical record in XML](../../xml.gif)
- [Fed84]
- Jane Fedorowicz:
Database Evaluation Using Multiple Regression Techniques.
SIGMOD Conference 1984: 70-76
![bibliographical record in XML](../../xml.gif)
- [GM88]
- Goetz Graefe, David Maier:
Query Optimization in Object-Oriented Database Systems: A Prospectus.
OODBS 1988: 358-363
![bibliographical record in XML](../../xml.gif)
- [GR73]
- S. Ganapathy, V. Rajaraman:
Information Theory Applied to the Conversion of Decision Tables to Computer Programs.
Commun. ACM 16(9): 532-539(1973)
![bibliographical record in XML](../../xml.gif)
- [KK85]
- Nabil Kamel, Roger King:
A Model of Data Distribution Based on Texture Analysis.
SIGMOD Conference 1985: 319-325
![bibliographical record in XML](../../xml.gif)
- [KKM91]
- Alfons Kemper, Christoph Kilger, Guido Moerkotte:
Function Materialization in Object Bases.
SIGMOD Conference 1991: 258-267
![bibliographical record in XML](../../xml.gif)
- [KM90a]
- Alfons Kemper, Guido Moerkotte:
Access Support in Object Bases.
SIGMOD Conference 1990: 364-374
![bibliographical record in XML](../../xml.gif)
- [KM90b]
- Alfons Kemper, Guido Moerkotte:
Advanced Query Processing in Object Bases Using Access Support Relations.
VLDB 1990: 290-301
![bibliographical record in XML](../../xml.gif)
- [KMS92]
- ...
- [LD91]
- Daniel F. Lieuwen, David J. DeWitt:
Optimizing Loops in Database Programming Languages.
DBPL 1991: 287-305
![bibliographical record in XML](../../xml.gif)
- [LNS90]
- Richard J. Lipton, Jeffrey F. Naughton, Donovan A. Schneider:
Practical Selectivity Estimation through Adaptive Sampling.
SIGMOD Conference 1990: 1-11
![bibliographical record in XML](../../xml.gif)
- [Lyn88]
- Clifford A. Lynch:
Selectivity Estimation and Query Optimization in Large Databases with Highly Skewed Distribution of Column Values.
VLDB 1988: 240-251
![bibliographical record in XML](../../xml.gif)
- [MD88]
- M. Muralikrishna, David J. DeWitt:
Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries.
SIGMOD Conference 1988: 28-36
![bibliographical record in XML](../../xml.gif)
- [Pol65]
- ...
- [PSC84]
- Gregory Piatetsky-Shapiro, Charles Connell:
Accurate Estimation of the Number of Tuples Satisfying a Condition.
SIGMOD Conference 1984: 256-276
![bibliographical record in XML](../../xml.gif)
- [RS66]
- Lewis T. Reinwald, Richard M. Soland:
Conversion of Limited-Entry Decision Tables to Optimal Computer Programs I: Minimum Average Processing Time.
J. ACM 13(3): 339-358(1966)
![bibliographical record in XML](../../xml.gif)
- [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
![bibliographical record in XML](../../xml.gif)
- [Sch89]
- ...
Copyright © Tue Mar 16 02:22:02 2010
by Michael Ley (ley@uni-trier.de)