UPM Institutional Repository

Matching schemas of heterogeneous relational databases


Citation

Karasneh, Yaser Mohammad Ali and Ibrahim, Hamidah and Othman, Mohamed and Yaakob, Razali (2009) Matching schemas of heterogeneous relational databases. In: Second International Conference on the Applications of Digital Information and Web Technologies (ICADIWT 2009), 4-6 Aug. 2009, London, United Kingdom. (pp. 1-7).

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, "given two schemas, Si and Sj, find the most plausible correspondences between the elements of Si and S j, exploiting all available information, such as the schemas, instance data, and auxiliary sources" [24]. 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)
Matching schemas of heterogeneous relational databases.pdf

Download (35kB) | Preview

Additional Metadata

Item Type: Conference or Workshop Item (Paper)
Divisions: Faculty of Computer Science and Information Technology
DOI Number: https://doi.org/10.1109/ICADIWT.2009.5273926
Publisher: IEEE
Keywords: Schema matching; Heterogeneous relational databases; Schemas; Data integration
Depositing User: Nabilah Mustapa
Date Deposited: 03 Aug 2016 04:27
Last Modified: 03 Aug 2016 04:27
Altmetrics: http://www.altmetric.com/details.php?domain=psasir.upm.edu.my&doi=10.1109/ICADIWT.2009.5273926
URI: http://psasir.upm.edu.my/id/eprint/47992
Statistic Details: View Download Statistic

Actions (login required)

View Item View Item