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

The design and implementation of urban industrial layout fundamental spatial database

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

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 ESRL 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.