Data warehousing - Difference between ER Modeling and Dimensional Modeling.

Difference between ER Modeling and Dimensional Modeling.

Dimensional modelling is very flexible for the user perspective. Dimensional data model is mapped for creating schemas whereas ER Model is not mapped for creating shemas and does not use in conversion of normalization of data into denormalized form.

ER Model is utilized for OLTP databases that uses any of the 1st or 2nd or 3rd normal forms, where as dimensional data model is used for data warehousing and uses 3rd normal form.

ER model contains normalized data where as Dimensional model contains denormalized data.

Difference between ER Modeling and Dimensional Modeling.

ER modeling that models an ER diagram represents the entire businesses or applications processes. This diagram can be segregated into multiple Dimensional models. This is to say, an ER model will have both logical and physical model. The Dimensional model will only have physical model.
Data warehousing - What is snapshot with reference to data warehouse?
What is snapshot with reference to data warehouse? - A snapshot of data warehouse is a persisted report from the catalogue........
Data warehousing - What is degenerate dimension table?
What is degenerate dimension table? - The dimensions that are persisted in the fact table is called dimension table........
Data warehousing - What is Data Mart?
What is Data Mart? - Data Mart is a data repository which is served to a community of people......
Post your comment