Distributed Databases

Distributed Database Systems Concepts

• Introduction to Distributed Databases

• Why Distributed Databases

• Components of Distributed DBMS architecture [peer-to-peer]

• Important considerations in Distributed Database 

• Various options for distributing database in a DDBS

• Comparison of Data allocation (replication) alternatives.

• Database Fragmentation (Horizontal, Vertical, Hybrid)

• Transactions in Distributed Databases

• Two Phase Commit (2PC) Protocol in Pictures 

  • Handling of failures by 2PC protocol

• Three Phase Commit (3PC) protocol in Distributed Databases

• Concurrency Control in Distributed Databases

• Deadlock handling in distributed databases

• Centralized deadlock detection approach in distributed database

• Keywords and Definitions in Distributed database

• Advantages and Disadvantages of Distributed Databases

• Advantages of Data Fragmentation in Distributed Databases

• Advantages and Disadvantages of Data Replication in Distributed Databases

• List of few DBMS Software that support the concept of Distributed Database

 

Distributed Database Systems - Question and Answers

• Distributed Database - Questions and Answers

• Distributed Database - Two Mark Questions with Answers