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

From the Publisher: 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. About the Author: Jim Melton is editor of all parts of ISO/IEC 9075 (SQL) and representative for database standards at Oracle Corporation. Since 1986, he has been his company's representative tothe ANSI NCITS Technical Committee H2 for Database and a U.S. representative to ISO/IEC JTCI/SC32/WG3. He was the editor of SQL-92 and the recently published SQL:1999 suite of standards and is increasingly involved in standards related to querying XML and integrating SQL and XML. He is also the editor of the next generation of the SQL standards, currently under development, as well as an editor for the Functions and Operators specification currently being developed by the W3C XML Query Working Group. He is the author of several SQL books.