Abstract
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.
Preview
Unable to display preview. Download preview PDF.
References
Codd, E.F.: Extending the Database Relational Model to Capture More Meaning, ACM Transactions on Database Systems, 4 (1979), 3, 397–434
Chen, P.P.: The Entity-Relationship Model — Toward a Unified View of Data, ACM Transactions on Database Systems, 1 (1976), 1, 9–36
Sinz, E.J.: The Structured Entity-Relationship Model (SER-Model), Angewandte Informatik, 30 (1988), 5, 191–202 (in German)
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–339
Peckham, J. / F. Maryanski: Semantic Data Models, ACM Computing Surveys, 20 (1988), 3, 153–189
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–305
Stonebraker, M. / J. Anton / E. Hanson: Extending a Database System with Procedures, ACM Transactions on Database Systems, 12 (1987), 3, 350–376
Oracle Corp.: PL/SQL User's Guide and Reference, Part No. 800-10-0691, 1991
Oracle Corp.: SQL Language Reference Manual Version 7.0, Part No. 778-70-0292, 1992
Martin, J. / J.J. Odell: Object-Oriented Analysis and Design, Englewood Cliffs: Prentice Hall 1992
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)
Yourdon, E.: Modern Structured Analysis, Englewood Cliffs: Prentice Hall 1989
Innovative Software: OEW-The Object Engineering Workbench for C++, 2nd Ed., 1991
Barker, R.: CASE*Method — Tasks and Deliverables, Wokingham: Addison-Wesley 1990
Martin, J.: Fourth-Generation Languages, 3 Volumes, Englewood Cliffs: Prentice Hall 1985/86
Winter, R.: A Database Approach to Hierarchical Materials Planning, International Journal of Operations & Production Management, 10 (1990), 2, 62–83
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–503
Winter, R. Application Development in a CIM Environment — The Changing Role of Humans and Computers, in: Olling, G.J. et.al. (Eds.): Human Aspects in Computer Integrated Manufacturing, Amsterdam etc.: North-Holland 1992, 465–473
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1994 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Winter, R. (1994). Design and implementation of derived entities. In: Elmasri, R.A., Kouramajian, V., Thalheim, B. (eds) Entity-Relationship Approach — ER '93. ER 1993. Lecture Notes in Computer Science, vol 823. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0024357
Download citation
DOI: https://doi.org/10.1007/BFb0024357
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-58217-5
Online ISBN: 978-3-540-48575-9
eBook Packages: Springer Book Archive