Title: Data modelling for effective data warehouse architecture and design

Authors: Mohammad Rifaie, Keivan Kianmehr, Reda Alhajj, Mick J. Ridley

Addresses: School of Informatics, Bradford University, West Yorkshire, UK. ' Department of Computer Science, University of Calgary, Calgary, Alberta, Canada. ' Department of Computer Science, University of Calgary, Calgary, Alberta, Canada. ' School of Informatics, Bradford University, West Yorkshire, UK

Abstract: A data warehouse is attractive as the main repository of an organisation|s historical data and is optimised for reporting and analysis. In this paper, we present a data warehouse and the process of data warehouse architecture development and design. We highlight the different aspects to be considered in building a data warehouse. These range from data store characteristics to data modelling and the principles to be considered for effective data warehouse architecture.

Keywords: data warehouse architecture; data warehouse design; historical data; data modelling.

DOI: 10.1504/IJIDS.2009.027656

International Journal of Information and Decision Sciences, 2009 Vol.1 No.3, pp.282 - 300

Published online: 06 Aug 2009 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article