The entity-relationship model—toward a unified view of data

ACM Transactions on Database Systems - Tập 1 Số 1 - Trang 9-36 - 1976
Peter Pin-Shan Chen1
1Massachusetts Institute of Technology, Cambridge

Tóm tắt

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.

Từ khóa


Tài liệu tham khảo

,~k BRIAL , 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 . ,~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.

BACHMAN , C.W. Software for random access processing. Datamation I1 ( April 1965 ), 36 - 41 . BACHMAN, C.W. Software for random access processing. Datamation I1 (April 1965), 36-41.

10.1145/1017466.1017467

BACHMAN , C.W. Trends in database management--1975 . Proc., AFIPS 1975 NCC , Vol. 44 , AFIPS Press, Montvale, N.J. , pp. 569 - 576 . BACHMAN, C.W. Trends in database management--1975. Proc., AFIPS 1975 NCC, Vol. 44, AFIPS Press, Montvale, N.J., pp. 569-576.

BIRKHOFF , ~., AND BARTEE , T.C. Modern Applied Algebra . McGraw-Hill , New York , 1970 . BIRKHOFF, ~., AND BARTEE, T.C. Modern Applied Algebra. McGraw-Hill, New York, 1970.

10.1145/800296.811515

CODASYL. Data base task group report . ACM , New York , 1971 . CODASYL. Data base task group report. ACM, New York, 1971.

10.1145/362384.362685

10.1145/1734714.1734716

10.1145/1734714.1734718

CODD , E.F. Recent investigations in relational data base systems . Proc. IFIP Congress 1974 , North-Holland Pub. Co., Amsterdam , pp. 1017 - 1021 . CODD, E.F. Recent investigations in relational data base systems. Proc. IFIP Congress 1974, North-Holland Pub. Co., Amsterdam, pp. 1017-1021.

DEHENEFFE , C. , HENNEBERT , H. , AND PAULUS , W. Relational model for data base . Proc. IFIP Congress 1974 , North-Holland Pub. Co., Amsterdam , pp. 1022 - 1025 . DEHENEFFE, C., HENNEBERT, H., AND PAULUS, W. Relational model for data base. Proc. IFIP Congress 1974, North-Holland Pub. Co., Amsterdam, pp. 1022-1025.

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 . 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.

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 . 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.

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 . 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.

HAMMER , M.M. , AND McLzo D, D . J. Semantic integrity in a relation data base system . Proc. Very Large Data Base Conf., Framingham, Mass. , Sept. 1975 , pp. 25 -- 47 . 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.

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 . 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.

MEALY , G.H. Another look at data base . Proc. AFIPS 1967 FJCC , Vol. 31 , AFIPS Press, Montvale, N.J. , pp. 525 - 534 . MEALY, G.H. Another look at data base. Proc. AFIPS 1967 FJCC, Vol. 31, AFIPS Press, Montvale, N.J., pp. 525-534.

~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 . ~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.

OLLE , T.W. Current and future trends in data base management systems . Proc. IFIP Congress 1974 , North-Holland Pub. Co., Amsterdam , pp. 998 - 1006 . OLLE, T.W. Current and future trends in data base management systems. Proc. IFIP Congress 1974, North-Holland Pub. Co., Amsterdam, pp. 998-1006.

10.1145/1282480.1282490

RUSTIC , R. (Ed.). Proc. ACM-SOGMOD 1974~debate on data models . Ann Arbor, Mich. , May 1974 . RUSTIC, R. (Ed.). Proc. ACM-SOGMOD 1974~debate on data models. Ann Arbor, Mich., May 1974.

10.1145/500080.500110

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 . 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.

10.1147/sj.121.0030

10.1145/800297.811530

10.1145/500080.500101

10.1145/500080.500091

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 . 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.

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 . 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.

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 . 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.

Thông tin
Thông tin xuất bản

ACM Transactions on Database Systems

Tập 1 Số 1

9-36

Thông tin tác giả