Abstract
Data warehouses have been developed that stores information enabling the knowledge worker to make better and faster decisions. As a decision support information system, a data warehouse must provide high level quality of data and quality of service. Various metrics have been defined and theoretical validated to measure the quality of the data warehouse in a consistent and objective manner and if quality measured, it can be managed and improved. Now, in this paper we will use these design quality metrics and empirically validated these metrics by conducting an experiment using regression analysis and deriving the conclusions according to the analysis so that they can be used by researchers and users.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Serrano, M., Trujillo, J., Calero, C., Piattini, M.: Metrics for data warehouse conceptual models understandability. Information and Software Technology 49, 851–870 (2007)
Serrano, M.A.: Towards Data Warehouse Quality Metrics. In: Proceedings of the International Workshop on Design and Management of Data Warehouses (DMDW 2001), Interlaken, Switzerland (2001)
Si-said Cherfi, S., Prat, N.: Multidimensional Schemas Quality: Assessing and Balancing Analyzability and Simplicity. In: Jeusfeld, M.A., Pastor, Ó. (eds.) ER Workshops 2003. LNCS, vol. 2814, pp. 140–151. Springer, Heidelberg (2003)
Berenguer, G., Romero, R., Trujillo, J., Bilò, V., Piattini, M.: A Set of Quality Indicators and Their Corresponding Metrics for Conceptual Models of Data Warehouses. In: Tjoa, A.M., Trujillo, J. (eds.) DaWaK 2005. LNCS, vol. 3589, pp. 95–104. Springer, Heidelberg (2005)
Luján-Mora, S., Trujillo, J., Song, I.-Y.: Extending UML for multidimensional modeling. In: Jézéquel, J.-M., Hussmann, H., Cook, S. (eds.) UML 2002. LNCS, vol. 2460, pp. 290–304. Springer, Heidelberg (2002)
Trujillo, J., Palomar, M., Gómez, J., Song, I.-Y.: Designing Data Warehouses with OO Conceptual Models. IEEE Computer, Special issue on Data Warehouses 34, 66–75 (2001)
Serrano, M., Calero, C., Piattini, M.: Validating metrics for data warehouses. IEE Proceedings Software 149(5) (2002)
Piattini, M., Caballero, I., Genero, M., Calero, C.: Data Quality and Database Design (1999)
Kaiser, M., Klier, M., Heinrich, B.: How to Measure Data Quality – A Metric-Based Approach. In: ICIS Proceedings, Association for Information Systems (2007)
Luján-Mora, S.: Multidimensional Modeling using UML and XML, Universidad de Alicante, Spain (2001)
Abelló, A., Samos, J., Saltor, F.: YAM2 (Yet Another Multidimensional Model): An Extension of UML. In: International Database Engineering and Applications Symposium (IDEAS 2002), pp. 172–181. IEEE Computer Society, Edmonton (2002)
Vassiliadis, P., Bouzeghoub, M., Quix, C.: Towards Quality-Oriented Data Warehouse Usage and Evolution. In: Jarke, M., Oberweis, A. (eds.) CAiSE 1999. LNCS, vol. 1626, pp. 164–179. Springer, Heidelberg (1999)
Romero, R., Mazón, J.-N., Trujillo, J., Serrano, M.A., Piattini, M.: Quality of Data Warehouses. In: Encyclopedia of Database Systems (2009)
Peralta, V.: Data Warehouse Logical Design from Multidimensional Conceptual Schemas, Universidad de la República, Uruguay
Moody Daniel, L.: Theoretical and practical issues in evaluating the quality of conceptual models: current state and future directions. Data and Knowledge Engineering 44(3), 243–276 (2005)
Serrano, M.A., Calero, C., Sahraouni, H.A., Piattini, M.: Emprircal studies to assess the understandability of data warehouse schemas using structural metrics. Software Qual. J (2008)
Cruz-Lemus, J.A., Maes, A., Genero, M., Poels, G., Piattini, M.: The impact of structural complexity on the understandability of UML statechart diagrams. Inf. Sci. 180(11), 2209–2220 (2010)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2011 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Gupta, J., Gosain, A., Nagpal, S. (2011). Empirical Validation of Object Oriented Data Warehouse Design Quality Metrics. In: Wyld, D.C., Wozniak, M., Chaki, N., Meghanathan, N., Nagamalai, D. (eds) Advances in Computing and Information Technology. ACITY 2011. Communications in Computer and Information Science, vol 198. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-22555-0_33
Download citation
DOI: https://doi.org/10.1007/978-3-642-22555-0_33
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-22554-3
Online ISBN: 978-3-642-22555-0
eBook Packages: Computer ScienceComputer Science (R0)