Files
Abstract
There is an ongoing debate about which data warehouse architecture should be used to implement a data warehouse. Using existing theory and interviews with a panel of experts, this research proposed a model that identifies the various selection factors that affect the choice of data warehouse architecture. In addition, the research also evaluated the success of the various architectures. Specific hypotheses were created to investigate how organizational factors influence architecture selection and how data warehouse architectures influence architecture success. An empirical investigation involving an online field survey was conducted to further validate and test the proposed research models on architecture selection and success. Data collected for the main data warehouse architectures were used in the statistical analyses. The results suggest that various combinations of organizational factors influence the selection of a data warehouse architecture. Further, one architecture was identified as the least successful data warehouse solution while another emerged as the most costly to develop when compared to the rest. Through a carefully designed empirical investigation of data warehouse architectures, thisresearch sheds light on the data warehouse design selection in organizations by examining the impact organizational factors on data warehouse architecture selection and by evaluating data warehouse architecture success.