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...

Full description

Bibliographic Details
Main Authors: Ibrahim, Hamidah, Karasneh, Yaser Mohammad Ali, Mirabi, Meghdad, Yaakob, Razali, Othman, Mohamed
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