Share Email Print

Proceedings Paper

Principles of database capability optimization based on Oracle9i
Author(s): Bin Li; Jiping Liu; Lihong Shi
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

Oracle9i database is a very big and complicated run system whose run efficiency is of great importance to E-government system capability. There are large numbers of basic geo-spatial data and attributed data in the E-government system, such as vector data, grid data, image data, DEM data and statistical data, etc. The large oracle9i database and B/S structure with three layers are adopted during the course of system application. It is very important to optimize the database capability due to using oracle9i database to manage the great capacity of data in the system. This paper proposed some optimizational principles and methods of oracle9i database capability in detail in the aspects of database structure, SQL Sentence and memory assignation. At last, some examples are given to validate the above-mentioned principles and methods. In fact, the optimization of oracle9i database is a long and continually dynamic process with the development of time due to great capacity of different data. It involves a lot of work and need often track diversified statistical targets and analyze the cause of capability change. Different aspects of factors must be synthetically considered in order to enhance the run efficiency of the system. During the course of system construction, DBA must analyze carefully different requirements and configure rationally diversified parameters about database structure, SQL sentence and memory assignation so that the run system based on oracle9i database can be at its best and improve the decision-making efficiency of e-government.

Paper Details

Date Published: 29 December 2008
PDF: 6 pages
Proc. SPIE 7285, International Conference on Earth Observation Data Processing and Analysis (ICEODPA), 728533 (29 December 2008); doi: 10.1117/12.815943
Show Author Affiliations
Bin Li, Wuhan Univ. (China)
Chinese Academy of Surveying and Mapping (China)
Jiping Liu, Chinese Academy of Surveying and Mapping (China)
Lihong Shi, Chinese Academy of Surveying and Mapping (China)

Published in SPIE Proceedings Vol. 7285:
International Conference on Earth Observation Data Processing and Analysis (ICEODPA)
Deren Li; Jianya Gong; Huayi Wu, Editor(s)

© SPIE. Terms of Use
Back to Top