ch22 - Chapter22:DistributedDatabases...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Database System Concepts, 5th Ed . ©Silberschatz, Korth and Sudarshan See  www.db-book.com  for conditions on re-use  Chapter 22: Distributed Databases Chapter 22: Distributed Databases
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
©Silberschatz, Korth and Sudarshan 22.<number> Database System Concepts - 5 th  Edition, Aug 22,  2005. Chapter 22: Distributed Databases Heterogeneous and Homogeneous Databases Distributed Data Storage Distributed Transactions Commit Protocols Concurrency Control in Distributed Databases Availability Distributed Query Processing Heterogeneous Distributed Databases Directory Systems
Background image of page 2
©Silberschatz, Korth and Sudarshan 22.<number> Database System Concepts - 5 th  Edition, Aug 22,  2005. Distributed Database System Distributed Database System A distributed database system consists of loosely coupled sites that share  no physical component Database systems that run on each site are independent of each other Transactions may access data at one or more sites
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
©Silberschatz, Korth and Sudarshan 22.<number> Database System Concepts - 5 th  Edition, Aug 22,  2005. Homogeneous Distributed Databases Homogeneous Distributed Databases In a homogeneous distributed database All sites have identical software  Are aware of each other and agree to cooperate in processing user  requests. Each site surrenders part of its autonomy in terms of right to change  schemas or software Appears to user as a single system In a heterogeneous distributed database Different sites may use different schemas and software Difference in schema is a major problem for query processing Difference in software is a major problem for transaction  processing Sites may not be aware of each other and may provide only  limited facilities for cooperation in transaction processing
Background image of page 4
©Silberschatz, Korth and Sudarshan 22.<number> Database System Concepts - 5 th  Edition, Aug 22,  2005. Distributed Data Storage Distributed Data Storage Assume relational data model Replication System maintains multiple copies of data, stored in different sites,  for faster retrieval and fault tolerance. Fragmentation Relation is partitioned into several fragments stored in distinct sites Replication and fragmentation can be combined Relation is partitioned into several fragments: system maintains  several identical replicas of each such fragment.
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
©Silberschatz, Korth and Sudarshan 22.<number> Database System Concepts - 5 th  Edition, Aug 22,  2005.
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 06/14/2011 for the course DATABASE & - taught by Professor - during the Spring '11 term at Aarhus Universitet.

Page1 / 93

ch22 - Chapter22:DistributedDatabases...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online