An Architecture-Oriented Data Warehouse Testing Approach

In the past few years, the data warehouse (DW) has regained experts’ interest due to the paradigm shift from data storages to data analysis. During the development of DWs data passes through a number of transformations and are staged in multiple storages which might lead to data corruption and/or manipulation. Hence, testing DWs is a vital stage in the DW development life cycle. In this paper, we will present a DW testing approach that is adjustable to fit multiple DW architectures and will present its applicability on three case studies to outline the flexibility and generality of the proposed approach.

[1]  M. Jarke,et al.  Fundamentals of Data Warehouses , 2003, Springer Berlin Heidelberg.

[2]  Oliver Moravcik,et al.  The Proposal of the Essential Strategies of DataWarehouse Testing , 2008 .

[3]  Payal Pahwa,et al.  CLASSIFICATION OF DATA WAREHOUSE TESTING APPROACHES , 2012, BIOINFORMATICS 2012.

[4]  Vincent Rainardi,et al.  Building a Data Warehouse: With Examples in SQL Server , 2008 .

[5]  Matteo Golfarelli,et al.  Data Warehouse Design: Modern Principles and Methodologies , 2009 .

[6]  Ralph Kimball,et al.  The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom , 1998 .

[7]  N. ElGamal,et al.  Towards a data warehouse testing framework , 2012, 2011 Ninth International Conference on ICT and Knowledge Engineering.

[8]  Matteo Golfarelli,et al.  Data Warehouse Testing , 2011, Int. J. Data Warehous. Min..

[9]  Doug Vucevic,et al.  Testing Data Warehouse Applications , 2011 .

[10]  Galal H. Galal-Edeen,et al.  Data warehouse testing , 2013, EDBT '13.

[11]  Stephen R. Gardner.  Building the data warehouse , 1998, CACM.

[12]  Barry W. Boehm,et al.  A spiral model of software development and enhancement , 1986, Computer.

[13]  Ahmed K. Elmagarmid,et al.  Duplicate Record Detection: A Survey , 2007, IEEE Transactions on Knowledge and Data Engineering.

[14]  Matteo Golfarelli,et al.  A comprehensive approach to data warehouse testing , 2009, DOLAP.

[15]  W. W. Royce,et al.  Managing the development of large software systems: concepts and techniques , 1987, ICSE '87.