A methodology for interschema relationship identification in heterogeneous databases

V. Ramesh, S. Ram

Research output: Chapter in Book/Report/Conference proceedingConference contribution

4 Scopus citations

Abstract

Information sharing among databases, whether scientific or business, requires the development of techniques for accessing data from multiple heterogeneous databases. One approach to providing interoperability among these databases is to define one or more federated schemas which represent a coherent view of the underlying databases. A review of existing research on schema integration (the process of generating integrated schemas) points to the need for the development of techniques for identifying objects in multiple databases that may be related. This process of interschema relationship identification (IRI) is the focus of this paper. We present a methodology for utilizing schematic as well as integrity constraint knowledge for IRI. We present the details of a comprehensive set of heuristics for schematic IRI. We also introduce the concept of constraint-based relationships and describe how such relationships can be generated. Finally, we describe heuristics for generating "real world" interschema relationships based on the schematic and constraint-based relationships that are generated.

Original languageEnglish (US)
Title of host publicationProceedings of the 28th Annual Hawaii International Conference on System Sciences, HICSS 1995
PublisherIEEE Computer Society
Pages263-272
Number of pages10
ISBN (Electronic)0818669306
DOIs
StatePublished - Jan 1 1995
Event28th Annual Hawaii International Conference on System Sciences, HICSS 1995 - Wailea, United States
Duration: Jan 3 1995Jan 6 1995

Publication series

NameProceedings of the Annual Hawaii International Conference on System Sciences
Volume3
ISSN (Print)1530-1605

Conference

Conference28th Annual Hawaii International Conference on System Sciences, HICSS 1995
CountryUnited States
CityWailea
Period1/3/951/6/95

ASJC Scopus subject areas

  • Engineering(all)

Fingerprint Dive into the research topics of 'A methodology for interschema relationship identification in heterogeneous databases'. Together they form a unique fingerprint.

  • Cite this

    Ramesh, V., & Ram, S. (1995). A methodology for interschema relationship identification in heterogeneous databases. In Proceedings of the 28th Annual Hawaii International Conference on System Sciences, HICSS 1995 (pp. 263-272). [375554] (Proceedings of the Annual Hawaii International Conference on System Sciences; Vol. 3). IEEE Computer Society. https://doi.org/10.1109/HICSS.1995.375554