A semantic approach to discovering schema mapping expressions

被引:0
|
作者
An, Yuan [1 ]
Borgida, Alex [2 ]
Miller, Renre J. [1 ]
Mylopoulos, John [1 ]
机构
[1] Univ Toronto, Toronto, ON, Canada
[2] Rutgers State Univ, New Brunswick, NJ USA
关键词
D O I
暂无
中图分类号
TP3 [计算技术、计算机技术];
学科分类号
0812 ;
摘要
In many applications it is important to find a meaningful relationship between the schemas of a source and target database. This relationship is expressed in terms of declarative logical expressions called schema mappings. The more successful previous solutions have relied on inputs such as simple element correspondences between schemas in addition to local schema constraints such as keys and referential integrity. In this paper, we investigate the use of an alternate source of information about schemas, namely the presumed presence of semantics for each table, expressed in terms of a conceptual model (CM) associated with it. Our approach first compiles each CM into a graph and represents each table's semantics as a subtree in it. We then develop algorithms for discovering subgraphs that are plausible connections between those concepts/nodes in the CM graph that have attributes participating in element correspondences. A conceptual mapping candidate is now a pair of source and target subgraphs which are semantically similar At the end, these are converted to expressions at the database level. We offer experimental results demonstrating that, for test cases of non-trivial mapping expressions involving schemas from a number of domains, the "semantic" approach outperforms the traditional technique in terms of recall and especially precision.
引用
收藏
页码:181 / +
页数:2
相关论文
共 50 条
  • [1] A Case-Based Approach for Easing Schema Semantic Mapping
    Malherbe, Emmanuel
    Iwaszko, Thomas
    Aufaure, Marie-Aude
    [J]. CASE-BASED REASONING RESEARCH AND DEVELOPMENT, ICCBR 2015, 2015, 9343 : 228 - 243
  • [2] Schema-Based Mapping Approach for Data Transformation to Enrich Semantic Web
    Natarajan, Senthilselvan
    Vairavasundaram, Subramaniyaswamy
    Teekaraman, Yuvaraja
    Kuppusamy, Ramya
    Radhakrishnan, Arun
    [J]. Wireless Communications and Mobile Computing, 2021, 2021
  • [3] Mapping from XML DTD to semantic schema
    Rishe, N
    Yang, L
    Chekmasov, M
    Chekmasova, M
    Graham, S
    Roque, A
    [J]. 6TH WORLD MULTICONFERENCE ON SYSTEMICS, CYBERNETICS AND INFORMATICS, VOL VII, PROCEEDINGS: INFORMATION SYSTEMS DEVELOPMENT II, 2002, : 450 - 455
  • [4] Unsupervised Semantic Mapping for Healthcare Data Storage Schema
    Satti, Fahad Ahmed
    Hussain, Musarrat
    Hussain, Jamil
    Ali, Syed Imran
    Ali, Taqdir
    Bilal, Hafiz Syed Muhammad
    Chung, Taechoong
    Lee, Sungyoung
    [J]. IEEE ACCESS, 2021, 9 : 107267 - 107278
  • [5] Schema-based natural language semantic mapping
    Stratica, N
    Desai, BC
    [J]. NATURAL LANGUAGE PROCESSING AND INFORMATION SYSTEMS, 2004, 3136 : 103 - 113
  • [6] A semantic approach for discovering eGovernment services
    Tambouris, Efthimios
    Loutas, Nikolaos
    Peristeras, Vassilios
    Tarabanis, Konstantinos
    [J]. PROCEEDINGS OF THE 6TH WSEAS INTERNATIONAL CONFERENCE ON SYSTEM SCIENCE AND SIMULATION IN ENGINEERING (ICOSSSE '07): SYSTEM SCIENCE AND SIMULATION IN ENGINEERING, 2007, : 153 - +
  • [7] P2P Mapping Creation by Semantic Discovering and Mapping
    Zhou, Jingtao
    Yang, Haicheng
    Wang, Mingwei
    Mo, Rang
    [J]. NEW TRENDS AND APPLICATIONS OF COMPUTER-AIDED MATERIAL AND ENGINEERING, 2011, 186 : 631 - 635
  • [8] A Collective, Probabilistic Approach to Schema Mapping
    Kimmig, Angelika
    Memory, Alex
    Miller, Renee J.
    Getoor, Lise
    [J]. 2017 IEEE 33RD INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE 2017), 2017, : 921 - 932
  • [9] Semantic Web Information Retrieval in XML By Mapping To RDF Schema
    Phyue, Soe Lai
    Thein, Myint Myint
    Win, Thinn Thinn
    Thwin, Mie Mie Su
    [J]. 2010 INTERNATIONAL CONFERENCE ON NETWORKING AND INFORMATION TECHNOLOGY (ICNIT 2010), 2010, : 500 - 503
  • [10] RETRACTED: Schema-Based Mapping Approach for Data Transformation to Enrich Semantic Web (Retracted Article)
    Natarajan, Senthilselvan
    Vairavasundaram, Subramaniyaswamy
    Teekaraman, Yuvaraja
    Kuppusamy, Ramya
    Radhakrishnan, Arun
    [J]. WIRELESS COMMUNICATIONS & MOBILE COMPUTING, 2021, 2021