Comparing relationships in conceptual modeling: mapping to semantic classifications

Much of the research that deals with understanding the real world and representing it in a conceptual model uses some form of the entity-relationship model as a means of representation. This research proposes an ontology for classifying relationship verb phrases based upon the domain and context of the application within which the relationship appears. The classification categories to which the verb phrases are mapped were developed based upon prior research in databases, ontologies, and linguistics. The usefulness of the ontology for comparing relationships when used in conjunction with an entity ontology is discussed. Together, these ontologies can be effective in comparing two conceptual database designs for integration and validation. Empirical testing of the ontology on a number of relationships from different application domains and contexts illustrates the usefulness of the research.

[1]  Veda C. Storey,et al.  An ontological analysis of the relationship construct in conceptual modeling , 1999, TODS.

[2]  Ye-Sho Chen,et al.  An entity-relationship approach to decision support and expert systems , 1988, Decis. Support Syst..

[3]  Ron Weber,et al.  Ontological foundations of information systems , 1997 .

[4]  Stefano Spaccapietra,et al.  Issues and approaches of database integration , 1998, CACM.

[5]  Veda C. Storey,et al.  Understanding semantic relationships , 1993, The VLDB Journal.

[6]  Douglas J. Herrmann,et al.  Developmental differences in the comprehension of semantic relations. With 1 figure , 1987, 1987.

[7]  Marianne Winslett.  C. Mohan speaks out: on R*, message queues, computer science in India, how ARIES came about, life as an IBM fellow, and more , 2004, SGMD.

[8]  Daniel E. O'Leary.  Impediments in the use of explicit ontologies for KBS development , 1997, Int. J. Hum. Comput. Stud..

[9]  James P. Davis,et al.  A framework for constructing visual knowledge specifications in acquiring organizational knowledge , 1991 .

[10]  Carole D. Hafner,et al.  The State of the Art in Ontology Design: A Survey and Comparative Review , 1997, AI Mag..

[11]  Michael N. Huhns,et al.  A Tool for Organizing Web Information , 1997, Computer.

[12]  David W. Embley,et al.  Conceptual-Model-Based Data Extraction from Multiple-Record Web Pages , 1999, Data Knowl. Eng..

[13]  Thomas R. Gruber,et al.  A translation approach to portable ontology specifications , 1993, Knowl. Acquis..

[14]  Jennifer Widom,et al.  A First Course in Database Systems , 1997 .

[15]  J. Searle.  Expression and Meaning: A taxonomy of illocutionary acts , 1975 .

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

[17]  Ron Weber,et al.  Conceptual Modelling and Ontology: Possibilities and Pitfalls , 2002, ER.

[18]  Zoubida Kedad,et al.  Dealing with Semantic Heterogeneity During Data Integration , 1999, ER.

[19]  Ronald J. Brachman,et al.  What IS-A Is and Isn't: An Analysis of Taxonomic Links in Semantic Networks , 1983, Computer.

[20]  Izak Benbasat,et al.  The Relative Importance of Structural Constraints and Surface Semantics in Information Modeling , 1997, Inf. Syst..

[21]  Michael L. Brodie.  Association: A Database Abstraction for Semantic Modelling , 1981, ER.

[22]  Nigel Shadbolt,et al.  Generalized directive models: integrating model development and knowledge acquisition , 1998, Int. J. Hum. Comput. Stud..

[23]  Ron Weber,et al.  Ontological Issues in Accounting Information Systems , 2002 .

[24]  C StoreyVeda,et al.  Knowledge-based approaches to database design , 1993 .

[25]  James Joseph Biundo,et al.  Analysis of Contingency Tables , 1969 .

[26]  James A. Hendler,et al.  Agents and the Semantic Web , 2001, IEEE Intell. Syst..

[27]  J. F. M. Burg,et al.  COLOR-X: Using Knowledge from WordNet for Conceptual Modeling , 1996 .

[28]  Peter P. Chen.  English, Chinese and ER Diagrams , 1997, Data Knowl. Eng..

[29]  Kathleen Dahlgren,et al.  Naive semantics for natural language understanding , 1988 .

[30]  Paul William Kuczora,et al.  Implementation of meronymic (part-whole) inheritance for semantic networks , 1989, Knowl. Based Syst..

[31]  R. Chaffin,et al.  An empirical taxonomy of part-whole relations: Effects of part-whole relation type on relation identification , 1988 .

[32]  Christiane Fellbaum,et al.  Color-X: Using Knowledge From Wordnet for Conceptual Modeling , 1998 .

[33]  Ee-Peng Lim,et al.  Accommodating instance heterogeneities in database integration , 2004, Decis. Support Syst..

[34]  George A. Miller,et al.  Introduction to WordNet: An On-line Lexical Database , 1990 .

