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.

3 — Distributed Transactions

Covers the saga and outbox patterns and eventual consistency as alternatives to distributed ACID transactions.

5 — PACELC

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