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 *

    About dbVidya

    DB Vidya is a technology-driven firm. It is dedicated to providing Quality IT trainings and services worldwide. In this era of information technology where change is constant, DB Vidya, has carved a niche for itself by providing quality training by making use of the latest developments in technology.

    Keep in Touch for latest Updates

    DbVidya © Copyright 2015. All rights reserved.