Rewriting with Acyclic Queries: Mind your Head

01/13/2022
by   Gaetano Geck, et al.
0

The paper studies the rewriting problem, that is, the decision problem whether, for a given conjunctive query Q and a set 𝒱 of views, there is a conjunctive query Q' over 𝒱 that is equivalent to Q, for cases where the query, the views, and/or the desired rewriting are acyclic or even more restricted. It shows that, if Q 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 Q and the views in 𝒱 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).

READ FULL TEXT

page 1

page 2

page 3

page 4

research
12/28/1998

Hypertree Decompositions and Tractable Queries

Several important decision problems on conjunctive queries (CQs) are NP-...
research
04/10/2021

Splitting Spanner Atoms: A Tool for Acyclic Core Spanners

This paper investigates regex CQs with string equalities (SERCQs), a sub...
research
10/07/2020

Acyclic Comprehension is equal to Stratified Comprehension

A new criterion of comprehension is defined, initially termed by myself ...
research
11/10/2014

Answering Conjunctive Queries over EL Knowledge Bases with Transitive and Reflexive Roles

Answering conjunctive queries (CQs) over EL knowledge bases (KBs) with c...
research
11/29/2019

Mining Approximate Acyclic Schemes from Relations

Acyclic schemes have numerous applications in databases and in machine l...
research
06/01/2020

Balancing expressiveness and inexpressiveness in view design

We study the design of data publishing mechanisms that allow a collectio...
research
07/14/2022

Using Fuzzy Matching of Queries to optimize Database workloads

Directed Acyclic Graphs (DAGs) are commonly used in Databases and Big Da...

Please sign up or login with your details

Forgot password? Click here to reset