Distributed database systems / Chhanda Ray.

Format:

Book

Author/Creator:

Ray, Chhanda.

Language:

English

Subjects (All):

Distributed databases.

Database management.

Data warehousing.

Physical Description:

1 online resource (xvi, 308 p.) : ill.

Edition:

[First edition].

Place of Publication:

Delhi : Pearson : Dorling Kindersley (India), c2009.

Summary:

Distributed Database Systems discusses the recent and emerging technologies in the field of distributed database technology. The material is up-to-date, highly readable, and illustrated with numerous practical examples. The mainstream areas of distributed database technology, such as distributed database design, distributed DBMS architectures, distributed transaction management, distributed concurrency control, deadlock handling in distributed systems, distributed recovery management, distributed query processing and optimization, data security and catalog management, have been covered in detail. The popular distributed database systems, SDD-1 and R*, have also been included.

Contents:

Cover

Distributed Database Systems

Copyright

Contents

Preface

Overview of Relational1 DBMS

Concepts of Relational Databases

Integrity Constraints

Normalization

Functional Dependencies

Normal Forms

Relational Algebra

Selection Operation

Projection Operation

Union Operation

Set Difference Operation

Cartesian Product Operation

Intersection Operation

Join Operation

Division Operation

Relational Database Management System

Chapter Summary

Exercises

Review of Database Systems

Evolution of Distributed Database System

Overview of Parallel Processing System

Parallel Databases

Benefits of Parallel Databases

Parallel Database Architectures

Parallel Database Design

Data Partitioning

Distributed Database Concepts

Fundamentals of Distributed Databases

Features of a Distributed DBMS

Advantages and Disadvantages of Distributed

An Example of Distributed

Homogeneous and Heterogeneous Distributed

Functions of Distributed

Components of a Distributed

Date's 12 Objectives for Distributed Database Systems

Overview of Computer Networking

Introduction to Networking

Types of Computer Networks

Communication Schemes

Network Topologies

The OSI Model

Network Protocols

TCP/IP

SPX/IPX

NetBIOS

APPC

DEC net

Apple Talk

WAP

The Internet and the World-Wide Web

Distributed Database Design

Distributed Database Design Concepts

Alternative Approaches for Distributed Database Design

Objectives of Data Distribution

Alternative Strategies for Data Allocation

Data Fragmentation

Benefits of Data Fragmentation

Correctness Rules for Data Fragmentation

Different Types of Fragmentation

The Allocation of Fragments.

Measure of Costs and Benefits for Fragment Allocation

Transparencies in Distributed Database Design

Data Distribution Transparency

Transaction Transparency

Performance Transparency

DBMS Transparency

Distributed DBMS Architecture

Introduction

Client/Server System

Advantages and Disadvantages of Client/Server System

Architecture of Client/Server Distributed Systems

Architectural Alternatives for Client/Server Systems

Peer-to-Peer Distributed System

Reference Architecture of Distributed DBMSs

Component Architecture of Distributed DBMSs

Distributed Data Independence

Multi-Database System

Five-Level Schema Architecture of federated MDBS

Distributed Transaction Management

Basic Concepts of Transaction Management

ACID Properties of Transactions

Objectives of Distributed Transaction Management

A Model for Transaction Management in a Distributed System

Classification of Transactions

Distributed Concurrency Control

Objectives of Distributed Concurrency Control

Concurrency Control Anomalies

Distributed Serializability

Classification of Concurrency Control Techniques

Locking-based Concurrency Control Protocols

Centralized 2PL

Primary Copy 2PL

Distributed 2PL

Majority Locking Protocol

Biased Protocol

Quorum Consensus Protocol

Timestamp-Based Concurrency Control Protocols

Basic Timestamp Ordering Algorithm

Conservative to Algorithm

Multi-version to Algorithm

Optimistic Concurrency Control Technique

Distributed Deadlock Management

Introduction to Deadlock

Distributed Deadlock Prevention

Distributed Deadlock Avoidance

Distributed Deadlock Detection and Recovery

Centralized Deadlock Detection.

Hierarchical Deadlock Detection

Distributed Deadlock Detection

False Deadlocks

Distributed Recovery Management

Introduction to Recovery Management

Failures in a Distributed Database System

Steps Followed after a Failure

Local Recovery Protocols

Immediate Modification Technique

Shadow Paging

Checkpointing and Cold Restart

Distributed Recovery Protocols

Two-Phase Commit Protocol

Three-Phase Commit Protocol

Network Partition

Pessimistic Protocols

Optimistic Protocols

Distributed Query Processing

Concepts of Query Processing

Objectives of Distributed Query Processing

Phases in Distributed Query Processing

Query Decomposition

Query Fragmentation

Global Query Optimization

Join Strategies in Fragmented Relations

Simple Join Strategy

Semijoin Strategy

Global Query Optimization Algorithms

Distributed INGRES Algorithm

Distributed R* Algorithm

SDD-1 Algorithm

Distributed Database Security and Catalog Management

Distributed Database Security

View Management

View Updatability

Views in Distributed DBMS

Authorization and Protection

Centralized Authorization Control

Distributed Authorization Control

Semantic Integrity Constraints

Global System Catalog

Contents of Global System Catalog

Catalog Management in Distributed Systems

Mobile Databases and Object-Oriented DBMS

Mobile Databases

Mobile DBMS

Introduction to Object-Oriented Databases

Object-Oriented Database Management Systems

Features of OODBMS

Benefits of OODBMS

Disadvantages of OODBMS

SDD-1 Distributed Database System

General Architecture of SDD-1 Database System.

Distributed Concurrency Control in SDD-1

Distributed Query Processing in SDD-1

Distributed Reliability and Transaction Commitment in SDD-1

R* Distributed Database System

Architecture of R*

Query Processing in R*

Transaction Management in R*

The Presumed Abort Protocol

The Presumed Commit Protocol

Data Warehousing and Data Mining

Concepts of Data Warehousing

Benefits of Data warehousing

Problems in Data Warehousing

Data Warehouses and OLTP Systems

Data Warehousing Architecture

Operational Data Source

Load Manager

Query Manager

Warehouse Manager

Detailed Data

Summarized Data

Archive/Backup Data

Metadata

End-User Access Tools

Data Warehouse Background Processes

Data Warehouse Schema

Star Schema

Snowflake Schema

Fact Constellation Schema

Data Marts

Online Analytical Processing

OLAP Tools

Introduction to Data Mining

Knowledge Discovery in Database Vs. Data Mining

Data Mining Techniques

Predictive Modeling

Clustering

Link Analysis

Appendix

Bibliography

Index.

Notes:

Title from cover (Safari Books Online, viewed September 3, 2011).

Includes bibliographical references (p. [299]-302) and index.

Description based on publisher supplied metadata and other sources.

ISBN:

9786612652523

81-317-4308-X

1-282-65252-4

OCLC:

732012372