Counting Database Repairs Entailing a Query: The Case of Functional Dependencies
Summary: Extends the FP/#P-complete dichotomy for counting repairs that entail a self-join-free CQ from primary keys to general functional dependencies, characterizing exact data complexity. Shows counting can be inapproximable under FDs, but FDs with a left-hand-side chain admit an FPRAS (an island of approximability). (summarized by gpt-5-mini on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Marco Calautti (University of Trento)
- 2. Ester Livshits (University of Edinburgh)
- 3. Andreas Pieris (University of Cyprus; University of Edinburgh)
- 4. Markus Schneider (University of Edinburgh)
BibTeX Citation
@inproceedings{calautti_pods22,
address = {New York, NY, USA},
series = {{PODS} '22},
title = {{Counting Database Repairs Entailing a Query: The Case of Functional Dependencies}},
url = {https://dl.acm.org/doi/10.1145/3517804.3524147},
doi = {10.1145/3517804.3524147},
booktitle = {Proceedings of the {ACM} {SIGMOD} Symposium on {Principles} of {Database} {Systems}},
publisher = {Association for Computing Machinery},
author = {Calautti, Marco and Livshits, Ester and Pieris, Andreas and Schneider, Markus},
year = {2022}
}Incoming Citations (Sorted by Pagerank)
Showing 4 of 4 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 7,712 | Uniform Operational Consistent Query Answering | 2022 | PODS | 5.5612056e-05 |
| 9,921 | Combined Approximations for Uniform Operational Consistent Query Answering | 2024 | PODS | 5.1955087e-05 |
| 11,121 | Consistent Query Answering for Primary Keys on Rooted Tree Queries | 2024 | PODS | 5.093636e-05 |
| 11,146 | Computing Range Consistent Answers to Aggregation Queries via Rewriting | 2024 | PODS | 5.093636e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 3 of 3 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 33 | Consistent Query Answers in Inconsistent Databases | 1999 | PODS | 0.00049907763 |
| 574 | Management of Probabilistic Data: Foundations and Challenges | 2007 | PODS | 0.00016278855 |
| 5,258 | Counting Database Repairs under Primary Keys Revisited | 2019 | PODS | 6.2967016e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 7,558 | Consistent Query Answering for Primary Keys on Path Queries | 2021 | PODS |
| 2 | 8,103 | The Computation of Optimal Subset Repairs | 2020 | VLDB |
| 3 | 11,121 | Consistent Query Answering for Primary Keys on Rooted Tree Queries | 2024 | PODS |
| 4 | 1,332 | Sampling the Repairs of Functional Dependency Violations under Hard Constraints | 2010 | VLDB |
| 5 | 644 | The Complexity of Query Reliability | 1998 | PODS |
| 6 | 9,921 | Combined Approximations for Uniform Operational Consistent Query Answering | 2024 | PODS |
| 7 | 1,707 | The Data Complexity of Consistent Query Answering for Self-Join-Free Conjunctive Queries Under Primary Key Constraints | 2015 | PODS |
| 8 | 8,038 | Counting and Enumerating (Preferred) Database Repairs | 2017 | PODS |
| 9 | 5,258 | Counting Database Repairs under Primary Keys Revisited | 2019 | PODS |
| 10 | 1,399 | Computing Optimal Repairs for Functional Dependencies | 2018 | PODS |