On preservation under homomorphisms and unions of conjunctive queries

被引:36
|
作者
Atserias, Albert [1 ]
Dawar, Anuj
Kolaitis, Phokion G.
机构
[1] Univ Politecn Cataluna, E-08028 Barcelona, Spain
[2] Univ Cambridge, Comp Lab, Cambridge, England
[3] IBM Corp, Almaden Res Ctr, San Jose, CA USA
基金
英国工程与自然科学研究理事会;
关键词
theory; conjunctive queries; Datalog; finite model theory; first-order logic; graph minors; homomorphisms; infinitary logic; preservation;
D O I
10.1145/1131342.1131344
中图分类号
TP3 [计算技术、计算机技术];
学科分类号
0812 ;
摘要
Unions of conjunctive queries, also known as select-project-join-union queries, are the most frequently asked queries in relational database systems. These queries are definable by existential positive first-order formulas and are preserved under homomorphisms. A classical result of mathematical logic asserts that the existential positive formulas are the only first-order formulas (up to logical equivalence) that are preserved under homomorphisms on all structures, finite and infinite. The question of whether the homomorphism-preservation theorem holds for the class of all finite structures resisted solution for a long time. It was eventually shown that, unlike other classical preservation theorems, the homomorphism-preservation theorem does hold in the finite. In this article, we show that the homomorphism-preservation theorem holds also for several restricted classes of finite structures of interest in graph theory and database theory. Specifically, we show that this result holds for all classes of finite structures of bounded degree, all classes of finite structures of bounded treewidth, and, more generally, all classes of finite structures whose cores exclude at least one minor.
引用
收藏
页码:208 / 237
页数:30
相关论文
共 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] On the Enumeration Complexity of Unions of Conjunctive Queries
    Carmeli, Nofar
    Kroell, Markus
    [J]. ACM TRANSACTIONS ON DATABASE SYSTEMS, 2021, 46 (02):
  • [3] Processing unions of conjunctive queries with negation under limited access patterns
    Nash, A
    Ludäscher, B
    [J]. ADVANCES IN DATABASE TECHNOLOGY - EDBT 2004, PROCEEDINGS, 2004, 2992 : 422 - 440
  • [4] The Dichotomy of Probabilistic Inference for Unions of Conjunctive Queries
    Dalvi, Nilesh
    Suciu, Dan
    [J]. JOURNAL OF THE ACM, 2012, 59 (06)
  • [5] Rewriting unions of general conjunctive queries using views
    Wang, JH
    Maher, M
    Topor, R
    [J]. ADVANCES IN DATABASE TECHNOLOGY - EDBT 2002, 2002, 2287 : 52 - 69
  • [6] A monotone preservation result for Boolean queries expressed as a containment of conjunctive queries
    Surinx, Dimitri
    Van den Bussche, Jan
    [J]. INFORMATION PROCESSING LETTERS, 2019, 150 : 1 - 5
  • [7] Query Languages for Data Exchange: Beyond Unions of Conjunctive Queries
    Arenas, Marcelo
    Barcelo, Pablo
    Reutter, Juan
    [J]. THEORY OF COMPUTING SYSTEMS, 2011, 49 (02) : 489 - 564
  • [8] A Dichotomy for the Generalized Model Counting Problem for Unions of Conjunctive Queries
    Kenig, Batya
    Suciu, Dan
    [J]. PODS '21: PROCEEDINGS OF THE 40TH SIGMOD-SIGACT-SIGAI SYMPOSIUM ON PRINCIPLES OF DATABASE SYSTEMS, 2021, : 312 - 324
  • [9] Query Languages for Data Exchange: Beyond Unions of Conjunctive Queries
    Marcelo Arenas
    Pablo Barceló
    Juan Reutter
    [J]. Theory of Computing Systems, 2011, 49 : 489 - 564
  • [10] Answering Conjunctive Queries under Updates
    Berkholz, Christoph
    Keppeler, Jens
    Schweikardt, Nicole
    [J]. PODS'17: PROCEEDINGS OF THE 36TH ACM SIGMOD-SIGACT-SIGAI SYMPOSIUM ON PRINCIPLES OF DATABASE SYSTEMS, 2017, : 303 - 318