Next Article in Journal
sgdm: An R Package for Performing Sparse Generalized Dissimilarity Modelling with Tools for gdm
Next Article in Special Issue
The Effects of Rural Settlement Evolution on the Surrounding Land Ecosystem Service Values: A Case Study in the Eco-Fragile Areas, China
Previous Article in Journal
Erratum: Dubois, G., et al. Integrating Multiple Spatial Datasets to Assess Protected Areas: Lessons Learnt from the Digital Observatory for Protected Areas (DOPA). ISPRS International Journal of Geo-Information 2016, 5, 242
Previous Article in Special Issue
Pattern of Spatial Distribution and Temporal Variation of Atmospheric Pollutants during 2013 in Shenzhen, China
Open AccessArticle

A NoSQL–SQL Hybrid Organization and Management Approach for Real-Time Geospatial Data: A Case Study of Public Security Video Surveillance

1,2, 1,2,3,*, 1,2,*, 1,2, 4,*, 5 and 6
State Key Laboratory of Information Engineering in Surveying, Mapping and Remote Sensing, Wuhan University, Wuhan 430079, China
Collaborative Innovation Center for Geospatial Technology, 129 Luoyu Road, Wuhan 430079, China
Faculty of Geosciences and Environmental Engineering of Southwest Jiaotong University, Chengdu 611756, China
Department of Geography, Kent State University, Kent, OH 44240, USA
Department of Geography and Geoinformation Science, George Mason University, Fairfax, VA 22030, USA
School of Resource and Environment, University of Electric Science and Technology, Chengdu 611731, China
Authors to whom correspondence should be addressed.
Academic Editors: Yichun Xie and Wolfgang Kainz
ISPRS Int. J. Geo-Inf. 2017, 6(1), 21;
Received: 16 October 2016 / Revised: 9 January 2017 / Accepted: 16 January 2017 / Published: 19 January 2017
(This article belongs to the Special Issue Spatiotemporal Computing for Sustainable Ecosystem)
PDF [2415 KB, uploaded 19 January 2017]


With the widespread deployment of ground, air and space sensor sources (internet of things or IoT, social networks, sensor networks), the integrated applications of real-time geospatial data from ubiquitous sensors, especially in public security and smart city domains, are becoming challenging issues. The traditional geographic information system (GIS) mostly manages time-discretized geospatial data by means of the Structured Query Language (SQL) database management system (DBMS) and emphasizes query and retrieval of massive historical geospatial data on disk. This limits its capability for on-the-fly access of real-time geospatial data for online analysis in real time. This paper proposes a hybrid database organization and management approach with SQL relational databases (RDB) and not only SQL (NoSQL) databases (including the main memory database, MMDB, and distributed files system, DFS). This hybrid approach makes full use of the advantages of NoSQL and SQL DBMS for the real-time access of input data and structured on-the-fly analysis results which can meet the requirements of increased spatio-temporal big data linking analysis. The MMDB facilitates real-time access of the latest input data such as the sensor web and IoT, and supports the real-time query for online geospatial analysis. The RDB stores change information such as multi-modal features and abnormal events extracted from real-time input data. The DFS on disk manages the massive geospatial data, and the extensible storage architecture and distributed scheduling of a NoSQL database satisfy the performance requirements of incremental storage and multi-user concurrent access. A case study of geographic video (GeoVideo) surveillance of public security is presented to prove the feasibility of this hybrid organization and management approach. View Full-Text
Keywords: real-time geospatial data; NoSQL; RDBMS; data management; public security; hybrid databases; GeoVideo real-time geospatial data; NoSQL; RDBMS; data management; public security; hybrid databases; GeoVideo

Figure 1

This is an open access article distributed under the Creative Commons Attribution License which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited (CC BY 4.0).

Share & Cite This Article

MDPI and ACS Style

Wu, C.; Zhu, Q.; Zhang, Y.; Du, Z.; Ye, X.; Qin, H.; Zhou, Y. A NoSQL–SQL Hybrid Organization and Management Approach for Real-Time Geospatial Data: A Case Study of Public Security Video Surveillance. ISPRS Int. J. Geo-Inf. 2017, 6, 21.

Show more citation formats Show less citations formats

Note that from the first issue of 2016, MDPI journals use article numbers instead of page numbers. See further details here.

Related Articles

Article Metrics

Article Access Statistics



[Return to top]
ISPRS Int. J. Geo-Inf. EISSN 2220-9964 Published by MDPI AG, Basel, Switzerland RSS E-Mail Table of Contents Alert
Back to Top