Object-relational DBMSs

Chapter 1 The DBMS Matrix 1.1 A DBMS Classification Matrix 1.2 Quadrant 1: Simple Data without Queries 1.3 Quadrant 2: Simple Data with Queries 1.4 Quadrant 3: Complex Data without Queries 1.5 Quadrant 4: Complex Data with Queries 1.6 Universal Applications 1.7 Technological Drivers in the DBMS Market 1.8 Summary Chapter 2 Characteristic 1: Base Data Type Extension 2.1 Need for Base Type Extension 2.2 A Better Way: Extensible Data Types 2.3 User-Defined Functions and Operators 2.4 Fully Object-Relational Type Extension 2.5 Summary Chapter 3 Examples of Base Type Extension 3.1 Geographic Information Systems Applications 3.2 Image Type Library Applications 3.3 The Quantity Data Type Chapter 4 Characteristic 2: Complex Objects 4.1 Type Constructors 4.2 Using Type Constructors 4.3 Collections and Client-Server Communication 4.4 Base Types and Complex Objects 4.5 Summary Chapter 5 Other Type Constructors? 5.1 A Time Series Example 5.2 An Array Example 5.3 Summary 86 Chapter 6 Characteristic 3: Inheritance? 6.1 Data Inheritance 6.2 Inheritance of Functions 6.3 Summary Chapter 7 Characteristic 4: Rules 7.1 Update-Update Rules 7.2 Query-Update Rules 7.3 Update-Query Rules 7.4 Query-Query Rules 7.5 Semantics: The Dark Side of Rules 7.6 Summary Chapter 8 Object-Relational Parsing 8.1 How an Object-Relational Parser Works 8.2 Summary Chapter 9 Traditional Relational Optimizers 9.1 How Relational Optimizers Work 9.2 Performing the Restriction on the Table 9.3 Methods for Processing the Join Chapter 10 Object-Relational Optimizers 10.1 Extension 1: Operator and Function Notation 10.2 Extensions 2 and 3: B-Trees and User-Defined Comparison Operators 10.3 Extension 4: User-Defined Selectivity Functions 10.4 Extension 5: User-Defined Negators 10.5 Extension 6: User-Defined Commutators 10.6 Extension 7: Access Methods on a Function of the Data 10.7 Extension 8: Smart Ordering of the Clauses in a Predicate 10.8 Extension 9: Optimization of Expensive Functions 10.9 Extension 10: User-Defined Access Methods 10.10 Extension 11: "Flattening" Complex Object Queries 10.11 Extension 12: "In-Line" Sets 10.12 Extension 13: Indexes on Attributes of Sets 10.13 Extension 14: Optimization of Scans of Inheritance Hierarchies 10.14 Extension 15: Optimization of Join over Inheritance Hierarchies 10.15 Extension 16: Support for User-Defined Aggregates 10.16 Summary Chapter 11 Implementation of Rule Systems 11.1 Support for Triggers 11.2 Extension to More General Rules 11.3 Scalability 11.4 Summary Chapter 12 Architectural Options for Commercial Vendors 12.1 Strategy 1: Do Nothing 12.2 Strategy 2: Rewrite a Relational Engine from Scratch 12.3 Strategy 3: Sell Two Systems 12.4 Strategy 4: An Object-Relational Top on a Relational Storage Manager 12.5 Strategy 5: Incremental Evolution 12.6 Strategy 6: Write a Wrapper 170 12.7 Strategy 7: Write a Gateway 175 12.8 Strategy 8: Extend an Object-Oriented DBMS 181 12.9 Strategy 9: Glue an Object-Relational Engine onto a Persistent Language 12.10 Summary Chapter 13 More on Object-Relational Architecture 13.1 Calling Extensions 185 13.2 Middleware 193 13.3 Summary 200 Chapter 14 Extension Performance: Implementation Makes a Difference 14.1 Examples 14.2 An SQL-92 Solution 14.3 The Informix 2-D Spatial DataBlade Approach 14.4 A Z Transform Solution 14.5 A Final Spatial Extension 14.6 A Comparison of the Alternatives 14.7 Summary Chapter 15 Object-Relational DBMS and Application Servers 15.1 Implications of a Thick Database on Traditional Application Servers 15.2 Two-Tier Thick Database Model 15.3 Three-Tier Thick Database Model 15.4 Summary Chapter 16 Multiquadrant Problems 16.1 A Video Service Application 16.2 An Insurance Application 16.3 Summary Chapter 17 Solutions to Multiquadrant Problems 17.1 Supporting File System Aspects of an Application 17.2 Supporting Lower-Right Quadrant Applications 17.3 Summary Chapter 18 Database Design for Object-Relational DBMSs 18.1 Relational Database Design 18.2 Reasons for Problems 18.3 Challenges in Object-Relational Database Design 18.4 Summary Chapter 19 The Next Great Wave in DBMS Technology 19.1 Overview of the Book 19.2 Overview of the Object-Relational Marketplace 19.3 Integration of Object-Relational Features with Database Services 19.4 A Brief Historical Perspective 19.5 Summary References Index