data-modeling
Installation
SKILL.md
Data Modeling Guide
Core Philosophy
Model for your queries. OLTP systems optimize for writes (normalize). OLAP systems optimize for reads (denormalize). Know your access patterns first.
"A data model is a contract between the data producer and consumer."
Modeling Approaches
| Approach | Best For | Pros | Cons |
|---|---|---|---|
| 3NF (Normalized) | OLTP | Data integrity, less redundancy | Complex queries |
| Star Schema | Analytics | Simple queries, fast reads | Redundancy |
| Snowflake | Large dims | Less redundancy than star | More joins |
| Data Vault | Enterprise DW | Auditability, flexibility | Complexity |
| One Big Table | Simple analytics | No joins | Data quality risk |