Integrity constraint integration in heterogeneous databases: An enhanced methodology for schema integration

Venkatar Ramesh, Sudha Ram

Research output: Contribution to journalArticle

10 Scopus citations

Abstract

In today's technologically diverse corporate environment, it is common to find several different databases being used to accomplish the organization's operational data management functions. Providing interoperability among these databases is important to the successful operation of the organization. One approach to providing interoperability among heterogeneous database systems, is to define one or more schemas which represent a coherent view of the underlying databases. In the past, most approaches have used schematic knowledge about the underlying databases to generate integrated representations of the databases. In this paper we present a seven step methodology for utilizing integrity constraint knowledge from heterogeneous databases. Specifically, we describe how we can generate a set of integrity constraints applicable at the integrated level from constraints specified on local databases. We introduce the concept of constraint-based relationships between objects in heterogeneous databases and describe the role that these relationships play in integrity constraint integration. Finally, we describe how the integrated set of constraints generated using our methodology can be used to facilitate semantic query processing in a heterogeneous database environment.

Original languageEnglish (US)
Pages (from-to)423-446
Number of pages24
JournalInformation Systems
Volume22
Issue number8
DOIs
StatePublished - Dec 1997

Keywords

  • Heterogeneous database integration
  • Integrity constraints
  • Schema integration
  • Semantic query processing

ASJC Scopus subject areas

  • Software
  • Information Systems
  • Hardware and Architecture

Fingerprint Dive into the research topics of 'Integrity constraint integration in heterogeneous databases: An enhanced methodology for schema integration'. Together they form a unique fingerprint.

  • Cite this