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. <acronym>SQL</acronym> Reference Books The Practical <acronym>SQL</acronym> Handbook Using SQL Variants Fourth Edition Judith Bowman Sandra Emerson Marcy Darnovsky 0-201-70309-2 Addison-Wesley Professional 2001 A Guide to the <acronym>SQL</acronym> Standard A user's guide to the standard database language SQL Fourth Edition C. J. Date Hugh Darwen 0-201-96426-0 Addison-Wesley 1997 An Introduction to Database Systems Eighth Edition C. J. Date 0-321-19784-4 Addison-Wesley 2003 Fundamentals of Database Systems Fourth Edition Ramez Elmasri Shamkant Navathe 0-321-12226-7 Addison-Wesley 2003 Understanding the New <acronym>SQL</acronym> A complete guide Jim Melton Alan R. Simon 1-55860-245-3 Morgan Kaufmann 1993 Principles of Database and Knowledge-Base Systems Classical Database Systems Jeffrey D. Ullman Volume 1 Computer Science Press 1988 <ulink url="https://standards.iso.org/ittf/PubliclyAvailableStandards/c067367_ISO_IEC_TR_19075-6_2017.zip">SQL Technical Report</ulink> Part 6: SQL support for JavaScript Object Notation (JSON) First Edition 2017 PostgreSQL-specific Documentation Enhancement of the ANSI SQL Implementation of PostgreSQL Stefan Simkovics Discusses SQL history and syntax, and describes the addition of INTERSECT and EXCEPT constructs into PostgreSQL. Prepared as a Master's Thesis with the support of O. Univ. Prof. Dr. Georg Gottlob and Univ. Ass. Mag. Katrin Seyr at Vienna University of Technology. Department of Information Systems, Vienna University of Technology
Vienna, Austria
November 29, 1998
The <productname>Postgres95</productname> User Manual A. Yu J. Chen University of California
Berkeley, California
Sept. 5, 1995
<ulink url="https://dsf.berkeley.edu/papers/UCB-MS-zfong.pdf">The design and implementation of the <productname>POSTGRES</productname> query optimizer</ulink> Zelaine Fong University of California, Berkeley, Computer Science Department
Proceedings and Articles <ulink url="https://arxiv.org/pdf/1208.4179">Serializable Snapshot Isolation in PostgreSQL</ulink> D. Ports K. Grittner VLDB Conference August 2012
Istanbul, Turkey
<ulink url="https://www.microsoft.com/en-us/research/wp-content/uploads/2016/02/tr-95-51.pdf">A Critique of ANSI SQL Isolation Levels</ulink> H. Berenson P. Bernstein J. Gray J. Melton E. O'Neil P. O'Neil ACM-SIGMOD Conference on Management of Data June 1995
San Jose, California
Partial indexing in POSTGRES: research project Nels Olson UCB Engin T7.49.1993 O676 University of California
Berkeley, California
1993
A Unified Framework for Version Modeling Using Production Rules in a Database System L. Ong J. Goh ERL Technical Memorandum M90/33 University of California
Berkeley, California
April, 1990
<ulink url="https://dsf.berkeley.edu/papers/ERL-M87-13.pdf">The <productname>POSTGRES</productname> data model</ulink> L. Rowe M. Stonebraker VLDB Conference Sept. 1987
Brighton, England
<ulink url="https://citeseer.ist.psu.edu/viewdoc/summary?doi=10.1.1.40.5740">Generalized Partial Indexes</ulink> P. Seshadri A. Swami Eleventh International Conference on Data Engineering 6–10 March 1995
Taipeh, Taiwan
Cat. No.95CH35724 IEEE Computer Society Press
Los Alamitos, California
1995 420–7
<ulink url="https://dsf.berkeley.edu/papers/ERL-M85-95.pdf">The design of <productname>POSTGRES</productname></ulink> M. Stonebraker L. Rowe ACM-SIGMOD Conference on Management of Data May 1986
Washington, DC
The design of the <productname>POSTGRES</productname> rules system M. Stonebraker E. Hanson C. H. Hong IEEE Conference on Data Engineering Feb. 1987
Los Angeles, California
<ulink url="https://dsf.berkeley.edu/papers/ERL-M87-06.pdf">The design of the <productname>POSTGRES</productname> storage system</ulink> M. Stonebraker VLDB Conference Sept. 1987
Brighton, England
<ulink url="https://dsf.berkeley.edu/papers/ERL-M89-82.pdf">A commentary on the <productname>POSTGRES</productname> rules system</ulink> M. Stonebraker M. Hearst S. Potamianos SIGMOD Record 18(3) Sept. 1989 <ulink url="https://dsf.berkeley.edu/papers/ERL-M89-17.pdf">The case for partial indexes</ulink> M. Stonebraker SIGMOD Record 18(4) Dec. 1989 4–11 <ulink url="https://dsf.berkeley.edu/papers/ERL-M90-34.pdf">The implementation of <productname>POSTGRES</productname></ulink> M. Stonebraker L. A. Rowe M. Hirohama Transactions on Knowledge and Data Engineering 2(1) IEEE March 1990 <ulink url="https://dsf.berkeley.edu/papers/ERL-M90-36.pdf">On Rules, Procedures, Caching and Views in Database Systems</ulink> M. Stonebraker A. Jhingran J. Goh S. Potamianos ACM-SIGMOD Conference on Management of Data June 1990