Design And Implementation Of Aerodynamic Performance Prediction System Based On DW

In the aircraft development process, aerodynamic layout design and analysis will produce a large aerodynamic data, including aerodynamic, thermal loads, pressure, temperature distribution, and these data from the wind tunnel test, numerical calculation and flight test. Pneumatic database systems require large amounts of data generated by the test process, test engineer s hope to get the desired result of data processing within two hours, therefore, an urgent need for research and the establishment of a complete and unified data warehouse pneumatic system to achieve aerodynamic data for effective management and analysis.In this paper, the characteristics of the complex relationship between the current aerodynamic data, research data between the data warehouse is introduced and applied to the pneumatic database management, using materialized views, multidimensional analysis and Java EE Web content services, technology, design and implement a data warehouse pneumatic performance prediction system that can provide efficient services to the aerodynamic research data research.The main work includes:(1) According to different s ources, data extraction, conversion(data normalization) and loading, to form a unified historical data stored in the data warehouse;(2) According to the raw data and application data from different data categories to establish materialized view updated i n real time, improve query performance;(3) to establish a data mart based on different categories of data, multi-dimensional data display data; a flexible query data(4) the use of data marts provide data analysis;(5) in a multidimensional analysis resul ts Based on the analysis algorithm library achieve aerodynamic performance to the user to analyze performance.