# Exploiting Lineage for Confidence Computation in Uncertain and Probabilistic Databases

Das Sarma, Anish and Theobald, Martin and Widom, Jennifer (2007) Exploiting Lineage for Confidence Computation in Uncertain and Probabilistic Databases. Technical Report. Stanford.

 BibTeX DublinCore EndNote HTML

 Preview
PDF
280Kb

## Abstract

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.

Item Type: Subjects: Techreport (Technical Report) Computer Science > Query Processing Miscellaneous Project Homepage http://infolab.stanford.edu/ 800 Import Account 20 Mar 2007 17:00 10 Dec 2008 16:59