[35]  Graeme G. Shanks,et al.  Representing part-whole relations in conceptual modeling: an empirical evaluation , 2008 .

[36]  Marti A. Hearst.  Trends & Controversies: Information integration , 1998, IEEE Intell. Syst..

[37]  Aviel D. Rubin,et al.  Security considerations for remote electronic voting , 2002, CACM.

[38]  Douglas Herrmann,et al.  A Taxonomy of Part-Whole Relations , 1987, Cogn. Sci..

[39]  Veda C. Storey,et al.  Data Abstractions: Why and How? , 1999, Data Knowl. Eng..

[40]  Kathleen Dahlgren,et al.  A linguistic ontology , 1995, Int. J. Hum. Comput. Stud..

[41]  Ronald D. Bonnell,et al.  A comprehensive conceptual analysis using ER and conceptual graphs , 1992, J. Exp. Theor. Artif. Intell..

[42]  John Mylopoulos,et al.  Information Modeling in the Time of the Revolution , 1998, Inf. Syst..

[43]  Michael L. Brodie.  On the Development of Data Models , 1982, On Conceptual Modelling.

[44]  Sandeep Purao,et al.  An Ontology for Classifying the Semantics of Relationships in Database Design , 2000, NLDB.

[45]  B. C. Vickery,et al.  Ontologies , 1997, J. Inf. Sci..

[46]  Austin Tate,et al.  Guest Editors' Introduction: Ontologies , 1999 .

[47]  Veda C. Storey,et al.  Improving database design through the analysis of relationships , 1999, TODS.

[48]  Veda C. Storey,et al.  An Ontology-Based Expert System for Database Design , 1998, Data Knowl. Eng..

[49]  Jeffrey Parsons,et al.  Effects of Local Versus Global Schema Diagrams on Verification and Communication in Conceptual Data Modeling , 2002, J. Manag. Inf. Syst..

[50]  Michael Gruninger,et al.  Ontology Applications and Design - Introduction. , 2002 .

[51]  James P. Davis,et al.  Modeling Semantics with Concept Abstraction in the EARL Data Model , 1989, ER.

[52]  Paul Johannesson,et al.  Classifying the Semantics of Relationships in Conceptual Modeling by Categorization of Roles , 2001, NLDB.

[53]  Veda C. Storey,et al.  Database design with common sense business reasoning and learning , 1997, TODS.

[54]  Nicola Guarino,et al.  Supporting ontological analysis of taxonomic relationships , 2001, Data Knowl. Eng..

[55]  Michael Gruninger,et al.  ONTOLOGY Applications and Design , 2002 .

[56]  Peter P. Chen.  The entity-relationship approach , 1993 .

[57]  Veda C. Storey,et al.  Modelling of set Membership: The Notion and the Issues , 1995, Data Knowl. Eng..

[58]  Ron Weber,et al.  Should Optional Properties Be Used in Conceptual Modelling? A Theory and Three Empirical Tests , 2001, Inf. Syst. Res..

[59]  Veda C. Storey,et al.  A Methodology for Learning Across Application Domains for Database Design Systems , 2002, IEEE Trans. Knowl. Data Eng..

[60]  David W. Embley,et al.  A Conceptual-Modeling Approach to Extracting Data from the Web , 1998, ER.

[61]  John F. Sowa,et al.  Conceptual Structures: Information Processing in Mind and Machine , 1983 .

[62]  Il-Yeol Song,et al.  A Taxonomy of Recursive Relationships and Their Structural Validity in ER Modeling , 1999, ER.

[63]  Yair Wand,et al.  Emancipating instances from the tyranny of classes in information modeling , 2000, TODS.

[64]  Renate Motschnig,et al.  A Generic Framework for the Modeling of Contexts and its Applications , 2000, Data Knowl. Eng..

[65]  Marianne Winslett.  Peter Chen speaks out: on paths to fame, the roots of the ER model in human language, the ER model in software engineering, the need for ER databases, and more , 2004, SGMD.

[66]  Peter P. Chen,et al.  Entity-Relationship Modeling : Historical Events , Future Trends , and Lessons Learned , 2002 .

[67]  John Mylopoulos,et al.  Classes and Instances , 1992, Int. J. Cooperative Inf. Syst..

[68]  D. Cruse.  On the transitivity of the part-whole relation , 1979, Journal of Linguistics.

[69]  Joachim Biskup,et al.  Extracting information from heterogeneous information sources using ontologically specified target views , 2003, Inf. Syst..

[70]  Nigel Shadbolt,et al.  The Use of Ontologies in a Decision Support System for Business Process Re-Engineering , 1998 .

[71]  James A. Hendler,et al.  The Semantic Web" in Scientific American , 2001 .

[72]  Ron Weber,et al.  Are Attributes Entities? A Study of Database Designers' Memory Structures , 1996, Inf. Syst. Res..