Skip to main content
SpringerLink
Log in

Evaluation of Data Warehouse Quality from Conceptual Model Perspective

  • Conference paper
Advances in Intelligent Informatics

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 320))

  • 1869 Accesses

Abstract

Organizations are adopting Data Warehouse (DW) for making strategic decisions. DW consist of huge and complex set of data, thus its maintenance and quality are equally important. Using improper, misunderstood, disregarded data quality will highly impact the decision making process as well as its performance. The DW quality is depending on data model quality, DBMS quality and Data quality itself. In this paper, we have surveyed on two aspects of DW quality; one is how researchers have improved the quality of Data; and another is how data model quality is improved. The paper discusses that metrics are real quality indicators of DWs; they help the designers in obtaining good quality model that allows us to guarantee the quality of the DW. In this paper, our focus has been on surveying research papers with respect to quality of the multidimensional conceptual model of DW. Having surveyed various papers, we compared all the proposals concerning theoretical validation and empirical validation of conceptual model metrics for assessment of DW model quality.

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 169.00
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 219.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

  • Ali, K.B., Gosain, A.: Predicting the quality of object oriented multidimensional (OOMD) model of data warehouse using fuzzy logic technique. International Journal of Engineering Science & Advanced Technology 2(4), 1048–1054 (2012)

    Google Scholar 

  • Basili, V.R., Weiss, D.: A methodology for collecting valid software engineering data. IEEE Transactionson Software Engineering 10(6), 728–738 (1984)

    Article  Google Scholar 

  • Basili, V., Rombach, H.: The TAME project: Towards improvement oriented software environments. IEEE Transactions on Software Engineering 14(6), 728–738 (1988)

    Article  Google Scholar 

  • Berenguer, G., Romero, R., Trujillo, J., Bilò, V., Piattini, M.: A set of quality indicators and their corresponding metrics for conceptual models of data warehouse. In: Tjoa, A.M., Trujillo, J. (eds.) DaWaK 2005. LNCS, vol. 3589, pp. 95–104. Springer, Heidelberg (2005)

    Chapter  Google Scholar 

  • Briand, L., Morasca, S., Basili, V.: Property based software engineering measurement. IEEE Transactions on Software Engineering 22(1), 68–86 (1996)

    Article  Google Scholar 

  • Calero, C., Piattini, M., Genero, M.: Metrics for controlling database complexity. In: Becker (ed.) Chapter III in Developing Quality Complex Database Systems: Practices, Techniques and Technologies. Idea Group Publishing (2001b)

    Google Scholar 

  • Calero, C., Piattini, M., Pascual, C., Serrano, M.: Towards data warehouse quality metrics. In: Proceedings of the International Workshops on Design and Management of Data Warehouses, Interlaken, Switzerland (2001a)

    Google Scholar 

  • Chen, M., Song, M., Han, J., Haihong, E.: Survey on data quality. IEEE (2012)

    Google Scholar 

  • 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 

  • Gosain, A., Mann, S.: Empirical validation of metrics for object oriented multidimensional model for data warehouse. International Journal of System Assurance Engineering & Management (2013)

    Google Scholar 

  • Gosain, A., Sabharwal, S., Nagpal, S.: Neural network approach to predict quality of data warehouse multidimensional model. In: Proceedings of International Conference on Advances in Computer Science. ACEEE (2010)

    Google Scholar 

  • Gosain, A., Nagpal, S., Sabharwal, S.: Quality metric for conceptual models for data warehouse focusing on dimension hierarchies. ACM SIGSOFT Software Engineering Notes 36(4) (2011)

    Google Scholar 

  • Gosain, A., Nagpal, S., Sabharwal, S.: Validating dimension hierarchy metrics for the understandability of multidimensional models for data warehouse. IET Software 7(2), 93–103 (2013)

    Article  Google Scholar 

  • Gupta, J., Gosain, A., Nagpal, S.: Empirical validation of object oriented data warehouse design quality metrics. In: Wyld, D.C., Wozniak, M., Chaki, N., Meghanathan, N., Nagamalai, D. (eds.) ACITY 2011. CCIS, vol. 198, pp. 320–329. Springer, Heidelberg (2011)

    Chapter  Google Scholar 

  • Gupta, R., Gosain, A.: Analysis of Data warehouse quality metrics using LR. In: Das, V.V., Vijaykumar, R. (eds.) ICT 2010. CCIS, vol. 101, pp. 384–388. Springer, Heidelberg (2010)

    Chapter  Google Scholar 

  • Gupta, R., Gosain, A.: Validating data warehouse quality metrics using PCA. In: Kannan, R., Andres, F. (eds.) ICDEM 2010. LNCS, vol. 6411, pp. 170–172. Springer, Heidelberg (2012)

    Chapter  Google Scholar 

  • Inmon, W.H.: Building the Data Warehouse. John Wiley & Sons (1996)

    Google Scholar 

  • Kumar, M., Gosain, A., Singh, Y.: Empirical validation of structural metrics for predicting understandability of conceptual schemas for data warehouse. International Journal of System Assurance Engineering & Management (2013)

    Google Scholar 

  • Kimball, R., Ross, M.: The data warehouse toolkit. Wiley, New York (2002)

    Google Scholar 

  • Lee, Y.W., Strong, D.M., Kahn, B.K., Wang, R.Y.: AIMQ: A methodology for information quality assessment. Information and Management 40, 133–146 (2002)

    Article  Google Scholar 

  • Moody, D.L., Shanks, G.G.: Improving the quality of data models: Empirical validation of a quality management framework. Information System 28(6), 619–650 (2003)

    Article  MATH  Google Scholar 

  • Munawar, S.N., Ibrahim, R.: Towards data quality into the data warehouse development. In: IEEE Ninth International Conference on Dependable, Autonomic and Secure Computing (2011)

    Google Scholar 

  • Nagpal, S., Gosain, A., Sabharwal, S.: Complexity metric for multidimensional models for data warehouse. In: CUBE, ACM (2012)

    Google Scholar 

  • Nagpal, S., Gosain, A., Sabharwal, S.: Theoretical and empirical validation of comprehensive complexity metric for multidimensional models for data warehouse. International Journal of System Assurance Engineering & Management, 193–204 (2013)

    Google Scholar 

  • Nelson, H.J., Poels, G., Genero, M., Piattini, M.: A Conceptual modeling quality framework. Software Quality Journal 20, 201–228 (2012)

    Article  Google Scholar 

  • Poels, G., Dedene, G.: DISTANCE: A framework for software measure construction. research report DTEW9937, Dept. Applied economics, Katholieke Universiteit Leuven, Belgium, p. 46 (1996)

    Google Scholar 

  • Santos, G.D., Takaoka, H., de Souza, C.A.: An empirical investigation of the relationship between information quality and individual impact in organizations. In: AMCIS Proceedings (2010)

    Google Scholar 

  • Serrano, M., Calero, C., Piattini, M.: Validating metrics for data warehouse. IEEE Proceedings 149(5) (2002)

    Google Scholar 

  • Serrano, M., Calero, C., Piattini, M.: Experimental validation of multidimensional data model metrics. In: Proceedings of the 36th Hawaii International Conference on System Sciences (2003)

    Google Scholar 

  • Bilò, V., Calero, C., Trujillo, J., Luján-Mora, S., Piattini, M.: Empirical validation of metrics for conceptual models of data warehouses. In: Persson, A., Stirna, J. (eds.) CAiSE 2004. LNCS, vol. 3084, pp. 506–520. Springer, Heidelberg (2004)

    Chapter  Google Scholar 

  • Serrano, M.: Definition of a set of metrics for assuring data warehouse quality. University of castilla, La Mancha (2004)

    Google Scholar 

  • 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 

  • Serrano, M., Calero, C., Sahraoui, H.A., Piattini, M.: Empirical studies to assess the understandability of data warehouse schema using structural metrics. Software Quality Journal 16, 79–106 (2008)

    Article  Google Scholar 

  • Sidi, F., Ramli, A., Jabar, M.A., Affendey, L.S., Mustapha, A., Ibrahim, H.: Data Quality Comparative Model for data warehouse. IEEE (2012)

    Google Scholar 

  • Si-said Cherfi, S., Akoka, J., Comyn-Wattiau, I.: Conceptual modeling quality- from EER to UML schemas evaluation. In: Spaccapietra, S., March, S.T., Kambayashi, Y. (eds.) ER 2002. LNCS, vol. 2503, pp. 414–428. Springer, Heidelberg (2002)

    Chapter  Google Scholar 

  • Tryfona, N., Busborg, F., Christiansen, J.G.B.: starER: A conceptual model for data warehouse design. In: Proceedings of the Second ACM International Workshop on Data Warehousing and OLAP, pp. 3–8. ACM (1999)

    Google Scholar 

  • Zuse, H.: A Framework of Software Measurement. Walter de Gruyter (1998)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Guru Gobind Singh Inderaprastha University, Delhi, India

    Rakhee Sharma, Hunny Gaur & Manoj Kumar

