9 notes in this chapter

Advanced Databases Terms MOC

Comprehensive reference for database normalization, storage engine internals, query optimizers, transactions, and modern database architectures.

Database Design

• Database Normalization and Denormalization

Transactions & Concurrency

• Transaction Isolation Levels
• MVCC
• ACID (Atomicity, Consistency, Isolation, Durability)

Storage Engine Internals

• Database Indexing Internals
• Write-Ahead Logging (WAL)

Query Processing

• Query Optimization and Execution

Database Architectures

• OLTP vs OLAP
• Vector Databases

---

How to use this

Use this MOC to master database modeling, optimize query performance, understand internal storage mechanics, and design data pipelines for scale.

Suggested order if starting from zero

1. Database Normalization and Denormalization → ACID (Atomicity, Consistency, Isolation, Durability)
2. Transaction Isolation Levels → MVCC
3. Database Indexing Internals → Query Optimization and Execution
4. Write-Ahead Logging (WAL)
5. OLTP vs OLAP → Vector Databases