The Design and Analysis of QAR Data Warehouse on the Subject of Flight Phase

The safety issue of civil aviation attracts people´s extensive attention increasingly. As flight data can truly reflect insecure incident and accident portent, the hidden troubles can be discovered and estimated by collecting and analyzing flight data to take measures to avoid safe lurking danger in time. It is easy to carry out effective analyses and deep excavation for the mass of historical flight data through data warehouse technology. Combined with QAR data´s characteristics, we build a QAR data warehouse on the subject of flight phase. And we adopt an algorithm for dynamic time warping based on piecewise linear representation in time series to analyze the similarity of ground speed acceleration oft the same aircraft type and the same flight number, in order to validate that building data warehouse can enhance the efficiency of system analysis and excavate the hidden safe dangers efficiently.