Federation views as a basis for querying and updating database federations

H. Balsters and E.O. de Brock
Additional contact information
E.O. de Brock: Groningen University

No 03A34, Research Report from University of Groningen, Research Institute SOM (Systems, Organisations and Management)

Abstract: This paper addresses the problem of how to query and update so-called database federations. A database federation provides for tight coupling of a collection of heterogeneous component databases into a global integrated system. This problem of querying and updating a database federation is tackled by describing a logical architecture and a general semantic framework for precise specification of such database federations, with the aim to provide a basis for implementing a federation by means of relational database views. Our approach to database federations is based on the UML/OCL data model, and aims at the integration of the underlying database schemas of the component legacy systems to a separate, newly defined integrated database schema. One of the central notions in database modelling and in constraint specifications is the notion of a database view, which closely corresponds to the notion of derived class in UML. We will employ OCL (version 2.0) and the notion of derived class as a means to treat (inter-)database constraints and database views in a federated context. Our approach to coupling component databases into a global, integrated system is based on mediation. The first objective of our paper is to demonstrate that our particular mediating system integrates component schemas without loss of constraint information. The second objective is to show that the concept of relational database view provides a sound basis for actual implementation of database federations, both for querying and updating purposes.

Date: 2003
References: Add references at CitEc
Citations:

Downloads: (external link)
http://irs.ub.rug.nl/ppn/256388210 (application/pdf)
Our link check indicates that this URL is bad, the error code is: 404 Not Found (http://irs.ub.rug.nl/ppn/256388210 [302 Found]--> https://irs.ub.rug.nl/ppn/256388210 [302 Found]--> https://www.rug.nl/research/portal/publications/pub(62daaf43-5eff-4a67-b7ca-0b9cf8071032).html [301 Moved Permanently]--> https://research.rug.nl/en/publications/pub(62daaf43-5eff-4a67-b7ca-0b9cf8071032).html)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:gro:rugsom:03a34

Access Statistics for this paper

More papers in Research Report from University of Groningen, Research Institute SOM (Systems, Organisations and Management) Contact information at EDIRC.
Bibliographic data for series maintained by Hanneke Tamling ().