Oracle数据库矢栅数据一体化存储与管理

doi:10.11947/j.AGCS.2017.20160586

测绘学报 ›› 2017, Vol. 46 ›› Issue (5): 639-648.doi: 10.11947/j.AGCS.2017.20160586

Oracle数据库矢栅数据一体化存储与管理

吴政, 李成名, 武鹏达, 沈建明, 孙伟

中国测绘科学研究院GIS所, 北京 100830

收稿日期:2016-11-17 修回日期:2017-03-27 出版日期:2017-06-20 发布日期:2017-06-05
通讯作者: 李成名 E-mail:cmli@casm.ac.cn
作者简介:吴政(1982-),男,博士,助理研究员,主要从事空间数据组织与管理、地理信息系统建模及地理信息服务等研究。E-mail:wuzheng_gucas@163.com
基金资助:
国家科技支撑计划（2015BAJ06B01）；国家基础测绘项目（A1608；A1615）

Integrated Storage and Management of Vector and Raster Data Based on Oracle Database

WU Zheng, LI Chengming, WU Pengda, SHEN Jianming, SUN Wei

Institute of GIS, Chinese Academy of Surveying and Mapping, Beijing 100830, China

Received:2016-11-17 Revised:2017-03-27 Online:2017-06-20 Published:2017-06-05
Supported by:
The National Key Technology Research and Development Program of the Ministry of Science and Technology of China (No.2015BAJ06B01);National Basic Surveying and Mapping Project (Nos. A1608;A1615)

摘要/Abstract

摘要： 当前多源异构空间数据存储和管理存在流转难度大、存储不统一、效率不高等问题。本文将关系数据库与空间数据引擎技术结合，提出了一种基于Oracle的面向对象的矢栅数据一体化存储与管理方法。该方法首先建立了矢栅一体化存储模型并优化了检索方法，然后据此构建了数据无缝流转框架，实现了多源异构矢栅数据的统一存储与高效管理。通过与国际领先的同类软件ArcSDE进行测试对比，该方法具有更高的数据流转性能及更优的查询检索效率。

关键词: 多源异构空间数据, 矢栅一体化存储, 检索优化, 数据流转

Abstract: At present, there are many problems in the storage and management of multi-source heterogeneous spatial data, such as the difficulty of transferring, the lack of unified storage and the low efficiency. By combining relational database and spatial data engine technology, an approach for integrated storage and management of vector and raster data is proposed on the basis of Oracle in this paper. This approach establishes an integrated storage model on vector and raster data and optimizes the retrieval mechanism at first, then designs a framework for the seamless data transfer, finally realizes the unified storage and efficient management of multi-source heterogeneous data. By comparing experimental results with the international leading similar software ArcSDE, it is proved that the proposed approach has higher data transfer performance and better query retrieval efficiency.

Key words: multi-source heterogeneous spatial data, vector and raster data integrated storage, retrieval optimization, data transfer

中图分类号:

P208

吴政, 李成名, 武鹏达, 沈建明, 孙伟. Oracle数据库矢栅数据一体化存储与管理[J]. 测绘学报, 2017, 46(5): 639-648.

WU Zheng, LI Chengming, WU Pengda, SHEN Jianming, SUN Wei. Integrated Storage and Management of Vector and Raster Data Based on Oracle Database[J]. Acta Geodaetica et Cartographica Sinica, 2017, 46(5): 639-648.

参考文献

