Difference between ER modeling and Dimensional modeling

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 ModelingDimensional Data Modeling
Suitable for  Online Line Transaction Processing (OLTP)  ApplicationSuggested for Data Warehousing Applications
Consists of  Entities and Relationships .Consists of Facts and Dimensions
High Create/Read/Update/  Delete (CRUD) activityHigh Select Activity
Data Redundancy is not desiredData Redundancy is desired
Normalization is suggestedDe-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
October 25, 2017

0 responses on "Difference between ER modeling and Dimensional modeling"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Template Design © VibeThemes. All rights reserved.