Dimensional Modeling vs. Relational Modeling in Data Warehouse

Dimensional modeling is a unique way to model a data warehouse and is markedly different from the typical relational modeling used in the OLTP/transaction-based systems. To clarify the terminology- Dimensional model is stored in the databases in relational form (relational tables linked to each other through foreign keys). It’s 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 in my portal www.bipminstitute.com.