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

Front Cover
Morgan Kaufmann, 2003 - Computers - 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.
 

What people are saying - Write a review

User Review - Flag as inappropriate

Read this for how SQL interacts with integrated circuits. Haven't read this yet. Page 423 Spatial part , section number 10.5

Contents

III
xxvii
IV
xxviii
V
3
VI
5
VII
14
VIII
16
IX
17
X
19
LV
278
LVI
284
LVII
294
LVIII
295
LIX
297
LX
304
LXI
305
LXII
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
XXVI
119
XXVII
121
XXVIII
127
XXIX
132
XXX
138
XXXI
143
XXXII
146
XXXIII
148
XXXIV
149
XXXV
151
XXXVI
153
XXXVII
158
XXXVIII
160
XXXIX
189
XL
205
XLI
216
XLII
229
XLIII
231
XLIV
233
XLVI
238
XLVII
242
XLVIII
260
XLIX
266
L
273
LI
276
LII
277
LXIII
330
LXIV
347
LXV
349
LXVI
351
LXVII
353
LXVIII
358
LXIX
367
LXX
372
LXXI
373
LXXII
374
LXXIII
380
LXXIV
395
LXXV
407
LXXVI
409
LXXVII
412
LXXVIII
413
LXXIX
421
LXXX
430
LXXXI
435
LXXXII
441
LXXXIII
443
LXXXIV
445
LXXXV
446
LXXXVI
447
LXXXVIII
463
LXXXIX
469
XC
470
XCI
492
XCII
493
XCIII
495
XCIV
497
XCVI
503
XCIX
517
CI
522
CII
526
CIII
527
CIV
528
CV
529
CVI
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