METHOD OF INTEGRATING SCHEMAS OF DISTRIBUTED HETEROGENEOUS DATABASES

摘要

A method for integrating the schemas of a plurality of independent and heterogeneous database management systems of a distributed database management system (DDBMS). The DDBMS includes a computer system in which the DDBMS resides and one or more subservient computer systems. The schemas of two of the independent database systems are fetched from the subservient computer systems. The schemas are converted from a relational database form to an object-oriented form. The schemas are then normalized and displayed graphically. Equivalencies are identified and the two schemas are integrated. These steps are repeated until the schemas of all databases to be integrated have been integrated into a single integrated, or global schema. The global schema is then converted from the object-oriented form to the relational form, and SQL commands are created to allow data from subservient databases to be obtained to create a virtual database residing in the host computer system satisfying the requirements of the global integrated schema.