Component Database Systems - 1st Edition - ISBN: 9781558606425, 9780080490724

Component Database Systems

1st Edition

Editors: Klaus Dittrich Andreas Geppert
eBook ISBN: 9780080490724
Hardcover ISBN: 9781558606425
Imprint: Morgan Kaufmann
Published Date: 16th October 2000
Page Count: 294
Tax/VAT will be calculated at check-out
File Compatibility per Device

PDF, EPUB, VSB (Vital Source):
PC, Apple Mac, iPhone, iPad, Android mobile devices.

Amazon Kindle eReader.

Institutional Access

Table of Contents

Chapter 1 - Component Database Systems: Introduction, Foundations and Overview

Klaus R. Dittrich, Andreas Geppert

1.1 Introduction

1.2 The need for componentization DBMSs

1.2.1 Handling nonstandard data types

1.2.2 Data integration

1.2.3 Downsized database systems

1.2.4 Discussion

1.3 Prerequisites and foundations of CDBMSs

1.3.1 DBMS architecture

1.3.2 Components and database management system architecture

1.4 Related work: the roots of CDBMSs

1.4.1 Kernel systems

1.4.2 Pure extensible database systems

1.4.3 Customizable systems

1.4.4 Toolkit systems

1.4.5 Transformational systems

1.4.6 Generators

1.4.7 Frameworks

1.4.8 Discussion

1.5 Component database models

1.5.1 Plug-in components

1.5.2 Database middleware

1.5.3 DBMS services

1.5.4 Configurable DBMS

1.5.5 Discussion

1.6 Summary and conclusion

Chapter 2 - Distributed Component Database Management Systems

Paul Brown

2.1 Introduction

2.1.1 Why distributed ORDBMSs

2.1.2 Description of the example application

2.1.3 Chapter over view

2.2 Single-site component DBMSs

2.2.1 ORDBMS abstract data model

2.2.2 Component standards and integration

2.2.3 Query-processing overview

2.2.4 ORDBMS query optimization

2.2.5 Internal architecture of ORDBMS

2.2.6 Function manager

2.3 Distributed component DBMSs

2.3.1 Overview of query processing in distributed ORDBMS

2.3.2 Distributed extensions to SQL

2.3.3 Query processing in distributed ORDBMS

2.3.4 External storage interfaces

2.3.5 Distributed processing

2.3.6 Distributed data movement

2.4 Summary

Chapter 3 - All Your Data: The Oracle Extensibility Architecture

Sandeepan Banerjee, Vishu Krishnamurthy, Ravi Murthy

3.1 Overview

3.2 Extensible type system

3.2.1 Object types

3.2.2 Collection types

3.2.3 Relation types

3.2.4 Large objects

3.2.5 Opaque types

3.3 Server execution environments

3.3.1 Java

3.3.2 PL/SQL

3.3.3 C and C++

3.3.4 Safe execution

3.4 Extensible indexing and operators

3.4.1 Index-organized tables

3.4.2 Function-based indexing

3.4.3 User-defined operators

3.5 Defining a text-indexing scheme

3.5.1 Using the text-indexing scheme

3.6 Extensible optimizer

3.6.1 Statistics

3.6.2 Selectivity

3.6.3 Cost

3.7 User-defined aggregates

3.7.1 Using the user-defined aggregates

3.8 Abstract tables

3.8.1 Table functions

3.9 Cartridge basic services

3.9.1 Memory management

3.9.2 Parameter management

3.9.3 Internationalization

3.9.4 Error reporting

3.9.5 Context management

3.9.6 File I/O

3.10 Case studies

3.10.1 The Oracle8i interMedia text data cartridge

3.10.2 The Oracle8i spatial data cartridge

3.10.3 The Oracle8i visual information information retrieval data cartridge

3.11 Conclusion

Chapter 4 - Extensible Indexing Support in DB2 Universal Database

Stefan Deßloch, Weidong Chen, Jyh-Herng Chow, You-Chin (Gene) Fuh, Jean Grandbois, Michelle Jou, Nelson Mattos, Raiko Nitzsche, Brian Tran, Yun Wang

4.1 Introduction

4.2 Hard-wired indexing

4.3 High-level indexing of user-defined types

4.3.1 Indexing maintenance

4.3.2 User-defined predicates and search-key generation

4.3.3 Index exploitation

4.3.4 Implementation and predicate filtering

4.4 Applications

4.4.1 Indexing for geographical information systems applications

4.4.2 Indexing on XML documents

4.5 Loose integration of external search engines

4.5.1 DB2 text extender overview

4.5.2 Exploiting high-level user-defined indexing

4.5.3 Generalization for arbitrary predicates

4.6 Performance

4.7 Related work and conclusion

Chapter 5 - Enabling Component Databases with OLE DB

Jose A. Blakeley and Michael J. Pizzo

5.1 Introduction

5.2 Universal data access

5.3 OLE DB: a component data model

5.3.1 The Microsoft Component Object model

5.3.2 Introspection via properties

5.3.3 Common abstractions

5.3.4 Common Extensions

5.4 Services

