Research and Design of QAR Data Warehouse

摘要：

Aiming at the practical questions of airline companies, such as the platform used to analyze the QAR data is not unified, lots of missing values, duplicate records and noise data in decoded QAR data, which seriously affect the efficiency of analysis of the QAR data. Thus, in this paper we present to analyze the data by designing QAR data warehouse, describe how to define the QAR data subjects, put forward a star schema, propose a cleaning framework of data preprocessing based on subjects and introduce the cleaning methods that are appropriate to QAR data and design multidimensional model by ETL, implement the farther research on QAR data through analyzing exceed the limits, so this can improve flight character and factor of safety for airline companies.

作者: Wang Hong Huan Xiu Xia Wang Hong Wei

作者单位: School of Computer Science and Technology,Civil Aviation University of China Tianjin 300300;School o School of Computer Science and Technology,Civil Aviation University of China Tianjin 300300

会议类型: 国际会议

会议名称: The 2nd International Symposium on Systems and Control in Aeronautics and Astronautics(第二届航空航天系统与控制国际会议 ISSCAA 2008)

会议地点: 深圳

会议语种:英文

页码: 396-401

在线出版日期: 2008-12-10（万方平台首次上网日期，不代表论文的发表时间）