Peter Pin-Shan Chen
Abstract
A data model, called the entity-relationship model, is proposed. This model incorporates some of the important semantic information about the real world. A special diagrammatic technique is introduced as a tool for database design. An example of database design and description using the model and the diagrammatic technique is given. Some implications for data integrity, information retrieval, and data manipulation are discussed.
The entity-relationship model can be used as a basis for unification of different views of data: the network model, the relational model, and the entity set model. Semantic ambiguities in these models are analyzed. Possible ways to derive their views of data from the entity-relationship model are presented.
- 1 ,~kBRIAL, J.R. Data semantics. In Data Base Management, J.W. Klimbie and K.L. Koffeman, Eds., North-Holland Pub. Co., Amsterdam, 1974, pp. 1-60.Google Scholar
- 2 BACHMAN, C.W. Software for random access processing. Datamation I1 (April 1965), 36-41.Google Scholar
- 3 BACH~AN, C.W. Data structure diagrams. Data Base 1, 2 (Summer 1969), 4-10. Google ScholarDigital Library
- 4 BACHMAN, C.W. Trends in database management--1975. Proc., AFIPS 1975 NCC, Vol. 44, AFIPS Press, Montvale, N.J., pp. 569-576.Google Scholar
- 5 BIRKHOFF, ~., AND BARTEE, T.C. Modern Applied Algebra. McGraw-Hill, New York, 1970.Google Scholar
- 6 CHA~B~RLI~, D.D., A~D RArMO~CD, F.B. SEQUEL: A structured English query language. Proc. ACM-SIGMOD 1974, Workshop, Ann Arbor, Michigan, May, 1974. Google ScholarDigital Library
- 7 CODASYL. Data base task group report. ACM, New York, 1971.Google Scholar
- 8 CODD, E.F. A relational model of data for large shared data banks. Comm. ACM 13, 6 (June 1970), 377-387. Google ScholarDigital Library
- 9 CODD, E.F. Normalized data base structure: A brief tutorial. Proc. ACM-SIGFIDET 1971, Workshop, San Diego, Calif., Nov. 1971, pp. 1-18.Google ScholarDigital Library
- 10 CODD, E.F. A data base sublanguage founded on the relational calculus. Proc. ACM-SIG- FIDET 1971, Workshop, San Diego, Calif., Nov. 1971, pp. 35-68.Google ScholarDigital Library
- 11 CODD, E.F. Recent investigations in relational data base systems. Proc. IFIP Congress 1974, North-Holland Pub. Co., Amsterdam, pp. 1017-1021.Google Scholar
- 12 DEHENEFFE, C., HENNEBERT, H., AND PAULUS, W. Relational model for data base. Proc. IFIP Congress 1974, North-Holland Pub. Co., Amsterdam, pp. 1022-1025.Google Scholar
- 13 DODD, G.G. APL--a language for associate data handling in PL/I. Proc. AFIPS 1966 FJCC, Vol. 29, Spartan Books, New York, pp. 677-084.Google Scholar
- 14 ESWXRAN, K.P., AND CHAMBERLI~, D.D. Functional specifications of a subsystem for data base integrity. Proc. Very Large Data Base Conf., Framingham, Mass., Sept. 1975, pp. 48-68.Google Scholar
- 15 HAINAUT, J.L., AND LECHARLXER, B. An extensible semantic model of data base and its data language. Proc. IFIP Congress 1974, North-Holland Pub. Co., Amsterdam, pp. 1026- 1030.Google Scholar
- 16 HAMMER, M.M., AND McLzoD, D.J. Semantic integrity in a relation data base system. Proc. Very Large Data Base Conf., Framingham, Mass., Sept. 1975, pp. 25--47.Google Scholar
- 17 LI~DG~EEN, Po Basic operations on information as a basis for data base design. Proc. IFIP Congress 1974, North-Holland Pub. Co., Amsterdam, pp. 993-997.Google Scholar
- 18 MEALY, G.H. Another look at data base. Proc. AFIPS 1967 FJCC, Vol. 31, AFIPS Press, Montvale, N.J., pp. 525-534.Google Scholar
- 19 ~IJSSEN, G.M. Data structuring in the DDL and the relational model. In Data Base Management, J.W. Klimbie and K.L. Koffeman, Eds., North-Holland Pub. Co., Amsterdam, 1974, pp. 363-379.Google Scholar
- 20 OLLE, T.W. Current and future trends in data base management systems. Proc. IFIP Congress 1974, North-Holland Pub. Co., Amsterdam, pp. 998-1006.Google Scholar
- 21 ROUSSOPOULOS, N., AND MYLOPOULOS, J. Using semantic networks for data base management. Proc. Very Large Data Base Conf., Framingham, Mass., Sept. 1975, pp. 144-172.Google ScholarDigital Library
- 22 RUSTIC, R. (Ed.). Proc. ACM-SOGMOD 1974~debate on data models. Ann Arbor, Mich., May 1974.Google Scholar
- 23 SCHMID, H.A., AND SWENSON, J.R. On the semantics of the relational model. Proc. ACM- SIGMOD 1975, Conference, San Jose, Calif., May 1975, pp. 211-233. Google ScholarDigital Library
- 24 SENXO, M.E. Data description language in the concept of multilevel structured description: DIAM II with FORAL. In Data Base Description, B.C.M. Dougue, and G.M. Ni}ssen, Eds., North-Holland Pub. Co., Amsterdam, pp. 239-258.Google Scholar
- 25 SENKO, M.E., ALTMAN, E.B., ASTRAHAN, M.M., AND FEHDER, P.L. Data structures and accessing in data-base systems. IBM Syst. J. 12, 1 (1973), 30-93.Google ScholarDigital Library
- 26 SIBLEY, E.H. On the equivalence of data base systems. Proc. ACM-SIGMOD 1974 debate on data models, Ann Arbor, Mich., May 1974, pp. 43-76. Google ScholarDigital Library
- 27 STEEL, T.B. Data base standardization--a status report. Proc. ACM-SIGMOD 1975, Conference, San Jose, Calif., May 1975, pp. 65-78. Google ScholarDigital Library
- 28 STONEBR.~_KER, M. Implementation of integrity constraints and views by query modification. Proc. ACM-SIGMOD 1975, Conference, San Jose, Calif., May 1975, pp. 65-78. Google ScholarDigital Library
- 29 SUNDGREN, B. Conceptual foundation of the infological approach to data bases. In Data Base Management, J.W. Klimbie and K.L. Koffeman, Eds., North-Holland Pub. Co., Amsterdam, 1974, pp. 61-95.Google Scholar
- 30 TAYLOR, R.W. Observations on the attributes of database sets. In Data Base Description, B.C.M. Dougue and G.M. Nijssen, Eds., North-Holland Pub. Co., Amsterdam, pp. 73-84.Google Scholar
- 31 TSICHRITZIS, D. A network framework for relation implementation. In Data Base Description, B.C.M. Douge and G.M. Nijssen, Eds., North-Holland Pub. Co., Amsterdam, pp. 269-282.Google Scholar
Index Terms
-
The entity-relationship model—toward a unified view of data
-
Recommendations
-
The entity-relationship model: toward a unified view of data
A data model, called the entity-relationship model, is proposed. This model incorporates some of the important semantic information in the real world. A special diagramatic technique is introduced as a tool for data base design. An example of data base ...
-
The entity-relationship model: toward a unified view of data
Software pioneersA data model, called the entity-relationship model, is proposed. This model incorporates some of the important semantic information about the real world. A special diagrammatic technique is introduced as a tool for database design. An example of ...
-
Using UML class diagrams for a comparative analysis of relational, object-oriented, and object-relational database mappings
SIGCSE '03: Proceedings of the 34th SIGCSE technical symposium on Computer science educationThis paper illustrates the manner in which UML can be used to study mappings to different types of database systems. After introducing UML through a comparison to the EER model, UML diagrams are used to teach different approaches for mapping conceptual ...
Comments