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. |