Conjunctive queries with self-joins, towards a fine-grained complexity analysis

06/10/2022
by   Nofar Carmeli, et al.
0

The complexity of evaluating conjunctive queries without self-joins is well understood: Acyclicity is the boundary for being able to test whether there is a solution in linear time, and free-connexity is the boundary for being able to compute the set of solutions in linear input + output time. Moreover, free-connex acyclic queries can be enumerated with constant delay. In the presence of self-joins, the situation is not that clear. All the upper-bounds mentioned above remain, but not the lower bounds. We provide preliminary results for the fine-grained complexity analysis of the evaluation of conjunctive queries with self-joins. We settle the case of queries with arity two or less and for queries with cyclic cores. We also provide a toolbox that can be used to show hardness or easiness of queries with self-joins. We illustrate the toolbox by identifying tractable cases that were not known to be efficiently solvable and identifying sufficient conditions for hardness.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
01/07/2022

Tight Fine-Grained Bounds for Direct Access on Join Queries

We consider the task of lexicographic direct access to query answers. Th...
research
12/10/2018

Enumeration Complexity of Unions of Conjunctive Queries

We study the enumeration complexity of answering unions of conjunctive q...
research
12/21/2017

Enumeration Complexity of Conjunctive Queries with Functional Dependencies

We study the complexity of enumerating the answers of Conjunctive Querie...
research
01/06/2021

Fine-Grained Complexity of Regular Path Queries

A regular path query (RPQ) is a regular expression q that returns all no...
research
07/02/2019

New Results for the Complexity of Resilience for Binary Conjunctive Queries with Self-Joins

The resilience of a Boolean query is the minimum number of tuples that n...
research
12/23/2019

Answering (Unions of) Conjunctive Queries using Random Access and Random-Order Enumeration

As data analytics becomes more crucial to digital systems, so grows the ...
research
03/09/2023

Direct Access for Answers to Conjunctive Queries with Aggregation

We study the fine-grained complexity of conjunctive queries with groupin...

Please sign up or login with your details

Forgot password? Click here to reset