Authors
  1. Rakhee Sharma
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Hunny Gaur
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Manoj Kumar
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. King Fahd University of Petroleum and Minerals, Dhahran, Saudi Arabia

    El-Sayed M. El-Alfy

  2. Indian Institute of Information Technology and Management- - Kerala (IIITM-K), Trivandrum, Kerala, India

    Sabu M. Thampi

  3. Faculty of Design, Kyushu University, Fukuoka, Japan

    Hideyuki Takagi

  4. Department of Information Systems and Operations Management, University of Florida, Warrington College of Business, Florida, Florida, USA

    Selwyn Piramuthu

  5. University of Applied Sciences, Institute for Information Systems, Olten, Switzerland

    Thomas Hanne

Rights and permissions

Reprints and permissions

Copyright information

© 2015 Springer International Publishing Switzerland

About this paper

Cite this paper

Sharma, R., Gaur, H., Kumar, M. (2015). Evaluation of Data Warehouse Quality from Conceptual Model Perspective. In: El-Alfy, ES., Thampi, S., Takagi, H., Piramuthu, S., Hanne, T. (eds) Advances in Intelligent Informatics. Advances in Intelligent Systems and Computing, vol 320. Springer, Cham. https://doi.org/10.1007/978-3-319-11218-3_47

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-11218-3_47

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-11217-6

  • Online ISBN: 978-3-319-11218-3

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics

Search

Navigation