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.

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.

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.