Search This Blog

Monday, June 30, 2014

What is Difference between E-R Modeling and Dimentional Modeling

  1. ER modeling the data is in normalised form. So more number of Joins, which may adversly affect the system performnace.Whereas in Dimensional Modelling the data is denormalised, so less number of joins, by which system performance will improve
  2. ER modeling: a view of data from data processing. OLTP
    MD modeling: a view of data from business porcessing.-- OLAP
     
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)