Dialogue: Explain Why OLTP and BI Should Diverge
Explain the workload difference between normalized source systems and dimensional serving models without turning the discussion into a turf war.
Marco ME Backend engineer Marco is proud of a carefully normalized order schema and sees the warehouse star as redundant duplication. If you attack the source design, the conversation becomes territorial instead of architectural. Write-heavy source workload Read-heavy analytics workload 1 schema cannot optimize bothequally well Translate the workload, not the ego The strongest response starts by agreeing that the source schema is correct for writes, then explains why the warehouse makes a different trade. Argue that normalized design is bad for analytics True in part, but it sounds like an attack on the engineer’s work. Two good models for…
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in