Issues and approaches of database integration

Abstract

In many large companies the widespread usage of computers has led a number of different application-specific databases to be installed. As company structures evolve, boundaries between departments move, creating new business units. Their new applications will use existing data from various data stores, rather than new data entering the organization. Henceforth, the ability to make data stores interoperable becomes a crucial factor for the development of new information systems.Data interoperability may come in various degrees. At the lowest level, commercial gateways connect specific pairs of database management systems (DBMSs). Software providing facilities for defining persistent views over different databases [6] simplifies access to distant data but does not support automatic enforcement of consistency constraints among different databases. Full interoperability is achieved by distributed or federated database systems, which support integration of existing data into virtual databases (i.e. databases which are logically defined but not physically materialized). The latter allow existing databases to remain under control of their respective owners, thus supporting a harmonious coexistence of scalable data integration and site autonomy requirements [9]. Federated systems are very popular today. However, before they become marketable, many issues remain to be solved. Design issues focus on either human-centered aspects (cooperative work, including autonomy issues and negotiation procedures) or database-centered aspects (data integration, schema/database evolution). Operational issues investigate system interoperability mainly in terms of support of new transaction types, new query processing algorithms, security concerns, etc. General overviews may be found elsewhere [4,9]. This paper is devoted to database integration, possibly the most critical issue. Simply stated, database integration is the process which takes as input a set of databases, and produces as output a single unified description of the input schemas (the integrated schema) and the associated mapping information supporting integrated access to existing data through the integrated schema. As such, database integration is also used in the process of re-engineering an existing legacy system.Database integration has attracted many diverse and diverging contributions. The purpose, and the main intended contribution of this article is to provide a clear picture of what are the approaches and the current solutions and what remains to be achieved. We focus on fundamental concepts and alternatives. We first give an example to provide a context for the rest of the paper. We then present the steps involved in developing an integrated schema (see Figure 1):• Pre-integration, where input schemas are transformed to make them more homogenous (both syntactically and semantically); homogenous (both syntactically and semantically);• Correspondence identification, devoted to the identification and description of interschema relationships; and • Integration, the fina...

An Evaluation of Multiple Approaches for Federating Biological Data

“…The goal of schema integration is to create a global view, by mapping away the structural and terminological differences between the component sites. Great effort has been devoted to this research area (Batini et al, 1986;DOAN et al, 2001;Elmagarmid and Pu, 1990;Larson et al, 1989;Parent and Spaccapietra, 1998). The main schema integration approaches include rule-based and machine-learning based, both of which can benefit from XML as the unifying data model.…”

SmartMatcher -- How Examples and a Dedicated Mapping Language can Improve the Quality of Automatic Matching Approaches

“…In the last decades a lot of contributions have been presented in the field of schema integration [3,10,13]. Based on those works, a lot of schema matching approaches have been built [14,19,18].…”

Implicit Hierarchical Meta-Modeling in Search of Flexible Inter-Operability for Manufacturing and Business Systems

“…The mapping between modeling languages and semantics are not at all times realized through the identity operation, and transformation functions sometimes are complex to define (Parent, 2000)(Arsanji, 1999).…”