Quality metrics emphasizing dimension hierarchy sharing in multidimensional models for data warehouse: a theoretical and empirical evaluation

Anjana Gosain () and Jaspreeti Singh ()
Additional contact information
Anjana Gosain: University School of Information and Communication Technology, Guru Gobind Singh Indraprastha University
Jaspreeti Singh: University School of Information and Communication Technology, Guru Gobind Singh Indraprastha University

International Journal of System Assurance Engineering and Management, 2017, vol. 8, issue 2, No 88, 1672-1688

Abstract: Abstract The quality of data warehouse (DW) depends largely on the multidimensional (MD) model quality. Few researchers have proposed metrics to evaluate the MD model quality based on facts, dimensions, hierarchy relationships, foreign keys, multiple hierarchies etc. However, some dimension hierarchy aspects like sharing of hierarchy levels within a dimension, sharing of hierarchy levels among various dimensions, relationship between dimension levels etc. have not been given due consideration. The aforementioned aspects may contribute to structural complexity of MD models, which in turn can affect its quality. Our previous study defined a set of quality metrics emphasizing dimension hierarchy sharing in MD models for DW. In this paper, we attempt to thoroughly validate a subset (six) of these metrics, theoretically as well as empirically. A careful study of the mathematical properties of defined metrics is done using Briand framework, which reveals that out of six metrics, two of them correspond to coupling measure, one metric is a cohesion measure and rest three are size/complexity measures. Further, an empirical validation consisting of Spearman’s Rho correlation analysis and linear regression analysis is conducted on 20 MD schemas and 28 subjects to determine the relationship between the metrics and understandability of MD models. The experimental study shows that four of our metrics are good indicators of understandability of MD models and can help in predicting the structural complexity of MD schemas for DW.

Keywords: Data warehouse quality; Multidimensional modeling; Metrics; Theoretical validation; Empirical validation (search for similar items in EconPapers)
Date: 2017
References: View references in EconPapers View complete reference list from CitEc
Citations:

Downloads: (external link)
http://link.springer.com/10.1007/s13198-017-0641-5 Abstract (text/html)
Access to the full text of the articles in this series is restricted.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:spr:ijsaem:v:8:y:2017:i:2:d:10.1007_s13198-017-0641-5

Ordering information: This journal article can be ordered from
http://www.springer.com/engineering/journal/13198

DOI: 10.1007/s13198-017-0641-5

Access Statistics for this article

International Journal of System Assurance Engineering and Management is currently edited by P.K. Kapur, A.K. Verma and U. Kumar

More articles in International Journal of System Assurance Engineering and Management from Springer, The Society for Reliability, Engineering Quality and Operations Management (SREQOM),India, and Division of Operation and Maintenance, Lulea University of Technology, Sweden
Bibliographic data for series maintained by Sonal Shukla () and Springer Nature Abstracting and Indexing ().