Object-Relational Dbmss,9781558604520

Object-Relational Dbmss

by ; ;
Edition: 2nd
ISBN13: 9781558604520
ISBN10: 1558604529
Format: Paperback
Pub. Date: 1998-09-01
Publisher(s): Morgan Kaufmann Pub
List Price: $49.95

Rent Book

Select for Price
Add to Cart
There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Buy from our Marketplace starting at $12.89

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

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. * Offers completely updated and expanded informationnew 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.

Table of Contents

Preface xi
CHAPTER 1 The DBMS Matrix
1(26)
1.1 A DBMS Classification Matrix
1(1)
1.2 Quadrant 1: Simple Data without Queries
2(1)
1.3 Quadrant 2: Simple Data with Queries
3(5)
1.4 Quadrant 3: Complex Data without Queries
8(7)
1.5 Quadrant 4: Complex Data with Queries
15(5)
1.6 Universal Applications
20(4)
1.7 Technological Drivers in the DBMS Market
24(2)
1.8 Summary
26(1)
CHAPTER 2 Characteristic 1: Base Data Type Extension
27(28)
2.1 Need for Base Type Extension
27(6)
2.2 A Better Way: Extensible Data Types
33(3)
2.3 User-Defined Functions and Operators
36(5)
2.4 Fully Object-Relational Type Extension
41(12)
2.5 Summary
53(2)
CHAPTER 3 Examples of Base Type Extension
55(6)
3.1 Geographic Information Systems Applications
55(3)
3.2 Image Type Library Applications
58(1)
3.3 The Quantity Data Type
59(2)
CHAPTER 4 Characteristic 2: Complex Objects
61(18)
4.1 Type Constructors
61(2)
4.2 Using Type Constructors
63(10)
4.3 Collections and Client-Server Communication
73(1)
4.4 Base Types and Complex Objects
73(3)
4.5 Summary
76(3)
CHAPTER 5 Other Type Constructors?
79(8)
5.1 A Time Series Example
79(2)
5.2 An Array Example
81(5)
5.3 Summary
86(1)
CHAPTER 6 Characteristic 3: Inheritance
87(14)
6.1 Data Inheritance
87(6)
6.2 Inheritance of Functions
93(5)
6.3 Summary
98(3)
CHAPTER 7 Characteristic 4: Rules
101(12)
7.1 Update-Update Rules
102(1)
7.2 Query-Update Rules
103(1)
7.3 Update-Query Rules
104(1)
7.4 Query-Query Rules
105(2)
7.5 Semantics: The Dark Side of Rules
107(4)
7.6 Summary
111(2)
CHAPTER 8 Object-Relational Parsing
113(4)
8.1 How an Object-Relational Parser Works
113(3)
8.2 Summary
116(1)
CHAPTER 9 Traditional Relational Optimizers
117(14)
9.1 How Relational Optimizers Work
117(2)
9.2 Performing the Restriction on the Table emp_R
119(5)
9.3 Methods for Processing the Join
124(7)
CHAPTER 10 Object-Relational Optimizers
131(20)
10.1 Extension 1: Operator and Function Notation
132(1)
10.2 Extensions 2 and 3: B-Trees and User-Defined Comparison Operators
133(2)
10.3 Extension 4: User-Defined Selectivity Functions
135(1)
10.4 Extension 5: User-Defined Negators
136(1)
10.5 Extension 6: User-Defined Commutators
136(1)
10.6 Extension 7: Access Methods on a Function of the Data
137(1)
10.7 Extension 8: Smart Ordering of the Clauses in a Predicate
138(2)
10.8 Extension 9: Optimization of Expensive Functions
140(2)
10.9 Extension 10: User-Defined Access Methods
142(2)
10.10 Extension 11: "Flattening" Complex Object Queries
144(1)
10.11 Extension 12: "In-Line" Sets
145(1)
10.12 Extension 13: Indexes on Attributes of Sets
146(1)
10.13 Extension 14: Optimization of Scans of Inheritance Hierarchies
147(1)
10.14 Extension 15: Optimization of Joins over Inheritance Hierarchies
147(1)
10.15 Extension 16: Support for User-Defined Aggregates
148(1)
10.16 Summary
149(2)
CHAPTER 11 Implementation of Rule Systems
151(12)
11.1 Support for Triggers
151(5)
11.2 Extension to More General Rules
156(1)
11.3 Scalability
157(4)
11.4 Summary
161(2)
CHAPTER 12 Architectural Options for Commercial Vendors
163(22)
12.1 Strategy 1: Do Nothing
164(1)
12.2 Strategy 2: Rewrite a Relational Engine from Scratch
165(1)
12.3 Strategy 3: Sell Two Systems
166(1)
12.4 Strategy 4: An Object-Relational Top on a Relational Storage Manager
167(2)
12.5 Strategy 5: Incremental Evolution
169(1)
12.6 Strategy 6: Write a Wrapper
170(5)
12.7 Strategy 7: Write a Gateway
175(6)
12.8 Strategy 8: Extend an Object-Oriented DBMS
181(1)
12.9 Strategy 9: Glue an Object-Relational Engine onto a Persistent Language
182(1)
12.10 Summary
183(2)
CHAPTER 13 More on Object-Relational Architecture
185(16)
13.1 Calling Extensions
185(8)
13.2 Middleware
193(7)
13.3 Summary
200(1)
CHAPTER 14 Extension Performance: Implementation Makes a Difference
201(14)
14.1 Examples
202(2)
14.2 An SQL-92 Solution
204(2)
14.3 The Informix 2-D Spatial DataBlade Approach
206(1)
14.4 A Z Transform Solution
207(2)
14.5 A Final Spatial Extension
209(3)
14.6 A Comparison of the Alternatives
212(1)
14.7 Summary
213(2)
CHAPTER 15 Object-Relational DBMS and Application Servers
215(16)
15.1 Implications of a Thick Database on Traditional Application Servers
219(4)
15.2 Two-Tier Thick Database Model
223(2)
15.3 Three-Tier Thick Database Model
225(4)
15.4 Summary
229(2)
CHAPTER 16 Multiquadrant Problems
231(12)
16.1 A Video Service Application
232(5)
16.2 An Insurance Application
237(3)
16.3 Summary
240(3)
CHAPTER 17 Solutions to Multiquadrant Problems
243(10)
17.1 Supporting File System Aspects of an Application
243(4)
17.2 Supporting Lower-Right Quadrant Applications
247(5)
17.3 Summary
252(1)
CHAPTER 18 Database Design for Object-Relational DBMSs
253(14)
18.1 Relational Database Design
253(4)
18.2 Reasons for Problems
257(5)
18.3 Challenges in Object-Relational Database Design
262(2)
18.4 Summary
264(3)
CHAPTER 19 The Next Great Wave in DBMS Technology
267(12)
19.1 Overview of the Book
267(3)
19.2 Overview of the Object-Relational Marketplace
270(5)
19.3 Integration of Object-Relational Features with Database Services
275(1)
19.4 A Brief Historical Perspective
276(1)
19.5 Summary
277(2)
References 279(4)
Index 283

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.