A system implementation method for data storage and push of a large number of devices in the Internet of Things system

Abstract

The invention discloses a system implementation method for data storage and push of a large number of devices in the Internet of Things system, including the following steps: Step 1: respectively divide each device into the group to which it belongs; Step 2: query according to the source of the data collected from the device device-topic table, get the group topic to which the data belongs, and then insert it into the push-data table; Step 3: Establish a mapping relationship between topic and url, and insert it into the okhttp-push table; Step 4: Use okhttp-push The value of topic and mid in each row in the push table is used to query the push-data table, and the data under the topic that has not been successfully received by the user corresponding to the url address is sent sequentially with okhttp; step 5: through the response data of okhttp , to determine whether the user has successfully received the push message, and if it is successfully received, update the mid corresponding to the topic and url in the okhttp‑push table. The present invention realizes storing a large amount of data collected from various devices, such as gateway devices, terminal nodes and other arbitrary devices, in a database, and pushing them to each user.

Description

technical field [0001] The invention relates to the technical field of data storage and pushing. More specifically, the present invention relates to a system implementation method for data storage and push of a large number of devices in the Internet of Things system. Background technique [0002] In the Internet of Things system, there are a large number of various types of equipment, and a large amount of data gathered from various types of equipment needs to be stored in the database and pushed to each user by category. The traditional implementation method is to bind each piece of data collected from the device to the url address to be pushed, and then insert it into the database. When the same piece of data is to be pushed to several different url addresses, several records with the same message content need to be inserted into the push data table push-data, that is, the total number of records in the database is equal to the number of messages multiplied by the number...

AI Technical Summary

Problems solved by technology

That is, there are a large number of concurrent insert and modify operations on the push-data table. With the increase of device data, the database will become more and more the bottleneck of system performance.

Images