摘要
在实际应用空间数据库管理方案中,逐步总结了与空间信息访问速度息息相关的数据库服务器配置和ArcSDE(AmericanSapatialDataEngine)空间数据库引擎配置两个主要方面的优化方法。通过调整组成SGA(SystemGlobalArea)的内存结构的大小,避免磁盘竞争、减少磁盘I/O次数,合理分配数据块空间,提高性能、确定回滚段数量,有利于频繁进行少量数据修改的联机事物处理、修改优先权,提高响应时间和竞争、调整索引格网单元整体优化空间数据的响应和系统性能等,形成了一套典型的空间信息访问优化方案。
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.
出处
《吉林大学学报（信息科学版）》
CAS
2004年第3期283-288,共6页
Journal of Jilin University（Information Science Edition）
基金
中国地质调查局地质调查情报服务体系建设基金资助项目(1212010360102)
关键词
数据库
空间数据引擎
访问
优化
空间数据
地理信息
Oracle
American Sapatial Data Engine(ArcSDE)
access
optimizing
spatial data
geographic information
