Applying ontologies in the integration of heterogeneous relational databases

  • Authors:
  • Adriana S. Aparício;Oscar L. M. Farias;Neide dos Santos

  • Affiliations:
  • Post-Graduation Program in Computer Engineering, Rio de Janeiro State University, Maracanã Rio de Janeiro, Brazil;Post-Graduation Program in Computer Engineering, Rio de Janeiro State University, Maracanã Rio de Janeiro, Brazil;Post-Graduation Program in Computer Engineering, Rio de Janeiro State University, Maracanã Rio de Janeiro, Brazil

  • Venue:
  • AOW '05 Proceedings of the 2005 Australasian Ontology Workshop - Volume 58
  • Year:
  • 2005

Quantified Score

Hi-index 0.00

Visualization

Abstract

Interoperability is a key point for integrating heterogeneous computing systems. A usual approach proposes the integration of the conceptual databases schemes into a global conceptual scheme, to resolve syntactic and structural heterogeneity. Moreover, semantic problems can remain. Ontologies have been largely designated to overcome semantic heterogeneity. We propose the specification of a formal ontology about the specific knowledge domain to be shared among several database systems build a posteriori of the ontology specification. We reach this integration through a global scheme, developed as a software layer among the databases under consideration. To test this approach we elaborated a case study, based upon hypothetical queries submitted to heterogeneous databases, with data on soil domain, to identify the soil most appropriate to a certain culture. The results are promising, but crucial, in our approach, is the acceptance for a given community of a common vocabulary and its relationships and that are captured by the ontology and transformed to the target conceptual models.