Dimensional modeling

Dimensional modeling (DM) is the name of a logical design technique often used for data warehouses. It is different from, and contrasts with, entity-relationship modeling (ER). According to Prof. Kimball, DM is a design technique for databases intended to support end-user queries in a data warehouse. It is oriented around understandability, as opposed to database administration. Still according to him, although ER is very useful for the transaction capture, it should be avoided for end-user delivery.