5.4.1 Adding generic connection facilities through Data Link

5.4.2 Adding common resource-pooling services

5.4.3 Providing a rich client-cursor service

5.5 Custom data providers

5.6 Component database scenarios

5.6.1 Database server

5.6.2 Distributed and heterogeneous query processing

5.6.3 Full-text queries on relational data

5.6.4 Distributed transformation services

5.6.5 Online analytical processing services

5.7 Microsoft data access software developer's kit

5.7.1 Documentation

5.7.2 ActiveX Data Objects (ADO)

5.7.3 OLE DB data providers

5.7.4 Simple provider toolkit

5.7.5 Test tools

5.7.6 Samples

5.8 Summary

Chapter 6 - An Architecture for Transparent Access to Diverse Data Sources

Mary Tork Roth, Peter Schwarz, and Laura Haas

6.1 Introduction

6.2 System Overview

6.3 Goals for the wrapper component architecture

6.4 Building a wrapper

6.4.1 Modeling data as objects

6.4.2 Method invocation

6.4.3 Query planning

6.4.4 Query execution

6.4.5 Wrapper packaging

6.5 Wrapper implementations

6.6 Related works

6.7 Conclusion

Chapter 7 Building Component Database Systems Using CORBA

M. Tamer Ozsu and Bin Yao

7.1 Introduction

7.2 Object management architecture

7.3 Common Object Request Broker Architecture

7.3.1 Interface definition language

7.3.2 Client-CORBA object communication

7.3.3 Object adapters

7.3.4 ORB interoperability

7.4 Common object services

7.4.1 Naming service

7.4.2 Event service

7.4.3 Life-cycle service

7.4.4 Persistent object service

7.4.5 Transaction service

7.4.6 Concurrency control service

7.4.7 Query service

7.4.8 Collections service

7.4.9 Other object services

7.5 Common facilities

7.6 Building componentized applications

7.7 CORBA and database interoperability

7.7.1 Object granularity

7.7.2 Object interfaces

7.7.3 Association mode

7.7.4 Call mode

7.7.5 Concurrently active objects

7.8 Conclusion

Chapter 8 - The Architecture of a Database System for Mobile and Embedded Devices

Heiko Bobzin

8.1 Introduction

8.2 The idea of a pure java database management system

8.3 User API and object model

8.3.1 Implementation

8.3.2 Database

8.3.3 Transaction

8.3.4 Collections

8.4 Object management

8.5 Transaction management

8.6 Concurrency control

8.7 Backend

8.8 Distributed applications

8.9 Event management

8.10 Log service

8.11 Postprocessing

8.12 On-demand assembly of components

8.13 Outlook

Chapter 9 - Conclusions and Perspectives

Andreas Geppert and Klaus R. Dittrich

9.1 Achievements

9.2 Open issues

9.2.1 Adequate support for components

9.2.2 Application development using CDBMSs

9.2.3 Performance issues

9.2.4 Development of CDBMS components

9.3 The End (is not yet near)



About the Authors


Component Database Systems is a collection of invited chapters by the researchers making the most influential contributions in the database industry's trend toward componentization

This book represents the sometimes-divergent, sometimes-convergent approaches taken by leading database vendors as they seek to establish commercially viable componentization strategies. Together, these contributions form the first book devoted entirely to the technical and architectural design of component-based database systems. In addition to detailing the current state of their research, the authors also take up many of the issues affecting the likely future directions of component databases.

If you have a stake in the evolution of any of today's leading database systems, this book will make fascinating reading. It will also help prepare you for the technology that is likely to become widely available over the next several years.

Key Features

  • Is comprised of contributions from the field's most highly respected researchers, including key figures at IBM, Oracle, Informix, Microsoft, and POET.
  • Represents the entire spectrum of approaches taken by leading software companies working on DBMS componentization strategies.
  • Covers component-focused architectures, methods for hooking components into an overall system, and support for component development.
  • Examines the component technologies that are most valuable to Web-based and multimedia databases.
  • Presents a thorough classification and overview of component database systems.


Database administrators and developers


No. of pages:
© Morgan Kaufmann 2001
Morgan Kaufmann
eBook ISBN:
Hardcover ISBN:


@qu:"We have in hand a wonderful book to show us how far database technology has been able to move in the direction of component databases, and what enormous challenges and ensuing rewards still lie ahead." @source:—Peter C. Lockemann, Universität Karlsruhe

About the Editors

Klaus Dittrich Editor

Klaus R. Dittrich is a professor in the Department of Information Technology at the University of Zurich, where he heads the Database Technology Research Group. he is the current secretary of the VLDB Endowment Board and has been a member of the ACM SIGMOD Advisory Committee. Professor Dittrich has been nominated as a Distinguished Speaker under the IEEE Computer Society Distinguished Visitors. He has over 100 scientific publications in the area of database technology and, in particular, has followed and influenced the development of object database technology from its inception.

Andreas Geppert Editor

Andreas Geppert is a senior researcher in the Database Technology Research Group at the University of Zurich. He has been working on object-oriented and active database systems and DMBS architecture and related topics for many years and has numerous publications in these areas.