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 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
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.

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

Template Design © VibeThemes. All rights reserved.
Open Chat
Hello ,
Looking for additional Information?
Whatsapp Now !!!