Bibliography
Selected references and readings forSQL andPostgreSQL. Some white papers and technical reports from the originalPOSTGRES development team are available at the University of California, Berkeley, Computer Science Department web site. Judith Bowman,Sandra Emerson,and Marcy Darnovsky,The PracticalSQL Handbook:Using SQL Variants, Fourth Edition, Addison-Wesley Professional, ISBN 0-201-70309-2, 2001. C. J. Dateand Hugh Darwen,A Guide to theSQL Standard:A user's guide to the standard database languageSQL, Fourth Edition, Addison-Wesley, ISBN 0-201-96426-0, 1997. C. J. Date,An Introduction to Database Systems, Eighth Edition, Addison-Wesley, ISBN 0-321-19784-4, 2003. Ramez Elmasriand Shamkant Navathe,Fundamentals of Database Systems, Fourth Edition, Addison-Wesley, ISBN 0-321-12226-7, 2003. Jim Meltonand Alan R. Simon,Understanding the NewSQL:A complete guide, Morgan Kaufmann, ISBN 1-55860-245-3, 1993. Jeffrey D. Ullman,Principles of Database and Knowledge:Base Systems, Volume 1, Computer Science Press, 1988. Stefan Simkovics,Enhancement of the ANSI SQL Implementation of PostgreSQL, Department of Information Systems, Vienna University of Technology, November 29, 1998. Discusses SQL history and syntax, and describes the addition ofINTERSECT andEXCEPT constructs intoPostgreSQL. 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. A. Yuand J. Chen, The POSTGRES Group,ThePostgres95 User Manual, University of California, Sept. 5, 1995. Zelaine Fong, The design and implementation of thePOSTGRES query optimizer, University of California, Berkeley, Computer Science Department. Nels Olson,Partial indexing in POSTGRES: research project, University of California, UCB Engin T7.49.1993 O676, 1993. L. Ongand J. Goh, "A Unified Framework for Version Modeling Using Production Rules in a Database System",ERL Technical Memorandum M90/33, University of California, April, 1990. L. Roweand M. Stonebraker, " ThePOSTGRES data model", Proc.VLDB Conference,Sept. 1987. P. Seshadriand A. Swami, "Generalized Partial Indexes(cached version) ", Proc.Eleventh International Conference on Data Engineering,6-10 March 1995, IEEE Computer Society Press, Cat. No.95CH35724, 1995, 420-7. M. Stonebrakerand L. Rowe, " The design ofPOSTGRES", Proc.ACM-SIGMOD Conference on Management of Data,May 1986. M. Stonebraker,E. Hanson,and C. H. Hong, "The design of thePOSTGRES rules system", Proc.IEEE Conference on Data Engineering,Feb. 1987. M. Stonebraker, " The design of thePOSTGRES storage system", Proc.VLDB Conference,Sept. 1987. M. Stonebraker,M. Hearst,and S. Potamianos, " A commentary on thePOSTGRES rules system",SIGMOD Record 18(3), Sept. 1989. M. Stonebraker, " The case for partial indexes",SIGMOD Record 18(4), Dec. 1989, 4-11. M. Stonebraker,L. A. Rowe,and M. Hirohama, " The implementation ofPOSTGRES",Transactions on Knowledge and Data Engineering 2(1), IEEE, March 1990. M. Stonebraker,A. Jhingran,J. Goh,and S. Potamianos, " On Rules, Procedures, Caching and Views in Database Systems", Proc.ACM-SIGMOD Conference on Management of Data,June 1990.SQL Reference Books
PostgreSQL-specific Documentation
Proceedings and Articles