Method for storing IOT time series data related to geographical location information

Abstract

The invention provides a method for storing IOT time series data related to geographical location information, and belongs to the field of computer big data storage. The method includes the steps that (1) latest data information is stored to a latest data cache table; (2) base point time is determined, and a time index table major key is generated; (3) increment time, geohash codes and actual data are stored to a time index table in a column family of a corresponding data row; (4) a space-time index table major key which is formed by base point space and base point time in a combined mode is generated according to the geohash codes; (5) increment time, increment space, equipment IDs and actual data are stored to a space-time index table in a column family of a corresponding data row; (6) data information is inquired. By means of the method, the IOT time series data related to the geographical location information can be stored and inquired quickly, and the mass IOT time series data management system requirement related to the geographical location information can be effectively met.

Description

technical field [0001] The invention relates to the field of computer big data storage, in particular to a time series data access method of the Internet of Things associated with geographic location information. Background technique [0002] In recent years, with the maturity of Internet of Things technology and the rapid expansion of Internet of Things technology in various industries, online monitoring and management of Internet of Things sensors has become particularly important. In the face of massive IoT sensors and massive sensor time series data, what method to use to quickly store and query is an important issue. The following takes the vehicle driving management system as an example to visualize the practical issues of IoT time-series data storage and query associated with geographic location information. In the vehicle driving management system, the management of the vehicle driving route works based on the time series position coordinate points recorded by the v...

AI Technical Summary

Problems solved by technology

[0004] Due to the actual needs, not only the total amount of data and throughput requirements for the time series data of the Internet of Things that can be stored and associated with geographic location information are required, but also the ability to quickly obtain data in a specified time range or a specified space range is required. The time series data of the Internet of Things associated with geographical location information is difficult to meet the above requirements using traditional data storage methods

Images