LI Shaojun, YANG Haijun, HUANG Yaohuan, ZHOU Qin. Geo-spatial Big Data Storage Based on NoSQL Database[J]. Geomatics and Information Science of Wuhan University, 2017, 42(2): 163-169. DOI: 10.13203/j.whugis20140774
Citation: LI Shaojun, YANG Haijun, HUANG Yaohuan, ZHOU Qin. Geo-spatial Big Data Storage Based on NoSQL Database[J]. Geomatics and Information Science of Wuhan University, 2017, 42(2): 163-169. DOI: 10.13203/j.whugis20140774

Geo-spatial Big Data Storage Based on NoSQL Database

Funds: 

The National Natural Science Foundation of China No. 51309210

More Information
  • Author Bio:

    LI Shaojun, PhD, specializes in geographic information software. E-mail:lishaojun@supermap.com

  • Corresponding author:

    YANG Haijun, PhD, senior engineer. E-mail:yanghj@lreis.ac.cn

  • Received Date: April 16, 2015
  • Published Date: February 04, 2017
  • Geospatial data in databases have shifted to conform to the characteristics of big-data in tandem with the development of the Internet, mobile Internet, cloud computing, and especially, spatial data acquisition technologies. Faced with tackling spatial big data, traditional spatial database management techniques based on Relational Database Management Systems have encountered problems including the unstructured characteristics of the spatial object, the high scalability of storage capacity, and the high concurrency in big data application environment. This paper focuses on the mainstream of NoSQL databases that successfully deal with unstructured big data and are widely used in Internet applications, but lack of spatial characteristics. The data operational and query modes cannot meet the requirments of GIS applications. To resolve this problem, this paper proposes a strategy that takes a NoSQL database as a warehouse for spatial big data and a traditional spatial database as the application server. The storage system architecture and the key technology and solutions are discussed. A prototype system was developed based on MongoDB, PostgreSQL and SQLite to verify the feasibility and effectiveness of the strategy.
  • [1]
    Mooney P, Corcoran P, Winstanley A C. Geospatial Data Issues in the Provision of Location-based Services[C].Proceedings of the 7th International Symposium on LBS & Telecartography, Guangzhou, China, 2010
    [2]
    龚健雅.空间数据库管理系统的概念与发展趋势[J].测绘科学, 2001, 26(3):4-9 http://www.cnki.com.cn/Article/CJFDTOTAL-CHKD200103001.htm

    Gong Jianya. Concepts and Development of Spatial Database Management System[J]. Science of Surveying and Mapping, 2001, 26(3):4-9 http://www.cnki.com.cn/Article/CJFDTOTAL-CHKD200103001.htm
    [3]
    刘经南, 方媛.位置大数据的分析处理研究进展[J]. 武汉大学学报·信息科学版, 2014, 39(4):380-385 http://ch.whu.edu.cn/CN/abstract/abstract2947.shtml

    Liu Jingnan, Fang Yuan. Research Progress in Location Big Data Analysis and Processing[J].Geomatics and Information Science of Wuhan University,2014, 39(4):380-385 http://ch.whu.edu.cn/CN/abstract/abstract2947.shtml
    [4]
    周芹,李绍俊.基于Oracle Spatial的空间数据库缓存技术研究[J].地球信息科学, 2007, 9(3):39-44 http://www.cnki.com.cn/Article/CJFDTOTAL-DQXX200703010.htm

    Zhou Qin, Li Shaojun. Study on Spatial Data Cache Technology Based on Oracle Spatial[J].Geo-Information Science, 2007, 9(3):39-44 http://www.cnki.com.cn/Article/CJFDTOTAL-DQXX200703010.htm
    [5]
    周芹,李绍俊,李云锦,等.空间数据库引擎的关键技术及发展[C]. 中国地理信息系统协会第四次会员代表大会, 北京,2007

    Zhou Qin, Li Shaojun, Li Yunjin, et al. The Key Technique and Development of Spatial Database Engine[C]. The Fourth Member Representative Assembly of China Geographic Information System Association, Beijing, China, 2007
    [6]
    Zhong Y, Han J, Zhang T, et al. A Distributed Geospatial Data Storage and Processing Framework for Large-scale WebGIS[C]. The 20th International Conference on Geoinformatics, Hong Kong. China, 2012
    [7]
    Han D, Stroulia E. HGrid:A Data Model for Large Geospatial Data Sets in HBase[C]. Proceedings of the 2013 IEEE Sixth International Conference on Cloud Computing, CA. USA, 2013
    [8]
    Wei L Y, Hsu Y T, Peng W C, et al. Indexing Spatial Data in Cloud Data Managements[J].Pervasive and Mobile Computing, 2014, 15:48-61 doi: 10.1016/j.pmcj.2013.07.001
    [9]
    陈崇成, 林剑峰, 吴小竹, 等.基于NoSQL的海量空间数据云存储与服务方法[J].地球信息科学学报, 2013, 15(2):166-174 doi: 10.3724/SP.J.1047.2013.00166

    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 doi: 10.3724/SP.J.1047.2013.00166
    [10]
    Chang F, Dean J, Ghemawat S, et al. Bigtable:A Distributed Storage System for Structured Data[J].ACM Transactions on Computer Systems, 2008, 26(2):1-26 http://cn.bing.com/academic/profile?id=6034c75210d72de01b3e8b076389df33&encoded=0&v=paper_preview&mkt=zh-cn
    [11]
    Ghemawat S, Gobioff H, Leung S T. The Google File System[C]. 19th ACM Symposium on Operating Systems Principles, New York, USA, 2003
    [12]
    Burrows M. The Chubby Lock Service for Loosely-coupled Distributed Systems[C]. Proceedings of the 7th Symposium on Operating Systems Design and Implementation, Berkeley, USA, 2006
    [13]
    陈吉荣,乐嘉锦.基于Hadoop生态系统的大数据解决方案综述[J].计算机工程与科学, 2013, 35(10):25-35 http://www.cnki.com.cn/Article/CJFDTOTAL-JSJK201310004.htm

    Chen Jirong, Le Jiajin. Reviewing the Big Data Solution Based on Hadoop Ecosystem[J]. Computer Engineering & Science, 2013, 35(10):25-35 http://www.cnki.com.cn/Article/CJFDTOTAL-JSJK201310004.htm
    [14]
    Hecht R, Jablonski S. NoSQL Evaluation:A Use Case Oriented Survey[C]. 2011 International Conference on Cloud and Service Computing, Hong Kong, China, 2011
    [15]
    李绍俊,钟耳顺,周芹,等.开放式空间数据库访问接口的开发应用[J].地球信息科学学报, 2013, 10(2):193-199 http://www.cnki.com.cn/Article/CJFDTOTAL-DQXX201302007.htm

    Li Shaojun, Zhong Ershun, Zhou Qin,et al. Study on Opening Geospatial Database Connectivity[J].Journal of Geo-Information Science,2013, 10(2):193-199 http://www.cnki.com.cn/Article/CJFDTOTAL-DQXX201302007.htm
  • Related Articles

    [1]YU Liebing, XIANG Longgang, SUN Shangyu, GUAN Xuefeng, WU Huayi. kNN Query Processing for Trajectory Big Data Based on Distributed Column-Oriented Storage[J]. Geomatics and Information Science of Wuhan University, 2021, 46(5): 736-745. DOI: 10.13203/j.whugis20200136
    [2]CAO Buyang, FENG Huasen, LIANG Junhao, LI Xiang. Hilbert Curve and Cassandra Based Indexing and Storing Approach for Large-Scale Spatiotemporal Data[J]. Geomatics and Information Science of Wuhan University, 2021, 46(5): 620-629. DOI: 10.13203/j.whugis20200367
    [3]WU Huayi, CHENG Hongquan, ZHENG Jie, QI Kunlun, YANG Hongbing, LI Xuexi. RS-ODMS: An Online Distributed Management and Service Framework for Remote Sensing Data[J]. Geomatics and Information Science of Wuhan University, 2020, 45(12): 1836-1846. DOI: 10.13203/j.whugis20200198
    [4]CHEN Mian, LI Longhai, XIE Peng, FU Shaofeng, HE Liesong, ZHOU Xiaodong. A Data Management System for Big Geospatial Data Based on Phoenix[J]. Geomatics and Information Science of Wuhan University, 2020, 45(5): 719-727. DOI: 10.13203/j.whugis20180435
    [5]YUE Peng, WU Zhaoyan, SHANGGUAN Boyi. Design and Implementation of a Distributed Geospatial Data Storage Structure Based on Spark[J]. Geomatics and Information Science of Wuhan University, 2018, 43(12): 2295-2302. DOI: 10.13203/j.whugis20180034
    [6]CHEN Di, ZHU Xinyan, ZHOU Chunhui, SU Kehua. Distributed Spatial Query Processing and Parallel Schedule Based on Zonal Fragmentation[J]. Geomatics and Information Science of Wuhan University, 2012, 37(8): 892-896.
    [7]MENG Lingkui, ZHANG Wen, Frank Zhigang WANG. A Grid Geo-spatial Database System Model Based on Layered P2P Protocol[J]. Geomatics and Information Science of Wuhan University, 2008, 33(12): 1233-1236.
    [8]ZHU Qing, ZHOU Yan. Distributed Spatial Data Storage Object[J]. Geomatics and Information Science of Wuhan University, 2006, 31(5): 391-394.
    [9]LUO De'an, LIAO Liqiong. A Cadastral Spatial Data Storage Structure Based on Relational Database[J]. Geomatics and Information Science of Wuhan University, 2000, 25(6): 516-520.
    [10]Fang Tao, Li Deren, Gong Jianya, Pi Minghong. Develeopment and Implementation of Multiresolution and Seamless Image Database System GeoImageDB[J]. Geomatics and Information Science of Wuhan University, 1999, 24(3): 189-193,281.

Catalog

    Article views (6253) PDF downloads (1050) Cited by()
    Related

    /

    DownLoad:  Full-Size Img  PowerPoint
    Return
    Return