Dimensional Modeling
Updated 2026-08-13
INTRODUCTION
English translation pending.
CORE DEFINITION
Developed by Ralph Kimball, dimensional modeling structures data warehouses around fact tables that store business measures, dimension tables that describe the context of facts such as time, geography, and product, and star or snowflake schemas that arrange dimension tables around the fact table. Its core proposition is that arranging data this way makes complex business data easy to query and analyze. The key qualification is that query performance and readability are favored over full normalization.
SCAFFOLDING EFFECT
Reduce cognitive load
- Structure business data: split measures into fact tables and descriptive context into dimension tables. - Speed up analysis: model dimensions so users can filter and group without complex joins. - Design for clarity: choose star or snowflake layouts to match query habits.
Anchor fast decisions
Fact tables hold the numeric events of the business while dimension tables hold the descriptive attributes used to slice them; because every measure sits beside its descriptive context, analytical queries reduce to simple joins along a predictable schema, so complex business questions become easy to formulate and fast to run.
MINIMUM ACTION
In progress 0/1Practice this model in one real situation:
account_treeGenealogyexpand_more
menu_bookReferencesexpand_more
Source support: Explicit
- en.wikipedia.orghttps://en.wikipedia.org/wiki/Dimensional_modelingverified
PRIVATE NOTES · Only visible to you
SAVED Q&A
ENTRY Q&A · Private saving available
Ask with a clear boundary
thinkingmodels answers from published entry context only.
Your question is sent to thinkingmodels. The answer uses public entry context only.
RELATED MODELS