ABSTRACT
During the development of the data warehouse (DW), too much data is transformed, integrated, structured, cleansed, and grouped in a single structure that is the DW. These various types of changes could lead to data corruption or data manipulation. Therefore, DW testing is a very critical stage in the DW development process.
A number of attempts were made to describe how the testing process should take place in the DW environment. In this paper, I will state briefly these testing approaches, and then a proposed matrix will be used to evaluate and compare these approaches. Afterwards, I will highlight the weakness points that exist in the available DW testing approaches. Finally, I will describe how I will fill the gap in the DW testing in my PhD by developing a DW Testing Framework presenting briefly its architecture. Then, I will state the scope of work that I am planning to address and what type of limitations that exist in this area that I am expecting to experience. In the end, I will conclude my work and state possible future work in the field of DW testing.
- Bateman, C. Where are the Articles on Data Warehouse Testing and Validation Strategy? Information Management, 2002.Google Scholar
- Bhat, S. Data Warehouse Testing - Practical Stick Minds, 2007.Google Scholar
- Brahmkshatriya, K. Data Warehouse Testing Stick Minds, 2007.Google Scholar
- Cooper, R. and Arbuckle, S., How to Throughly Test a Data Warehouse. in Software Testing Analysis and Review (STAREAST), (Orlando, Florida, 2002).Google Scholar
- CTG. CTG Data Warehouse Testing, 2002.Google Scholar
- ElGamal, N., ElBastawissy, A. and Galal-Edeen, G., Towards a Data Warehouse Testing Framework. in IEEE 9th International Conference on ICT and Knowledge Engineering (IEEE ICT&KE), (Bangkok, Thailand, 2011), 67--71.Google Scholar
- Executive-MiH. Data Warehouse Testing is Different, 2010.Google Scholar
- Golfarelli, M. and Rizzi, S. A Comprehensive Approach to Data Warehouse Testing ACM 12th international workshop on Data warehousing and OLAP (DOLAP '09), Hong Kong, China, 2009. Google ScholarDigital Library
- Golfarelli, M. and Rizzi, S. Data Warehouse Design: Modern Principles and Methodologies. McGraw Hill, 2009. Google ScholarDigital Library
- Golfarelli, M. and Rizzi, S. Data Warehouse Testing. International Journal of Data Warehousing and Mining, 7 (2). 26--43. Google ScholarDigital Library
- Golfarelli, M. and Rizzi, S. Data Warehouse Testing: A prototype-based methodology. Information and Software Technology, 53 (11). 1183--1198.Google ScholarCross Ref
- Inergy. Automated ETL Testing in Data Warehouse Environment, 2007.Google Scholar
- Mathen, M. P. Data Warehouse Testing InfoSys, 2010.Google Scholar
- Munshi, A. Testing a Data Warehouse Application Wipro Technologies, 2003.Google Scholar
- Rainardi, V. Testing your Data Warehouse. in Building a Data Warehouse with Examples in SQL Server, Apress, 2008.Google Scholar
- RTTS. QuerySurge, 2011.Google Scholar
- SSNSolutions. SSN Solutions, 2006.Google Scholar
- Tanuška, P., Moravčík, O., Važan, P. and Miksa, F., The Proposal of Data Warehouse Testing Activities. in 20th Central European conference on Information and Intelligent Systems, (Varaždin, Croatia, 2009), 7--11.Google Scholar
- Tanuška, P., Moravčík, O., Važan, P. and Miksa, F., The Proposal of the Essential Strategies of Data Warehouse Testing. in 19th Central European Conference on Information and Intelligent Systems (CECIIS), (2008), 63--67.Google Scholar
- Tanuška, P., Schreiber, P. and Zeman, J. The Realization of Data Warehouse Testing Scenario proizvodstvo obrazovanii. (Infokit-3) Part II: 3 meždunarodnaja nature-techničeskaja konferencija., Stavropol, Russia, 2008.Google Scholar
- Tanuška, P., Verschelde, W. and Kopček, M., The proposal of Data Warehouse Test Scenario. in European conference on the use of Modern Information and Communication Technologies (ECUMICT), (Gent, Belgium, 2008).Google Scholar
- Tavant, T. Data Warehouse Testing. Date Accessed: Jan 2013Google Scholar
- Theobald, J. Strategies for Testing Data Warehouse Applications Information Management, 2007.Google Scholar
Index Terms
- Data warehouse testing
Recommendations
An Approach for Testing the Extract-Transform-Load Process in Data Warehouse Systems
IDEAS '18: Proceedings of the 22nd International Database Engineering & Applications SymposiumThe Extract-Transform-Load (ETL) process in data warehousing involves extracting data from source databases, transforming it into a form suitable for research and analysis, and loading it into a data warehouse. ETL processes can use complex ...
A comprehensive approach to data warehouse testing
DOLAP '09: Proceedings of the ACM twelfth international workshop on Data warehousing and OLAPTesting is an essential part of the design life-cycle of any software product. Nevertheless, while most phases of data warehouse design have received considerable attention in the literature, not much has been said about data warehouse testing. In this ...
Alliance Rules for Data Warehouse Cleansing
ICSPS '09: Proceedings of the 2009 International Conference on Signal Processing SystemsData Cleansing is an activity performed on the data sets of data warehouse to enhance and maintain the quality and consistency of the data. This paper addresses the problems related with dirty data, entrance of dirty data and detection of dirty data in ...
Comments