Distributed And Multi-Database Systems

by Angelo R. Bobak

Overview

Regardless of your database experience, Distributed and Multi-Database Systems provides the foundation and understanding necessary for proper design of databases for today's distributed and multi-database architectures. Introductory chapters help novices understand essential topics such as SQL, relational databases, transaction processing, and deadlock detection. Subsequent sections dealing with homogeneous, distributed databases, heterogenous multi-databases, and federated databases apply information discussed in earlier chapters enasbling readers to understand the complexities of distributed database design. Packed with over 200 illustrations, 50 equations, and two full chapters of examples, the book also includes discussions on objefct-oriented databases, which form an integral part of any database.

Product Details

ISBN-13:	9780890066140
Publisher:	Artech House, Incorporated
Publication date:	11/30/1995
Series:	Artech House Computer Science Library Series
Pages:	500
Product dimensions:	6.00(w) x 9.00(h) x 1.25(d)

Table of Contents

Contents:
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 ComponentArchitecture. 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:
Introduction. Review of Database Schemas. Traditional Fish n' Chips. Multi-Database Architecture Based on the ANSI/SPARC Model. Example MDBMS Architectures. Traditional Fish n' Chips MDBMS.

Multi-Database Design Issues:
Introduction. Simplified Design Steps.

Editorial Reviews

Provides a foundation for database design for distributed and multi- database architectures, assuming no experience with databases. Introductory chapters cover essential topics such as SQL, relational databases, transaction processing, relational theory, relational calculus, and algebra. Subsequent sections deal with homogeneous, distributed databases; heterogeneous multi-databases; recovery; object-oriented databases; and federated databases. Includes b&w two chapters of examples and case studies. For programmers, technical managers, and students. Annotation c. Book News, Inc., Portland, OR (booknews.com)

Booknews