The Design Of Postgres

Summary: Presents POSTGRES, a successor to INGRES, with object support and user extensibility for data types, operators, and access methods. Adds alerters/triggers, forward/backward inference, and simplified crash recovery; hardware-aware design for optical disks, multi-processor workstations, and VLSI, with minimal changes to the relational model. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 2320
Venue: SIGMOD
Year: 1986
Pagerank: 0.00071838587
Overall Rank: 44 | 99.70%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Michael Stonebraker
2. Lawrence A. Rowe

Incoming Citations (Sorted by Pagerank)

Showing 50 of 100 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
5,303	The Partial Normalized Storage Model of Nested Relations	1988	VLDB	5.5779667e-05
5,528	Tapes Hold Data, Too: Challenges of Tuples on Tertiary Store	1993	SIGMOD	5.4570591e-05
5,602	An Object-Oriented Database System for Engineering Applications	1987	SIGMOD	5.414943e-05
5,612	Object-Oriented Database Support for Software Environments	1987	SIGMOD	5.4106199e-05
6,021	Securing history: Privacy and accountability in database systems	2007	CIDR	5.2415551e-05
6,098	Blockchains vs. Distributed Databases: Dichotomy and Fusion	2021	SIGMOD	5.2112094e-05
6,258	A Temporal Knowledge Representation Model OSAM*/T and Its Query Language OQL/T	1991	VLDB	5.1357897e-05
6,302	Diva: Making MVCC Systems HTAP-Friendly	2022	SIGMOD	5.1215989e-05
6,332	Long-lived Transactions Made Less Harmful	2020	SIGMOD	5.1070098e-05
6,363	Conflict Resolution Of Rules Assigning Values To Virtual Attributes	1989	SIGMOD	5.095005e-05
6,473	Research Directions in Object-Oriented Database Systems	1990	PODS	5.0509826e-05
6,501	How Good is My HTAP System?	2022	SIGMOD	5.0374293e-05
6,803	Proteus: Autonomous Adaptive Storage for Mixed Workloads	2022	SIGMOD	4.9224958e-05
6,833	Keep CALM and CRDT On	2023	VLDB	4.9125021e-05
6,898	Disclosure-Compliant Query Answering	2024	SIGMOD	4.8925595e-05
7,232	Anarchy in the Database: A Survey and Evaluation of Database Management System Extensibility	2025	VLDB	4.7942933e-05
7,250	A Scalable and Generic Approach to Range Joins	2022	VLDB	4.78908e-05
7,820	Subjective Databases	2019	VLDB	4.6431208e-05
8,026	ADOPT: Adaptively Optimizing Attribute Orders for Worst-Case Optimal Join Algorithms via Reinforcement Learning	2023	VLDB	4.6030518e-05
8,192	Scalable and Robust Snapshot Isolation for High-Performance Storage Engines	2023	VLDB	4.562388e-05
8,198	Elimination of Views and Redundant Variables in an SQL-like Database Language for Extended NF^2 Structures	1990	VLDB	4.5605849e-05
8,334	Freeform: A User-Adaptable Form Management System	1987	VLDB	4.5435639e-05
8,415	Pruning in Snowflake: Working Smarter, Not Harder	2025	SIGMOD	4.5197687e-05
8,618	Nexus: Correlation Discovery over Collections of Spatio-Temporal Tabular Data	2024	SIGMOD	4.4838259e-05
8,680	A Practical Approach to Groupjoin and Nested Aggregates	2021	VLDB	4.4694927e-05
8,881	Second-Order Signature: A Tool for Specifying Data Models, Query Processing, and Optimization	1993	SIGMOD	4.4294996e-05
9,103	AlayaDB: The Data Foundation for Efficient and Effective Long-context LLM Inference	2025	SIGMOD	4.3958197e-05
9,187	POLAR: Adaptive and Non-invasive Join Order Selection via Plans of Least Resistance	2024	VLDB	4.3780059e-05
9,231	Modyn: Data-Centric Machine Learning Pipeline Orchestration	2025	SIGMOD	4.3690661e-05
9,238	Optimizing Disjunctive Queries with Tagged Execution	2024	SIGMOD	4.3690661e-05
9,476	Adda: Towards Efficient in-Database Feature Generation via LLM-based Agents	2025	SIGMOD	4.3341665e-05
9,689	LST-Bench: Benchmarking Log-Structured Tables in the Cloud	2024	SIGMOD	4.3043822e-05
9,702	Evaluating Query Languages and Systems for High-Energy Physics Data	2022	VLDB	4.3008468e-05
9,825	Athena: An Effective Learning-based Framework for Query Optimizer Performance Improvement	2025	SIGMOD	4.2751057e-05
10,635	Saving Private Hash Join	2025	VLDB	4.1945683e-05
10,714	Towards Designing Future-Proof Data Processing Systems	2025	VLDB	4.1945683e-05
11,021	SeLeP: Learning Based Semantic Prefetching for Exploratory Database Workloads	2024	VLDB	4.1945683e-05
11,037	Spectrum: Speedy and Strictly-Deterministic Smart Contract Transactions for Blockchain Ledgers	2024	VLDB	4.1945683e-05
11,053	Efficient Enumeration of Recursive Plans in Transformation-based Query Optimizers	2024	VLDB	4.1945683e-05
11,069	Hardware-Efficient Data Imputation through DBMS Extensibility	2024	VLDB	4.1945683e-05
11,130	The Vadalog Parallel System: Distributed Reasoning with Datalog+/-	2024	VLDB	4.1945683e-05
11,148	mutable: A Modern DBMS for Research and Fast Prototyping	2023	CIDR	4.1945683e-05
11,298	Demonstrating ADOPT: Adaptively Optimizing Attribute Orders for Worst-Case Optimal Joins via Reinforcement Learning	2023	VLDB	4.1945683e-05
12,460	Inverse Functions in the AquaLogic Data Services Platform	2007	VLDB	4.1945683e-05
12,816	Processing Object-Oriented Queries with Invertible Late Bound Functions	1995	VLDB	4.1945683e-05
12,902	Experiences With an Object Manager for a Process-Centered Environment	1992	VLDB	4.1945683e-05
12,912	Trait: An Attribute Management System for VLSI Design Objects	1991	SIGMOD	4.1945683e-05
12,943	Extending a Relational Database with Deferred Referential Integrity Checking and Intelligent Joins	1989	SIGMOD	4.1945683e-05
12,968	Rapid Application Prototyping: The PROQUEL Language	1988	VLDB	4.1945683e-05
12,999	Panel on Extensible Database Systems	1986	SIGMOD	4.1945683e-05

