Article

Free access

Interactive support for non-programmers: The relational and network approaches

Authors:

C. J. DateAuthors 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 11 - 41

https://doi.org/10.1145/800297.811529

Published: 01 January 1975 Publication History

Abstract

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 capability without branching, explicit iteration, or cursors. It is clear how this capability can be realized with the relational approach—whether with a formal or informal language interface. It is not at all clear how the network approach can reach this goal, so long as the principal schema includes owner-coupled sets “bearing information essentially”. A relational discipline is suggested as a way out for DBTG users.

References

[1]

C. J. Date, E. F. Codd, "The Relational and Network Approaches: Comparison of the Application Programming Interfaces," Proc. 1974 ACM-SIGFIDET Workshop.

Digital Library

[2]

V. K. M. Whitney, "Relational Data Management Implementation Techniques," Proc. 1974 ACM-SIGFIDET Workshop.

Digital Library

[3]

CODASYL, "Data Base Task Group Report," ACM, New York City, October 1969.

[4]

CODASYL, "Data Base Task Group Report," ACM, New York City, April 1971.

[5]

R. W. Engles, "An Analysis of the April 1971 Data Base Task Group Report," Proc. 1971 ACM-SIGFIDET Workshop.

[6]

C. J. Date, P. Hopewell, "File Definition and Logical Data Independence," Proc. 1971 ACM-SIGFIDET Workshop.

[7]

C. J. Date, P. Hopewell, "Storage Structure and Physical Data Independence," Proc. 1971 ACM-SIGFIDET Workshop.

[8]

C. W. Bachman, "The Programmer as Navigator," Comm. ACM 16, No. 11, November 1973, pp. 653-658.

Digital Library

[9]

R. L. Frank, E. H. Sibley, "The Data Base Task Group Report: An Illustrative Example," ISDOS Working Paper No. 71, February 1973, U.S. National Technical Information Service, Document AD-759-267.

[10]

M. G. Notley, "The Peterlee IS/1 System," IBM UK Scientific Centre Report UKSC-0018, March 1972.

[11]

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

Digital Library

[12]

D. Bjorner, E. F. Codd, K. L. Deckert, I. L. Traiger, "The Gamma Zero n-ary Relational Data Base Interface: Specifications of Objects and Operations," IBM San Jose Research Report RJ1200, April 11, 1973.

[13]

E. F. Codd, "A Data Base Sublanguage founded on the Relational Calculus," Proc. 1971 ACM-SIGFIDET Workshop.

[14]

E. F. Codd, "Relational Completeness of Data Base Sublanguages," Courant Computer Science Symposia 6, "Data Base Systems," New York City, May 24-25, 1971, Prentice Hall.

[15]

E. F. Codd, "Seven Steps to Rendezvous with the Casual User," Proc. IFIP TC-2 Working Conference on Data Base Management Systems, Cargese, Corsica, April 1-5, 1974, North-Holland, Amsterdam.

[16]

E. F. Codd, "Recent Investigations in Relational Data Base Systems," Information Processing 74, North-Holland, Amsterdam.

[17]

R. F. Boyce, D. D. Chamberlin, W. F. King III, M. M. Hammer, "Specifying Queries as Relational Expressions: SQUARE," Proc. ACM SIGPLAN-SIGIR Interface Meeting, Gaithersburg, Maryland, November 4-6, 1973.

Digital Library

[18]

Proc. SHARE Working Conference on Data Base Management Systems, Montreal, Quebec July 23-27, 1973, SHARE Distribution.

[19]

C. P. Earnest, "A Comparison of the Network and Relational Data Structure Models," Computer Sciences Corporation Report, E1 Segundo, California, April 1974.

[20]

E. F. Codd, "Normalized Data Base Structure: A Brief Tutorial," Proc. 1971 ACM-SIGFIDET Workshop.

[21]

E. F. Codd, "Derivability, Redundancy and Consistency of Relations Stored in Large Data Banks," IBM Research Report RJ599, August 19, 1969.

[22]

C. J. Date, "An Introduction to Database Systems," Addison Wesley (in preparation).

Digital Library

Cited By

Reznichenko V(2021)60 Years of DatabasesPROBLEMS IN PROGRAMMING10.15407/pp2021.03.040(040-071)Online publication date: Sep-2021
https://doi.org/10.15407/pp2021.03.040
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
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
Show More Cited By

Index Terms

Interactive support for non-programmers: The relational and network approaches
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

The relational and network approaches: Comparison of the application programming interfaces
SIGFIDET '74: Proceedings of the 1974 ACM SIGFIDET (now SIGMOD) workshop on Data description, access and control: Data models: Data-structure-set versus relational

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 ...
Pro T-SQL 2008 Programmers Guide
Database support for interactive computer graphics
SIGMOD '84: Proceedings of the 1984 ACM SIGMOD international conference on Management of data

Software applications involving interactive computer graphics are made up of several components. One of these is a data modeling component. This data modeling component is often application dependent and therefore difficult to integrate with the 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

34
Total Citations
View Citations
786
Total Downloads

Downloads (Last 12 months)95
Downloads (Last 6 weeks)20

Reflects downloads up to 04 Oct 2024

Other Metrics

View Author Metrics

Citations

Cited By

Reznichenko V(2021)60 Years of DatabasesPROBLEMS IN PROGRAMMING10.15407/pp2021.03.040(040-071)Online publication date: Sep-2021
https://doi.org/10.15407/pp2021.03.040
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
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
Kaufmann MWaldis ASiegfried PWilke GPortmann EHemmje M(2016)Intuitive Knowledge Connectivity: Design and Prototyping of Cross-Platform Knowledge NetworksKnowledge Science, Engineering and Management10.1007/978-3-319-47650-6_27(337-348)Online publication date: 5-Oct-2016
https://doi.org/10.1007/978-3-319-47650-6_27
Darwen HDate CFagin RDeutsch A(2012)A normal form for preventing redundant tuples in relational databasesProceedings of the 15th International Conference on Database Theory10.1145/2274576.2274589(114-126)Online publication date: 26-Mar-2012
https://dl.acm.org/doi/10.1145/2274576.2274589
Eessaar E(2007)Metamodel-based Comparison of Data ModelsAdvances and Innovations in Systems, Computing Sciences and Software Engineering10.1007/978-1-4020-6264-3_21(109-114)Online publication date: 2007
https://doi.org/10.1007/978-1-4020-6264-3_21
Date C(2005)An architecture for high-level language database extensionsECI Conference 197610.1007/3-540-07804-5_25(107-129)Online publication date: 24-May-2005
https://doi.org/10.1007/3-540-07804-5_25
Schauer U(2005)Ein System zur interaktiven Bearbeitung umfangreicher MeßdatenData Base Systems10.1007/3-540-07612-3_8(213-231)Online publication date: 23-May-2005
https://doi.org/10.1007/3-540-07612-3_8
Yannakoudakis EYannakoudakis E(1988)Data Structures and Data ModelsThe Architectural Logic of Database Systems10.1007/978-1-4471-1616-5_3(31-62)Online publication date: 1988
https://doi.org/10.1007/978-1-4471-1616-5_3
Shoval PEven-Chaime M(1987)Database schema design: an experimental comparison between normalization and information analysisACM SIGMIS Database: the DATABASE for Advances in Information Systems10.1145/27544.2754818:3(30-39)Online publication date: 1-Mar-1987
https://dl.acm.org/doi/10.1145/27544.27548
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 Publication

Media

Figures

Other

Tables

View Table of Contents