Copyright © 2004 Pearson Education, Inc.

Copyright © 2004 Pearson Education, Inc.

Chapter 25

Distributed Databases and Client–Server

Architectures

Slide 25-3Elmasri and Navathe, Fundamentals of Database Systems, Fourth Edition

Copyright © 2004 Pearson Education, Inc.

Distributed Database Concepts

Parallel Versus Distributed TechnologyAdvantages of Distributed DatabasesAdditional Functions of Distributed

Databases

Slide 25-4Elmasri and Navathe, Fundamentals of Database Systems, Fourth Edition

Copyright © 2004 Pearson Education, Inc.

Data Fragmentation, Replication, and Allocation Techniques for Distributed

Database Design

Data FragmentationData Replication and AllocationExample of Fragmentation, Allocation, and

Replication

Slide 25-5Elmasri and Navathe, Fundamentals of Database Systems, Fourth Edition

Copyright © 2004 Pearson Education, Inc.

Types of Distributed Database Systems

Slide 25-6Elmasri and Navathe, Fundamentals of Database Systems, Fourth Edition

Copyright © 2004 Pearson Education, Inc.

Query Processing in Distributed Databases

Data Transfer Costs of Distributed Query Processing

Distributed Query Processing Using Semijoin

Query and Update Decomposition

Slide 25-7Elmasri and Navathe, Fundamentals of Database Systems, Fourth Edition

Copyright © 2004 Pearson Education, Inc.

Overview of Concurrency Control and Recovery in Distributed Databases

Distributed Concurrency Control Based on a Distinguished Copy of a Data Item

Distributed Concurrency Control Based on Voting

Distributed Recovery

Slide 25-8Elmasri and Navathe, Fundamentals of Database Systems, Fourth Edition

Copyright © 2004 Pearson Education, Inc.

An Overview of 3-Tier Client-Server Architecture

Slide 25-9Elmasri and Navathe, Fundamentals of Database Systems, Fourth Edition

Copyright © 2004 Pearson Education, Inc.

Distributed Databases in Oracle

Slide 25-10Elmasri and Navathe, Fundamentals of Database Systems, Fourth Edition

Copyright © 2004 Pearson Education, Inc.

Summary