System R
Based on the System R bibliography by Donald D. Chamberlin
System R WWW page
by Paul R. McJones
Some other early relational systems:
System R Publications
1973
1974
1975
- Morton M. Astrahan, Donald D. Chamberlin:
Implementation of a Structured English Query Language.
Commun. ACM 18(10): 580-588(1975)
- Morton M. Astrahan, Raymond A. Lorie:
SEQUEL-XRM, A Relational System.
ACM Pacific 1975: 34-38
- Raymond F. Boyce, Donald D. Chamberlin, W. Frank King III, Michael Hammer:
Specifying Queries as Relational Expressions: The SQUARE Data Sublanguage.
Commun. ACM 18(11): 621-628(1975)
- Donald D. Chamberlin, Jim Gray, Irving L. Traiger:
Views, Authorization, and Locking in a Relational Data Base System.
AFIPS National Computer Conference 1975: 425-430
- Kapali P. Eswaran, Donald D. Chamberlin:
Functional Specifications of Subsystem for Database Integrity.
VLDB 1975: 48-68
- Jim Gray, Raymond A. Lorie, Gianfranco R. Putzolu, Irving L. Traiger:
Granularity of Locks in a Large Shared Data Base.
VLDB 1975: 428-451
- Jim Gray, Vera Watson:
A Shared Segment and Interprocess Communication Facility for VM/370.
IBM Research Report RJ1579: (1975)
- Phyllis Reisner, Raymond F. Boyce, Donald D. Chamberlin:
Human factors evaluation of two data base query languages: SQUARE and SEQUEL.
AFIPS National Computer Conference 1975: 447-452
1976
- Morton M. Astrahan, Mike W. Blasgen, Donald D. Chamberlin, Kapali P. Eswaran, Jim Gray, Patricia P. Griffiths, W. Frank King III, Raymond A. Lorie, Paul R. McJones, James W. Mehl, Gianfranco R. Putzolu, Irving L. Traiger, Bradford W. Wade, Vera Watson:
System R: Relational Approach to Database Management.
ACM Trans. Database Syst. 1(2): 97-137(1976)
- Donald D. Chamberlin:
Relational Data-Base Management Systems.
ACM Comput. Surv. 8(1): 43-66(1976)
- Donald D. Chamberlin, Morton M. Astrahan, Kapali P. Eswaran, Patricia P. Griffiths, Raymond A. Lorie, James W. Mehl, Phyllis Reisner, Bradford W. Wade:
SEQUEL 2: A Unified Approach to Data Definition, Manipulation, and Control.
IBM Journal of Research and Development 20(6): 560-575(1976)
- Kapali P. Eswaran, Jim Gray, Raymond A. Lorie, Irving L. Traiger:
The Notions of Consistency and Predicate Locks in a Database System.
Commun. ACM 19(11): 624-633(1976)
- Jim Gray, Raymond A. Lorie, Gianfranco R. Putzolu, Irving L. Traiger:
Granularity of Locks and Degrees of Consistency in a Shared Data Base.
IFIP Working Conference on Modelling in Data Base Management Systems 1976: 365-394
- Patricia P. Griffiths, Bradford W. Wade:
An Authorization Mechanism for a Relational Database System.
ACM Trans. Database Syst. 1(3): 242-255(1976)
1977
1978
- Donald D. Chamberlin,
Jim Gray,
Patricia P. Griffiths,
M. Mresse,
Irving L. Traiger,
Bradford W. Wade:
Data Base System Authorization.
in Foundations of Secure Computation (edited by R. Demillo, D. Dobkin, A. Jones, and R. Lipton), Academic Press, 1978, p. 39
- Ronald Fagin:
On an Authorization Mechanism.
ACM Trans. Database Syst. 3(3): 310-319(1978)
- Jim Gray:
Notes on Data Base Operating Systems.
Advanced Course: Operating Systems 1978: 393-481
- H. Raymond Strong, Irving L. Traiger, George Markowsky:
Slide Search.
IBM Research Report RJ2274: (1978)
1979
- Morton M. Astrahan, Mike W. Blasgen, Donald D. Chamberlin, Jim Gray, W. Frank King III, Bruce G. Lindsay, Raymond A. Lorie, James W. Mehl, Thomas G. Price, Gianfranco R. Putzolu, Mario Schkolnick, Patricia G. Selinger, Donald R. Slutz, H. Raymond Strong, Paolo Tiberio, Irving L. Traiger, Bradford W. Wade, Robert A. Yost:
System R: A Relational Data Base Management System.
IEEE Computer 12(5): 42-48(1979)
- Mike W. Blasgen, Jim Gray, Michael F. Mitoma, Thomas G. Price:
The Convoy Phenomenon.
Operating Systems Review 13(2): 20-25(1979)
- Patricia G. Selinger, Morton M. Astrahan, Donald D. Chamberlin, Raymond A. Lorie, Thomas G. Price:
Access Path Selection in a Relational Database Management System.
SIGMOD Conference 1979: 23-34
- Raymond A. Lorie, Jørgen Fischer Nilsson:
An Access Specification Language for a Relational Data Base System.
IBM Journal of Research and Development 23(3): 286-298(1979)
- Raymond A. Lorie, Bradford W. Wade:
The Compilation of a High Level Data Language.
IBM Research Report RJ2598: (1979)
- Irving L. Traiger, Jim Gray, Cesare A. Galtieri, Bruce G. Lindsay:
Transactions and Consistency in Distributed Database Systems.
IBM Research Report RJ2555: (1979)
- Mario Schkolnick, Paolo Tiberio:
Considerations in Developing a Design Tool for a Relational DBMS.
COMPSAC 1979: 228-235
1980
1981
- Mike W. Blasgen, Morton M. Astrahan, Donald D. Chamberlin, Jim Gray, W. Frank King III, Bruce G. Lindsay, Raymond A. Lorie, James W. Mehl, Thomas G. Price, Gianfranco R. Putzolu, Mario Schkolnick, Patricia G. Selinger, Donald R. Slutz, H. Raymond Strong, Irving L. Traiger, Bradford W. Wade, Robert A. Yost:
System R: An Architectural Overview.
IBM Systems Journal 20(1): 41-62(1981)
- Donald D. Chamberlin, Morton M. Astrahan, Mike W. Blasgen, Jim Gray, W. Frank King III, Bruce G. Lindsay, Raymond A. Lorie, James W. Mehl, Thomas G. Price, Gianfranco R. Putzolu, Patricia G. Selinger, Mario Schkolnick, Donald R. Slutz, Irving L. Traiger, Bradford W. Wade, Robert A. Yost:
A History and Evaluation of System R.
Commun. ACM 24(10): 632-646(1981)
- Donald D. Chamberlin, Morton M. Astrahan, W. Frank King III, Raymond A. Lorie, James W. Mehl, Thomas G. Price, Mario Schkolnick, Patricia G. Selinger, Donald R. Slutz, Bradford W. Wade, Robert A. Yost:
Support for Repetitive Transactions and Ad Hoc Queries in System R.
ACM Trans. Database Syst. 6(1): 70-94(1981)
- Donald D. Chamberlin, A. M. Gilbert, Robert A. Yost:
A History of System R and SQL/Data System (Invited Paper).
VLDB 1981: 456-464
- E. F. Codd:
The Significance of the SQL/Data System Announcement.
Computerworld 15(7): 27-30(1981)
- Jim Gray, Paul R. McJones, Mike W. Blasgen, Bruce G. Lindsay, Raymond A. Lorie, Thomas G. Price, Gianfranco R. Putzolu, Irving L. Traiger:
The Recovery Manager of the System R Database Manager.
ACM Comput. Surv. 13(2): 223-243(1981)
- SQL/Data System, General Information Manual.
IBM Publication GH24-5012: (1981)
- SQL/Data System, Conpects and Facilities.
IBM Publication GH24-5013: (1981)
- SQL/Data System for VSE: A Relational Data System for Application Development.
IBM Publication G320-6590: (1981)
1982
1995
- The 1995 SQL Reunion: People, Project, and Politics, May 29, 1995.
Digital System Research Center Report SRC1997-018: (1997)
Acknowledgement: These papers were collected by Paul R. McJones
for the ACM SIGMOD Anthology.
System R People
based the System R People Page by Paul R. McJones
- Michel E. Adiba (1979-1980): designs for
R* snapshots, derived relations, distributed catalog. <Michel.Adiba@imag.fr>
- Mike W. Blasgen:
RSS index component, manager of
RSS, manager of System R. <michael@blasgen.com>
- Donald D. Chamberlin:
manager of RDS, co-designer
of SQL. <chamberlin@almaden.ibm.com>
- David M. Choy:
Fast loader, reorg utility, runstat,
catalog. <dmc@almaden.ibm.com>
- Ronald Fagin:
authorization, indexing, and theory
(including normalization). <fagin@almaden.ibm.com>
- Jim Gray:
IBM: RSS transaction component; SQL/DS
consulting, SQL/DS, DB2, IMS Fast Path efforts;
Tandem: NonStop SQL; FastSort, and Pathmaker; DEC: Rdb, TP and AlphaSort;
Microsoft: NTclusters. <gray@microsoft.com>
- Donald J. Haderle:
DB2 (1978-): chief architect, IBM Fellow, architecture and development of IBM's other
relational database managers and related products. <dhaderle@vnet.ibm.com>
- Theo Härder (1976):
RSS sort/merge component.
<haerder@informatik.uni-kl.de>
- Bob Jolls:
manager of SQL/DS at Santa Teresa; manager
of VS/QUERY (QMF); manager of DB2 (1980-1981). <Bobjolls@aol.com>
- W. Frank King III:
manager of System R. <king@concero.com>
- Bruce G. Lindsay:
RSS storage pools; R* architect. <bgl@almaden.ibm.com>
- Guy M. Lohman (1982-): R* optimizer. <lohman@almaden.ibm.com>
- Raymond A. Lorie:
XRM; RSS: buffer management, shadow pages, transaction management; RDS: compilation of SQL, optimization. <lorie@almaden.ibm.com>
- Paul R. McJones
(1975-1976): RSS crash recovery;
author of the System R web site.
<paul.mcjones@acm.org>
- James W. Mehl:
System R: SQL parser, MVS port, Boeing
joint study contact. <JimMehl@acm.org>
- Roger L. Miller
(1979-): DB2: lead strategist, planning, and development (SQL, languages, install, security, audit, standards, performance, concurrency, and availability). <millerrl@us.ibm.com>
- C. Mohan
(1981-): R* transaction management, ARIES, DB2, MQSeries and
Lotus Domino recovery and locking. <mohan@almaden.ibm.com>
- John Nauman:
DB2 development manager. <john@johnnauman.com>
- Thomas G. Price:
RSS: buffer manager, latches, alternate
(never-implemented) recovery manager design that didn't use shadow pages;
RDS: optimizer. <tom.price@ieee.org>
- Gianfranco R. Putzolu:
RSS record component, Technology Evaluation (IBM DB2 prototype); Tandem NonStop SQL.
<fputzolu@us.oracle.com>
- Mario Schkolnick:
RDS optimizer, database design tools. <schkol@schkol.engr.sgi.com>
- Patricia G. Selinger:
RDS optimizer, precompiler,
authorization; R* optimizer and compiler. <pgs@us.ibm.com>
- Donald R. Slutz:
RDS; Esvel; Tandem NonStop SQL. <dslutz@microsoft.com>
- Paolo Tiberio:
(1978-1979, 1981): Update cost
evaluation, System R-based database design tool. <paolo.tiberio@unimo.it>
- Irving L. Traiger:
manager of RSS component of System
R. <traigerik@worldnet.att.net>
- Bradford W. Wade:
RDS: authorization, code generator, catalog
creation, performance, UFI, installation procedures. <bwade@almaden.ibm.com>
Copyright © Tue Feb 9 19:19:04 2010
by Michael Ley (ley@uni-trier.de)