The semantic data model: a modelling mechanism for data base applications

ABSTRACT

Conventional data models are not satisfactory for modelling data base application systems. The features that they provide are too low level and representational to allow the semantics of a data base to be directly expressed in the schema. The semantic data model (SDM) has been designed as a natural application modelling mechanism that can capture and express the structure of an application environment. The features of the SDM correspond to the principal intensional structures naturally occurring in contemporary data base applications. Furthermore, facilities for expressing derived (redundant) information are an essential part of the SDM; derived information is as prominent in an SDM schema as is primitive data. The SDM is designed to enhance the effectiveness and usability of computerized data bases. It can serve as a formal specification and documentation mechanism for a data base, can support a variety of powerful user interface facilities, and can be used as a tool in the data base design process.

REFERENCES

• 1: ANSI/X3/SPARC (Standards Planning and Requirements Committee), "Interim Report from the Study Group on Data Base Management Systems," FDT (Bulletin of ACM SIGMOD), Volume 7, Number 2, 1975.
• 2: Bachman, C. W., "The Role Concept in Database Models", Proceedings of International Conference on Very Large Data Bases, Tokyo, Japan, 6-8 October 1977.
• 3: P. A. Bernstein , J. R. Swenson , D. C. Tsichritzis, A unified approach to functional dependencies and relations, Proceedings of the 1975 ACM SIGMOD international conference on Management of data, May 14-16, 1975, San Jose, California [doi>10.1145/500080.500112]
• 4: Biller, H. and E. J. Neuhold, "Semantics of Data Bases: The Semantics of Data Models", Information Systems, Volume 3, Number 1, Pages 11-30, 1978.
• 5: Chamberlin, D. D., J. N. Gray, and I. L. Traiger, "Views, Authorization, and Locking in a Relational Data Base System", Proceedings of National Computer Conference, Anaheim CA, 19-22 May 1975.
• 6: Donald D. Chamberlin, Relational Data-Base Management Systems, ACM Computing Surveys (CSUR), v.8 n.1, p.43-66, March 1976 [doi>10.1145/356662.356665]
• 7: Chang, C. L., A Hyper-Relational Model of Data Bases, IBM. Research Report RJ1634, San Jose CA, 22 August 1975.
• 8: Peter Pin-Shan Chen, The entity-relationship model—toward a unified view of data, ACM Transactions on Database Systems (TODS), v.1 n.1, p.9-36, March 1976 [doi>10.1145/320434.320440]
• 9: E. F. Codd, A relational model of data for large shared data banks, Communications of the ACM, v.13 n.6, p.377-387, June 1970 [doi>10.1145/362384.362685]
• 10: Codd, E. F., "Further Normalization of the Data Base Relational Model", Data Base Systems (editor Rustin, R.), Prentice Hall, 1971.
• 11: Codd, E. F., "Normalized Data Base Structure: A Brief Tutorial", Proceedings of ACM SIGFIDET Workshop on Data Description, Access, and Control, San Diego CA, 1971.
• 12: Eswaran, K. P. and D. D. Chamberlin, "Functional Specifications of a Subsystem for Database Integrity", Proceedings of International Conference on Very Large Data Bases, Framingham MA, 22-24 September 1975.
• 13: Fagin, R., "The Decomposition Versus the Synthetic Approach to Database Design, Proceedings of International Conference on Very Large Data Bases, Tokyo, Japan, 6-8 October 1977.
• 14: Hammer, M. M. and. D. J. McLeod, "Semantic Integrity in a Relational Data Base System", Proceedings of International Conference on Very Large Data Bases, Framingham MA, 22-24 September 1975.
• 15: Michael Hammer , Dennis McLeod, A framework for data base semantic integrity, Proceedings of the 2nd international conference on Software engineering, p.498-504, October 13-15, 1976, San Francisco, California, United States
• 16: William C. McGee, On user criteria for data model evaluation, ACM Transactions on Database Systems (TODS), v.1 n.4, p.370-387, Dec. 1976 [doi>10.1145/320493.320504]
• 17: McLeod, D. J., "High Level Definition of Abstract Domains in a Relational Data Base System", Journal of Computer Languages, Volume 2, Number 3, 1977.
• 18: Pirotte, A., The Entity - Property - Association Model: An Information-Oriented Data Base Model, Technical Report, M.B.L.E. Research Laboratory, Brussels, Belgium, 1977.
• 19: Roussopoulos, N., "ADD: Algebraic Data Definition", Proceedings of Sixth Texas Conference on Computing Systems, Austin TX, 14-15 November 1977.
• 20: Roger C. Schank , Kenneth M. Colby, Computer Models of Thought and Language, W. H. Freeman & Co., New York, NY, 1973
• 21: Hans Albrecht Schmid , J. Richard Swenson, On the semantics of the relational data model, Proceedings of the 1975 ACM SIGMOD international conference on Management of data, May 14-16, 1975, San Jose, California [doi>10.1145/500080.500110]
• 22: John Miles Smith , Diane C. P. Smith, Database abstractions: aggregation, Communications of the ACM, v.20 n.6, p.405-413, June 1977 [doi>10.1145/359605.359620]
• 23: John Miles Smith , Diane C. P. Smith, Database abstractions: aggregation and generalization, ACM Transactions on Database Systems (TODS), v.2 n.2, p.105-133, June 1977 [doi>10.1145/320544.320546]
• 24: Stonebraker, M. R., High Level Integrity Assurance in Relational Data Base Management Systems, Electronics Research Laboratory Report ERL-M473, University of California, Berkeley CA, 16 August 1974
• 25: Robert W. Taylor , Randall L. Frank, CODASYL Data-Base Management Systems, ACM Computing Surveys (CSUR), v.8 n.1, p.67-103, March 1976 [doi>10.1145/356662.356666]
• 26: D. C. Tsichritzis , F. H. Lochovsky, Hierarchical Data-Base Management: A Survey, ACM Computing Surveys (CSUR), v.8 n.1, p.105-123, March 1976 [doi>10.1145/356662.356667]
• 27: Gio C. Wiederhold, Database Design, McGraw-Hill, Inc., New York, NY, 1977

INDEX TERMS

Keywords:
data base management, data base modelling, data base user interfaces, data definition, data models, data semantics, information redundancy, logical data base design