毕业设计（论文）-提高数据仓库中数据质量的研究.docVIP

HUNAN UNIVERSITY 毕业设计(论文) 设计论文题目： 提高数据仓库中数据质量的研究 学生姓名： 学生学号： 专业班级： 软件开发班 学院名称： 软件学院 指导老师： 学院院长： 2008年5月20日 首先，利用ETL调度原理实现数据的自动化调度，使数据成为一个流动的数据流，数据所在的数据库作为ETL流的起点，保存最终高质量数据的数据仓库作为ETL数据流的终点。 其次，对于已经形成ETL数据流的数据生成流实例信息，对完成ETL流程处理的数据构造历史信息，从而保证能够对ETL流进行监控。 再次，构造ETL流程的处理逻辑，这是构造高质量数据的核心部分，根据实际的经验构造自动化的校验程序，使数据流流过时校验程序能够纠正错误数据，最终达到获得高质量数据的目的。 最后，经过EMC项目的实施情况证明，非法数据在以ETL流的形式流经校验程序时都能够按照提前设定得到处理，保证了数据仓库中数据的稳定性。 关键词：ETL，EMC（ETL）The Research in Improving the Quality of Data in the Data Warehouse Abstract Author: Gao Zhongshan Tutor: Shen Yuxiang Data Warehouse is a data collection which is subject-oriented, integrated, and relatively stable. It can reflect the changes of history and support the management decision. It is an important segment to maintain the accuracy of the data warehouse. However, ETL is an important part to build data warehouse and occupy about 60 percent of the load. The improvement of the quality in the data warehouse helps to guarantee the reliability and also help the enterprise to summarize and use the data for a long period of time. There are many methods to improve the quality of data. However, in the view of the experience summary and practice accumulation in the practical application, the paper mainly focuses on the ETL dispatcher and way of check to improve data quality of data warehouse. First of all, the automation of data management which is realized by ETL principle make the data into a data stream., the database where the data exists become as starting point of ETL, saving the data warehouse with ultimate high-quality data as the end of ETL. Second, for the data which the ETL data flow has been formed to generate example, for the data which complete ETL processes structure to handling historical information, thus ensuring that the ETL flow can monitoring. Third, building the processing logic of ETL tectonic processes is the core of constructing high-quality data, constructing the automated calibration procedures based on the