<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML ><HEAD ><TITLE >Bibliography</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK REV="MADE" HREF="mailto:pgsql-docs@postgresql.org"><LINK REL="HOME" TITLE="PostgreSQL 8.0.11 Documentation" HREF="index.html"><LINK REL="PREVIOUS" TITLE="Extensions" HREF="external-extensions.html"><LINK REL="NEXT" TITLE="Index" HREF="bookindex.html"><LINK REL="STYLESHEET" TYPE="text/css" HREF="stylesheet.css"><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"><META NAME="creation" CONTENT="2007-02-02T03:57:22"></HEAD ><BODY CLASS="BIBLIOGRAPHY" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="5" ALIGN="center" VALIGN="bottom" >PostgreSQL 8.0.11 Documentation</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="top" ><A HREF="external-extensions.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="10%" ALIGN="left" VALIGN="top" ><A HREF="appendixes.html" >Fast Backward</A ></TD ><TD WIDTH="60%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="top" ><A HREF="bookindex.html" >Fast Forward</A ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="top" ><A HREF="bookindex.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><A NAME="BIBLIO" ></A ><H1 ><A NAME="BIBLIO" ></A >Bibliography</H1 ><P > Selected references and readings for <ACRONYM CLASS="ACRONYM" >SQL</ACRONYM > and <SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN >. </P ><P > Some white papers and technical reports from the original <SPAN CLASS="PRODUCTNAME" >POSTGRES</SPAN > development team are available at <A HREF="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/" TARGET="_top" > the University of California, Berkeley, Computer Science Department web site</A > </P ><H2 CLASS="BIBLIODIV" ><A NAME="AEN75482" ><ACRONYM CLASS="ACRONYM" >SQL</ACRONYM > Reference Books</A ></H2 ><DIV CLASS="BIBLIOENTRY" ><A NAME="BOWMAN93" ></A ><P ><SPAN CLASS="AUTHOR" >Judith Bowman, </SPAN ><SPAN CLASS="AUTHOR" >Sandra Emerson, </SPAN ><SPAN CLASS="AUTHOR" >and Marcy Darnovsky</SPAN >, <I >The Practical <ACRONYM CLASS="ACRONYM" >SQL</ACRONYM > Handbook</I ><I >: </I ><I >Using Structured Query Language</I >, Third Edition, Addison-Wesley, ISBN 0-201-44787-8, 1996.</P ><DIV CLASS="BIBLIOENTRYBLOCK" STYLE="margin-left: 0.5in" ></DIV ></DIV ><DIV CLASS="BIBLIOENTRY" ><A NAME="DATE97" ></A ><P ><SPAN CLASS="AUTHOR" >C. J. Date </SPAN ><SPAN CLASS="AUTHOR" >and Hugh Darwen</SPAN >, <I >A Guide to the <ACRONYM CLASS="ACRONYM" >SQL</ACRONYM > Standard</I ><I >: </I ><I >A user's guide to the standard database language <ACRONYM CLASS="ACRONYM" >SQL</ACRONYM ></I >, Fourth Edition, Addison-Wesley, ISBN 0-201-96426-0, 1997.</P ><DIV CLASS="BIBLIOENTRYBLOCK" STYLE="margin-left: 0.5in" ></DIV ></DIV ><DIV CLASS="BIBLIOENTRY" ><A NAME="DATE94" ></A ><P ><SPAN CLASS="AUTHOR" >C. J. Date</SPAN >, <I >An Introduction to Database Systems</I >, Volume 1, Sixth Edition, Addison-Wesley, 1994.</P ><DIV CLASS="BIBLIOENTRYBLOCK" STYLE="margin-left: 0.5in" ></DIV ></DIV ><DIV CLASS="BIBLIOENTRY" ><A NAME="ELMA99" ></A ><P ><SPAN CLASS="AUTHOR" >Ramez Elmasri </SPAN ><SPAN CLASS="AUTHOR" >and Shamkant Navathe</SPAN >, <I >Fundamentals of Database Systems</I >, 3rd Edition, Addison-Wesley, ISBN 0-805-31755-4, August 1999.</P ><DIV CLASS="BIBLIOENTRYBLOCK" STYLE="margin-left: 0.5in" ></DIV ></DIV ><DIV CLASS="BIBLIOENTRY" ><A NAME="MELT93" ></A ><P ><SPAN CLASS="AUTHOR" >Jim Melton </SPAN ><SPAN CLASS="AUTHOR" >and Alan R. Simon</SPAN >, <I >Understanding the New <ACRONYM CLASS="ACRONYM" >SQL</ACRONYM ></I ><I >: </I ><I >A complete guide</I >, Morgan Kaufmann, ISBN 1-55860-245-3, 1993.</P ><DIV CLASS="BIBLIOENTRYBLOCK" STYLE="margin-left: 0.5in" ></DIV ></DIV ><DIV CLASS="BIBLIOENTRY" ><A NAME="ULL88" ></A ><P ><SPAN CLASS="AUTHOR" >Jeffrey D. Ullman</SPAN >, <I >Principles of Database and Knowledge</I ><I >: </I ><I >Base Systems</I >, Volume 1, Computer Science Press, 1988.</P ><DIV CLASS="BIBLIOENTRYBLOCK" STYLE="margin-left: 0.5in" ></DIV ></DIV ><H2 CLASS="BIBLIODIV" ><A NAME="AEN75591" >PostgreSQL-Specific Documentation</A ></H2 ><DIV CLASS="BIBLIOENTRY" ><A NAME="SIM98" ></A ><P ><SPAN CLASS="AUTHOR" >Stefan Simkovics</SPAN >, <I >Enhancement of the ANSI SQL Implementation of PostgreSQL</I >, Department of Information Systems, Vienna University of Technology, November 29, 1998.</P ><DIV CLASS="BIBLIOENTRYBLOCK" STYLE="margin-left: 0.5in" ><DIV CLASS="ABSTRACT" ><P > Discusses SQL history and syntax, and describes the addition of <TT CLASS="LITERAL" >INTERSECT</TT > and <TT CLASS="LITERAL" >EXCEPT</TT > constructs into <SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN >. 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. </P ></DIV ></DIV ></DIV ><DIV CLASS="BIBLIOENTRY" ><A NAME="YU95" ></A ><P ><SPAN CLASS="AUTHOR" >A. Yu </SPAN ><SPAN CLASS="AUTHOR" >and J. Chen</SPAN >, The POSTGRES Group, <I >The <SPAN CLASS="PRODUCTNAME" >Postgres95</SPAN > User Manual</I >, University of California, Sept. 5, 1995.</P ><DIV CLASS="BIBLIOENTRYBLOCK" STYLE="margin-left: 0.5in" ></DIV ></DIV ><DIV CLASS="BIBLIOENTRY" ><A NAME="FONG" ></A ><P ><SPAN CLASS="AUTHOR" >Zelaine Fong</SPAN >, <I ><A HREF="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/UCB-MS-zfong.pdf" TARGET="_top" >The design and implementation of the <SPAN CLASS="PRODUCTNAME" >POSTGRES</SPAN > query optimizer</A ></I >, University of California, Berkeley, Computer Science Department.</P ><DIV CLASS="BIBLIOENTRYBLOCK" STYLE="margin-left: 0.5in" ></DIV ></DIV ><H2 CLASS="BIBLIODIV" ><A NAME="AEN75637" >Proceedings and Articles</A ></H2 ><DIV CLASS="BIBLIOENTRY" ><A NAME="OLSON93" ></A ><P ><SPAN CLASS="AUTHOR" >Nels Olson</SPAN >, <I >Partial indexing in POSTGRES: research project</I >, University of California, UCB Engin T7.49.1993 O676, 1993.</P ><DIV CLASS="BIBLIOENTRYBLOCK" STYLE="margin-left: 0.5in" ></DIV ></DIV ><DIV CLASS="BIBLIOENTRY" ><A NAME="ONG90" ></A ><P ><SPAN CLASS="AUTHOR" >L. Ong </SPAN ><SPAN CLASS="AUTHOR" >and J. Goh</SPAN >, "A Unified Framework for Version Modeling Using Production Rules in a Database System", <I >ERL Technical Memorandum M90/33</I >, University of California, April, 1990.</P ><DIV CLASS="BIBLIOENTRYBLOCK" STYLE="margin-left: 0.5in" ></DIV ></DIV ><DIV CLASS="BIBLIOENTRY" ><A NAME="ROWE87" ></A ><P ><SPAN CLASS="AUTHOR" >L. Rowe </SPAN ><SPAN CLASS="AUTHOR" >and M. Stonebraker</SPAN >, "<A HREF="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M87-13.pdf" TARGET="_top" >The <SPAN CLASS="PRODUCTNAME" >POSTGRES</SPAN > data model</A >", Proc. <SPAN CLASS="CONFTITLE" >VLDB Conference</SPAN >, <SPAN CLASS="CONFDATES" >Sept. 1987</SPAN >.</P ><DIV CLASS="BIBLIOENTRYBLOCK" STYLE="margin-left: 0.5in" ></DIV ></DIV ><DIV CLASS="BIBLIOENTRY" ><A NAME="SESHADRI95" ></A ><P ><SPAN CLASS="AUTHOR" >P. Seshadri </SPAN ><SPAN CLASS="AUTHOR" >and A. Swami</SPAN >, "<A HREF="http://simon.cs.cornell.edu/home/praveen/papers/partindex.de95.ps.Z" TARGET="_top" >Generalized Partial Indexes</A > ", Proc. <SPAN CLASS="CONFTITLE" >Eleventh International Conference on Data Engineering</SPAN >, <SPAN CLASS="CONFDATES" >6-10 March 1995</SPAN >, IEEE Computer Society Press, Cat. No.95CH35724, 1995, 420-7.</P ><DIV CLASS="BIBLIOENTRYBLOCK" STYLE="margin-left: 0.5in" ></DIV ></DIV ><DIV CLASS="BIBLIOENTRY" ><A NAME="STON86" ></A ><P ><SPAN CLASS="AUTHOR" >M. Stonebraker </SPAN ><SPAN CLASS="AUTHOR" >and L. Rowe</SPAN >, "<A HREF="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M85-95.pdf" TARGET="_top" >The design of <SPAN CLASS="PRODUCTNAME" >POSTGRES</SPAN ></A >", Proc. <SPAN CLASS="CONFTITLE" >ACM-SIGMOD Conference on Management of Data</SPAN >, <SPAN CLASS="CONFDATES" >May 1986</SPAN >.</P ><DIV CLASS="BIBLIOENTRYBLOCK" STYLE="margin-left: 0.5in" ></DIV ></DIV ><DIV CLASS="BIBLIOENTRY" ><A NAME="STON87A" ></A ><P ><SPAN CLASS="AUTHOR" >M. Stonebraker, </SPAN ><SPAN CLASS="AUTHOR" >E. Hanson, </SPAN ><SPAN CLASS="AUTHOR" >and C. H. Hong</SPAN >, "The design of the <SPAN CLASS="PRODUCTNAME" >POSTGRES</SPAN > rules system", Proc. <SPAN CLASS="CONFTITLE" >IEEE Conference on Data Engineering</SPAN >, <SPAN CLASS="CONFDATES" >Feb. 1987</SPAN >.</P ><DIV CLASS="BIBLIOENTRYBLOCK" STYLE="margin-left: 0.5in" ></DIV ></DIV ><DIV CLASS="BIBLIOENTRY" ><A NAME="STON87B" ></A ><P ><SPAN CLASS="AUTHOR" >M. Stonebraker</SPAN >, "<A HREF="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M87-06.pdf" TARGET="_top" >The design of the <SPAN CLASS="PRODUCTNAME" >POSTGRES</SPAN > storage system</A >", Proc. <SPAN CLASS="CONFTITLE" >VLDB Conference</SPAN >, <SPAN CLASS="CONFDATES" >Sept. 1987</SPAN >.</P ><DIV CLASS="BIBLIOENTRYBLOCK" STYLE="margin-left: 0.5in" ></DIV ></DIV ><DIV CLASS="BIBLIOENTRY" ><A NAME="STON89" ></A ><P ><SPAN CLASS="AUTHOR" >M. Stonebraker, </SPAN ><SPAN CLASS="AUTHOR" >M. Hearst, </SPAN ><SPAN CLASS="AUTHOR" >and S. Potamianos</SPAN >, "<A HREF="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M89-82.pdf" TARGET="_top" >A commentary on the <SPAN CLASS="PRODUCTNAME" >POSTGRES</SPAN > rules system</A >", <I >SIGMOD Record 18(3)</I >, Sept. 1989.</P ><DIV CLASS="BIBLIOENTRYBLOCK" STYLE="margin-left: 0.5in" ></DIV ></DIV ><DIV CLASS="BIBLIOENTRY" ><A NAME="STON89B" ></A ><P ><SPAN CLASS="AUTHOR" >M. Stonebraker</SPAN >, "<A HREF="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M89-17.pdf" TARGET="_top" >The case for partial indexes</A >", <I >SIGMOD Record 18(4)</I >, Dec. 1989, 4-11.</P ><DIV CLASS="BIBLIOENTRYBLOCK" STYLE="margin-left: 0.5in" ></DIV ></DIV ><DIV CLASS="BIBLIOENTRY" ><A NAME="STON90A" ></A ><P ><SPAN CLASS="AUTHOR" >M. Stonebraker, </SPAN ><SPAN CLASS="AUTHOR" >L. A. Rowe, </SPAN ><SPAN CLASS="AUTHOR" >and M. Hirohama</SPAN >, "<A HREF="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M90-34.pdf" TARGET="_top" >The implementation of <SPAN CLASS="PRODUCTNAME" >POSTGRES</SPAN ></A >", <I >Transactions on Knowledge and Data Engineering 2(1)</I >, IEEE, March 1990.</P ><DIV CLASS="BIBLIOENTRYBLOCK" STYLE="margin-left: 0.5in" ></DIV ></DIV ><DIV CLASS="BIBLIOENTRY" ><A NAME="STON90B" ></A ><P ><SPAN CLASS="AUTHOR" >M. Stonebraker, </SPAN ><SPAN CLASS="AUTHOR" >A. Jhingran, </SPAN ><SPAN CLASS="AUTHOR" >J. Goh, </SPAN ><SPAN CLASS="AUTHOR" >and S. Potamianos</SPAN >, "<A HREF="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M90-36.pdf" TARGET="_top" >On Rules, Procedures, Caching and Views in Database Systems</A >", Proc. <SPAN CLASS="CONFTITLE" >ACM-SIGMOD Conference on Management of Data</SPAN >, <SPAN CLASS="CONFDATES" >June 1990</SPAN >.</P ><DIV CLASS="BIBLIOENTRYBLOCK" STYLE="margin-left: 0.5in" ></DIV ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="external-extensions.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="bookindex.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Extensions</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" > </TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Index</TD ></TR ></TABLE ></DIV ></BODY ></HTML >