Title: On completeness and traceability metrics for data warehouse requirements engineering

Authors: Manoj Kumar; Anjana Gosain; Yogesh Singh

Addresses: Department of Computer Science and Engineering, Ambedkar Institute of Advanced Communication Technologies and Research, Geeta Colony, Delhi, 110031, India ' University School of Information Technology, Guru Gobind Singh Indraprastha University, Sector 16-C, Dwarka, New Delhi, 110075, India ' The Maharaja Sayajirao University of Baroda, Vadodara, 390002, Gujarat, India

Abstract: Due to increased complexity of data warehouse (DW), continuous attention must be paid for evaluation of quality throughout its design and development. The quality of models is one of the main factors that influence information quality of DW. In some earlier works, metrics or guidelines to assure the quality of conceptual, logical and physical models for DW were proposed. To the best knowledge of the authors, there is no significant work found in the literature that may assure quality of DW requirements model. In this paper, we present requirements completeness and traceability metrics to monitor the progress of DW requirements engineering (RE) products (i.e., requirements model) while using a particular approach. Here, in our case, our existing approach is being used for capturing DW requirements, in which, we capture requirements in terms of organisation model, decision model and information model. We have successfully applied our proposed metrics to these DW requirements models for a typical banking organisation.

Keywords: data warehousing; model quality; requirements engineering; completeness metrics; traceability metrics; banking industry; bank data warehouse.

DOI: 10.1504/IJCSYSE.2013.057213

International Journal of Computational Systems Engineering, 2013 Vol.1 No.4, pp.229 - 237

Published online: 26 Jul 2014 *

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