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.

导出引用管理器 EndNote|Reference Manager|ProCite|BibTeX|RefWorks

链接本文: http://xb.chinasmp.com/CN/10.11947/j.AGCS.2017.20160586

http://xb.chinasmp.com/CN/Y2017/V46/I5/639

参考文献

[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]	吴明光, 成梓铭. 顾及使用场景的绿色地图颜色生成方法研究[J]. 测绘学报, 2026, 55(3): 390-403.
[2]	杨敏, 马宏然, 孔博, 刘鹏程, 艾廷华. 基于预训练模型的矢量海岸线形态模式判别方法[J]. 测绘学报, 2026, 55(3): 404-414.
[3]	禹文豪, 曾子怡, 张一帆, 钱海忠. 融合欧氏空间邻近与拓扑邻接信息预训练模型的路网网格模式[J]. 测绘学报, 2026, 55(3): 415-424.
[4]	禄小敏, 张志义, 闫浩文, 何毅, 苏小宁. 融合深度图信息最大化和多层感知机的建筑物群组模式识别方法[J]. 测绘学报, 2026, 55(3): 425-438.
[5]	成晓强, 赵家威, 刘鹏程. 基于距离-相似性隐喻的空间交互可视化[J]. 测绘学报, 2026, 55(3): 536-547.
[6]	王泽矫, 向隆刚, 王猛, 王兴娟, 刘清. 融合层级特征与多样化注意力的道路面与中心线协同提取网络[J]. 测绘学报, 2026, 55(3): 548-563.
[7]	徐智邦. 实体城市的多层次边界识别、模式分析与扩张模拟[J]. 测绘学报, 2026, 55(3): 566-566.
[8]	冉耘博, 杨雪, 周文豪, 吴承恩, 周宝定, 唐炉亮, 李清泉. 多维偏好增强型对抗深度强化学习驱动的行人路径规划[J]. 测绘学报, 2026, 55(2): 191-205.
[9]	王立增, 程诗奋, 杨一涛, 王培晓, 陆锋. 局部-全局联合感知的时空自适应交通集成预测方法[J]. 测绘学报, 2026, 55(2): 206-221.
[10]	王少华, 梁浩健, 苏澄, 徐大川, 周亮, 秦昆. 耦合时空大数据和人工智能的城市设施配置优化研究进展与展望[J]. 测绘学报, 2026, 55(2): 222-235.
[11]	付晓, 朱司蕊, 厉旭东, 闾国年. 面向长距离通勤场景的城市垂直起降场布局优化方法[J]. 测绘学报, 2026, 55(2): 236-248.
[12]	郭军豪, 吴明治, 王培晓, 张恒才. 一种面向定点稀疏轨迹的密度聚类停留点识别方法[J]. 测绘学报, 2026, 55(2): 249-260.
[13]	李冠男. 道路实景三维模型自动构建方法[J]. 测绘学报, 2026, 55(2): 378-378.
[14]	刘鹏程, 成晓强, 肖天元, 杨敏, 艾廷华. 一种面向地图综合建筑多边形化简的Transformer模型[J]. 测绘学报, 2026, 55(1): 124-137.
[15]	贺彪, 林浩嘉, 郭仁忠, 蒯希, 马丁, 张琛. 基于视觉感知的三维空间相似关系量化计算[J]. 测绘学报, 2026, 55(1): 138-153.