CFP last date
20 May 2024
Call for Paper
June Edition
IJCA solicits high quality original research papers for the upcoming June edition of the journal. The last date of research paper submission is 20 May 2024

Submit your paper
Know more
The week's pick
Responsive image
Enhancing Privacy Preservation: Multi-Attribute Protection with P-Sensitive K-Anonymity

Twinkle Patel Kiran Amin
Random Articles
Reseach Article

Validation of Object Oriented Metrics for Evaluating Understandability of Data Warehouse Models

by Jaspreeti Singh, Srishti Vashishtha
journal cover thumbnail

International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 118 - Number 13
Year of Publication: 2015
Authors: Jaspreeti Singh, Srishti Vashishtha
10.5120/20806-3512

Jaspreeti Singh, Srishti Vashishtha . Validation of Object Oriented Metrics for Evaluating Understandability of Data Warehouse Models. International Journal of Computer Applications. 118, 13 ( May 2015), 26-33. DOI=10.5120/20806-3512

@article{ 10.5120/20806-3512,
author = { Jaspreeti Singh, Srishti Vashishtha },
title = { Validation of Object Oriented Metrics for Evaluating Understandability of Data Warehouse Models },
journal = { International Journal of Computer Applications },
issue_date = { May 2015 },
volume = { 118 },
number = { 13 },
month = { May },
year = { 2015 },
issn = { 0975-8887 },
pages = { 26-33 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume118/number13/20806-3512/ },
doi = { 10.5120/20806-3512 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T23:01:36.732946+05:30
%A Jaspreeti Singh
%A Srishti Vashishtha
%T Validation of Object Oriented Metrics for Evaluating Understandability of Data Warehouse Models
%J International Journal of Computer Applications
%@ 0975-8887
%V 118
%N 13
%P 26-33
%D 2015
%I Foundation of Computer Science (FCS), NY, USA
Abstract

Datawarehouse has a key role in formulating strategic decisions thus it is very essential to maintain its quality. Metrics have been generally used to direct designers to develop quality data models. Numerous researchers have proposed metrics for multidimensional models for datawarehouse. These metrics are required to be empirically validated to prove their practical utility. Empirical validation of the object oriented metrics for multidimensional models for data warehouses at a conceptual level is presented in the paper. Quality attribute understandability is assessed through various combinations of metrics. Univariate and Multiple linear regression analysis have been used in this paper for computing the multidimensional models quality. The results show that these metrics may be considered as key indicators for quality of multidimensional data models.

References
  1. V. R. Basili, F. Shull and F. Lanubille. Building Knowledge through families of experiments. IEEE Transactions on Software Engineering. No. 4. 456-473, July/August, 1999.
  2. L. C. Briand, S. Morasca and V. Basili. Propertybased software engineering measurement. IEEE Transactions on Software Engineering. 22(1). 68-85, 1996.
  3. Calero C. , Piattini M. , Pascual C. , Serrano, M. A. (2001), "Towards Data warehouse quality metrics. In 3rd International workshop on design and Management of Data warehouses (DMDW 2001), Interlaken, Switzerland.
  4. Inmon,, W. H. (1997), "Building Data warehouse", John Wiley & sons.
  5. Fenton N. (1994), "Software measurement: a necessary scientific basis," IEEE Transactions on Software Engineering, Vol. 20, 1994, pp. 199-206.
  6. GARDNER, S. R. : 'Building the data warehouse', Comnzun. ACM, September 1998,41, (9), pp. 52-60.
  7. Gupta SL, Kumar V (2011) Statistical mechanics. Pragati prakashan, Meeru [GS11] Gosain A, Nagpal S, Sabharwal S, "Quality Metrics for Conceptual Models for Data Warehouse focusing on Dimension Hierarchies'' July 2011 ACM SIGSOFT.
  8. Gosain A, Mann S (2013) ''Empirical validation of metrics for object oriented multidimensional model for data warehouse'', Springer Int J Syst Assur Eng Manag.
  9. Gosain A , Nagpal S , Sabharwal S, Validating dimension hierarchy metrics for the understandability of multidimensional models for data warehouse.
  10. R. Kimball, L. Reeves, M. Ross and W. Thornthwaite. The Data Warehouse LifecycleToolkit, John Wiley and Sons, 1998.
  11. Kumar M, Gosain A, Singh Y, Empirical validation of structural metrics for predicting understandability of conceptual schemas for data warehouse.
  12. Serrano M. , Calero C. , Piattini M. (2002), "Validating metrics for data warehouses", IEE Proceedings SOFTWARE 149, 161–166.
  13. Serrano M, Calero M, Piattini M (2003) ''Experimental Validation of Multidimensional Data Models Metrics'', IEEE Proceedings of the 36th Hawaii International Conference on System Sciences – 2003.
  14. Serrano MA, Calero C, Trujillo J, Lujan S, Piattini M (2004) ''Empirical validation of metrics for conceptual models of data warehouse. '' Lecture Notes Comput Sci 3084:506–520 (Caise2004).
  15. Serrano M. , Trujillo j, Calero C. , Piattini M. (2007), "Metrics for data warehouse conceptual models understandability",Journal of Information and Software Technology49, 851-870.
  16. Serrano M, Calero C, Sahraoui HA, Piattini M (2008) ''Empirical studies to assess the understandability of data warehouse schemas using structural metrics. '' Softw Qual J Springer 16:79–106.
  17. E. J. Weyuker. Evaluating software complexity measures. IEEE Transactions on Software Engineering. 14(9). 1357-1365, 1988.
  18. H. Zuse. A Framework of SoftwareMeasurement. Walter de Gruyter, 1998.
Index Terms

Computer Science
Information Sciences

Keywords

Datawarehouse Metrics Multidimensional models Quality attributes

Powered by PhDFocusTM