Understanding Semantic Relationships.

Veda C. Storey: Understanding Semantic Relationships. VLDB J. 2(4): 455-488(1993)
  author    = {Veda C. Storey},
  title     = {Understanding Semantic Relationships},
  journal   = {VLDB J.},
  volume    = {2},
  number    = {4},
  year      = {1993},
  pages     = {455-488},
  ee        = {db/journals/vldb/Storey93.html},
  bibsource = {DBLP,}


To develop sophisticated database management systems, there is a need to incorporate more understanding of the real world in the information that is stored in a database. Semantic data models have been developed to try to capture some of the meaning, as well as the structure, of data using abstractions such as inclusion, aggregation, and association. Besides these well-known relationships, a number of additional semantic relationships have been identified by researchers in other disciplines such as linguistics, logic, and cognitive psychology. This article explores some of the lesser-recognized semantic relationships and discusses both how they could be captured, either manually or by using an automated tool, and their implact on database design. To demonstrate the feasibility of this research, a prototype system for analyzing semantic relationships, called the Semantic Relationship Analyzer, is presented.

Copyright © 1993 by the VLDB Endowment. Permission to copy without fee all or part of this material is granted provided that the copies are not made or distributed for direct commercial advantage, the VLDB copyright notice and the title of the publication and its date appear, and notice is given that copying is by the permission of the Very Large Data Base Endowment. To copy otherwise, or to republish, requires a fee and/or special permission from the Endowment.

Key Words

Database design, entity-relationship model, relational model, semantic relationships, database design systems.

Online Paper

ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 4 Issue 1, Books, VLDB-j, TODS, ..." and ... DVD Version: Load ACM SIGMOD Anthology DVD 2" and ... BibTeX


