A Star Schema Serves Questions, Not Writes
Explain why star schemas are designed around query simplicity and metric consistency rather than write efficiency.
A star is a serving model. Central fact, descriptive edges The star schema works because one measurable process sits in the middle and the dimensions around it answer the natural slicing questions. Who bought it? What was sold? When? Through which channel? Those are analysis questions, so the model exposes them directly. Simpler joins produce more consistent answers Every extra operational join is another opportunity for analysts to pick the wrong table, join at the wrong level, or miss a filter. A star reduces those choices. Fewer paths mean fewer accidental definitions of the same metric. Denormalization is a trade…
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in