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 条
  • [41] Fuzzy querying of incomplete, imprecise, and heterogeneously structured data in the relational model using ontologies and rules
    Buche, P
    Dervin, C
    Haernrnerlé, L
    Thomopoulos, R
    IEEE TRANSACTIONS ON FUZZY SYSTEMS, 2005, 13 (03) : 373 - 383
  • [42] Presto-RDF: SPARQL Querying over Big RDF Data
    Mammo, Mulugeta
    Bansal, Srividya K.
    DATABASES THEORY AND APPLICATIONS, 2015, 9093 : 281 - 293
  • [43] Using punctuation schemes to characterize strategies for querying over data streams
    Tucker, Peter A.
    Maier, David
    Sheard, Tim
    Stephens, Paul
    IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2007, 19 (09) : 1227 - 1240
  • [44] Efficiently Computing and Querying Multidimensional OLAP Data Cubes over Probabilistic Relational Data
    Cuzzocrea, Alfredo
    Gunopulos, Dimitrios
    ADVANCES IN DATABASES AND INFORMATION SYSTEMS, 2010, 6295 : 132 - +
  • [45] OLAP over Probabilistic Data Cubes I: Aggregating, Materializing, and Querying
    Xie, Xike
    Hao, Xingjun
    Pedersen, Torben Bach
    Jin, Peiquan
    Chen, Jinchuan
    2016 32ND IEEE INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE), 2016, : 799 - 810
  • [46] Leveraging Currency for Repairing Inconsistent and Incomplete Data (Extended Abstract)
    Ding, Xiaoou
    Wang, Hongzhi
    Su, Jiaxuan
    Wang, Muxian
    Li, Jianzhong
    Gao, Hong
    2021 IEEE 37TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE 2021), 2021, : 2315 - 2316
  • [47] Graph Summarization for Source Selection of Querying over Linked Open Data
    Li, Junxian
    Wang, Wei
    PROCEEDINGS OF 2017 IEEE 2ND INFORMATION TECHNOLOGY, NETWORKING, ELECTRONIC AND AUTOMATION CONTROL CONFERENCE (ITNEC), 2017, : 357 - 362
  • [48] XML-extended OLAP querying
    Pedersen, D
    Riis, K
    Pedersen, TB
    14TH INTERNATIONAL CONFERENCE ON SCIENTIFIC AND STATISTICAL DATABASE MANAGEMENT, PROCEEDINGS, 2002, : 195 - 206
  • [49] Querying Sensor Networks with Extended SQL
    Sun, Jun-Zhao
    Zhou, Jiehan
    2010 IEEE INTERNATIONAL CONFERENCE ON WIRELESS COMMUNICATIONS, NETWORKING AND INFORMATION SECURITY (WCNIS), VOL 2, 2010, : 634 - +
  • [50] Exploratory Querying of Extended Knowledge Graphs
    Yahya, Mohamed
    Berberich, Klaus
    Ramanath, Maya
    Weikum, Gerhard
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2016, 9 (13): : 1521 - 1524