Skip to main content
SpringerLink
Log in

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

  • Conference paper
  • First Online:
Computer Aided Systems Theory — EUROCAST '91 (EUROCAST 1991)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 585))

Included in the following conference series:

  • 122 Accesses

Abstract

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 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 M.L.: Data Abstraction for Designing Databaseintensive Applications, in SIGPLAN Notices, Vol.16, No.1, Jan.1981.

    Google Scholar 

  3. CHEN P. P.: The Entity-Relationship Model: Towards a unified view of data, ACM TODS, Vol.1, No.1, 1976.

    Google Scholar 

  4. CODD E.F.: Extending the Database Relational Model to Capture More Meaning, ACM TODS, Vol.4, Nor.4, 1979.

    Google Scholar 

  5. 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 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 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 G.: Extending a Relational DBMS towards KBMS: A First Approach, Workshop on Knowledge Base Management Systems, Creta, June 1985

    Google Scholar 

  9. 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. 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. 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 G.: A Dynamic Database Design Method based on an Extended Relational Data Model, Ph.D. Thesis University of Vienna, 1986.

    Google Scholar 

  13. 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 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 C.H., SOLVBERG A.: Activity Modelling and Behaviour Modelling, in /OLLE 86/, pp.145–171.

    Google Scholar 

  16. 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. 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 T.W., SOL H.G., VERRIJN-STUART A.A. (eds.): Information Systems Design Methodologies: A Comparative Review, North-Holland, 1982.

    Google Scholar 

  19. 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 Corporation, Pro*C User's Guide, Belmont CA, 1987.

    Google Scholar 

  21. PETERSON J. L.: Petri Net Theory and the Modelling of Systems, Prentice Hall, 1981.

    Google Scholar 

  22. ROLLAND C.: The REMORA Methodology, in /OLLE 82/, pp.369–426.

    Google Scholar 

  23. 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 U., et al.: Towards Multi-Level and Modular Conceptual Schema Specifications, Information Systems, Vol.9, No.1, 1984 pp.43–57.

    Google Scholar 

  25. 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. 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. B. Stroustrup, The C++ Programming Language, Addison-Wesley 1986.

    Google Scholar 

  28. 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 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. R. S. Wiener, L. J. Pinson, An Introduction to Object-Oriented Programming and C++, Addison-Wesley, 1988.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. FAW Forschungsinstitut für Anwendungsorientierte Wissensverarbeitung, Johannes Kepler Universität Linz, Altenbergerstraße 69, A-4040, Linz, Vienna, Austria

    Christian Gierlinger, A Min Tjoa & Roland R. Wagner

Authors
  1. Christian Gierlinger
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. A Min Tjoa
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Roland R. Wagner
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Franz Pichler Roberto Moreno Díaz

Rights and permissions

Reprints and permissions

Copyright information

© 1992 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Gierlinger, C., Min Tjoa, A., Wagner, R.R. (1992). A methodology for computer aided modelling of information systems based on the extended entity relationship model BIER. In: Pichler, F., Díaz, R.M. (eds) Computer Aided Systems Theory — EUROCAST '91. EUROCAST 1991. Lecture Notes in Computer Science, vol 585. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0021044

Download citation

  • DOI: https://doi.org/10.1007/BFb0021044

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-55354-0

  • Online ISBN: 978-3-540-47034-2

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation