Data Modeling Techniques for Data Warehouse
Sona Kumra · International Journal of Advance Research and Innovation · 2017
The conceptual Entity-Relationship (ER) diagrams are extensively used for database design in relational database environment, which emphasized on day-to-day operations. Multidimensional (MD) data modelling, on the other hand, is crucial in data warehouse design, which targeted for managerial decision support. It 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 item of interest and pivot to re-orientate the view of MD data. When designing a MD model regardless whether it is a star or snowflake schema, it involves the identification of a fact, dimensions and measure attributes. This paper will explore on how the Multidimensional model can be used as the solution of data warehouse design instead of ER Model.