Integrating the ER Approach in an OO Environment

We translate Entity-Relationship (ER) schemas into the object-oriented specification language TROLL light. This language describes the Universe of Discourse (UoD) as a system of concurrently existing and interacting objects, i.e., an object community. Thereby two essential aspects, structure and behavior, are integrated in one formalism. By doing the translation from ER to TROLL light we preserve the visual advantages of the former and receive a formalism through the latter which can be mapped to an adequate object-oriented database system. Proceeding this way we hope our proposal for transforming ER schemas into TROLL light specifications provides a valuable link between structural and dynamic modeling.

[1]  Arie Segev,et al.  TOODM - A Temporal Object-Oriented Data Model with Temporal Constraints , 1991, ER.

[2]  Serge Abiteboul,et al.  IFO: a formal semantic database model , 1987, TODS.

[3]  James Geller,et al.  "Part" Relations for Object-Oriented Databases , 1992, ER.

[4]  Martin Gogolla,et al.  Towards a semantic view of an extended entity-relationship model , 1991, TODS.

[5]  François Banciihon Object-oriented database systems , 1988, PODS 1988.

[6]  Michael Schrefl,et al.  USING AN OBJECT-ORIENTED DIAGRAM TECHNIQUE FOR THE DESIGN OF INFORMATION SYSTEMS , 1991 .

[7]  Bernhard Thalheim,et al.  Extending the Entity-Relationship Model for a High-Level, Theory-Based Database Design , 1990, East/West Database Workshop.

[8]  Hank G. Sol,et al.  Dynamic Modelling of Information Systems , 1991 .

[9]  Jack A. Orenstein,et al.  The ObjectStore database system , 1991, CACM.

[10]  Toby J. Teorey,et al.  Database modeling and design: the entity-relationship approach , 1990 .

[11]  Gunter Saake,et al.  Formal Specification of Object Systems , 1991, TAPSOFT, Vol.2.

[12]  Martin Gogolla,et al.  A Calculus for an Extended Entity-Relationship Model Incorporating Arbitrary Data Operations and Aggregate Functions , 1988, International Conference on Conceptual Modeling.

[13]  Serge Abiteboul,et al.  IFO: A Formal Semantic Database Model , 1987, ACM Trans. Database Syst..

[14]  Cristina Sernadas,et al.  Object-Oriented Specification of Databases: An Algebraic Approach , 1987, VLDB.

[15]  Elisa Bertino,et al.  Object-Oriented Database Systems , 1993 .

[16]  Gerti Kappel,et al.  BIER - The Behaviour Integrated Entity Realtionship Approach , 1986, ER.

[17]  Erich J. Neuhold,et al.  A Data Type Approach to the Entity-Relationship Approach , 1979, ER.

[18]  Uwe Hohenstein,et al.  Automatic Transformation of an Entity-Relationship Query Language into SQL , 1989, ER.

[19]  Ramez Elmasri,et al.  The Category Concept: An Extension to the Entity-Relationship Model , 1985, Data Knowl. Eng..

[20]  Martin Gogolla,et al.  TROLL light: A Core Language for Specifying Objects , 1992 .

[21]  Uwe Hohenstein,et al.  A Language for Specifying Static and Dynamic Integrity Constraints , 1991, International Conference on Conceptual Modeling.

[22]  Setrag Khoshafian,et al.  Object identity , 1986, OOPSLA 1986.

[23]  Martin Gogolla,et al.  Towards Reliable Information Systems: The KorSo Approach , 1993, CAiSE.

[24]  Shamkant B. Navathe,et al.  Conceptual Database Design: An Entity-Relationship Approach , 1991 .

[25]  Michael Schrefl,et al.  Object/behavior diagrams , 1991, [1991] Proceedings. Seventh International Conference on Data Engineering.

[26]  Martin Gogolla,et al.  Sketching Concepts and Computational Model of TROLL light , 1993, DISCO.

[27]  Toby J. Teorey,et al.  The ORAC Model: A Unified View of Data Abstraction , 1991, ER.

[28]  Maurizio Lenzerini,et al.  INCOD: A System for Conceptual Design of Data and Transactions in the Entity-Relationship Model , 1981, ER.

[29]  Johann A. Makowsky,et al.  Entity-Relationship Consistency for Relational Schemas , 1986, ICDT.

[30]  Zahir Tari,et al.  On the design of object-oriented databases , 1992 .

[31]  T. J. Teorey,et al.  A logical design methodology for relational databases using the extended entity-relationship model , 1986, CSUR.

[32]  Branka Tauzovich,et al.  Towards Temporal Extensions to the Entity-Relationship Model , 1991, International Conference on Conceptual Modeling.

[33]  Henri Briand,et al.  From Entity-Relationship Diagram to an Object-Oriented Database , 1991, International Conference on Conceptual Modeling.

[34]  Roger King,et al.  Semantic database modeling: survey, applications, and research issues , 1987, CSUR.

[35]  Martin Gogolla,et al.  Conceptual modelling of database applications using extended ER model , 1992, Data Knowl. Eng..

[36]  Peter P. Chen The Entity-Relationship Model: Towards a unified view of Data , 1976 .

[37]  Peter P. Chen The entity-relationship model: toward a unified view of data , 1975, VLDB '75.