skip to main content
article
Free Access

Semantic database modeling: survey, applications, and research issues

Published:01 September 1987Publication History
Skip Abstract Section

Abstract

Most common database management systems represent information in a simple record-based format. Semantic modeling provides richer data structuring capabilities for database applications. In particular, research in this area has articulated a number of constructs that provide mechanisms for representing structurally complex interrelations among data typically arising in commercial applications. In general terms, semantic modeling complements work on knowledge representation (in artificial intelligence) and on the new generation of database models based on the object-oriented paradigm of programming languages.

This paper presents an in-depth discussion of semantic data modeling. It reviews the philosophical motivations of semantic models, including the need for high-level modeling abstractions and the reduction of semantic overloading of data type constructors. It then provides a tutorial introduction to the primary components of semantic models, which are the explicit representation of objects, attributes of and relationships among objects, type constructors for building complex types, ISA relationships, and derived schema components. Next, a survey of the prominent semantic models in the literature is presented. Further, since a broad area of research has developed around semantic modeling, a number of related topics based on these models are discussed, including data languages, graphical interfaces, theoretical investigations, and physical implementation strategies.

References

  1. AbB87 ABITEBOUL, S., AND BEERg, C. 1987. On the power of languages for the manipulation of complex objects (extended abstract). In Proceedings o{ International Workshop on Nested Relations and Complex Objects. (Darmstadt, Germany, Apr.). INRIA, Roquencourt, France.Google ScholarGoogle Scholar
  2. AbB84 ABITEBOUL, S., AND BIDOIT, N. 1986. Nonfirst normal form relations: An algebra allowing data restructuring. J. Cornput. Syst. Sci. 33, 361-393. Google ScholarGoogle Scholar
  3. AbH85 ABITEBOUL, S., AND HULL, R. 1985. Update propagation in the IFO database model. In Proceedings of the International Conference on Foundations of Data Organization. Organizing Committee of the international Conference on Foundations of Data Organization, c/o S. P. Ghosh, IBM Research, Almaden, Calif., pp. 243- 251.Google ScholarGoogle Scholar
  4. AbH86 ABITEBOUL, S. AND HULL, R. 1986. Restructuring of complex database objects and office forms. In Proceedings of the International Conference on Database Theory (Rome, Sept.). Google ScholarGoogle Scholar
  5. AbH87 ABITEBOUL, S., AND HULL, R. 1987. IFO: A formal semantic database model. A CM Trans. Database Syst. 12, 4 (Dec.), 525-565. Google ScholarGoogle Scholar
  6. Abr74 ABRiAL, J. R. 1974. Data semantics. Data Base Management. North-Holland, Amsterdam, pp. 1-59.Google ScholarGoogle Scholar
  7. AfM84 AFSARMANESH, H., AND MCLEOO, D. 1984. A framework for semantic database models. In Proceedings of the NYU Symposium on New Directions for Database Systems (New York, May 16-18). New York Univ., New York.Google ScholarGoogle Scholar
  8. Aik85 AIKENS, J. 1985. A representation scheme using both frames and rules. In Rule-Based Expert Systems, B. Buchanan and E. Shortliffe, Eds. Addison-Wesley, Reading, Mass., pp. 424- 440.Google ScholarGoogle Scholar
  9. ACO85 ALBANO, A., CARDELLI, L., AND ORSINI, R. 1985. Galileo: A strongly-typed, interactive conceptual language. A CM Trans. Database Syst. 10, 2 (June), 230-260. Google ScholarGoogle Scholar
  10. AOO85 ALBANO, A., OCCHIUTO, M. E., AND ORSINi, R. 1985. Galileo Reference Manual, VAX/UNIX Version 1.0. Tech. Rep. Dipartimento di Informatica, Univ. di Pisa, Pisa, italy.Google ScholarGoogle Scholar
  11. AnH87 ANDREWS, T., AND HARRIS, C. 1987. Combining language and database advances in an object-oriented development environment. In Proceedings of the A CM Conference on Object- Oriented Programming Systems, Languages and Applications (Oct.), pp. 430-440. Google ScholarGoogle Scholar
  12. AtB87 ATKINSON, M. P., AND BUNEMAN, O. P. 1987. Database programming languages, ACM Cornput. Surv. 19, 2 (June), 105-190. Google ScholarGoogle Scholar
  13. AtK83 ATKINSON, M. P., AND KULKARNi, K. G. 1983. Experimenting with the functional data model. Tech. Rep. Persistent Programming Research Rep. 5, Univ. of Edinburgh, Edinburgh, Scotland.Google ScholarGoogle Scholar
  14. AtP86 ATZENI, P., AND PARKER, D. S. 1986. Formal properties of net-based knowledge representation schemes. In Proceedings of the 2nd IEEE International Conference on Data Engineering. IEEE, New York, pp. 700-706. Google ScholarGoogle Scholar
  15. Bac78 BACKUS, J. 1978. Can programming be liberated from the Von Neumann style? A functional style and its algebra of programs. Commun. ACM 21, 8 (Aug.), 613-641. Google ScholarGoogle Scholar
  16. BLN86 BATINI, C., LENZERINI, M., AND NAVATHE, S. B. 1986. A comparative analysis of methodologies for Database schema integration. A CM Cornput. Surv. 18, 4 (Dec.), 323-364. Google ScholarGoogle Scholar
  17. BaK85 BATORY, D. S., ANO KIM, W. 1985. Modeling concepts for VLSI CAD objects. ACM Trans. Database Syst. 10, 3 (Sept.), 322-346. Google ScholarGoogle Scholar
  18. BBG BATORY, D. S., BARNETT, J. R., GARZA, F. F., SMITH, K. P., TSUKAUDA, K., TWICHELL, B. C., AND WIS~., T. E. 1988. GENESIS: A reconfigurable database management system. IEEE Trans. Softw. Eng. to appear. Google ScholarGoogle Scholar
  19. BKK86 BOBROW, D., KAHN, K., KICZALES, G., MASINTER, L., STEFIK, M., AND ZDYBEL, F. 1986. CommonLoops: Merging Lisp and objectoriented programming. In Proceedings of the A CM Conference on Object-Oriented Programruing Systems, Languages and Applications (Mar.). ACM, New York, pp. 17-29. Google ScholarGoogle Scholar
  20. Bor85 BORGIOA, A. 1985. Features of languages for the development of information systems at the conceptual level. IEEE Software 2, 1 (Jan.), 63-72.Google ScholarGoogle Scholar
  21. BPP76 BRACCHI, G., PAOLINI, P., AND PELA(~ATTI, G. 1976. Binary logical associations in data modelling. In Modelling in Data Base Management Systems. North Holland, Amsterdam, pp. 125-148.Google ScholarGoogle Scholar
  22. BrS85 BRACHMAN, R. J., ANO SCHMOLZE, J. G. 1985. An overview of the KL-ONE knowledge representation system. Cognitive Sct 9 (1985), 171-216.Google ScholarGoogle Scholar
  23. Bro84 BRODIE, M. L. 1984. On the development of data models. In On Conceptual Modelling, M. L. Brodie, J. Mylopoulos, and J. W. Schmidt, Eds. Springer-Verlag, New York, pp. 19-48.Google ScholarGoogle Scholar
  24. BrR84 BRODIE, M. L., AND RIDJANOVIC, D. 1984. On the design and specification of database transactions. In On Conceptual Modelling. Springer-Verlag, New York, pp. 277-306.Google ScholarGoogle Scholar
  25. BMS84 BRODIE, M. L., MYLOPOULOS, J., AND SCHMiDT, J. W. Eds. 1984. On Conceptual ModeUing. Springer-Verlag, New York.Google ScholarGoogle Scholar
  26. BrP83 BROWN, R., AND PARKER, D. S. 1983. LAURA: A formal data model and her logical design methodology. In Proceedings of the 9th International Conference on Very Large Data Bases. Very Large Database Endowment, Saratoga, Calif., pp. 206-218. Google ScholarGoogle Scholar
  27. BFN82 BUNEMAN, P., FRANKEL, R. E., ANO NIKHIL, R. 1982. An implementation technique for database query languages. A CM Trans. Database Syst. 7, 2 (June), 164-186. Google ScholarGoogle Scholar
  28. CDR86 CAREY, M. J., DEWITT, D. J., RICHARDSON, J. E., AND SHEKiTA, E. J. 1986. Object and file management in the EXODUS extensible database system. In Proceedings of the 12th International Conference on Very Large Databases (Aug.). Very Large Database Endowment, Saratoga, Calif., pp. 91-100. Google ScholarGoogle Scholar
  29. CGT75 CHAMBERLIN, D. D., GRAY, J. N., AND TRAIGER, I. L. 1975. Views, authorization and locking in a relational database system. In Proceedings of AFIPS National Computer Conference, vol. 44. AFIPS Press, Reston, VA., pp. 425-430.Google ScholarGoogle Scholar
  30. CDF83 CHAN, A., DAYAL, U., FOX, S., AND RIES, D. 1983. Supporting a semantic data model in a distributed database system. In Proceedings o/the 9th International Conference on Very Large Data Bases. Very Large Database Endowment, Saratoga, Calif., pp. 354-363. Google ScholarGoogle Scholar
  31. CDF82 CHAN, A., DANBERG, S., FOX, S. LIN, W. T. K., NORI, A., AND Rms, D. 1982. Storage and access structures to support a semantic data model, in Proceedings o/ the 8th International Con/erence on Very Large Data Bases. Very Large Database Endowment, Saratoga, Calif., pp. 122-130. Google ScholarGoogle Scholar
  32. Che76 CHEN, P. P. 1976. The entity-relationship model-Toward a unified view of data. A CM Trans. Database Syst. 1, 1 (Mar.), 9-36. Google ScholarGoogle Scholar
  33. Cod79 COOD, E. F. 1979. Extending the database relational model to capture more meaning. ACM Trans. Database Syst. 4, 4 (Dec.), 397-434. Google ScholarGoogle Scholar
  34. CoP84 COSMADAKIS, S. S., AND PAPADiMITRIOU, C. H. 1984. Updates of relational views. J. ACM 31, 4 (Oct.), 743-760. Google ScholarGoogle Scholar
  35. DDG85 DARDAILLER, P., DELOBEL, C., AND GIRAU- DIN, J. P. 1985. Modelisation progressive d'une base de donnees. Tech. Rep. 493, Laboratoire de Genie Informatique.Google ScholarGoogle Scholar
  36. Dat81 DATE, C. J. 1981. An Introduction to Database Systems, vol 1. Addison-Wesley, Reading, Mass. Google ScholarGoogle Scholar
  37. DaH84 DAYAL, U., AND HWANG, H. Y. 1984. View definition and generalization for database integration in a multidatabase system. IEEE Trans. Softw. Eng. SE-IO, 6, 628-644.Google ScholarGoogle Scholar
  38. DHP74 DEHENEFFE, C., HENNEBERT, H., AND PAULUS, W. 1974. Relational model for a data base. In Proceedings of the IFIP Congress, pp. 1022-1025.Google ScholarGoogle Scholar
  39. DKL85 DERRET'r, N., KENT, W., AND LYNGBAEK, P. 1985. Some aspects of operations in an object-oriented database, iEEE Database Eng. Bull. 8, 4 (Dec.).Google ScholarGoogle Scholar
  40. Fag77 FAC, XN, R. 1977. Multivalued dependencies and a new normal form for relation databases. ACM Trans. Database Syst. 2, 3 (Sept.), 262-278. Google ScholarGoogle Scholar
  41. FKM85 FARMER, D. B., KING, R., AND MYERS, D. A. 1985. The semantic database constructor. IEEE Tran So{tw. Eng. SE-11, 7, 583-591.Google ScholarGoogle Scholar
  42. FiK85 FIKES, R., AND KEHLER, T. 1985. The role of frame-based representation in reasoning. Commun. A CM 28, 9 (Sept.), 904-920. Google ScholarGoogle Scholar
  43. Fin79 FINDLER, N., Ed. 1979. Associative Networks. Academic Press, New York.Google ScholarGoogle Scholar
  44. FiT83 FISCHER, P., AND THOMAS, S. 1982. Operators for non-first-normal-form relations. In Proceedings of the 7th International Computer Software Applications Conference (Chicago, Nov.). IEEE, New York, pp. 464-475.Google ScholarGoogle Scholar
  45. Fog84 FO(~G, D. 1984. Lesson from a "Living in a database" graphical query interface. In Proceedings of the A CM SIGMOD International Conference on the Management of Data (Boston, Mass.). ACM, New York, pp. 100-106. Google ScholarGoogle Scholar
  46. FoD82 FOLEY, J. D., AND VAN DAM, A. 1982. Fundamentals of Interactive Computer Graphics. Addison-Wesley, Reading, Mass. Google ScholarGoogle Scholar
  47. GoR83 GOLDBERG, A., AND ROBSON, D. 1983. Smalltalk-80: The Language and its Implementation. Addison-Wesley, Reading, Mass. Google ScholarGoogle Scholar
  48. GGK85 GOLDMAN, K. J., GOLDMAN, $. A., KANEL- LAKIS, P. C., AND ZDONIK, S. B. 1985. ISIS: Interface for a semantic information system. In Proceedings of the A CM SIGMOD International Conference on the Management of Data. ACM, New York, pp. 328-342. Google ScholarGoogle Scholar
  49. Gut77 GUTTAG, J. 1977. Abstract data types and the development of data structures. Commun. ACM 20, 6 (June), 396-404. Google ScholarGoogle Scholar
  50. HaL74 HAINAUT, J. L., AND LECHARLIER, B. 1974. An extensible semantic model of database and its data language. In Proceedings of the IFIP Congress, pp. 1026-1030.Google ScholarGoogle Scholar
  51. HaB80 HAMMER, M., AND BERKOWITZ, B. 1980. DIAL: A programming language for data intensive applications. In Proceedings of the A CM SIGMOD International Conference on the Management of Data. ACM, New York, pp. 75-92. Google ScholarGoogle Scholar
  52. HaM81 HAMMER, M., AND McLEOD, D. 1981. Database description with SDM: A semantic database model. A CM Trans. Database Syst. 6, 3 (Sept.), 351-386. Google ScholarGoogle Scholar
  53. HeK81 HECHT, M. S., AND KERSCHBERG, L. 1981. Update semantics for the functional data model. Tech. Rep., Bell Laboratories, Holmdel, N.J.Google ScholarGoogle Scholar
  54. HuK86 HUDSON, S. E., AND KING, R. 1986. CACTIS: A database system for specifying functionally-defined data. In Proceedings of the Workshop on Object-Oriented Databases (Asilomar, Pacific Grove, Calif., Sept.). IEEE, New York. Google ScholarGoogle Scholar
  55. HuK87 HUDSON, S. E., AND KING, R. 1987. Object-oriented database support for software environments. In Proceedings of the A CM SIG- MOD International Conference on Management of Data (San Francisco, Calif., May). ACM, New York, pp. 491-503. Google ScholarGoogle Scholar
  56. Hul87 HULL, R. 1987. A survey of theoretical research on typed complex database objects. In Databases, J. Paredaens, Ed. Academic Press, London. Google ScholarGoogle Scholar
  57. HuY84 HULL, R., AND YAP, C. K. 1984. The format model: A theory of database organization. J. ACM 31, 3 (July), 518-537. Google ScholarGoogle Scholar
  58. IsB84 ISRAEL, D. J., AND BRACHMAN, R. J. 1984. Some remarks on the semantics of representation languages. In On Conceptual Modelling. Springer- Verlag, New York, pp. 119-146.Google ScholarGoogle Scholar
  59. JaS82 JAESCHKE, B., AND SCHEK, H. J. 1982. Remarks on the algebra of non first normal form relations. In Proceedings of the A CM Symposium on Principles o{ Database Systems. ACM, New York. Google ScholarGoogle Scholar
  60. KeC83 KEHLER, T. P., AND CLEMENSON, G. D. 1983. An application development system for expert systems. Syst. So{tw. 3, i (Jan.), 212-223.Google ScholarGoogle Scholar
  61. Ken78 KENT, W. 1978. Data and Reality. North- Holland, Amsterdam.Google ScholarGoogle Scholar
  62. Ken79 KENT, W. 1979. Limitations of recordbased information models. A CM Trans. Database Syst. 4, I (Mar.), 107-131. Google ScholarGoogle Scholar
  63. KeP76 KERSCHBERO, L., AND PACHECO, J. E. S. 1976. A functional data base model. Tech. Rep., Pontificia Univ. Catolica do Rio de Janeiro, Rio de Janeiro, Brazil.Google ScholarGoogle Scholar
  64. KKT76 KERSCHBERG, L., KLUO, A., AND TSI- CHRITZIS, D. 1976. A taxonomy of data models. In Systems for Large Data Bases. North-Holland, Amsterdam, pp. 43-64. Google ScholarGoogle Scholar
  65. KhC86 KHOSHAFIAN, S. N., AND COPELAND, G. P. 1986. Object identity. In Proceedings of the Conference on Object Oriented Programming Systems, Languages and Applications (Portland, Oreg., Sept.). ACM, New York, pp. 406-416. Google ScholarGoogle Scholar
  66. Kin84 KINO, R. 1984. Sembase: A semantic DBMS. In Proceedings o{ the First International Workshop on Expert Database Systems (Oct.). Univ. of Southern Carolina, Columbia, S.C., pp. 151-171.Google ScholarGoogle Scholar
  67. KiM82 KING, R., AND MCLEOD, D. 1982. The event database specification model. In Proceedings of the 2nd International Conference on Databases: Improving Usability and Responsiveness (Jerusalem, Israel), pp. 299-321.Google ScholarGoogle Scholar
  68. KiM84 KING, R., AND MCLEOD, D. 1984. A unified model and methodology for conceptual database design. In On Conceptual Modelling. Springer- Verlag, New York, pp. 313-331.Google ScholarGoogle Scholar
  69. KiM85a KZNG, R., ANO MCLEOD, D. 1985a. A database design methodology and tool for informarion systems. A CM Trans. Off. Inf. Syst. 3, 1 (Jan.), 2-21. Google ScholarGoogle Scholar
  70. KiM85b KING, R., ANO McLEoo, D. 1985b. Semantic database models, in Database Design. Springer-Verlag, New York, pp. 115-150.Google ScholarGoogle Scholar
  71. Kup85 KUPER, G. M. 1985. The logical data model: A new approach to database logic. Ph.D. dissertation, Computer Science Dept., Stanford Univ. Google ScholarGoogle Scholar
  72. KuV84 KUPER, G. M., AND VARDI, M. Y. 1984. The logical data model. In Proceedings of A CM SIGACT News-SIGMOD Symposium on Principles of Database Systems. ACM, New York, pp. 86-96.Google ScholarGoogle Scholar
  73. KuV85 KUPER, G. M., AND VARm, M. Y. 1985. On the expressive power of the logical data model (extended abstract). In Proceedings of the ACM SIGMOD International Conference on the Management of Data. ACM, New York. Google ScholarGoogle Scholar
  74. LaR82 LANOERS, T. A., ANO ROSENBERG, R. L. 1982. An overview of multibase. Distributed Databases. North-Holland, Amsterdam.Google ScholarGoogle Scholar
  75. Len87 LENZERINI, M. 1987. Covering and disjointness constraints in type networks. In Proceedings of the IEEE Conference on Data Engineering (Los Angeles, Calif.). IEEE, New York, pp. 386-393. Google ScholarGoogle Scholar
  76. LSA77 LIsKov, B., SNYOER, A., ATKINSON, R., AND SCXAFFERT, C. 1977. Abstraction mechanisms in CLU. Commun. ACM 20, 8 (Aug.), 564-576. Google ScholarGoogle Scholar
  77. LyK86 LYNGBAEK, P., ANO KENT, W. 1986. A data modeling methodology for the design and implementation of information In International Workshop on Object-Oriented Database Systems (Asilomar, Pacific Grove, Calif., Sept.). IEEE, New York. Google ScholarGoogle Scholar
  78. LyV87 LYNGBAEK, P., ANO VIANU, V. 1987. Mapping a semantic database model to the relational model. In Proceedings of the A CM SiG- MOD Conference on Management of Data (San Francisco, Calif., June). ACM, New York. Google ScholarGoogle Scholar
  79. Mac85 MACGREGOR, R. M. 1985. ARIEL--A semantic front-end to relational DBMSs In Proceedings of the 11th International Conference on Very Large Data Bases. Very Large Data Base Foundation, Saratoga, Calif., pp. 305-315.Google ScholarGoogle Scholar
  80. MSO86 MAmR, D., STEIN, j., OTIS, A., ANO PUROY, A. 1986. Development of an object-oriented DBMS. In Proceedings o{ the Conference on Object-Oriented Programming Systems, Languages, and Applications (Sept. 29-Oct. 2). ACM, New York, pp. 472-482. Google ScholarGoogle Scholar
  81. Mak77 MAKINOUCHI, A. 1977. A consideration on normal form of not-necessarily-normalized relation in the relational data model, in Proceedings of the 3rd International Conference on Very Large Databases (Tokyo, Oct.), pp. 447-453.Google ScholarGoogle Scholar
  82. MaD86 MANOLA, F., AND DAYAL, U. 1986. PDM: An object-oriented data model. In Proceedings of the Workshop on Object-Oriented Databases (Pacific Grove, Calif., Sept. 23-26). IEEE, New York, pp. 18-25. Google ScholarGoogle Scholar
  83. MaP86 MARYANSKI, F., AND PECKHAM, J. 1986. Semantic data models. Tech. Rep. CSTR 86-15, Dept. of Computer Science and Engineering, Univ. of Connecticut, Storrs, Conn.Google ScholarGoogle Scholar
  84. Min84 MINSKY, M. L. 1984. A framework for representing knowledge. In The Psychology o{ Computer Vision, P. H. Winston, Ed. McGraw-Hill, New York, pp. 211-277.Google ScholarGoogle Scholar
  85. Moo86 MOON, D. A. 1986. Object-oriented programming with flavors. In Proceedings o{ A CM Con{erence on Object-Oriented Programming Systems, Languages and Applications. ACM, New York, pp. 1-8. Google ScholarGoogle Scholar
  86. Myl80 MYLOPOULOS, g. 1980. An overview of knowledge representation. In Workshop on Data Abstract, Databases, and Conceptual Modelling (Pingree Park, Colo.). ACM, New York, pp. 5-12. Google ScholarGoogle Scholar
  87. MBW80 MYLOPOULOS, J., BERNSTEIN, P. A., AND WONG, H. K. T. 1980. A language facility for designing database-intensive applications. ACM Trans Database Syst. 5, 2 (June), 185-207. Google ScholarGoogle Scholar
  88. MBG86 MYLOPOULOS, J., BORGIDA, A., GREEN- SPAN, S., MEGHINI, C., AND NIXON, B. 1986. Knowledge representation in the software development process: A case study. Tech. Rep., Univ. of Toronto, Toronto, Canada.Google ScholarGoogle Scholar
  89. NEL86 NAVA?HE, S., ELMASRI, R., AND LARSON, J. 1986. Integrating user views in database design. IEEE Computer 19, 1, 50-62.Google ScholarGoogle Scholar
  90. Nik84 NIKHIL, R. 1984. An incremental, strongly typed applicative programming system for databases. Ph.D. dissertation, Dept. of Computer and Information Sciences, Univ. of Pennsylvania, Philadelphia.Google ScholarGoogle Scholar
  91. O'Y82 O'DUNLAING, C., AND YAP, C. K. 1982. Generic transformation of data structures, in Proceedings o{ the 23rd Annual IEEE Symposium on Foundations o{ Computer Science. IEEE, New York, pp. 186-195.Google ScholarGoogle Scholar
  92. Ris85 RISHE, N. 1985. Semantic modeling of data using binary schemata. Tech. Rep. TRCS85-06, Univ. of California, Santa Barbara, Calif.Google ScholarGoogle Scholar
  93. Ris86 RiSHE, N. 1986. On representation of medical knowledge by a binary data model. In Proceedings of the 5th International Conference on Mathematical ModeUing,X. J. R. Avula, G. Leitman, C. D. Mote, Jr., and E. Y. Rodin, Eds. Pergamon Press, Elmsford, N.Y.Google ScholarGoogle Scholar
  94. RoC87 ROGERS, T. R., AND CATTELL, g. G. G. 1987. Entity-relationship database user interfaces. Tech. Rep. Sun Microsystems, Mountain View, Calif.Google ScholarGoogle Scholar
  95. RoY84 ROUSSOPOULOS, N., AND YEH, R. T. 1984. An adaptable methodology for database design. IEEE Computer (May), 64-80.Google ScholarGoogle Scholar
  96. RoS79 ROWE, L., AND SCHOENS, K. A. 1979. Data abstractions, views, and updates in RIGEL. In Proceedings of the A CM SIGMOD International Con{erence on the Management of Data. ACM, New York, pp. 71-81. Google ScholarGoogle Scholar
  97. Sch80 SCHNEIDERMAN, B. 1980. So{tware Psychology: Human Factors in Computer and In/ormation Systems. Prentice-Hall, Englewood Cliffs, N.J. Google ScholarGoogle Scholar
  98. Sen75 SENKO, M. E. 1975. Information systems: Records, relations, set, entities, and things. In{. Syst. 1, 1, 3-13.Google ScholarGoogle Scholar
  99. Shi81 SHIPMAN, D. 1981. The functional data model and the data language DAPLEX. ACM Trans. Database Syst. 6, 1 (Mar.), 140-173. Google ScholarGoogle Scholar
  100. Sho82 SHOSHANI, A. 1982. Statistical databases: Characteristics, problems, and some solutions. In Proceedings o{ the 8th International Con{erence on Very Large Data Bases (Mexico City). Very Large Data Base Endowment, Saratoga, Calif., pp. 208-222. Google ScholarGoogle Scholar
  101. SiK77 SIBLEY, E. H., AND KERSCHBERG, L. 1977. Data architecture and data model considerations. In Proceedings o{ the National Computer Con{erence. AFIPS Press, Reston, Va., pp. 85-96.Google ScholarGoogle Scholar
  102. SmS77 SMITH, J. M., AND SMITH, D. C. P. 1977. Database abstractions: Aggregation and generalization. A CM Trans. Database Syst. 2, 2 (June), 105-133. Google ScholarGoogle Scholar
  103. SFL81 SMITH, J. M., FOx, S., AND LANDERS, T. 1981. Reference manual for ADAPLEX. Tech. Rep., Computer Corporation of America.Google ScholarGoogle Scholar
  104. SBD81 SMITH, J. M., BERNSTEIN, P. A., DAYAL, U., GOODMAN, N., LANDERS, T., LIN, K. W. T., AND WONG, E. 1981. Multibase-Integrating heterogeneous distributed database systems. In Proceedings o{ AFIPS National Computer Con{erence. AFIPS Press, Reston, Va., pp. 487-499. Google ScholarGoogle Scholar
  105. SBM83 STEFIK, M., BOBROW, D. G., MIq~AL, S., AND CONWA~, L. 1983. Knowledge programmini in LOOPS: Report on an experimental course. Arti{. InteU. 4, 3, 3-14.Google ScholarGoogle Scholar
  106. StR86 STONEBRAKER, M., AND ROWE, L. A. 1986. The design of postgres. In Proceedings of International Conference on the Management of Data (May). ACM, New York, pp. 340-355. Google ScholarGoogle Scholar
  107. SWK76 STONEBRAKER, M. R., WONG, E., KREPS, P., AND HELD, G. 1976. The design and implementation of INGRES. ACM Trans. Database Syst. 1, 3 (Sept.), 189-222. Google ScholarGoogle Scholar
  108. Su83 Su, S. Y. W. 1983. SAM*: A semantic association model for corporate and scientific statistical databases. Inf. Sci. 29, 151-199.Google ScholarGoogle Scholar
  109. Su86 Su, S. Y. W. 1986. Modeling integrated manufacturing data with SAM*. IEEE Computer Magazine (Jan.), 34-49.Google ScholarGoogle Scholar
  110. Su80 Su, S. Y. W., AND LO, D. H. 1980. A semantic association model for conceptual database design. In Entity-Relationship Approach to Systems Analysis and Design. North Holland, Amsterdam, pp. 147-171. Google ScholarGoogle Scholar
  111. SK88 Su, S. Y. W., KRISHNAMURTHY, V., AND LAM, H. 1988. An object-oriented semantic association model (OSAM*). In AI in Industrial Engineering and Manufacturing: Theoretical Issues and Applications, S. Kumara and R. L. Kashyap, Eds. American Institute of Industrial Engineers, Norcross, Ga.Google ScholarGoogle Scholar
  112. TYF86 TEOREY, T. g., YANG, D., AND FRY, J. P. 1986. A logical design methodology for relational databases using the extended entityrelationship model. ACM Comput Surv. 18, 2 (June), 197-222. Google ScholarGoogle Scholar
  113. TsK77 TSICHRITZIS, D., AND KLUG, A. C. 1977. American National Standards Institute/X3/ SPARC DBMS Framework: Report of the Study Group on Database Management Systems. AFIPS Press, Reston, Va.Google ScholarGoogle Scholar
  114. TsL82 TSICHRITZlS, D. C., AND LOCHOVSKY, F. H. 1982. Data Models. Prentice-Hall, Englewood Cliffs, N.J. Google ScholarGoogle Scholar
  115. TsZ84 TSUR, S., AND ZANIOLO, C. 1984. An implementation of GEM-Supporting a semantic data model on a relational back-end. In Proceedings of the A CM SIGMOD International Conference on the Management of Data. ACM, New York, pp. 286-295. Google ScholarGoogle Scholar
  116. Ull82 ULLMAN, J. D. 1982. Principles of Database Systems. 2nd ed. Computer Science Press, Rockville, MD. Google ScholarGoogle Scholar
  117. Ull87 ULLMAN, J. 1987. Database theory: Past and future. In Proceedings of A CM SIGACT News- SIGMOD-SIGART Principles of Database Systerns. (San Diego, Calif., Mar.). ACM, New York. Google ScholarGoogle Scholar
  118. UrD86 URBAN, S. D., AND DELCAMBRE, L. M. L. 1986. An analysis of the structural, dynamic, and temporal aspects of semantic data models. In Proceedings of the 2nd IEEE International Conference on Data Engineering (Feb.). IEEE, New York, pp. 382-389. Google ScholarGoogle Scholar
  119. VeB82 VERHEIJEN, G., AND BEKKUM, g. V. 1982. NIAM: An information analysis method. In Information Systems Design Methodologies: A Comparative Review, T. Otte, H. Sol and A. Verrijn-Stuart, Eds. IFIP.Google ScholarGoogle Scholar
  120. Via87 VIANU, V. 1987. Dynamic functional dependencies and database aging. J. ACM 34, 1 (Jan.), 28-59. Google ScholarGoogle Scholar
  121. Was79 WASSERMAN, A. I. 1979. The data management facilities of PLAIN. In Proceedings of the A CM SIGMOD International Conference on the Management of Data. ACM, New York. Google ScholarGoogle Scholar
  122. WiE80 WIEOERHOLD, G., ANO EL-MASRI, R. 1980. Structural model for database design. In Entity- Relationship Approach to Systems Analysis and Design. North Holland, Amsterdam. Google ScholarGoogle Scholar
  123. WoK82 WONG, H. K. T. ANO KOU, I. 1982. GUIDE: A graphical user interface for database exploration. In Proceedings of 8th International Conference on Very Large Data Bases. Very Large Data Base Endowment, Saratoga, Calif., pp. 22-32. Google ScholarGoogle Scholar
  124. ZANIOLO. C. 1976. Analysis and design of relational schemata for database systems. Tech. Rep. UCLA-Eng-7668, Dept. of Computer Science, Univ. of California at Los Angeles.Google ScholarGoogle Scholar
  125. ZANIOLO. C. 1983. The database language GEM. In Proceedings of the A CM SIGMOD International Conference on the Management of Data. ACM, New York, pp. 207-217. Google ScholarGoogle Scholar
  126. Zlo77 ZLOOF, M. 1977. Query-by-example: A data base language. IBM Syst. J. 16, 324-343.Google ScholarGoogle Scholar

Recommendations

Reviews

Martin E. Modell

Semantic data models represent an attempt to describe objects and the relationships between them from the viewpoint of their real-world existence, rather than from the way the data used to describe these objects are stored in the database. While many of these objects are physical and relatively easy to describe, many others are abstract, conceptual, and difficult to describe. Semantic data models provide mechanisms for dealing with and modeling data abstractions and “provide a higher level of abstraction for modeling data, allowing database designers to think of data in ways that correlate more directly to how data arise in the world.” The record-oriented data model world primarily uses three model constructs: hierarchic, network, and relational. These constructs traditionally revolve around physical objects (documents, people, places, and things) and cannot easily represent the more conceptual aspects of the real world. Semantic data models can capture concepts as well as data and are used in an attempt to describe how these physical objects relate to each other and how they are grouped (both physically and logically). The developers of the various semantic data modeling methods attempted to provide the means for translating the descriptions of the real-world objects into graphic representations to facilitate analysis and to assist the design process. Because these models provide more constructs and abstraction capabilities, they can represent a wider variety of situations and conditions. More than a dozen different modeling methods have been proposed over the years. Unfortunately, each technique uses a different set of terminology, a different set of constructs, and a different set of rules. This paper surveys the most prominent among these methods: the entity-relationship model, the semantic data model, and the functional data model. As a basis for discussing the various differences and similarities between the other models, the authors use a generic semantic model that “was developed expressly for this survey and is based largely on [the above three] most prominent models . . . along with many concepts derived from the IFO model.” The authors have a large topic to cover and many concepts to present. Their paper is lengthy (55 pages) and is supplemented by five pages of references. The paper has four main parts: philosophical considerations of semantic database modeling; a tutorial on semantic data modeling; a survey of prominent semantic data modeling techniques; and a discussion of the research, implementations, and theoretical analyses being performed in the semantic data modeling arena. The paper has much to commend it: the coverage of the various modeling techniques is complete and unbiased; the explanations of the concepts which underlie the various techniques are concise; and it is well illustrated and logically organized in general. The problem is that the paper is very difficult to read. This difficuty is due as much to the authors' writing style as to their method of presentation, the scope of what they try to cover, and the territory that they do cover. The large number of terms and concepts that are involved in so many different methods becomes confusing and difficult to follow after a while. Surveys and tutorials should be easy to comprehend so the reader can devote his or her energies to understanding rather then deciphering. By attempting to combine a survey and a tutorial in a single paper, the authors have done a disservice to their readers. Although the paper is informative, the authors would have done well to separate it into two parts—a survey and a tutorial. This would have allowed a much clearer and more extended discussion of the concepts. My final difficulty with this paper concerns the particular versions of the selected models that the authors use for discussions. Although many of these models were developed in the mid- to late 1970s, they have been extended and modified over the years in many significant ways. It appears that the authors have chosen to use the original developers' presentations as a basis of discussion rather than the current usages. Chen's entity-relationship model [1], for instance, has been extended and modified since 1976 by innumerable papers, conferences, and practitioners to the point where it is substantially different from the original proposal. Many of the other models have evolved in a similar manner. Obviously it is much more difficult to discuss the present state of these modeling techniques' evolution than it is to discuss the original versions. The current implementations of these models have come closer to each other than the paper implies. A follow-up paper might be in order.

Access critical reviews of Computing literature here

Become a reviewer for Computing Reviews.

Comments

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Sign in

Full Access

  • Published in

    cover image ACM Computing Surveys
    ACM Computing Surveys  Volume 19, Issue 3
    Sept. 1987
    96 pages
    ISSN:0360-0300
    EISSN:1557-7341
    DOI:10.1145/45072
    Issue’s Table of Contents

    Copyright © 1987 ACM

    Publisher

    Association for Computing Machinery

    New York, NY, United States

    Publication History

    • Published: 1 September 1987
    Published in csur Volume 19, Issue 3

    Permissions

    Request permissions about this article.

    Request Permissions

    Check for updates

    Qualifiers

    • article

PDF Format

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader