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