Skip to main content
SpringerLink
Log in

Qualitative model to enhance quality of metadata for data warehouse

  • Original Research
  • Published:
International Journal of Information Technology Aims and scope Submit manuscript

Abstract

A metadata quality directly impact on the decision making. Therefore, the metadata is enhanced with semantics to improve quality of metadata but no formal representation is laid down. Here in this work, the formal representation of metadata is proposed to enhance the quality of information required for decision making. Therefore, in this paper three formal models are defined to properly manage metadata with different types of operation and to provide qualitative information to user. First is to define the metadata. Second is to describe metadata development process. Third model is used to formally describe the complete process of metadata management. All three models are used to properly representation and management of metadata.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Fig. 1
Fig. 2
Fig. 3
Fig. 4
Fig. 5
Fig. 6
Fig. 7
Fig. 8
Fig. 9
Fig. 10
Fig. 11

Similar content being viewed by others

References

  1. Parimala N, Vinay G (2011) Extended metadata for data warehouse schema. ENASE 254–259

  2. Thomas V, Anca V, Martin S (2000) Metadata standards for data warehousing: open information meta-model common warehouse meta-model, published ACM SIGMOD

  3. Anca V (2001) Metadata management for data warehousing: between vision and reality. In: IEEE, publish in database engineering and applications, international symposium, pp 129–135. https://doi.org/10.1109/ideas.2001.938079

  4. Guotong X, Yang Y, Shengping L, Zhaoming Q, Yue P, Xiongzhi Z (2010) EIAW: towards a business-friendly data warehouse using semantic web technologies. In: Published in the semantic web and 2nd Asian conference on Asian semantic web conference

  5. Veronika S, Beate L (2006) Business Metadata for data warehouse—weaving enterprise goals and models. IEEE Publ J Object Technol 4(2):41–48

    Google Scholar 

  6. Sarda NL (2006) Structuring business metadata in data warehouse systems for effective business support. In: Published in international enterprise object computing conference workshops, EDCOW’06 W

  7. George A, Papadopoulos, Wita W, Gregory W, Stanislaw W, JoeZupancic (2010) Metadata support for data warehouse evolution. In: Published in information systems development 2010

  8. Wua L, Millera L, Nilakanta S (2001) Design of data warehouses using metadata. Inf Softw Technol 43:109–119

  9. Katic N, Quirchmay G, Schiefer J, Stolba M, Tjoa AM (1998) A prototype model for data warehouse security based on metadata. In: Proceeding in ninth international workshop in database and expert systems applications

  10. Olbric S (2010) Warehousing and analyzing streaming data quality information. In: AMCIS 2010 Proceedings, p 159

  11. Munawar NS, Ibrahim R (2011) Towards data quality into the data warehouse development. In: 2011 Ninth IEEE international conference on dependable, autonomic and secure computing

  12. Răduţ Carmen (2013) The quality of data and metadata in a data warehouse. Manag Strateg J Constantin Brancoveanu Univ 19(1):36–40

    Google Scholar 

  13. Devillers R, Gervais M, Bédard Y, Jeansoulin R (2001) Spatial data quality: from metadata to quality indicators and contextual end-user manual. In: OEEPE/ISPRS Joint Workshop on Spatial Data Quality Management, 21–22 March 2002, Istanbul

  14. Aziz AA, Saman MYM, Hamzah MP (2011) Using metadata analysis and base analysis techniques in data qualities framework for data warehouses. Am J Econ Bus Admin 3(1):112–119

    Google Scholar 

  15. Yeoh W, Wang TW, Verbitskiy Y (2012) Describing data quality problem through a metadata framework. In: Proceedings of the Eighteenth Americas Conference on Information Systems, Seattle, Washington, August 9–12, 2012

  16. Shankaranarayanan G, Zhu B, Cai Y (2012) Decision support with data quality metadata. In: Proceeding of 45th Hawaii international conference on system sciences

  17. Mosig B, Röglinger M (2012) A metadata-based approach to leveraging the information supply of business intelligence systems. In: Proceeding of international conference on conceptual modeling ER 2012: conceptual modeling, pp 537–542

  18. Jarke M, Jeusfeld MA, Quix C, Vassiliadis P (1999) Architecture and quality in data warehouses: an extended repository approach. Inf Syst 24(3):229–253

    Article  Google Scholar 

  19. Daniel F, Casati F, Palpanas T, Chayka O (2008) Managing data quality in business intelligence applications. In: Proceedings of the VLDB Endowment, Auckland, New Zealand

  20. Rodic J, Baranovic M (2009) Generating data quality rules and integration into ETL process. In: Proceedings of the ACM twelfth international workshop on Data warehousing and OLAP. ACM: Hong Kong, pp 65–72

  21. Vassiliadis P, Bouzeghoub M, Quix C (1999) Towards quality-oriented data warehouse usage and evolution. In: Jarke M, Oberweis A (eds) Advanced information systems engineering. Springer, Heidelberg, pp 164–179

    Google Scholar 

  22. Li Y, Osei-Bryson KM (2010) Quality factory and quality notification service in data warehouse. In: Proceedings of the 3rd workshop on information and knowledge management. ACM, Toronto, pp 25–32

  23. Carneiro L, Brayner A (2002) X-META: a methodology for data warehouse design with metadata management. In: Proceedings of the 4th International Workshop DMDW, Toronto, Canada, DOI: Publications/CEUR-WS, pp 13–22

  24. Chong Q, Marwadi A, Supekar K, Lee Y (2003) Ontology based metadata management in medical domains. J Res Pract Inf Technol 35:139–154

    Google Scholar 

  25. Hauch R, Miller A, Cardwell R (2005) Information intelligence: metadata for information discovery, access and integration. In: Proceedings of ACM SIGMOD/Int’l Conf on Management of Data, Baltimore. https://doi.org/10.1145/1066157.1066250, pp 793–798

  26. Stöhr T, Muller R, Rahm E (1999) An integrative and uniform model for metadata management in data warehousing environments. In: Proceedings of international workshop on design and management of data warehouses (DMDW’99 at CAiSE99), Heidelberg, Germany, vol 19, pp 1–12. http://www.minet.uni-jena.de/dbis/lehre/ss2005/sem_dwh/lit/SMR99.pdf

  27. Pan D (2010) Metadata version management for DW 2.0 environment. J Converg Inf

  28. Vinay G, Parimala N (2012) E-Metadata versioning system for data warehouse schema. IJMSO 7(2):101–113

    Article  Google Scholar 

  29. Wrembel R, Bebel B (2005) Metadata management in a multi-version data warehouse. In: Proceedings of OTM Conferences, Agia Napa, Cyprus, Published in Springer, LNCS, vol 3761–2005, pp 1347–1364. https://doi.org/10.1007/11575801_26

Download references

Author information

Authors and Affiliations

  1. Thapar Institute of Engineering and Technology, Patiala, 147003, India

    Vinay Gautam

Authors
  1. Vinay Gautam
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Vinay Gautam.

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

Gautam, V. Qualitative model to enhance quality of metadata for data warehouse. Int. j. inf. tecnol. 12, 1025–1036 (2020). https://doi.org/10.1007/s41870-018-0222-0

Download citation

  • Received:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s41870-018-0222-0

Keywords

Search

Navigation