Basic diff is E-R modeling will have logical and physical model. Dimensional model will have only physical model.
E-R modeling is used for normalizing the OLTP database design.
Dimensional modeling is used for de-normalizing the ROLAP/MOLAP design.
Showing posts with label Explain Difference between E-R Modeling and Dimentional Modeling. Show all posts
Showing posts with label Explain Difference between E-R Modeling and Dimentional Modeling. Show all posts
Saturday, May 4, 2013
Explain Difference between E-R Modeling and Dimentional Modeling
Basic diff is E-R modeling will have logical and physical model. Dimensional model will have only physical model.
E-R modeling is used for normalizing the OLTP database design.
Dimensional modeling is used for de-normalizing the ROLAP/MOLAP design.
Subscribe to:
Posts (Atom)