Data Model Selection
🔴 P0 — the first data decision in every design; determines query flexibility, scaling, and consistency
··
923 words·
5 mins
- rtshkmr's digital garden/
- References/
- Architecture Design Basics/
- Pattern Taxonomy/
- Data Storage & Retrieval/
Data Storage & Retrieval
How data is modelled, stored, indexed, and made durable. Covers database selection, indexing strategies, durability internals, and event-driven data patterns.
| Pattern | Priority |
|---|---|
| Data Model Selection | 🔴 P0 |
| Index Trade-offs (B-Tree vs LSM) | 🟠P1 |
| Write-Ahead Logging | 🟠P1 |
| CQRS | 🟠P1 |
| Event Sourcing | 🟠P1 |
Event Sourcing
🟠P1 — store events, not state; the append-only log as source of truth
··
172 words·
1 min
CQRS
🟠P1 — Command Query Responsibility Segregation; separate read and write models
··
191 words·
1 min
Write-Ahead Logging
🟠P1 — the durability mechanism underlying every serious database
··
173 words·
1 min
Index Trade-offs (B-Tree vs LSM)
🟠P1 — DDIA Ch3 deep knowledge; shows understanding of storage engine internals
··
286 words·
2 mins