Data Warehouse Metadata Management: Ensuring Data Quality and Governance
In an age defined by the abundance of data, organizations face the formidable task of not only collecting but also extracting valuable insights from diverse sources of information. Data warehousing, a critical component of modern data management, emerges as a strategic solution to this challenge. This abstract provides a concise overview of the concept, significance, and primary features of data warehousing.
A data warehouse is a centralized repository that facilitates the collection, storage, and management of data from multiple sources. Unlike operational databases, which are designed for transactional processing, data warehouses are tailored for analytical purposes. They serve as a dedicated platform for data consolidation, transformation, and the provision of a consistent, accessible dataset.
The principal objective of a data warehouse is to offer a comprehensive and unified view of an organization's data, enabling decision-makers to extract valuable insights, detect trends, and make informed, data-driven decisions. As a cornerstone of business intelligence and analytics, data warehouses empower organizations to convert their data assets into a competitive advantage.
Metadata Coalition: Proposal for version 1.0 metadata interchange specification. http://www.metadata.org/standards/toc.html, July 1996.
M. Jarke, M.A. Jeusfeld, C. Quix, P. Vassiliadis. Architecture and quality in data warehouses. In Proc. 10th Conference on Advanced Information Systems Engineering (CAiSE '98), pp. 93-113, Pisa, Italy, June, 8-12, 1998. Lecture Notes in Computer Science, vol. 1413, Springer, 1998.
Foundations of Data Warehouse Quality (DWQ) homepage. Available at http://www.dblab.ece.ntua.gr/~dwq/
M. Jarke, M.A. Jeusfeld, C. Quix, P. Vassiliadis. Architecture and quality in data warehouses. Information Systems, vol. 24, no. 3, pp. 229-253, May 1999. Elsevier Science Ltd. ISSN 0306-4379.
Katic, N.; Quirchmayr, G.; Schiefer, J.; Stolba, M.; Tjoa, A M.: A Prototype Model for Data Warehouse Security Based on Metadata. Proceedings DEXA 98.
Ken Orr, Data Warehousing Technology, The Ken Orr Institute, A white paper, 1996.
M. Wu, A. P. Buchmann, Research Issues in Data Warehousing, BTW 1997: 61-82.
O. Mangisengi, A M. Tjoa, R. R. Wagner, Metadata for Data Warehouses Using Extended Relational Models Proc. of third IEEE Computer Society Metadata Conference, April 1999.
Que, The Official Client/Server Computing Guide to Data Warehousing, Que Books, 1997.
Thanh N. Huynh, Oscar Mangisengi, and A Min Tjoa, Metadata for Object-Relational Data Warehouse, Vienna University of Technology, Proceedings of the International Workshop on Design and Management of Data Warehouses (DMDW'2000) Stockholm, Sweden, 2000.
Copyright (c) 2023 International Journal of Engineering and Computer Science

This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.