Title: Quantitative analysis of data warehouse design quality

Authors: M. Pighin, L. Ieronutti

Addresses: IS&SE-Lab, Department of Mathematics and Computer Science, University of Udine, Via delle Scienze 206, Udine, 33100, Italy. ' IS&SE-Lab, Department of Mathematics and Computer Science, University of Udine, Via delle Scienze 206, Udine, 33100, Italy

Abstract: Information systems allow companies to collect a large number of operational and transactional data. Data warehouses are increasingly used by organisations to extract concise information supporting decision processes. However, data warehouse design strategies as well as the structure and content of the original database largely influence the effectiveness of such tools. Our research is focused on data-driven approaches, and in this paper, we present a solution that, based on a set of metrics measuring different characteristics of the original data sources, effectively supports the creation of data warehouses. Moreover, combining the indexes computed by our metrics on selected dimensions and measures, it is also possible to derive quantitative information on the design quality of the final data warehouse. To demonstrate the effectiveness of our solution, we briefly present the results obtained from the analysis of a selling data warehouse derived from a real-word ERP system.

Keywords: data warehouse quality; data driven design; data warehouse metrics; data warehousing; data warehouse design; ERP; enterprise resource planning.

DOI: 10.1504/IJIDSS.2010.033676

International Journal of Intelligent Defence Support Systems, 2010 Vol.3 No.1/2, pp.52 - 65

Published online: 15 Jun 2010 *

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