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.
SQL Reference Books
The Practical SQL Handbook
Using SQL Variants
Fourth Edition
Judith >Bowman
Sandra >Emerson
Marcy >Darnovsky
0-201-70309-2
Addison-Wesley Professional
2001
A Guide to the SQL 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 SQL
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
SQL Technical Report
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 Postgres95 User Manual
A. >Yu
J. >Chen
University of California Berkeley, California
Sept. 5, 1995
The design and implementation of the **POSTGRES** query optimizer
Zelaine >Fong
University of California, Berkeley, Computer Science Department
Proceedings and Articles
Serializable Snapshot Isolation in PostgreSQL
D. >Ports
K. >Grittner
VLDB Conference >August 2012 Istanbul, Turkey
A Critique of ANSI SQL Isolation Levels
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
L. >Rowe
M. >Stonebraker
VLDB Conference >Sept. 1987 Brighton, England
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
M. >Stonebraker
L. >Rowe
ACM-SIGMOD Conference on Management of Data >May 1986 Washington, DC
The design of the POSTGRES rules system
M. >Stonebraker
E. >Hanson
C. H. >Hong
IEEE Conference on Data Engineering >Feb. 1987 Los Angeles, California
The design of the **POSTGRES** storage system
M. >Stonebraker
VLDB Conference >Sept. 1987 Brighton, England
A commentary on the **POSTGRES** rules system
M. >Stonebraker
M. >Hearst
S. >Potamianos
SIGMOD Record 18(3)
M. >Stonebraker
SIGMOD Record 18(4)
4–11
The implementation of **POSTGRES**
M. >Stonebraker
L. A. >Rowe
M. >Hirohama
Transactions on Knowledge and Data Engineering 2(1)
IEEE
On Rules, Procedures, Caching and Views in Database Systems
M. >Stonebraker
A. >Jhingran
J. >Goh
S. >Potamianos
ACM-SIGMOD Conference on Management of Data >June 1990