Binding propagation techniques for the optimization of bound disjunctive queries

被引:22
|
作者
Greco, S [1 ]
机构
[1] Univ Calabria, Dipartimento Informat & Sistemist, I-87036 Arcavacata Di Rende, Italy
关键词
disjunctive databases; optimization; query rewriting;
D O I
10.1109/TKDE.2003.1185840
中图分类号
TP18 [人工智能理论];
学科分类号
081104 ; 0812 ; 0835 ; 1405 ;
摘要
This paper presents a technique for the optimization of bound queries on disjunctive deductive databases. The optimization is based on the rewriting of the source program into an equivalent program which can be evaluated more efficiently. The proposed optimization reduces the amount of data needed to answer the query and, consequently, 1) reduces the complexity of computing a single model and, more importantly, 2) greatly reduces the number of models to be considered. Although, in this paper, we consider the application of the magic-set method, other rewriting techniques defined for special classes of queries can also be applied. To show the relevance of our technique, we have implemented a prototype of an optimizer. Several experiments have confirmed the value of the technique.
引用
收藏
页码:368 / 385
页数:18
相关论文
共 50 条
  • [1] Optimization of bound disjunctive queries with constraints
    Greco, G
    Greco, S
    Trubitsyna, I
    Zumpano, E
    [J]. THEORY AND PRACTICE OF LOGIC PROGRAMMING, 2005, 5 : 713 - 745
  • [2] Optimization of disjunctive queries
    Greco, S
    [J]. LOGIC PROGRAMMING: PROCEEDINGS OF THE 1999 INTERNATIONAL CONFERENCE ON LOGIC PROGRAMMING, 1999, : 441 - 455
  • [3] Optimization and evaluation of disjunctive queries
    Claussen, J
    Kemper, A
    Moerkotte, G
    Peithner, K
    Steinbrunn, M
    [J]. IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2000, 12 (02) : 238 - 260
  • [4] OPTIMIZATION STRATEGIES FOR RELATIONAL DISJUNCTIVE QUERIES
    CIACCIA, P
    SCALAS, MR
    [J]. IEEE TRANSACTIONS ON SOFTWARE ENGINEERING, 1989, 15 (10) : 1217 - 1235
  • [5] Query optimization of disjunctive databases with constraints through binding propagation
    Greco, G
    Greco, S
    Trubtsyna, I
    Zumpano, E
    [J]. LOGIC FOR PROGRAMMING, ARTIFICIAL INTELLIGENCE, AND REASONING, 2002, 2514 : 216 - 230
  • [6] An optimization of disjunctive queries: Union-pushdown
    Chang, JY
    Lee, SG
    [J]. COMPSAC 97 : TWENTY-FIRST ANNUAL INTERNATIONAL COMPUTER SOFTWARE & APPLICATIONS CONFERENCE, 1997, : 356 - 361
  • [7] Constraint propagation techniques for the disjunctive scheduling problem
    Dorndorf, U
    Pesch, E
    Toàn, PH
    [J]. ARTIFICIAL INTELLIGENCE, 2000, 122 (1-2) : 189 - 240
  • [8] Optimization techniques for queries with expensive methods
    Hellerstein, JM
    [J]. ACM TRANSACTIONS ON DATABASE SYSTEMS, 1998, 23 (02): : 113 - 157
  • [9] Semantic optimization techniques for preference queries
    Chomicki, Jan
    [J]. INFORMATION SYSTEMS, 2007, 32 (05) : 670 - 684
  • [10] On formulation of disjunctive coupling queries in WHOWEDA
    Bhowmick, SS
    Ng, WK
    Madria, S
    [J]. DATABASE AND EXPERT SYSTEMS APPLICATIONS, 2001, 2113 : 688 - 698