2019 – Dimensional Modeling Design Patterns – A Review

Presentation Summary

This technical presentation will review the characteristics of a well-designed dimensional model at the table and column level. I use the term “Design Patterns” to represent easily recognized conventions that might vary slightly from one institution to another. By internalizing good “Design Patterns”, a data modeler can superimpose those patterns on top of a new design early in the process and guide it to completion without having to rework the design to meet local conventions. We will walk through various design patterns like table naming, column naming, column hierarchies and support columns for both dimensions and facts.