Database Management Systems

A book-shaped table of contents for DBMS: relational foundations through SQL mastery, storage internals, transactions, distributed databases, NoSQL, and MAANG interview prep — cross-linking existing system-design/patterns notes instead of duplicating them.

1 — Replication

Covers master-replica, multi-master, and leaderless replication topologies and their tradeoffs.

2 — Partitioning

Covers horizontal and vertical partitioning and consistent hashing for distributing data across nodes.

4 — CAP Theorem

Covers the CAP theorem's consistency, availability, and partition tolerance tradeoff.

5 — PACELC

Extends CAP with PACELC's latency-vs-consistency tradeoff and its practical implications for system design.