[1] 李德仁, 姚远, 邵振峰. 智慧城市中的大数据[J]. 武汉大学学报(信息科学版), 2014, 39(6):631-640. LI Deren, YAO Yuan, SHAO Zhenfeng. Big Data in Smart City[J]. Geomatics and Information Science of Wuhan University, 2014, 39(6):631-640.
[2] 李德仁. 展望大数据时代的地球空间信息学[J]. 测绘学报, 2016, 45(4):379-384. DOI:10.11947/j.AGCS.2016.20160057. LI Deren. Towards Geo-spatial Information Science in Big Data Era[J]. Acta Geodaetica et Cartographica Sinica, 2016, 45(4):379-384. DOI:10.11947/j.AGCS.2016.20160057.
[3] 龚健雅. 空间数据库管理系统的概念与发展趋势[J]. 测绘科学, 2001, 26(3):4-9. GONG Jianya. Concepts and Development of Spatial Database Management[J]. Science of Surveying and Mapping, 2001, 26(3):4-9.
[4] 覃雄派, 王会举, 李芙蓉, 等. 数据管理技术的新格局[J]. 软件学报, 2013, 24(2):175-197. QIN Xiongpai, WANG Huiju, LI Furong, et al. New Landscape of Data Management Technologies[J]. Journal of Software, 2013, 24(2):175-197.
[5] 胡金星, 潘懋, 宋扬, 等. 空间数据库实现及其集成技术研究[J]. 计算机应用研究, 2003, 20(3):12-14, 19. HU Jinxing, PAN Mao, SONG Yang, et al. Research on Realization and Integrated Technology of Spatial Databases[J]. Application Research of Computers, 2003, 20(3):12-14, 19.
[6] 陈传彬, 邬群勇, 陈崇成. 基于GML的多源异构空间数据集成框架研究[J]. 测绘科学, 2005, 30(5):53-55. CHEN Chuanbin, WU Qunyong, CHEN Chongcheng. A GML-based Multi-source and Heterogeneous Spatial Data Integration Framework[J]. Science of Surveying and Mapping, 2005, 30(5):53-55.
[7] Oracle Corporation. Oracle^® Spatial Developer's Guide 11 g Release 2(11.2)[EB/OL]. (2013-11). http://docs.oracle.com/cd/E11882_01/appdev.112/e11830/toc.htm.
[8] Oracle Corporation.Oracle^® Spatial GeoRaster Developer's Guide 11 g Release 2(11.2)[EB/OL]. (2013-11). http://docs.oracle.com/cd/E11882_01/appdev.112/e11827/toc.htm.
[9] 申德荣, 于戈, 王习特, 等. 支持大数据管理的NoSQL系统研究综述[J]. 软件学报, 2013, 24(8):1786-1803. SHEN Derong, YU Ge, WANG Xite, et al. Survey on NoSQL for Management of Big Data[J]. Journal of Software, 2013, 24(8):1786-1803.
[10] 陈崇成, 林剑峰, 吴小竹, 等. 基于NoSQL的海量空间数据云存储与服务方法[J]. 地球信息科学学报, 2013, 15(2):166-174. CHEN Chongcheng, LIN Jianfeng, WU Xiaozhu, et al. Massive Geo-spatial Data Cloud Storage and Services Based on NoSQL Database Technique[J]. Journal of Geo-information Science, 2013, 15(2):166-174.
[11] YAN Baoqiang, RHODES P J. IDEA-An API for Parallel Computing with Large Spatial Datasets[C]//Proceedings of the 2011 International Conference on Parallel Processing. Taipei, China:IEEE, 2011:355-364.
[12] 康俊锋. 云计算环境下高分辨率遥感影像存储与高效管理技术研究[D]. 杭州:浙江大学, 2011. KANG Junfeng. Technologies of Storage and Efficient Management on Cloud Computing for High Resolution Remote Sensing Image[D]. Hangzhou:Zhejiang University, 2011.
[13] 雷德龙, 郭殿升, 陈崇成, 等. 基于MongoDB的矢量空间数据云存储与处理系统[J]. 地球信息科学学报, 2014, 16(4):507-516. LEI Delong, GUO Diansheng, CHEN Chongcheng, et al. Vector Spatial Data Cloud Storage and Processing Based on MongoDB[J]. Journal of Geo-information Science, 2014, 16(4):507-516.
[14] 邬伦, 张毅. 分布式多空间数据库系统的集成技术[J]. 地理学与国土研究, 2002, 18(1):6-10. WU Lun, ZHANG Yi. The Integrated Framework on Distributed Multi-Spatial Database System[J]. Geography and Territorial Research, 2002, 18(1):6-10.
[15] 刘小飞, 关昆, 于海波, 等. 多源多目标空间数据库的一体化集成与管理技术研究[J]. 测绘通报, 2014(12):97-100. LIU Xiaofei, GUAN Kun, YU Haibo, et al. Research of Integration and Management of Multi-source Multi-target Geospatial Database[J]. Bulletin of Surveying and Mapping, 2014(12):97-100.
[16] 徐道柱, 罗斌, 周岩, 等. 分布式环境下矢栅一体化数据组织模型设计[J]. 地球信息科学学报, 2016, 18(12):1588-1596. XU Daozhu, LUO Bin, ZHOU Yan, et al. Model Design of Integrated Vector and Raster Data Organization under the Distributed Environment[J]. Journal of Geo-information Science, 2016, 18(12):1588-1596.
[17] 王意洁, 孙伟东, 周松, 等. 云计算环境下的分布存储关键技术[J]. 软件学报, 2012, 23(4):962-986. WANG Yijie, SUN Weidong, ZHOU Song, et al. Key Technologies of Distributed Storage for Cloud Computing[J]. Journal of Software, 2012, 23(4):962-986.
[18] Ozsu M T, Valduriez P. Principles of Distributed Database Systems[M]. 2nd ed. New York:Prentice Hall, 1999.
[19] 李德仁, 关泽群. 空间信息系统的集成与实现[M]. 武汉:武汉测绘科技大学出版社, 2000. LI Deren, GUAN Zequn. Integration and Implementation of Spatial Information System[M]. Wuhan:Wuhan Surveying and Mapping Science and Technology University Press, 2000.
[20] KJENSTAD K.On the Integration of Object-based Models and Field-based Models in GIS[J]. International Journal of Geographical Information Science, 2006, 20(5):491-509.
[21] GOODCHILD M F, YUAN M, COVA T J. Towards a General Theory of Geographic Representation in GIS[J]. International Journal of Geographical Information Science, 2007, 21(3):239-260.
[22] 朱欣焰, 张建超, 李德仁, 等. 无缝空间数据库的概念、实现与问题研究[J]. 武汉大学学报(信息科学版), 2002, 27(4):382-386. ZHU Xinyan, ZHANG Jianchao, LI Deren, et al. Concepts, Implementation and Problems of the Seamless Spatial Database[J]. Geomatics and Information Science of Wuhan University, 2002, 27(4):382-386.
[23] LIM E P, CHIANG R H L. The Integration of Relationship Instances from Heterogeneous Databases[J]. Decision Support Systems, 2000, 29(2):153-167.
[24] 金宝轩. 网格环境下的异构空间数据库集成技术[J]. 计算机工程, 2008, 34(5):74-76. JIN Baoxuan. Integration of Heterogeneous Spatial Databases in Grid Environment[J]. Computer Engineering, 2008, 34(5):74-76.
[25] 杜红悦, 刘先林, 宫辉力. 基于ArcSDE的空间数据综合管理系统设计与实现[J]. 测绘科学, 2009, 34(5):171-173. DU Hongyue, LIU Xianlin, GONG Huili. Design and Implementation of Spatial Data Integreted Management System Based on ArcSDE[J]. Science of Surveying and Mapping, 2009, 34(5):171-173.

