基于GIS的水库移民工程数据库模型构建  

Construction of Database Model of Reservoir Resettlement Project Based on GIS

作　　者：马逍 MA Xiao(Guizhou Province Water Conservancy and Hydropower Survey Design&Research Institute Co.Ltd.,Guiyang 550002,China)

机构地区：[1]贵州省水利水电勘测设计研究院有限公司,贵阳550002

出　　处：《水利科技与经济》2022年第6期128-133,共6页Water Conservancy Science and Technology and Economy

摘　　要：水库移民工程数据管理过程中,由于数据库设计逻辑的差异,导致数据库查询响应时间过长,因此提出基于GIS的水库移民工程数据库模型构建。采用多项式变换和IHS变换方法,对水库移民工程数据进行处理。按照数据描述信息,建立数据分类及编码规则。依托于GIS数据模型和对象关系概念,获取空间数据库模型设计逻辑,结合数据库访问机制,完成数据库模型构建。实例分析结果表明,所提出的模型生成的水库移民工程数据库,与原始数据库相比查询响应时间降低63.53%。In the process of reservoir resettlement project data management,due to the difference of database design logic,the database query response time is too long.Therefore,a database model of reservoir resettlement project based on GIS is proposed.Polynomial transformation and IHS transformation are used to process the data of reservoir resettlement project.Then,according to the data description information,establish data classification and coding rules.Based on GIS data model and object relationship concept,obtain the design logic of spatial database model,and then complete the construction of database model combined with database access mechanism.The example analysis results show that the query response time of the reservoir resettlement engineering database generated by the proposed model is reduced by 63.53%compared with the original database.

关 键 词：水库移民工程 数据库 模型 GIS 数据分类 逻辑 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论] D632.4[自动化与计算机技术—计算机科学与技术]