An automatic domain independent schema matching in integrating schemas of heterogeneous relational databases
Schema matching is one of the key challenges in the process of integrating heterogeneous databases which identifies the correspondences among different elements of databases’ schemas. There are several semi-automatic schema matching algorithms, however these algorithms do not exploit most of the ava...
Main Authors: | , , , , |
---|---|
Format: | Article |
Language: | English |
Published: |
Institute of Information Science, Academia Sinica
2014
|
Online Access: | http://psasir.upm.edu.my/id/eprint/36395/1/An%20automatic%20domain%20independent%20schema%20matching%20in%20integrating%20schemas%20of%20heterogeneous%20relational%20databases.pdf |
_version_ | 1825948833321844736 |
---|---|
author | Ibrahim, Hamidah Karasneh, Yaser Mohammad Ali Mirabi, Meghdad Yaakob, Razali Othman, Mohamed |
author_facet | Ibrahim, Hamidah Karasneh, Yaser Mohammad Ali Mirabi, Meghdad Yaakob, Razali Othman, Mohamed |
author_sort | Ibrahim, Hamidah |
collection | UPM |
description | Schema matching is one of the key challenges in the process of integrating heterogeneous databases which identifies the correspondences among different elements of databases’ schemas. There are several semi-automatic schema matching algorithms, however these algorithms do not exploit most of the available information related to schemas during the process of schema matching which affects on the accuracy of schema matching result. In this paper, we proposed a domain independent schema matching approach which utilized both the structural and semantic information during the process of schema matching and offered database integration without user intervention. In order to ensure the correctness of our proposed approach, we provide a proof on the validation of our proposed approach in terms of maintaining the properties of the initial input schemas as well as the characteristics of the relational model. In comparison with previous approaches, our proposed approach produced better global schemas during integration process. |
first_indexed | 2024-03-06T08:35:12Z |
format | Article |
id | upm.eprints-36395 |
institution | Universiti Putra Malaysia |
language | English |
last_indexed | 2024-03-06T08:35:12Z |
publishDate | 2014 |
publisher | Institute of Information Science, Academia Sinica |
record_format | dspace |
spelling | upm.eprints-363952016-07-12T03:28:17Z http://psasir.upm.edu.my/id/eprint/36395/ An automatic domain independent schema matching in integrating schemas of heterogeneous relational databases Ibrahim, Hamidah Karasneh, Yaser Mohammad Ali Mirabi, Meghdad Yaakob, Razali Othman, Mohamed Schema matching is one of the key challenges in the process of integrating heterogeneous databases which identifies the correspondences among different elements of databases’ schemas. There are several semi-automatic schema matching algorithms, however these algorithms do not exploit most of the available information related to schemas during the process of schema matching which affects on the accuracy of schema matching result. In this paper, we proposed a domain independent schema matching approach which utilized both the structural and semantic information during the process of schema matching and offered database integration without user intervention. In order to ensure the correctness of our proposed approach, we provide a proof on the validation of our proposed approach in terms of maintaining the properties of the initial input schemas as well as the characteristics of the relational model. In comparison with previous approaches, our proposed approach produced better global schemas during integration process. Institute of Information Science, Academia Sinica 2014-09 Article PeerReviewed application/pdf en http://psasir.upm.edu.my/id/eprint/36395/1/An%20automatic%20domain%20independent%20schema%20matching%20in%20integrating%20schemas%20of%20heterogeneous%20relational%20databases.pdf Ibrahim, Hamidah and Karasneh, Yaser Mohammad Ali and Mirabi, Meghdad and Yaakob, Razali and Othman, Mohamed (2014) An automatic domain independent schema matching in integrating schemas of heterogeneous relational databases. Journal of Information Science and Engineering, 30 (4). pp. 1505-1536. ISSN 1016-2364 http://www.iis.sinica.edu.tw/page/jise/2014/201409_12.html |
spellingShingle | Ibrahim, Hamidah Karasneh, Yaser Mohammad Ali Mirabi, Meghdad Yaakob, Razali Othman, Mohamed An automatic domain independent schema matching in integrating schemas of heterogeneous relational databases |
title | An automatic domain independent schema matching in integrating schemas of heterogeneous relational databases |
title_full | An automatic domain independent schema matching in integrating schemas of heterogeneous relational databases |
title_fullStr | An automatic domain independent schema matching in integrating schemas of heterogeneous relational databases |
title_full_unstemmed | An automatic domain independent schema matching in integrating schemas of heterogeneous relational databases |
title_short | An automatic domain independent schema matching in integrating schemas of heterogeneous relational databases |
title_sort | automatic domain independent schema matching in integrating schemas of heterogeneous relational databases |
url | http://psasir.upm.edu.my/id/eprint/36395/1/An%20automatic%20domain%20independent%20schema%20matching%20in%20integrating%20schemas%20of%20heterogeneous%20relational%20databases.pdf |
work_keys_str_mv | AT ibrahimhamidah anautomaticdomainindependentschemamatchinginintegratingschemasofheterogeneousrelationaldatabases AT karasnehyasermohammadali anautomaticdomainindependentschemamatchinginintegratingschemasofheterogeneousrelationaldatabases AT mirabimeghdad anautomaticdomainindependentschemamatchinginintegratingschemasofheterogeneousrelationaldatabases AT yaakobrazali anautomaticdomainindependentschemamatchinginintegratingschemasofheterogeneousrelationaldatabases AT othmanmohamed anautomaticdomainindependentschemamatchinginintegratingschemasofheterogeneousrelationaldatabases AT ibrahimhamidah automaticdomainindependentschemamatchinginintegratingschemasofheterogeneousrelationaldatabases AT karasnehyasermohammadali automaticdomainindependentschemamatchinginintegratingschemasofheterogeneousrelationaldatabases AT mirabimeghdad automaticdomainindependentschemamatchinginintegratingschemasofheterogeneousrelationaldatabases AT yaakobrazali automaticdomainindependentschemamatchinginintegratingschemasofheterogeneousrelationaldatabases AT othmanmohamed automaticdomainindependentschemamatchinginintegratingschemasofheterogeneousrelationaldatabases |