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
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
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.
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.
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.
@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.
Related papers
The Complexity of Conjunctive Query Answering in Expressive Description Logics
Carsten Lutz · Lecture notes in computer science · 2008
Cited by 162
Rewriting Conjunctive Queries under Description Logic Constraints (Technical Report)
Héctor Pérez-Urbina · Oxford University Research Archive (ORA) (University of Oxford) · 2008
Cited by 0Open access
Immutably answering Why-Not questions for equivalent conjunctive queries
Nicole Bidoít, Melanie Herschel, Katerina Tzompanaki · Ingénierie des systèmes d information · 2015
Cited by 22
An Algorithm for Query Rewriting with Refined Criteria for Query Materialization in Deep Web
Peng Pan, Qingzhong Li · Web Information System and Application Conference · 2013
Cited by 0
Analysis of Query Optimizers
Ramineni Sharath Kumar · Journal of Computer Engineering and Information Technology · 2021
Cited by 0
Search Condition-Hiding Query Evaluation on Encrypted Databases
Myungsun Kim, Hyung Tae Lee, San Ling et al. · IEEE Access · 2019
Cited by 5Open access
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