Browse content
Table of contents
Actions for selected chapters
- Full text access
- Book chapterAbstract only
Chapter 1 - Introduction to SQL:1999
Pages 1-19 - Book chapterAbstract only
Chapter 2 - User-Defined Types
Pages 21-117 - Book chapterAbstract only
Chapter 3 - Typed Tables
Pages 119-151 - Book chapterAbstract only
Chapter 4 - Routines and Routine Invocation
Pages 153-233 - Book chapterAbstract only
Chapter 5 - Foreign Servers and Foreign-Data Wrappers
Pages 235-278 - Book chapterAbstract only
Chapter 6 - Datalinks
Pages 279-297 - Book chapterAbstract only
Chapter 7 - OLAP
Pages 299-349 - Book chapterAbstract only
Chapter 8 - SQL/OLB and SQL/JRT
Pages 351-374 - Book chapterAbstract only
Chapter 9 - SQL/XML
Pages 375-409 - Book chapterAbstract only
Chapter 10 - SQL Multimedia and Application Packages
Pages 411-443 - Book chapterAbstract only
Chapter 11 - A Look to the Future
Pages 445-448 - Book chapterNo access
Appendix A - An SQL:1999 Example Using UDTs
Pages 449-470 - Book chapterNo access
Appendix B - The SQL:1999 Annexes
Pages 471-495 - Book chapterNo access
Appendix C - Relevant Standards Bodies
Pages 497-504 - Book chapterNo access
Appendix D - Status Codes
Pages 505-517 - Book chapterNo access
Appendix E - The SQL Standardization Process
Pages 519-530 - Book chapterNo access
Index
Pages 531-561 - Book chapterNo access
About the Author
Page 563
About the book
Description
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.
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.
Key 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.
- 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.
Details
ISBN
978-1-55860-677-7
Language
English
Published
2003
Copyright
Copyright © 2003 Elsevier Inc. All rights reserved
Imprint
Morgan Kaufmann