ACM Home Page
Please provide us with feedback. Feedback
The entity-relationship model—toward a unified view of data
Full text PdfPdf (1.72 MB)
Source ACM Transactions on Database Systems (TODS) archive
Volume 1 ,  Issue 1  (March 1976) table of contents
Special issue: papers from the international conference on very large data bases: September 22&ndash24, 1975, Framingham, MA
Pages: 9 - 36  
Year of Publication: 1976
ISSN:0362-5915
Author
Peter Pin-Shan Chen  Massachusetts Institute of Technology, Cambridge
Publisher
ACM  New York, NY, USA
Bibliometrics
Downloads (6 Weeks): 203,   Downloads (12 Months): 1808,   Citation Count: 799
Additional Information:

abstract   references   cited by   index terms   collaborative colleagues  

Tools and Actions: Request Permissions Request Permissions    Review this Article  
DOI Bookmark: Use this link to bookmark this Article: http://doi.acm.org/10.1145/320434.320440
What is a DOI?

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.


REFERENCES

Note: OCR errors may be found in this Reference List extracted from the full text article. ACM has opted to expose the complete List rather than only correct and linked references.

 
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.
 
2
BACHMAN, C.W. Software for random access processing. Datamation I1 (April 1965), 36-41.
3
 
4
BACHMAN, C.W. Trends in database management--1975. Proc., AFIPS 1975 NCC, Vol. 44, AFIPS Press, Montvale, N.J., pp. 569-576.
 
5
BIRKHOFF, ~., AND BARTEE, T.C. Modern Applied Algebra. McGraw-Hill, New York, 1970.
6
 
7
CODASYL. Data base task group report. ACM, New York, 1971.
8
 
9
CODD, E.F. Normalized data base structure: A brief tutorial. Proc. ACM-SIGFIDET 1971, Workshop, San Diego, Calif., Nov. 1971, pp. 1-18.
 
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.
 
11
CODD, E.F. Recent investigations in relational data base systems. Proc. IFIP Congress 1974, North-Holland Pub. Co., Amsterdam, pp. 1017-1021.
 
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.
 
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.
 
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.
 
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.
 
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.
 
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.
 
18
MEALY, G.H. Another look at data base. Proc. AFIPS 1967 FJCC, Vol. 31, AFIPS Press, Montvale, N.J., pp. 525-534.
 
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.
 
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.
 
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.
 
22
RUSTIC, R. (Ed.). Proc. ACM-SOGMOD 1974~debate on data models. Ann Arbor, Mich., May 1974.
23
 
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.
 
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.
26
27
28
 
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.
 
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.
 
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.

CITED BY  799

Collaborative Colleagues:
Peter Pin-Shan Chen: colleagues