A Generic Model for 3-Dimensional Conceptual Modelling

Abstract This article discusses two highly intertwined issues. Firstly, we discuss the lack of top-down abstraction mechanisms in data modelling techniques; i.e. abstraction techniques that are fully integrated into the modelling technique and methodology and not just a ‘post-modelling process’ add on. Secondly, we are concerned with the integration of object-oriented modelling techniques and traditional data modelling techniques. We start by discussing the pragmatics and motivations behind these issues. Then, a formalisation of (the syntax and semantics of) a data modelling technique is presented that is a generalisation of (E)ER and ORM, and also adheres to the requirements of an object-oriented technique as laid down in the object-oriented manifesto. The result of this exercise is the so-called CDM Kernel. Furthermore, we briefly show how (E)ER, ORM and object-oriented views can be derived from models in the CDM Kernel. This effectively means that the CDM Kernel equates (E)ER, ORM and (some) object-oriented models. Finally, we briefly discuss some practical issues on the use of the facilities offered by the CDM Kernel in terms of modelling practice and tool support. A generalised conceptual modelling kernel will be very beneficial in the context of CASE Tool and in the context of federated database (information) systems.

[1]  Ramez Elmasri,et al.  Fundamentals of Database Systems , 1989 .

[2]  Henderik Alex Proper,et al.  A unifying object role modelling theory , 1995, Inf. Syst..

[3]  Terry Halpin,et al.  Conceptual Schema and Relational Database Design , 1995 .

[4]  Linda Campbell.  Adding a New Dimension to Flat Conceptual Modeling , 1994, ORM.

[5]  Michael Schrefl,et al.  Local Referential Integrity , 1992, ER.

[6]  Henderik Alex Proper,et al.  Subtyping and Polymorphism in Object-Role Modelling , 1995, Data Knowl. Eng..

[7]  Arthur H. M. ter Hofstede,et al.  A Category Theory Approach to Conceptual Data Modeling , 1996, RAIRO Theor. Informatics Appl..

[8]  Luca Cardelli,et al.  On understanding types, data abstraction, and polymorphism , 1985, CSUR.

[9]  Arthur H. M. ter Hofstede,et al.  A unifying framework for conceptual data modelling concepts , 1997, Inf. Softw. Technol..

[10]  Dirk Vermeir.  Semantic hierarchies and abstractions in conceptual schemata , 1983, Inf. Syst..

[11]  Arthur H. M. ter Hofstede,et al.  Uniquest: Determining the Semantics of Complex Uniqueness Constraints , 1992, Comput. J..

[12]  Olga De Troyer,et al.  ON modularity for conceptual data models and the consequences for subtyping, inheritance and overriding , 1993, Proceedings of IEEE 9th International Conference on Data Engineering.

[13]  Arthur H. M. ter Hofstede,et al.  Semantics and verification of object-role models , 1991, Inf. Syst..

[14]  Kim B. Bruce,et al.  An Algebraic Model of Subtype and Inheritance , 1990, DBPL.

[15]  David W. Embley,et al.  OO Systems Analysis: Is It or Isn't It? , 1995, IEEE Softw..

[16]  Robert Meersman,et al.  A Logic Framework for a Semantics of Object-Oriented Data Modeling , 1995, OOER.

[17]  D. Miller,et al.  Entity Model Clustering: Structuring A Data Model By Abstraction , 1986, Comput. J..

[18]  Setrag Khoshafian,et al.  Object identity , 1986, OOPLSA '86.

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

[20]  Peretz Shoval,et al.  Conceptual Design of Object-Oriented Database Schemas Using the Binary-Relationship Model , 1995, Data Knowl. Eng..

[21]  A.H.M. ter Hofstede,et al.  Information modelling in data intensive domains , 1993 .

[22]  PERETZ SHOVAL.  Essential information structure diagrams and database schema design , 1985, Inf. Syst..

[23]  William E. Lorensen,et al.  Object-Oriented Modeling and Design , 1991, TOOLS.

[24]  Peter N. Creasy,et al.  Two level NIAM: A way to get it object-oriented , 1994, Methods and Associated Tools for the Information Systems Life Cycle.

[25]  J. V. R. Wintraecken,et al.  The NIAM Information Analysis Method: Theory and Practice , 1990 .

[26]  Serge Abiteboul,et al.  Foundations of Databases , 1994 .

[27]  C. H. A. Koster.  On infinite modes , 1969, SIGP.

[28]  Michael Stonebraker,et al.  Third-generation database system manifesto , 1990, SGMD.

[29]  G. M. Nijssen,et al.  Conceptual schema and relational database design - a fact oriented approach , 1989 .

[30]  Olga De Troyer.  The OO-Binary Relationship Model: A Truly Object Oriented Conceptual Model , 1991, CAiSE.

[31]  Arthur H. M. ter Hofstede,et al.  Expressiveness in Conceptual Data Modelling , 1993, Data Knowl. Eng..

[32]  David J. DeWitt,et al.  The Object-Oriented Database System Manifesto , 1994, Building an Object-Oriented Database System, The Story of O2.

[33]  Fèlix Saltor,et al.  Suitability of datamodels as canonical models for federated databases , 1991, SGMD.

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

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

[36]  Atsushi Ohori,et al.  Orderings and Types in Databases , 1990, DBPL.

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

[38]  O. De.  A Logic Framework for a Semantics of Object Oriented Data Modelling , .

[39]  Linda Campbell,et al.  Abstraction techniques for Conceptual Schema , 1994, Australasian Database Conference.

[40]  Ehud Gudes,et al.  A new model for data base abstraction , 1982, Inf. Syst..

[41]  A.H.M. ter Hofstede,et al.  Deriving Identity from Extensionality , 1998, Int. J. Softw. Eng. Knowl. Eng..

[42]  Arthur H. M. ter Hofstede,et al.  Fact Orientation in Complex Object Role Modelling Techniques , 1994, ORM.

[43]  David Maier,et al.  Readings in Object-Oriented Database Systems , 1989 .

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

[45]  Henderik Alex Proper,et al.  Conceptual Schemas with Abstractions: Making Flat Conceptual Schemas More Comprehensible , 1996, Data Knowl. Eng..