Implementing NOT EXISTS Predicates over a Probabilistic Database.
Ting-You Wang, Christopher Ré, Dan Mircea Suciu · 2008
Abstract. Systems for managing uncertain data need to support queries with negated subgoals, which are typically expressed in SQL through the NOT EXISTS predicate. For example, the user of an RFID tracking system may want to find all RFID tags (people or objects) that have traveled from a point A to a point C without going through a point D. Such queries are difficult to support in a probabilistic database management system, because offending tuples do not necessarily disqualify an answer, but only decrease its probability. In this paper, we present an approach for supporting queries with NOT EXISTS in a probabilistic database management system, by leveraging the existing query processing infrastructure. Our approach is to break up the query into multiple, monotone queries, which can be evaluated in the current system, then to combine their probabilities by addition and subtraction to compute that of the original query. We will also describe how this technique was integrated with MystiQ, and how we incorporated the top-k multi-simulation and safe-plans optimizations. 1