Filtering with Approximate Predicates

作者: Hector Garcia-Molina , Narayanan Shivakumar , Chandra Chekuri

DOI:

关键词: AlgorithmQuery optimizationComputer sciencePredicate (grammar)Theoretical computer sciencePoint (geometry)

摘要: Approximate predicates can be used to reduce the number of comparisons made by expensive, complex predicates. For example, check if a point is within region (expensive predicate) we first bounding rectangle (approximate In general, approximate may have false positive and negative errors. this paper study problem selecting structuring in order cost processing user query, while keeping errors user-specified bounds. We model different types their dependencies, derive expressions for compound predicates, develop query optimization strategies. also complexity our strategies under various scenarios, present an experimental case that illustrates potential gains achieved optimizing queries with

参考文章(27)
Yannis E. Ioannidis, Viswanath Poosala, Histogram-Based Solutions to Diverse Database Estimation Problems. IEEE Data(base) Engineering Bulletin. ,vol. 18, pp. 10- 18 ,(1995)
Surajit Chaudhuri, Kyuseok Shim, Query Optimization in the Presence of Foreign Functions very large data bases. pp. 529- 542 ,(1993)
Yannis Papakonstantinou, Vasilis Vassalos, Describing and Using Query Capabilities of Heterogeneous Sources very large data bases. pp. 256- 265 ,(1997)
Kyuseok Shim, Surajit Chaudhuri, Optimization of Queries with User-defined Predicates very large data bases. pp. 87- 98 ,(1996)
Hector Garcia-Molina, Narayanan Shivakumar, SCAM: A Copy Detection Mechanism for Digital Documents DL. ,(1995)
H. Garcia-Molina, W. Labio, R. Yerneni, Capability-sensitive query processing on Internet sources international conference on data engineering. pp. 50- 59 ,(1999) , 10.1109/ICDE.1999.754897
Gerard Salton, Christopher Buckley, Term Weighting Approaches in Automatic Text Retrieval Information Processing and Management. ,vol. 24, pp. 323- 328 ,(1988) , 10.1016/0306-4573(88)90021-0
Jeffrey D. Ullman, Principles of database and knowledge-base systems, Vol. I Computer Science Press, Inc.. ,vol. 14, ,(1988)
Surajit Chaudhuri, Phokion G. Kolaitis, Can Datalog be approximated? Proceedings of the thirteenth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems - PODS '94. pp. 86- 96 ,(1994) , 10.1145/182591.182602