The design and implementation of INGRES
- 1 September 1976
- journal article
- Published by Association for Computing Machinery (ACM) in ACM Transactions on Database Systems
- Vol. 1 (3) , 189-222
- https://doi.org/10.1145/320473.320476
Abstract
The currently operational (March 1976) version of the INGRES database management system is described. This multiuser system gives a relational view of data, supports two high level nonprocedural data sublanguages, and runs as a collection of user processes on top of the UNIX operating system for Digital Equipment Corporation PDP 11/40, 11/45, and 11/70 computers. Emphasis is on the design decisions and tradeoffs related to (1) structuring the system into processes, (2) embedding one command language in a general purpose programming language, (3) the algorithms implemented to process interactions, (4) the access methods implemented, (5) the concurrency and recovery control currently provided, and (6) the data structures used for system catalogs and the role of the database administrator. Also discussed are (1) support for integrity constraints (which is only partly operational), (2) the not yet supported features concerning views and protection, and (3) future plans concerning the system.Keywords
This publication has 15 references indexed in Scilit:
- Decomposition—a strategy for query processingACM Transactions on Database Systems, 1976
- System RACM Transactions on Database Systems, 1976
- Embedding a relational data sublanguage in a general purpose programming languagePublished by Association for Computing Machinery (ACM) ,1976
- SEQUELPublished by Association for Computing Machinery (ACM) ,1976
- The relational and network approachesPublished by Association for Computing Machinery (ACM) ,1975
- Interactive support for non-programmersPublished by Association for Computing Machinery (ACM) ,1975
- Views, authorization, and locking in a relational data base systemPublished by Association for Computing Machinery (ACM) ,1975
- The UNIX time-sharing systemCommunications of the ACM, 1974
- A data base sublanguage founded on the relational calculusPublished by Association for Computing Machinery (ACM) ,1971
- A relational model of data for large shared data banksCommunications of the ACM, 1970