Analysis of QAR data based on data warehouse

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.