Counting Database Repairs Entailing a Query: The Case of Functional Dependencies

12/17/2021
by   Marco Calautti, et al.
0

A key task in the context of consistent query answering is to count the number of repairs that entail the query, with the ultimate goal being a precise data complexity classification. This has been achieved in the case of primary keys and self-join-free conjunctive queries (CQs) via an FP/#P-complete dichotomy. We lift this result to the more general case of functional dependencies (FDs). Another important task in this context is whenever the counting problem in question is intractable, to classify it as approximable, i.e., the target value can be efficiently approximated with error guarantees via a fully polynomial-time randomized approximation scheme (FPRAS), or as inapproximable. Although for primary keys and CQs (even with self-joins) the problem is always approximable, we prove that this is not the case for FDs. We show, however, that the class of FDs with a left-hand side chain forms an island of approximability. We see these results, apart from being interesting in their own right, as crucial steps towards a complete classification of approximate counting of repairs in the case of FDs and self-join-free CQs.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
11/08/2022

Consistent Query Answering for Primary Keys and Conjunctive Queries with Counting

The problem of consistent query answering for primary keys and self-join...
research
10/08/2018

Consistent Query Answering for Primary Keys in Logspace

We study the complexity of consistent query answering on databases that ...
research
01/20/2023

A Simple Algorithm for Consistent Query Answering under Primary Keys

We consider the dichotomy conjecture for consistent query answering unde...
research
03/25/2022

A Dichotomy in Consistent Query Answering for Primary Keys and Unary Foreign Keys

Since 2005, significant progress has been made in the problem of Consist...
research
11/12/2020

The Complexity of Counting Problems over Incomplete Databases

We study the complexity of various fundamental counting problems that ar...
research
12/23/2019

Counting Problems over Incomplete Databases

We study the complexity of various fundamental counting problems that ar...
research
05/29/2021

Towards a Dichotomy for Minimally Factorizing the Provenance of Self-Join Free Conjunctive Queries

We consider the problem of finding the minimal-size factorization of the...

Please sign up or login with your details

Forgot password? Click here to reset