A methodology for computer aided modelling of information systems based on the extended entity relationship model BIER

  • Christian Gierlinger
  • A Min Tjoa
  • Roland R. Wagner
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 585)


The Entity Relationship approach is used in many databases and information systems design methodology and tools. Its use is expanded to new types of applications and the ER-Model itself is being developed to meet new requirements based on the advanced modelling approach. In this paper we discuss the representation of static and dynamic aspects in information systems with an extended Entity-Relationship-Model Particular attention is given to a unified view of both aspects by a behaviour integrated Entity-Relationship Model.

A framework of modelling static components and dynamic processes in an information system is described. To model the static component we used an extended Entity-Relationship diagram and for the dynamic model we used a Petri net based graph representation.

A dynamic process will be decomposed into basic, elementary and complex activities Each elementary activity is bounded with one entity of a certain entity set.

Complex activities are defined as interface between at least two elementary processes which are identified by different entities.

The second part of the paper will describe a tool which is built on the basis of the methodology described above. The tool is implemented in C++ and ET++ on a Sparc Workstation. For the underlying database we use the commercially availabel database system Oracle.

The experiences with this tool show that the design of information systems can be supported in a very efficient manner and because of the integrity managementfacilities the schemas created are always tested on ther correctness. Furthermore the graphic method allows a stepwise extension of defined schemas.


