基于Oracle与ArcSDE的空间信息访问优化

在实际应用空间数据库管理方案中，逐步总结了与空间信息访问速度息息相关的数据库服务器配置和ArcSDE(American Sapatial Data Engine)空间数据库引擎配置两个主要方面的优化方法。通过调整组成SGA(System Global Area)的内存结构的大小，避免磁盘竞争、减少磁盘I／O次数，合理分配数据块空间，提高性能、确定回滚段数量，有利于频繁进行少量数据修改的联机事物处理、修改优先权，提高响应时间和竞争、调整索引格网单元整体优化空间数据的响应和系统性能等，形成了一套典型的空间信息访问优化方案。

Optimizing access to spatial data based on Oracle & ArcSDE

Gaining and saving of the spatial information in Internet is the key of its effective utilization and the important issue of the most GIS(Geographic Information System) scientific research teams in recent years.The scheme of Oracle & ArcSDE(American Sapatial Data Engine) is the most advanced management one of the spatial database, supplying strong access mechanism of the spatial database. Applying the spatial database management scheme, the project team summarized many methods to optimize access from optimizing the configuration of the data server and the ArcSDE data engine. Adjustment of SGA(System Global Area) memory structure, avoidance of disk I/O issues, rational distribution of data-space, confirm of reasonable rollback-segment number, modifying priority and index grid to optimize response time, etc, buildup a typical scheme of optimizing access to spatial data.