Outgoing Citations (Sorted by Pagerank)

Showing 13 of 13 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
2	R-Trees: A Dynamic Index Structure For Spatial Searching	1984	SIGMOD	0.0032169493
5	The K-D-B-Tree: A Search Structure for Large Multidimensional Dynamic Indexes	1981	SIGMOD	0.0018397217
32	Differential Files: Their Application To The Maintenance Of Large Data Bases	1976	SIGMOD	0.00077486306
68	The Database Language GEM	1983	SIGMOD	0.00060795269
69	Implementation of Integrity Constraints and Views by Query Modification	1975	SIGMOD	0.00060379399
85	Making Smalltalk a Database System	1984	SIGMOD	0.00053428612
448	Data Abstraction, Views And Updates In Rigel	1979	SIGMOD	0.00022870667
579	Quel As A Data Type	1984	SIGMOD	0.00019808249
1,360	Data Constructors: On the Integration of Rules and Relations	1985	VLDB	0.00012385136
1,447	An Extensible Object-Oriented Approach to Databases for VLSI/CAD	1985	VLDB	0.00011939785
1,656	Database Portals: A New Application Program Interface	1984	VLDB	0.00010994744
2,155	An Implementation of Hypothetical Relations	1983	VLDB	9.4197523e-05
2,668	"Fill-in-the-Form" Programming	1985	VLDB	8.3400653e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
1,428	Don't be lazy, be consistent: Postgres-R, A new way to implement Database Replication	2000	VLDB	0.00012040675
1,416	A Performance Study of Query Optimization Algorithms on a Database System Supporting Procedures	1988	VLDB	0.00012105525
10	Benchmarking Database Systems: A Systematic Approach	1983	VLDB	0.0012103754
7,445	An Automated, Yet Interactive and Portable DB Designer	2010	SIGMOD	4.7278675e-05
317	Distributed Query Processing In A Relational Data Base System	1978	SIGMOD	0.00027980992
463	The Design Of Xprs	1988	VLDB	0.00022464669
3,346	Efficiently Supporting Procedures In Relational Database Systems	1987	SIGMOD	7.1924206e-05
3,740	Query Processing in Tertiary Memory Databases	1995	VLDB	6.8015038e-05
974	The POSTGRES Data Model	1987	VLDB	0.00014896625
26	The Design Of The Postgres Storage System	1987	VLDB	0.00082378685