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.
Reference texts for SQL features.
[bowman01] The Practical SQL Handbook. Bowman et al, 2001. Using SQL Variants. Fourth Edition. 0-201-70309-2. 2001. Addison-Wesley Professional. Copyright © 2001.
[date97] A Guide to the SQL Standard. Date and Darwen, 1997. A user's guide to the standard database language SQL. Fourth Edition. 0-201-96426-0. 1997. Addison-Wesley. Copyright © 1997 Addison-Wesley Longman, Inc..
[date04] An Introduction to Database Systems. Date, 2004. Eighth Edition. 0-321-19784-4. 2003. Addison-Wesley. Copyright © 2004 Pearson Education, Inc..
[elma04] Fundamentals of Database Systems. Fourth Edition. 0-321-12226-7. 2003. Addison-Wesley. Copyright © 2004.
This section is for related documentation.
[sim98] Enhancement of the ANSI SQL Implementation of PostgreSQL. Simkovics, 1998. November 29, 1998. Department of Information Systems, Vienna University of Technology. Vienna, Austria.
[yu95] The Postgres95. User Manual. Yu and Chen, 1995. Sept. 5, 1995. University of California. Berkeley, California.
[fong] The design and implementation of the POSTGRES™ query optimizer . University of California, Berkeley, Computer Science Department.
This section is for articles and newsletters.
[olson93] Partial indexing in POSTGRES: research project. Olson, 1993. 1993. UCB Engin T7.49.1993 O676. University of California. Berkeley, California.
[ong90] “A Unified Framework for Version Modeling Using Production Rules in a Database System”. Ong and Goh, 1990. ERL Technical Memorandum M90/33. April, 1990. University of California. Berkely, California.
[rowe87] “ The POSTGRES™ data model ”. Rowe and Stonebraker, 1987. VLDB Conference. Sept. 1987. Brighton, England. .
[seshadri95] “Generalized Partial Indexes (cached version) ”. Seshardri, 1995. Eleventh International Conference on Data Engineering. 6-10 March 1995. Taipeh, Taiwan. . 1995. Cat. No.95CH35724. IEEE Computer Society Press. Los Alamitos, California. 420-7.
[ston86] “ The design of POSTGRES™ ”. Stonebraker and Rowe, 1986. ACM-SIGMOD Conference on Management of Data. May 1986. Washington, DC. .
[ston87a] “The design of the POSTGRES™ rules system”. Stonebraker, Hanson, Hong, 1987. IEEE Conference on Data Engineering. Feb. 1987. Los Angeles, California. .
[ston87b] “ The design of the POSTGRES™ storage system ”. Stonebraker, 1987. VLDB Conference. Sept. 1987. Brighton, England. .
[ston89] “ A commentary on the POSTGRES™ rules system ”. Stonebraker et al, 1989. SIGMOD Record 18(3). Sept. 1989.
[ston89b] “ The case for partial indexes ”. Stonebraker, M, 1989b. SIGMOD Record 18(4). 4-11. Dec. 1989.
[ston90a] “ The implementation of POSTGRES™ ”. Stonebraker, Rowe, Hirohama, 1990. Transactions on Knowledge and Data Engineering 2(1). IEEE. March 1990.
[ston90b] “ On Rules, Procedures, Caching and Views in Database Systems ”. Stonebraker et al, ACM, 1990. ACM-SIGMOD Conference on Management of Data. June 1990. .