Share Email Print
cover

Proceedings Paper

Research and application of oracle performance optimizing technologies for building airplane environment resource database"
Author(s): Jianjun Zhang; Jianyong Sun; Conggao Cheng
Format Member Price Non-Member Price
PDF $14.40 $18.00
cover GOOD NEWS! Your organization subscribes to the SPIE Digital Library. You may be able to download this paper for free. Check Access

Paper Abstract

Many problems exist in processing experimental aircraft vibration (temperature, humidity) data and generating the intermediate calculations during the 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 Oracle11g, which include data storage structure tuning, the memory configuration of the server, 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.

Paper Details

Date Published: 20 March 2013
PDF: 7 pages
Proc. SPIE 8768, International Conference on Graphic and Image Processing (ICGIP 2012), 876839 (20 March 2013); doi: 10.1117/12.2011050
Show Author Affiliations
Jianjun Zhang, Ctr. of Quality Engineering of China Aero-Polytechnology Establishment (China)
Jianyong Sun, Ctr. of Quality Engineering of China Aero-Polytechnology Establishment (China)
Conggao Cheng, Ctr. of Quality Engineering of China Aero-Polytechnology Establishment (China)


Published in SPIE Proceedings Vol. 8768:
International Conference on Graphic and Image Processing (ICGIP 2012)
Zeng Zhu, Editor(s)

© SPIE. Terms of Use
Back to Top