Filtering with Approximate Predicates.
Narayanan Shivakumar, Hector Garcia-Molina, Chandra Chekuri:
Filtering with Approximate Predicates.
VLDB 1998: 263-274@inproceedings{DBLP:conf/vldb/ShivakumarGC98,
author = {Narayanan Shivakumar and
Hector Garcia-Molina and
Chandra Chekuri},
editor = {Ashish Gupta and
Oded Shmueli and
Jennifer Widom},
title = {Filtering with Approximate Predicates},
booktitle = {VLDB'98, Proceedings of 24rd International Conference on Very
Large Data Bases, August 24-27, 1998, New York City, New York,
USA},
publisher = {Morgan Kaufmann},
year = {1998},
isbn = {1-55860-566-5},
pages = {263-274},
ee = {db/conf/vldb/ShivakumarGC98.html},
crossref = {DBLP:conf/vldb/98},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX
Abstract
Approximate predicates can be used to reduce the number of comparisons made by expensive, complex predicates.
For example, to check if a point is within a region (expensive predicate) we can first check if the point is within a bounding rectangle (approximate predicate).
In general, approximate predicates may have false positive and false negative errors.
In this paper we study the problem of selecting and structuring approximate predicates in order to reduce the cost of processing a user query, whilekeeping errors within user-specified bounds.
We model different types of approximate predicates and their dependencies,we derive expressions for the errors of compound predicates, and we develop query optimization strategies.
We also study the complexity of our optimization strategies under various scenarios, and we present an experimental case study that illustrates the potential gains achieved by optimizing queries with approximate predicates.
Copyright © 1998 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 "DiSC, Volume 1 Number 1" and ...
DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...
BibTeX
Printed Edition
Ashish Gupta, Oded Shmueli, Jennifer Widom (Eds.):
VLDB'98, Proceedings of 24rd International Conference on Very Large Data Bases, August 24-27, 1998, New York City, New York, USA.
Morgan Kaufmann 1998, ISBN 1-55860-566-5
Contents BibTeX
References
- [Aro96]
- ...
- [CGK89]
- Danette Chimenti, Ruben Gamboa, Ravi Krishnamurthy:
Towards on Open Architecture for LDL.
VLDB 1989: 195-203 BibTeX
- [CGMP96]
- Kevin Chen-Chuan Chang, Hector Garcia-Molina, Andreas Paepcke:
Boolean Query Mapping Across Heterogeneous Information Sources.
IEEE Trans. Knowl. Data Eng. 8(4): 515-521(1996) BibTeX
- [CK94]
- Surajit Chaudhuri, Phokion G. Kolaitis:
Can Datalog be Approximated?
PODS 1994: 86-96 BibTeX
- [CS93]
- Surajit Chaudhuri, Kyuseok Shim:
Query Optimization in the Presence of Foreign Functions.
VLDB 1993: 529-542 BibTeX
- [CS96]
- Surajit Chaudhuri, Kyuseok Shim:
Optimization of Queries with User-defined Predicates.
VLDB 1996: 87-98 BibTeX
- [CS97]
- ...
- [ea95]
- Myron Flickner, Harpreet S. Sawhney, Jonathan Ashley, Qian Huang, Byron Dom, Monika Gorkani, Jim Hafner, Denis Lee, Dragutin Petkovic, David Steele, Peter Yanker:
Query by Image and Video Content: The QBIC System.
IEEE Computer 28(9): 23-32(1995) BibTeX
- [GJ79]
- M. R. Garey, David S. Johnson:
Computers and Intractability: A Guide to the Theory of NP-Completeness.
W. H. Freeman 1979, ISBN 0-7167-1044-7
BibTeX
- [HNSS96]
- Peter J. Haas, Jeffrey F. Naughton, S. Seshadri, Arun N. Swami:
Selectivity and Cost Estimation for Joins Based on Random Sampling.
J. Comput. Syst. Sci. 52(3): 550-569(1996) BibTeX
- [HS93]
- Joseph M. Hellerstein, Michael Stonebraker:
Predicate Migration: Optimizing Queries with Expensive Predicates.
SIGMOD Conference 1993: 267-276 BibTeX
- [IM97]
- ...
- [LYGM98]
- ...
- [ME97]
- Alvaro E. Monge, Charles Elkan:
An Efficient Domain-Independent Algorithm for Detecting Approximately Duplicate Database Records.
DMKD 1997: 0- BibTeX
- [PD96]
- Jignesh M. Patel, David J. DeWitt:
Partition Based Spatial-Merge Join.
SIGMOD Conference 1996: 259-270 BibTeX
- [Ros96]
- ...
- [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
- [SB88]
- Gerard Salton, Chris Buckley:
Term-Weighting Approaches in Automatic Text Retrieval.
Inf. Process. Manage. 24(5): 513-523(1988) BibTeX
- [Sea96]
- Praveen Seshadri, Joseph M. Hellerstein, Hamid Pirahesh, T. Y. Cliff Leung, Raghu Ramakrishnan, Divesh Srivastava, Peter J. Stuckey, S. Sudarshan:
Cost-Based Optimization for Magic: Algebra and Implementation.
SIGMOD Conference 1996: 435-446 BibTeX
- [SGM95]
- Narayanan Shivakumar, Hector Garcia-Molina:
SCAM: A Copy Detection Mechanism for Digital Documents.
DL 1995: 0- BibTeX
- [SGM96]
- Narayanan Shivakumar, Hector Garcia-Molina:
Building a Scalable and Accurate Copy Detection Mechanism.
Digital Libraries 1996: 160-168 BibTeX
- [SGMC98]
- ...
- [Ull88]
- Jeffrey D. Ullman:
Principles of Database and Knowledge-Base Systems, Volume I.
Computer Science Press 1988, ISBN 0-7167-8158-1
Contents BibTeX
- [Vas98]
- ...
- [VP97]
- Vasilis Vassalos, Yannis Papakonstantinou:
Describing and Using Query Capabilities of Heterogeneous Sources.
VLDB 1997: 256-265 BibTeX
- [YI95]
- Yannis E. Ioannidis, Viswanath Poosala:
Histogram-Based Solutions to Diverse Database Estimation Problems.
IEEE Data Eng. Bull. 18(3): 10-18(1995) BibTeX
Referenced by
- Jihad Boulos, Kinji Ono:
Cost Estimation of User-Defined Methods in Object-Relational Database Systems.
SIGMOD Record 28(3): 22-28(1999)
- Weidong Chen, Jyh-Herng Chow, You-Chin Fuh, Jean Grandbois, Michelle Jou, Nelson Mendonça Mattos, Brian T. Tran, Yun Wang:
High Level Indexing of User-Defined Types.
VLDB 1999: 554-564
- Hector Garcia-Molina, Steven P. Ketchpel, Narayanan Shivakumar:
Safeguarding and Charging for Information on the Internet.
ICDE 1998: 182-189
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:21 2009