On the Enumeration Complexity of Unions of Conjunctive Queries

We study the enumeration complexity of Unions of Conjunctive Queries (UCQs). We aim to identify the UCQs that are tractable in the sense that the answer tuples can be enumerated with a linear preprocessing phase and a constant delay between every successive tuples. It has been established that, in the absence of self-joins and under conventional complexity assumptions, the CQs that admit such an evaluation are precisely the free-connex ones. A union of tractable CQs is always tractable. We generalize the notion of free-connexity from CQs to UCQs, thus showing that some unions containing intractable CQs are, in fact, tractable. Interestingly, some unions consisting of only intractable CQs are tractable too. We show how to use the techniques presented in this article also in settings where the database contains cardinality dependencies (including functional dependencies and key constraints) or when the UCQs contain disequalities. The question of finding a full characterization of the tractability of UCQs remains open. Nevertheless, we prove that, for several classes of queries, free-connexity fully captures the tractable UCQs.

[1]  Friedrich Eisenbrand,et al.  On the complexity of fixed parameter clique and dominating set , 2004, Theor. Comput. Sci..

[2]  Arnaud Durand,et al.  On Acyclic Conjunctive Queries and Constant Delay Enumeration , 2007, CSL.

[3]  Noga Alon,et al.  Finding and counting given length cycles , 1997, Algorithmica.

[4]  Jörg Flum,et al.  Query evaluation via tree-decompositions , 2001, JACM.

[5]  Josh Alman,et al.  Limits on All Known (and Some Unknown) Approaches to Matrix Multiplication , 2018, 2018 IEEE 59th Annual Symposium on Foundations of Computer Science (FOCS).

[6]  Luc Segoufin,et al.  Constant Delay Enumeration for Conjunctive Queries , 2015, SGMD.

[7]  Etienne Grandjean,et al.  Sorting, linear time and the satisfiability problem , 1996, Annals of Mathematics and Artificial Intelligence.

[8]  Yann Strozecki,et al.  Incremental delay enumeration: Space and time , 2019, Discret. Appl. Math..

[9]  Nicole Schweikardt,et al.  Constant delay enumeration for conjunctive queries , 2020, ACM SIGLOG News.

[10]  Mihalis Yannakakis,et al.  Algorithms for Acyclic Database Schemes , 1981, VLDB.

[11]  Yann Strozecki,et al.  Enumeration complexity and matroid decomposition , 2010 .

[12]  Ashok K. Chandra,et al.  Optimal implementation of conjunctive queries in relational data bases , 1977, STOC '77.

[13]  François Le Gall,et al.  Powers of tensors and fast matrix multiplication , 2014, ISSAC.

[14]  Nicole Schweikardt,et al.  Answering UCQs under updates and in the presence of integrity constraints , 2017, ICDT.

[15]  Alexandre Vigny,et al.  Constant Delay Enumeration for FO Queries over Databases with Local Bounded Expansion , 2017, ICDT.

[16]  Nicole Schweikardt,et al.  Answering Conjunctive Queries under Updates , 2017, PODS.

[17]  Catriel Beeri,et al.  On the Desirability of Acyclic Database Schemes , 1983, JACM.

[18]  Markus Kröll,et al.  Enumeration Complexity of Conjunctive Queries with Functional Dependencies , 2018, ICDT.

[19]  Dan Suciu,et al.  What Do Shannon-type Inequalities, Submodular Width, and Disjunctive Datalog Have to Do with One Another? , 2016, PODS.

[20]  Richard Ryan Williams,et al.  Tight Hardness for Shortest Cycles and Paths in Sparse Graphs , 2017, SODA.

[21]  Nicole Schweikardt,et al.  Enumeration for FO Queries over Nowhere Dense Graphs , 2018, PODS.

[22]  Luc Segoufin,et al.  Enumeration of MSO Queries on Strings with Constant Delay and Logarithmic Updates , 2018, PODS.

[23]  Stijn Vansummeren,et al.  Constant Delay Algorithms for Regular Document Spanners , 2018, PODS.

[24]  Markus Kröll,et al.  On the Enumeration Complexity of Unions of Conjunctive Queries , 2018, PODS.

[25]  Stijn Vansummeren,et al.  The Dynamic Yannakakis Algorithm: Compact and Efficient Query Processing Under Updates , 2017, SIGMOD Conference.

[26]  Arnaud Durand,et al.  First-order queries on structures of bounded degree are computable with constant delay , 2005, TOCL.