How does Relational Data Modeling differ from that of Dimensional Data Modeling?
In relational models data is normalized to 1st 2nd or 3rd Normal form. In dimensional models data is denormalized. The typical design is that of a Star where their is a central fact table containing additive measurable facts and this central fact table is in relationship with dimensional tables which generally contain text filters that normally occurs in the WHERE clause of a query.
