Research and Application of ORACLE Performance Optimizing Technologies for Building Airplane Environment Resource Database
Many problems exist in processing experimental aircraft vibration (temperature, humidity) data and generating the intermediate calculations during tbe construction of airplane environment resource database, such as the need to deal with both structural and non-structural data, weak capacity of the client browser for data processing and massive network data transferring etc. To solve the above problems, some strategies on tuning and optimization performance of database are employed base on Oraclellg, which include data storage structure tuning, the memory configuration of the sever, the disk I/O tuning and SQL statement tuning. The experimental results show that the performance of airplane environment resource database is enhanced about 80％ compared with the database developed in the initial demonstration and validation phase. The application of new optimization strategies to the database construction can lay a sound foundation for finishing building airplane environment resource database.
airplane environment resource database storage structure tuning the memory configuration of the sever the disk I/O tuning SQL statement tuning
ZHANG Jianjun SUN Jianyong CHENG Conggao
Center of quality engineering China Aero-Polytechnology Establishment Beijing, China
国际会议
重庆
英文
454-458
2011-01-21（万方平台首次上网日期，不代表论文的发表时间）