UPM Institutional Repository

An approach for matching schemes of heterogeneous relational databases.


Citation

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

Abstract

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.


Download File

[img]
Preview
PDF (Abstract)
An approach for matching schemes of heterogeneous relational databases.pdf

Download (84kB) | Preview

Additional Metadata

Item Type: Article
Divisions: Faculty of Computer Science and Information Technology
Publisher: Digital Information Research Foundation
Keywords: Biomedical database; Database integration; Heterogeneous; Schema matching.
Depositing User: Ms. Nida Hidayati Ghazali
Date Deposited: 11 Feb 2014 01:01
Last Modified: 28 Sep 2015 00:10
URI: http://psasir.upm.edu.my/id/eprint/13017
Statistic Details: View Download Statistic

Actions (login required)

View Item View Item