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

Venkatar Ramesh, Sudha Ram

Research output: Contribution to journalArticle

10 Citations (Scopus)

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
StatePublished - Dec 1997

Fingerprint

Interoperability
Data base
Integrity
Methodology
Query processing
Schematic diagrams
Information management
Semantics
Integrated
Data management

Keywords

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

ASJC Scopus subject areas

  • Management Information Systems
  • Management of Technology and Innovation
  • Hardware and Architecture
  • Information Systems
  • Software

Cite this

Integrity constraint integration in heterogeneous databases : An enhanced methodology for schema integration. / Ramesh, Venkatar; Ram, Sudha.

In: Information Systems, Vol. 22, No. 8, 12.1997, p. 423-446.

Research output: Contribution to journalArticle

@article{02bcd8c0f0c148d68a3a6ce11aff5d50,
title = "Integrity constraint integration in heterogeneous databases: An enhanced methodology for schema integration",
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.",
keywords = "Heterogeneous database integration, Integrity constraints, Schema integration, Semantic query processing",
author = "Venkatar Ramesh and Sudha Ram",
year = "1997",
month = "12",
language = "English (US)",
volume = "22",
pages = "423--446",
journal = "Information Systems",
issn = "0306-4379",
publisher = "Elsevier Limited",
number = "8",

}

TY - JOUR

T1 - Integrity constraint integration in heterogeneous databases

T2 - An enhanced methodology for schema integration

AU - Ramesh, Venkatar

AU - Ram, Sudha

PY - 1997/12

Y1 - 1997/12

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

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

KW - Heterogeneous database integration

KW - Integrity constraints

KW - Schema integration

KW - Semantic query processing

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

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

M3 - Article

AN - SCOPUS:0031370818

VL - 22

SP - 423

EP - 446

JO - Information Systems

JF - Information Systems

SN - 0306-4379

IS - 8

ER -