A methodology for interschema relationship identification in heterogeneous databases

V. Ramesh, Sudha Ram

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

4 Citations (Scopus)

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

Fingerprint

Schematic diagrams
Interoperability
Industry

ASJC Scopus subject areas

  • Engineering(all)

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

A methodology for interschema relationship identification in heterogeneous databases. / Ramesh, V.; Ram, Sudha.

Proceedings of the 28th Annual Hawaii International Conference on System Sciences, HICSS 1995. IEEE Computer Society, 1995. p. 263-272 375554 (Proceedings of the Annual Hawaii International Conference on System Sciences; Vol. 3).

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

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., 375554, Proceedings of the Annual Hawaii International Conference on System Sciences, vol. 3, IEEE Computer Society, pp. 263-272, 28th Annual Hawaii International Conference on System Sciences, HICSS 1995, Wailea, United States, 1/3/95. https://doi.org/10.1109/HICSS.1995.375554
Ramesh V, Ram S. A methodology for interschema relationship identification in heterogeneous databases. In Proceedings of the 28th Annual Hawaii International Conference on System Sciences, HICSS 1995. IEEE Computer Society. 1995. p. 263-272. 375554. (Proceedings of the Annual Hawaii International Conference on System Sciences). https://doi.org/10.1109/HICSS.1995.375554
Ramesh, V. ; Ram, Sudha. / A methodology for interschema relationship identification in heterogeneous databases. Proceedings of the 28th Annual Hawaii International Conference on System Sciences, HICSS 1995. IEEE Computer Society, 1995. pp. 263-272 (Proceedings of the Annual Hawaii International Conference on System Sciences).
@inproceedings{ea5d29ef241f47fba85a7cf5e3cbb732,
title = "A methodology for interschema relationship identification in heterogeneous databases",
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.",
author = "V. Ramesh and Sudha Ram",
year = "1995",
month = "1",
day = "1",
doi = "10.1109/HICSS.1995.375554",
language = "English (US)",
series = "Proceedings of the Annual Hawaii International Conference on System Sciences",
publisher = "IEEE Computer Society",
pages = "263--272",
booktitle = "Proceedings of the 28th Annual Hawaii International Conference on System Sciences, HICSS 1995",

}

TY - GEN

T1 - A methodology for interschema relationship identification in heterogeneous databases

AU - Ramesh, V.

AU - Ram, Sudha

PY - 1995/1/1

Y1 - 1995/1/1

N2 - 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.

AB - 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.

UR - http://www.scopus.com/inward/record.url?scp=0041740304&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=0041740304&partnerID=8YFLogxK

U2 - 10.1109/HICSS.1995.375554

DO - 10.1109/HICSS.1995.375554

M3 - Conference contribution

T3 - Proceedings of the Annual Hawaii International Conference on System Sciences

SP - 263

EP - 272

BT - Proceedings of the 28th Annual Hawaii International Conference on System Sciences, HICSS 1995

PB - IEEE Computer Society

ER -