Component Database Systems
- 1st Edition - October 16, 2000
- Imprint: Morgan Kaufmann
- Editors: Klaus R. Dittrich, Andreas Geppert
- Language: English
- Hardback ISBN:9 7 8 - 1 - 5 5 8 6 0 - 6 4 2 - 5
- eBook ISBN:9 7 8 - 0 - 0 8 - 0 4 9 0 7 2 - 4
Component Database Systems is a collection of invited chapters by the researchers making the most influential contributions in the database industry's trend toward componenti… Read more
Purchase options
Institutional subscription on ScienceDirect
Request a sales quote
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.
* 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.
* 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.
Computing professionals including developers and IT managers with an interest in the near-future of database technology.
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)
Bibliography
Index
About the Authors
- Edition: 1
- Published: October 16, 2000
- No. of pages (Hardback): 294
- No. of pages (eBook): 294
- Imprint: Morgan Kaufmann
- Language: English
- Hardback ISBN: 9781558606425
- eBook ISBN: 9780080490724
KD
Klaus R. 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.
AG
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.
Read Component Database Systems on ScienceDirect