<!-- doc/src/sgml/biblio.sgml -->

 <bibliography id="biblio">
  <title>Bibliography</title>

  <para>
   Selected references and readings for <acronym>SQL</acronym>
   and <productname>PostgreSQL</productname>.
  </para>

  <para>
   Some white papers and technical reports from the original
   <productname>POSTGRES</productname> development team
   are available at the University of California, Berkeley, Computer Science
   Department <ulink url="http://db.cs.berkeley.edu/papers/">
   web site</ulink>.
  </para>

  <bibliodiv>
   <title><acronym>SQL</acronym> Reference Books</title>

   <biblioentry id="BOWMAN01">
    <title>The Practical <acronym>SQL</acronym> Handbook</title>
    <titleabbrev>Bowman et al, 2001</titleabbrev>
    <subtitle>Using SQL Variants</subtitle>
    <edition>Fourth Edition</edition>
    <authorgroup>
     <author>
      <firstname>Judith</firstname>
      <surname>Bowman</surname>
     </author>
     <author>
      <firstname>Sandra</firstname>
      <surname>Emerson</surname>
     </author>
     <author>
      <firstname>Marcy</firstname>
      <surname>Darnovsky</surname>
     </author>
    </authorgroup>
    <isbn>0-201-70309-2</isbn>
    <pubdate>2001</pubdate>
    <publisher>
     <publishername>Addison-Wesley Professional</publishername>
    </publisher>
    <copyright>
     <year>2001</year>
    </copyright>
   </biblioentry>

   <biblioentry id="DATE97">
    <title>A Guide to the <acronym>SQL</acronym> Standard</title>
    <titleabbrev>Date and Darwen, 1997</titleabbrev>
    <subtitle>A user's guide to the standard database language <acronym>SQL</acronym></subtitle>
    <edition>Fourth Edition</edition>
    <authorgroup>
     <author>
      <firstname>C. J.</firstname>
      <surname>Date</surname>
     </author>
     <author>
      <firstname>Hugh</firstname>
      <surname>Darwen</surname>
     </author>
    </authorgroup>
    <isbn>0-201-96426-0</isbn>
    <pubdate>1997</pubdate>
    <publisher>
     <publishername>Addison-Wesley</publishername>
    </publisher>
    <copyright>
     <year>1997</year>
     <holder>Addison-Wesley Longman, Inc.</holder>
    </copyright>
   </biblioentry>

   <biblioentry id="DATE04">
    <title>An Introduction to Database Systems</title>
    <titleabbrev>Date, 2004</titleabbrev>
    <edition>Eighth Edition</edition>
    <authorgroup>
     <author>
      <firstname>C. J.</firstname>
      <surname>Date</surname>
     </author>
    </authorgroup>
    <isbn>0-321-19784-4</isbn>
    <pubdate>2003</pubdate>
    <publisher>
     <publishername>Addison-Wesley</publishername>
    </publisher>
    <copyright>
     <year>2004</year>
     <holder>Pearson Education, Inc.</holder>
    </copyright>
   </biblioentry>

  <biblioentry id="ELMA04">
   <title>Fundamentals of Database Systems</title>
   <edition>Fourth Edition</edition>
   <authorgroup>
    <author>
     <firstname>Ramez</firstname>
     <surname>Elmasri</surname>
    </author>
    <author>
     <firstname>Shamkant</firstname>
     <surname>Navathe</surname>
    </author>
   </authorgroup>
   <isbn>0-321-12226-7</isbn>
   <pubdate>2003</pubdate>
   <publisher>
    <publishername>Addison-Wesley</publishername>
   </publisher>
   <copyright>
    <year>2004</year>
   </copyright>
  </biblioentry>

   <biblioentry id="MELT93">
    <title>Understanding the New <acronym>SQL</acronym></title>
    <titleabbrev>Melton and Simon, 1993</titleabbrev>
    <subtitle>A complete guide</subtitle>
    <authorgroup>
     <author>
      <firstname>Jim</firstname>
      <surname>Melton</surname>
     </author>
     <author>
      <firstname>Alan R.</firstname>
      <surname>Simon</surname>
     </author>
    </authorgroup>
    <isbn>1-55860-245-3</isbn>
    <pubdate>1993</pubdate>
    <publisher>
     <publishername>Morgan Kaufmann</publishername>
    </publisher>
    <copyright>
     <year>1993</year>
     <holder>Morgan Kaufmann Publishers, Inc.</holder>
    </copyright>
   </biblioentry>

   <biblioentry id="ULL88">
    <title>Principles of Database and Knowledge</title>
    <subtitle>Base Systems</subtitle>
    <titleabbrev>Ullman, 1988</titleabbrev>
    <authorgroup>
     <author>
      <firstname>Jeffrey D.</firstname>
      <surname>Ullman</surname>
     </author>
    </authorgroup>
    <volumenum>Volume 1</volumenum>
    <publisher>
     <publishername>Computer Science Press</publishername>
    </publisher>
    <pubdate>1988</pubdate>
   </biblioentry>

  </bibliodiv>

  <bibliodiv>
   <title>PostgreSQL-specific Documentation</title>

   <biblioentry id="SIM98">
    <title>Enhancement of the ANSI SQL Implementation of PostgreSQL</title>
    <titleabbrev>Simkovics, 1998</titleabbrev>
    <authorgroup>
     <author>
      <firstname>Stefan</firstname>
      <surname>Simkovics</surname>
