A study of multidimensional modeling approaches for data warehouse

Data warehouse system is used to support the process of organizational decision making. Hence, the system must extract and integrate information from heterogeneous data sources in order to uncover relevant knowledge suitable for decision making process. However, the development of data warehouse is...

Full description

Bibliographic Details
Main Authors: Mat Yusof, Sharmila, Sidi, Fatimah, Ibrahim, Hamidah, Affendey, Lilly Suriani
Format: Conference or Workshop Item
Language:English
Published: AIP Publishing 2016
Online Access:http://psasir.upm.edu.my/id/eprint/57414/1/A%20study%20of%20multidimensional%20modeling%20approaches%20for%20data%20warehouse.pdf
Description
Summary:Data warehouse system is used to support the process of organizational decision making. Hence, the system must extract and integrate information from heterogeneous data sources in order to uncover relevant knowledge suitable for decision making process. However, the development of data warehouse is a difficult and complex process especially in its conceptual design (multidimensional modeling). Thus, there have been various approaches proposed to overcome the difficulty. This study surveys and compares the approaches of multidimensional modeling and highlights the issues, trend and solution proposed to date. The contribution is on the state of the art of the multidimensional modeling design.