data modelling dynamic aspects extended E-R diagram behaviour diagram 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. /APTKINSON 89/.
    M. Atkinson, F. Bancilhon, D. DeWitt, K. Dittrich, D. Maier, S. Zdonik, The object-oriented database system manifesto (a political pamphlet), Proc. DOOD 89, Kyoto, Japan, December 1989.Google Scholar
  2. /BRODIE 81/.
    BRODIE M.L.: Data Abstraction for Designing Databaseintensive Applications, in SIGPLAN Notices, Vol.16, No.1, Jan.1981.Google Scholar
  3. /CHEN 76/.
    CHEN P. P.: The Entity-Relationship Model: Towards a unified view of data, ACM TODS, Vol.1, No.1, 1976.Google Scholar
  4. /CODD 79/.
    CODD E.F.: Extending the Database Relational Model to Capture More Meaning, ACM TODS, Vol.4, Nor.4, 1979.Google Scholar
  5. /DITTRICH 90/.
    K. R. Dittrich, Object-oriented database systems: the next miles of the marathon, Information Systems, Vol. 15, No. 1, pp. 161–167, 1990.Google Scholar
  6. /ELMASRI 85/.
    ELMASRI R., WELLDREYER J., HEVNER A.: The Category Concept: An Extension to the Entity-Relationship Model Data and Knowledge Engineering, Vol.1, No.1, June 1985.Google Scholar
  7. /FERG 85/.
    FERG S.: Modelling the Time Dimension in an Entity-Relationship Diagram, Proc. 4th Int. Conf. on Entity-Relationship Approach (P.P. Chen, ed.), North Holland, 1985, pp. 280–286.Google Scholar
  8. /GARDARIN 85/.
    GARDARIN G.: Extending a Relational DBMS towards KBMS: A First Approach, Workshop on Knowledge Base Management Systems, Creta, June 1985Google Scholar
  9. /GIERLINGER 88/.
    Ch. Gierlinger, A M. Toja, R. R. Wagner, Die Entwicklung im Bereich der Datenbanken als Prozeß der Wissensverlagerung, in Statistik, Informatik, Ökonomie, Springer Verlag, Berlin, Heidelberg, 1988.Google Scholar
  10. /GIERLINGER 89/.
    Ch. Gierlinger, K. Reisinger, A M. Toja, R. R. Wagner: Update-Dependencies in Dynamic Data Models for Office Information Systems, International Conference on Organizations and Information Systems, Yugoslavia, Bled, Conf. Proc., 1989.Google Scholar
  11. /GIERLINGER 90/.
    Ch. Gierlinger, F. Kastner, R. R. Wagner, BIER '90, The Behavior Integrated Entity Relationship Model '90, in print in Bibliotheka Informatyki Szkol Wyzszych, Pub. M. Bazewicza, Wroclaw, Polen, 1990.Google Scholar
  12. /KAPPEL 86/.
    KAPPEL G.: A Dynamic Database Design Method based on an Extended Relational Data Model, Ph.D. Thesis University of Vienna, 1986.Google Scholar
  13. /KEMPER 90/.
    A. Kemper, P.C. Lockemann, G. Moerkotte, Future Database Technologie: Driving Forces and Directions, Lecture Notes in Computer Science, Vol 266, Database Systems of the 90s, pp15–33, Springer, Berlin 1990.Google Scholar
  14. /KLOPPROGGE 81/.
    KLOPPROGGE M.R.: TERM: An Approach to Include the Time Dimension in the Entity-Relationship Model, Proc. 2nd Int. Conf. on Entity-Relationship Approach (P.P. CHEN, ed.), North Holland, 1981, pp. 477–512.Google Scholar
  15. /KUNG 86/.
    KUNG C.H., SOLVBERG A.: Activity Modelling and Behaviour Modelling, in /OLLE 86/, pp.145–171.Google Scholar
  16. /MATTHES 90/.
    F. Matthes, J.W. Schmidt, Language Technology for Post-Relational Data Systems, Lecture Notes in Computer Science, Vol 266, Database Systems of the 90s, pp81–114, Springer, Berlin 1990.Google Scholar
  17. /MYLOPOULOS 80/.
    MYLOPOUOS J., WONG H.K.T.: Some Features of the Taxis Data Model, IEEE CH-1534-7/80/0000-0399, 1980.Google Scholar
  18. /OLLE 82/.
    OLLE T.W., SOL H.G., VERRIJN-STUART A.A. (eds.): Information Systems Design Methodologies: A Comparative Review, North-Holland, 1982.Google Scholar
  19. /OLLE 86/.
    OLLE T.W., SOL H.G., VERRIJN-STUART A.A. (eds.): Information Systems Design Methodologies: Improving the Practice, North-Holland, 1986.Google Scholar
  20. /ORACLE 87/.
    Oracle Corporation, Pro*C User's Guide, Belmont CA, 1987.Google Scholar
  21. /PETERSON 81/.
    PETERSON J. L.: Petri Net Theory and the Modelling of Systems, Prentice Hall, 1981.Google Scholar
  22. /ROLLAND 82/.
    ROLLAND C.: The REMORA Methodology, in /OLLE 82/, pp.369–426.Google Scholar
  23. /SAKAI 83/.
    SAKAI H.: A Method for Entity Relationship Behaviour Modelling, Entity-Relationship Approach to Software Engineering (eds. Davis C.G., et al.), North Holland, 1983.Google Scholar
  24. /SCHIEL 84/.
    SCHIEL U., et al.: Towards Multi-Level and Modular Conceptual Schema Specifications, Information Systems, Vol.9, No.1, 1984 pp.43–57.Google Scholar
  25. /SCHLAGETER 90/.
    G. Schlageter, R. Unland, Object-Oriented Database Systems: Concepts and Perspectives, Lecture Notes in Computer Science, Vol 266, Database Systems of the 90s, pp154–197, Springer, Berlin 1990.Google Scholar
  26. /SCHMID 90/.
    F.J. Schmied, H. Schukat, OMEN — An Object-Oriented Database Management System for Non-Standard Database Applications, Proc. DEXA 90, pp241–252, Springer, Vienna, 1990.Google Scholar
  27. /STROUSTRUP 86/.
    B. Stroustrup, The C++ Programming Language, Addison-Wesley 1986.Google Scholar
  28. /TJOA 85/.
    TJOA A M., WAGNER R.R.: Comparison of Dynamic Aspects in Semantic Data Modelling, Proc. Int. Conf. of Applied Informatics, 1985.Google Scholar
  29. /URBAN 86/.
    Urban S.D., DELCAMBRE L.M.L.: An Analysis of the Structural, Dynamic and Temporal Aspects of Semantic Data Models, Proc. 2nd Int. Conf. on Data Engineering, Los Angeles, 1986.Google Scholar
  30. /WIENER 88/.
    R. S. Wiener, L. J. Pinson, An Introduction to Object-Oriented Programming and C++, Addison-Wesley, 1988.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1992

Authors and Affiliations

  • Christian Gierlinger
    • 1
  • A Min Tjoa
    • 1
  • Roland R. Wagner
    • 1
  1. 1.FAW Forschungsinstitut für Anwendungsorientierte WissensverarbeitungJohannes Kepler Universität LinzLinz, ViennaAustria

Personalised recommendations