The design of POSTGRES
- 15 June 1986
- journal article
- Published by Association for Computing Machinery (ACM) in ACM SIGMOD Record
- Vol. 15 (2), 340-355
- https://doi.org/10.1145/16856.16888
Abstract
This paper presents the preliminary design of a new database management system, called POSTGRES, that is the successor to the INGRES relational database system. The main design goals of the new system are to provide better support for complex objects, provide user extendibility for data types, operators and access methods, provide facilities for active databases (i.e., alerters and triggers) and inferencing including forward- and backward-chaining, simplify the DBMS code for crash recovery, produce a design that can take advantage of optical disks, workstations composed of multiple tightly-coupled processors, and custom designed VLSI chips, and make as few changes as possible (preferably none) to the relational model. The paper describes the query language, programming language interface, system architecture, query processing strategy, and storage system for the new system.Keywords
This publication has 18 references indexed in Scilit:
- Information Management for Engineering DesignPublished by Springer Science and Business Media LLC ,1985
- Making smalltalk a database systemPublished by Association for Computing Machinery (ACM) ,1984
- R-treesPublished by Association for Computing Machinery (ACM) ,1984
- A form application development systemPublished by Association for Computing Machinery (ACM) ,1982
- The K-D-B-treePublished by Association for Computing Machinery (ACM) ,1981
- Efficiently monitoring relational databasesACM Transactions on Database Systems, 1979
- Data abstraction, views and updates in RIGELPublished by Association for Computing Machinery (ACM) ,1979
- 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
- A relational model of data for large shared data banksCommunications of the ACM, 1970