Abstract
Metrics have been popularly used to guide designers to develop quality data models. Researchers have proposed metrics for multidimensional models for data warehouses. These metrics need to be empirically validated to prove their practical utility. This paper presents the empirical validation of the metrics for multidimensional models for data warehouses at conceptual level. Quality attributes namely, understandability and efficiency are evaluated through various combinations of metrics. Multiple linear regression analysis has been used in this paper for predicting the multidimensional models quality. The results show that these metrics may be considered as solid indicators for quality of multidimensional data models. Finally, accuracy of our models in predicting the multidimensional models’ quality is evaluated.
Similar content being viewed by others
References
Abello A, Samos J, Saltor F (2002) “YAM (yet another multidimensional model): an extension of UML”, international database engineering and applications symposium (IDEAS 2002). IEEE computer society, Edmonton (Canada), pp 172–181
Ali KB, Gosain A (2012) Predicting the quality of object-oriented multidimensional (OOMD) model of data warehouse using decision tree technique. Int J Sci Eng Res :1–5
Arora D, Khanna K, Tripathi A, Sharma S, Shukla S (2011) Software quality estimation through object oriented design metrics. Int J Comput Sci Netw Secur 11(4)
Berenguer G, Romero R, Truijillo J, Piattini M (2005) A set of quality indicators and their corresponding metrics for conceptual models of data warehouses. Springer, Berlin, pp 95–104
Booch G, Maksimchuk RA et al (2009) Object oriented analysis and design with applications. Pearson education, New Delhi
Booch G, Rumbaugh J, Jacobson I (1999) The unified modeling language–user guide. Pearson Education India, New Delhi
Calero C, Piattini M, Pascual C, Serrano MA (2001) Towards data warehouse quality metrics. In: Abstract of the 3rd international workshop on design and management of data warehouses (DMDW’2001), Interlaken Switzerland, pp 1–10
Dandrade R, Dart J (1990) The interpretation of r versus r2 or why percent of variance accounted for Is a poor measure of size effect. J Quant Anthropol 2:47–59
Daniel LM (2005) Theoretical and practical issues in evaluating the quality of conceptual models: current state and future directions. Data Knowl Eng 55:243–276
de Borba SFP (2005) Extending the UML for dimensional models in object-oriented database. In Proceedings of sixteenth international workshop on database and expert systems applications. IEEE, pp 1150–1154
Golfarelli M, Maio D, Rizzi S (1998) The dimensional fact model: a conceptual model for data warehouses. Int J Coop Inform Syst 7:215–227
Gosain A, Sabharwal S, Nagpal S (2010) Neural network approach to predict quality of data warehouse multidimensional model. In: Proceeding of international conference on advance in computer science, pp 241–244
Gosain A, Sabharwal S, Nagpal S (2011a) Assessment of quality of data warehouse multidimensional model. Int J inform qual 2:344–357
Gosain A, Sabharwal S, Nagpal S (2011b) Quality metrics for conceptual models for data warehouse focusing on dimension hierarchies. ACM SIGSOFT 36:1–5 Software engineering notes
Gupta SL, Kumar V (2011) Statistical mechanics. Pragati prakashan, Meerut
Inmon WH (2005) Building the data warehouse, 4th edn. Wiley, Indianapolis
Khan RA, Mustafa K, Ahson SI (2007) An empirical validation of object oriented design quality metrics. Comput inform sci 19:1–16
Konovalov A (2002) Object–oriented data model for data warehouse. Springer, Heidelberg, pp 319–325
Mario M, Piattini M, Calero C (2001) Assurance of conceptual data model quality based on early measures. In: Quality Software. Proceeding of Second Asia-Pacific Conference, pp 97–103
Moody DL, Shank GG (2003) Improving the quality of data models: empirical validation of quality management framework. Int J Inform Syst 28:619–650
Nelson HJ, Poels G, Genero M, Piattini M (2012) A conceptual modeling quality framework. Softw Qual J 20:201–228
Samira SS, Prat N (2003) Multidimensional schemas quality: assessing and balancing analyzability and simplicity. Springer LNCS 2814:140–151 ER workshop
Sapia C, Blaschka M, Hofling G, Dinter B (1998) Extending the E/R model for the multidimensional model paradigm, 1st international workshop on data warehouse and data mining. Springer, Singapore, pp 105–116
Serrano M, Calero C, Piattini M (2002) Validating metrics for data warehouse. IEEE Proc Softw Assoc BCS 149(5):161–166
Serrano M, Calero C, Piattini M (2003) Experimental validation of multidimensional data models metrics. Proceedings in IEEE Hawaii international conference on system sciences 2003
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)
Serrano M, Calero C, Piattini M (2005) An experimental replication with warehouse metrics. Int J Data Wareh Min 1(4):1–21
Serrano MA, Truijillo J, Calero C, Piattini M (2007) Metrics for data warehouse conceptual models understandability, information and software technology (INFSOF). Elsevier 49(8):851–870
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
Shaik A, Reddy CRK, Manda B, Prakashini C, Deepthi K (2010) An empirical validation of object oriented design metrics in object oriented systems. J Emerg Trends Eng Appl Sci 1(2):216–224
Soni D, Srivastava R, Kumar M (2009) A framework for validation of object oriented design metrics. Int J Comput Sci Netw Secur 6(3):46–52
Trujillo J (2000) The gold model: “An object oriented multidimensional data model for multidimensional databases”. pp 24–30
Trujillo J (2002) Extending the UML for multidimensional modeling. In: The unified modeling language. Lecture notes in computer science, vol 2460. Springer, pp 290–304
Tryfona N, Busborg F, Christiansen J (1999) starER: a conceptual model for data warehouse design, ACM 2nd international workshop on data warehousing and OLAP (DOLAP’99). ACM, Miissouri (USA), pp 3–8
Author information
Authors and Affiliations
Corresponding author
Rights and permissions
About this article
Cite this article
Gosain, A., Mann, S. Empirical validation of metrics for object oriented multidimensional model for data warehouse. Int J Syst Assur Eng Manag 5, 262–275 (2014). https://doi.org/10.1007/s13198-013-0155-8
Received:
Revised:
Published:
Issue Date:
DOI: https://doi.org/10.1007/s13198-013-0155-8