Transcript
Page 1: Copyright © 2004 Pearson Education, Inc.. Chapter 25 Distributed Databases and Client–Server Architectures

Copyright © 2004 Pearson Education, Inc.

Page 2: Copyright © 2004 Pearson Education, Inc.. Chapter 25 Distributed Databases and Client–Server Architectures

Copyright © 2004 Pearson Education, Inc.

Chapter 25

Distributed Databases and Client–Server

Architectures

Page 3: 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

Page 4: Copyright © 2004 Pearson Education, Inc.. Chapter 25 Distributed Databases and Client–Server Architectures

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

Page 5: Copyright © 2004 Pearson Education, Inc.. Chapter 25 Distributed Databases and Client–Server Architectures

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

Copyright © 2004 Pearson Education, Inc.

Types of Distributed Database Systems

Page 6: Copyright © 2004 Pearson Education, Inc.. Chapter 25 Distributed Databases and Client–Server Architectures

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

Page 7: Copyright © 2004 Pearson Education, Inc.. Chapter 25 Distributed Databases and Client–Server Architectures

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

Page 8: Copyright © 2004 Pearson Education, Inc.. Chapter 25 Distributed Databases and Client–Server Architectures

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

Copyright © 2004 Pearson Education, Inc.

An Overview of 3-Tier Client-Server Architecture

Page 9: Copyright © 2004 Pearson Education, Inc.. Chapter 25 Distributed Databases and Client–Server Architectures

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

Copyright © 2004 Pearson Education, Inc.

Distributed Databases in Oracle

Page 10: Copyright © 2004 Pearson Education, Inc.. Chapter 25 Distributed Databases and Client–Server Architectures

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

Copyright © 2004 Pearson Education, Inc.

Summary


Top Related