KEYWORDS: Databases, Statistical analysis, Associative arrays, Data storage, Roads, Geographic information systems, Data conversion, Structural design, Data processing, Lithium
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.
Access to the requested content is limited to institutions that have purchased or subscribe to SPIE eBooks.
You are receiving this notice because your organization may not have SPIE eBooks access.*
*Shibboleth/Open Athens users─please
sign in
to access your institution's subscriptions.
To obtain this item, you may purchase the complete book in print or electronic format on
SPIE.org.
INSTITUTIONAL Select your institution to access the SPIE Digital Library.
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.