Why is star schema preferred over 3NF for analytics?
Tests your grasp of the read-performance trade-off in analytical schemas. A great answer names fact and dimension tables, emphasizes fewer joins for aggregations, and cites simpler SQL and faster query plans.
Tests your understanding of why OLAP workloads favor denormalization over OLTP normalization. A strong answer defines the fact table as the central measurable events and dimension tables as descriptive context, explains that star schemas reduce expensive multi-table joins during large scans and aggregations, notes that 3NF normalization optimizes for write consistency and small updates rather than bulk reads, and acknowledges the storage trade-off.
Read the original → Wikipedia: Star schema
- #data modeling
- #star schema
- #olap
- #data warehousing
- #3nf
Get five bites like this every day.
Tezvyn delivers a daily feed of 60-second tech bites with quizzes to lock in what you learn.