The Design and Implementation of Urban Industrial Layout Fundamental Spatial Database
CAO Yun-gang,ZHU Xiao-hua,DING Jing-jing
2010-01-01
Geographical Research
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.