Research and application of oracle performance optimizing technologies for building airplane environment resource database"

Jianjun Zhang; Jianyong Sun; Conggao Cheng

doi:10.1117/12.2011050

20 March 2013 Research and application of ORACLE performance optimizing technologies for building airplane environment resource database

Jianjun Zhang, Jianyong Sun, Conggao Cheng

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.

Citation Download Citation

Jianjun Zhang, Jianyong Sun, and 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); https://doi.org/10.1117/12.2011050

ACCESS THE FULL ARTICLE

INSTITUTIONAL
Select your institution to access the SPIE Digital Library.

SELECT YOUR INSTITUTION

PERSONAL
Sign in with your SPIE account to access your personal subscriptions or to use specific features such as save to my library, sign up for alerts, save searches, etc.

PERSONAL SIGN IN

No SPIE Account? Create one

PURCHASE THIS CONTENT

SUBSCRIBE TO DIGITAL LIBRARY

50 downloads per 1-year subscription

Members: $195

Non-members: $335 ADD TO CART

25 downloads per 1 - year subscription

Members: $145

Non-members: $250 ADD TO CART

PURCHASE SINGLE ARTICLE

Includes PDF, HTML & Video, when available