
Development Versions: [devel](https://www.postgresql.org/docs/devel/biblio.html "PostgreSQL devel - 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

\[bowman01\] _The Practical SQL Handbook_. Using SQL Variants. Fourth Edition. ISBN 0-201-70309-2. Addison-Wesley Professional. 2001.

\[date97\] _A Guide to the SQL Standard_. A user's guide to the standard database language SQL. Fourth Edition. C. J. Date and Hugh Darwen. ISBN 0-201-96426-0. Addison-Wesley. 1997.

\[date04\] _An Introduction to Database Systems_. Eighth Edition. C. J. Date. ISBN 0-321-19784-4. Addison-Wesley. 2003.

\[elma04\] _Fundamentals of Database Systems_. Fourth Edition. Ramez Elmasri and Shamkant Navathe. ISBN 0-321-12226-7. Addison-Wesley. 2003.

\[melt93\] _Understanding the New SQL_. A complete guide. Jim Melton and Alan R. Simon. ISBN 1-55860-245-3. Morgan Kaufmann. 1993.

\[ull88\] _Principles of Database and Knowledge-Base Systems_. Classical Database Systems. Jeffrey D. Ullman. Computer Science Press. 1988.

\[sqltr-19075-6\] _SQL Technical Report_. Part 6: SQL support for JavaScript Object Notation (JSON). First Edition. 2017.

### PostgreSQL-specific Documentation

\[sim98\] _Enhancement of the ANSI SQL Implementation of PostgreSQL_. Stefan Simkovics. Department of Information Systems, Vienna University of Technology. Vienna, Austria. November 29, 1998.

\[yu95\] _The Postgres95. User Manual_. A. Yu and J. Chen. University of California. Berkeley, California. Sept. 5, 1995.

\[fong\] _[The design and implementation of the POSTGRES query optimizer](https://dsf.berkeley.edu/papers/UCB-MS-zfong.pdf)_. Zelaine Fong. University of California, Berkeley, Computer Science Department.

### Proceedings and Articles

\[berenson95\] “[A Critique of ANSI SQL Isolation Levels](https://www.microsoft.com/en-us/research/wp-content/uploads/2016/02/tr-95-51.pdf)”. H. Berenson, P. Bernstein, J. Gray, J. Melton, E. O'Neil, and P. O'Neil. ACM-SIGMOD Conference on Management of Data, June 1995.

\[hell18\] “[Looking Back at Postgres](https://arxiv.org/pdf/1901.01973)”. J. Hellerstein. _Making Databases Work_. ISBN 978-1-947487-19-2. Association for Computing Machinery and Morgan & Claypool. 2018.

\[olson93\] _[Partial indexing in POSTGRES: research project](https://search.library.berkeley.edu/permalink/01UCS_BER/iqob43/alma991082339239706532)_. Nels Olson. UCB Engin T7.49.1993 O676. University of California. Berkeley, California. 1993.

\[ong90\] “[A Unified Framework for Version Modeling Using Production Rules in a Database System](https://www2.eecs.berkeley.edu/Pubs/TechRpts/1990/1466.html)”. L. Ong and J. Goh. _ERL Technical Memorandum M90/33_. University of California. Berkeley, California. April, 1990.

\[ports12\] “[Serializable Snapshot Isolation in PostgreSQL](https://arxiv.org/pdf/1208.4179)”. D. Ports and K. Grittner. VLDB Conference, August 2012.

\[rowe87\] “[The POSTGRES data model](https://dsf.berkeley.edu/papers/ERL-M87-13.pdf)”. L. Rowe and M. Stonebraker. VLDB Conference, Sept. 1987.

\[seshadri95\] “[Generalized Partial Indexes](https://citeseer.ist.psu.edu/viewdoc/summary?doi=10.1.1.40.5740)”. P. Seshadri and A. Swami. Eleventh International Conference on Data Engineering, 6–10 March 1995. Cat. No.95CH35724. IEEE Computer Society Press. Los Alamitos, California. 1995. 420–7.

\[ston86\] “[The design of POSTGRES](https://dsf.berkeley.edu/papers/ERL-M85-95.pdf)”. M. Stonebraker and L. Rowe. ACM-SIGMOD Conference on Management of Data, May 1986.

\[ston87a\] “The design of the POSTGRES rules system”. M. Stonebraker, E. Hanson, and C. H. Hong. IEEE Conference on Data Engineering, Feb. 1987.

\[ston87b\] “[The design of the POSTGRES storage system](https://dsf.berkeley.edu/papers/ERL-M87-06.pdf)”. M. Stonebraker. VLDB Conference, Sept. 1987.

\[ston89\] “[A commentary on the POSTGRES rules system](https://dsf.berkeley.edu/papers/ERL-M89-82.pdf)”. M. Stonebraker, M. Hearst, and S. Potamianos. _SIGMOD Record 18(3)_. Sept. 1989.

\[ston89b\] “[The case for partial indexes](https://dsf.berkeley.edu/papers/ERL-M89-17.pdf)”. M. Stonebraker. _SIGMOD Record 18(4)_. Dec. 1989. 4–11.

\[ston90a\] “[The implementation of POSTGRES](https://dsf.berkeley.edu/papers/ERL-M90-34.pdf)”. M. Stonebraker, L. A. Rowe, and M. Hirohama. _Transactions on Knowledge and Data Engineering 2(1)_. IEEE. March 1990.

\[ston90b\] “[On Rules, Procedures, Caching and Views in Database Systems](https://dsf.berkeley.edu/papers/ERL-M90-36.pdf)”. M. Stonebraker, A. Jhingran, J. Goh, and S. Potamianos. ACM-SIGMOD Conference on Management of Data, June 1990.

\[ston92\] “ [An overview of the Sequoia 2000 project](https://dsf.berkeley.edu/papers/S2K-91-05.pdf) ”. M. Stonebraker. _Digest of Papers COMPCON Spring 1992_. 1992. 383–388.
