Views, authorization, and locking in a relational data base system

ABSTRACT

In the interest of brevity we assume that the reader is familiar with the notion of a relational data base. In particular, we assume a familiarity with the work of Codd or Boyce and Chamberlin. The examples in this paper will be drawn from a data base which describes a department store and consists of three relations:

EMP(NAME, SAL, MGR, DEPT)

SALES(DEPT, ITEM, VOL)

LOC(DEPT, FLOOR)

REFERENCES

• 1: E. F. Codd, A relational model of data for large shared data banks, Communications of the ACM, v.13 n.6, p.377-387, June 1970 [doi>10.1145/362384.362685]
• 2: Codd, E. F., "A Data Base Sublanguage Founded on the Relational Calculus," Proceedings of 1971 ACM SIGFIDET Workshop on Data Description, Access, and Control, San Diego, California, November 1971.
• 3: Codd, E. F., "Further Normalization of the Data Base Relational Model," Courant Computer Science Symposia, Vol. 6, Data Base Systems, Prentice Hall, New York, May 1971.
• 4: Codd, E. F., "Relational Completeness of Data Base Sublanguages," Courant Computer Science Symposia, Vol. 6, Data Base Systems, Prentice Hall, New York, May 1971.
• 5: Codd, E. F., "Recent Investigations in Relational Data Base Systems," Proceedings of IFIP Congress 74, Stockholm, Sweden, August 1974.
• 6: Donald D. Chamberlin , Raymond F. Boyce, SEQUEL: A structured English query language, Proceedings of the 1974 ACM SIGFIDET (now SIGMOD) workshop on Data description, access and control, p.249-264, May 01-03, 1974, Ann Arbor, Michigan [doi>10.1145/800296.811515]
• 7: Boyce, R. F., D. D. Chamberlin, Using a Structured English Query Language as a Data Definition Facility, IBM Research report: RJ 1318, San Jose, California, December 1973.
• 8: R. F. Boyce , D. D. Chamberlin , M. M. Hammer , W. F. King, Specifying queries as relational expressions, Proceedings of the 1973 meeting on Programming languages and information retrieval, p.31-47, November 04-06, 1973, Gaithersburg, Maryland
• 9: Anonymous, Information Management System Virtual Storage System (IMS/VS)---System/Application Design Guide, IBM form No: SH20-9025, pp. 3.72--3.73, IBM Corporation, Palo Alto' California, 1971.
• 10: CODASYL, "Data Base task group report," ACM, New York, 1971.
• 11: Summers, R. C., C. D. Coleman, E. B. Fernandez, A Programming Language Approach to Secure Data Bases, IBM Los Angeles Scientific Center Technical Report: G320-2662, Los Angeles California, May 1974.
• 12: Stonebraker, M., E. Wong, Access Control in a Relational Data Base Management System by Query Modification, Electronics Research Laboratory memorandum: ERL-M438, UC Berkeley, California, May 1974.
• 13: Minsky, N., Protection of Data-Bases, and the Process of Data-Base Interaction, Computer Science Department, Rutgers, New Brunswick, N.J., September 1974.
• 14: R. C. Owens, PRIMARY ACCESS CONTROL IN LARGE-SCALE TIME-SHARED DECISION SYSTEMS, Massachusetts Institute of Technology, Cambridge, MA, 1971
• 15: Eswaran, K. E., J. N. Gray, R. A. Lorie, I. L. Traiger, The Notions of Consistency and Predicate Locks, IBM Research report: RJ 1487, San Jose, California, December 1974.