Open Access
The Role of Metadata for Data Warehousing
TLDR
It turns out that an overall solution for managing all metadata in a central or federated repository is still missing regarding a global metadata schema as well as system aspects and interoperability among involved tools producing metadata.Abstract:
Metadata has been identified as a key success factor in data warehouse projects. It captures all kinds of information necessary to extract, transform and load data from source systems into the data warehouse, and afterwards to use and interpret the data warehouse contents. This paper gives an overview about the role metadata plays for data warehousing and reviews existing standards, commercial solutions and research actions relevant to metadata management. It turns out that an overall solution for managing all metadata in a central or federated repository is still missing regarding a global metadata schema as well as system aspects and interoperability among involved tools producing metadata. The divergence of proposed standards will probably prevent a breakthrough within the near future.read more
Citations
More filters
Proceedings ArticleDOI
DWARF: an approach for requirements definition and management of data warehouse systems
F.R.S. Paim,J.F.B. de Castro +1 more
TL;DR: The traditional requirements engineering process is adapted and DWARF, a data warehouse requirements definition method is proposed, which has been successfully applied in the company wise development of a large-scale data warehouse system that stores hundreds of gigabytes of strategic data for the Brazilian Federal Revenue Service.
On Metadata Interoperability in Data Warehouses
Hong Hai Do,Erhard Rahm +1 more
TL;DR: This work categorizes the major metadata types and their interdependencies within a three-dimensional classification approach and investigates how interoperability and integration of metadata can be achieved based on a federated metadata architecture and standardization efforts such as OIM and CWM.
Journal ArticleDOI
Metadata management for data warehousing: an overview
Anca Vaduva,Thomas Vetterli +1 more
TL;DR: It turns out that an overall solution for managing all metadata in a central or federated repository is still missing regarding a global metadata schema as well as system aspects and interoperability among involved tools producing metadata.
Proceedings ArticleDOI
Metadata management for data warehousing: between vision and reality
A. Vaduva,K.R. Dittrich +1 more
TL;DR: The paper summarizes the most important issues of metadata management for data warehousing, including the role of metadata and solved and unsolved problems of the available solutions.
References
More filters
Book
The Unified Modeling Language User Guide
TL;DR: In The Unified Modeling Language User Guide, the original developers of the UML provide a tutorial to the core aspects of the language in a two-color format designed to facilitate learning.
Journal ArticleDOI
A framework for information systems architecture
TL;DR: Information systems architecture is defined by creating a descriptive framework from disciplines quite independent of information systems, then by analogy specifies information systems architecture based upon the neutral, objective framework.
Book
Building the data warehouse
TL;DR: This Second Edition of Building the Data Warehouse is revised and expanded to include new techniques and applications of data warehouse technology and update existing topics to reflect the latest thinking.
Journal ArticleDOI
CYC: a large-scale investment in knowledge infrastructure
TL;DR: The fundamental assumptions of doing such a large-scale project are examined, the technical lessons learned by the developers are reviewed, and the range of applications that are or soon will be enabled by the technology is surveyed.