A history and evaluation of System R

System R, an experimental database system, was constructed to demonstrate that the usability advantages of the relational data model can be realized in a system with the complete function and high performance required for everyday production use. This paper describes the three principal phases of the System R project and discusses some of the lessons learned from System R about the design of relational systems and database systems in general.

[1]  Irving L. Traiger,et al.  Granularity of Locks in a Large Shared Data Base. , 1975, VLDB 1975.

[2]  Ronald Fagin,et al.  On an authorization mechanism , 1978, TODS.

[3]  E. F. Codd,et al.  Further Normalization of the Data Base Relational Model , 1971, Research Report / RJ / IBM / San Jose, California.

[4]  Patricia G. Selinger,et al.  Access path selection in a relational database management system , 1979, SIGMOD '79.

[5]  Irving L. Traiger,et al.  System R: relational approach to database management , 1976, TODS.

[6]  Irving L. Traiger,et al.  The notions of consistency and predicate locks in a database system , 1976, CACM.

[7]  Raymond A. Lorie,et al.  The Compilation of a High Level Data Language , 1979, Research Report / RJ / IBM / San Jose, California.

[8]  Irving L. Traiger,et al.  The recovery manager of a data management system , 1979 .

[9]  Irving L. Traiger,et al.  Granularity of Locks and Degrees of Consistency in a Shared Data Base , 1998, IFIP Working Conference on Modelling in Data Base Management Systems.

[10]  Donald D. Chamberlin,et al.  Human factors evaluation of two data base query languages: square and sequel , 1975, AFIPS '75.

[11]  E. F. Codd,et al.  Recent Investigations in Relational Data Base Systems , 1974, ACM Pacific.

[12]  Donald D. Chamberlin,et al.  A History of System R and SQL/Data System (Invited Paper) , 1981, VLDB.

[13]  Irving L. Traiger,et al.  System R: A Relational Data Base Management System , 1979, Computer.

[14]  Donald D. Chamberlin,et al.  Functional specifications of a subsystem for data base integrity , 1975, VLDB '75.

[15]  Raymond A. Lorie,et al.  Physical integrity in a large segmented database , 1977, TODS.

[16]  Donald D. Chamberlin,et al.  SEQUEL: A structured English query language , 1974, SIGFIDET '74.

[17]  Douglas Comer,et al.  Ubiquitous B-Tree , 1979, CSUR.

[18]  Jim Gray,et al.  The convoy phenomenon , 1979, OPSR.

[19]  Irving L. Traiger,et al.  Granularity of locks in a shared data base , 1975, VLDB '75.

[20]  M. W. Blasgen,et al.  Storage and Access in Relational Data Bases , 1977, IBM Syst. J..

[21]  Jørgen Fischer Nilsson,et al.  An Access Specification Language for a Relational Data Base System , 1979, IBM J. Res. Dev..

[22]  Donald D. Chamberlin,et al.  SEQUEL 2: A Unified Approach to Data Definition, Manipulation, and Control , 1976, IBM J. Res. Dev..

[23]  Raymond A. Lorie,et al.  XRM - An Extended (N-ary) Relational Memory , 1974, Research Report / G / IBM / Cambridge Scientific Center.

[24]  Irving L. Traiger,et al.  Views, authorization, and locking in a relational data base system , 1975, AFIPS '75.

[25]  Bradford W. Wade,et al.  An authorization mechanism for a relational database system , 1976, TODS.

[26]  Patricia G. Selinger,et al.  Support for repetitive transactions and ad hoc queries in System R , 1981, TODS.

[27]  Richard G. Casey,et al.  An encoding method for multifield sorting and indexing , 1977, CACM.

[28]  Jim Gray,et al.  A Shared Segment and Interprocess Communication Facility for VM/370 , 1975, Research Report / RJ / IBM / San Jose, California.

[29]  E. F. Codd,et al.  Extending the database relational model to capture more meaning , 1979, ACM Trans. Database Syst..

[30]  H. Raymond Strong,et al.  Index Path Length Evaluation for the Research Storage System of System R , 1980, Research Report / RJ / IBM / San Jose, California.

[31]  Jim Gray,et al.  Notes on Data Base Operating Systems , 1978, Advanced Course: Operating Systems.

[32]  Irving L. Traiger,et al.  Transactions and consistency in distributed database systems , 1982, TODS.

[33]  Donald D. Chamberlin,et al.  Relational Data-Base Management Systems , 1976, CSUR.

[34]  Won Kim,et al.  Performance of the System R Access Path Selection Mechanism , 1980, IFIP Congress.

[35]  Paolo Tiberio,et al.  Considerations in developing a design tool for a relational DBMS , 1979, COMPSAC.

[36]  Donald D. Chamberlin.  A Summary of user Experience with the SQL Data Sublanguage , 1980, ICOD.

[37]  Donald D. Chamberlin,et al.  Relational database management systems , 1978 .

[38]  Donald D. Chamberlin,et al.  Using a Structured English Query Language as a Data Definition Facility , 1973, Research Report / RJ / IBM / San Jose, California.

[39]  G. G. Stokes.  "J." , 1890, The New Yale Book of Quotations.

[40]  E. F. CODD,et al.  A relational model of data for large shared data banks , 1970, CACM.

[41]  Michael Stonebraker,et al.  Implementation of integrity constraints and views by query modification , 1975, SIGMOD '75.

[42]  Ronald Fagin,et al.  Multivalued dependencies and a new normal form for relational databases , 1977, TODS.

[43]  Phyllis Reisner,et al.  Use of Psychological Experimentation as an Aid to Development of a Query Language , 1977, IEEE Transactions on Software Engineering.

[44]  Donald D. Chamberlin,et al.  Implementation of a structured English query language , 1975, CACM.

[45]  Michael Hammer,et al.  Specifying queries as relational expressions: the SQUARE data sublanguage , 1975, CACM.

[46]  Raymond A. Lorie,et al.  SEQUEL-XRM, A Relational System , 1975, ACM Pacific.

[47]  Bruce G. Lindsay,et al.  Database Snapshots , 1980, VLDB.