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 条
  • [21] Querying Historical Data Over Multiple Time-Lines
    Orgun, Mehmet A.
    MATHEMATICS IN COMPUTER SCIENCE, 2008, 2 (01) : 165 - 191
  • [22] Querying sliding windows over on-line data streams
    Golab, Lukasz
    Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), 2004, 3268 : 1 - 11
  • [23] A Demonstration of TripleProv: Tracking and Querying Provenance over Web Data
    Wylot, Marcin
    Cudre-Mauroux, Philippe
    Groth, Paul
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2015, 8 (12): : 1993 - 1996
  • [24] Querying large physics data sets over an information grid
    Baker, N
    Brooks, P
    Kovacs, Z
    Le Goff, JM
    McClatchey, R
    PROCEEDINGS OF CHEP 2001, 2001, : 663 - 667
  • [25] Panorama: A Data System for Unbounded Vocabulary Querying over Video
    Zhang, Yuhao
    Kumar, Arun
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2019, 13 (04): : 477 - 491
  • [26] Semantic Data Querying Over NoSQL Databases with Apache Spark
    Hassan, Mahmudul
    Bansal, Srividya K.
    2018 IEEE INTERNATIONAL CONFERENCE ON INFORMATION REUSE AND INTEGRATION (IRI), 2018, : 364 - 371
  • [27] Querying XML data over DHT system using XPeer
    Rao, WX
    Song, H
    Ma, FY
    GRID AND COOPERATIVE COMPUTING GCC 2004, PROCEEDINGS, 2004, 3251 : 559 - 566
  • [28] Querying sliding windows over on-line data streams
    Golab, L
    CURRENT TRENDS IN DATABASE TECHNOLOGY - EDBT 2004 WORKSHOPS, PROCEEDINGS, 2004, 3268 : 1 - 11
  • [29] SCHEMATA OVER LOCAL RINGS
    GREENBERG, M
    ANNALS OF MATHEMATICS, 1961, 73 (03) : 624 - &
  • [30] FORMAL SPECIFICATION OF A DATA DICTIONARY FOR AN EXTENDED ER DATA MODEL
    MISIC, V
    VELASEVIC, D
    LAZAREVIC, B
    COMPUTER JOURNAL, 1992, 35 (06): : 611 - 622