| January 01, 2009 21:09:33 |
#1 |
| wmilford |
Member Since: October 2008 Total Comments: 2 |
RE: Relational and 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. |
| |
