Rewriting conjunctive queries determined by views

被引:0
|
作者
Afrati, Foto [1 ]
机构
[1] Natl Tech Univ Athens, GR-10682 Athens, Greece
关键词
D O I
暂无
中图分类号
TP301 [理论、方法];
学科分类号
081202 ;
摘要
Answering queries using views is the problem which examines how to derive the answers to a query when we only have the answers to a set of views. Constructing rewritings is a widely studied technique to derive those answers. In this paper we consider the problem of existence of rewritings in the case where the answers to the views uniquely determine the answers to the query. Specifically, we say that a view set V determines a query Q if for any two databases D-1; D-2 it holds: V(D-1) = V(D2) implies Q(D-1) = Q(D2). We consider the case where query and views are defined by conjunctive queries and investigate the question: If a view set V determines a query Q, is there an equivalent rewriting of Q using V? We present here interesting cases where there are such rewritings in the language of conjunctive queries. Interestingly, we identify a class of conjunctive queries, CQ(path), for which a view set can produce equivalent rewritings for "almost all" queries which are determined by this view set. We introduce a problem which relates determinacy to query equivalence. We show that there are cases where restricted results can carry over to broader classes of queries.
引用
收藏
页码:78 / 89
页数:12
相关论文
共 50 条
  • [21] Object oriented mechanisms to rewriting queries using views
    Seriai, Abdelhak
    Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), 2003, 2736 : 672 - 682
  • [22] Rewriting queries with arbitrary aggregation functions using views
    Cohen, Sara
    Nutt, Werner
    Sagiv, Yehoshua
    ACM TRANSACTIONS ON DATABASE SYSTEMS, 2006, 31 (02): : 672 - 715
  • [23] Rewriting queries using views with value integrity constraints
    Jaudoin, H
    STAIRS 2004, 2004, 109 : 38 - 49
  • [24] Object oriented mechanisms to rewriting queries using views
    Seriai, A
    DATABASE AND EXPERT SYSTEMS APPLICATIONS, PROCEEDINGS, 2003, 2736 : 672 - 682
  • [25] Rewriting XPath queries using materialized XPath views
    Ramanan, Prakash
    JOURNAL OF COMPUTER AND SYSTEM SCIENCES, 2012, 78 (04) : 1006 - 1025
  • [26] On Maximal Contained Rewriting of Tree Pattern Queries Using Views
    Wang, Junhu
    Yu, Jeffrey Xu
    WEB INFORMATION SYSTEM ENGINEERING-WISE 2010, 2010, 6488 : 616 - +
  • [27] Rewriting queries using views over monadic database schemas
    Van den Bussche, J
    INFORMATION PROCESSING LETTERS, 2001, 79 (03) : 111 - 114
  • [28] Rewriting queries using views with access patterns under integrity constraints
    Deutsch, A
    Ladäscher, B
    Nash, A
    DATABASE THEORY - ICDT 2005, PROCEEDINGS, 2005, 3363 : 352 - 367
  • [29] Rewriting queries using views with access patterns under integrity constraints
    Deutsch, Alin
    Ludascher, Bertram
    Nash, Alan
    THEORETICAL COMPUTER SCIENCE, 2007, 371 (03) : 200 - 226
  • [30] Conjunctive Queries with Comparisons
    Wang, Qichen
    Yi, Ke
    PROCEEDINGS OF THE 2022 INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA (SIGMOD '22), 2022, : 108 - 121