Edinburgh Research Explorer

Automatically Merging Databases

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Related Edinburgh Organisations

Original languageEnglish
Title of host publicationProc IEEE Compcon Conference
PublisherInstitute of Electrical and Electronics Engineers (IEEE)
Number of pages8
Publication statusPublished - 1 Sep 1980


Using a semantic data model, a program has been developed that takes as input a set of assertions about two database schemas and generates a schema for their
union. This schema is then used for either a virtual or physical representation of the original databases. In the case of a virtual merge, queries against the merged
databases are automatically decomposed. In the case of a physical merge, the data transfer programs are automatically generated. In either case, integrity constraints may be automatically generated to enforce consistency in places where the two databases contain overlapping information. The problem is the converse of providing '"user views": given two subschemas, what "super-schema" contains both?

ID: 10624027