3
<bibliography id="biblio">
4
<title>Bibliography</title>
7
Selected references and readings for <acronym>SQL</acronym>
8
and <productname>PostgreSQL</productname>.
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/">
20
<title><acronym>SQL</acronym> Reference Books</title>
21
<para>Reference texts for <acronym>SQL</acronym> features.</para>
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>
30
<firstname>Judith</firstname>
31
<surname>Bowman</surname>
34
<firstname>Sandra</firstname>
35
<surname>Emerson</surname>
38
<firstname>Marcy</firstname>
39
<surname>Darnovsky</surname>
42
<isbn>0-201-70309-2</isbn>
43
<pubdate>2001</pubdate>
45
<publishername>Addison-Wesley Professional</publishername>
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>
59
<firstname>C. J.</firstname>
60
<surname>Date</surname>
63
<firstname>Hugh</firstname>
64
<surname>Darwen</surname>
67
<isbn>0-201-96426-0</isbn>
68
<pubdate>1997</pubdate>
70
<publishername>Addison-Wesley</publishername>
74
<holder>Addison-Wesley Longman, Inc.</holder>
78
<biblioentry id="DATE04">
79
<title>An Introduction to Database Systems</title>
80
<titleabbrev>Date, 2004</titleabbrev>
81
<edition>Eighth Edition</edition>
84
<firstname>C. J.</firstname>
85
<surname>Date</surname>
88
<isbn>0-321-19784-4</isbn>
89
<pubdate>2003</pubdate>
91
<publishername>Addison-Wesley</publishername>
95
<holder>Pearson Education, Inc.</holder>
99
<biblioentry id="ELMA04">
100
<title>Fundamentals of Database Systems</title>
101
<edition>Fourth Edition</edition>
104
<firstname>Ramez</firstname>
105
<surname>Elmasri</surname>
108
<firstname>Shamkant</firstname>
109
<surname>Navathe</surname>
112
<isbn>0-321-12226-7</isbn>
113
<pubdate>2003</pubdate>
115
<publishername>Addison-Wesley</publishername>
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>
128
<firstname>Jim</firstname>
129
<surname>Melton</surname>
132
<firstname>Alan R.</firstname>
133
<surname>Simon</surname>
136
<isbn>1-55860-245-3</isbn>
137
<pubdate>1993</pubdate>
139
<publishername>Morgan Kaufmann</publishername>
143
<holder>Morgan Kaufmann Publishers, Inc.</holder>
147
<biblioentry id="ULL88">
148
<title>Principles of Database and Knowledge</title>
149
<subtitle>Base Systems</subtitle>
150
<titleabbrev>Ullman, 1988</titleabbrev>
153
<firstname>Jeffrey D.</firstname>
154
<surname>Ullman</surname>
157
<volumenum>Volume 1</volumenum>
159
<publishername>Computer Science Press</publishername>
161
<pubdate>1988</pubdate>
167
<title>PostgreSQL-Specific Documentation</title>
168
<para>This section is for related documentation.</para>
170
<biblioentry id="SIM98">
171
<title>Enhancement of the ANSI SQL Implementation of PostgreSQL</title>
172
<titleabbrev>Simkovics, 1998</titleabbrev>
175
<firstname>Stefan</firstname>
176
<surname>Simkovics</surname>
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>
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.
208
<pubdate>November 29, 1998</pubdate>
210
<publishername>Department of Information Systems, Vienna University of Technology</publishername>
211
<address>Vienna, Austria</address>
215
<biblioentry id="YU95">
216
<title>The <productname>Postgres95</productname> User Manual</title>
217
<titleabbrev>Yu and Chen, 1995</titleabbrev>
220
<firstname>A.</firstname>
221
<surname>Yu</surname>
224
<firstname>J.</firstname>
225
<surname>Chen</surname>
230
<collabname>The POSTGRES Group</collabname>
234
<pubdate>Sept. 5, 1995</pubdate>
236
<publishername>University of California</publishername>
237
<address>Berkeley, California</address>
241
<biblioentry id="FONG">
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
247
<firstname>Zelaine</firstname>
248
<surname>Fong</surname>
251
<publishername>University of California, Berkeley, Computer Science Department</publishername>
258
<title>Proceedings and Articles</title>
259
<para>This section is for articles and newsletters.</para>
261
<biblioentry id="OLSON93">
262
<title>Partial indexing in POSTGRES: research project</title>
263
<titleabbrev>Olson, 1993</titleabbrev>
266
<firstname>Nels</firstname>
267
<surname>Olson</surname>
270
<pubdate>1993</pubdate>
271
<pubsnumber>UCB Engin T7.49.1993 O676</pubsnumber>
273
<publishername>University of California</publishername>
274
<address>Berkeley, California</address>
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>
284
<firstname>L.</firstname>
285
<surname>Ong</surname>
288
<firstname>J.</firstname>
289
<surname>Goh</surname>
293
<biblioset relation="journal">
294
<title>ERL Technical Memorandum M90/33</title>
295
<pubdate>April, 1990</pubdate>
297
<publishername>University of California</publishername>
298
<address>Berkely, California</address>
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
308
<titleabbrev>Rowe and Stonebraker, 1987</titleabbrev>
311
<firstname>L.</firstname>
312
<surname>Rowe</surname>
315
<firstname>M.</firstname>
316
<surname>Stonebraker</surname>
321
<conftitle>VLDB Conference</conftitle>
322
<confdates>Sept. 1987</confdates>
323
<address>Brighton, England</address>
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)
332
Original URL: http://citeseer.ist.psu.edu/seshadri95generalized.html
336
<titleabbrev>Seshardri, 1995</titleabbrev>
339
<firstname>P.</firstname>
340
<surname>Seshadri</surname>
343
<firstname>A.</firstname>
344
<surname>Swami</surname>
349
<conftitle>Eleventh International Conference on Data Engineering</conftitle>
350
<confdates>6-10 March 1995</confdates>
351
<address>Taipeh, Taiwan</address>
353
<pubdate>1995</pubdate>
354
<pubsnumber>Cat. No.95CH35724</pubsnumber>
356
<publishername>IEEE Computer Society Press</publishername>
357
<address>Los Alamitos, California</address>
359
<pagenums>420-7</pagenums>
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>
367
<titleabbrev>Stonebraker and Rowe, 1986</titleabbrev>
370
<firstname>M.</firstname>
371
<surname>Stonebraker</surname>
374
<firstname>L.</firstname>
375
<surname>Rowe</surname>
380
<conftitle>ACM-SIGMOD Conference on Management of Data</conftitle>
381
<confdates>May 1986</confdates>
382
<address>Washington, DC</address>
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>
392
<firstname>M.</firstname>
393
<surname>Stonebraker</surname>
396
<firstname>E.</firstname>
397
<surname>Hanson</surname>
400
<firstname>C. H.</firstname>
401
<surname>Hong</surname>
406
<conftitle>IEEE Conference on Data Engineering</conftitle>
407
<confdates>Feb. 1987</confdates>
408
<address>Los Angeles, California</address>
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
417
<titleabbrev>Stonebraker, 1987</titleabbrev>
420
<firstname>M.</firstname>
421
<surname>Stonebraker</surname>
426
<conftitle>VLDB Conference</conftitle>
427
<confdates>Sept. 1987</confdates>
428
<address>Brighton, England</address>
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
437
<titleabbrev>Stonebraker et al, 1989</titleabbrev>
440
<firstname>M.</firstname>
441
<surname>Stonebraker</surname>
444
<firstname>M.</firstname>
445
<surname>Hearst</surname>
448
<firstname>S.</firstname>
449
<surname>Potamianos</surname>
453
<biblioset relation="journal">
454
<title>SIGMOD Record 18(3)</title>
455
<date>Sept. 1989</date>
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
464
<titleabbrev>Stonebraker, M, 1989b</titleabbrev>
467
<firstname>M.</firstname>
468
<surname>Stonebraker</surname>
472
<biblioset relation="journal">
473
<title>SIGMOD Record 18(4)</title>
474
<pagenums>4-11</pagenums>
475
<date>Dec. 1989</date>
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>
484
<titleabbrev>Stonebraker, Rowe, Hirohama, 1990</titleabbrev>
487
<firstname>M.</firstname>
488
<surname>Stonebraker</surname>
491
<firstname>L. A.</firstname>
492
<surname>Rowe</surname>
495
<firstname>M.</firstname>
496
<surname>Hirohama</surname>
500
<biblioset relation="journal">
501
<title>Transactions on Knowledge and Data Engineering 2(1)</title>
503
<publishername>IEEE</publishername>
505
<date>March 1990</date>
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
514
<titleabbrev>Stonebraker et al, ACM, 1990</titleabbrev>
517
<firstname>M.</firstname>
518
<surname>Stonebraker</surname>
521
<firstname>A.</firstname>
522
<surname>Jhingran</surname>
525
<firstname>J.</firstname>
526
<surname>Goh</surname>
529
<firstname>S.</firstname>
530
<surname>Potamianos</surname>
535
<conftitle>ACM-SIGMOD Conference on Management of Data</conftitle>
536
<confdates>June 1990</confdates>