Article

Free access

A relational storage scheme suitable for derived views

Authors:

James R. Driscoll,

Beverly A. Dutton,

Kathryn C. KinsleyAuthors Info & Claims

ACM '78: Proceedings of the 1978 annual conference - Volume 2

Pages 602 - 611

https://doi.org/10.1145/800178.810097

Published: 01 January 1978 Publication History

PDF eReader

Abstract

A physical storage scheme used within a relational DBMS is described. The storage scheme is network in nature. The scheme implements physical linkage through shared attributes and enables data duplication to be eliminated. It results in a homogeneous structure for both permanent and temporary relations, and it is convenient for implementation of dynamic derived relations and supportability of updates by means of derived views. Our relational DBMS language incorporates unique features to facilitate the above objectives. These features make the user aware of the natural consequence of his data base.

References

[1]

Chamberlin, D. D. "Relational Data-Base Management Systems" ACM Computing Surveys, Vol. 8, No. 1, p. 54, March 1976.

Digital Library

Google Scholar

[2]

Codd, E. F. "Recent Investigations in Relational Data Base Systems" Information Processing 74, Proc. IFIP Congress, Vol. 5, North Holland Publ. Co., Amsterdam, The Netherlands, pp. 1017-1021, August 1974.

Google Scholar

[3]

Chen, C. H. Master's Project, Department of Computer Science, Florida Technological University, Orlando, Florida, in preparation.

Google Scholar

[4]

Driscoll, J. R. "Two Languages, and Their Environment, Founded on Basic DBMS Constructs" Proceedings of the Third Jerusalem Conference on Information Technology, Jerusalem, Israel, August 1978.

Google Scholar

[5]

Driscoll, J. R. "The Physical Representation of Data Models" Proceedings of ICMOD 78, Milan, Italy, June 1978.

Google Scholar

[6]

Dutton, B. A. and K. C. Kinsley "RAQUEL II -A Relational Query Language" Proceedings of the 16th Annual Southeast Regional ACM Conference, Atlanta, April 1978.

Digital Library

Google Scholar

[7]

Dutton, B. A. Master's Project, Department of Computer Science, Florida Technological University, Orlando, Florida, in preparation.

Google Scholar

[8]

Lien, Y. E. "Design and Implementation of a Relational Database on a Minicomputer" Proceedings of the 1977 ACM Annual Conference, Seattle, pp. 16-22, October 1977.

Digital Library

Google Scholar

[9]

Tsichritzis, D. C. and F. H. Lochovsky Data Base Management Systems, Academic Press, 1977.

Google Scholar

Cited By

View all

(1982)Final report of the ANSI/X3/SPARC DBS-SG relational database task groupACM SIGMOD Record10.1145/984555.110883012:4(1-62)Online publication date: 1-Jul-1982
https://dl.acm.org/doi/10.1145/984555.1108830
Kinsley KDriscoll J(1979)Dynamic derived relations within the RAQUEL II DBMSProceedings of the 1979 annual conference10.1145/800177.810034(69-80)Online publication date: 1-Jan-1979
https://dl.acm.org/doi/10.1145/800177.810034
Dutton BChing-hua Chen Driscoll J(1979)A relational dbms conforming to an architecture which incorporates a physical storage language and a physical navigation languageCOMPSAC 79. Proceedings. Computer Software and The IEEE Computer Society's Third International Applications Conference, 1979.10.1109/CMPSAC.1979.762461(31-38)Online publication date: 1979
https://doi.org/10.1109/CMPSAC.1979.762461

Index Terms

A relational storage scheme suitable for derived views
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

A very easy hierarchical DBMS implementation
ACM '79: Proceedings of the 1979 annual conference

The implementation of a DBMS offering a hierarchical view is described. The implementation follows a unique architecture designed to simplify DBMS implementation. The architecture incorporates basic physical storage constructs for specifying actual data ...
A visual database management tool: the design of a semi-intelligent DBA tool for a relational DBMS
DEXA '97: Proceedings of the 8th International Workshop on Database and Expert Systems Applications

The need for, as well as the design and implementation of a visual storage management tool to be used by a database administrator (DBA) of an Oracle RDBMS are examined, articulated and discussed. The problems that a DBA is likely to encounter in ...
Query processing over object views of relational data

This paper presents an approach to object view management for relational databases. Such a view mechanism makes it possible for users to transparently work with data in a relational database as if it was stored in an object-oriented (OO) database. A ...

Comments

Information & Contributors

Information

Published In

ACM '78: Proceedings of the 1978 annual conference - Volume 2

January 1978

990 pages

ISBN:0897910001

DOI:10.1145/800178

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 January 1978

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

3
Total Citations
View Citations
147
Total Downloads

Downloads (Last 12 months)17
Downloads (Last 6 weeks)4

Reflects downloads up to 10 Oct 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

(1982)Final report of the ANSI/X3/SPARC DBS-SG relational database task groupACM SIGMOD Record10.1145/984555.110883012:4(1-62)Online publication date: 1-Jul-1982
https://dl.acm.org/doi/10.1145/984555.1108830
Kinsley KDriscoll J(1979)Dynamic derived relations within the RAQUEL II DBMSProceedings of the 1979 annual conference10.1145/800177.810034(69-80)Online publication date: 1-Jan-1979
https://dl.acm.org/doi/10.1145/800177.810034
Dutton BChing-hua Chen Driscoll J(1979)A relational dbms conforming to an architecture which incorporates a physical storage language and a physical navigation languageCOMPSAC 79. Proceedings. Computer Software and The IEEE Computer Society's Third International Applications Conference, 1979.10.1109/CMPSAC.1979.762461(31-38)Online publication date: 1979
https://doi.org/10.1109/CMPSAC.1979.762461

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Get Access

Login options

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

Abstract

References

Cited By

Index Terms

Recommendations

A very easy hierarchical DBMS implementation

A visual database management tool: the design of a semi-intelligent DBA tool for a relational DBMS

Query processing over object views of relational data

Comments

Information

Published In

Publisher

Publication History

Permissions

Check for updates

Author Tags

Qualifiers

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

View options

PDF

eReader

Get Access

Login options

Full Access

Figures

Other

Share

Share this Publication link

Share on social media

Affiliations