Unit 5: Database System Architectures
Databases often need to be distributed across a number of different locations, especially because today's global companies need to be able to access data in multiple locations. While one copy of a database could reside in a location and be accessed remotely, it is often more efficient and reliable to replicate data across servers or to have portions of data on databases that share access across locations. In this unit, we will study distributed databases and related issues.
Completing this unit should take you approximately 17 hours.
5.1: Centralized and Client-Server Systems
Read this lecture, which covers server-system architectures and client-server architectures. While you read, compare and contrast the differences between the centralized and client-server systems.
5.2: Parallel Databases
Read this lecture, which covers parallel databases. While you read, be sure to compare and contrast the components available in parallel databases.
5.3: Distributed Databases
Read this lecture, which covers distributed databases.
5.3.1: Heterogeneous and Homogeneous Databases
Read this lecture, which covers distributed homogeneous databases.
Read this lecture, which covers distributed heterogeneous databases.
5.3.2: Concurrency Control
Watch this lecture for an introduction to concurrency control mechanisms in distributed databases.
5.3.3: Distributed Query Processing
Read this lecture, which discusses query processing.