基于数据仓库的QAR数据分析  

Analysis of QAR data based on data warehouse

作　　者：郇秀霞[1] 王红[1] 

机构地区：[1]中国民航大学计算机科学与技术学院,天津300300

出　　处：《计算机工程与设计》2008年第10期2685-2688,共4页Computer Engineering and Design

基　　金：国家自然科学基金项目(60612174)

摘　　要：针对现有各航空公司分析QAR数据的平台不统一、QAR数据量大、分析和处理数据能力不足、导致海量的数据变成了信息垃圾,在对QAR数据和数据仓库技术研究基础上,结合航空公司关心的问题,设计了QAR数据仓库,给出了数据仓库模型的设计,详细阐述了QAR数据分析主题的提取方法,提出QAR数据仓库的星型模型。通过ETL设计了多维数据集,以超限事件为例展现了对QAR数据的安全分析,为航空公司改进飞行品质、提高安全系数提供依据。Aimed at the practical questions of airline companies, such as the platform used to analyze the QAR data is not unified, great amount of QAR data, low capability of data processing and numerous data turned into information trash, QAR data warehouse based on technique of data warehouse and studied QAR data is designed combining the questions which airline companies concerned. The data warehouse architecture is designed, a blue print about how to extract analysis of QAR data subjects, a star schema and multidimensional model by ETL is presented, which implemented the farther research on QAR data through exceed the limits, so that some basis can be provided for airline companies＇ improving flight character and factor of safety.

关 键 词：数据仓库 数据清洗 QAR数据 飞行品质 多维数据集 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]