Question

Why is entity relationship model technique not suitable for data warehouse?

Answer 1

dataware house contain huge information data can't fetch by normal technique so it requires special techniques..

Answer 2

Answer: ER modelling aims to optimize performance for transaction processing and is also difficult to query ER models because of the complexity.

Concept : Data Warehouse

Given : Entity relationship model technique not suitable for data warehouse

To Find : Why is entity relationship model technique not suitable for data

               warehouse?

Explanation :

In computing, a data warehouse, also known as an enterprise data warehouse, is a system used for reporting and data analysis and is considered as a core component of business intelligence. A data warehouse is a central repository of information that can be analyzed to make more useful decisions. Data flows into a data warehouse from transactional systems, relational databases, and other sources like application log files and transaction applications. ER modelling aims to optimize performance for transaction processing and is also difficult to query ER models because of the complexity. Hence, ER models are not suitable for high performance retrieval of data. The conceptual Entity-Relationship (ER) model is extensively used for database design in relational database environment, which is used on day-to - day operations. Multidimensional (MD) data modeling is crucial in data warehouse design as it is targeted for managerial decision support. Multidimensional Data Modeling supports decision making by allowing users to drill-down for a more detailed information, roll-up to view summarized information, slice and dice a dimension for a selection of a specific point of interest and pivot to re-orientate the view of MD data.

#SPJ3