4 Selected references and readings for SQL and PostgreSQL.
6 Some white papers and technical reports from the original POSTGRES
7 development team are available at the University of California,
8 Berkeley, Computer Science Department web site.
12 [bowman01] The Practical SQL Handbook. Using SQL Variants. Fourth
13 Edition. Judith Bowman, Sandra Emerson, and Marcy Darnovsky. ISBN
14 0-201-70309-2. Addison-Wesley Professional. 2001.
16 [date97] A Guide to the SQL Standard. A user's guide to the standard
17 database language SQL. Fourth Edition. C. J. Date and Hugh Darwen. ISBN
18 0-201-96426-0. Addison-Wesley. 1997.
20 [date04] An Introduction to Database Systems. Eighth Edition. C. J.
21 Date. ISBN 0-321-19784-4. Addison-Wesley. 2003.
23 [elma04] Fundamentals of Database Systems. Fourth Edition. Ramez
24 Elmasri and Shamkant Navathe. ISBN 0-321-12226-7. Addison-Wesley. 2003.
26 [melt93] Understanding the New SQL. A complete guide. Jim Melton and
27 Alan R. Simon. ISBN 1-55860-245-3. Morgan Kaufmann. 1993.
29 [ull88] Principles of Database and Knowledge-Base Systems. Classical
30 Database Systems. Jeffrey D. Ullman. Volume 1. Computer Science Press.
33 [sqltr-19075-6] SQL Technical Report. Part 6: SQL support for
34 JavaScript Object Notation (JSON). First Edition. 2017.
36 PostgreSQL-specific Documentation
38 [sim98] Enhancement of the ANSI SQL Implementation of PostgreSQL.
39 Stefan Simkovics. Department of Information Systems, Vienna University
40 of Technology. Vienna, Austria. November 29, 1998.
42 [yu95] The Postgres95. User Manual. A. Yu and J. Chen. University of
43 California. Berkeley, California. Sept. 5, 1995.
45 [fong] The design and implementation of the POSTGRES query optimizer.
46 Zelaine Fong. University of California, Berkeley, Computer Science
49 Proceedings and Articles
51 [berenson95] “A Critique of ANSI SQL Isolation Levels”. H. Berenson, P.
52 Bernstein, J. Gray, J. Melton, E. O'Neil, and P. O'Neil. ACM-SIGMOD
53 Conference on Management of Data, June 1995.
55 [hell18] “Looking Back at Postgres”. J. Hellerstein. Making Databases
56 Work. ISBN 978-1-947487-19-2. Association for Computing Machinery and
57 Morgan & Claypool. 2018.
59 [olson93] Partial indexing in POSTGRES: research project. Nels Olson.
60 UCB Engin T7.49.1993 O676. University of California. Berkeley,
63 [ong90] “A Unified Framework for Version Modeling Using Production
64 Rules in a Database System”. L. Ong and J. Goh. ERL Technical
65 Memorandum M90/33. University of California. Berkeley, California.
68 [ports12] “Serializable Snapshot Isolation in PostgreSQL”. D. Ports and
69 K. Grittner. VLDB Conference, August 2012.
71 [rowe87] “The POSTGRES data model”. L. Rowe and M. Stonebraker. VLDB
72 Conference, Sept. 1987.
74 [seshadri95] “Generalized Partial Indexes”. P. Seshadri and A. Swami.
75 Eleventh International Conference on Data Engineering, 6–10 March 1995.
76 Cat. No.95CH35724. IEEE Computer Society Press. Los Alamitos,
77 California. 1995. 420–7.
79 [ston86] “The design of POSTGRES”. M. Stonebraker and L. Rowe.
80 ACM-SIGMOD Conference on Management of Data, May 1986.
82 [ston87a] “The design of the POSTGRES rules system”. M. Stonebraker, E.
83 Hanson, and C. H. Hong. IEEE Conference on Data Engineering, Feb. 1987.
85 [ston87b] “The design of the POSTGRES storage system”. M. Stonebraker.
86 VLDB Conference, Sept. 1987.
88 [ston89] “A commentary on the POSTGRES rules system”. M. Stonebraker,
89 M. Hearst, and S. Potamianos. SIGMOD Record 18(3). Sept. 1989.
91 [ston89b] “The case for partial indexes”. M. Stonebraker. SIGMOD Record
92 18(4). Dec. 1989. 4–11.
94 [ston90a] “The implementation of POSTGRES”. M. Stonebraker, L. A. Rowe,
95 and M. Hirohama. Transactions on Knowledge and Data Engineering 2(1).
98 [ston90b] “On Rules, Procedures, Caching and Views in Database
99 Systems”. M. Stonebraker, A. Jhingran, J. Goh, and S. Potamianos.
100 ACM-SIGMOD Conference on Management of Data, June 1990.
102 [ston92] “ An overview of the Sequoia 2000 project ”. M. Stonebraker.
103 Digest of Papers COMPCON Spring 1992. 1992. 383–388.