Article

Free access

The INGRES protection system

Authors:

Michael Stonebraker,

Peter RubinsteinAuthors Info & Claims

ACM '76: Proceedings of the 1976 annual conference

Pages 80 - 84

https://doi.org/10.1145/800191.805536

Published: 20 October 1976 Publication History

PDF eReader

Abstract

This paper presents the design of a protection system being implemented for the INGRES relational data base management system. A brief description of the INGRES system and its operational environment is first presented to provide the setting for the protection scheme. Mechanisms for protecting physical data files and enforcing sophisticated access control rules for shared relations are then presented. Lastly, the important design decisions concerning protection are discussed.

References

[1]

Allman, E., Stonebraker, M., and Held, G. "Embedding a Relational Data Sub-language in a General Purpose Programming Language", Proc. ACM SIGPLAN-SIGMOD Workshop on Data, Salt Lake City, Utah, March, 1976.

Digital Library

Google Scholar

[2]

Boyce, R. et. al., "Specifying Queries as Relational Expressions: SQUARE", IBM Research, San Jose, Ca., RJ 1291, Oct. 1973.

Google Scholar

[3]

Chamberlin, D. and Boyce, R., "SEQUEL: A Structured English Query Language", Proc. 1974 ACM-SIGFIDET Workshop on Data Description, Access and Control, Ann Arbor, Mich., May 1974.

Digital Library

Google Scholar

[4]

Chamberlin, D., Gray, J.N., and Traiger, I.L., "Views, Authorization and Locking in a Relational Data Base System", Proc. 1975 National Computer Conference, AFIPS Press, May 1975.

Digital Library

Google Scholar

[5]

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

Google Scholar

[6]

Codd, E.F., "Relational Completeness of Data Base Sublanguages", Courant Computer Science Symposium 6, May 1972.

Google Scholar

[7]

Held. G.D., Stonebraker, M. and Wong, E., "INGRES-A Relational Data Base Management System", Proc. 1975 National Computer Conference, AFIPS Press, 1975.

Google Scholar

[8]

Hoffman, L. "The Formulary Model for Access Control and Privacy" Stanford Linear Acceleration Report 117, May, 1970

Google Scholar

[9]

Ritchie, D.M. C Reference Manual UNIX Programmer's Manual, Bell Telephone Labs, Murray Hill, N.J. July 1974.

Google Scholar

[10]

Stonebraker, M. and Wong, E., "Access Control in a Relational Data Base Management System by Query Modification", Proc. 1974 ACM National Conference, San Diego, Ca., Nov. 1974

Digital Library

Google Scholar

[11]

Stonebraker, M. "A Functional View of Data Independence," Proc. 1974 ACM-SIGFIDET Workshop on Data Description, Access and Control, Ann Arbor Mich, May 1974

Digital Library

Google Scholar

[12]

Stonebraker, M., "Implementation of Integrity Constraints and Views by Query Modification", Proc 1975 SIGMOD Workshop on Management of Data, San Jose, Ca., May 1975.

Digital Library

Google Scholar

[13]

Stonebraker, M.R., Wong, E., Held, G.D. and Kreps, P., "The Design and Implementation of INGRES", ACM Transactions on Data Base Systems, Vol.1, No.3.

Digital Library

Google Scholar

[14]

Zook, W., Youssefi. K., Whyte, N., Rubinstein, P., Kreps, P., Held, G., Ford, J., Berman, R., and Allman, E. "INGRES-Reference Manual-Version 6", University of California, Electronics Research Laboratory, Memo. No. ERL-M579, April, 1976.

Google Scholar

Cited By

View all

Rosenthal ASciore E(2025)Content-Based and View-Based Access ControlEncyclopedia of Cryptography, Security and Privacy10.1007/978-3-030-71522-9_695(425-429)Online publication date: 8-Jan-2025
https://doi.org/10.1007/978-3-030-71522-9_695
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
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

The INGRES protection system
1. Information systems
  1. Data management systems

Recommendations

INGRES: a relational data base system
AFIPS '75: Proceedings of the May 19-22, 1975, national computer conference and exposition

INGRES (Interactive Graphics and Retrieval System) is a relational data base and graphics system which is being implemented on a PDP-11/40 based hardware configuration at Berkeley. INGRES runs as a normal user job on top of the UNIX operating system ...
History of the Ingres Corporation

Developed at the University of California, Berkeley, beginning in 1972, the INGRES relational database management system was originally a research prototype that helped to prove the viability of relational systems. This article describes the subsequent ...
Using the INGRES relational database system in statistical applications
SSDBM'81: Proceedings of the 1st LBL Workshop on Statistical database management

This paper presents the use of INGRES, a relational database management system, in solving several complex statistical database problems, as presented in Robert Teitel's paper, Volume Testing of Statistical Software. One set of problems involves a ...

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

ACM '76: Proceedings of the 1976 annual conference

October 1976

576 pages

ISBN:9781450374897

DOI:10.1145/800191

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: 20 October 1976

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

17
Total Citations
View Citations
382
Total Downloads

Downloads (Last 12 months)64
Downloads (Last 6 weeks)10

Reflects downloads up to 14 Feb 2025

Other Metrics

View Author Metrics

Citations

Cited By

View all

Rosenthal ASciore E(2025)Content-Based and View-Based Access ControlEncyclopedia of Cryptography, Security and Privacy10.1007/978-3-030-71522-9_695(425-429)Online publication date: 8-Jan-2025
https://doi.org/10.1007/978-3-030-71522-9_695
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
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
Jonscher DDittrich K(1994)An Approach for Building Secure Database FederationsProceedings of the 20th International Conference on Very Large Data Bases10.5555/645920.672978(24-35)Online publication date: 12-Sep-1994
https://dl.acm.org/doi/10.5555/645920.672978
Fernandez EGudes ESong H(1994)A Model for Evaluation and Administration of Security in Object-Oriented DatabasesIEEE Transactions on Knowledge and Data Engineering10.1109/69.2777716:2(275-292)Online publication date: 1-Apr-1994
https://dl.acm.org/doi/10.1109/69.277771
Pernul G(1994)Database SecurityAdvances in Computers Volume 3810.1016/S0065-2458(08)60175-8(1-72)Online publication date: 1994
https://doi.org/10.1016/S0065-2458(08)60175-8
Weems BShieh WJaseemuddin M(1991)Complete containment sets and their application to the inference problemProceedings Seventh Annual Computer Security Applications Conference10.1109/CSAC.1991.213006(187-200)Online publication date: 1991
https://doi.org/10.1109/CSAC.1991.213006
Biskup JBruggemann H(1989)The personal model of data towards a privacy oriented information system[1989] Proceedings. Fifth International Conference on Data Engineering10.1109/ICDE.1989.47235(348-355)Online publication date: 1989
https://doi.org/10.1109/ICDE.1989.47235
Spooner DD'Auria TTartar J(1983)Specification of content-dependent security policiesProceedings of the 1983 annual conference on Computers : Extending the human resource10.1145/800173.809719(141-145)Online publication date: 1-Jan-1983
https://dl.acm.org/doi/10.1145/800173.809719
Katz RCrabbe JRadke COfek H(1982)A database approach for managing VLSI design dataProceedings of the 19th Design Automation Conference10.5555/800263.809218(274-282)Online publication date: 1-Jan-1982
https://dl.acm.org/doi/10.5555/800263.809218
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

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

Cited By

Index Terms

Recommendations

INGRES: a relational data base system

History of the Ingres Corporation

Using the INGRES relational database system in statistical applications