Integrity constraint integration in heterogeneous databases: An enhanced methodology for schema integration
作者:
Highlights:
•
摘要
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.
论文关键词:Integrity Constraints,Heterogeneous Database Integration,Semantic Query Processing,Schema Integration
论文评审过程:Received 18 July 1995, Revised 25 September 1997, Available online 11 March 1999.
论文官网地址:https://doi.org/10.1016/S0306-4379(97)00027-6