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

by Jim Melton

"Advanced - 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, " - 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 " 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 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 annexes, a example using UDTs, status codes, and useful information on the standardization process.

562 pages, ebook

First published September 9, 2002