Advanced SQL:1999 (eBook)

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