Advanced SQL, 1999 : understanding object-relational and other advanced features / Jim Melton.

Format:

Book

Author/Creator:

Melton, Jim, 1946-

Series:

Morgan Kaufmann series in data management systems.

The Morgan Kaufmann series in data management systems

Language:

English

Subjects (All):

SQL (Computer program language).

Object-oriented programming (Computer science).

Relational databases.

Physical Description:

1 online resource (593 p.)

Edition:

1st edition

Other Title:

Understanding object-relational and other advanced features

Place of Publication:

Amsterdam ; Boston, Mass. : Morgan Kaufmann Pub., c2003.

Language Note:

English

System Details:

text file

Summary:

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 eas

Contents:

Front Cover; Advanced SQL: 1999 Understanding Object-Relational and Other Advanced Features; Copyright Page; Foreword; Contents; Preface; Chapter 1. Introduction to SQL:1999; 1.1 Introduction; 1.2 What Is SQL?; 1.3 The Structure and Goals of This Book; 1.4 The SQL Object Model; 1.5 Conforming to SQL:1999 Object Facilities; 1.6 Relationship to Products; 1.7 Chapter Summary; 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 Detail2.7 Behavior and Methods; 2.8 Defining Structured User-Defined Types; 2.9 Inheritance; 2.10 Creating Instances of Structured Types; 2.11 Using Structured Types; 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; 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; 3.5 Defining Typed Tables; 3.6 Reference Values and REF Types; 3.7 Retrieving from Typed Tables

3.8 Inserting, Modifying, and Deleting in Typed Tables3.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; 4.6 Routine Invocation-in Brief; 4.7 Polymorphism; 4.8 Routine Invocation-The Details; 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 Wrappers5.4 Metadata Associated with Management of External Data; 5.5 The SQL/MED API; 5.6 Processing Queries; 5.7 An Example; 5.8 Chapter Summary; Chapter 6. Datalinks; 6.1 Introduction; 6.2 Two Sides of a Coin; 6.3 Datalinkers and External Data Managers; 6.4 DATALINK Data Type; 6.5 The Future; 6.6 Chapter Summary; Chapter 7. OLAP; 7.1 Introduction; 7.2 Facilities for Data Analysis without OLAP; 7.3 What More Do We Need?; 7.4 SQL Does Windows; 7.5 Coordinated Nondeterminism; 7.6 Query Functions; 7.7 Chapter Summary

Chapter 8. SQL/OLB and SQL/JRT8.1 Introduction; 8.2 The SQLJ Group; 8.3 The Joys of Java; 8.4 Embedding SQL in Java; 8.5 Java Routines; 8.6 Java Types; 8.7 Chapter Summary; 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; 9.5 Publishing SQL Data Using XML; 9.6 Chapter Summary; Chapter 10. SQL Multimedia and Application Packages; 10.1 Introduction; 10.2 What Is SQL/MM?; 10.3 Framework; 10.4 Full-Text; 10.5 Spatial; 10.6 Still Image; 10.7 Data Mining; 10.8 Chapter Summary; Chapter 11. A Look to the Future; 11.1 Introduction

11.2 Additional Parts of SQL:1999

Notes:

Description based upon print version of record.

Includes bibliographical references and index.

ISBN:

9786611072889

9781281072887

1281072885

9780080498843

0080498841

OCLC:

476112743