Research And Implement Of Data Quality Management Of Data Warehouse For Finance Industry

With the deepening application of DW in commercial banks, the DQ becomes the critical point of the successful construction of the DW and the effective application of the data. The purpose of the DW is to optimize the resource configuration of the enterprise, to promote the resource sharing and collaboration of the enterprise, so as to improve the core competitiveness and innovation power of the enterprise. The good data can raise the correctness of the decision of the management group. So the control of the DQ has become the increasing outstanding problems during the development of the DW construction.Firstly, the dissertation introduced the current situations of the DQ research areas at home and abroad, describt the relavant conceptions of the DW and the DQ, analyzed the origin of the DQ problems, expounds the common methods that gurantee the DQ of the DW.Secondly, the dissertation discusses the importance the metadata for the assistant decision-making personals to understand the data and improve the DQ of the commercial banks. Considering the extensibility of the metadata integration and sharing, it designs the metadata database and management architecture which are based on the CWM to improve the DQ.Thirdly, the dissertation puts forward the principles and the standard for the DQ inspection in combination of some commercial bank's DW concrete situation, designes the process and measure of the DQ examination in the commercial banks.Last, under the background of the some commercial bank, the dissertation combines with the metadata database and the DQ control process, designes a metadata and DQ management system based on the common warehouse metamodel standard for the DW. The result illustrates that the implement of this method improved the DQ of the DW.