article

Free access

The design of POSTGRES

Authors:

Michael Stonebraker,

Lawrence A. RoweAuthors Info & Claims

ACM SIGMOD Record, Volume 15, Issue 2

Pages 340 - 355

https://doi.org/10.1145/16856.16888

Published: 15 June 1986 Publication History

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.

References

[1]

Adlba, ME and Llndsay, B G, "Database Snapshots," IBM San Jose Res Tech Rep RJ-2772, March 1980

[2]

Afasarmanesh,H, et al, "An Extenslble Object-Oriented Approach to Database for VLSI/CAD," Proc 1985 Very Large Data Base Conference, Stockholm, Sweden, August 1985

[3]

Allman, E, et al, "Embedding a Relational Data Sublanguage m a General Purpose Programming Language," Proc 1976 ACM- SIGPLAN-SIGMOD Conference on Data, Salt Lake City, Utah, March 1976

Digital Library

[4]

Astrhan, M et al, "System R A Relational Approach to Data," ACM-TODS, June 1976

Digital Library

[5]

Atklnson, M P et al, "Progress with Persistent Programming," m Database, Role and Structure (ed P Stocker), Cambridge Umverlsty of Press, 1984

[6]

Bunemann, P and Clemons, E, "Effictently Momtormg Relational Data Bases," ACM-TODS, Sept 1979

Digital Library

[7]

Clocksm, W and Melhsh, C, "Programmlng m Prolog," Springer~ Verlag, Berlin, Germany, 1981

[8]

Codd, E, "A Relational Model of Data for Large Shared Data Bases," CACM, June 1970

Digital Library

[9]

Copeland, G and D Maler, "Making Smalltalk a Database System," Proc 1984 ACM-SIGMOD Conference on Management of Data, Boston, Mass June 1984

Digital Library

[10]

Dermtt, N, Personal Commumcatlon, HP Laboratomes, October 1985

[11]

DeWltt, DJ and Carey, M J, "Extenslble Database Systems," Proc 1st International Workshop on Expert Data Bases, Klowah, S C, Oct 1984

[12]

Eswaren, K, "A General Purpose Tmgger Subsystem and Its Inclusion m a Relatmnal Data Base System," IBM Research, San Jose, Ca, RJ 1833, July 1976

[13]

Garcla-Mohna, H, et al, "Data- Patch Integrating Inconsistent copies of a Database after a Partltmn," Tech Rep TR# 304, Dept Elec Eng and Comp Scl, Princeton Umv, 1984

[14]

Held, G et al, "INGRES A Relational Data Base System," Proc 1975 Natmnal Computer Conference, Anaheim, Ca, June 1975

[15]

Gutman, A, "R-trees A Dynamic Index Structure for Spatial Searchrag," Proc 1984 ACM-SIGMOD Conference on Management of Data, Boston, Mass June 1984

Digital Library

[16]

Jarke, M et al, "Data Constructors On the Integration of Rules and Relations," Proc 1985 Very Large Data Base Conference, Stockholm, Sweden, August 1985

[17]

Katz, R H, Information Management for Englneemng Design, Spmnger-Verlag, 1985

Digital Library

[18]

Kung, R et al, "Heumstlc Search m Database Systems," Proc 1st Internatmnal Workshop on Expert Data Bases, Kmwah, SC, Oct 1984

Digital Library

[19]

LorIe, R, and Plouffe, W, "Complex Objects and Their Use m Desmg Transactmns," Proc Eng Design Applications of ACM-IEEE Data Base Week, San Jose, CA, May 1983

[20]

Lum, V, et al, "Design of an Integrated DB MS to Support Advanced Apphcatmns," Proc Int Conf on Foundatmns of Data Org, Kyoto Umv, Japan, May 1985

[21]

Robinson, J, "The K-D-B Tree A Search Structure for Large Multldlmensmnal Indexes," Proc 1981 ACM-SIGMOD Conference on Management of Data, Ann Arbor, Mlch, May 1981

Digital Library

[22]

Rowe, L A and Shoens, K, "Data Abstractmn, Vmws, and Updates m Rlgel," Proc 1979 ACM-SIGMOD Conference on Management of Data, Boston, MA, May 1979

Digital Library

[23]

Rowe, LA and Shoens, K "FADS- A Forms Apphcatmn Development System," Proc 1982 ACM-SIGMOD Conference on Management of Data, Orlando, FL, June 1982

Digital Library

[24]

Rowe, L, "Fill-m-the-Form Programmmg," Proc 1985 Very Large Data Base Conference, Stockholm, Sweden, August 1985

[25]

Sehnger, P et al, "Access Path Selectmn m a Relatmnal Data Base System," Proc 1979 ACM-SIGMOD Conference on Management of Data, Boston, Mass, June 1979

