Consistent Answers of Aggregation Queries using SAT Solvers
Databases
2021-11-15 v3
Abstract
The framework of database repairs and consistent answers to queries is a principled approach to managing inconsistent databases. We describe the first system able to compute the consistent answers of general aggregation queries with the COUNT(A), COUNT(*), SUM(A), MIN(A), and MAX(A) operators, and with or without grouping constructs. Our system uses reductions to optimization versions of Boolean satisfiability (SAT) and then leverages powerful SAT solvers. We carry out an extensive set of experiments on both synthetic and real-world data that demonstrate the usefulness and scalability of this approach.
Cite
@article{arxiv.2103.03314,
title = {Consistent Answers of Aggregation Queries using SAT Solvers},
author = {Akhil A. Dixit and Phokion G. Kolaitis},
journal= {arXiv preprint arXiv:2103.03314},
year = {2021}
}
Comments
18 pages, 10 figures, 7 tables