| Preface | p. ix |
| Acknowledgments | p. xiii |
| Introduction | p. 1 |
| Database Systems and Language Evolution | p. 7 |
| What Is a Database? | p. 9 |
| What Is a Database Management System? | p. 13 |
| Database Data Structuring Models | p. 17 |
| Relational Database Support | p. 19 |
| Object Database Support | p. 24 |
| Object-Relational Database Support | p. 27 |
| Database SQL Standards | p. 28 |
| SQL Database Language Development History | p. 29 |
| Object-Relational Language Support | p. 30 |
| Summary | p. 37 |
| SQL-92 Overview | p. 39 |
| The Foundation of the Language: | |
| Concepts and Features | p. 40 |
| How ANSI SQL Database Language Conformance Is Defined | p. 41 |
| SQL-92 Entry-Level Features | p. 42 |
| SQL-92 Intermediate-Level Features | p. 48 |
| SQL-92 Full-Level Features | p. 50 |
| SQL-92 Basic Operators and Features | p. 50 |
| Summary | p. 65 |
| SQL-3 Overview | p. 67 |
| SQL-3 Introduction | p. 68 |
| SQL Framework | p. 70 |
| SQL Foundation | p. 70 |
| SQL Call-Level Interface | p. 79 |
| SQL Persistent Stored Modules | p. 80 |
| PSM SQL 3 Flow of Control Structures | p. 84 |
| SQL Bindings | p. 87 |
| SQL Transactions | p. 87 |
| SQL Temporal | p. 89 |
| SQL Object | p. 90 |
| Proposed SQL-3 Extensions | p. 91 |
| Summary | p. 93 |
| SQL-3 Model and Language Basics | p. 95 |
| Introduction to the Object-Relational SQL-3 Data Model | p. 96 |
| Basic Database Structures | p. 97 |
| Basic Data Types | p. 119 |
| Type System Extensions | p. 131 |
| Subtables and Supertables | p. 141 |
| Summary | p. 143 |
| Abstract Data Types | p. 145 |
| Introduction | p. 146 |
| Abstract Data Type | p. 146 |
| Abstract Data Type Attributes | p. 149 |
| Abstract Data Type Creation and Initialization | p. 151 |
| Accessing Attributes of an ADT | p. 156 |
| Abstract Data Type Interface | p. 158 |
| Summary | p. 161 |
| Using Abstract Data Types | p. 163 |
| Abstract Data Type Use in Expanded Type Definitions | p. 164 |
| Abstract Data Type Manipulations | p. 172 |
| Abstract Data Type Privileges | p. 190 |
| Summary | p. 194 |
| SQL-3 Specialized ADT Concepts | p. 195 |
| Subtyping and Inheritance | p. 196 |
| Abstract Data Type Functions | p. 210 |
| Abstract Data Type Comparison | p. 230 |
| Summary | p. 231 |
| Database Persistence | p. 233 |
| Concept of Persistence | p. 234 |
| Persistence for Tables in SQL-3 | p. 235 |
| Summary | p. 246 |
| Collection Types | p. 247 |
| Introduction | p. 248 |
| Collections of ADTs | p. 248 |
| Row Type | p. 252 |
| Set Type | p. 256 |
| List Type | p. 258 |
| Multiset Type | p. 259 |
| Collection Type Constructors | p. 259 |
| Collection Type Manipulation | p. 261 |
| Summary | p. 272 |
| Triggers | p. 273 |
| Introduction | p. 274 |
| Trigger Definition | p. 275 |
| Trigger Operation | p. 284 |
| Triggered SQL Statement | p. 293 |
| Summary | p. 300 |
| SQL Persistent Stored Modules | p. 301 |
| SQL Architecture | p. 303 |
| SQL Routines | p. 313 |
| SQL Procedure Language Elements | p. 318 |
| Error Handling | p. 334 |
| SIGNAL Statements | p. 335 |
| Summary | p. 339 |
| Miscellaneous Additional SQL-3 Features | p. 341 |
| Overview of Additional Features | p. 342 |
| Table Expressions | p. 342 |
| Common Table Expressions | p. 344 |
| Recursive SQL | p. 345 |
| Extensions to Order By | p. 354 |
| Roles | p. 356 |
| Savepoints | p. 363 |
| Additional Predicates | p. 368 |
| Extensions to Cursors | p. 370 |
| Extensions to Referential Integrity | p. 371 |
| Extensions to Transactions | p. 373 |
| Summary | p. 376 |
| Early SQL-3 Release Vendor Product Reviews | p. 377 |
| Introduction | p. 378 |
| Oracle Support for Complex and User-Defined Data Types | p. 379 |
| Informix Universal Server Support | p. 382 |
| IBM DB2 Universal Database Support | p. 386 |
| Product Support for Large Object Data Types | p. 388 |
| Support for Boolean Data Type | p. 397 |
| Summary | p. 398 |
| Bibliography | p. 399 |
| Index | p. 405 |
| Table of Contents provided by Syndetics. All Rights Reserved. |