[26]

Severence, D, and Lohman, G, "Differential Files Their Apphcat#on to the Maintenance of large Databases," ACM-TODS, June 1976

Digital Library

[27]

Stonebraker, M, "Implementatmn of Integrity Constraints and Vmws by Query Modfficatlon," Proc 1975 ACM-SIGMOD Conference, San Jose, Ca, May 1975

Digital Library

[28]

Stonebraker, M, et al "The Design and Implementation of INGRES," ACM-TODS, September 1976

Digital Library

[29]

Stonebraker, M, "Operating System Support for Database Management," CACM, July 1981

Digital Library

[30]

Stonebraker, M, et al, "Performance Analysis of a Dlstmbuted Data Base System," Proc 3th Symposium on Rehabllity in Distributed Software and Data Base Systems, Clearwater, Fla, Oct 1983

[31]

Stonebraker, M, "Document Processmg m a Relatmnal Database System," ACM TOOIS, April 1983

Digital Library

[32]

Stonebraker, M, et al, "Apphcatlon of Abstract Data Types and Abstract Indexes to CAD Data," Proc Engineering Apphcatlons Stream of 1983 Data Base Week, San Jose, Ca, May 1983

[33]

Stonebraker, M et al, "QUEL as a Data Type," Proc 1984 ACM- SIGMOD Conference on Management of Data, Boston, Mass, June 1984

Digital Library

[34]

Stonebraker, M and Rowe, L A, "PORTALS A New Application Program Interface," Proc 1984 VLDB Conference, Singapore, Sept 1984

Digital Library

[35]

Stonebraker, M, "Extending a Data Base System wlth Procedures," (subnutted for pubhcatlon)

[36]

Stonebraker, M, "Triggers and inference in Data Base Systems," Proc Islamoora Conference on Expert Data Bases, Islamoora, Fla, Feb 1985, to appear as a Sprmger- Verlag book

[37]

Stonebraker, M et al, "An Analysls of Rule Indexing Implementatmns m Data Base Systems," (submitted for publmatmn)

[38]

Stonebraker, M, "Inclusion of New Types m Relational Data Base Systems," Proc Second International Conference on Data Base Engineerrag, Los Angeles, Ca, Feb 1986

Digital Library

[39]

T1chy, WF, "Design, Implementatmn, and Evaluation of a Revlslon Control System, Proc 6th Int Conf on Soft Eng, Sept 1982

Digital Library

[40]

Tslchmtms, D C "Form Management," CACM 25, July 1982

Digital Library

[41]

Ullman, J, "Implementatmn of Logical Query Languages for Data Bases," Proceedings of the 1985 ACM-SIGMOD Internatmnal Conference on Management of Data, Austin, TX, May 1985

[42]

Wong, E, et al, "Enhanclng INGRES wlth Deductive Power," Proceedings of the Ist Internatmnal Workshop on Expert Data Base Systems, Kmwah SC, October 1984

[43]

Woodfill, J and Stonebraker, M, "An Implementation of Hypothetlcal Relatlons," Proc 9th VLDB Confernece, Florence, Italy, Dec 1983

Digital Library

[44]

Zamolo, C, "The Database Language GEM," Proc 1983 ACM- SIGMOD Conference on Management of Data, San Jose, Ca, May 1983

Digital Library

Cited By

OZDEMIR MHANBAY D(2024)Real-Time Scalable System For Face Tracking In Multi-CameraÇoklu Kamerada Gerçek Zamanlı Ölçeklenebilir Yüz Takibi SistemiJournal of Polytechnic10.2339/politeknik.1332952Online publication date: 1-Mar-2024
https://doi.org/10.2339/politeknik.1332952
Zirak FChoudhury FBorovica-Gajic R(2024)SeLeP: Learning Based Semantic Prefetching for Exploratory Database WorkloadsProceedings of the VLDB Endowment10.14778/3659437.365945817:8(2064-2076)Online publication date: 1-Apr-2024
https://dl.acm.org/doi/10.14778/3659437.3659458
Feng YRahman SFeng AChen VKandogan E(2024)CMDBench: A Benchmark for Coarse-to-fine Multimodal Data Discovery in Compound AI SystemsProceedings of the Conference on Governance, Understanding and Integration of Data for Effective and Responsible AI10.1145/3665601.3669846(16-25)Online publication date: 9-Jun-2024
https://dl.acm.org/doi/10.1145/3665601.3669846
Show More Cited By

Index Terms

The design of POSTGRES

Recommendations

The design of POSTGRES
SIGMOD '86: Proceedings of the 1986 ACM SIGMOD international conference on Management of data
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,
- ...
The Implementation of POSTGRES

