Schema coordination in federated database management : A comparison with schema integration

Research output: Journal Publications and Reviews (RGC: 21, 22, 62)21_Publication in refereed journalNot applicablepeer-review

View graph of relations

Author(s)

Detail(s)

Original languageEnglish
Pages (from-to)243-257
Journal / PublicationDecision Support Systems
Volume20
Issue number3
StatePublished - Jul 1997
Externally publishedYes

Abstract

We have introduced a new approach, termed schema coordination, as an alternative to the well-known schema integration approach for processing cooperative queries in federated database systems. The schema coordination approach is based on the attribute correspondence matrix that links similar attributes in all component databases. In this paper, we compare the schema coordination approach with the schema integration approach for both metadata management and cooperative query processing. We demonstrate that schema coordination offers a much simpler methodology that enables logical data independence and is especially better suited for database federations consisting of many competing databases with ever-evolving metadata. © 1997 Elsevier Science B.V.

Research Area(s)

  • Federated database systems, Metadata management, Multi-organizational information systems, Query translation, Schema coordination, Schema integration, Universal relation