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 条
  • [1] Querying incomplete data with logic programs:: ER strikes back
    Cali, Andrea
    CONCEPTUAL MODELING - ER 2007, PROCEEDINGS, 2007, 4801 : 245 - 260
  • [2] Querying incomplete information in semistructured data
    Kanza, Y
    Nutt, W
    Sagiv, Y
    JOURNAL OF COMPUTER AND SYSTEM SCIENCES, 2002, 64 (03) : 655 - 693
  • [3] Querying Conceptual Schemata with Expressive Equality Constraints
    Cali, Andrea
    Gottlob, Georg
    Pieris, Andreas
    CONCEPTUAL MODELING - ER 2011, 2011, 6998 : 161 - +
  • [4] Querying Incomplete Numerical Data: Between Certain and Possible Answers
    Console, Marco
    Libkin, Leonid
    Peterfreund, Liat
    PROCEEDINGS OF THE 42ND ACM SIGMOD-SIGACT-SIGAI SYMPOSIUM ON PRINCIPLES OF DATABASE SYSTEMS, PODS 2023, 2023, : 349 - 358
  • [5] Reasoning over extended ER models
    Artale, A.
    Calvanese, D.
    Kontchakov, R.
    Ryzhikov, V.
    Zakharyaschev, M.
    CONCEPTUAL MODELING - ER 2007, PROCEEDINGS, 2007, 4801 : 277 - +
  • [6] Querying over Heterogeneous and Distributed Data Sources
    Sokhn, Maria
    Mugellini, Elena
    Abou Khaled, Omar
    ADVANCES IN INTELLIGENT WEB MASTERING 3, 2011, 86 : 29 - 38
  • [7] PROBABILISTIC QUERYING OVER UNCERTAIN DATA STREAMS
    Dezfuli, Mohammad G.
    Haghjoo, Mostafa S.
    INTERNATIONAL JOURNAL OF UNCERTAINTY FUZZINESS AND KNOWLEDGE-BASED SYSTEMS, 2012, 20 (05) : 701 - 728
  • [8] Optimized querying of integrated data over the web
    Calì, A
    Calvanese, D
    ENGINEERING INFORMATION SYSTEMS IN THE INTERNET CONTEXT, 2002, 103 : 285 - 301
  • [9] Querying Recurrent Convoys over Trajectory Data
    Yadamjav, Munkh-Erdene
    Bao, Zhifeng
    Zheng, Baihua
    Choudhury, Farhana M.
    Samet, Hanan
    ACM TRANSACTIONS ON INTELLIGENT SYSTEMS AND TECHNOLOGY, 2020, 11 (05)
  • [10] An efficient SQL-based querying method to RDF schemata
    Falkowski, Maciej
    Jedrzejek, Czeslaw
    CONTROL AND CYBERNETICS, 2009, 38 (01): : 193 - 213