Comparing data modelling frameworks using Chisholm's ontology

Data modelling frameworks consist of a series of constructs which are used to create an abstraction of the world. Ontologies consist of concepts through which reality can be described. The aim of this paper is to use an ontology as a basis for comparing and evaluating data modelling frameworks. We begin by establishing a method for comparing modelling frameworks using ontology, and then examine the role ChisholmOs ontology can play in such a comparison. We then perform a comparison of three semantic data models: the EntityRelationship Model, the NIAM model, and the Functional Data Model. In undertaking the comparison we introduce ChisholmOs ontology, which is a new ontology in the Information Systems literature. ChisholmOs ontology has given us new insights into the role of attributes and into the changing nature of relationships, although in this paper we do not discuss the latter. All the data modelling methods supported the ontology to varying extents, with the Functional Data Model offering the best support. However we found that all the models lacked the full generality of ChisholmOs ontology. The disagreement between current data models and ChisholmOs ontology provides insight into the requirements for a truly flexible data modelling technique.

[1]  Ron Weber,et al.  On the deep structure of information systems , 1995, Inf. Syst. J..

[2]  Yair Wand,et al.  Theoretical foundations for conceptual modelling in information systems development , 1995, Decis. Support Syst..

[3]  B. Russell Mathematical Logic as Based on the Theory of Types , 1908 .

[4]  R. Chisholm A Realistic Theory of Categories: An Essay on Ontology , 1998 .

[5]  Louis Osgood Kattsoff Logic and the nature of reality , 1956 .

[6]  W. Neuman,et al.  Social Research Methods: Qualitative and Quantitative Approaches , 2002 .

[7]  Joan Peckham,et al.  Semantic data models , 1988, CSUR.

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

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

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

[11]  Yair Wand,et al.  Ontology as a foundation for meta-modelling and method engineering , 1996, Inf. Softw. Technol..

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

[13]  Jay Banerjee,et al.  Data model issues for object-oriented applications , 1987, TOIS.

[14]  Yair Wand,et al.  A Proposal for a Formal Model of Objects , 1989, Object-Oriented Concepts, Databases, and Applications.

[15]  M. Bunge Treatise on basic philosophy , 1974 .

[16]  David W. Shipman The functional data model and the data language DAPLEX , 1979, SIGMOD '79.

[17]  Ron Weber,et al.  An Ontological Model of an Information System , 1990, IEEE Trans. Software Eng..

[18]  Stanley B. Zdonik Object-oriented data model , 1990 .

[19]  Ron Weber,et al.  On the ontological expressiveness of information systems analysis and design grammars , 1993, Inf. Syst. J..

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

[21]  Roderick M. Chisholm,et al.  The Basic Ontological Categories , 1992 .

[22]  Jean-Dominique Dominique Warnier,et al.  Logical Construction of Systems , 1981 .