Skip to main content
SpringerLink
Log in

Empirical Validation of Object Oriented Data Warehouse Design Quality Metrics

  • Conference paper
Advances in Computing and Information Technology (ACITY 2011)

Part of the book series: Communications in Computer and Information Science ((CCIS,volume 198))

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 to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Serrano, M., Trujillo, J., Calero, C., Piattini, M.: Metrics for data warehouse conceptual models understandability. Information and Software Technology 49, 851–870 (2007)

    Article  Google Scholar 

  2. 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)

    Google Scholar 

  3. 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)

    Chapter  Google Scholar 

  4. 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)

    Chapter  Google Scholar 

  5. 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)

    Chapter  Google Scholar 

  6. 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)

    Google Scholar 

  7. Serrano, M., Calero, C., Piattini, M.: Validating metrics for data warehouses. IEE Proceedings Software 149(5) (2002)

    Google Scholar 

  8. Piattini, M., Caballero, I., Genero, M., Calero, C.: Data Quality and Database Design (1999)

    Google Scholar 

  9. Kaiser, M., Klier, M., Heinrich, B.: How to Measure Data Quality – A Metric-Based Approach. In: ICIS Proceedings, Association for Information Systems (2007)

    Google Scholar 

  10. Luján-Mora, S.: Multidimensional Modeling using UML and XML, Universidad de Alicante, Spain (2001)

    Google Scholar 

  11. 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)

    Chapter  Google Scholar 

  12. 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)

    Chapter  Google Scholar 

  13. Romero, R., Mazón, J.-N., Trujillo, J., Serrano, M.A., Piattini, M.: Quality of Data Warehouses. In: Encyclopedia of Database Systems (2009)

    Google Scholar 

  14. Peralta, V.: Data Warehouse Logical Design from Multidimensional Conceptual Schemas, Universidad de la República, Uruguay

    Google Scholar 

  15. 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)

    Article  Google Scholar 

  16. 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)

    Google Scholar 

  17. 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)

    Article  MathSciNet  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. University School of Information Technology, GGS Indraprastha University, Delhi, India

    Jaya Gupta & Anjana Gosain

  2. Computer Engineering Dept, Netaji Subhash Institute of Technology, Delhi, India

    Sushama Nagpal

Authors
  1. Jaya Gupta
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Anjana Gosain
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Sushama Nagpal
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Southeastern Louisiana University, 70402, Hammond, LA, USA

    David C. Wyld

  2. Chair of Systems and Computer Networks, Wroclaw University of Technology, Wybrzeze Wyspianskiego 27, 50-370, Wroclaw, Poland

    Michal Wozniak

  3. University of Calcutta, Calcutta, India

    Nabendu Chaki

  4. Jackson State University Jackson, 39217, MS, USA

    Natarajan Meghanathan

  5. Wireilla Net Solutions PTY Ltd, Melbourne, Victoria, Australia

    Dhinaharan Nagamalai

Rights and permissions

Reprints 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)

Publish with us

Policies and ethics

Search

Navigation