Local Schemas Modifications Propagation and Maintenance of Metadata in Multidatabase System

Abstract

One of the challenging problems in the multidatabase systems is to find the most viable solution to the problem of interoperability of distributed heterogeneous autonomous local component databases. This has resulted in the creation of a global schema over set of local component database schemas to provide a uniform representation of local schemas. The main objective of this paper is to maintain the Global Schema and the Global Directory/Dictionary/Metadata as the local schemas are autonomous and evolve over time. In this paper we consider uniform object-oriented data models which is used during integration of different heterogeneous distributed databases from different data models and proposed a framework to maintain an objected-oriented Global Schema in the multidatabase system.The Bottom up local schema modifications propagation in the Global schema is proposed and during this process the Global Directory/Dictionary/Metadata is maintained without manual intervention.

Use of Component Integration Services in Multidatabase Systems: A Feasible Solution for Integrating Academic Institutions or Commercial Industries

“…A variety of approaches to schema integration have been proposed. The main schema integration problem is associated with combining the diverse distributed local schemas of the different databases into a coherent global view by reconciling any structure or semantic conflicts between the local component databases [20]. Now, a crucial demand in the multidatabase system is how to maintain the schema structure of the multidatabase and all the remote distributed local databases, as all remote distributed local databases are autonomous and evolve over time, so that the schema of the multidatabase and all the remote distributed databases remains consistent and coherent.…”

“…Now, a crucial demand in the multidatabase system is how to maintain the schema structure of the multidatabase and all the remote distributed local databases, as all remote distributed local databases are autonomous and evolve over time, so that the schema of the multidatabase and all the remote distributed databases remains consistent and coherent. The issue has been addressed to a certain extent under the project entitled "Method and System for Local and Distributed Remote Schemas Structure Modifications, Propagation, and Maintenance of Metadata in Multidatabases and All Subsequent Locally Distributed Remote Databases" [21].…”

“…Creating and maintaining the global schema, which requires the use of database integration techniques (including schema mapping, correspondence investigation, and transformation of attributes in a similar format), is a critical issue in the multidatabase system. A variety of approaches to schema integration have been proposed, e.g., [16] [17] [19] [20] [23]- [29].…”