Student tutors for the course Data Modelling wanted (winter term 2021/22)

IT-Project Data Souvereignty in winter termin 2021/22

Business Intelligence: Washing Gold in Times of Information Overload

See all news.



You can find us here.

A Behavior Integrated Entity-Relationship Approach for the Design of Object-Oriented Databases

Authors: G. Kappel, M. Schrefl
Paper: Kapp89a (1989)
Citation: Carlo Batini (ed.): Proceedings of the 7th International Conference on Entity Relationship Approach (ER 1988): A Bridge to the User, Roma, Italy, November 16-18, 1988, North-Holland Publishing, ISBN 0-444-87453-4, pp. 311-328, 1989.
Resources: Copy  (In order to obtain the copy please send an email with subject  Kapp89a  to


Contrary to conventional databases the conceptual schema of an object-oriented database contains the description of the operations on the data next to the description of the structures of the data which are shared by several application programs. Therefore a design method for the conceptual schema of an object-oriented database must consider next to the structural aspects also the behavioral aspects of real world objects.

This paper presents such a method. It is based on the Behavior Integrated Entity Relationship Approach which considers the structural as well as the behavioral aspects of the real world objects to be modeled. The structural aspects are represented by different entity sets in an extended entity-relationship diagram. The behavioral aspects are represented by different activities which correspond to transitions in a entity-state/transition diagram.

The entity sets in the extended entity-relationship diagrams and the activities in the corresponding entity-state/transition diagram completely characterize the object classes of an object-oriented database. The data structures of the classes are given by the entity sets. The associated operations are determined by the respective activities. The public effects of the operations are defined by the pre- and poststates of the corresponding activities.