Abstract
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 impact on database design. To demonstrate the feasibility of this research, a prototype system for analyzing semantic relationships, called the Semantic Relationship Analyzer, is presented.
Similar content being viewed by others
References
Blaha, M.R., Premerlani, W.J., and Rambaugh, J.E. Relational database design using an object-oriented methodology.Communications of the ACM, 31(4):414–427, 1988.
Bouzeghoub, M., Gardarin, G., and Metais, E. Database design tools: An expert system approach.Proceedings of the 11th International Conference on Very Large Databases, Stockholm, Sweden, 1985.
Brachman, R.J., What IS-A is and isn't: An analysis of taxonomic links in semantic networks.Computer, 16(10):30–36, 1983.
Brodie, M. Association: A database abstraction. In: Chen, P., ed.Approach to Information Modeling and Analysis. Amsterdam: North-Holland, 1981, pp. 583–608.
Brodie, M. On the development of data models. In: Brodie, M.L., Mylopoulos, J., and Schmidt, J.W., eds.On Conceptual Modelling. Berlin: Springer-Verlag, 1984, pp. 19–47.
Cauvet, C., Proix, C., and Rolland C. Information systems design: An expert system approach. In: Schmidt, J.W., Ceri, S., and Missikoff, M., eds.Advances in Database Technology: Proceedings of the International Conference on Extending Database Technology, In: Goss, G. and Hartmanis, J., eds.Lecture Notes in Computer Science, Berlin: Springer-Verlag, 1988, pp. 113–133.
Chaffin, R., and Herrmann, D.J. The nature of semantic relations: A comparison of two approaches. In: Evens, M., ed.Relational Models of the Lexicon: Representing Knowledge in Semantic Networks. New York: Cambridge University Press, 1988, pp. 289–334.
Chaffin, R., and Herrmann, D.J. Relation elementy theory: A new account of the representation and processing of semantic relations. In: Gorfein, D. and Hoffman, R., eds.Memory and Learning: The Ebbinghaus Centennial Conference. Hillsdale, N.J.: Lawrence Erlbaum Associates Inc., 1987. pp. 221–245.
Chaffin, R., and Herrmann, D.J. The similarity and diversity of semantic relations.Memory and Cognition, 13(2):134–141, 1984.
Chaffin, R., Herrmann, D.J., and Winston, M. An empirical taxonomy of part-whole relations: Effects of part-whole type on relation identification.Language and Cognitive Processes, 3(1):17–48, 1988.
Chen, P.P., The entity-relationship model: Toward a unified view of data.ACM Transactions On Database Systems, 1(1):9–36, 1976.
Codd, E.F. Extending the database relational model to capture more meaning.ACM Transactions on Database Systems, 4(4):397–434, 1979.
Cruse, D.A.Lexical Semantics, New York: Cambridge University Press, 1986.
Dahlgren, K.Naive Semantics for Natural Language Understanding. Boston, MA: Kluwer Academic Publishers, 1988.
Davis, J.P. and Bonnell, R.D. Modeling semantics with concept abstraction in the EARL data model,Proceedings of the Eighth International Conference on Entity-Relationship Approach, Toronto, Canada, 1989.
Demo, B. and Tilli, M. Expert system functionalities for database design tools. In: Sriram, D. and Adey, R., eds.Applications of Artificial Intelligence in Engineering Problems: Proceedings of the 1st International Conference, Southampton University. Berlin: Springer-Verlag, 1986, pp. 1073–1082.
Dogac, A., Yuruten, B., and Spaccapietra, S. A generalized expert system for database design.IEEE Transactions on Software Engineeering, 15(4):479–491, 1989.
Dos Santos, C.S., Neuhold, E.J., and Furtado, A.L.. A data-type approach to the entity- relationship model. In: Chen, P.P., ed.Proceedings of the Entity-Relationship Approach to Systems Analysis and Design. Amsterdam: North-Holland, 1980, pp. 103–119.
Elmasri, R. and Navathe, S.Fundamentals of Database Systems. City?: Benjamin/Cummings Publishing Co., Inc., 1989.
Evens, M. Introduction. In: Evens, M., ed.Relational Models of the Lexicon: Representing Knowledge in Semantic Networks. New York: Cambridge University Press, 1988, pp. 1–37.
Goldstein, R.C. and Storey, V.C. Unravelling Is-A structures.Information Systems Research, 3(2):99–126, 1992.
Goldstein, R.C. and Storey, V.C. Data Abstractions. Working Paper, University of Rochester, 1991.
Reiter, R. Towards a logical reconstruction of relational database theory. In: Brodie, M.L., Mylopoulos, J., and Schmidt, J.W., eds.On Conceptual Modelling. New York: Springer-Verlag, 1984, pp. 191–233.
Rolland, C. and Proix, C. An expert system approach to information system design. In: Kugler, H.J.Information Processing 86, City: Elsevier Science Publishers B.V. (North-Holland), 1986, pp. 241–250.
Schank, R.C. and Abelson, R.P.Scripts, Plans, Goals, and Understanding. Hillsdale, N.J.: Lawrence Erlbaum Associates Inc., 1977.
Schubert, L.K., Papalaskaris, M. A., and Taugher, J. Determining type, part, color, and time relationships.IEEE Computer, pp. 53–60, 1983.
Shaw, M. The impact of modelling and abstraction concerns on modern programming languages. In: Brodie, M.L., Mylopoulos, J., and Schmidt, J.W., eds.On Conceptual Modelling. New York: Springer-Verlag, 1984, pp. 49–83.
Smith, J.M. and Smith, C.P. Database abstractions: Aggregation and generalization.ACM Transactions on Database Management Systems, 2(2):105–133, 1977.
Storey, V.C. View creation: An expert system for database Design. Ph.D. Dissertation, Faculty of Commerce and Business Administration, University of British Columbia, Vancouver, Canada, Washington, D.C.: ICIT Press, 1988.
Storey, V.C. Relational database design based on the entity-relationship model.Data and Knowledge Engineering North-Holland, 7(1):47–83, 1991a.
Storey, V.C. Meronymic relationships.Journal of Database Administration, 2(3)22–35, 1991b.
Storey, V.C. Real world knowledge for databases.Journal of Database Administration, 3(1):1–19, 1992a.
Storey, V.C. Understanding semantic relationships: Theory and implementation. Technical Report, University of Rochester, 1992b.
Storey, V.C. The use of artificial intelligence methods for database design systems.Data and Knowledge Engineering, 1993, in press.
Storey, V.C. and Goldstein, R.C. A methodology for creating user views in database design.ACM Transactions on Database Systems, 13(3):305–338, 1988.
Storey, V.C. and R.C. Goldstein. Design and development of an expert database design system.International Journal of Expert Systems: Research and Applications, 3(1):31–63, 1990a.
Storey, V.C. and R.C. Goldstein. An expert view creation system for database design.Expert Systems Review, 2(3):19–45, 1990b.
Storey, V.C. and Goldstein, R.C. Knowledge-based approaches to database design.Management Information Systems Quarterly, 17(1):25–46, 1993.
Tauzovich, B. An expert system for conceptual data modelling.Proceedings of the Eighth International Conference on Entiry-Relationship Approach, Toronto, Canada, 1989.
Teorey, T.L., Yang, D., and Fry, J.P. A logical design methodology for relational databases using the extended entity-relationship model.Computing Surveys, 18(2), 1986.
Tsichritzis, D. and Lochovsky, F.Data Models. New York: Prentice-Hall, 1982.
Ullman, J. Discussion. In: Brodie, M.L. and Mylopoulos, J., eds.On Knowledge Base Management Systems, Berlin: Springer-Verlag, 1986, pp. 197–198.
Urban, S.D. and Delcambre, L.M.L. An analysis of the structural, dynamic, and temporal aspects of semantic data models.Proceedings of the International Conference on Data Engineering, 1986.
Wagner, C. View integration in database design, Ph.D. Dissertation, Faculty of Commerce and Business Administration, University of British Columbia, Vancouver, Canada, 1989.
Winston, M.E., Chaffin, R., and Herrmann, D. A taxonomy of part-whole relations.Cognitive Science, 11:417–444, 1987.
Zoeppritz, M. The meaning of OF and HAVE in the USL system.American Journal of Computational Linguistics, 7(2):109–119, 1981.
Author information
Authors and Affiliations
Rights and permissions
About this article
Cite this article
Storey, V.C. Understanding semantic relationships. VLDB Journal 2, 455–488 (1993). https://doi.org/10.1007/BF01263048
Received:
Revised:
Accepted:
Issue Date:
DOI: https://doi.org/10.1007/BF01263048