Font Size: a A A

Research And Application Of The Metadata Management System In The Data Warehouse

Posted on:2012-10-02Degree:MasterType:Thesis
Country:ChinaCandidate:J ChenFull Text:PDF
GTID:2248330377452745Subject:Computer Science and Technology
Abstract/Summary:PDF Full Text Request
Nowadays many industry enterprise are gradually realize, skilled, effective use from the information getting from enterprise internal is the key to realize performance excellence. And they say that, a lot of data gold mine in fact are all hidden in the base of operations, if they are dug out, can in mixed competition slightly better.Now many enterprises have established more and more business information systems to collect the different levels and aspects of the enterprise internal information. With the data warehouse technology of constant exploration, development and application, many enterprises in the hope of exploring much deeper data value.they built or are to establish the data warehouse project to collect and integrate their business data.But, from the whole industry, a lot of these projects are failed to made substantial breakthrough and victory. Investigate its reason, mainly because of poor quality data restricted the analysis method of value play. And improve data quality must first guarantee the correctness of the data, clarity, integrity, and consistency, that is, to ensure that the data attributes of the quality. This allows people to get to know the importance of metadata management and use, and began to spend more and more resources exploring metadata management and use.This topic based on data warehouse project of Weichai Power, from the real use of the construction of the data warehouse, in the nature of the data analysis and the basis of the study, looking for an effective and general metadata management mode to constructed a metadata management system With the reality of Weichai Power.This topic mainly studies the data warehouse and the concept, classification and application of the metadata. The data warehouse is a new information technology based on relational database, parallel processing and distributed technology. It is a to better support the enterprise or the organization’s decision analysis processing, facing the theme, integration, stable, and not changed with time collection of data used to support the enterprise management, the decision making process. Metadata is the data to describe the data, and is a very important part of data warehouse. It describes the data attribute information, including data content and meaning, quality, status and other properties. Also describes the data warehouse in data attributes and meaning, define the data structure, mode and establishing methods, source and extraction, conversion rules, is in data warehouse data resources use guide. From different angles can divide metadata to different classes, usually in the user or purpose which is divided into technical metadata and business metadata.This topic also study the way of metadata management methods, strategies and norms. The fundamental goal of metadata management is to enhance the quality of the data. The first is the data warehouse modeling tools, data acquisition tools, front show the data transfer between tools, interactive and integration, and the other is responsible for storage and maintenance in the data warehouse metadata, to be stable and accurate coordinate each module and tools work between. This topic unifies the data warehouse project, in actual demand of metadata quality for in‐depth analysis on the basis of the discussion of the metadata management purpose, scope and the present situation, the thorough analysis of metadata management rules and standards, maturity and metadata management strategy and planning, at the same time for metadata model of the structure, characteristics, application also do are described.This topic using the establishment of metadata management of data warehouse,and expounds the system to realize the automation management metadata building methods, strategies and implementation method. Including metadata management system design of the purpose and principle, function design and architecture design content, and management tools selection standards and the basis, and finally the system implementation strategies, methods and steps.
Keywords/Search Tags:Data Warehouse, Metadata, Metadata Management
PDF Full Text Request
Related items