Skip to main content
Elsevier
View Cart

Object-Relational DBMSs

  • 2nd Edition - August 1, 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

Sorry, this title is not available for purchase in your country/region.

World Book Day celebration

Where learning shapes lives

Up to 25% off trusted resources that support research, study, and discovery.

Explore resources

Description

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.

Key features

* Offers completely updated and expanded information—new and revised material discusses both the latest technology and the latest products.
* 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.

Readership

Database analyst and IT Managers

Table of contents

Object-Relational DBMSs, 2nd Edition, by Michael Stonebraker and Paul Brown, with Dorothy Moore

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

Product details

  • Edition: 2
  • Latest edition
  • Published: December 20, 1998
  • Language: English

About the authors

MS

Michael Stonebraker

Michael Stonebraker is a professor emeritus of computer science at the University of California at Berkeley. He is a founder of Ingres Corp. (now a division of Computer Associates), the founder of Illustra Information Technologies, Inc., a past chairman of the ACM Special Interest Group on Management of Data, and the author of many papers and books on DBMS technology. A well-known lecturer and keynote speaker, Dr. Stonebraker was the recipient of the first ACM SIGMOD innovations award in 1992.

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.