Oracle数据库矢栅数据一体化存储与管理

Integrated Storage and Management of Vector and Raster Data Based on Oracle Database

PDF

可视化

被引次数

摘要/Abstract

引用本文

使用本文

参考文献

相关文章 15

编辑推荐

Metrics

本文评价

[1]	刘经南, 罗亚荣, 郭迟, 高柯夫. PNT智能与智能PNT[J]. 测绘学报, 2022, 51(6): 811-828.
[2]	韩李涛, 周丽娟, 龚城, 张爱国. 顾及步行习惯的室内导航网络及其生成算法[J]. 测绘学报, 2022, 51(5): 729-738.
[3]	方金凤, 孟祥福. 基于LBSN和多图融合的兴趣点推荐[J]. 测绘学报, 2022, 51(5): 739-749.
[4]	张睿卓. 基于多源数据的林区电力走廊安全风险评估方法[J]. 测绘学报, 2022, 51(5): 784-784.
[5]	夏吉喆, 周颖, 李珍, 李帆, 乐阳, 程涛, 李清泉. 城市时空大数据驱动的新型冠状病毒传播风险评估——以粤港澳大湾区为例[J]. 测绘学报, 2020, 49(6): 671-680.
[6]	朱庆, 冯斌, 李茂粟, 陈媚特, 徐肇文, 谢潇, 张叶廷, 刘铭崴, 黄志勤, 冯义从. 面向动态关联数据的高效稀疏图索引方法[J]. 测绘学报, 2020, 49(6): 681-691.
[7]	陆川伟, 孙群, 陈冰, 温伯威, 赵云鹏, 徐立. 车辆轨迹数据的道路学习提取法[J]. 测绘学报, 2020, 49(6): 692-702.
[8]	尹烁, 闫小明, 晏雄锋. 基于特征边重构的建筑物化简方法[J]. 测绘学报, 2020, 49(6): 703-710.
[9]	吴华意, 黄蕊, 游兰, 向隆刚. 出租车轨迹数据挖掘进展[J]. 测绘学报, 2019, 48(11): 1341-1356.
[10]	郭庆胜, 刘洋, 李萌, 程晓茜, 何捷, 王慧慧, 魏智威. 基于网格模型的导航道路图渐进式化简方法[J]. 测绘学报, 2019, 48(11): 1357-1368.
[11]	吴政, 武鹏达, 李成名. 对等网络下自适应层级的矢量数据时空索引构建方法[J]. 测绘学报, 2019, 48(11): 1369-1379.
[12]	王培晓, 张恒才, 王海波, 吴升. ST-CFSFDP:快速搜索密度峰值的时空聚类算法[J]. 测绘学报, 2019, 48(11): 1380-1390.
[13]	万子健, 李连营, 杨敏, 周校东. 车辆轨迹数据提取道路交叉口特征的决策树模型[J]. 测绘学报, 2019, 48(11): 1391-1403.
[14]	胡光辉, 熊礼阳, 汤国安. DEM地表坡向变率的向量几何计算法[J]. 测绘学报, 2019, 48(11): 1404-1414.
[15]	张旭, 郝向阳, 李建胜, 李朋月. 监控视频中动态目标与地理空间信息的融合与可视化方法[J]. 测绘学报, 2019, 48(11): 1415-1423.