Article

Free access

The relational and network approaches: Comparison of the application programming interfaces

Authors:

E. F. CoddAuthors Info & Claims

SIGFIDET '74: Proceedings of the 1974 ACM SIGFIDET (now SIGMOD) workshop on Data description, access and control: Data models: Data-structure-set versus relational

Pages 83 - 113

https://doi.org/10.1145/800297.811532

Published: 01 January 1975 Publication History

Abstract

For some time now there has been considerable debate in the field of database systems over the fundamental question of the underlying design philosophy of such a system. The controversy has centered on the structure of the programmer interface, though of course the design chosen for this interface has repercussions throughout the rest of the system. Two approaches to this problem have received particular attention: the network approach, which is typified by the proposals of the CODASYL Data Base Task Group (DBTG), and the relational approach, which is advocated by the present authors (among others). The purpose of this paper is to give some comparisons between these two approaches (primarily from the application programming viewpoint), and to show what the authors believe to be the advantages of the relational approach. The reader is assumed to have a basic familiarity with the two approaches.

References

[1]

C. W. Bachman: "Implementation Techniques for Data Structure Sets", Proc. SHARE Workshop on Data Base Management Systems, Montreal, July 1973, SHARE Distribution.

[2]

CODASYL Data Base Task Group: Report, April 1971.

[3]

CODASYL Data Base Language Task Group: Proposal, February 1973.

[4]

CODASYL Data Description Language Committee: Journal of Development, June 1973.

[5]

E. F. Codd: "A Relational Model of Data for Large Shared Data Banks", CACM 13,6 June 1970.

Digital Library

[6]

E. F. Codd: "Normalized Data Base Structure: A Brief Tutorial", Proc. 1971 ACM SIGFIDET Workshop on Data Description, Access and Control.

[7]

E. F. Codd: "A Data Base Sublanguage Founded on the Relational Calculus", Proc. 1971 ACM SIGFIDET Workshop on Data Description, Access and Control.

[8]

E. F. Codd: "Further Normalization of the Data Base Relational Model", In "Data Base Systems", Courant Computer Science Symposia 6, Prentice-Hall 1972.

[9]

E. F. Codd: "Relational Completeness of Data Base Sublanguages", Courant Computer Science Symposia 6, Prentice-Hall 1972.

[10]

E. F. Codd: "Access Control for Relational Data Base Systems", Presented at BCS Symposium on Relational Database Concepts, London, April 1973.

[11]

C. J. Date: "Relational Database Systems: a Tutorial", Proc. 4th International Symposium on Computer and Information Science, Miami Beach, December 1972, Plenum, New York

[12]

C. J. Date, P. Hopewell: "Storage Structure and Physical Data Independence", Proc. 1971 ACM SIGFIDET Workshop on Data Description, Access and Control.

[13]

C. J. Date, P. Hopewell: "File Definition and Logical Data Independence", Proc. 1971 ACM SIGFIDET Workshop on Data Description, Access and Control.

[14]

R. W. Engles: "An Analysis of the April 1971 DBTG Report", Proc. 1971 ACM SIGFIDET Workshop on Data Description, Access and Control.

[15]

R. C. Goldstein, A. J. Strnad: "The MacAIMS Data Management System", Proc. 1970 ACM SIGFIDET Workshop on Data Description and Access.

[16]

I. J. Heath: "Unacceptable File Operations in a Relational Database", Proc. 1971 ACM SIGFIDET Workshop on Data Description, Access and Control.

[17]

F. P. Palermo: "A Data Base Search Problem", Proc. 4th International Symposium on Computer and Information Science, Miami Beach, December 1972, Plenum, New York.

[18]

P. H. Prowse: "The Relational Model as a System Analysis Tool", Presented at BCS Symposium on Relational Database Concepts, London, April 1973.

[19]

C. W. Bachman: "Data Structure Diagrams", Data Base 1,2, Summer 1969.

Digital Library

[20]

C. W. Bachman: "The Programmer as Navigator" (1973 Turing Award Lecture), CACM 16,11 November 1973.

Digital Library

[21]

J. B. Rothnie: "The Design of Generalized Data Management Systems", Ph.D. Dissertation, Dept. of Civil Engineering, MIT (September 1972).

[22]

D. D. Chamberlin, R. F. Boyce: "SEQUEL: A Structured English Query Language", Proc. ACM-SIGFIDET Workshop 1974

Digital Library

[23]

R. Boyce, D. D. Chamberlin: "Using a Structured English Query Language as a Data Definition Facility", IBM Research Report RJ 1318.

[24]

D. D. Chamberlin, R. F. Boyce, I. L. Traiger: "A Deadlock-Free Scheme for Resource Locking in a Database Environment", Information Processing 74, North-Holland, Amsterdam.

[25]

V. K. M. Whitney: "Fourth Generation Data Management Systems", Proc. 1973 National Computer Conference, New York.

Cited By

