关系数据库存储空间数据模型与结构分析

空间数据的存储成为地理信息系统的核心问题。本文分析了ERSI的空间数据库引擎和MapInfo公司的SpatialWare,得出空间数据和属性数据在数据库体系下,统一存储管理是必然趋势。另对空间数据的几种存储模型进行了分析,指出全关系型的数据模型或面向对象的关系数据模型是最佳的存储方式。在此基础上。提出了一种将空间数据存入关系型数据库的数据模型,进而对基于SQL Server的全关系化空间数据结构进行了分析。

The Research of Database-based Storage for Spatial Data

The handling of spatial data is a key issue of Geographic Information System (GIS). The spatial data can be analyzed and applied when stored and operated in GIS. So, it is important for GIS to store and manage spatial data. At first, this paper introduces the present research status, then analyses ESRI's Spatial Database Engine (SDE) and MapInfo's SpatialWare. It is concluded that the development direction that spatial data and attribute data are managed under Database Manage System (DBMS) is a necessary trend for unified storage and management. Then, depended on the practical technology, the paper discusses storage models of spatial data, and points out a good storage model is Relational Database Manage System (RDBMS) or Oriented Relational Database Manage System (ORDBMS). So, a data model of spatial graphical data storage in RDBMS is presented in this paper. Finally, in light of this model, the paper analyses a relational spatial-data structure based on SQL Server.