← Advanced DBMS learning pathAdvanced DBMS · Module 7 of 10
Distributed databases
Store data across multiple sites.
📖 Key ideas
- Data is spread over multiple nodes or locations.
- Fragmentation: horizontal (rows) and vertical (columns).
- Replication improves availability and read performance.
- Distributed commit uses Two-Phase Commit (2PC).
- CAP theorem: consistency, availability, partition tolerance trade-offs.
💡 Real-life example: A distributed database is a bank with branches in many cities, keeping accounts in sync.
FragmentationSplitting tables across sites
ReplicationCopies of data at multiple sites
2PCTwo-Phase Commit protocol
CAP theoremDistributed trade-off theorem