Make Informed Decisions
Sunday May 20th 2012

Dimensional modeling (DM)

According to Dr. Kimball[1], DM is a design technique for databases intended to support end-user queries in a data warehouse. It is oriented around understandability, contrary to database administration. According to him, although transaction-oriented ER is very useful for the transaction capture, it should be avoided for end-user delivery.

Dimensional modeling always uses the concepts of facts, AKA ‘measures’, and dimensions. Facts are typically (but not always) numeric values that can be aggregated, and dimensions are groups of hierarchies and descriptors that define the facts. For example, sales amount is a fact; timestamp, product, register#, store#, etc. are elements of dimensions. Dimensional models are built by subject area, e.g. store sales, inventory, claims, etc. Because the different subject areas share some but not all dimensions, efficiency in design, operation, and consistency, is achieved using conformed dimensions, i.e. using one copy of the shared dimension across subject areas. The term “conformed dimensions” was originated by Ralph Kimball.[2]

Source:

1- Ralph Kimball (1997). “A Dimensional Modeling Manifesto”. DBMS and Internet Systems 10 (9). http://www.dbmsmag.com/9708d15.html.

2- Wikipedia.org

Reader Feedback

One Response to “Dimensional modeling (DM)”

  1. [...] brick walls. The post is about an article by Margy Ross. She highlights essential rules for dimensional Modelling. Author: admin Categories: Data Mart vrs Data Warehouse, Data Model Tags: Comments (0) [...]

Leave a Reply