Advanced SQL, 1999: Understanding Object-relational and Other Advanced Features

Front Cover
Morgan Kaufmann, 2003 - Computers - 563 pages
1 Review


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.

* 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

We haven't found any reviews in the usual places.

Contents

III
1
V
2
VI
5
VII
7
VIII
16
IX
18
X
19
XI
21
LX
280
LXI
286
LXII
296
LXIV
297
LXV
299
LXVII
300
LXVIII
306
LXIX
307

XII
22
XIII
25
XIV
26
XV
30
XVI
35
XVII
43
XVIII
58
XIX
68
XX
78
XXI
84
XXII
106
XXIII
107
XXIV
110
XXV
111
XXVI
117
XXVII
119
XXIX
121
XXX
123
XXXI
129
XXXII
134
XXXIII
140
XXXIV
145
XXXV
148
XXXVI
150
XXXVII
151
XXXVIII
153
XL
154
XLI
155
XLII
160
XLIII
162
XLIV
191
XLV
207
XLVI
218
XLVII
231
XLVIII
233
XLIX
235
LI
236
LII
240
LIII
244
LIV
262
LV
268
LVI
275
LVII
278
LVIII
279
LXX
330
LXXI
332
LXXII
349
LXXIII
351
LXXV
352
LXXVI
353
LXXVII
355
LXXVIII
360
LXXIX
369
LXXX
374
LXXXI
375
LXXXIII
376
LXXXV
382
LXXXVI
397
LXXXVII
409
LXXXVIII
411
LXXXIX
414
XC
415
XCI
423
XCII
432
XCIII
437
XCIV
443
XCV
445
XCVII
446
XCVIII
447
XCIX
448
C
449
CI
465
CII
471
CIII
472
CIV
494
CV
495
CVI
497
CVII
499
CIX
505
CX
519
CXI
524
CXII
528
CXIII
529
CXIV
530
CXV
531
CXVI
563
Copyright

Common terms and phrases

References to this book

All Book Search results »

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