Processing math: 100%

Diego Figueira ; Anantha Padmanabha ; Luc Segoufin ; Cristina Sirangelo - A Simple Algorithm for Consistent Query Answering under Primary Keys

lmcs:12679 - Logical Methods in Computer Science, February 21, 2025, Volume 21, Issue 1 - https://doi.org/10.46298/lmcs-21(1:18)2025
A Simple Algorithm for Consistent Query Answering under Primary KeysArticle

Authors: Diego Figueira ; Anantha Padmanabha ; Luc Segoufin ; Cristina Sirangelo

    We consider the dichotomy conjecture for consistent query answering under primary key constraints. It states that, for every fixed Boolean conjunctive query q, testing whether q is certain (i.e. whether it evaluates to true over all repairs of a given inconsistent database) is either polynomial time or coNP-complete. This conjecture has been verified for self-join-free and path queries. We propose a simple inflationary fixpoint algorithm for consistent query answering which, for a given database, naively computes a set Δ of subsets of facts of the database of size at most k, where k is the size of the query q. The algorithm runs in polynomial time and can be formally defined as: (1) Initialize Δ with all sets S of at most k facts such that Sq. (2) Add any set S of at most k facts to Δ if there exists a block B (i.e., a maximal set of facts sharing the same key) such that for every fact aB there is a set SS{a} such that SΔ. For an input database D, the algorithm answers "q is certain" iff Δ eventually contains the empty set. The algorithm correctly computes certainty when the query q falls in the polynomial time cases of the known dichotomies for self-join-free queries and path queries. For arbitrary Boolean conjunctive queries, the algorithm is an under-approximation: the query is guaranteed to be certain if the algorithm claims so. However, there are polynomial time certain queries (with self-joins) which are not identified as such by the algorithm.


    Volume: Volume 21, Issue 1
    Published on: February 21, 2025
    Accepted on: December 18, 2024
    Submitted on: December 12, 2023
    Keywords: Computer Science - Databases,Computer Science - Logic in Computer Science

    Consultation statistics

    This page has been seen 568 times.
    This article's PDF has been downloaded 205 times.