CFP last date
20 June 2024
Call for Paper
July Edition
IJCA solicits high quality original research papers for the upcoming July edition of the journal. The last date of research paper submission is 20 June 2024

Submit your paper
Know more
Reseach Article

Test Case Design using Black Box Testing Techniques for Data Mart

by Payal Pahwa, Renu Miglani
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 109 - Number 3
Year of Publication: 2015
Authors: Payal Pahwa, Renu Miglani

Payal Pahwa, Renu Miglani . Test Case Design using Black Box Testing Techniques for Data Mart. International Journal of Computer Applications. 109, 3 ( January 2015), 18-22. DOI=10.5120/19169-0636

@article{ 10.5120/19169-0636,
author = { Payal Pahwa, Renu Miglani },
title = { Test Case Design using Black Box Testing Techniques for Data Mart },
journal = { International Journal of Computer Applications },
issue_date = { January 2015 },
volume = { 109 },
number = { 3 },
month = { January },
year = { 2015 },
issn = { 0975-8887 },
pages = { 18-22 },
numpages = {9},
url = { },
doi = { 10.5120/19169-0636 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
%0 Journal Article
%1 2024-02-06T22:43:50.173360+05:30
%A Payal Pahwa
%A Renu Miglani
%T Test Case Design using Black Box Testing Techniques for Data Mart
%J International Journal of Computer Applications
%@ 0975-8887
%V 109
%N 3
%P 18-22
%D 2015
%I Foundation of Computer Science (FCS), NY, USA

Data Warehouse is a logical stockroom which accumulates and maintains enormous volume of data. It is very important for the enterprise that needs to analyze data obtained from heterogeneous sources to take tactical decisions. Any enterprise that wants to expand, survive and beat out the competition must have control over data. Any error or inconsistency in the data may lead to improper decision which may cause immense losses to enterprise. Data Warehouse testing is carried out to eliminate the errors and inconsistencies that arise due to data being collected from desperate sources in different formats. Data Warehouse testing is too expensive and time consuming practice as exhaustive testing is not possible. Therefore the concept of Data Mart comes into existence. Data Mart is a specialized subset of Data Warehouse which fulfills the data requirement of a specific group. Testing of a Data Mart is much easier and manageable process as compared to testing of a Data Warehouse. In order to test the data mart, there are a number of strategies that allow us to select a set of test cases and test data which are very effective in detecting errors. In our paper we have discussed black box and white box testing techniques concerning Data Mart in brief. We have explored black box techniques to select test cases as they have systematic approach to uncover a great number of errors. We have also proposed to design the test cases using Boundary Value Analysis, Equivalence Class Partitioning and the combination of both techniques. The test cases designed using these techniques are very successful to detect previously undetected errors or faults in a Data Mart. These are also proficient for testing the worst case and robustness of Data Mart.

  1. Eiad Basher Alhyasat, Al-Salt, Jordan and Mahmoud Al-Dalahmeh, "Data Warehouse Success and Strategic Oriented Business Intelligence: A Theoretical Framework", Journal of Management Research, Vol. 5, No. 3, 2013.
  2. W. H. Inmon, "Building the Data Warehouse", John Wiley and Sons, Second Edition, March 27, 1996.
  3. Manoj Philip Mathen, " Data Warehouse Testing", Developer IQ Magizine, Infosys Technologies Limited, Mar 2010,
  4. Payal Pahwa and Renu Miglani, "Domain Level Analysis of Data Mart Quality Factors along with Best-fit Tests to minimize defects", International Journal of Engineering Sciences Paradigms and Researches, Vol. 02, Issue 01, December 2012.
  5. Neveen ElGamal, Ali, El BastaWissy and GalalGalal-Edeen,"Towards a Data Warehouse Testing Framework" , Ninth International Conference on ICT and Knowledge Engineering, 2011.
  6. Rajib Mall, Fundamentals of Software Engineering, PHI, 2nd Edition, 2008.
  7. Mohd. Ehmer Khan , Farmeena Khan "A Comparative Study of White Box, Black Box and Grey Box Testing Techniques ", International Journal of Advanced Computer Science and Applications, Vol. 3, No. 6, 2012.
  8. Vineta Arnicane, " Complexity of Equivalence Class and Boundary Value Testing Methods", Computer Science and Information Technologies" ,Vol 751, 2009.
  9. Mats Grindal, Jeff Offutt, Sten F. Andler, "Combination Testing Strategies: A Survey", GMU Technical Report ISE-TR-04-05, July 2004.
Index Terms

Computer Science
Information Sciences


Data Warehouse Data Mart Data Mart testing Black box testing technique White box testing technique Equivalence class partitioning Boundary value analysis