Extremal Fitting Problems for Conjunctive Queries

被引:3
|
作者
ten Cate, Balder [1 ]
Dalmau, Victor [2 ]
Funk, Maurice [3 ]
Lutz, Carsten [3 ]
机构
[1] Univ Amsterdam, ILLC, Amsterdam, Netherlands
[2] Univ Pompeu Fabra, Barcelona, Spain
[3] Univ Leipzig, ScaDSAI Ctr Dresden Leipzig, Leipzig, Germany
来源
PROCEEDINGS OF THE 42ND ACM SIGMOD-SIGACT-SIGAI SYMPOSIUM ON PRINCIPLES OF DATABASE SYSTEMS, PODS 2023 | 2023年
关键词
Conjunctive Queries; Database Queries; Data Examples; Fitting; Homomorphism Dualities; COMPLEXITY; FINITE;
D O I
10.1145/3584372.3588655
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
The fitting problem for conjunctive queries (CQs) is the problem to construct a CQ that fits a given set of labeled data examples. When a fitting CQ exists, it is in general not unique. This leads us to proposing natural refinements of the notion of a fitting CQ, such as most-general fitting CQ, most-specific fitting CQ, and unique fitting CQ. We give structural characterizations of these notions in terms of (suitable refinements of) homomorphism dualities, frontiers, and direct products, which enable the construction of the refined fitting CQs when they exist. We also pinpoint the complexity of the associated existence and verification problems, and determine the size of fitting CQs. We study the same problems for UCQs and for the more restricted class of tree CQs.
引用
收藏
页码:89 / 98
页数:10
相关论文
共 50 条
  • [31] Greedy strategies and larger islands of tractability for conjunctive queries and constraint satisfaction problems
    Greco, Gianluigi
    Scarcello, Francesco
    INFORMATION AND COMPUTATION, 2017, 252 : 201 - 220
  • [32] Tractable counting of the answers to conjunctive queries
    Pichler, Reinhard
    Skritek, Sebastian
    JOURNAL OF COMPUTER AND SYSTEM SCIENCES, 2013, 79 (06) : 984 - 1001
  • [33] LINEAR PROGRAMS WITH CONJUNCTIVE DATABASE QUERIES
    Capelli, Florent
    Crosetti, Nicolas
    Niehren, Joachim
    Ramon, Jan
    LOGICAL METHODS IN COMPUTER SCIENCE, 2024, 20 (01) : 1 - 9
  • [34] View selection for real conjunctive queries
    Afrati, Foto
    Chirkova, Rada
    Gergatsoulis, Manolis
    Pavlaki, Vassia
    ACTA INFORMATICA, 2007, 44 (05) : 289 - 321
  • [35] Answering Conjunctive Queries under Updates
    Berkholz, Christoph
    Keppeler, Jens
    Schweikardt, Nicole
    PODS'17: PROCEEDINGS OF THE 36TH ACM SIGMOD-SIGACT-SIGAI SYMPOSIUM ON PRINCIPLES OF DATABASE SYSTEMS, 2017, : 303 - 318
  • [36] Direct Access for Conjunctive Queries with Negations
    Capelli, Florent
    Irwin, Oliver
    27TH INTERNATIONAL CONFERENCE ON DATABASE THEORY, ICDT 2024, 2024, 290
  • [37] Technical Perspective: Conjunctive Queries with Comparisons
    Vansummeren, Stijn
    SIGMOD RECORD, 2023, 52 (01) : 53 - 53
  • [38] On the hardness of learning acyclic conjunctive queries
    Hirata, K
    ALGORITHMIC LEARNING THEORY, PROCEEDINGS, 2000, 1968 : 238 - 251
  • [39] Rewriting conjunctive queries determined by views
    Afrati, Foto
    Mathematical Foundations of Computer Science 2007, Proceedings, 2007, 4708 : 78 - 89
  • [40] On the Enumeration Complexity of Unions of Conjunctive Queries
    Carmeli, Nofar
    Kroell, Markus
    PROCEEDINGS OF THE 38TH ACM SIGMOD-SIGACT-SIGAI SYMPOSIUM ON PRINCIPLES OF DATABASE SYSTEMS (PODS '19), 2019, : 134 - 148