Difference between ER Modeling and Dimensional Modeling - Data warehousing

Difference between ER Modeling and Dimensional Modeling

The entity-relationship model is a method used to represent the logical flow of entities/objects graphically that in turn create a database. It has both logical and physical model. And it is good for reporting and point queries.

Dimensional model is a method in which the data is stored in two types of tables namely facts table and dimension table. It has only physical model. It is good for ad hoc query analysis.

Difference between ER Modeling and Dimensional Modeling

Dimensional modeling is a form of modeling of data that is more flexible for the perspective of user. The ER modeling is for databases that are OLTP databases which uses normalized data using 1st or 2nd or 3rd normal forms.

Dimensional Modeling is used in data warehouses that uses 3rd normal form. It contains denormalized data.
What is the difference between data warehousing and business intelligence? - Data warehousing
Data warehousing relates to all aspects of data management starting from the development, implementation and operation of the data sets...
Describe dimensional Modeling - Data warehousing
Dimensional modeling is a design concept which is used by designers of building data warehouses. The data is stored in two types of tables...
What is snapshot with reference to data warehouse? - Data warehousing
Snapshot refers to a complete visualization of data at the time of extraction. It occupies less space and can be used to back up and restore data quickly...
Post your comment