Please wait a minute...
 
Remote Sensing for Land & Resources    2018, Vol. 30 Issue (1) : 238-242     DOI: 10.6046/gtzyyg.2018.01.33
Orginal Article |
Application of main memory database to spatial query of mass ZY1-02C data
Yanzuo WANG(), Wei ZHOU, Lei FENG
China Aero Geophysical Survey and Remote Sensing Center for Land and Resources, Beijing 100083, China
Download: PDF(906 KB)   HTML
Export: BibTeX | EndNote | Reference Manager | ProCite | RefWorks    
Abstract  

Fast spatial query is the foundation of the mass ZY1-02C data application. In the traditional spatial query structure using relational database, frequent disk I/Os and data swaps degrade the query performance a lot. In contrast, main memory database which is completely based on the memory can significantly improve the searching efficiency. In this study, a vector data storage and R-tree indexing structure was designed and implemented based on the Redis database, which is a main memory database of Key-Value type. This structure was used in practice and the efficiency of spatial query was improved.

Keywords main memory database      spatial index      vector data     
:  TP302  
Issue Date: 08 February 2018
Service
E-mail this article
E-mail Alert
RSS
Articles by authors
Yanzuo WANG
Wei ZHOU
Lei FENG
Cite this article:   
Yanzuo WANG,Wei ZHOU,Lei FENG. Application of main memory database to spatial query of mass ZY1-02C data[J]. Remote Sensing for Land & Resources, 2018, 30(1): 238-242.
URL:  
https://www.gtzyyg.com/EN/10.6046/gtzyyg.2018.01.33     OR     https://www.gtzyyg.com/EN/Y2018/V30/I1/238
Fig.1  Storage structure example
Fig.2  Storage structure example of R-tree index in Redis
Fig.3  Data conversion flowchart of shapefile
Fig.4  Flowchart of spatial data query
Fig.5  Efficiency test of spatial query
[1] 薛涛,刁明光,李建存,等.资源环境遥感海量空间数据存储、检索和访问方法[J].国土资源遥感,2013,25(2):168-173.doi:10.6046/gtzyyg.2013.02.28.
[1] Xue T,Diao M G,Li J C,et al.Approach to storing, retrieving and accessing mass spatial data in resources and environments remote sensing[J].Remote Sensing for Land and Resources,2013,25(2):168-173.doi:10.6046/gtzyyg.2013.02.28.
[2] 杨武军,张继荣,屈军锁.内存数据库技术综述[J].西安邮电学院学报,2005,10(3):95-99.
[2] Yang W J,Zhang J R,Qu J S.An overview of main-memory database technologies[J].Journal of Xi’an University of Post and Telecommunications,2005,10(3):95-99.
[3] 王珊,肖艳芹,刘大为,等.内存数据库关键技术研究[J].计算机应用,2007,27(10):2353-2357.
[3] Wang S,Xiao Y Q,Liu D W,et al.Research of main memory database[J].Computer Applications,2007,27(10):2353-2357.
[4] Wikipedia.Key-value database[EB/OL].(2016-05-16)[2016-06-27].
url: https://en.wikipedia.org/wiki/Key-value_database.
[5] Redislabs.Redis[EB/OL].(2016-06-17)[2016-06-27]..
url: http://redis.io
[6] 朱进,胡斌,邵华,等.基于内存数据库Redis的轻量级矢量地理数据组织[J].地理信息科学,2014,16(2):165-172.
[6] Zhu J,Hu B,Shao H,et al.Research of lightweight vector geographic data management based on main memory database Redis[J].Journal of Geo-information Science,2014,16(2):165-172.
[7] 阎超德,赵学胜.GIS空间索引方法述评[J].地理与地理信息科学,2004,20(4):23-26,39.
[7] Yan C D,Zhao X S.The review of spatial indexes in GIS[J].Geography and Geo-Information Science,2004,20(4):23-26,39.
[8] 史文中,郭薇,彭奕彰.一种面向地理信息系统的空间索引方法[J].测绘学报,2001,30(2):156-161.
[8] Shi W Z,Guo W,Peng Y Z.A spatial indexing method for GIS[J].Acta Geodaetica et Cartographica Sinica,2001,30(2):156-161.
[9] 黄晓明,杨红雨,闫觅.基于R树的空管GIS数据模型索引的设计[J].微计算机信息,2008,24(8-3):144-146.
[9] Huang X M,Yang H Y,Yan M.The index design for ATC GIS data model based on R tree[J].Microcomputer Information,2008,24(8-3):144-146.
[10] 罗琪,李军,陈荦.基于GIS平台的R树索引模型研究与实现[J].计算机工程与科学,2003,25(6):93-96.
[10] Luo Q,Li J,Chen L.Research and implementation of a R-tree index model based on the GIS platform[J].Computer Engineering and Science,2003,25(6):93-96.
[1] JIANG Fan, ZHANG Chenjie. Anomaly detection algorithm based on NSCT and spatial clustering in hyperspectral imagery[J]. REMOTE SENSING FOR LAND & RESOURCES, 2017, 29(2): 53-59.
[2] LI Liang, YING Guowei, WEN Xuehu, HE Xin. Classification of high spatial resolution remotely sensed images by temporal feature fusion[J]. REMOTE SENSING FOR LAND & RESOURCES, 2016, 28(2): 91-98.
[3] CHENG Baozhi. Study and progress of anomaly target detection in hyperspectral imagery[J]. REMOTE SENSING FOR LAND & RESOURCES, 2014, 26(3): 1-7.
[4] LIU Xiang-Lei, MA Jing. THE METHOD FOR TRANSFORMING ARCGIS
VECTOR DATA TO KML FILE BASED ON ARCENGINE
[J]. REMOTE SENSING FOR LAND & RESOURCES, 2007, 19(3): 98-101.
Viewed
Full text


Abstract

Cited

  Shared   
  Discussed   
京ICP备05055290号-2
Copyright © 2017 Remote Sensing for Natural Resources
Support by Beijing Magtech