Exploring ER and RE syntax and semantics with metamodel object diagrams

  • Authors:
  • Martin Gogolla

  • Affiliations:
  • University of Bremen, Bremen, Germany

  • Venue:
  • MIS '05 Proceedings of the 2005 symposia on Metainformatics
  • Year:
  • 2005

Quantified Score

Hi-index 0.00

Visualization

Abstract

This paper explains how a metamodel transformation between two well-known database models work: Entity-Relationship (ER) database schemas are transformed into Relational (RE) database schemas hand in hand with the transformation of ER states into Relational states. The schemas determine the syntax of the datamodels, and the set of associated states fix the semantics of the datamodels. Often, when database models are considered, one formally only treats syntactical aspects, i.e., schemas, and handles the semantics, i.e., states, merely informally. Our approach formally handles syntax and semantics of database models and their transformation within a single, uniform framework. The approach thus precisely describes properties of the data-models and properties of the transformation. Our meta-model transformations do not simply convert ER schemas into Relational schemas, but they respect the semantics in a formal way and they can also be used the other way round in order to transfrom Relational schemas into ER ones. This opens the approach for re-engineering as well.