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.

3 — Distributed Transactions

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

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.