• Dr. J. Hamed Department Information Technology, Mansoura University, Egypt
  • Sahar Ahmed Al-Badani Department Information Technology, Mansoura University, Egypt


Data Warehouse is a collection of large amount of data which is used by the management for making strategic decisions. The data in a data warehouse is gathered from heterogeneous sources and then populated and queried for carrying out the analysis. The data warehouse design must support the queries for which it is being used for. The design is often an iterative process and must be modified a number of times before any model can be stabilized. The design life cycle of any product includes various stages wherein, testing being the most important one. Data warehouse design has received considerable attention whereas data warehouse testing is being explored now by various researchers. This paper discusses about various categories of testing activities being carried out in a data warehouse at different levels.


[1] Pooniah, P., 2001, “Data Warehousing Fundamentals – A Comprehensive Guide for IT Professionals”, John Wiley & Sons, Inc.
[2] Myers, Glenford J., 1979, “The art of software testing”, New York: Wiley, ISBN: 0471043281, xi, 177 p.
[3] Sneed M. Harry, 2006, “Testing a Data Warehouse – an Industrial Challenge”, in proceedings of the Testing:
Academic & Industrial Conference on Practice and Research Techniques, IEEE Computer, p. 203-210
[4] Sneed M. Harry, 2006, “Reengineering for Testability”, at workshop on Software Reengineering.
[5] Executive-MiH, “Data Warehouse Testing is different”.
[6] Theobald J., 2007, “http://www.information
[7] Breue T., 2010, “Turning data into Dollars”, XLNT Consulting.
[8] Brahmkshatriya K., 2007, “Data Warehouse Testing”, in
[9] Mathen M. P., 2010, “Data Warehouse Testing”, in
[10] Golfarelli M. and Rizzi S., 2009, “A Comprehensive Approach to Data Warehouse Testing”, in ACM 12th international workshop on Data Warehousing and OLAP (DOLAP’09), Hong Kong, China.
[11] Golfarelli M. and Rizzi S., 2011, “Data warehouse testing: A prototype-based metholdology”, on Information and Software Technology Journal, vol. 53, pp. 1183-1198.
[12] Ceres E., 2011, “Data Warehouse Testing: Why QA projects need Automation”, white paper published for Real-Time Technology Solutions.
[13] Mookerjea A. and Malisetty P., 2008, “Data Warehouse/ETL Testing: Best Practices”,
[14] Arbuckle S. and Cooper R., 2002, “How to thoroughly Test a Data Warehouse”, in Software Testing Analysis and Review (STAREAST), Orlando, Florida.
How to Cite
HAMED, Dr. J.; AL-BADANI, Sahar Ahmed. DATA WAREHOUSE TESTING APPROACHES. Universal Journal of Computers & Technology, [S.l.], v. 2, n. 2, p. 180-188, nov. 2017. ISSN 2456-2955. Available at: <>. Date accessed: 26 may 2018.


Data Warehouse, Data warehouse testing, Software Testing