Conjunctive-query containment constraint satisfaction

被引:188
作者
Kolaitis, PG [1 ]
Vardi, MY
机构
[1] Univ Calif Santa Cruz, Dept Comp Sci, Santa Cruz, CA 95064 USA
[2] Rice Univ, Dept Comp Sci, Houston, TX 77005 USA
基金
美国国家科学基金会;
关键词
D O I
10.1006/jcss.2000.1713
中图分类号
TP3 [计算技术、计算机技术];
学科分类号
0812 ;
摘要
Conjunctive-query containment is recognized as a fundamental problem in database query evaluation and optimization. At the same time, constraint satisfaction is recognized as a fundamental problem in artificial intelligence. What do conjunctive-query containment and constraint satisfaction have in common? Our main conceptual contribution in this paper is to point out that, despite their very different formulation, conjunctive-query containment and constraint satisfaction are essentially the same problem. The reason is that they can be recast as the following fundamental algebraic problem: given two finite relational structures A and B, is there a homomorphism h: A --> B? As formulated above, the homomorphism problem is uniform in the sense that both relational structures A and B are part of the input. By fixing the structure B, one obtains the following nonuniform problem: given a finite relational structure A, is there a homomorphism h: A --> B? In general, nonuniform tractability results do not uniformize. Thus, it is natural to ask: which tractable cases of nonuniform tractability results for constraint satisfaction and conjunctive-query containment do uniformize?. Our main technical contribution in this paper is to show that several cases of tractable nonuniform constraint-satisfaction problems do indeed uniformize. We exhibit three nonuniform tractability results that uniformize and, thus, give rise to polynomial-time solvable cases of constraint satisfaction and conjunctive-query containment. We begin by examining the tractable cases of Boolean constraint-satisfaction problems and show that they do uniformize. This can be applied to conjunctive-query containment via Booleanization; in particular, it yields one of the known tractable cases of conjunctive-query containment. After this, we show that tractability results for constraint-satisfaction problems that can be expressed using Datalog programs with bounded number of distinct variables also uniformize. Finally, we provide a new proof for the fact that tractability results for queries with bounded treewidth uniformize as well, via a connection with first-order logic with a bounded number of distinct variables. (C) 2000 Academic Press.
引用
收藏
页码:302 / 332
页数:31
相关论文
共 55 条
  • [1] Abiteboul S., 1995, Foundations of databases, V1st
  • [2] [Anonymous], 1993, FDN CONSTRAINT SATIS
  • [3] [Anonymous], 1992, Encyclopedia of Artificial Intelligence
  • [4] BACCHUS F, 1998, P NAT C ART INT AAAI, P326
  • [5] Beeri C., 1979, ACM Transactions on Database Systems, V4, P30, DOI 10.1145/320064.320066
  • [6] CONSTRAINT SATISFACTION FROM A DEDUCTIVE VIEWPOINT
    BIBEL, W
    [J]. ARTIFICIAL INTELLIGENCE, 1988, 35 (03) : 401 - 413
  • [7] Bodlaender H. L., 1993, Proceedings of the Twenty-Fifth Annual ACM Symposium on the Theory of Computing, P226, DOI 10.1145/167088.167161
  • [8] Carey M., 1979, COMPUTER INTRACTABIL
  • [9] Chandra A., 1985, J LOGIC PROGRAM, V1, P1
  • [10] Chandra Ashok K., 1977, STOC'77: Proceedings of the ninth annual ACM symposium on Theory of computing, P77, DOI DOI 10.1145/800105.803397