Abstract
During the last decades researches, Data Warehouse is mainly concentrated on Quality. The best approach to quality evaluation goes through determining effective metrics on schemas. However, this set of metrics contains some redundant metrics. Generally, PCA (Principal Component Analysis) is used for defining principal metrics in the domain. In this study, we used PCA for dimensionality reduction on a set of 41 schemas, and we find out that instead of seven metrics [3], only 3 metrics were extracted as principal components. Our empirical validation experiment showed us that three principal components out of seven proposed metrics [3] seem to be practical indicators of the Quality Model for Data Warehouses.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Calero, C., Piattini, M., Genero, M.: Developing quality complex database systems: practices, techniques & technologies. In: Metrics for Controlling Database Complexity, ch. III (2001)
Caro, A., Calero, C., Caballero, I., Piattini, M.: Defining a Data Quality Model for Web Portals. In: Aberer, K., Peng, Z., Rundensteiner, E.A., Zhang, Y., Li, X. (eds.) WISE 2006. LNCS, vol. 4255, pp. 363–374. Springer, Heidelberg (2006)
Calero, C., Piattini, M., Pascual, C., Serrano, M.A., Piattini, M., Genero, M., Calero, C., Polo, M., Ruiz, F.: Towards DW Quality metrics. In: Proceedings of the International Workshop on Design and Management of Data Warehouses (DMDW 2001) Interlaken, Switzerland (June 4, 2001); Foster, I., Kesselman, C.: The Grid: Blueprint for a New Computing Infrastructure. Morgan Kaufmann, San Francisco (1999)
Inmon, W.H.: Building the Data Warehouse, 3rd edn. John Wiley and Sons, USA (2003)
Serrano, M., Calero, C., Piattini, M.: An experimental replication with data warehouse metrics. International Journal of Data Warehousing & Mining 1(4), 1–21 (2005)
Sieniawski, P., Trawiński, B.: An Open Platform of Data Quality Monitoring for ERP Information Systems. In: IFIP Working Conference on Software Engineering Techniques - SET 2006, Warsaw, Poland (2006), http://www.ncbi.nlm.nih.gov
Signore, O.: Towards a Quality Model for Web Sites. In: CMG Conference, Warsaw, Poland (2005)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2012 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Gupta, R., Gosain, A. (2012). Validating Data Warehouse Quality Metrics Using PCA. In: Kannan, R., Andres, F. (eds) Data Engineering and Management. ICDEM 2010. Lecture Notes in Computer Science, vol 6411. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-27872-3_25
Download citation
DOI: https://doi.org/10.1007/978-3-642-27872-3_25
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-27871-6
Online ISBN: 978-3-642-27872-3
eBook Packages: Computer ScienceComputer Science (R0)