Distributed Databases
Even the most powerful computers have finite processing and storage – eventually a database will exceed those limits. Thus, a distributed database is designed to spread the processing and storage of data across multiple machines. Such distribution introduces challenges for availability, concurrency, and joins when processing queries.
Learning Objectives
- Compare and contrast centralized and distributed databases
- Describe the techniques used by a distributed database management system (DBMS) for joins
How to Complete this Lesson
Complete the following learning activities: (2.5–3 hours total)
- Read Fundamentals of Database Management Systems Chapter 12: Client / Server Database and Distributed Database (45 minutes)
- Attend the class meeting (60 minutes)
- Take the quiz (10 minutes)
- Start working on the project’s web application (30–60 minutes)
Due
As a reminder, the following is due this lesson:
Resources
- Centralized vs Distributed Databases (3 minutes)
- Simple 2PC: Messaging Only (4 minutes)
- Questions for distributed databases (15–30 minutes)