Research On The Applications Of Bi's Etl Optimization And Quality Control On Aviation Warning

The applications of business intelligence and aviation warning in china are only ten years, but its effect is not to be small peep. Currently, business intelligence has certain application in the aviation. However, to achieve the accuracy and timeliness of aviation warning is still a long way to go. And aviation warning's success is largely safeguard the passenger and pilot's safe of life and property.The paper, firstly researches the relevant content and theory of Business intelligence and aviation warning, summarizes the research status of Business intelligence, the ETL technology and aviation warning. Secondly, gives a general framework of business intelligent, studies the relationship between business intelligence and its key technology ETL, and analyzes the use of business intelligence applied in aviation warning. Through the above mentioned, establish the research direction and content framework about this paper. The research direction is studying business intelligence's ETL process optimization and its quality control in apply of aviation warning. The content framework is in-depth studying the difficulty problem of constructing business intelligence, and giving optimization scheme. Finally, combines with the actual situation of the aviation warning area and gives the whole framework of business intelligence which based on the aviation warning. Then, thinks about the difficult problem of implementing business intelligence, and advances an applicable blue print for the ETL process design and quality control.The difficult problem of constructing business intelligence——ETL processing and quality controlling. These two problems optimizing and processing scheme are embodied in:(1) Implementation of the ETL process optimization. Improve the ETL process from the whole, increasing interaction and share of system resources. Then base on this start the task scheduling optimization. Achieve the maximum benefit of system resources in the limited time. Last think about the details of ETL process, put forward the optimization of execution efficiency for both specific tools and query. Reduce the time consumption of ETL process in some way. (2) Research in the data quality controlling problem. Determine the elements of data quality issues identification, analysis the source of data quality issues and give out the corresponding categories, so that carry out the data quality control of source system and quality control in ETL implementation process separately. The main job of quality control in the implementation of ETL process is to design handle process in eliminating data duplication, converting code and conjunction, which can record the bad data in the process, then classify the rejected information. Identify the source of the problem, and notify handlers or system for processing at last. Finally, create a closed-loop processing which from data source to data integration, and then to the target data, and the last to the data source, so that to ensure good data quality. Provide a comprehensive quality control on business intelligence platform.