The design and implementation decisions made for the three-dimensional data manager POSTGRES are discussed. Attention is restricted to the DBMS backend functions. The POSTGRES data model and query language, the rules system, the storage system, the ...
Postgres: For Starters

Comments

Information & Contributors

Information

Published In

cover image ACM SIGMOD Record

ACM SIGMOD Record Volume 15, Issue 2

June 1986

407 pages

ISSN:0163-5808

DOI:10.1145/16856

Editor:
Carlo Zaniolo

Issue’s Table of Contents

SIGMOD '86: Proceedings of the 1986 ACM SIGMOD international conference on Management of data
June 1986
407 pages
ISBN:0897911911
DOI:10.1145/16894
Editor:
Carlo Zaniolo

Copyright © 1986 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 15 June 1986

Published in SIGMOD Volume 15, Issue 2

Check for updates

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

543
Total Citations
View Citations
4,541
Total Downloads

Downloads (Last 12 months)1,472
Downloads (Last 6 weeks)161

Reflects downloads up to 30 Aug 2024

Other Metrics

View Author Metrics

Citations

Cited By

OZDEMIR MHANBAY D(2024)Real-Time Scalable System For Face Tracking In Multi-CameraÇoklu Kamerada Gerçek Zamanlı Ölçeklenebilir Yüz Takibi SistemiJournal of Polytechnic10.2339/politeknik.1332952Online publication date: 1-Mar-2024
https://doi.org/10.2339/politeknik.1332952
Zirak FChoudhury FBorovica-Gajic R(2024)SeLeP: Learning Based Semantic Prefetching for Exploratory Database WorkloadsProceedings of the VLDB Endowment10.14778/3659437.365945817:8(2064-2076)Online publication date: 1-Apr-2024
https://dl.acm.org/doi/10.14778/3659437.3659458
Feng YRahman SFeng AChen VKandogan E(2024)CMDBench: A Benchmark for Coarse-to-fine Multimodal Data Discovery in Compound AI SystemsProceedings of the Conference on Governance, Understanding and Integration of Data for Effective and Responsible AI10.1145/3665601.3669846(16-25)Online publication date: 9-Jun-2024
https://dl.acm.org/doi/10.1145/3665601.3669846
Gong YGalhotra SCastro Fernandez R(2024)Nexus: Correlation Discovery over Collections of Spatio-Temporal Tabular DataProceedings of the ACM on Management of Data10.1145/36549572:3(1-28)Online publication date: 30-May-2024
https://dl.acm.org/doi/10.1145/3654957
Chalvantzis NVontzalidis AKassela ESpyrou ANikitas NProvatas NKonstantinou IKoziris N(2024)IW-NET BDA: A Big Data Infrastructure for Predictive and Geotemporal Analytics of Inland WaterwaysIEEE Access10.1109/ACCESS.2024.338731512(52503-52523)Online publication date: 2024
https://doi.org/10.1109/ACCESS.2024.3387315
Wang ZCui JGao XLi HPeng YLiu ZZhang HZhao K(2024)QuartetExpert Systems with Applications: An International Journal10.1016/j.eswa.2023.122841244:COnline publication date: 15-Jun-2024
https://dl.acm.org/doi/10.1016/j.eswa.2023.122841
Gasser RArnold RFaber FSchuldt HWaltenspül RRossetto L(2024)A New Retrieval Engine for VitrivrMultiMedia Modeling10.1007/978-3-031-53302-0_28(324-331)Online publication date: 29-Jan-2024
https://doi.org/10.1007/978-3-031-53302-0_28
Wang JGray MTrummer IKara AOlteanu D(2023)Demonstrating ADOPT: Adaptively Optimizing Attribute Orders for Worst-Case Optimal Joins via Reinforcement LearningProceedings of the VLDB Endowment10.14778/3611540.361162916:12(4094-4097)Online publication date: 1-Aug-2023
https://dl.acm.org/doi/10.14778/3611540.3611629
Škrhák VHoksza D(2023)Framework for Protein Structures Conformation Analysis2023 IEEE International Conference on Bioinformatics and Biomedicine (BIBM)10.1109/BIBM58861.2023.10385905(4942-4944)Online publication date: 5-Dec-2023
https://doi.org/10.1109/BIBM58861.2023.10385905
Rasiya Koya SGiron NRojas MMantilla RHarvey KCeynar DQuintero FKrajewski WRoy T(2023)Applicability of a flood forecasting system for Nebraska watershedsEnvironmental Modelling & Software10.1016/j.envsoft.2023.105693164:COnline publication date: 1-Jun-2023
https://dl.acm.org/doi/10.1016/j.envsoft.2023.105693
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

Media

Figures

Other

Tables

View Issue’s Table of Contents