Component Database Systems

Component Database Systems

1st Edition - October 16, 2000

Write a review

  • Editors: Klaus Dittrich, Andreas Geppert
  • Hardcover ISBN: 9781558606425
  • eBook ISBN: 9780080490724

Purchase options

Purchase options
DRM-free (PDF)
Sales tax will be calculated at check-out

Institutional Subscription

Free Global Shipping
No minimum order


Component Database Systems is a collection of invited chapters by the researchers making the most influential contributions in the database industry's trend toward componentizationThis 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

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

Product details

  • No. of pages: 294
  • Language: English
  • Copyright: © Morgan Kaufmann 2000
  • Published: October 16, 2000
  • Imprint: Morgan Kaufmann
  • Hardcover ISBN: 9781558606425
  • eBook ISBN: 9780080490724

About the Editors

Klaus Dittrich

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

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.

Ratings and Reviews

Write a review

There are currently no reviews for "Component Database Systems"