Data warehouse process management

Abstract

− − − − Previous research has provided metadata models that enable the capturing of the static components of a data warehouse architecture, along with information on different quality factors over these components. This paper complements this work with the modeling of the dynamic parts of the data warehouse. The proposed metamodel of data warehouse operational processes is capable of modeling complex activities, their interrelationships, and the relationship of activities with data sources and execution details. Moreover, the metamodel complements the existing architecture and quality models in a coherent fashion, resulting in a full framework for quality-oriented data warehouse management, capable of supporting the design, administration and especially evolution of a data warehouse. Finally, we exploit our framework to revert the widespread belief that data warehouses can be treated as collections of materialized views. We have implemented this metamodel using the language Telos and the metadata repository system ConceptBase.

Research of Emergency Information Resourse Organization Based on Metadata

“…Therefore, metadata can be understood as: the process of data, data management, and the application of the structure and meaning of the description of data, and the goal is to provide a comprehensive guide to data resources. In addition metadata has been well developed and applied in the field of data storage and data warehouse [4][5][6][7].…”

A Survey: Data Warehouse Architecture

“…After these operations data is moved to target [9]. Then they used "warehouse control center" tool to create meta data ,which helps the administrator and developer to find data of their interest [10].After gathering interest information they used different OLAP tools to provide different dimension of data [7] and based on these different dimensions, decisions can be made.…”

Benefits of Knowledge Acquisition Systems for Management. An Empirical Study

“…The DW is developed in order to support the integration of external data sources ( [38]; [39]) for the purpose of advanced data analysis. [40 p. 35] argues that a DW produces tangible impacts to the quality of day-to-day business transactions.…”