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]	邱越, 武芳, 翟仁健, 钱海忠, 黄哲琨, 李博. 面向匹配优化的多源建筑物实体级保形空间对齐模型[J]. 测绘学报, 2025, 54(12): 2262-2275.
[2]	张锦彬, 朱军, 党沛, 周宇轩, 杨博文. 现场直播式地理信息服务：基于VR全景的现场实况远程临浸感知[J]. 测绘学报, 2025, 54(12): 2276-2286.
[3]	张岩. 基于街景影像的城市功能区多尺度时空感知方法[J]. 测绘学报, 2025, 54(12): 2289-2289.
[4]	曾进. 城市社会空间的空间大数据量化表达与分析方法：以深圳市为例[J]. 测绘学报, 2025, 54(12): 2292-2292.
[5]	刘少俊. 基于手机信令数据的城市人群活动时空格局分析研究[J]. 测绘学报, 2025, 54(12): 2295-2295.
[6]	吴超, 梁咏翔, 岳瀚, 崔远政, 黄波. 面向计数数据的时空地理加权泊松回归模型[J]. 测绘学报, 2025, 54(11): 2026-2039.
[7]	王小龙, 王卓, 李精忠, 闫浩文. 微地图制图的空间方向关系转译法[J]. 测绘学报, 2025, 54(11): 2040-2051.
[8]	胡鑫, 杨学习, 江一凡, 王宪彬, 丁晨, 谢顾然, 邓敏. 基于多智能体层次化协同的地理事件抽取与时空解析[J]. 测绘学报, 2025, 54(11): 2052-2067.
[9]	李俊, 李朝奎, 黄磊, 冯媛媛. 高速公路广告牌巡检目标跟踪的改进ByteTrack算法[J]. 测绘学报, 2025, 54(11): 2068-2080.
[10]	叶欣宇, 徐胜华, 刘纪平, 陈虹宇, 王琢璐, 李维炼. 基于时空因果推断的下一个兴趣点推荐[J]. 测绘学报, 2025, 54(11): 2081-2096.
[11]	赵学胜, 谢文澜, 孙文彬. 空间格网互操作的研究进展与关键问题[J]. 测绘学报, 2025, 54(10): 1727-1740.
[12]	高凡, 路威, 甘麟露, 章繁, 荣凤娟, 汤士涵. 智能驱动的并行地理计算引擎框架[J]. 测绘学报, 2025, 54(10): 1877-1892.
[13]	吴浩宇, 朱庆, 丁雨淋, 鲍榴, 刘利. 数据模型知识协同驱动的隧道围岩高精度数字孪生建模方法[J]. 测绘学报, 2025, 54(10): 1893-1906.
[14]	郝彧露. 时空数据驱动的城市区域火灾风险评估预测模型及应用[J]. 测绘学报, 2025, 54(10): 1910-1910.
[15]	张付兵, 孙群, 徐青, 马京振, 黄文君, 陈若虚. 随机森林和图神经网络支持下的河系自动分级与选取方法[J]. 测绘学报, 2025, 54(9): 1697-1711.