Design and Implementation of Derived Entities
Series
Lecture Notes in Computer Science
ISBN
978-3-540-58217-5
Type
book section
Date Issued
1993
Author(s)
Editor(s)
Elmasri, Ramez A.
Kouramajian, Vram
Thalheim, Bernhard
Research Team
IWI1
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.
Language
German
HSG Classification
not classified
Refereed
No
Book title
Entity-Relationship Approach - ER `93 (Lecture Notes in Computer Science, Vol. 823)
Publisher
Springer
Publisher place
Berlin etc.
Volume
vol 823
Start page
60
End page
73
Pages
13
Event Title
Entity-Relationship Approach — ER '93
Event Location
Arlington, Texas, USA
Event Date
15.-17.12.1993
Subject(s)
Division(s)
Eprints ID
213804