[Blaha et al. 1988]
Michael R. Blaha, William J. Premerlani, James E. Rumbaugh: Relational Database Design Using an Object-Oriented Methodology. Commun. ACM 31(4): 414-427(1988) BibTeX
[Bouzeghoub et al. 1985]
Mokrane Bouzeghoub, Georges Gardarin, Elisabeth Métais: Database Design Tools: An Expert System Approach. VLDB 1985: 82-95 BibTeX
[Brachman 1983]
[Brodie 1981]
Michael L. Brodie: Association: A Database Abstraction for Semantic Modelling. ER 1981: 577-602 BibTeX
[Brodie 1984]
[Cauvet et al. 1988]
Corine Cauvet, C. Proix, Colette Rolland: Information System Design: An Expert System Approach. EDBT 1988: 113-133 BibTeX
[Chaffin & Herrmann 1988]
[Chaffin & Herrmann 1987]
[Chaffin & Herrmann 1984]
[Chaffin et al. 1988]
[Chen 1976]
Peter P. Chen: The Entity-Relationship Model - Toward a Unified View of Data. ACM Trans. Database Syst. 1(1): 9-36(1976) BibTeX
[Codd 1979]
E. F. Codd: Extending the Database Relational Model to Capture More Meaning. ACM Trans. Database Syst. 4(4): 397-434(1979) BibTeX
[Cruse 1986]
[Dahlgren 1988]
[Davis & Bonnell 1989]
James P. Davis, Ronald D. Bonnell: Modeling Semantics with Concept Abstraction in the EARL Data Model. ER 1989: 95-110 BibTeX
[Demo & Tilli 1986]
[Dogac et al. 1989]
Asuman Dogac, Birol Yürüten, Stefano Spaccapietra: A Generalized Expert System for Database Design. IEEE Trans. Software Eng. 15(4): 479-491(1989) BibTeX
[Dos Santos et al. 1980]
Clesio Saraiva dos Santos, Erich J. Neuhold, Antonio L. Furtado: A Data Type Approach to the Entity-Relationship Approach. ER 1979: 103-119 BibTeX
[Elmasri & Navathe 1989]
Ramez Elmasri, Shamkant B. Navathe: Fundamentals of Database Systems. Benjamin/Cummings 1989
[Evens 1988]
[Goldstein & Storey 1992]
[Goldstein & Storey 1991]
[Goldstein & Storey 1990]
[Hull & King 1987]
Richard Hull, Roger King: Semantic Database Modeling: Survey, Applications, and Research Issues. ACM Comput. Surv. 19(3): 201-260(1987) BibTeX
[Kawaguchi et al. 1986]
[Kim 1990]
Won Kim: Object-Oriented Databases: Definition and Research Directions. IEEE Trans. Knowl. Data Eng. 2(3): 327-341(1990) BibTeX
[Kuczora & Cosby 1989]
[Landis et al. 1987]
[Lloyd-Williams 1991]
[Maschtera 1987]
[Mattos 1988]
Nelson Mendonça Mattos: Abstraction Concepts: The Basis for Data and Knowledge Modeling. ER 1988: 473-492 BibTeX
[Mattos & Michels 1989]
Nelson Mendonça Mattos, M. Michels: Modeling with KRISYS: the Design Process of DB Applications Reviewed. ER 1989: 239-253 BibTeX
[Peckham & Maryanski 1988]
Joan Peckham, Fred J. Maryanski: Semantic Data Models. ACM Comput. Surv. 20(3): 153-189(1988) BibTeX
[Pitha 1972]
[Pitha 1971]
[Potter & Kerschberg 1988]
Walter D. Potter, Larry Kerschberg: A Unified Approach to Modeling Knowledge And Data. DS-2 1986: 265-291 BibTeX
[Potter & Trueblood 1988]
Walter D. Potter, Robert P. Trueblood: Traditional, Semantic, and Hyper-Semantic Approaches to Data Modeling. IEEE Computer 21(6): 53-63(1988) BibTeX
[Proix & Rolland 1988]
C. Proix, Colette Rolland: A Knowledge Base for Information System Design. DS-2 1986: 293-306 BibTeX
[Ram 1989]
[Reiter 1984]
[Rolland & Proix 1986]
[Schank & Abelson 1977]
[Schubert et al. 1983]
[Shaw 1984]
[Smith & Smith 1977]
John Miles Smith, Diane C. P. Smith: Database Abstractions: Aggregation and Generalization. ACM Trans. Database Syst. 2(2): 105-133(1977) BibTeX
[Storey 1988]
[Storey 1991a]
Veda C. Storey: Relational database design based on the Entity-Relationship model. Data Knowl. Eng. 7: 47-83(1991) BibTeX
[Storey 1991b]
[Storey 1992a]
[Storey 1992b]
[Storey 1993]
Veda C. Storey: A Selective Survey of the Use of Artificial Intelligence for Database Design Systems. Data Knowl. Eng. 11(1): 61-(1993) BibTeX
[Storey & Goldstein 1988]
Veda C. Storey, Robert C. Goldstein: A Methodology for Creating User Views in Database Design. ACM Trans. Database Syst. 13(3): 305-338(1988) BibTeX
[Storey & Goldstein 1990a]
[Storey & Goldstein 1990b]
[Storey & Goldstein 1993]
[Tauzovich 1989]
Branka Tauzovich: An Expert System for Conceptual Data Modelling. ER 1989: 205-220 BibTeX
[Teorey et al. 1986]
Toby J. Teorey, Dongqing Yang, James P. Fry: A Logical Design Methodology for Relational Databases Using the Extended Entity-Relationship Model. ACM Comput. Surv. 18(2): 197-222(1986) BibTeX
[Tsichritzis & Lochsovsky 1982]
[Ullman 1986]
[Urban & Delcambre 1986]
Susan Darling Urban, Lois M. L. Delcambre: An Analysis of the Structural, Dynamic, and Temporal Aspects of Semantic Data Models. ICDE 1986: 382-389 BibTeX
[Wagner 1989]
[Winston et al. 1987]
[Zoeppritz 1981]

Referenced by

  1. Manos Theodorakis, Anastasia Analyti, Panos Constantopoulos, Nicolas Spyratos: Contextualization as an Abstraction Mechanism for Conceptual Modelling. ER 1999: 475-489
  2. Remigijus Gustas: Integrated Approach for Modelling of Semantic and Pragmatic Dependencies of Information Systems. ER 1998: 121-134
  3. Dolors Costal, Antoni Olivé, Maria-Ribera Sancho: Temporal Features of Class Populations and Attributes in Conceptual Models. ER 1997: 57-70
  4. Roland Kaschek: Inheritance as a Conceptual Primitive. ER 1996: 406-421
  5. Robert C. Goldstein, Veda C. Storey: Materialization. IEEE Trans. Knowl. Data Eng. 6(5): 835-842(1994)
ACM SIGMOD Anthology - DBLP: [Home | Search: Author, Title | Conferences | Journals]
VLDB Journal: 1992-1995 Copyright © by VLDB Endowment / 1996-... Copyright © by Springer Verlag,
ACM SIGMOD Anthology: Copyright © by ACM (, Corrections:
DBLP: Copyright © by Michael Ley (, last change: Sun May 17 00:31:19 2009