Strategic Database Technology: Management for the Year 2000 / Edition 1

Table of Contents

Preface
A Road Map of This Book
Acknowledgments
Part I Background and Introduction
1 Setting the Stage
1.1 Introduction
1.2 Terminology
1.3 Major Information Systems Trends
1.3.1 Distribution and Decentralization
1.3.2 Heterogeneity
1.3.3 Standards
1.3.4 Real-World Modeling
1.4 How IM Relates to Other IS Disciplines
1.5 Days of Future...in the Past
1.5.1 The Early Days: Pre-DBMS
1.5.2 Hierarchical and Network Databases
1.5.3 The Relational Model
1.5.4 Distribution and Extended Database Models
1.5.5 Object-Oriented Databases
1.5.6 Hypertext and Hypermedia
1.5.7 Database Languages
1.6 Into the 1990s
1.6.1 Third-Generation Data Base System manifesto
1.6.2 The Object-Oriented Database System Manifesto
1.6.3 The National Science Foundation Workshop
1.7 A Perspective on Future Directions
1.8 Conclusion
Outlook
Additional Reading
Endnotes

Part II Distributed Databases and Information Management
2 Principles of Distributed Information management
2.1 Introduction
2.2 Definition and Characteristics of Distributed Database Systems
2.3 Distributed Information Management: The Ultimate Scenario
2.4 Distributed Database Models
2.4.1 Homogeneous versus Heterogeneous Systems
2.4.2 Top-Down versus Bottom-Up Distributed Databases
2.5 Conclusion
Outlook
Additional Reading
Endnotes

3 Client/Server Databases and Middleware
3.1 Introduction
3.2 Client/Server Guidelines and Evaluation Criteria
3.3 Client/Server Information Management Standards
3.3.1 SQL Access Group and DRDA
3.3.2 SAG CLI-Based Standards
3.4 Middleware
3.5 Database Interoperability
3.6 Conclusion
Outlook
Additional Reading
Endnotes

4 Data Warehouses
4.1 Introduction
4.2 Principles of the Data Warehouse
4.3 Multiple Media
4.4 Data Summarization
4.5 Distributed Data Warehouses
4.6 Rewriting History
4.7 Data Warehouses and Other Information Management Technology
4.7.1 Client/Server Databases and Applications
4.7.2 Active Databases
4.7.3 Hypertext
4.7.4 Temporal Databases
4.8 Digital Libraries and Information Highways
4.9 Conclusion
Outlook
Additional Reading
Endnotes

5 Partitioning and Replication: The Next Generation
5.1 Introduction
5.2 MPP and Parallel Database System Concepts
5.3 Partitioning Models for Parallel Database Systems
5.4 Parallel Relational Operators and Index Structures
5.5 The Future Direction of Parallel Database Systems
5.6 Revisiting Replication
5.7 Conclusion
Outlook
Additional Reading
Endnotes

6 Heterogeneous Federated Databases and Multidatabase Systems
6.1 Introduction
6.2 Distributed Database Systems Revisited: A Taxonomy
6.3 A Conceptual Architecture of a Multidatabase System
6.4 Database Services
6.5 Conflict Resolution
6.6 Mediators
6.7 Cross-Database Integrity
6.8 The Role of Standards in Heterogeneous Information Management
6.9 Problems and Issues with Multidatabase Environments
6.10 Conclusion
Outlook
Additional Reading
Endnotes

7 Conclusions: Future Directions of Distributed Information Management
7.1 Introduction
7.2 Where are We today?
7.2.1 Multiple Models of Information Distribution
7.2.2 Parallel Database Machines
7.3 Problem Areas in Distributed Information Management
7.3.1 Semantic Inconsistency
7.3.2 Browsing
7.3.3 Security
7.3.4 Site Scale-Up
7.3.5 Transaction Processing
7.3.6 Distributed Design
7.3.7 Distributed Query processing
7.4 Promising Areas in Distributed Information Management
7.5 Conclusion
Outlook
Additional Reading
Endnotes

Part III Object-Oriented Databases
8 Principles of Object-Oriented Databases
8.1 Introduction
8.2 Rationale and Characteristics of Object-Oriented Databases
8.3 Concepts of Object-Oriented Databases
8.3.1 Object Identity
8.3.2 Attributes
8.3.3 Methods
8.3.4 Classes
8.3.5 Class Hierarchies and Inheritance
8.4 Persistence
8.5 Development Methodology and Programming Languages
8.6 Conclusion
Outlook
Additional Reading
Endnotes

