« Assess Data Warehouse Project Readiness | Main | Design your Data Warehouse for broader application »
July 3, 2008
Dimensional Modeling vs. Relational Modeling
Dimensional modeling is a unique way to model a data warehouse and is different from relational modeling used in the OLTP systems. To clarify the terminology- Dimensional model is stored in the databases in relational form (relational tables linked to each other through foreign keys). Its the way your logically and physically model the database that is different.
Dimensional modeling has the advantage of:
Responding to ad-hoc and huge queries
Symmetrical model
Extensible and scalable
To understand the details on the comparison, and why one should go for dimensional modeling one can refer Dimensional Modeling vs. relational modeling.
Posted by Rajan Gupta at July 3, 2008 11:00 AM
