Skip to content
Free planNo credit card requiredStart writing

preprint · arXiv (Cornell University) · 2023

Consistent Query Answering for Primary Keys on Rooted Tree Queries

Paraschos Koutris, Xiating Ouyang, Jef Wijsen

Cited by 1Open access

Abstract

We study the data complexity of consistent query answering (CQA) on databases that may violate the primary key constraints. A repair is a maximal subset of the database satisfying the primary key constraints. For a Boolean query q, the problem CERTAINTY(q) takes a database as input, and asks whether or not each repair satisfies q. The computational complexity of CERTAINTY(q) has been established whenever q is a self-join-free Boolean conjunctive query, or a (not necessarily self-join-free) Boolean path query. In this paper, we take one more step towards a general classification for all Boolean conjunctive queries by considering the class of rooted tree queries. In particular, we show that for every rooted tree query q, CERTAINTY(q) is in FO, NL-hard $\cap$ LFP, or coNP-complete, and it is decidable (in polynomial time), given q, which of the three cases applies. We also extend our classification to larger classes of queries with simple primary keys. Our classification criteria rely on query homomorphisms and our polynomial-time fixpoint algorithm is based on a novel use of context-free grammar (CFG).

Cite this paper

APA 7

Koutris, P., Ouyang, X., & Wijsen, J. (2023). Consistent Query Answering for Primary Keys on Rooted Tree Queries. arXiv (Cornell University). https://doi.org/10.48550/arxiv.2310.19642

MLA 9

Koutris, Paraschos, et al. “Consistent Query Answering for Primary Keys on Rooted Tree Queries.” arXiv (Cornell University), 2023, https://doi.org/10.48550/arxiv.2310.19642.

Chicago

Koutris, Paraschos, Xiating Ouyang, and Jef Wijsen. 2023. “Consistent Query Answering for Primary Keys on Rooted Tree Queries.” arXiv (Cornell University). https://doi.org/10.48550/arxiv.2310.19642.

Harvard

Koutris, P., Ouyang, X. and Wijsen, J. (2023) ‘Consistent Query Answering for Primary Keys on Rooted Tree Queries’, arXiv (Cornell University). Available at: https://doi.org/10.48550/arxiv.2310.19642.

BibTeX
@misc{koutris2023consistent,
  title = {{Consistent Query Answering for Primary Keys on Rooted Tree Queries}},
  author = {Koutris, Paraschos and Ouyang, Xiating and Wijsen, Jef},
  journal = {arXiv (Cornell University)},
  year = {2023},
  doi = {10.48550/arxiv.2310.19642}
}

Made from the index record. Check names, capitalisation and page numbers against the paper. Need another style? AI for Research has over 10,000.

Hybrid query plan generation

Carlos-Manuel López-Enríquez, Genoveva Vargas Solar, José-Luis Zechinelli-Martini et al. · HAL · 2012

Cited by 0Open access