【作者】 张金辉；

【导师】 李斌；

【作者基本信息】 长安大学 ， 大地测量学与测量工程， 2011， 硕士

【副题名】以汾渭盆地地裂缝地面沉降灾害空间数据库为例

【摘要】 随着数据库技术在生产、生活和社会各个层面日益广泛的应用和推广,对数据库管理系统管理数据的能力和效率的要求也越来越高。在现有软硬件资源基础上,如何充分发挥数据库管理系统潜能、全面优化并提升应用型数据库操作效能不仅可以节约系统运行成本,而且能够保障数据库的安全、稳定和效率。事实上,效能调整与优化已成为数据库,特别是空间数据库应用研究的重要课题。本文以汾渭盆地地裂缝地面沉降灾害空间数据库建设为例,借鉴现有数据库性能调整与优化研究成果,结合建库实际,将空间数据库存储优化、Oracle 10g内存参数和安全参数调整、地图服务发布等作为主要研究内容,以期通过实验研究找到提高空间数据库性能调整与优化的一般策略和方法。据此,本文取得如下研究成果：1、对于矢量数据,采用要素类的数据组织形式直接存储在SDE Geodatabase模型中以减少Oracle数据库存储空间。对于栅格数据,根据其不同数据类型特点,设置入库时各自的数据压缩方法和压缩率、数据重采样和金字塔级数等参数,确定数字高程模型采用栅格数据集,数字正射影像采用栅格目录表的数据组织形式。2、利用Oracle自带的性能优化与监测工具,根据内存参数活动统计信息,参照相关性能评价指标,适时调整与优化系统全局区和程序全局区参数。同时,调整空间数据库系统安全性参数,启用空间数据库归档模式以保障该空间数据库的安全、稳定和效率。3、利用ArcGIS Server将地图文档发布为两类地图服务：一类是缓存地图服务,主要是将地图服务转化为PNG或JPEG数据类型的同时设置瓦片级数,对每级栅格数据进行切片并将其保存在服务器的缓存路径下以加速数据显示；一类是动态地图服务,主要是根据各图层多级比例尺显示范围设置以增强地图显示效果。两者均为WebGIS调用地图提供URL地址,避免访问后台空间数据库。更多还原

【Abstract】 With the database technology widespread application in the production, life and all levels of society, it puts forward higher requirements to manage data on the capacity and efficiency by database management system. Based on the existing hardware and software resources, how to make the potential of database management system, fully optimize and enhance the operational effectiveness of the application database, can not only save operating costs, but also protect the database’security, stability and efficiency. In fact, performance tuning and optimization has become an important research subject in database, especially in spatial database applications.Taking the ground fissures and land subsidence disaster spatial database in Fen-wei Basin as the research object, referencing the existing research results in the database performance optimization and adjustment, and combined with the actual situation of the database construction, the paper will take space database storage optimization, Oracle lOg memory and safety parameters adjustment, map service issued as the main research contents, in order to find the general adjustment and optimization strategy and method to improve space database performance. Accordingly, the paper made the research results:Firstly, in order to reduce Oracle storage space, vector data as the feature class directly stored in the SDE Geodatabase model. According to different raster data types, Digital Elevation Model stored in raster dataset, and Digital Orthophoto Model stored in raster catalog after setting compression method and compression ratio, data re-sampling and pyramids series parameters.Secondly, using Oracle own performance optimization and monitoring tools, according to the statistical information of the memory parameters’activities, and referencing certain performance evaluation index, we timely adjust and optimize the system global area and program global area parameters. Meanwhile, we also adjust space database system security parameters, opening space database archivelog model to safeguard the spatial database’ security, stability and efficiency.Thirdly, map document are issued for two kinds of maps service by Using the ArcGIS Server:one kind is cache maps service. When change map service into PNG or JPEG data types, set tile levels, and then slice the grid data according to each tile level, storing in the Server’s cache path to accelerate data shows; One kind is dynamic map service. It mainly enhances map display effect by setting each layer multistage scale display range. Both of them provide URL for WebGIS using map services, avoiding access spatial database backstage.更多还原