An approach for matching schemes of heterogeneous relational databases.
Schema matching is a basic problem in many database application domains, such as data integration. The problem of schema matching can be formulated as follows, ldquogiven two schemas, Si and Sj, find the most plausible correspondences between the elements of Si and Sj, exploiting all available infor...
| Main Authors: | , , , |
|---|---|
| Format: | Article |
| Language: | English English |
| Published: |
Digital Information Research Foundation
2010
|
| Online Access: | http://psasir.upm.edu.my/id/eprint/13017/ http://psasir.upm.edu.my/id/eprint/13017/1/An%20approach%20for%20matching%20schemes%20of%20heterogeneous%20relational%20databases.pdf |
| _version_ | 1848841995747852288 |
|---|---|
| author | Karasneh, Yaser Ibrahim, Hamidah Othman, Mohamed Yaakob, Razali |
| author_facet | Karasneh, Yaser Ibrahim, Hamidah Othman, Mohamed Yaakob, Razali |
| author_sort | Karasneh, Yaser |
| building | UPM Institutional Repository |
| collection | Online Access |
| description | Schema matching is a basic problem in many database application domains, such as data integration. The problem of schema matching can be formulated as follows, ldquogiven two schemas, Si and Sj, find the most plausible correspondences between the elements of Si and Sj, exploiting all available information, such as the schemas, instance data, and auxiliary sourcesrdquo. Given the rapidly increasing number of data sources to integrate and due to database heterogeneities, manually identifying schema matches is a tedious, time consuming, error-prone, and therefore expensive process. As systems become able to handle more complex databases and applications, their schemas become large, further increasing the number of matches to be performed. Thus, automating this process, which attempts to achieve faster and less labor-intensive, has been one of the main tasks in data integration. However, it is not possible to determine fully automatically the different correspondences between schemas, primarily because of the differing and often not explicated or documented semantics of the schemas. Several solutions in solving the issues of schema matching have been proposed. Nevertheless, these solutions are still limited, as they do not explore most of the available information related to schemas and thus affect the result of integration. This paper presents an approach for matching schemas of heterogeneous relational databases that utilizes most of the information related to schemas, which indirectly explores the implicit semantics of the schemas, that further improves the results of the integration. |
| first_indexed | 2025-11-15T07:52:06Z |
| format | Article |
| id | upm-13017 |
| institution | Universiti Putra Malaysia |
| institution_category | Local University |
| language | English English |
| last_indexed | 2025-11-15T07:52:06Z |
| publishDate | 2010 |
| publisher | Digital Information Research Foundation |
| recordtype | eprints |
| repository_type | Digital Repository |
| spelling | upm-130172015-09-28T00:10:10Z http://psasir.upm.edu.my/id/eprint/13017/ An approach for matching schemes of heterogeneous relational databases. Karasneh, Yaser Ibrahim, Hamidah Othman, Mohamed Yaakob, Razali Schema matching is a basic problem in many database application domains, such as data integration. The problem of schema matching can be formulated as follows, ldquogiven two schemas, Si and Sj, find the most plausible correspondences between the elements of Si and Sj, exploiting all available information, such as the schemas, instance data, and auxiliary sourcesrdquo. Given the rapidly increasing number of data sources to integrate and due to database heterogeneities, manually identifying schema matches is a tedious, time consuming, error-prone, and therefore expensive process. As systems become able to handle more complex databases and applications, their schemas become large, further increasing the number of matches to be performed. Thus, automating this process, which attempts to achieve faster and less labor-intensive, has been one of the main tasks in data integration. However, it is not possible to determine fully automatically the different correspondences between schemas, primarily because of the differing and often not explicated or documented semantics of the schemas. Several solutions in solving the issues of schema matching have been proposed. Nevertheless, these solutions are still limited, as they do not explore most of the available information related to schemas and thus affect the result of integration. This paper presents an approach for matching schemas of heterogeneous relational databases that utilizes most of the information related to schemas, which indirectly explores the implicit semantics of the schemas, that further improves the results of the integration. Digital Information Research Foundation 2010 Article PeerReviewed application/pdf en http://psasir.upm.edu.my/id/eprint/13017/1/An%20approach%20for%20matching%20schemes%20of%20heterogeneous%20relational%20databases.pdf Karasneh, Yaser and Ibrahim, Hamidah and Othman, Mohamed and Yaakob, Razali (2010) An approach for matching schemes of heterogeneous relational databases. Journal of Digital Information Management, 8 (4). pp. 260-269. ISSN 0972-7272 English |
| spellingShingle | Karasneh, Yaser Ibrahim, Hamidah Othman, Mohamed Yaakob, Razali An approach for matching schemes of heterogeneous relational databases. |
| title | An approach for matching schemes of heterogeneous relational databases. |
| title_full | An approach for matching schemes of heterogeneous relational databases. |
| title_fullStr | An approach for matching schemes of heterogeneous relational databases. |
| title_full_unstemmed | An approach for matching schemes of heterogeneous relational databases. |
| title_short | An approach for matching schemes of heterogeneous relational databases. |
| title_sort | approach for matching schemes of heterogeneous relational databases. |
| url | http://psasir.upm.edu.my/id/eprint/13017/ http://psasir.upm.edu.my/id/eprint/13017/1/An%20approach%20for%20matching%20schemes%20of%20heterogeneous%20relational%20databases.pdf |