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

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

doi:10.11947/j.AGCS.2017.20160586

测绘学报 >

2017 , Vol. 46 >Issue 5: 639 - 648

DOI: https://doi.org/10.11947/j.AGCS.2017.20160586

地图学与地理信息

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

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

展开

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

吴政(1982-),男,博士,助理研究员,主要从事空间数据组织与管理、地理信息系统建模及地理信息服务等研究。E-mail:wuzheng_gucas@163.com

收稿日期: 2016-11-17

修回日期: 2017-03-27

网络出版日期: 2017-06-05

基金资助

国家科技支撑计划（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

Expand

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

Received date: 2016-11-17

Revised date: 2017-03-27

Online 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)

Fold

摘要

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

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

本文引用格式

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

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

参考文献

[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.

Options

文章导航

模态框（Modal）标题

摘要

本文引用格式

Abstract

参考文献