doc/src/sgml/biblio.sgml

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