Using ORDBMS to Store GIS Data
-
摘要: 在比较目前主要GIS存储方式的基础上, 认为基于对象关系型数据库存储GIS数据是一种良好的选择.讨论了对象关系型数据库系统Postgre-SQL的特点及其适合于存储GIS数据的一些优异特性, 主要包括基本的空间数据类型及内置空间操作符及可扩展机制等; 并讨论了基于OpenGIS标准扩展该数据库以实现地理信息数据存储的方法, 主要包括空间数据类型的扩展及空间操作扩展; 最后讨论了三维地理信息系统的扩展, 在三维数据结构方面采用单纯复型作为基本数据模型, 在空间的几何属性中引入几何体的包围盒, 并通过R-树等索引函数进一步提高速度.另外还实现了空间数据操作的两类重要函数, 即空间位置判断和并、交、分、割、裁剪等物体运算函数.所有的内核函数基于C及C+ +实现, 而在客户端通过JAVA实现服务器数据的访问.
-
关键词:
- 对象关系型数据库 /
- 地理信息系统 /
- 开放数据库标准 /
- Postgre-SQL
Abstract: Based on the comparison of the main storage method used in current GIS, we think that the ORDBMS is a good choice for storing the GIS data. We have discussed the characteristics of a special ORDBMS Postgre-SQL, which include predefined space data type and operation and extensibility fordata and function, forthe storing and processing of GIS data.We have further discussed the extension of the Postgre-SQL following the standard of Open GIS, which involves amore complicated space data structure andmore functions.Moreover, we have extended to the discussion on the store of 3D GIS data applicable in the real world.At last, we discuss the extension for 3D GIS. We use simple complexes as the basic data model, define bounding box in the geometry feather and using the R-tree structure to improve searching proficiency.We also implement two kinds of important function in space manipulation, one is the determiner of the spatial relation between objects, the other is manipulation between two 3D bodies such as union, intersection and clipping.All the function is designed for the extension in server side using C or C+ +, and in the client side, we use JAVA language to get the space data from server.-
Key words:
- object-relation database management system(ORDBMS) /
- GIS /
- OpenGIS standard /
- Postgre-SQL
-
[1] Excelon Corporation. Technical specification[EB/OL]. http://www.objectdesign.com, 2000. [2] Momjian B. PostgreSQL: introduction and concepts[M]. [s. l. ]: Addison-Wesley, 2000. [3] 罗忠文, 谢忠. 三维GIS系统框架模型[J]. 计算机工程与应用, 2002(待刊).LUO Z W, XIEZ. 3D-GIS structure mode[J]. Computer Engineering and Application, 2002(in Press). [4] 吴信才. 地理信息系统的基本技术与发展动态[J]. 地球科学———中国地质大学学报, 1998, 23(4): 329-333.WUX C. Basic technology and development of geographic information system[J]. Earth Science—Journal of China University of Geosciences, 1998, 23(4): 329-333. [5] 牛雪峰, 孙运生, 杨国东. 三维地理信息系统面向对象数据结构[J]. 世界地质, 1999, 18(3): 72-75.LIUX F, SUN Y S, YANG G D. 3D GIS object orient data structure[J]. World Geoscience, 1999, 18(3): 72-75. [6] Ramsey P. Postgis manual[EB/OL]. Reflection Research Corporation. http://postgis.reflections.org, 2001. [7] OpenGIS Consortium Inc. OpenGIS simple feature specification for SQL[EB/OL]. http://www.opengis.org/techno/specs.htm, 1999. [8] 袁艳斌, 吴冲龙, 李伟忠. 面向野外地质填图的空间实体对象表达[J]. 地球科学———中国地质大学学报, 2001, 26(2): 192-196. https://www.cnki.com.cn/Article/CJFDTOTAL-DQKX200102019.htmYUAN Y B, WUC L, LI W Z. Object styles of spatial entity for field geological mapping based on object-oriented method [J]. Earth Science—Journal of China University of Geosciences, 2001, 26(2): 192-196. https://www.cnki.com.cn/Article/CJFDTOTAL-DQKX200102019.htm [9] Breunig M. An approach to the integration of spatial data and systems for a 3D geo-information system[J]. Computers and Geosciences, 1999, 25(1): 39-48. doi: 10.1016/S0098-3004(98)00104-6 -
下载:
点击查看大图
图(2)
计量
- 文章访问数: 3638
- HTML全文浏览量: 152
- PDF下载量: 3
- 被引次数: 0
