---
title: "Bibliography"
id: biblio
pg_version: "20devel"
---

<a id="biblio"></a>

# Bibliography

Selected references and readings for SQL and PostgreSQL. 

Some white papers and technical reports from the original POSTGRES development team are available at the University of California, Berkeley, Computer Science Department [web site](https://dsf.berkeley.edu/papers/). 

SQL Reference Books<a id="bowman01"></a>

**[bowman01]** The Practical SQL Handbook

<a id="date97"></a>

**[date97]** A Guide to the SQL Standard

<a id="date04"></a>

**[date04]** An Introduction to Database Systems

<a id="elma04"></a>

**[elma04]** Fundamentals of Database Systems

<a id="melt93"></a>

**[melt93]** Understanding the New SQL

<a id="ull88"></a>

**[ull88]** Principles of Database and Knowledge-Base Systems

<a id="sqltr-19075-6"></a>

**[sqltr-19075-6]** SQL Technical Report

PostgreSQL-specific Documentation<a id="sim98"></a>

**[sim98]** Enhancement of the ANSI SQL Implementation of PostgreSQL

<a id="yu95"></a>

**[yu95]** The Postgres95 User Manual

<a id="fong"></a>

**[fong]** [The design and implementation of the POSTGRES query optimizer](https://dsf.berkeley.edu/papers/UCB-MS-zfong.pdf)

Proceedings and Articles<a id="berenson95"></a>

**[berenson95]** [A Critique of ANSI SQL Isolation Levels](https://www.microsoft.com/en-us/research/wp-content/uploads/2016/02/tr-95-51.pdf)

<a id="hell18"></a>

**[hell18]** [Looking Back at Postgres](https://arxiv.org/pdf/1901.01973)

<a id="olson93"></a>

**[olson93]** [Partial indexing in POSTGRES: research project](https://search.library.berkeley.edu/permalink/01UCS_BER/iqob43/alma991082339239706532)

<a id="ong90"></a>

**[ong90]** [A Unified Framework for Version Modeling Using Production Rules in a Database System](https://www2.eecs.berkeley.edu/Pubs/TechRpts/1990/1466.html)

<a id="ports12"></a>

**[ports12]** [Serializable Snapshot Isolation in PostgreSQL](https://arxiv.org/pdf/1208.4179)

<a id="rowe87"></a>

**[rowe87]** [The POSTGRES data model](https://dsf.berkeley.edu/papers/ERL-M87-13.pdf)

<a id="seshadri95"></a>

**[seshadri95]** [Generalized Partial Indexes](https://citeseer.ist.psu.edu/viewdoc/summary?doi=10.1.1.40.5740)

<a id="ston86"></a>

**[ston86]** [The design of POSTGRES](https://dsf.berkeley.edu/papers/ERL-M85-95.pdf)

<a id="ston87a"></a>

**[ston87a]** The design of the POSTGRES rules system

<a id="ston87b"></a>

**[ston87b]** [The design of the POSTGRES storage system](https://dsf.berkeley.edu/papers/ERL-M87-06.pdf)

<a id="ston89"></a>

**[ston89]** [A commentary on the POSTGRES rules system](https://dsf.berkeley.edu/papers/ERL-M89-82.pdf)

<a id="ston89b"></a>

**[ston89b]** [The case for partial indexes](https://dsf.berkeley.edu/papers/ERL-M89-17.pdf)

<a id="ston90a"></a>

**[ston90a]** [The implementation of POSTGRES](https://dsf.berkeley.edu/papers/ERL-M90-34.pdf)

<a id="ston90b"></a>

**[ston90b]** [On Rules, Procedures, Caching and Views in Database Systems](https://dsf.berkeley.edu/papers/ERL-M90-36.pdf)

<a id="ston92"></a>

**[ston92]** [An overview of the Sequoia 2000 project](https://dsf.berkeley.edu/papers/S2K-91-05.pdf)