On the Enumeration Complexity of Unions of Conjunctive Queries

被引:11
|
作者
Carmeli, Nofar [1 ,3 ]
Kroell, Markus [2 ]
机构
[1] Technion Israel Inst Technol, Haifa, Israel
[2] TU Wien, Favoritenstr 9-11-3, A-1040 Vienna, Austria
[3] Technion, CS Taub Bldg, IL-3200003 Haifa, Israel
来源
ACM TRANSACTIONS ON DATABASE SYSTEMS | 2021年 / 46卷 / 02期
基金
奥地利科学基金会;
关键词
Unions of conjunctive queries; enumeration; complexity; constant delay;
D O I
10.1145/3450263
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
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.
引用
收藏
页数:41
相关论文
共 50 条
  • [1] On the Enumeration Complexity of Unions of Conjunctive Queries
    Carmeli, Nofar
    Kroell, Markus
    [J]. PROCEEDINGS OF THE 38TH ACM SIGMOD-SIGACT-SIGAI SYMPOSIUM ON PRINCIPLES OF DATABASE SYSTEMS (PODS '19), 2019, : 134 - 148
  • [2] Enumeration Complexity of Conjunctive Queries with Functional Dependencies
    Carmeli, Nofar
    Kroell, Markus
    [J]. THEORY OF COMPUTING SYSTEMS, 2020, 64 (05) : 828 - 860
  • [3] Enumeration Complexity of Conjunctive Queries with Functional Dependencies
    Nofar Carmeli
    Markus Kröll
    [J]. Theory of Computing Systems, 2020, 64 : 828 - 860
  • [4] Answering (Unions of) Conjunctive Queries using Random Access and Random-Order Enumeration
    Carmeli, Nofar
    Zeevi, Shai
    Berkholz, Christoph
    Kimelfeld, Benny
    Schweikardt, Nicole
    [J]. PODS'20: PROCEEDINGS OF THE 39TH ACM SIGMOD-SIGACT-SIGAI SYMPOSIUM ON PRINCIPLES OF DATABASE SYSTEMS, 2020, : 393 - 409
  • [5] Answering (Unions of) Conjunctive Queries using Random Access and Random-Order Enumeration
    Carmeli, Nofar
    Zeevi, Shai
    Berkholz, Christoph
    Conte, Alessio
    Kimelfeld, Benny
    Schweikardt, Nicole
    [J]. ACM TRANSACTIONS ON DATABASE SYSTEMS, 2022, 47 (03):
  • [6] Constant delay enumeration for conjunctive queries
    Segoufin, Luc
    [J]. SIGMOD RECORD, 2015, 44 (01) : 10 - 17
  • [7] The complexity of acyclic conjunctive queries
    Gottlob, G
    Leone, N
    Scarcello, F
    [J]. 39TH ANNUAL SYMPOSIUM ON FOUNDATIONS OF COMPUTER SCIENCE, PROCEEDINGS, 1998, : 706 - 715
  • [8] The complexity of acyclic conjunctive queries
    Gottlob, G
    Leone, N
    Scarcello, F
    [J]. JOURNAL OF THE ACM, 2001, 48 (03) : 431 - 498
  • [9] On acyclic conjunctive queries and constant delay enumeration
    Bagan, Guillaume
    Durand, Arnaud
    Grandjean, Etienne
    [J]. COMPUTER SCIENCE LOGIC, PROCEEDINGS, 2007, 4646 : 208 - +
  • [10] On preservation under homomorphisms and unions of conjunctive queries
    Atserias, Albert
    Dawar, Anuj
    Kolaitis, Phokion G.
    [J]. JOURNAL OF THE ACM, 2006, 53 (02) : 208 - 237