Filtering with Approximate Predicates

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, while keeping 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.

• Type: Conference
• Year: 1998
• Where: VLDB
• Authors: Narayanan Shivakumar, Hector Garcia-Molina, Chandra Chekuri
• Keywords: Approximate Predicates, Complex Predicates, Compound Predicates, Database, VLDB 1998