doc/src/sgml/biblio.sgml

   1 <!-- $PostgreSQL$ -->
   2
   3  <bibliography id="biblio">
   4   <title>Bibliography</title>
   5
   6   <para>
   7    Selected references and readings for <acronym>SQL</acronym>
   8    and <productname>PostgreSQL</productname>.
   9   </para>
  10
  11   <para>
  12    Some white papers and technical reports from the original
  13    <productname>POSTGRES</productname> development team
  14    are available at the University of California, Berkeley, Computer Science
  15    Department <ulink url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/">
  16    web site</ulink>.
  17   </para>
  18
  19   <bibliodiv>
  20    <title><acronym>SQL</acronym> Reference Books</title>
  21    <para>Reference texts for <acronym>SQL</acronym> features.</para>
  22
  23    <biblioentry id="BOWMAN01">
  24     <title>The Practical <acronym>SQL</acronym> Handbook</title>
  25     <titleabbrev>Bowman et al, 2001</titleabbrev>
  26     <subtitle>Using SQL Variants</subtitle>
  27     <edition>Fourth Edition</edition>
  28     <authorgroup>
  29      <author>
  30       <firstname>Judith</firstname>
  31       <surname>Bowman</surname>
  32      </author>
  33      <author>
  34       <firstname>Sandra</firstname>
  35       <surname>Emerson</surname>
  36      </author>
  37      <author>
  38       <firstname>Marcy</firstname>
  39       <surname>Darnovsky</surname>
  40      </author>
  41     </authorgroup>
  42     <isbn>0-201-70309-2</isbn>
  43     <pubdate>2001</pubdate>
  44     <publisher>
  45      <publishername>Addison-Wesley Professional</publishername>
  46     </publisher>
  47     <copyright>
  48      <year>2001</year>
  49     </copyright>
  50    </biblioentry>
  51
  52    <biblioentry id="DATE97">
  53     <title>A Guide to the <acronym>SQL</acronym> Standard</title>
  54     <titleabbrev>Date and Darwen, 1997</titleabbrev>
  55     <subtitle>A user's guide to the standard database language <acronym>SQL</acronym></subtitle>
  56     <edition>Fourth Edition</edition>
  57     <authorgroup>
  58      <author>
  59       <firstname>C. J.</firstname>
  60       <surname>Date</surname>
  61      </author>
  62      <author>
  63       <firstname>Hugh</firstname>
  64       <surname>Darwen</surname>
  65      </author>
  66     </authorgroup>
  67     <isbn>0-201-96426-0</isbn>
  68     <pubdate>1997</pubdate>
  69     <publisher>
  70      <publishername>Addison-Wesley</publishername>
  71     </publisher>
  72     <copyright>
  73      <year>1997</year>
  74      <holder>Addison-Wesley Longman, Inc.</holder>
  75     </copyright>
  76    </biblioentry>
  77
  78    <biblioentry id="DATE04">
  79     <title>An Introduction to Database Systems</title>
  80     <titleabbrev>Date, 2004</titleabbrev>
  81     <edition>Eighth Edition</edition>
  82     <authorgroup>
  83      <author>
  84       <firstname>C. J.</firstname>
  85       <surname>Date</surname>
  86      </author>
  87     </authorgroup>
  88     <isbn>0-321-19784-4</isbn>
  89     <pubdate>2003</pubdate>
  90     <publisher>
  91      <publishername>Addison-Wesley</publishername>
  92     </publisher>
  93     <copyright>
  94      <year>2004</year>
  95      <holder>Pearson Education, Inc.</holder>
  96     </copyright>
  97    </biblioentry>
  98
  99   <biblioentry id="ELMA04">
 100    <title>Fundamentals of Database Systems</title>
 101    <edition>Fourth Edition</edition>
 102    <authorgroup>
 103     <author>
 104      <firstname>Ramez</firstname>
 105      <surname>Elmasri</surname>
 106     </author>
 107     <author>
 108      <firstname>Shamkant</firstname>
 109      <surname>Navathe</surname>
 110     </author>
 111    </authorgroup>
 112    <isbn>0-321-12226-7</isbn>
 113    <pubdate>2003</pubdate>
 114    <publisher>
 115     <publishername>Addison-Wesley</publishername>
 116    </publisher>
 117    <copyright>
 118     <year>2004</year>
 119    </copyright>
 120   </biblioentry>
 121
 122    <biblioentry id="MELT93">
 123     <title>Understanding the New <acronym>SQL</acronym></title>
 124     <titleabbrev>Melton and Simon, 1993</titleabbrev>
 125     <subtitle>A complete guide</subtitle>
 126     <authorgroup>
 127      <author>
 128       <firstname>Jim</firstname>
 129       <surname>Melton</surname>
 130      </author>
 131      <author>
 132       <firstname>Alan R.</firstname>
 133       <surname>Simon</surname>
 134      </author>
 135     </authorgroup>
 136     <isbn>1-55860-245-3</isbn>
 137     <pubdate>1993</pubdate>
 138     <publisher>
 139      <publishername>Morgan Kaufmann</publishername>
 140     </publisher>
 141     <copyright>
 142      <year>1993</year>
 143      <holder>Morgan Kaufmann Publishers, Inc.</holder>
 144     </copyright>
 145    </biblioentry>
 146
 147    <biblioentry id="ULL88">
 148     <title>Principles of Database and Knowledge</title>
 149     <subtitle>Base Systems</subtitle>
 150     <titleabbrev>Ullman, 1988</titleabbrev>
 151     <authorgroup>
 152      <author>
 153       <firstname>Jeffrey D.</firstname>
 154       <surname>Ullman</surname>
 155      </author>
 156     </authorgroup>
 157     <volumenum>Volume 1</volumenum>
 158     <publisher>
 159      <publishername>Computer Science Press</publishername>
 160     </publisher>
 161     <pubdate>1988</pubdate>
 162    </biblioentry>
 163
 164   </bibliodiv>
 165
 166   <bibliodiv>
 167    <title>PostgreSQL-Specific Documentation</title>
 168    <para>This section is for related documentation.</para>
 169
 170    <biblioentry id="SIM98">
 171     <title>Enhancement of the ANSI SQL Implementation of PostgreSQL</title>
 172     <titleabbrev>Simkovics, 1998</titleabbrev>
 173     <authorgroup>
 174      <author>
 175       <firstname>Stefan</firstname>
 176       <surname>Simkovics</surname>
 177 <!--
 178 Paul-Peters-Gasse 36
 179 2384 Breitenfurt
 180 AUSTRIA
 181 ssimkovi@ag.or.at
 182 -->
 183      </author>
 184     </authorgroup>
 185 <!--
 186     <othercredit>
 187      <contrib>
 188       with support by
 189      </contrib>
 190      <honorific>O. Univ. Prof. Dr.</honorific>
 191      <firstname>Georg</firstname>
 192      <surname>Gottlob</surname>
 193      <honorific>Univ. Ass. Mag.</honorific>
 194      <firstname>Katrin</firstname>
 195      <surname>Seyr</surname>
 196     </othercredit>
 197 -->
 198     <abstract>
 199      <para>
 200       Discusses SQL history and syntax, and describes the addition of
 201       <literal>INTERSECT</> and <literal>EXCEPT</> constructs into
 202       <productname>PostgreSQL</productname>.  Prepared as a Master's
 203       Thesis with the support of O. Univ. Prof. Dr. Georg Gottlob and
 204       Univ. Ass. Mag. Katrin Seyr at Vienna University of Technology.
 205      </para>
 206     </abstract>
 207
 208     <pubdate>November 29, 1998</pubdate>
 209     <publisher>
 210      <publishername>Department of Information Systems, Vienna University of Technology</publishername>
 211      <address>Vienna, Austria</address>
 212     </publisher>
 213    </biblioentry>
 214
 215    <biblioentry id="YU95">
 216     <title>The <productname>Postgres95</productname> User Manual</title>
 217     <titleabbrev>Yu and Chen, 1995</titleabbrev>
 218     <authorgroup>
 219      <author>
 220       <firstname>A.</firstname>
 221       <surname>Yu</surname>
 222      </author>
 223      <author>
 224       <firstname>J.</firstname>
 225       <surname>Chen</surname>
 226      </author>
 227     </authorgroup>
 228     <authorgroup>
 229      <collab>
 230       <collabname>The POSTGRES Group</collabname>
 231      </collab>
 232     </authorgroup>
 233
 234     <pubdate>Sept. 5, 1995</pubdate>
 235     <publisher>
 236      <publishername>University  of  California</publishername>
 237      <address>Berkeley, California</address>
 238     </publisher>
 239    </biblioentry>
 240
 241   <biblioentry id="FONG">
 242    <title>
 243    <ulink url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/UCB-MS-zfong.pdf">
 244    The design and implementation of the <productname>POSTGRES</productname> query optimizer
 245    </ulink></title>
 246    <author>
 247     <firstname>Zelaine</firstname>
 248     <surname>Fong</surname>
 249    </author>
 250    <publisher>
 251     <publishername>University of California, Berkeley, Computer Science Department</publishername>
 252    </publisher>
 253   </biblioentry>
 254
 255   </bibliodiv>
 256
 257   <bibliodiv>
 258    <title>Proceedings and Articles</title>
 259    <para>This section is for articles and newsletters.</para>
 260
 261    <biblioentry id="OLSON93">
 262     <title>Partial indexing in POSTGRES: research project</title>
 263     <titleabbrev>Olson, 1993</titleabbrev>
 264     <authorgroup>
 265      <author>
 266       <firstname>Nels</firstname>
 267       <surname>Olson</surname>
 268      </author>
 269     </authorgroup>
 270     <pubdate>1993</pubdate>
 271     <pubsnumber>UCB Engin T7.49.1993 O676</pubsnumber>
 272     <publisher>
 273      <publishername>University  of  California</publishername>
 274      <address>Berkeley, California</address>
 275     </publisher>
 276    </biblioentry>
 277
 278    <biblioentry id="ONG90">
 279    <biblioset relation="article">
 280     <title>A Unified Framework for Version Modeling Using Production Rules in a Database System</title>
 281     <titleabbrev>Ong and Goh, 1990</titleabbrev>
 282     <authorgroup>
 283      <author>
 284       <firstname>L.</firstname>
 285       <surname>Ong</surname>
 286      </author>
 287      <author>
 288       <firstname>J.</firstname>
 289       <surname>Goh</surname>
 290      </author>
 291     </authorgroup>
 292    </biblioset>
 293    <biblioset relation="journal">
 294     <title>ERL Technical Memorandum M90/33</title>
 295     <pubdate>April, 1990</pubdate>
 296     <publisher>
 297      <publishername>University  of  California</publishername>
 298      <address>Berkely, California</address>
 299     </publisher>
 300    </biblioset>
 301    </biblioentry>
 302
 303    <biblioentry id="ROWE87">
 304    <biblioset relation="article">
 305     <title><ulink url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M87-13.pdf">
 306     The <productname>POSTGRES</productname> data model
 307     </ulink></title>
 308     <titleabbrev>Rowe and Stonebraker, 1987</titleabbrev>
 309     <authorgroup>
 310      <author>
 311       <firstname>L.</firstname>
 312       <surname>Rowe</surname>
 313      </author>
 314      <author>
 315       <firstname>M.</firstname>
 316       <surname>Stonebraker</surname>
 317      </author>
 318     </authorgroup>
 319     </biblioset>
 320     <confgroup>
 321      <conftitle>VLDB Conference</conftitle>
 322      <confdates>Sept. 1987</confdates>
 323      <address>Brighton, England</address>
 324     </confgroup>
 325    </biblioentry>
 326
 327    <biblioentry id="SESHADRI95">
 328    <biblioset relation="article">
 329     <title>Generalized Partial Indexes
 330     <ulink url="http://citeseer.ist.psu.edu/seshadri95generalized.html">(cached version)
 331 <!--
 332      Original URL:  http://citeseer.ist.psu.edu/seshadri95generalized.html
 333 -->
 334     </ulink>
 335     </title>
 336     <titleabbrev>Seshardri, 1995</titleabbrev>
 337     <authorgroup>
 338      <author>
 339       <firstname>P.</firstname>
 340       <surname>Seshadri</surname>
 341      </author>
 342      <author>
 343       <firstname>A.</firstname>
 344       <surname>Swami</surname>
 345      </author>
 346     </authorgroup>
 347    </biblioset>
 348     <confgroup>
 349      <conftitle>Eleventh International Conference on Data Engineering</conftitle>
 350      <confdates>6-10 March 1995</confdates>
 351      <address>Taipeh, Taiwan</address>
 352     </confgroup>
 353     <pubdate>1995</pubdate>
 354     <pubsnumber>Cat. No.95CH35724</pubsnumber>
 355     <publisher>
 356      <publishername>IEEE Computer Society Press</publishername>
 357      <address>Los Alamitos, California</address>
 358     </publisher>
 359     <pagenums>420-7</pagenums>
 360    </biblioentry>
 361
 362    <biblioentry id="STON86">
 363    <biblioset relation="article">
 364     <title><ulink url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M85-95.pdf">
 365     The design of <productname>POSTGRES</productname>
 366     </ulink></title>
 367     <titleabbrev>Stonebraker and Rowe, 1986</titleabbrev>
 368     <authorgroup>
 369      <author>
 370       <firstname>M.</firstname>
 371       <surname>Stonebraker</surname>
 372      </author>
 373      <author>
 374       <firstname>L.</firstname>
 375       <surname>Rowe</surname>
 376      </author>
 377     </authorgroup>
 378    </biblioset>
 379     <confgroup>
 380      <conftitle>ACM-SIGMOD Conference on Management of Data</conftitle>
 381      <confdates>May 1986</confdates>
 382      <address>Washington, DC</address>
 383     </confgroup>
 384    </biblioentry>
 385
 386    <biblioentry id="STON87a">
 387    <biblioset relation="article">
 388     <title>The design of the <productname>POSTGRES</productname> rules system</title>
 389     <titleabbrev>Stonebraker, Hanson, Hong, 1987</titleabbrev>
 390     <authorgroup>
 391      <author>
 392       <firstname>M.</firstname>
 393       <surname>Stonebraker</surname>
 394      </author>
 395      <author>
 396       <firstname>E.</firstname>
 397       <surname>Hanson</surname>
 398      </author>
 399      <author>
 400       <firstname>C. H.</firstname>
 401       <surname>Hong</surname>
 402      </author>
 403     </authorgroup>
 404    </biblioset>
 405     <confgroup>
 406      <conftitle>IEEE Conference on Data Engineering</conftitle>
 407      <confdates>Feb. 1987</confdates>
 408      <address>Los Angeles, California</address>
 409     </confgroup>
 410    </biblioentry>
 411
 412    <biblioentry id="STON87b">
 413    <biblioset relation="article">
 414     <title><ulink url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M87-06.pdf">
 415     The design of the <productname>POSTGRES</productname> storage system
 416     </ulink></title>
 417     <titleabbrev>Stonebraker, 1987</titleabbrev>
 418     <authorgroup>
 419      <author>
 420       <firstname>M.</firstname>
 421       <surname>Stonebraker</surname>
 422      </author>
 423     </authorgroup>
 424    </biblioset>
 425     <confgroup>
 426      <conftitle>VLDB Conference</conftitle>
 427      <confdates>Sept. 1987</confdates>
 428      <address>Brighton, England</address>
 429     </confgroup>
 430    </biblioentry>
 431
 432    <biblioentry id="STON89">
 433    <biblioset relation="article">
 434     <title><ulink url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M89-82.pdf">
 435     A commentary on the <productname>POSTGRES</productname> rules system
 436     </ulink></title>
 437     <titleabbrev>Stonebraker et al, 1989</titleabbrev>
 438     <authorgroup>
 439      <author>
 440       <firstname>M.</firstname>
 441       <surname>Stonebraker</surname>
 442      </author>
 443      <author>
 444       <firstname>M.</firstname>
 445       <surname>Hearst</surname>
 446      </author>
 447      <author>
 448       <firstname>S.</firstname>
 449       <surname>Potamianos</surname>
 450      </author>
 451     </authorgroup>
 452    </biblioset>
 453    <biblioset relation="journal">
 454     <title>SIGMOD Record 18(3)</title>
 455     <date>Sept. 1989</date>
 456    </biblioset>
 457    </biblioentry>
 458
 459    <biblioentry id="STON89b">
 460    <biblioset relation="article">
 461     <title><ulink url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M89-17.pdf">
 462     The case for partial indexes
 463     </ulink></title>
 464     <titleabbrev>Stonebraker, M, 1989b</titleabbrev>
 465     <authorgroup>
 466      <author>
 467       <firstname>M.</firstname>
 468       <surname>Stonebraker</surname>
 469      </author>
 470     </authorgroup>
 471    </biblioset>
 472    <biblioset relation="journal">
 473     <title>SIGMOD Record 18(4)</title>
 474     <pagenums>4-11</pagenums>
 475     <date>Dec. 1989</date>
 476    </biblioset>
 477    </biblioentry>
 478
 479    <biblioentry id="STON90a">
 480    <biblioset relation="article">
 481     <title><ulink url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M90-34.pdf">
 482     The implementation of <productname>POSTGRES</productname>
 483     </ulink></title>
 484     <titleabbrev>Stonebraker, Rowe, Hirohama, 1990</titleabbrev>
 485     <authorgroup>
 486      <author>
 487       <firstname>M.</firstname>
 488       <surname>Stonebraker</surname>
 489      </author>
 490      <author>
 491       <firstname>L. A.</firstname>
 492       <surname>Rowe</surname>
 493      </author>
 494      <author>
 495       <firstname>M.</firstname>
 496       <surname>Hirohama</surname>
 497      </author>
 498     </authorgroup>
 499    </biblioset>
 500    <biblioset relation="journal">
 501     <title>Transactions on Knowledge and Data Engineering 2(1)</title>
 502     <publisher>
 503      <publishername>IEEE</publishername>
 504     </publisher>
 505     <date>March 1990</date>
 506    </biblioset>
 507    </biblioentry>
 508
 509    <biblioentry id="STON90b">
 510    <biblioset relation="article">
 511     <title><ulink url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M90-36.pdf">
 512     On Rules, Procedures, Caching and Views in Database Systems
 513     </ulink></title>
 514     <titleabbrev>Stonebraker et al, ACM, 1990</titleabbrev>
 515     <authorgroup>
 516      <author>
 517       <firstname>M.</firstname>
 518       <surname>Stonebraker</surname>
 519      </author>
 520      <author>
 521       <firstname>A.</firstname>
 522       <surname>Jhingran</surname>
 523      </author>
 524      <author>
 525       <firstname>J.</firstname>
 526       <surname>Goh</surname>
 527      </author>
 528      <author>
 529       <firstname>S.</firstname>
 530       <surname>Potamianos</surname>
 531      </author>
 532     </authorgroup>
 533    </biblioset>
 534     <confgroup>
 535      <conftitle>ACM-SIGMOD Conference on Management of Data</conftitle>
 536      <confdates>June 1990</confdates>
 537     </confgroup>
 538    </biblioentry>
 539
 540   </bibliodiv>
 541  </bibliography>