A Methodology of Constructing Canonical Form Database Schemas in a Multiple Heterogeneous Database Environment

A Methodology of Constructing Canonical Form Database Schemas in a Multiple Heterogeneous Database Environment

Jeongseok Lim (University of Connecticut, USA) and Dong-Guk Shin (University of Connecticut, USA)
Copyright: © 1998 |Pages: 8
DOI: 10.4018/jdm.1998100101
OnDemand PDF Download:
$30.00
List Price: $37.50

Abstract

The Query Clearing House (QCH) model aims at achieving an ideal heterogeneous multiple database environment in which users can submit queries without concern for the location of the data or the specifics of the relevant database schemas. One important prerequisite for building such an environment is to organize local database schemas in a cohesive way so that a systematic method of determining data relevancy can be developed. In this paper, we propose a method for converting multiple local relational schemas into canonical form expressions. The resulting canonical form schema expressions include much more descriptive data semantics than what is offered by the original database schemas. These expressions also include information for mapping between the terms used in the canonical form expressions and their counterparts implemented in local databases. We include a number of examples illustrating how the canonical form schema expressions are produced.

Complete Article List

Search this Journal:
Reset
Open Access Articles
Volume 28: 4 Issues (2017)
Volume 27: 4 Issues (2016)
Volume 26: 4 Issues (2015)
Volume 25: 4 Issues (2014)
Volume 24: 4 Issues (2013)
Volume 23: 4 Issues (2012)
Volume 22: 4 Issues (2011)
Volume 21: 4 Issues (2010)
Volume 20: 4 Issues (2009)
Volume 19: 4 Issues (2008)
Volume 18: 4 Issues (2007)
Volume 17: 4 Issues (2006)
Volume 16: 4 Issues (2005)
Volume 15: 4 Issues (2004)
Volume 14: 4 Issues (2003)
Volume 13: 4 Issues (2002)
Volume 12: 4 Issues (2001)
Volume 11: 4 Issues (2000)
Volume 10: 4 Issues (1999)
Volume 9: 4 Issues (1998)
Volume 8: 4 Issues (1997)
Volume 7: 4 Issues (1996)
Volume 6: 4 Issues (1995)
Volume 5: 4 Issues (1994)
Volume 4: 4 Issues (1993)
Volume 3: 4 Issues (1992)
Volume 2: 4 Issues (1991)
Volume 1: 2 Issues (1990)
View Complete Journal Contents Listing