Difference between ER modeling and Dimensional modeling
This Article discusses about Difference between ER modeling and Dimensional modeling.
In Data Modeling
Dimensional Modeling is used for OLAP Applications design.
ER Modeling is used for OLTP application design.
5 Differences between ER Modeling and Dimensional Modeling
|ER Data Modeling
|Dimensional Data Modeling
|Suitable for Online Line Transaction Processing (OLTP) Application
|Suggested for Data Warehousing Applications
|Consists of Entities and Relationships .
|Consists of Facts and Dimensions
|High Create/Read/Update/ Delete (CRUD) activity
|High Select Activity
|Data Redundancy is not desired
|Data Redundancy is desired
|Normalization is suggested
|De-Normalization is suggested
Video : Difference between ER Modeling and Dimensional Modeling
Interested in Online Training of Dimensional Modeling check out
Interested in Online ER Data Modeling check out