| How to Use This Book: A Road Map | |
| Relational Algebra, Calculus, and Fundamental Database Concepts | |
| Introduction | |
| Relational Algebra | |
| Relational Calculus | |
| Database Objects | |
| Catalogs | |
| Database Models | |
| ANSI/SPARC Database Model | |
| Entity-Relationship Model | |
| Relational Model | |
| Network Model | |
| Hierarchical Database Model | |
| Traditional Fish n' Chips Enterprise | |
| Model Translation Concepts | |
| Communications Networks | |
| Introduction | |
| Analog Versus Digital Transmission | |
| Classifying Networks | |
| Network Topologies | |
| Standards | |
| Network Architectures | |
| Local Area Networks | |
| Client/Server Architecture | |
| SQL Basics | |
| Introduction | |
| Data Declaration Language | |
| Example Database | |
| Data Manipulation Language | |
| SQL Insert Command | |
| The SQL Update Command | |
| DATA Control Language | |
| Referential Integrity | |
| Examples of Distributed Queries | |
| Concurrency and Recovery | |
| Introduction | |
| A Simple DBMS Model | |
| Concurrency Issues and Solutions | |
| Serialization of Concurrent Transactions | |
| Concurrence Control Algorithms | |
| Two-Phase Locking Protocols | |
| Time Stamp Ordering Protocol | |
| Deadlock and Deadlock Resolution | |
| Recovery Strategies | |
| Introduction to Distributed and Multi-Database Systems | |
| Introduction | |
| Classifying Shared Information Systems | |
| Distributed Database Systems | |
| Design Issues | |
| Multi-Database Systems | |
| Design Issues | |
| Federated Distributed Database Systems | |
| Role of Expert Systems | |
| Agents and Federated Distributed Database Systems | |
| Introduction to Distributed Database Systems | |
| Data Model | |
| Global Database Catalog | |
| Global Application Views | |
| Local Database Catalogs | |
| Local Physical Database Schema | |
| System Component Architecture | |
| Global Transaction Monitor | |
| Local Transaction Monitor | |
| Local Database Management System | |
| Homogeneous Distributed Database Design | |
| Introduction | |
| Partitioning Versus Replication | |
| Horizontal Fragmentation | |
| Vertical Fragmentation | |
| Hybrid Fragmentation | |
| Distributed Query Processing | |
| DDBMS Model | |
| An Example | |
| Syntax Analyzer | |
| Query Decomposer | |
| Query Object Localizer | |
| Query Optimizer | |
| Local Query Optimizer | |
| Transaction Processing, Concurrency, and Deadlocks in Distributed Architectures | |
| Introduction | |
| Review of Classical Transaction Processing | |
| Concurrency Issues | |
| Review of Two-Phase Locking Protocol | |
| Distributed Concurrency Control Strategies | |
| Distributed Deadlock Detection and Resolution | |
| Two-Phase Commit Protocol | |
| Three-Phase Commit Protocol | |
| General Architecture Reviewed | |
| Distributed and Local Recovery Strategies | |
| Introduction | |
| Failure Categories | |
| A Generic Recovery System | |
| Popular Logging Strategies | |
| Classifying Recovery Systems | |
| Distributed Recovery Coordination Protocols | |
| Introduction to Multi-Database Architectures | |
| Table of Contents provided by Publisher. All Rights Reserved. |