English

Rewriting with Acyclic Queries: Mind Your Head

Databases 2024-02-14 v6 Logic in Computer Science

Abstract

The paper studies the rewriting problem, that is, the decision problem whether, for a given conjunctive query QQ and a set V\mathcal{V} of views, there is a conjunctive query QQ' over V\mathcal{V} that is equivalent to QQ, for cases where the query, the views, and/or the desired rewriting are acyclic or even more restricted. It shows that, if QQ itself is acyclic, an acyclic rewriting exists if there is any rewriting. An analogous statement also holds for free-connex acyclic, hierarchical, and q-hierarchical queries. Regarding the complexity of the rewriting problem, the paper identifies a border between tractable and (presumably) intractable variants of the rewriting problem: for schemas of bounded arity, the acyclic rewriting problem is NP-hard, even if both QQ and the views in V\mathcal{V} are acyclic or hierarchical. However, it becomes tractable if the views are free-connex acyclic (i.e., in a nutshell, their body is (i) acyclic and (ii) remains acyclic if their head is added as an additional atom).

Cite

@article{arxiv.2201.05129,
  title  = {Rewriting with Acyclic Queries: Mind Your Head},
  author = {Gaetano Geck and Jens Keppeler and Thomas Schwentick and Christopher Spinrath},
  journal= {arXiv preprint arXiv:2201.05129},
  year   = {2024}
}
R2 v1 2026-06-24T08:49:21.520Z