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><ulink url="https://standards.iso.org/ittf/PubliclyAvailableStandards/c067367_ISO_IEC_TR_19075-6_2017.zip">SQL Technical Report</ulink></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<!-- 159Paul-Peters-Gasse 36 1602384 Breitenfurt 161AUSTRIA 162ssimkovi@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="ports12"> 234 <biblioset relation="article"> 235 <title><ulink url="https://arxiv.org/pdf/1208.4179">Serializable Snapshot Isolation in PostgreSQL</ulink></title> 236 <authorgroup> 237 <author> 238 <firstname>D.</firstname> 239 <surname>Ports</surname> 240 </author> 241 <author> 242 <firstname>K.</firstname> 243 <surname>Grittner</surname> 244 </author> 245 </authorgroup> 246 </biblioset> 247 <confgroup> 248 <conftitle>VLDB Conference</conftitle> 249 <confdates>August 2012</confdates> 250 <address>Istanbul, Turkey</address> 251 </confgroup> 252 </biblioentry> 253 254 <biblioentry id="berenson95"> 255 <biblioset relation="article"> 256 <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> 257 <authorgroup> 258 <author> 259 <firstname>H.</firstname> 260 <surname>Berenson</surname> 261 </author> 262 <author> 263 <firstname>P.</firstname> 264 <surname>Bernstein</surname> 265 </author> 266 <author> 267 <firstname>J.</firstname> 268 <surname>Gray</surname> 269 </author> 270 <author> 271 <firstname>J.</firstname> 272 <surname>Melton</surname> 273 </author> 274 <author> 275 <firstname>E.</firstname> 276 <surname>O'Neil</surname> 277 </author> 278 <author> 279 <firstname>P.</firstname> 280 <surname>O'Neil</surname> 281 </author> 282 </authorgroup> 283 </biblioset> 284 <confgroup> 285 <conftitle>ACM-SIGMOD Conference on Management of Data</conftitle> 286 <confdates>June 1995</confdates> 287 <address>San Jose, California</address> 288 </confgroup> 289 </biblioentry> 290 291 <biblioentry id="olson93"> 292 <title>Partial indexing in POSTGRES: research project</title> 293 <authorgroup> 294 <author> 295 <firstname>Nels</firstname> 296 <surname>Olson</surname> 297 </author> 298 </authorgroup> 299 <pubsnumber>UCB Engin T7.49.1993 O676</pubsnumber> 300 <publisher> 301 <publishername>University of California</publishername> 302 <address>Berkeley, California</address> 303 </publisher> 304 <pubdate>1993</pubdate> 305 </biblioentry> 306 307 <biblioentry id="ong90"> 308 <biblioset relation="article"> 309 <title>A Unified Framework for Version Modeling Using Production Rules in a Database System</title> 310 <authorgroup> 311 <author> 312 <firstname>L.</firstname> 313 <surname>Ong</surname> 314 </author> 315 <author> 316 <firstname>J.</firstname> 317 <surname>Goh</surname> 318 </author> 319 </authorgroup> 320 </biblioset> 321 <biblioset relation="journal"> 322 <title>ERL Technical Memorandum M90/33</title> 323 <publisher> 324 <publishername>University of California</publishername> 325 <address>Berkeley, California</address> 326 </publisher> 327 <pubdate>April, 1990</pubdate> 328 </biblioset> 329 </biblioentry> 330 331 <biblioentry id="rowe87"> 332 <biblioset relation="article"> 333 <title><ulink url="https://dsf.berkeley.edu/papers/ERL-M87-13.pdf">The <productname>POSTGRES</productname> 334 data model</ulink></title> 335 <authorgroup> 336 <author> 337 <firstname>L.</firstname> 338 <surname>Rowe</surname> 339 </author> 340 <author> 341 <firstname>M.</firstname> 342 <surname>Stonebraker</surname> 343 </author> 344 </authorgroup> 345 </biblioset> 346 <confgroup> 347 <conftitle>VLDB Conference</conftitle> 348 <confdates>Sept. 1987</confdates> 349 <address>Brighton, England</address> 350 </confgroup> 351 </biblioentry> 352 353 <biblioentry id="seshadri95"> 354 <biblioset relation="article"> 355 <title><ulink url="https://citeseer.ist.psu.edu/viewdoc/summary?doi=10.1.1.40.5740">Generalized 356 Partial Indexes</ulink></title> 357 <authorgroup> 358 <author> 359 <firstname>P.</firstname> 360 <surname>Seshadri</surname> 361 </author> 362 <author> 363 <firstname>A.</firstname> 364 <surname>Swami</surname> 365 </author> 366 </authorgroup> 367 </biblioset> 368 <confgroup> 369 <conftitle>Eleventh International Conference on Data Engineering</conftitle> 370 <confdates>6–10 March 1995</confdates> 371 <address>Taipeh, Taiwan</address> 372 </confgroup> 373 <pubsnumber>Cat. No.95CH35724</pubsnumber> 374 <publisher> 375 <publishername>IEEE Computer Society Press</publishername> 376 <address>Los Alamitos, California</address> 377 </publisher> 378 <pubdate>1995</pubdate> 379 <pagenums>420–7</pagenums> 380 </biblioentry> 381 382 <biblioentry id="ston86"> 383 <biblioset relation="article"> 384 <title><ulink url="https://dsf.berkeley.edu/papers/ERL-M85-95.pdf">The 385 design of <productname>POSTGRES</productname></ulink></title> 386 <authorgroup> 387 <author> 388 <firstname>M.</firstname> 389 <surname>Stonebraker</surname> 390 </author> 391 <author> 392 <firstname>L.</firstname> 393 <surname>Rowe</surname> 394 </author> 395 </authorgroup> 396 </biblioset> 397 <confgroup> 398 <conftitle>ACM-SIGMOD Conference on Management of Data</conftitle> 399 <confdates>May 1986</confdates> 400 <address>Washington, DC</address> 401 </confgroup> 402 </biblioentry> 403 404 <biblioentry id="ston87a"> 405 <biblioset relation="article"> 406 <title>The design of the <productname>POSTGRES</productname> rules system</title> 407 <authorgroup> 408 <author> 409 <firstname>M.</firstname> 410 <surname>Stonebraker</surname> 411 </author> 412 <author> 413 <firstname>E.</firstname> 414 <surname>Hanson</surname> 415 </author> 416 <author> 417 <firstname>C. H.</firstname> 418 <surname>Hong</surname> 419 </author> 420 </authorgroup> 421 </biblioset> 422 <confgroup> 423 <conftitle>IEEE Conference on Data Engineering</conftitle> 424 <confdates>Feb. 1987</confdates> 425 <address>Los Angeles, California</address> 426 </confgroup> 427 </biblioentry> 428 429 <biblioentry id="ston87b"> 430 <biblioset relation="article"> 431 <title><ulink url="https://dsf.berkeley.edu/papers/ERL-M87-06.pdf">The 432 design of the <productname>POSTGRES</productname> storage 433 system</ulink></title> 434 <authorgroup> 435 <author> 436 <firstname>M.</firstname> 437 <surname>Stonebraker</surname> 438 </author> 439 </authorgroup> 440 </biblioset> 441 <confgroup> 442 <conftitle>VLDB Conference</conftitle> 443 <confdates>Sept. 1987</confdates> 444 <address>Brighton, England</address> 445 </confgroup> 446 </biblioentry> 447 448 <biblioentry id="ston89"> 449 <biblioset relation="article"> 450 <title><ulink url="https://dsf.berkeley.edu/papers/ERL-M89-82.pdf">A 451 commentary on the <productname>POSTGRES</productname> rules 452 system</ulink></title> 453 <authorgroup> 454 <author> 455 <firstname>M.</firstname> 456 <surname>Stonebraker</surname> 457 </author> 458 <author> 459 <firstname>M.</firstname> 460 <surname>Hearst</surname> 461 </author> 462 <author> 463 <firstname>S.</firstname> 464 <surname>Potamianos</surname> 465 </author> 466 </authorgroup> 467 </biblioset> 468 <biblioset relation="journal"> 469 <title>SIGMOD Record 18(3)</title> 470 <date>Sept. 1989</date> 471 </biblioset> 472 </biblioentry> 473 474 <biblioentry id="ston89b"> 475 <biblioset relation="article"> 476 <title><ulink url="https://dsf.berkeley.edu/papers/ERL-M89-17.pdf">The 477 case for partial indexes</ulink></title> 478 <authorgroup> 479 <author> 480 <firstname>M.</firstname> 481 <surname>Stonebraker</surname> 482 </author> 483 </authorgroup> 484 </biblioset> 485 <biblioset relation="journal"> 486 <title>SIGMOD Record 18(4)</title> 487 <date>Dec. 1989</date> 488 <pagenums>4–11</pagenums> 489 </biblioset> 490 </biblioentry> 491 492 <biblioentry id="ston90a"> 493 <biblioset relation="article"> 494 <title><ulink url="https://dsf.berkeley.edu/papers/ERL-M90-34.pdf">The 495 implementation of <productname>POSTGRES</productname></ulink></title> 496 <authorgroup> 497 <author> 498 <firstname>M.</firstname> 499 <surname>Stonebraker</surname> 500 </author> 501 <author> 502 <firstname>L. A.</firstname> 503 <surname>Rowe</surname> 504 </author> 505 <author> 506 <firstname>M.</firstname> 507 <surname>Hirohama</surname> 508 </author> 509 </authorgroup> 510 </biblioset> 511 <biblioset relation="journal"> 512 <title>Transactions on Knowledge and Data Engineering 2(1)</title> 513 <publisher> 514 <publishername>IEEE</publishername> 515 </publisher> 516 <date>March 1990</date> 517 </biblioset> 518 </biblioentry> 519 520 <biblioentry id="ston90b"> 521 <biblioset relation="article"> 522 <title><ulink url="https://dsf.berkeley.edu/papers/ERL-M90-36.pdf">On 523 Rules, Procedures, Caching and Views in Database Systems</ulink></title> 524 <authorgroup> 525 <author> 526 <firstname>M.</firstname> 527 <surname>Stonebraker</surname> 528 </author> 529 <author> 530 <firstname>A.</firstname> 531 <surname>Jhingran</surname> 532 </author> 533 <author> 534 <firstname>J.</firstname> 535 <surname>Goh</surname> 536 </author> 537 <author> 538 <firstname>S.</firstname> 539 <surname>Potamianos</surname> 540 </author> 541 </authorgroup> 542 </biblioset> 543 <confgroup> 544 <conftitle>ACM-SIGMOD Conference on Management of Data</conftitle> 545 <confdates>June 1990</confdates> 546 </confgroup> 547 </biblioentry> 548 549 </bibliodiv> 550 </bibliography> 551