Title: Empirical study to predict the understandability of requirements schemas of data warehouse using requirements metrics

Authors: Tanu Singh; Manoj Kumar

Addresses: University School of Information and Communication Technology, Guru Gobind Singh Indraprastha University, Delhi – 110078, India ' Department of Computer Science and Engineering, Netaji Subhas University of Technology, East Campus (Formerly Ambedkar Institute of Advanced Communication Technologies and Research), Delhi – 110031, India

Abstract: Information quality of data warehouse is assessed by its data model quality. Various authors have proposed metrics for data models, that are designed to capture physical, conceptual, logical and requirements views of data warehouse. These metrics were validated not only formally but also empirically to assess quality of the respective data models. However, very less work was seen in the literature to assess quality of requirements model. Therefore, in this paper, an empirical validation of requirements metrics are performed to predict the understandability of requirements schemas of data warehouse using machine learning techniques (random forest and artificial neural network). Result shows that, artificial neural network technique performed better than random forest technique. In this way, effect of requirements metrics on understandability of schemas has been assessed, thus, good quality of requirements schema may be identified and help to the designers for producing better quality of conceptual schema.

Keywords: artificial neural network; data warehouse; requirements engineering; requirements metrics; requirements schemas understandability; Random forest.

DOI: 10.1504/IJIEI.2021.120317

International Journal of Intelligent Engineering Informatics, 2021 Vol.9 No.4, pp.329 - 354

Received: 21 Oct 2020
Accepted: 25 Apr 2021
Published online: 14 Jan 2022 *

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