Object-Relational DBMSs
- 2nd Edition - December 20, 1998
- Latest edition
- Authors: Michael Stonebraker, Paul Brown, Dorothy Moore
- Language: English
Discover why object-relational technology is ideal for supporting a broad spectrum of data types and application areas, from financial services to multimedia data. In this comp… Read more
Purchase options
Discover why object-relational technology is ideal for supporting a broad spectrum of data types and application areas, from financial services to multimedia data. In this completely revised and updated edition, database experts Michael Stonebraker and Paul Brown explore the object-relational paradigm and examine the most recent developments in the field.
Specifically written for database application programmers, database analysts, and IT managers, this book includes detailed information on how to classify DBMS applications, where object-relational DBMSs fit in the database world, and what mechanisms are required to support such an engine.
* Presents a simple matrix for classifying and evaluating DBMSs so that you can make informed judgments about object-relational systems.
* Includes examples, tables, and tests to help you judge the quality and optimization of systems now on the market.
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
- Edition: 2
- Latest edition
- Published: December 20, 1998
- Language: English
MS
Michael Stonebraker
PB
Paul Brown
Paul Brown is “Chief Plumber” within the Chief Technology Office of Informix Software, where he works with Informix’s customers and partners in developing and deploying information systems based on object-relational DBMS technology. Previously he worked on the POSTGRES and SEQUOIA 2000 projects at the University of California, Berkeley.
DM
Dorothy Moore
Dorothy Moore is a senior engineering-marketing writer at Illustra Information Technologies, Inc. Her extensive technical writing experience includes the development of user guides, training manuals, and documentation for Novell, Inc. and the RAND corporation.