Advanced SQL:1999: Understanding Object-Relational and Other Advanced Features

Front Cover
Morgan Kaufmann, 2003 - 563 pages


Advanced SQL:1999 - Understanding Object-Relational and Other Advanced Features is the practitioner's handbook to the standard's advanced features. It is not a re-presentation of the standard, but rather an authoritative, in-depth guide to its practical application. Like its companion, SQL:1999 - Understanding Relational Language Components, which explained the standard's basic features, this book will show you how to make your applications both effective and standard-compliant.


This handy reference has a modular format so you can explore specific topics with ease. It is equally useful to those upgrading from earlier versions of SQL and those with no previous experience. Written by the standard's distinguished editor, Advanced SQL:1999 will complete your knowledge and support your skills like no other book can.


Features

  • Focuses entirely on the issues that matter to programmers who are connecting applications to databases.
  • Details SQL:1999's object facilities, including structured user-defined types, typed tables, user-defined routines, and routine invocation.
  • Examines facilities new to SQL, including those relating to on-line analytical processing (OLAP), management of external data (SQL/MED), and Java support.
  • Covers the ongoing development of XML support.
  • Includes appendices that cover the SQL:1999 annexes, a SQL:1999 example using UDTs, status codes, and useful information on the standardization process.
 

Contents

III
xxvii
IV
xxviii
V
3
VI
5
VII
14
VIII
16
IX
17
X
19
LVI
278
LVII
284
LVIII
294
LX
295
LXI
297
LXII
304
LXIII
305
LXIV
328

XI
23
XII
24
XIII
28
XIV
33
XV
41
XVI
56
XVII
66
XVIII
76
XIX
82
XX
104
XXI
105
XXII
108
XXIII
109
XXIV
115
XXV
117
XXVII
119
XXVIII
121
XXIX
127
XXX
132
XXXI
138
XXXII
143
XXXIII
146
XXXIV
148
XXXV
149
XXXVI
151
XXXVII
153
XXXVIII
158
XXXIX
160
XL
189
XLI
205
XLII
216
XLIII
229
XLIV
231
XLV
233
XLVII
238
XLVIII
242
XLIX
260
L
266
LI
273
LII
276
LIII
277
LXV
330
LXVI
347
LXVII
349
LXVIII
351
LXIX
353
LXX
358
LXXI
367
LXXII
372
LXXIII
373
LXXV
374
LXXVII
380
LXXVIII
395
LXXIX
407
LXXX
409
LXXXI
412
LXXXII
413
LXXXIII
421
LXXXIV
430
LXXXV
435
LXXXVI
441
LXXXVII
443
LXXXVIII
445
LXXXIX
446
XC
447
XCII
463
XCIII
469
XCIV
470
XCV
492
XCVI
493
XCVII
495
XCIX
497
CI
503
CIV
517
CIX
522
CX
526
CXI
527
CXII
528
CXIII
529
CXIV
561
Copyright

Other editions - View all

Common terms and phrases

About the author (2003)

Jim Melton is editor of all parts of ISO/IEC 9075 (SQL) and is a representative for database standards at Oracle Corporation. Since 1986, he has been his company's representative to ANSI INCITS Technical Committee H2 for Database and a US representative to ISO/IEC JTC1/SC32/WG3 (Database Languages). In addition, Jim has participated in the W3C's XML Query Working Group since 1998 and is currently co-Chair of that Working Group. He is also Chair of the WG's Full-Text Task Force, co-Chair of the Update Language Task Force, and co-editor of two XQuery-related specifications. He is the author of several SQL books.

Bibliographic information