A history and evaluation of System R

@article{Chamberlin1981AHA,
  title={A history and evaluation of System R},
  author={Donald D. Chamberlin and Morton M. Astrahan and Mike W. Blasgen and Jim Gray and W. Frank King and Bruce G. Lindsay and Raymond A. Lorie and James W. Mehl and Thomas G. Price and Gianfranco R. Putzolu and Patricia G. Selinger and Mario Schkolnick and Donald R. Slutz and Irving L. Traiger and Bradford W. Wade and Robert A. Yost},
  journal={Commun. ACM},
  year={1981},
  volume={24},
  pages={632-646}
}
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. 
A History of System R and SQL/Data System (Invited Paper)
TLDR
This paper traces the development of System R as a research prototype and its evolution into the SQL/DS product. Expand
Design and implementation of the wisconsin storage system
We describe the implementation of a flexible data storage system for the UNIX environment that has been designed as an experimental vehicle for building database management systems. The storageExpand
Thirty years (and more) of databases
  • M. Jackson
  • Computer Science
  • Inf. Softw. Technol.
  • 1999
TLDR
The need for data independence and the embedding of structural and behavioural semantics in the database as key issues in the development of modern systems are identified. Expand
An Overview of Three Relational Data Base Products
  • S. Kahn
  • Computer Science
  • IBM Syst. J.
  • 1984
TLDR
This essay illustrates the requirements that these products were designed to address and gives a brief overview of their content and history to provide an introduction to the more specific and detailed papers that follow. Expand
Stored Queries - a Data Organization for Query Optimization
TLDR
The main properties of such a data organization as well as its essential problems are outlined, particularly the problem of updating stored queries, and two methods for solution of this problem, elimination and correction are presented. Expand
The small-computer data base system DVSR
Abstract The rationale for the design of the DVSR database system is discussed. Advantages of the relational data model for small computer database applications are given. The system's user interfaceExpand
IBM Database 2 Overview
TLDR
The major features of DB2 are presented and its architecture and the relationship ofDB2 with the host operating system are discussed and illustrated by an example. Expand
Physical Database Design: Techniques for Improved Database Performance
TLDR
This paper addresses two areas of physical database design: record structuring and access path design (the design of algorithms and system structures used to determine the physical location of records and to support content dependent retrieval). Expand
Combining Systems and Databases: A Search Engine Retrospective
TLDR
This paper presents how a search engine should have been designed in hindsight using the ideas and vocabulary of the database community as a model of how to design data-intensive systems and draws some conclusions about the application of database principles to other “out of the box” data- intensive systems. Expand
Representing Databases in ames
Three methods for representing data in a relational storage system with an in-core frame-based system are experimented with and reported upon. Tradeoffs among these three representational methods areExpand
...
1
2
3
4
5
...

References

SHOWING 1-10 OF 73 REFERENCES
A History of System R and SQL/Data System (Invited Paper)
TLDR
This paper traces the development of System R as a research prototype and its evolution into the SQL/DS product. Expand
System R: relational approach to database management
TLDR
This paper contains a description of the overall architecture and design of the system, and emphasizes that System R is a vehicle for research in database architecture, and is not planned as a product. Expand
System R: A Relational Data Base Management System
TLDR
A relational approach makes this experimental data base management system unusually easy to install and use and offers major bonuses in other areas. Expand
Access path selection in a relational database management system
TLDR
This paper describes how System R chooses access paths for both simple (single relation) and complex queries (such as joins) given a user specification of desired data as a boolean expression of predicates. Expand
Implementation of a structured English query language
TLDR
The relational model of data, the XRM Relational Memory System, and the SEQUEL language, a relational data sublanguage intended for ad hoc interactive problem solving by non-computer specialists, are reviewed. Expand
Storage and Access in Relational Data Bases
TLDR
Results indicate that physical clustering of logically adjacent items is a critical performance parameter for relational query evaluation and methods that depend on sorting the records themselves seem to be the algorithm of choice. Expand
Views, authorization, and locking in a relational data base system
TLDR
The examples in this paper will be drawn from a data base which describes a department store and consists of three relations: EMP, SAL, MGR, DEPT, and LOC. Expand
An Access Specification Language for a Relational Data Base System
TLDR
It is conjecture that the introducing of an access specification language provides a conceptual platform for the handling of the "optimization" problem and is implemented as a target language for the optimizer part of the complier. Expand
Relational Data-Base Management Systems
TLDR
The relational model of data is described, which allows several applications to share a common bank of data, maintained and protected by a central system, and provides each application program with its own view of the common data. Expand
Support for repetitive transactions and ad hoc queries in System R
TLDR
The architecture of System R is described, some preliminary measurements of system performance in both the ad hoc query and the “canned program” environments are given, and much of the work of parsing, name binding, and access path selection from the path of a running program is removed. Expand
...
1
2
3
4
5
...