9 Hybrid and Extended Relational Forms of Object Management
9.1 Introduction
9.2 Hybrid Versus Extended Relational Approaches
9.2.1 Uses and Trends of the Hybrid and Extended Relational Approaches
9.3 Extended Relational Languages
9.4 Object-Oriented Languages and SQL
9.5 Conclusion
Outlook
Additional Reading
Endnotes

10 Object-Oriented Engines and Models
10.1 Introduction
10.2 The Object-Oriented Database System manifesto
10.3 The ODMG Standardization Effort
10.4 ODMG Contents
10.5 ODMG Languages
10.6 Conclusion
Outlook
Additional Reading
Endnotes

11 Other Issues in Object-Oriented Information Management
11.1 Introduction
11.2 Transaction Processing for Object-Oriented Environments
11.3 Distributed Object Management and Object Request Brokers
11.4 Security in OODBMS Environments
11.5 A Final Look at Object-Oriented Information Management
11.6 Conclusion
Outlook
Additional Reading
Endnotes

Part IV Database and Information Management Languages
12 SQL Futures
12.1 Introduction
12.2 SQL History
12.3 The SQL-92 Standard
12.3.1 Leveling
12.3.2 Implementation Issues
12.3.3 SQL-92 Language Features
12.4 The SQL3 Standard
12.4.1 SQL3 Advanced Relational-Like Database Concepts
12.4.2 MOOSE
12.4.3 Issues
12.4.4 Related Standards Efforts
12.5 Conclusion
Outlook
Additional Reading
Endnotes

13 ODMG Languages for Object-Oriented Databases
13.1 Introduction
13.2 Review of ODMG Principles
13.3 Object Definition Language (ODL)
13.4 Object Query Language (OQL)
13.5 ODMG and C++
13.5.1 C++ and ODL
13.5.2 C++ and OQL
13.5.3 C++ and OML
13.6 Smalltalk and ODMG
13.7 Conclusion
Outlook
Additional Reading
Endnotes

14 Xbase and Other Desktop Databases
14.1 Introduction
14.2 Desktop Database and Xbase: A Brief History
14.2.1 dBASE and Related Products
14.2.2 Other PC Databases
14.3 Xbase and ANSI X3J19
14.3.1 Standardization Efforts
14.3.2 Xbase Standardization Concerns
14.4 Graphical user Interfaces (GUIs) to PC Databases
14.5 Object Orientation
14.6 PC Databases and Architectures
14.6.1 The DBF File Format
14.6.2 IBM Desktop Databases: Future Directions
14.6.3 Representative PC Database Architectures
14.7 Conclusion
Outlook
Additional Reading
Endnotes

Part V Future Database and Information Management Models
15 Time Is on Your Side: Temporal Databases
15.1 Introduction
15.2 Principles of Temporal Databases
15.3 Models of Temporal Databases
15.4 Temporal Extensions to Database Languages
15.4.1 TempSQL
15.4.2 TSQL
15.4.3 HSQL
15.4.4 Other SQL Extensions
15.4.5 Standardized Temporal SQL
15.5 Metadata and Temporal Databases
15.6 Object-Oriented Temporal Databases
15.7 Indexes for Temporal Database Support
15.8 Conclusion
Outlook
Additional Reading
Endnotes

16 Database Intelligence: The Active Database Approach
16.1 Introduction
16.2 Principles of Active Database Systems
16.2.1 Constraints and Assertions
16.2.2 Stored Procedures
16.2.3 Triggers
16.3 Extensions to the Active Database Model
16.4 Transaction Models and Active Databases
16.5 Limitations of Active Database Models
16.6 Production Rules and Database Environments
16.7 Artificial Intelligence and Database Technology
16.8 Conclusion
Outlook
Additional Reading
Endnotes

17 Space, Shapes and Words: Spatial Databases, Multimedia and Image Information Management, and Text Management Systems
17.1 Introduction
17.2 Principles of Spatial Data
17.2.1 Navigational Systems: A Case of Spatial Data Management
17.3 Image Information Systems
17.4 Multimedia Information Systems
17.4.1 Architecture
17.4.2 Standards
17.4.3 Application Development Methodology
17.5 Text Retrieval and Document Management Systems
17.5.1 Document Check-in
17.5.2 Index Structure
17.5.3 Index Loading
17.5.4 Component Document Management
17.5.5 Future Directions and Issues
17.6 Conclusion
Outlook
Additional Reading
Endnotes

18 Hypertext and Hypermedia
18.1 Introduction
18.2 Definitions of Hypertext and Hypermedia
18.3 Architecture of Hypermedia Systems
18.4 Hypermedia and Information Management
18.5 Future Directions in Hypermedia
18.6 Conclusion
Outlook
Additional Reading
Endnotes

Part VI Supporting Functions
19 Repositories and Metadata Management Read More