System R: relational approach to database management

@article{Astrahan1976SystemRR,
  title={System R: relational approach to database management},
  author={M. Astrahan and M. Blasgen and D. Chamberlin and K. Eswaran and J. Gray and Patricia P. Griffiths and W. F. King and R. Lorie and P. McJones and J. W. Mehl and G. R. Putzolu and I. Traiger and B. W. Wade and V. Watson},
  journal={ACM Trans. Database Syst.},
  year={1976},
  volume={1},
  pages={97-137}
}
System R is a database management system which provides a high level relational data interface. The systems provides a high level of data independence by isolating the end user as much as possible from underlying storage structures. The system permits definition of a variety of relational views on common underlying data. Data control features are provided, including authorization, integrity assertions, triggered transactions, a logging and recovery subsystem, and facilities for maintaining data… Expand
A relational data management system for electronic switching systems
TLDR
A relational data base management system (named DMC) designed to provide administrative software with a high level view of an Electronic Switching System (ESS) database is described, providing a data independent interface to application programs. Expand
Data access and storage in an entity relationship database system
TLDR
The setting-up of a database project at Manchester University is described together with the initial implementation of the database system which evolved from it, and the structure of the data storage subsystem is described and two data storage models are discussed. Expand
A data management extension architecture
TLDR
The data management extension architecture is described, which provides common services for coordination of storage method and attachment execution and some implementation issues and techniques. Expand
A retrospective of R*: A distributed database management system
  • B. Lindsay
  • Computer Science
  • Proceedings of the IEEE
  • 1987
TLDR
The guiding objectives of the R*effort are discussed, as well as several areas of the implementation which presented special difficulties or were simplified by design decisions. Expand
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
On extending the functions of a relational database system
TLDR
Additions to System R, a prototypical relational system, are introduced to satisfy demands: long fields, for storing non-coded data, and complex objects, which declare the semantic relationships among data items and provide a means for adequately supporting interactive access. Expand
Extending a database system with procedures
TLDR
This paper reports on the extensions for one particular query language and data manager and gives performance figures for a prototype implementation of this construct, and suggests that more powerful database systems can be built by supporting database procedures as full-fledged database objects. Expand
Relational data management and modeling systems: a tutorial
The purpose of this tutorial is to offer an overview of the relational model and relational database management systems (RDBMS) with particular emphasis on how they can be used in a managementExpand
Site autonomy issues in R*: A distributed database management system
TLDR
Some of the issues raised in the implementation of a DDBMS by the requirements of site autonomy are discussed from the perspective of the R ∗ research project at IBM's San Jose Research Lab. 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
...
1
2
3
4
5
...

References

SHOWING 1-10 OF 35 REFERENCES
An authorization mechanism for a relational database system
TLDR
A multiuser database system must selectively permit users to share data, while retaining the ability to restrict data access, and an algorithm for detecting exactly which of B's grants should be revoked is presented. Expand
Implementation of integrity constraints and views by query modification
TLDR
The mechanism being implemented in one relational system to prevent integrity violations which can result from improper updates by a process is indicated. Expand
An authorization mechanism for a relational data base system
TLDR
Because revocation may be performed dynamically, a user's authorization for a table must be checked dynamically and a scheme which attempts to minimize the cost of such revalidation is presented. Expand
A multi-level architecture for relational data base systems
TLDR
A multi-level architecture for relational data base systems that distinguishes clearly between user oriented features, access path structures, data structures and file organization, and allows efficiency problems to be isolated within levels and solved independently of each other, without impacting the logical structure of the user's virtual machine. Expand
Functional specifications of a subsystem for data base integrity
This paper defines an integrity subsystem for an integrated data base management system, and shows how integrity is distinguished from the related areas of security, consistency, and reliability. TheExpand
The MacAIMS data management system
TLDR
The MacAIMS Data Management System (MADAM) is based on a relational model of data, and employs set-theoretic primitive operations for manipulating data. Expand
Optimizing the performance of a relational algebra database interface
An approach for implementing a “smart” interface to support a relational view of data is proposed. The basic idea is to employ automatic programming techniques so that the interface analyzes andExpand
INGRES: a relational data base system
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 aExpand
SEQUEL 2: A Unified Approach to Data Definition, Manipulation, and Control
SEQUEL 2 is a relational data language that provides a consistent, English keyword-oriented set of facilities for query, data definition, data manipulation, and datac ontrol. SEQUEL 2 may be usedExpand
A multi-level relational system
TLDR
A relational data base is composed of a set of time varying relations inter-related through common domains. Expand
...
1
2
3
4
...