20 March 2013 Research and application of ORACLE performance optimizing technologies for building airplane environment resource database
Author Affiliations +
Proceedings Volume 8768, International Conference on Graphic and Image Processing (ICGIP 2012); 876839 (2013) https://doi.org/10.1117/12.2011050
Event: 2012 International Conference on Graphic and Image Processing, 2012, Singapore, Singapore
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.
© (2013) COPYRIGHT Society of Photo-Optical Instrumentation Engineers (SPIE). Downloading of the abstract is permitted for personal use only.
Jianjun Zhang, Jianjun Zhang, Jianyong Sun, Jianyong Sun, Conggao Cheng, Conggao Cheng, } "Research and application of ORACLE performance optimizing technologies for building airplane environment resource database", Proc. SPIE 8768, International Conference on Graphic and Image Processing (ICGIP 2012), 876839 (20 March 2013); doi: 10.1117/12.2011050; https://doi.org/10.1117/12.2011050
PROCEEDINGS
7 PAGES


SHARE
Back to Top