Mr. Bin Li Profile

Bin Li

at Wuhan Univ

SPIE Involvement:

Author

Publications (1)

This will count as one of your downloads.

You will have access to both the presentation and article (if available).

DOWNLOAD NOW

This content is available for download via your institution's subscription. To access this item, please sign in to your personal account.

Email or Username Forgot your username?

Password Forgot your password?

Show

Keep me signed in

No SPIE account? Create an account

Proceedings Article | 29 December 2008 Paper

Principles of database capability optimization based on Oracle9i

Bin Li, Jiping Liu, Lihong Shi

Proceedings Volume 7285, 728533 (2008) https://doi.org/10.1117/12.815943

KEYWORDS: Databases, Statistical analysis, Associative arrays, Data storage, Roads, Geographic information systems, Data conversion, Structural design, Data processing, Lithium

Read 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.

My Library

You currently do not have any folders to save your paper to! Create a new folder below.

Folder Name

Folder Description

View contact details

UPDATE YOUR PROFILE

Is this your profile? Update it now.

Sign into your SPIE.org account

Don’t have a profile and want one?

Create an account on SPIE.org

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.

ORGANIZATIONAL
Sign in with credentials provided by your organization.

Organizational Username

Organizational Password

Show/Hide Password

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

Members:

Non-members: ADD TO CART

Keywords/Phrases

Search In:

Publication Years