English

Computing expected multiplicities for bag-TIDBs with bounded multiplicities

Databases 2022-07-04 v3 Computational Complexity

Abstract

In this work, we study the problem of computing a tuple's expected multiplicity over probabilistic databases with bag semantics (where each tuple is associated with a multiplicity) exactly and approximately. We consider bag-TIDBs where we have a bound cc on the maximum multiplicity of each tuple and tuples are independent probabilistic events (we refer to such databases as c-TIDBs. We are specifically interested in the fine-grained complexity of computing expected multiplicities and how it compares to the complexity of deterministic query evaluation algorithms -- if these complexities are comparable, it opens the door to practical deployment of probabilistic databases. Unfortunately, our results imply that computing expected multiplicities for c-TIDBs based on the results produced by such query evaluation algorithms introduces super-linear overhead (under parameterized complexity hardness assumptions/conjectures). We proceed to study approximation of expected result tuple multiplicities for positive relational algebra queries (RA+RA^+) over c-TIDBs and for a non-trivial subclass of block-independent databases (BIDBs). We develop a sampling algorithm that computes a 1±ϵ\pm\epsilon approximation of the expected multiplicity of an output tuple in time linear in the runtime of the corresponding deterministic query for any RA+RA^+ query.

Keywords

Cite

@article{arxiv.2204.02758,
  title  = {Computing expected multiplicities for bag-TIDBs with bounded multiplicities},
  author = {Su Feng and Boris Glavic and Aaron Huber and Oliver Kennedy and Atri Rudra},
  journal= {arXiv preprint arXiv:2204.02758},
  year   = {2022}
}

Comments

Added grant acknowledgements in v.3

R2 v1 2026-06-24T10:39:43.330Z