地理研究 ›› 2010, Vol. 29 ›› Issue (1): 173-180.doi: 10.11821/yj2010010018

• 地球信息科学 • 上一篇    下一篇

城镇产业布局基础空间信息数据库系统的设计与实现

曹云刚1, 朱晓华2, 丁晶晶2   

  1. 1. 西南交通大学土木工程学院测量工程系,成都 610031;
    2. 中国科学院地理科学与资源研究所,北京 100101
  • 收稿日期:2009-02-05 修回日期:2009-07-26 出版日期:2010-01-20 发布日期:2010-01-20
  • 通讯作者: 朱晓华,博士,副研究员。E-mail:zhuxh@igsnrr.ac.cn. E-mail:zhuxh@igsnrr.ac.cn
  • 作者简介:曹云刚(1978-),男,四川成都人,博士,讲师。主要从事资源环境遥感应用与GIS研究。
  • 基金资助:

    "十一五"国家科技支撑计划重大项目"小城镇产业布局分析系统开发"(2006BAJ05A06)

The design and implementation of urban industrial layout fundamental spatial database

CAO Yun-gang1, ZHU Xiao-hua2, DING Jing-jing2   

  1. 1. Department of Survey Engineering, School of Civil Engineering, Southwest Jiaotong University, Chengdu 610031, China;
    2. Institute of Geographic Sciences and Natural Resources Research, CAS, Beijing 100101, China
  • Received:2009-02-05 Revised:2009-07-26 Online:2010-01-20 Published:2010-01-20

摘要:

建立城镇产业布局基础空间信息数据库的目的是避免城镇基础空间数据集的重复采集,减少浪费,协调空间数据的使用,加强对信息资源有效而经济的管理。针对城镇产业布局分析中对基础数据的实际要求,综合利用地理信息系统技术、数据库技术和空间数据库引擎技术,设计了城镇产业布局基础空间信息数据库的系统框架结构和建库技术路线,并在此基础上建立了一套分布式城镇产业布局数据库原型系统。该系统能够对城镇产业布局分析相关的海量空间数据进行有效的组织、管理和应用,并预留了数据接口,可为相关的城镇产业布局分析软件提供数据支持服务。此外,该系统还可实现不同部门和用户的数据共享,为城镇建设决策提供数据支持。

关键词: 数据库, 地理信息系统, 空间数据库引擎

Abstract:

The function of fundamental spatial database is to avoid redundant collection of spatial datasets, to coordinate spatial data application, and to strengthen information resources management effectively and economically. Based on the geographic information system technology, database technology and spatial database engine technology, this paper put forward the technological framework to construct urban industrial layout fundamental spatial database. In this database, spatial database and industrial layout information database are logical disjunction but storage in the same relational database system. The data structure used in spatial data organization is Geodatabase model developed by ESRI. In the Geodatabase data model, feature dataset together with raster dataset are stored in the relational database system through spatial database engine. On the other hand, metadata database is established to benefit system management. Beyond this work, we also achieved a set of distributed database prototype system for the effective organization, management and applications of massive spatial data. This system is developed by Microsoft Visual Studio 2005 and Arc Engine 9.2 based on client/server structure with four modules, which are system management module, data warehousing module, query and analysis module and data management module. System management module provides the functions for user management, log management, database backup and recovery. Data warehousing module provides the functions for importing industrial information and spatial data into database, spatial data quality check, etc. Query and analysis module provides the functions for spatial query and attribute query, statistical analysis, while data management module provides the functions for data updating and sharing. With the aid of this system, data administrators can manage the industrial layout fundamental spatial database through network. Different departments and users can share their data effectively. Decision-makers for urban industrial layout can also achieve supporting information from the system.

Key words: database, geographic information system, spatial database engine