Dimensional Modelling
Last updated
Last updated
Dimensional Modeling (DM) is a data structure technique optimized for data storage in a Data warehouse. Dimensional modeling aims to optimize the database for faster data retrieval. The concept of Dimensional Modeling was developed by Ralph Kimball and consisted of "fact" and "dimension" tables.
Dimension provides the context surrounding a business process event; they give who, what, and where of a fact. In the Sales business process, for the fact quarterly sales number, dimensions would be
They are joined to Fact tables via a foreign key.
Dimensions offer descriptive characteristics of the facts with the help of their attributes.
It contains Measurements, metrics, and facts about a business process, the primary table in dimension modeling.
A Fact Table contains
