Melton Advanced SQL:1999

Understanding Object-Relational and Other Advanced Features
1. Auflage 2002
ISBN: 978-0-08-049884-3
Verlag: Elsevier Science & Techn.
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 562 Seiten, Web PDF

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.

Autoren/Hrsg.

Melton, Jim

Inhaltsverzeichnis

1;Front Cover ;1
2;Advanced SQL: 1999 Understanding Object-Relational and Other Advanced Features;4
3;Copyright Page ;5
4;Contents ;10
5;Foreword;8
6;Preface;20
7;Chapter 1. Introduction to SQL:1999;30
7.1;1.1 Introduction;30
7.2;1.2 What Is SQL?;31
7.3;1.3 The Structure and Goals of This Book;34
7.4;1.4 The SQL Object Model;36
7.5;1.5 Conforming to SQL:1999 Object Facilities;45
7.6;1.6 Relationship to Products;47
7.7;1.7 Chapter Summary;48
8;Chapter 2. User-Defined Types;50
8.1;2.1 Introduction;50
8.2;2.2 What Are UDTs?;51
8.3;2.3 Using Objects: GUIs, Languages, and Major Applications;54
8.4;2.4 Three Kinds of UDTs;55
8.5;2.5 Major Characteristics of Structured UDTs;59
8.6;2.6 Attributes in Detail;64
8.7;2.7 Behavior and Methods;72
8.8;2.8 Defining Structured User-Defined Types;87
8.9;2.9 Inheritance;97
8.10;2.10 Creating Instances of Structured Types;107
8.11;2.11 Using Structured Types;113
8.12;2.12 Security for User-Defined Types;135
8.13;2.13 More Than One Way to Model Your Application;136
8.14;2.14 Implementation Issues;139
8.15;2.15 The SQL Object Model;140
8.16;2.16 Chapter Summary;146
9;Chapter 3. Typed Tables;148
9.1;3.1 Introduction;148
9.2;3.2 Typed Tables and Structured Types;148
9.3;3.3 Self-Referencing Columns;150
9.4;3.4 Table Hierarchies ;152
9.5;3.5 Defining Typed Tables;158
9.6;3.6 Reference Values and REF Types;163
9.7;3.7 Retrieving from Typed Tables;169
9.8;3.8 Inserting, Modifying, and Deleting in Typed Tables;174
9.9;3.9 Typed Views;177
9.10;3.10 Typed Tables and Privileges;179
9.11;3.11 Chapter Summary;180
10;Chapter 4. Routines and Routine Invocation;182
10.1;4.1 Introduction;182
10.2;4.2 SQL-Invoked Routines;183
10.3;4.3 External Routines and SQL Routines ;184
10.4;4.4 SQL-Paths;189
10.5;4.5 Procedures, Functions, and Methods;191
10.6;4.6 Routine Invocation—in Brief;220
10.7;4.7 Polymorphism;236
10.8;4.8 Routine Invocation—The Details;247
10.9;4.9 Security and Rights in Routine Invocation;260
10.10;4.10 Chapter Summary;262
11;Chapter 5. Foreign Servers and Foreign-Data Wrappers;264
11.1;5.1 Introduction;264
11.2;5.2 Overview of Distributed Databases;265
11.3;5.3 Foreign Tables, Foreign Servers, and Foreign-Data Wrappers;269
11.4;5.4 Metadata Associated with Management of External Data;273
11.5;5.5 The SQL/MED API ;291
11.6;5.6 Processing Queries;297
11.7;5.7 An Example;304
11.8;5.8 Chapter Summary;307
12;Chapter 6. Datalinks;308
12.1;6.1 Introduction;308
12.2;6.2 Two Sides of a Coin;308
12.3;6.3 Datalinkers and External Data Managers;309
12.4;6.4 DATALINK Data Type;315
12.5;6.5 The Future;325
12.6;6.6 Chapter Summary;326
13;Chapter 7. OLAP;328
13.1;7.1 Introduction;328
13.2;7.2 Facilities for Data Analysis without OLAP;329
13.3;7.3 What More Do We Need?;335
13.4;7.4 SQL Does Windows;336
13.5;7.5 Coordinated Nondeterminism;359
13.6;7.6 Query Functions;361
13.7;7.7 Chapter Summary;378
14;Chapter 8. SQL/OLB and SQL/JRT;380
14.1;8.1 Introduction;380
14.2;8.2 The SQLJ Group;381
14.3;8.3 The Joys of Java;382
14.4;8.4 Embedding SQL in Java;384
14.5;8.5 Java Routines;389
14.6;8.6 Java Types;398
14.7;8.7 Chapter Summary;403
15;Chapter 9. SQL/XML;404
15.1;9.1 Introduction;404
15.2;9.2 The SQLX Group;405
15.3;9.3 Brief Overview of XML;405
15.4;9.4 Mapping SQL and XML Concepts;411
15.5;9.5 Publishing SQL Data Using XML;426
15.6;9.6 Chapter Summary;438
16;Chapter 10. SQL Multimedia and Application Packages;440
16.1;10.1 Introduction;440
16.2;10.2 What Is SQL/MM?;440
16.3;10.3 Framework;443
16.4;10.4 Full-Text;444
16.5;10.5 Spatial;452
16.6;10.6 Still Image;461
16.7;10.7 Data Mining;466
16.8;10.8 Chapter Summary;472
17;Chapter 11. A Look to the Future;474
17.1;11.1 Introduction;474
17.2;11.2 Additional Parts of SQL:1999;475
17.3;11.3 SQL:2003 and Beyond;476
17.4;11.4 Chapter Summary;477
18;Appendix A. An SQL:1999 Example Using UDTs;478
18.1;A.1 Introduction;478
18.2;A.2 The Schema Definition;478
18.3;A.3 Application Code;494
19;Appendix B. The SQL: 1999 Annexes;500
19.1;B.1 Introduction;500
19.2;B.2 Implementation-Defined and Implementation-Dependent;501
19.3;B.3 SQL:1999 Conformance Claims;523
19.4;B.4 Appendix Summary;524
20;Appendix C. Relevant Standards Bodies;526
20.1;C.1 Introduction;526
20.2;C.2 Contacting ISO;528
20.3;C.3 Selected National Standards Bodies;528
21;Appendix D. Status Codes;534
21.1;D.1 Values of SQLSTATE;534
22;Appendix E. The SQL Standardization Process;548
22.1;E.1 Introduction;548
22.2;E.2 The Various Standards Bodies;548
22.3;E.3 History of the SQL Standard;553
22.4;E.4 NIST and the FIPS;557
22.5;E.5 Other SQL-Related Organizations;558
22.6;E.6 Appendix Summary;559
23;Index;560
24;About the Author;592