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