Data Modeling Techniques for Data Warehouse
Year: 2017
Type: article
Abstract: 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.
Author: Sona Kumra
Language: English
Subfield: Management Information Systems
Domain: Social Sciences
Open Access status: hybrid
OpenAlex ID: W4321463762
