A SAT-based System for Consistent Query Answering

05/07/2019
by   Akhil A. Dixit, et al.
0

An inconsistent database is a database that violates one or more integrity constraints, such as functional dependencies. Consistent Query Answering is a rigorous and principled approach to the semantics of queries posed against inconsistent databases. The consistent answers to a query on an inconsistent database is the intersection of the answers to the query on every repair, i.e., on every consistent database that differs from the given inconsistent one in a minimal way. Computing the consistent answers of a fixed conjunctive query on a given inconsistent database can be a coNP-hard problem, even though every fixed conjunctive query is efficiently computable on a given consistent database. We designed, implemented, and evaluated CAvSAT, a SAT-based system for consistent query answering. CAvSAT leverages a set of natural reductions from the complement of consistent query answering to SAT and to Weighted MaxSAT. The system is capable of handling unions of conjunctive queries and arbitrary denial constraints, which include functional dependencies as a special case. We report results from experiments evaluating CAvSAT on both synthetic and real-world databases. These results provide evidence that a SAT-based approach can give rise to a comprehensive and scalable system for consistent query answering.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
03/04/2021

Consistent Answers of Aggregation Queries using SAT Solvers

The framework of database repairs and consistent answers to queries is a...
research
08/19/2021

Second-Order Specifications and Quantifier Elimination for Consistent Query Answering in Databases

Consistent answers to a query from a possibly inconsistent database are ...
research
08/25/2022

LinCQA: Faster Consistent Query Answering with Linear Time Guarantees

Most data analytical pipelines often encounter the problem of querying i...
research
04/22/2022

Uniform Operational Consistent Query Answering

Operational consistent query answering (CQA) is a recent framework for C...
research
06/27/2023

A fine-grained framework for database repairs

We introduce a general abstract framework for database repairing that di...
research
01/09/2023

Consistent Query Answering without Repairs in Tables with Nulls and Functional Dependencies

In this paper, we study consistent query answering in tables with nulls ...
research
07/19/2022

Consistent Query Answering for Expressive Constraints under Tuple-Deletion Semantics

We study consistent query answering in relational databases. We consider...

Please sign up or login with your details

Forgot password? Click here to reset