Michael JBork DWimmer MMayr H(2024)Quo Vadis modeling?Software and Systems Modeling (SoSyM)10.1007/s10270-023-01128-y23:1(7-28)Online publication date: 1-Feb-2024
https://dl.acm.org/doi/10.1007/s10270-023-01128-y
Torres-Salinas DArroyo-Machado W(2022)APIs en contextos bibliométricos: introducción básica y corpus exhaustivoAnuario ThinkEPI10.3145/thinkepi.2022.e16a09Online publication date: 7-Jun-2022
https://doi.org/10.3145/thinkepi.2022.e16a09
Zhang XCao GZhang XCao G(2021)Data CollectionEvent Attendance Prediction in Social Networks10.1007/978-3-030-89262-3_3(11-14)Online publication date: 24-Sep-2021
https://doi.org/10.1007/978-3-030-89262-3_3
Show More Cited By

Index Terms

The relational and network approaches: Comparison of the application programming interfaces
1. Information systems
  1. Data management systems
    1. Database design and models
      1. Relational database model
    2. Query languages
      1. Relational database query languages
2. Theory of computation
  1. Theory and algorithms for application domains
    1. Database theory
      1. Database query languages (principles)

Recommendations

Interactive support for non-programmers: The relational and network approaches
SIGFIDET '74: Proceedings of the 1974 ACM SIGFIDET (now SIGMOD) workshop on Data description, access and control: Data models: Data-structure-set versus relational

The objectives and strategies of the relational and network approaches are compared. The status of support for non-programming users is examined. General purpose support for such users entails provision of an augmented relationally complete retrieval ...
Relational Operations and Uncertainty Measure in Rough Relational Database

The traditional relational database model RDM is not effective for dealing with imprecise and uncertain data as it deals with precise and unambiguous data. Hence, Beaubouef et al. proposed the rough relational database model RRDM for the management of ...
Modeling MongoDB with Relational Model
EIDWT '13: Proceedings of the 2013 Fourth International Conference on Emerging Intelligent Data and Web Technologies

Relational databases have been prevailing for the last two decades, with features of clear semantics and ease of use with SQL supported by the underlying theory, relational algebra. Relational databases provide good support for structural data ...

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

cover image ACM Conferences

SIGFIDET '74: Proceedings of the 1974 ACM SIGFIDET (now SIGMOD) workshop on Data description, access and control: Data models: Data-structure-set versus relational

January 1975

144 pages

ISBN:9781450374187

DOI:10.1145/800297

Chairman:
Randall Rustin

Copyright © 1975 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]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 January 1975

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

76
Total Citations
View Citations
1,757
Total Downloads

Downloads (Last 12 months)543
Downloads (Last 6 weeks)145

Reflects downloads up to 27 Nov 2024

Other Metrics

View Author Metrics

Citations

Cited By

Michael JBork DWimmer MMayr H(2024)Quo Vadis modeling?Software and Systems Modeling (SoSyM)10.1007/s10270-023-01128-y23:1(7-28)Online publication date: 1-Feb-2024
https://dl.acm.org/doi/10.1007/s10270-023-01128-y
Torres-Salinas DArroyo-Machado W(2022)APIs en contextos bibliométricos: introducción básica y corpus exhaustivoAnuario ThinkEPI10.3145/thinkepi.2022.e16a09Online publication date: 7-Jun-2022
https://doi.org/10.3145/thinkepi.2022.e16a09
Zhang XCao GZhang XCao G(2021)Data CollectionEvent Attendance Prediction in Social Networks10.1007/978-3-030-89262-3_3(11-14)Online publication date: 24-Sep-2021
https://doi.org/10.1007/978-3-030-89262-3_3
Zolotov ORomanovskaya YRzhannikova V(2019)On Definition of BigDataEPJ Web of Conferences10.1051/epjconf/201922404011224(04011)Online publication date: 9-Dec-2019
https://doi.org/10.1051/epjconf/201922404011
(2018)ReferencesMaking Databases Work10.1145/3226595.3226642(635-644)Online publication date: 1-Dec-2018
https://dl.acm.org/doi/10.1145/3226595.3226642
(2018)The collected works of Michael StonebrakerMaking Databases Work10.1145/3226595.3226641(606-633)Online publication date: 1-Dec-2018
https://dl.acm.org/doi/10.1145/3226595.3226641
Stonebraker MWong EKreps PHeld G(2018)The design and implementation of INGRESMaking Databases Work10.1145/3226595.3226640(561-605)Online publication date: 1-Dec-2018
https://dl.acm.org/doi/10.1145/3226595.3226640
Stonebraker MRowe LHirohama M(2018)The implementation of POSTGRESMaking Databases Work10.1145/3226595.3226639(519-559)Online publication date: 1-Dec-2018
https://dl.acm.org/doi/10.1145/3226595.3226639
Stonebraker MAbadi DBatkin AChen XCherniack MFerreira MLau ELin AMadden SO'Neil EO'Neil PRasin ATran NZdonik S(2018)C-storeMaking Databases Work10.1145/3226595.3226638(491-518)Online publication date: 1-Dec-2018
https://dl.acm.org/doi/10.1145/3226595.3226638
Stonebraker MMadden SAbadi DHarizopoulos SHachem NHelland P(2018)The end of an architectural eraMaking Databases Work10.1145/3226595.3226637(463-489)Online publication date: 1-Dec-2018
https://dl.acm.org/doi/10.1145/3226595.3226637
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

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 Publication

Media

Figures

Other

Tables

View Table of Contents