article

Free access

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

Author:

Peter Pin-Shan ChenAuthors Info & Claims

ACM Transactions on Database Systems (TODS), Volume 1, Issue 1

Pages 9 - 36

https://doi.org/10.1145/320434.320440

Published: 01 March 1976 Publication History

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

[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]

BACH~AN, C.W. Data structure diagrams. Data Base 1, 2 (Summer 1969), 4-10.

Digital Library

[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]

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.

Digital Library

[7]

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

[8]

CODD, E.F. A relational model of data for large shared data banks. Comm. ACM 13, 6 (June 1970), 377-387.

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

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

Digital Library

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

Digital Library

[22]

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

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

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

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

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

Digital Library

[27]

STEEL, T.B. Data base standardization--a status report. Proc. ACM-SIGMOD 1975, Conference, San Jose, Calif., May 1975, pp. 65-78.

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

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

[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

Fujita JTsuji DYazawa SSakamoto ASawada KKaneko O(2024)Model-based Security Countermeasure Designing Methodology for Industrial Control Systems based on Cyber Kill Chains and Defense-in-depth Models攻撃キルチェーンと多層防御モデルに基づく産業制御システム向けモデルベースセキュリティ対策設計方式Transactions of the Institute of Systems, Control and Information Engineers10.5687/iscie.37.137:1(1-11)Online publication date: 15-Jan-2024
https://doi.org/10.5687/iscie.37.1
Wehnert SChedella PAsche JDe Luca E(2024)A dynamic approach for visualizing and exploring concept hierarchies from textbooksFrontiers in Artificial Intelligence10.3389/frai.2024.12850267Online publication date: 8-Feb-2024
https://doi.org/10.3389/frai.2024.1285026
Brandt MVidotti S(2024)Arquitetura da informação para processos de negócio e modelagem de banco de dados: aproximações possíveisEm Questão10.1590/1808-5245.30.13130430Online publication date: 2024
https://doi.org/10.1590/1808-5245.30.131304
Show More Cited By

Index Terms

The entity-relationship model—toward a unified view of data
1. Information systems
  1. Data management systems
    1. Database design and models
      1. Relational database model
    2. Query languages
      1. Relational database query languages

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 pioneers

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

This 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

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

cover image ACM Transactions on Database Systems

ACM Transactions on Database Systems Volume 1, Issue 1

Special issue: papers from the international conference on very large data bases: September 22–24, 1975, Framingham, MA

March 1976

88 pages

ISSN:0362-5915

EISSN:1557-4644

DOI:10.1145/320434

Editor:
David K. Hsiao
Ohio State Univ., Columbus

Issue’s Table of Contents

Copyright © 1976 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 March 1976

Published in TODS Volume 1, Issue 1

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

5,212
Total Citations
View Citations
40,786
Total Downloads

Downloads (Last 12 months)5,498
Downloads (Last 6 weeks)872

Reflects downloads up to 02 Oct 2024

Other Metrics

View Author Metrics

Citations

Cited By

Fujita JTsuji DYazawa SSakamoto ASawada KKaneko O(2024)Model-based Security Countermeasure Designing Methodology for Industrial Control Systems based on Cyber Kill Chains and Defense-in-depth Models攻撃キルチェーンと多層防御モデルに基づく産業制御システム向けモデルベースセキュリティ対策設計方式Transactions of the Institute of Systems, Control and Information Engineers10.5687/iscie.37.137:1(1-11)Online publication date: 15-Jan-2024
https://doi.org/10.5687/iscie.37.1
Wehnert SChedella PAsche JDe Luca E(2024)A dynamic approach for visualizing and exploring concept hierarchies from textbooksFrontiers in Artificial Intelligence10.3389/frai.2024.12850267Online publication date: 8-Feb-2024
https://doi.org/10.3389/frai.2024.1285026
Brandt MVidotti S(2024)Arquitetura da informação para processos de negócio e modelagem de banco de dados: aproximações possíveisEm Questão10.1590/1808-5245.30.13130430Online publication date: 2024
https://doi.org/10.1590/1808-5245.30.131304
Ahmadi NZoch MGuengoeze OFacchinello CMondorf AStratmann KMusleh KErasmus HTchertov JGebler RSchaaf JFrischen LNasirian ADai JHenke ETremblay DSrisuwananukorn ABornhäuser MRöllig CEckardt JMiddeke JWolfien MSedlmayr M(2024)How to customize common data models for rare diseases: an OMOP-based implementation and lessons learnedOrphanet Journal of Rare Diseases10.1186/s13023-024-03312-919:1Online publication date: 14-Aug-2024
https://doi.org/10.1186/s13023-024-03312-9
Dorn CPribadi H(2024)TypeQL: A Type-Theoretic & Polymorphic Query LanguageProceedings of the ACM on Management of Data10.1145/36516112:2(1-27)Online publication date: 14-May-2024
https://dl.acm.org/doi/10.1145/3651611
Wasserman ADig DBryksin TGolubev YBezzubov A(2024)Lessons from a Pioneering Software Engineering Environment: Design Principles of Software through PicturesProceedings of the 1st ACM/IEEE Workshop on Integrated Development Environments10.1145/3643796.3648445(12-14)Online publication date: 20-Apr-2024
https://dl.acm.org/doi/10.1145/3643796.3648445
Zhang ZLu YZheng WLin X(2024)A Comprehensive Survey and Experimental Study of Subgraph Matching: Trends, Unbiasedness, and InteractionProceedings of the ACM on Management of Data10.1145/36393152:1(1-29)Online publication date: 26-Mar-2024
https://dl.acm.org/doi/10.1145/3639315
Song SLi CLi DChen JWang C(2024)GraphDecoder: Recovering Diverse Network Graphs From Visualization Images via Attention-Aware LearningIEEE Transactions on Visualization and Computer Graphics10.1109/TVCG.2022.322555430:7(3074-3088)Online publication date: Jul-2024
https://doi.org/10.1109/TVCG.2022.3225554
Chillón AKlettke MRuiz DMolina J(2024)A Generic Schema Evolution Approach for NoSQL and Relational DatabasesIEEE Transactions on Knowledge and Data Engineering10.1109/TKDE.2024.336227336:7(2774-2789)Online publication date: 5-Feb-2024
https://dl.acm.org/doi/10.1109/TKDE.2024.3362273
Stechschulte GWintner MHemmje MSchwarz JLischer SKaufmann M(2024)In-Database Feature Extraction to Improve Early Detection of Problematic Online Gambling BehaviorIEEE Transactions on Computational Social Systems10.1109/TCSS.2024.340650111:5(6868-6881)Online publication date: Oct-2024
https://doi.org/10.1109/TCSS.2024.3406501
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Article

Media

Figures

Other

Tables

View Issue’s Table of Contents