title: Exploiting Lineage for Confidence Computation in Uncertain and Probabilistic Databases
creator: Das Sarma, Anish
creator: Theobald, Martin
creator: Widom, Jennifer
subject: Query Processing
description: We study the problem of computing query results with confidence values in {\em ULDBs}: relational databases with {\em uncertainty} and {\em lineage}. ULDBs, which subsume {\em probabilistic databases}, offer an alternative {\em decoupled} method of computing confidence values: Instead of computing confidences during query processing, compute them afterwards based on lineage. This approach enables a wider space of query plans, and it permits selective computations when not all confidence values are needed. This paper develops a suite of algorithms and optimizations for a broad class of relational queries on ULDBs. We provide confidence computation algorithms for single data items, as well as efficient batch algorithms to compute confidences for an entire relation or database. All algorithms incorporate memoization to avoid redundant computations, and they have been implemented in the {\em Trio} prototype ULDB database system. Performance characteristics and scalability of the algorithms are demonstrated through experimental results over a large synthetic dataset.
publisher: Stanford
date: 2007-03-21
type: Techreport
type: NonPeerReviewed
format: application/pdf
identifier: http://ilpubs.stanford.edu:8090/800/1/2007-15.pdf
identifier: Das Sarma, Anish and Theobald, Martin and Widom, Jennifer (2007) Exploiting Lineage for Confidence Computation in Uncertain and Probabilistic Databases. Technical Report. Stanford.
relation: http://ilpubs.stanford.edu:8090/800/