Title: Predicting quality of data warehouse using fuzzy logic

Authors: Anjana Gosain; Sangeeta Sabharwal; Sushama Nagpal

Addresses: University School of Information Technology, Guru Gobind Singh Indraprastha University, New Delhi - 06, India. ' COE Division, Netaji Subhas Institute of Technology, Sector - 3, Dwarka, New Delhi - 110078, India. ' COE Division, Netaji Subhas Institute of Technology, Sector - 3, Dwarka, New Delhi - 110078, India

Abstract: Due to strategic importance of data warehouse (DW) as decision support systems, it has become crucial to guarantee that these repositories should provide quality information to the decision makers. Quality of data warehouse multidimensional model has significant effect on data warehouse quality and in turn on the information quality. Few authors have suggested metrics to assess the quality of data warehouse multidimensional models. Empirical validation using statistical techniques like correlation analysis, univariate and multivariate regression techniques, etc., indicated that these metrics are significantly related to the quality of multidimensional models for data warehouse. But these techniques are not able to model non-linear relationship between the metrics and quality of multidimensional model. In this paper, model based on fuzzy logic approach is proposed to approximate non-linear relationship between the metrics and the quality of multidimensional models. In order to empirically evaluate the effectiveness of the proposed approach, validation is done on the published data and results indicate that the proposed model is able to predict the output with significant accuracy.

Keywords: data warehousing; DW; multidimensional modelling; fuzzy logic; quality metrics; decision support systems; DSS; information quality.

DOI: 10.1504/IJBSR.2012.047925

International Journal of Business and Systems Research, 2012 Vol.6 No.3, pp.255 - 268

Published online: 14 Nov 2014 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article