<!--
Paul-Peters-Gasse 36
2384 Breitenfurt
AUSTRIA
ssimkovi@ag.or.at
-->
     </author>
    </authorgroup>
<!--
    <othercredit>
     <contrib>
      with support by
     </contrib>
     <honorific>O. Univ. Prof. Dr.</honorific>
     <firstname>Georg</firstname>
     <surname>Gottlob</surname>
     <honorific>Univ. Ass. Mag.</honorific>
     <firstname>Katrin</firstname>
     <surname>Seyr</surname>
    </othercredit>
-->
    <abstract>
     <para>
      Discusses SQL history and syntax, and describes the addition of
      <literal>INTERSECT</> and <literal>EXCEPT</> constructs into
      <productname>PostgreSQL</productname>.  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.
     </para>
    </abstract>

    <pubdate>November 29, 1998</pubdate>
    <publisher>
     <publishername>Department of Information Systems, Vienna University of Technology</publishername>
     <address>Vienna, Austria</address>
    </publisher>
   </biblioentry>

   <biblioentry id="YU95">
    <title>The <productname>Postgres95</productname> User Manual</title>
    <titleabbrev>Yu and Chen, 1995</titleabbrev>
    <authorgroup>
     <author>
      <firstname>A.</firstname>
      <surname>Yu</surname>
     </author>
     <author>
      <firstname>J.</firstname>
      <surname>Chen</surname>
     </author>
    </authorgroup>
    <authorgroup>
     <collab>
      <collabname>The POSTGRES Group</collabname>
     </collab>
    </authorgroup>

    <pubdate>Sept. 5, 1995</pubdate>
    <publisher>
     <publishername>University  of  California</publishername>
     <address>Berkeley, California</address>
    </publisher>
   </biblioentry>

  <biblioentry id="FONG">
   <title>
   <ulink url="http://db.cs.berkeley.edu/papers/UCB-MS-zfong.pdf">
   The design and implementation of the <productname>POSTGRES</productname> query optimizer
   </ulink></title>
   <author>
    <firstname>Zelaine</firstname>
    <surname>Fong</surname>
   </author>
   <publisher>
    <publishername>University of California, Berkeley, Computer Science Department</publishername>
   </publisher>
  </biblioentry>

  </bibliodiv>

  <bibliodiv>
   <title>Proceedings and Articles</title>

   <biblioentry id="OLSON93">
    <title>Partial indexing in POSTGRES: research project</title>
    <titleabbrev>Olson, 1993</titleabbrev>
    <authorgroup>
     <author>
      <firstname>Nels</firstname>
      <surname>Olson</surname>
     </author>
    </authorgroup>
    <pubdate>1993</pubdate>
    <pubsnumber>UCB Engin T7.49.1993 O676</pubsnumber>
    <publisher>
     <publishername>University  of  California</publishername>
     <address>Berkeley, California</address>
    </publisher>
   </biblioentry>

   <biblioentry id="ONG90">
   <biblioset relation="article">
    <title>A Unified Framework for Version Modeling Using Production Rules in a Database System</title>
    <titleabbrev>Ong and Goh, 1990</titleabbrev>
    <authorgroup>
     <author>
      <firstname>L.</firstname>
      <surname>Ong</surname>
     </author>
     <author>
      <firstname>J.</firstname>
      <surname>Goh</surname>
     </author>
    </authorgroup>
   </biblioset>
   <biblioset relation="journal">
    <title>ERL Technical Memorandum M90/33</title>
    <pubdate>April, 1990</pubdate>
    <publisher>
     <publishername>University  of  California</publishername>
     <address>Berkeley, California</address>
    </publisher>
   </biblioset>
   </biblioentry>

   <biblioentry id="ROWE87">
   <biblioset relation="article">
    <title><ulink url="http://db.cs.berkeley.edu/papers/ERL-M87-13.pdf">
    The <productname>POSTGRES</productname> data model
    </ulink></title>
    <titleabbrev>Rowe and Stonebraker, 1987</titleabbrev>
    <authorgroup>
     <author>
      <firstname>L.</firstname>
      <surname>Rowe</surname>
     </author>
     <author>
      <firstname>M.</firstname>
      <surname>Stonebraker</surname>
     </author>
    </authorgroup>
    </biblioset>
    <confgroup>
     <conftitle>VLDB Conference</conftitle>
     <confdates>Sept. 1987</confdates>
     <address>Brighton, England</address>
    </confgroup>
   </biblioentry>

   <biblioentry id="SESHADRI95">
   <biblioset relation="article">
    <title>Generalized Partial Indexes
    <ulink url="http://citeseer.ist.psu.edu/seshadri95generalized.html">(cached version)
