The Entity-Relationship Model - Toward a Unified View of Data.

@article{DBLP:journals/tods/Chen76,
  author    = {Peter P. Chen},
  title     = {The Entity-Relationship Model - Toward a Unified View of Data},
  journal   = {ACM Trans. Database Syst.},
  volume    = {1},
  number    = {1},
  year      = {1976},
  pages     = {9-36},
  ee        = {http://doi.acm.org/10.1145/320434.320440, db/journals/tods/Chen76.html},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

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.

Copyright © 1976 by the ACM, Inc., used by permission. Permission to make digital or hard copies is granted provided that copies are not made or distributed for profit or direct commercial advantage, and that copies show this notice on the first page or initial screen of a display along with the full citation.

Joint ACM SIGMOD / IEEE Computer Society Anthology

• Windows: Click the letter of your CD drive
  A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
• Mac: Click here
• UNIX/LINUX: mount the CD and click on the path of your mount point:
  /Anthology/An3-1 or /cdrom

• Windows: Click the letter of your CD drive
  A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
• Mac: Click here
• UNIX/LINUX: mount the DVD and click on the path of your mount point:
  /Anthology/aDVD2 or /dvd

Conference Abstract

References

[1]

...

[2]

...

[3]

...

[4]

...

[5]

...

[6]

Donald D. Chamberlin, Raymond F. Boyce: SEQUEL: A Structured English Query Language. SIGMOD Workshop, Vol. 1 1974: 249-264 BibTeX

[7]

...

[8]

E. F. Codd: A Relational Model of Data for Large Shared Data Banks. Commun. ACM 13(6): 377-387(1970) BibTeX

[9]

E. F. Codd: Normalized Data Structure: A Brief Tutorial. SIGFIDET Workshop 1971: 1-17 BibTeX

[10]

E. F. Codd: A Database Sublanguage Founded on the Relational Calculus. SIGFIDET Workshop 1971: 35-68 BibTeX

[11]

E. F. Codd: Recent Investigations in Relational Data Base Systems. IFIP Congress 1974: 1017-1021 BibTeX

[12]

Claude Deheneffe, Henri Hennebert, W. Paulus: Relational Model for a Data Base. IFIP Congress 1974: 1022-1025 BibTeX

[13]

...

[14]

Kapali P. Eswaran, Donald D. Chamberlin: Functional Specifications of Subsystem for Database Integrity. VLDB 1975: 48-68 BibTeX

[15]

Jean-Luc Hainaut, Baudouin Le Charlier: An Extensible Semantic Model of Data Base and Its Data language. IFIP Congress 1974: 1026-1030 BibTeX

[16]

Michael Hammer, Dennis McLeod: Semantic Integrity in a Relational Data Base System. VLDB 1975: 25-47 BibTeX

[17]

Paul Lindgreen: Basic Operations on Information as a Basis for Data Base Design. IFIP Congress 1974: 993-997 BibTeX

[18]

...

[19]

...

[20]

T. William Olle: Current and Future Trends in Data Base Management Systems. IFIP Congress 1974: 998-1006 BibTeX

[21]

Nick Roussopoulos, John Mylopoulos: Using Semantic Networks for Database Management. VLDB 1975: 144-172 BibTeX

[22]

...

[23]

Hans Albrecht Schmid, J. Richard Swenson: On the Semantics of the Relational Data Model. SIGMOD Conference 1975: 211-223 BibTeX

[24]

...

[25]

...

[26]

Edgar H. Sibley: On the Equivalence of Data Based Systems. SIGMOD Workshop, Vol. 2 1974: 43-76 BibTeX

[27]

Thomas B. Steel Jr.: Data Base Standardization - A Status Report. SIGMOD Conference 1975: 149-156 BibTeX

[28]

Michael Stonebraker: Implementation of Integrity Constraints and Views by Query Modification. SIGMOD Conference 1975: 65-78 BibTeX

[29]

...

[30]

...

[31]

...