Skip to main content
SpringerLink
Log in

Understanding and Representing Relationship Semantics in Database Design

  • Conference paper
  • First Online:
Natural Language Processing and Information Systems (NLDB 2000)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 1959))

Abstract

Much of the research that deals with understanding the real world and representing it in a conceptual model uses the entity-relationship model as a means of representation. Although the relationship construct is a very important part of this model, the semantics of relationship verbs are usually not considered in much detail, due, in part, to their generic nature. In this research, an ontology for classifying relationships based upon their verb phrases is proposed. The ontology is intended to serve as a useful part of database design methodologies to understand, capture, and refine the semantics of an application. Testing of the ontology on a number of cases illustrates its usefulness.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

6. Bibliography

  1. Bouzeghoub, M.,.“Using Expert Systems in Schema Design,” in Loucopoulos, P. and Zicari, R. (Eds.), Conceptual Modelling, Databases, and CASE, Wiley, 1992

    Google Scholar 

  2. Brachman, R.J. What IS-A is and isn’t: An analysis of taxonomic links insemantic networks, IEEE Computer, October, 1983.

    Google Scholar 

  3. Brodie, M., “Association: A Database Abstraction,” Proceedings of the Entity-Relationship Conference, 1981.

    Google Scholar 

  4. Goldstein, R.C., and Storey, V.C., “Materialization”, IEEE Transactions on Knowledge and Data Engineerig, Vol.6, No.5, October 1994, pp.835–842.

    Article  Google Scholar 

  5. Goldstein, R.C. and Storey, V.C., “Data Abstractions:.Why and How,” Data and Knowledge Engineering, Vol.29, No.3, 1999, pp. 1–18.

    Article  Google Scholar 

  6. Goldstein, R.C., and Storey, V.C., “Unravelling IS-A Structures,” Information Systems Research (ISR), Vol.3, No.2, June 1992, pp.99–126.

    Article  Google Scholar 

  7. Lloyd-Williams, M., “Exploiting Domain Knowledge During the Automated Design of Object-Oriented Databases,” Proceedings of the 16th International Conference on Conceptual Modeling (ER.97), Los Angeles, 3-6 November, 1997.

    Google Scholar 

  8. Motschnig-Pitrik, R., “A Generic Framework for the Modeling of Contexts and its Applications,” Data and Knowledge Engineering, Vol.32, 2000, pp.145–180.

    Article  MATH  Google Scholar 

  9. Motschnig-Pitrik, R. and Myloppoulos, J., “Class and Instances,” International Journal of Intelligent and Cooperative Systems, Vol1, No.1, 1992, pp.61–92.

    Article  Google Scholar 

  10. Motschnig-Pitrik, R. and Storey, V.C., “Modelling of Set Membership: the Notion and the Issues,” Data and Knowledge Engineering, Vol.16, August 1995.

    Google Scholar 

  11. Neches, R., Fikes, R.E., Finin, T., Gruber, T.R., Senator, T., and Swartout, W.R., “Enabling Technology for Knowledge Sharing, ” AI Magazine, Vol.12, No.3, 1991, pp.36–56.

    Google Scholar 

  12. Storey, V.C., “Understanding Semantic Relationships,” Very Large Data Bases (VLDB) Journal, Vol.2, No.4, October 1993, pp.455–488.

    Article  Google Scholar 

  13. Storey, V.C., Chiang, R., Dey, D., Goldstein, R.C., and Sundaresan, S., “Common Sense Reasoning and Learning for Database Design Systems,” ACM Transactions on Data Base Systems, Vol.22, No.4, December 1997.

    Google Scholar 

  14. Storey, V.C., Dey, D., Ullrich, H., and Sundaresan, S., “An Ontology-Based Expert System for Database Design,” Data and Knowledge Engineering, Special Issue: ER.97, 1998.

    Google Scholar 

  15. Storey, V.C. and Goldstein, R.C., “Knowledge-Based Approaches to Database Design,” Management Information Systems Quarterly, Vol.17, No.1, March, 1993, pp.25–46.

    Google Scholar 

  16. Storey, V.C. and Goldstein, R.C., “A Methodology for Creating User Views in Database Design,” ACM Transactions on Database Systems, Vol.13, No.3, September 1988, pp.305–338.

    Article  Google Scholar 

  17. Swartout, W., “Ontologies,” IEEE Intelligent Systems, January-February, 1999, pp.18–19.

    Google Scholar 

  18. Teorey, T.L., Yang, D., and Fry, J.P, “A Logical Design Methodology for Relational Databases using the Extended Entity-Relationship Approach,” ACM Computing Surveys, Vol.18, No.2, 1986, pp.197–222..

    Article  MATH  Google Scholar 

  19. Ullrich, H., Purao, S., and Storey, V.C., “An Ontology for Classifying the Semantics of Relationships in Database Design,” Proceedings of NLDB.2000, Versailles, 28-30 June 2000.

    Google Scholar 

  20. Whinston, M.E., Chaffin, R., and Hermann, D., “A Taxonomy of Part-Whole Relations,” Cognitive Science, Vol.11, 1987, pp.417–444.

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Dept. of Computer Information Systems J. Mack Robinson College of Business Administration, Georgia State University, P.O. Box 4015, 30302, Atlanta, Georgia, USA

    Veda C. Storey

Authors
  1. Veda C. Storey
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. PRiSM Laboratory, University of Versailles, 45 av.des Etats-Unis, 78035, Paris, France

    Mokrane Bouzeghoub  & Zoubida Kedad  & 

  2. CNAM, CEDRIC Laboratory, 292 rue Saint-Martin, 75003, Paris

    Elisabeth Métais

Rights and permissions

Reprints and permissions

Copyright information

© 2001 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Storey, V.C. (2001). Understanding and Representing Relationship Semantics in Database Design. In: Bouzeghoub, M., Kedad, Z., Métais, E. (eds) Natural Language Processing and Information Systems. NLDB 2000. Lecture Notes in Computer Science, vol 1959. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-45399-7_7

Download citation

  • DOI: https://doi.org/10.1007/3-540-45399-7_7

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-41943-3

  • Online ISBN: 978-3-540-45399-4

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation