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 条
  • [1] Determinacy and query rewriting for conjunctive queries and views
    Afrati, Foto N.
    THEORETICAL COMPUTER SCIENCE, 2011, 412 (11) : 1005 - 1021
  • [2] Rewriting unions of general conjunctive queries using views
    Wang, JH
    Maher, M
    Topor, R
    ADVANCES IN DATABASE TECHNOLOGY - EDBT 2002, 2002, 2287 : 52 - 69
  • [3] Determinacy and rewriting of conjunctive queries using views: A progress report
    Nash, Alan
    Segoufin, Luc
    Vianu, Victor
    DATABASE THEORY - ICDT 2007, PROCEEDINGS, 2006, 4353 : 59 - +
  • [4] A Top-Down Approach to Rewriting Conjunctive Queries Using Views
    Mohajerin, Nima
    Shiri, Nematollaah
    SEMANTICS IN DATA AND KNOWLEDGE BASES, 2008, 4925 : 180 - 198
  • [5] Conjunctive Queries with Constraints: Homomorphism, Containment and Rewriting
    Kiani, Ali
    Shiri, Nematollaah
    FOUNDATIONS OF INFORMATION AND KNOWLEDGE SYSTEMS, PROCEEDINGS, 2010, 5956 : 40 - 57
  • [6] Rewriting queries using views
    Flesca, S
    Greco, S
    IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2001, 13 (06) : 980 - 995
  • [7] Views and Queries: Determinacy and Rewriting
    Nash, Alan
    Segoufin, Luc
    Vianu, Victor
    ACM TRANSACTIONS ON DATABASE SYSTEMS, 2010, 35 (03):
  • [8] Rewriting Union Queries Using Views
    J. Wang
    R. Topor
    M. Maher
    Constraints, 2005, 10 : 219 - 251
  • [9] Approximate Rewriting of Queries Using Views
    Afrati, Foto
    Chandrachud, Manik
    Chirkova, Rada
    Mitra, Prasenjit
    ADVANCES IN DATABASES AND INFORMATION SYSTEMS, PROCEEDINGS, 2009, 5739 : 164 - +
  • [10] Rewriting queries using views with negation
    Afrati, Foto
    Pavlaki, Vassia
    AI COMMUNICATIONS, 2006, 19 (03) : 229 - 237