Title: An empirical experimentation towards predicting understandability of conceptual schemas using quality metric

Authors: Naveen Dahiya; Vishal Bhatnagar; Manjeet Singh

Addresses: CSE Department, MSIT, C-4, Janakpuri, New Delhi, India ' CSE Department, AIACT & R, Geeta Colony, Delhi, India ' CE Department, YMCAUST, Sector-6, Faridabad, Haryana, India

Abstract: Data warehouse are used in organisations for efficient information delivery. The quality of a data warehouse is governed by the quality of conceptual, logical and physical data models. Conceptual model forms the base for design of logical/physical models. The conceptual model quality is assessed using quality metrics. The metrics for assessing the quality of conceptual schemas are based on size/structural complexity of schemas. Various statistical techniques show the existence of significant relationship between quality metrics and understanding time of conceptual models. In this paper, the authors analyse the ability of quality metrics in predicting the understandability of conceptual schemas using experimental empirical approach. Various statistical techniques are used for study and analysis. The results of empirical analysis show that few of the metrics are strong indicators for predicting the understandability of conceptual multidimensional models.

Keywords: empirical validation; quality metrics; conceptual models; understandability; data warehouses; model quality; multidimensional modelling.

DOI: 10.1504/IJBDI.2015.067564

International Journal of Big Data Intelligence, 2015 Vol.2 No.1, pp.9 - 22

Received: 04 Jun 2014
Accepted: 22 Aug 2014

Published online: 21 Mar 2015 *

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