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.
- 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.
Table of contents
- Front Cover
- Advanced SQL: 1999 Understanding Object-Relational and Other Advanced Features
- Copyright Page
- Foreword
- Contents (1/2)
- Contents (2/2)
- Preface (1/2)
- Preface (2/2)
- Chapter 1. Introduction to SQL:1999
-
Chapter 2. User-Defined Types
- 2.1 Introduction
- 2.2 What Are UDTs?
- 2.3 Using Objects: GUIs, Languages, and Major Applications
- 2.4 Three Kinds of UDTs
- 2.5 Major Characteristics of Structured UDTs
- 2.6 Attributes in Detail (1/2)
- 2.6 Attributes in Detail (2/2)
- 2.7 Behavior and Methods (1/3)
- 2.7 Behavior and Methods (2/3)
- 2.7 Behavior and Methods (3/3)
- 2.8 Defining Structured User-Defined Types (1/2)
- 2.8 Defining Structured User-Defined Types (2/2)
- 2.9 Inheritance (1/2)
- 2.9 Inheritance (2/2)
- 2.10 Creating Instances of Structured Types (1/2)
- 2.10 Creating Instances of Structured Types (2/2)
- 2.11 Using Structured Types (1/5)
- 2.11 Using Structured Types (2/5)
- 2.11 Using Structured Types (3/5)
- 2.11 Using Structured Types (4/5)
- 2.11 Using Structured Types (5/5)
- 2.12 Security for User-Defined Types
- 2.13 More Than One Way to Model Your Application
- 2.14 Implementation Issues
- 2.15 The SQL Object Model (1/2)
- 2.15 The SQL Object Model (2/2)
- 2.16 Chapter Summary
-
Chapter 3. Typed Tables
- 3.1 Introduction
- 3.2 Typed Tables and Structured Types
- 3.3 Self-Referencing Columns
- 3.4 Table Hierarchies (1/2)
- 3.4 Table Hierarchies (2/2)
- 3.5 Defining Typed Tables
- 3.6 Reference Values and REF Types (1/2)
- 3.6 Reference Values and REF Types (2/2)
- 3.7 Retrieving from Typed Tables
- 3.8 Inserting, Modifying, and Deleting in Typed Tables
- 3.9 Typed Views
- 3.10 Typed Tables and Privileges
- 3.11 Chapter Summary
-
Chapter 4. Routines and Routine Invocation
- 4.1 Introduction
- 4.2 SQL-Invoked Routines
- 4.3 External Routines and SQL Routines
- 4.4 SQL-Paths
- 4.5 Procedures, Functions, and Methods (1/6)
- 4.5 Procedures, Functions, and Methods (2/6)
- 4.5 Procedures, Functions, and Methods (3/6)
- 4.5 Procedures, Functions, and Methods (4/6)
- 4.5 Procedures, Functions, and Methods (5/6)
- 4.5 Procedures, Functions, and Methods (6/6)
- 4.6 Routine Invocation—in Brief (1/4)
- 4.6 Routine Invocation—in Brief (2/4)
- 4.6 Routine Invocation—in Brief (3/4)
- 4.6 Routine Invocation—in Brief (4/4)
- 4.7 Polymorphism (1/3)
- 4.7 Polymorphism (2/3)
- 4.7 Polymorphism (3/3)
- 4.8 Routine Invocation—The Details (1/3)
- 4.8 Routine Invocation—The Details (2/3)
- 4.8 Routine Invocation—The Details (3/3)
- 4.9 Security and Rights in Routine Invocation
- 4.10 Chapter Summary
-
Chapter 5. Foreign Servers and Foreign-Data Wrappers
- 5.1 Introduction
- 5.2 Overview of Distributed Databases
- 5.3 Foreign Tables, Foreign Servers, and Foreign-Data Wrappers
- 5.4 Metadata Associated with Management of External Data (1/4)
- 5.4 Metadata Associated with Management of External Data (2/4)
- 5.4 Metadata Associated with Management of External Data (3/4)
- 5.4 Metadata Associated with Management of External Data (4/4)
- 5.5 The SQL/MED API (1/2)
- 5.5 The SQL/MED API (2/2)
- 5.6 Processing Queries (1/2)
- 5.6 Processing Queries (2/2)
- 5.7 An Example
- 5.8 Chapter Summary
- Chapter 6. Datalinks
-
Chapter 7. OLAP
- 7.1 Introduction
- 7.2 Facilities for Data Analysis without OLAP (1/2)
- 7.2 Facilities for Data Analysis without OLAP (2/2)
- 7.3 What More Do We Need?
- 7.4 SQL Does Windows (1/5)
- 7.4 SQL Does Windows (2/5)
- 7.4 SQL Does Windows (3/5)
- 7.4 SQL Does Windows (4/5)
- 7.4 SQL Does Windows (5/5)
- 7.5 Coordinated Nondeterminism
- 7.6 Query Functions (1/4)
- 7.6 Query Functions (2/4)
- 7.6 Query Functions (3/4)
- 7.6 Query Functions (4/4)
- 7.7 Chapter Summary
- Chapter 8. SQL/OLB and SQL/JRT
-
Chapter 9. SQL/XML
- 9.1 Introduction
- 9.2 The SQLX Group
- 9.3 Brief Overview of XML
- 9.4 Mapping SQL and XML Concepts (1/3)
- 9.4 Mapping SQL and XML Concepts (2/3)
- 9.4 Mapping SQL and XML Concepts (3/3)
- 9.5 Publishing SQL Data Using XML (1/3)
- 9.5 Publishing SQL Data Using XML (2/3)
- 9.5 Publishing SQL Data Using XML (3/3)
- 9.6 Chapter Summary
- Chapter 10. SQL Multimedia and Application Packages
- Chapter 11. A Look to the Future
- Appendix A. An SQL:1999 Example Using UDTs
-
Appendix B. The SQL: 1999 Annexes
- B.1 Introduction
- B.2 Implementation-Defined and Implementation-Dependent (1/5)
- B.2 Implementation-Defined and Implementation-Dependent (2/5)
- B.2 Implementation-Defined and Implementation-Dependent (3/5)
- B.2 Implementation-Defined and Implementation-Dependent (4/5)
- B.2 Implementation-Defined and Implementation-Dependent (5/5)
- B.3 SQL:1999 Conformance Claims
- B.4 Appendix Summary
- Appendix C. Relevant Standards Bodies
- Appendix D. Status Codes
- Appendix E. The SQL Standardization Process
- Index (1/7)
- Index (2/7)
- Index (3/7)
- Index (4/7)
- Index (5/7)
- Index (6/7)
- Index (7/7)
- About the Author
Product information
- Title: Advanced SQL:1999
- Author(s):
- Release date: September 2002
- Publisher(s): Morgan Kaufmann
- ISBN: 9780080498843
You might also like
book
A Developer’s Guide to SQL Server 2005
"I come from a T-SQL background, so when I first laid my eyes on SQL Server …
book
How to Use Objects: Code and Concepts
While most developers today use object-oriented languages, the full power of objects is available only to …
book
Integrating the IBM MQ Appliance into your IBM MQ Infrastructure
This IBM® Redbooks® publication describes the IBM MQ Appliance M2000, an application connectivity option that combines …
book
Querying XML
XML has become the lingua franca for representing business data, for exchanging information between business partners …