Querying incomplete data over extended ER schemata

被引:4
|
作者
Cali, Andrea [1 ]
Martinenghi, Davide [2 ]
机构
[1] Univ Oxford, Comp Lab, Oxford OX2 6ED, England
[2] Politecn Milan, Dipartimento Elettron & Informaz, I-20133 Milan, Italy
基金
英国工程与自然科学研究理事会;
关键词
Extended ER model; dependencies; chase; incomplete data; COMPLEXITY; SEMANTICS;
D O I
10.1017/S1471068410000104
中图分类号
TP31 [计算机软件];
学科分类号
081202 ; 0835 ;
摘要
Since Chen's Entity-Relationship (ER) model, conceptual modeling has been playing a fundamental role in relational data design. In this paper we consider an extended ER (EER) model enriched with cardinality constraints, disjointness assertions, and is a relations among both entities and relationships. In this setting, we consider the case of incomplete data, which is likely to occur, for instance, when data from different sources are integrated. In such a context, we address the problem of providing correct answers to conjunctive queries by reasoning on the schema. Based on previous results about decidability of the problem, we provide a query answering algorithm that performs rewriting of the initial query into a recursive Datalog query encoding the information about the schema. We finally show extensions to more general settings.
引用
收藏
页码:291 / 329
页数:39
相关论文
共 50 条
  • [31] ON REPRESENTATION AND QUERYING INCOMPLETE INFORMATION IN DATABASES WITH BAGS
    LIBKIN, L
    WONG, LS
    INFORMATION PROCESSING LETTERS, 1995, 56 (04) : 209 - 214
  • [32] An efficient path index for querying semi-structured data (Extended abstract)
    Barg, M
    Wong, RK
    Lam, F
    WEB TECHNOLOGIES AND APPLICATIONS, 2003, 2642 : 89 - 94
  • [33] Querying and ranking incomplete twigs in probabilistic XML
    Liu, Jian
    Ma, Z. M.
    Yan, Li
    WORLD WIDE WEB-INTERNET AND WEB INFORMATION SYSTEMS, 2013, 16 (03): : 325 - 353
  • [34] Querying and ranking incomplete twigs in probabilistic XML
    Jian Liu
    Z. M. Ma
    Li Yan
    World Wide Web, 2013, 16 : 325 - 353
  • [35] Skyline queries over incomplete data streams
    Weilong Ren
    Xiang Lian
    Kambiz Ghazinour
    The VLDB Journal, 2019, 28 : 961 - 985
  • [36] A Framework for Identifying Skylines over Incomplete Data
    Alwan, Ali A.
    Ibrahim, Hamidah
    Udzir, Nur Izura
    3RD INTERNATIONAL CONFERENCE ON ADVANCED COMPUTER SCIENCE APPLICATIONS AND TECHNOLOGIES ACSAT 2014, 2014, : 79 - 84
  • [37] Quantitative association rules over incomplete data
    Ng, V
    Lee, J
    1998 IEEE INTERNATIONAL CONFERENCE ON SYSTEMS, MAN, AND CYBERNETICS, VOLS 1-5, 1998, : 2821 - 2826
  • [38] Skyline queries over incomplete data streams
    Ren, Weilong
    Lian, Xiang
    Ghazinour, Kambiz
    VLDB JOURNAL, 2019, 28 (06): : 961 - 985
  • [39] Optimizing skyline queries over incomplete data
    Lee, Jongwuk
    Im, Hyeonseung
    You, Gae-won
    INFORMATION SCIENCES, 2016, 361 : 14 - 28
  • [40] Querying temporal variable transportation data stream based on extended XQuery engine
    Gui, Zhiming
    Liao, Husheng
    GEOINFORMATICS 2007: GEOSPATIAL INFORMATION SCIENCE, PTS 1 AND 2, 2007, 6753