Design and implementation of derived entities

  • Robert Winter
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 823)


To allow an utilization of database system trigger mechanisms and application generators for information systems implementation, entity derivation is introduced into the ER model as a semantic equivalent for derived tuples and derived attributes. The necessity of an open, reusable representation of data derivation in information systems engineering is discussed. A tool is presented that supports not only the semantic design of entity types, existential dependencies, and aggregation/generalization relationships, but also the design of derivation relationships. Based on three basic types of parametrical trigger declarations, the system specification created by the design tool can then be transformed automatically into database triggers by an object generator. Object generator design is presented, and the trigger parameter substitution process is described. Based on the design and implementation of a MRP II-style, complex production management system for a large mechanical engineering company, the benefits of the proposed extension of traditional, ER-based approaches to information systems design and implementation are discussed.


Entity Type Integrity Constraint Derivation Rule Capacity Usage Data Derivation 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Codd, E.F.: Extending the Database Relational Model to Capture More Meaning, ACM Transactions on Database Systems, 4 (1979), 3, 397–434CrossRefGoogle Scholar
  2. 2.
    Chen, P.P.: The Entity-Relationship Model — Toward a Unified View of Data, ACM Transactions on Database Systems, 1 (1976), 1, 9–36CrossRefGoogle Scholar
  3. 3.
    Sinz, E.J.: The Structured Entity-Relationship Model (SER-Model), Angewandte Informatik, 30 (1988), 5, 191–202 (in German)Google Scholar
  4. 4.
    Winter, R.: Generation of Individual Software for Distributed, Hierarchical Production Management Systems, in: Pappas, I.A. / I.P. Tatsiopoulos (Eds.): Advances in Production Management Systems, Amsterdam etc.: North-Holland 1993, 331–339Google Scholar
  5. 5.
    Peckham, J. / F. Maryanski: Semantic Data Models, ACM Computing Surveys, 20 (1988), 3, 153–189CrossRefGoogle Scholar
  6. 6.
    Adiba, M.: Derived Relations: A Unified Mechanism for Views, Snapshots and Distributed Data, Proceedings of the Seventh International Conference on Very Large Data Bases, Cannes, September 1981, 293–305Google Scholar
  7. 7.
    Stonebraker, M. / J. Anton / E. Hanson: Extending a Database System with Procedures, ACM Transactions on Database Systems, 12 (1987), 3, 350–376CrossRefGoogle Scholar
  8. 8.
    Oracle Corp.: PL/SQL User's Guide and Reference, Part No. 800-10-0691, 1991Google Scholar
  9. 9.
    Oracle Corp.: SQL Language Reference Manual Version 7.0, Part No. 778-70-0292, 1992Google Scholar
  10. 10.
    Martin, J. / J.J. Odell: Object-Oriented Analysis and Design, Englewood Cliffs: Prentice Hall 1992Google Scholar
  11. 11.
    Ferstl, O.K. / E.J. Sinz: Object-Oriented Modelling of Business Information Systems Using a Semantic Object Model (SOM), Wirtschaftsinformatik, 32 (1990), 6, 566–581 (in German)Google Scholar
  12. 12.
    Yourdon, E.: Modern Structured Analysis, Englewood Cliffs: Prentice Hall 1989Google Scholar
  13. 13.
    Innovative Software: OEW-The Object Engineering Workbench for C++, 2nd Ed., 1991Google Scholar
  14. 14.
    Barker, R.: CASE*Method — Tasks and Deliverables, Wokingham: Addison-Wesley 1990Google Scholar
  15. 15.
    Martin, J.: Fourth-Generation Languages, 3 Volumes, Englewood Cliffs: Prentice Hall 1985/86Google Scholar
  16. 16.
    Winter, R.: A Database Approach to Hierarchical Materials Planning, International Journal of Operations & Production Management, 10 (1990), 2, 62–83Google Scholar
  17. 17.
    Winter, R.: On the Utilization of an Active, Integrated Database for the Vertical Integration of Production Planning and Control, in: Doumeingts, G. / J. Browne / M. Tomljanovich (Eds.): Computer Applications in Production and Engineering, Amsterdam etc.: North-Holland 1991, 495–503Google Scholar
  18. 18.
    Winter, R. Application Development in a CIM Environment — The Changing Role of Humans and Computers, in: Olling, G.J. (Eds.): Human Aspects in Computer Integrated Manufacturing, Amsterdam etc.: North-Holland 1992, 465–473Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1994

Authors and Affiliations

  • Robert Winter
    • 1
  1. 1.Institut für WirtschaftsinformatikJohann Wolfgang Goethe-UniversitätFrankfurt am MainGermany

Personalised recommendations