Data warehouse testing: A prototype-based methodology

作者：Golfarelli Matteo; Rizzi Stefano^*

来源：Information and Software Technology, 2011, 53(11): 1183-1198.

DOI：10.1016/j.infsof.2011.04.002

• Testing
• Business intelligence
• Data warehouse
• Software engineering

Context: Testing is an essential part of the development life-cycle of any software product. While most phases of data warehouse design have received considerable attention in the literature, not much has been written about data warehouse testing.
Objective: In this paper we propose a comprehensive approach to testing data warehouse systems. Its main features are earliness with respect to the life-cycle, modularity, tight coupling with design, scalability, and measurability through proper metrics.
Method: We introduce a number of specific testing activities, we classify them in terms of what is tested and how it is tested, and we show how they can be framed within a prototype-based methodology. We apply our approach to a real case study for a large retail company.
Results: The case study we faced, based on an iterative prototype-based medium-size project, confirmed the validity of our approach. In particular, the main benefits were obtained in terms of project transparency, coordination of the development team, and organization of design activities.
Conclusion: Though some general-purpose testing techniques can be applied to data warehouse projects, the effectiveness of testing can be largely improved by applying specifically-devised techniques and metrics.

• 出版日期2011-11