IDEAS home Printed from https://ideas.repec.org/p/gro/rugsom/03a18.html
   My bibliography  Save this paper

Object-oriented modeling and design of database federations

Author

Listed:
  • Balsters, H.

    (Groningen University)

Abstract

We describe a logical architecture and a general semantic framework for precise specification of so-called database federations. A database federation provides for tight coupling of a collection of heterogeneous component databases into a global integrated system. Our approach to database federation integrates in a uniform and systematic manner the underlying database schemas of the component legacy systems to a separate, newly defined integrated database schema. This integrated database is completely virtual, and will constitute the actual federated database. That is, queries posed against the federated system will be posed against this virtual integrated database; these global queries will then be mapped by the mediator to actual local queries against the existing (legacy) component databases. Our approach is based upon the UML/OCL data model. UML is the de facto standard language for analysis and design in object-oriented frameworks, and is being employed more and more for analysis and design of Information systems, in particular information systems based on databases and their applications. Database specifications often involve specifications of constraints, and the Object Constraint Language (OCL) - as part of UML - can aid in the unambiguous modelling of database constraints. One of the central notions in database modelling and in constraint specifications is the notion of a database view; a database view closely corresponds to the notion of derived class in UML. We will employ OCL and the notion of derived class as a means to treat (inter-)database constraints and database views in a federated context. We will also offer a transaction model for a simple set of updates in database federations. The paper will demonstrate that our particular mediating system integrates component schemas without loss of constraint information. Furthermore, we will discuss a mapping of database specifications in terms of UML/OCL to the relational model.

Suggested Citation

  • Balsters, H., 2003. "Object-oriented modeling and design of database federations," Research Report 03A18, University of Groningen, Research Institute SOM (Systems, Organisations and Management).
    • Handle: RePEc:gro:rugsom:03a18
    as

    Download full text from publisher

    File URL: http://irs.ub.rug.nl/ppn/248286137
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. repec:dgr:rugsom:02a47 is not listed on IDEAS
    2. Balsters, H., 2002. "Derived classes as a basis for views in UML/OCL data models," Research Report 02A47, University of Groningen, Research Institute SOM (Systems, Organisations and Management).
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.

      More about this item

      Statistics

      Access and download statistics

      Corrections

      All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:gro:rugsom:03a18. See general information about how to correct material in RePEc.

      If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

      If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

      If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

      For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Hanneke Tamling (email available below). General contact details of provider: https://edirc.repec.org/data/ferugnl.html .

      Please note that corrections may take a couple of weeks to filter through the various RePEc services.

      IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.