<!--
     Original URL:  http://citeseer.ist.psu.edu/seshadri95generalized.html
-->
    </ulink>
    </title>
    <titleabbrev>Seshardri, 1995</titleabbrev>
    <authorgroup>
     <author>
      <firstname>P.</firstname>
      <surname>Seshadri</surname>
     </author>
     <author>
      <firstname>A.</firstname>
      <surname>Swami</surname>
     </author>
    </authorgroup>
   </biblioset>
    <confgroup>
     <conftitle>Eleventh International Conference on Data Engineering</conftitle>
     <confdates>6-10 March 1995</confdates>
     <address>Taipeh, Taiwan</address>
    </confgroup>
    <pubdate>1995</pubdate>
    <pubsnumber>Cat. No.95CH35724</pubsnumber>
    <publisher>
     <publishername>IEEE Computer Society Press</publishername>
     <address>Los Alamitos, California</address>
    </publisher>
    <pagenums>420-7</pagenums>
   </biblioentry>

   <biblioentry id="STON86">
   <biblioset relation="article">
    <title><ulink url="http://db.cs.berkeley.edu/papers/ERL-M85-95.pdf">
    The design of <productname>POSTGRES</productname>
    </ulink></title>
    <titleabbrev>Stonebraker and Rowe, 1986</titleabbrev>
    <authorgroup>
     <author>
      <firstname>M.</firstname>
      <surname>Stonebraker</surname>
     </author>
     <author>
      <firstname>L.</firstname>
      <surname>Rowe</surname>
     </author>
    </authorgroup>
   </biblioset>
    <confgroup>
     <conftitle>ACM-SIGMOD Conference on Management of Data</conftitle>
     <confdates>May 1986</confdates>
     <address>Washington, DC</address>
    </confgroup>
   </biblioentry>

   <biblioentry id="STON87a">
   <biblioset relation="article">
    <title>The design of the <productname>POSTGRES</productname> rules system</title>
    <titleabbrev>Stonebraker, Hanson, Hong, 1987</titleabbrev>
    <authorgroup>
     <author>
      <firstname>M.</firstname>
      <surname>Stonebraker</surname>
     </author>
     <author>
      <firstname>E.</firstname>
      <surname>Hanson</surname>
     </author>
     <author>
      <firstname>C. H.</firstname>
      <surname>Hong</surname>
     </author>
    </authorgroup>
   </biblioset>
    <confgroup>
     <conftitle>IEEE Conference on Data Engineering</conftitle>
     <confdates>Feb. 1987</confdates>
     <address>Los Angeles, California</address>
    </confgroup>
   </biblioentry>

   <biblioentry id="STON87b">
   <biblioset relation="article">
    <title><ulink url="http://db.cs.berkeley.edu/papers/ERL-M87-06.pdf">
    The design of the <productname>POSTGRES</productname> storage system
    </ulink></title>
    <titleabbrev>Stonebraker, 1987</titleabbrev>
    <authorgroup>
     <author>
      <firstname>M.</firstname>
      <surname>Stonebraker</surname>
     </author>
    </authorgroup>
   </biblioset>
    <confgroup>
     <conftitle>VLDB Conference</conftitle>
     <confdates>Sept. 1987</confdates>
     <address>Brighton, England</address>
    </confgroup>
   </biblioentry>

   <biblioentry id="STON89">
   <biblioset relation="article">
    <title><ulink url="http://db.cs.berkeley.edu/papers/ERL-M89-82.pdf">
    A commentary on the <productname>POSTGRES</productname> rules system
    </ulink></title>
    <titleabbrev>Stonebraker et al, 1989</titleabbrev>
    <authorgroup>
     <author>
      <firstname>M.</firstname>
      <surname>Stonebraker</surname>
     </author>
     <author>
      <firstname>M.</firstname>
      <surname>Hearst</surname>
     </author>
     <author>
      <firstname>S.</firstname>
      <surname>Potamianos</surname>
     </author>
    </authorgroup>
   </biblioset>
   <biblioset relation="journal">
    <title>SIGMOD Record 18(3)</title>
    <date>Sept. 1989</date>
   </biblioset>
   </biblioentry>

   <biblioentry id="STON89b">
   <biblioset relation="article">
    <title><ulink url="http://db.cs.berkeley.edu/papers/ERL-M89-17.pdf">
    The case for partial indexes
    </ulink></title>
    <titleabbrev>Stonebraker, M, 1989b</titleabbrev>
    <authorgroup>
     <author>
      <firstname>M.</firstname>
      <surname>Stonebraker</surname>
     </author>
    </authorgroup>
   </biblioset>
   <biblioset relation="journal">
    <title>SIGMOD Record 18(4)</title>
    <pagenums>4-11</pagenums>
    <date>Dec. 1989</date>
   </biblioset>
   </biblioentry>

   <biblioentry id="STON90a">
   <biblioset relation="article">
    <title><ulink url="http://db.cs.berkeley.edu/papers/ERL-M90-34.pdf">
    The implementation of <productname>POSTGRES</productname>
    </ulink></title>
    <titleabbrev>Stonebraker, Rowe, Hirohama, 1990</titleabbrev>
    <authorgroup>
     <author>
      <firstname>M.</firstname>
      <surname>Stonebraker</surname>
     </author>
     <author>
      <firstname>L. A.</firstname>
      <surname>Rowe</surname>
     </author>
     <author>
      <firstname>M.</firstname>
      <surname>Hirohama</surname>
     </author>
    </authorgroup>
   </biblioset>
   <biblioset relation="journal">
    <title>Transactions on Knowledge and Data Engineering 2(1)</title>
    <publisher>
     <publishername>IEEE</publishername>
    </publisher>
    <date>March 1990</date>
   </biblioset>
   </biblioentry>

   <biblioentry id="STON90b">
   <biblioset relation="article">
    <title><ulink url="http://db.cs.berkeley.edu/papers/ERL-M90-36.pdf">
    On Rules, Procedures, Caching and Views in Database Systems
    </ulink></title>
    <titleabbrev>Stonebraker et al, ACM, 1990</titleabbrev>
    <authorgroup>
     <author>
      <firstname>M.</firstname>
      <surname>Stonebraker</surname>
     </author>
     <author>
      <firstname>A.</firstname>
      <surname>Jhingran</surname>
     </author>
     <author>
      <firstname>J.</firstname>
      <surname>Goh</surname>
     </author>
     <author>
      <firstname>S.</firstname>
      <surname>Potamianos</surname>
     </author>
    </authorgroup>
   </biblioset>
    <confgroup>
     <conftitle>ACM-SIGMOD Conference on Management of Data</conftitle>
     <confdates>June 1990</confdates>
    </confgroup>
   </biblioentry>

  </bibliodiv>
 </bibliography>
