skip to main content
10.1145/1734714.1734716acmconferencesArticle/Chapter ViewAbstractPublication PagesmodConference Proceedingsconference-collections
research-article
Free access

Normalized data base structure: a brief tutorial

Published: 11 November 1971 Publication History

Abstract

Casual and other users of large formatted data bases need a simple tabular (relational) view of the data rather than a network or tree-structured view. This paper illustrates the removal of repeating groups, hierarchic and plex structures, and cross-referencing structures. Finally, the simplification of data base relations by normalization is discussed.

References

[1]
F. B. Thompson, P. C. Lockemann, B. H. Dostert, R. S. Deverill, "REL: A Rapidly Extensible Language System", Proc. Nat. ACM August 1969 San Francisco.
[2]
B. H. Dostert, F. B. Thompson, "How Features Resolve Syntactic Ambiguity", Proceedings of Symposium on Information Storage and Retrieval, University of Maryland, April 1--2, 1971.
[3]
B. H. Dostert, F. B. Thompson "Syntactic Analysis in REL English", 1971 International Meeting in Computational Linguistics, Debrecen, Hungary September 1971.
[4]
Codasyl Systems Committee, "Feature Analysis of Generalized Data Base Management Systems", May 1971, obtainable from ACM HQ, New York, New York.
[5]
E. F. Codd, "A Data Base Sublanguage founded on the Relational Calculus", Proc. 1971 ACM-SIGFIDET Workshop on Data Description, Access and Control, to be available from ACM HQ, 1972.
[6]
E. F. Codd, "A Relational Model of Data for Large Shared Data Banks", Comm. ACM 13 6, June 1970, 377--387.
[7]
E. F. Codd, "Further Normalization of the Data Base Relational Model", Courant Computer Science Symposia 6, "Data Base Systems", New York City, May 24--25, 1971, to be published by Prentice-Hall.
[8]
I. J. Heath, "Unacceptable File Operations in a Relational Data Base", Proc. 1971 ACM-SIGFIDET Workshop on Data Descirption, Access and Control, to be available from ACM HQ, 1972.

Cited By

View all
  • (2023)Application of Several Fuzzy-Based Techniques for Estimating Tunnel Boring Machine Performance in Metamorphic RocksRock Mechanics and Rock Engineering10.1007/s00603-023-03602-x57:2(1471-1494)Online publication date: 31-Oct-2023
  • (2021)60 Years of DatabasesPROBLEMS IN PROGRAMMING10.15407/pp2021.03.040(040-071)Online publication date: Sep-2021
  • (2021)Increase Efficiency of Relational Databases Using Instruments of Second Normal Form2021 IEEE 3rd International Conference on Advanced Trends in Information Theory (ATIT)10.1109/ATIT54053.2021.9678605(221-225)Online publication date: 15-Dec-2021
  • Show More Cited By
  1. Normalized data base structure: a brief tutorial

    Recommendations

    Comments

    Information & Contributors

    Information

    Published In

    cover image ACM Conferences
    SIGFIDET '71: Proceedings of the 1971 ACM SIGFIDET (now SIGMOD) Workshop on Data Description, Access and Control
    November 1971
    368 pages
    ISBN:9781450373005
    DOI:10.1145/1734714
    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]

    Sponsors

    Publisher

    Association for Computing Machinery

    New York, NY, United States

    Publication History

    Published: 11 November 1971

    Permissions

    Request permissions for this article.

    Check for updates

    Qualifiers

    • Research-article

    Contributors

    Other Metrics

    Bibliometrics & Citations

    Bibliometrics

    Article Metrics

    • Downloads (Last 12 months)438
    • Downloads (Last 6 weeks)39
    Reflects downloads up to 16 Feb 2025

    Other Metrics

    Citations

    Cited By

    View all
    • (2023)Application of Several Fuzzy-Based Techniques for Estimating Tunnel Boring Machine Performance in Metamorphic RocksRock Mechanics and Rock Engineering10.1007/s00603-023-03602-x57:2(1471-1494)Online publication date: 31-Oct-2023
    • (2021)60 Years of DatabasesPROBLEMS IN PROGRAMMING10.15407/pp2021.03.040(040-071)Online publication date: Sep-2021
    • (2021)Increase Efficiency of Relational Databases Using Instruments of Second Normal Form2021 IEEE 3rd International Conference on Advanced Trends in Information Theory (ATIT)10.1109/ATIT54053.2021.9678605(221-225)Online publication date: 15-Dec-2021
    • (2020)Tax-KG: Taxation Big Data Visualization System for Knowledge Graph2020 IEEE 5th International Conference on Signal and Image Processing (ICSIP)10.1109/ICSIP49896.2020.9339403(425-429)Online publication date: 23-Oct-2020
    • (2020)Discovering Evolving Temporal Information: Theory and Application to Clinical DatabasesSN Computer Science10.1007/s42979-020-00160-91:3Online publication date: 8-May-2020
    • (2020)Modernization of the Second Normal Form and Boyce-Codd Normal Form for Relational TheoryAdvances in Computer Science for Engineering and Education III10.1007/978-3-030-55506-1_27(296-305)Online publication date: 6-Aug-2020
    • (2020)Efficient Information Support of the Automatic Process and Production Control SystemAnalysis of Images, Social Networks and Texts10.1007/978-3-030-39575-9_25(244-255)Online publication date: 2-Feb-2020
    • (2019)Finding the Transitive Closure of Functional Dependencies using Strategic Port Graph RewritingElectronic Proceedings in Theoretical Computer Science10.4204/EPTCS.288.5288(50-62)Online publication date: 6-Feb-2019
    • (2019)Supporting the long‐term curation and migration of natural history museum collections databasesProceedings of the Association for Information Science and Technology10.1002/pra2.2018.1450550105555:1(504-513)Online publication date: Feb-2019
    • (2018)Basic Mathematical StructuresN-ary Relations for Logical Analysis of Data and Knowledge10.4018/978-1-5225-2782-4.ch001(1-96)Online publication date: 2018
    • Show More Cited By

    View Options

    View options

    PDF

    View or Download as a PDF file.

    PDF

    eReader

    View online with eReader.

    eReader

    Login options

    Figures

    Tables

    Media

    Share

    Share

    Share this Publication link

    Share on social media