期刊名称：ISPRS Annals of the Photogrammetry, Remote Sensing and Spatial Information Sciences
印刷版ISSN：2194-9042
电子版ISSN：2194-9050
出版年度：2005
卷号：XXXVI-2/W25
出版社：Copernicus Publications
摘要：E-governmental Spatial Aided Decision-making System based on GIS and DSS is a representative paradigm in the fields of e- government application.Oracle9i database is adopted is an important aspect of system application. It is a big and complicated run database system whose run efficiency is of great importance to system capability. There are lots of methods of optimization for oracle9i database. This paper proposed some optimizational principles and methods of oracle9i database capability in the aspects of database structure, SQL Sentence and memory assignation, etc. And the system capability has been enhanced to comparatively great extent by using these above-mentioned methods of optimizing database during the course of system application. At last, this paper gave some integrated and further conclusion about optimization of oracle9i database
关键词：Oracle9i database; Optimization; Memory; SQL sentence; Table space
