Cloud-based flow data storage system and query method thereof

Abstract

The invention discloses a cloud-based flow data storage system which comprises a layer of Internet of Things, a cloud terminal and a gateway, wherein the layer of Internet of Things is physically connected with the cloud terminal; the Internet of Things is used for collecting the flow data generated in an industrial automatic production process and transmitting to the cloud terminal; the cloud terminal comprises a flow data processing system, a controller and a relational database; the flow data processing system in the cloud terminal is used for storing the received flow data as a historical data; the controller is used for inquiring the historical data in the flow data processing system, storing to the relational database and deleting the data from the flow database. The invention also discloses a query method. According to the cloud-based flow data storage system and the query method provided by the invention, data can be effectively stored and processed, so that not only can the cost of the server system be lowered, but also the effect of quickly inquiring the real-time data is achieved.

Description

technical field [0001] The invention relates to the field of industrial automation, in particular to a cloud storage system and query method for industrial automation flow data. Background technique [0002] With the wave of Industry 4.0, the level of informatization in the manufacturing industry is getting higher and higher, and a large amount of real-time data will be generated correspondingly in the process of industrial automation production. These data are stream data. The continuous generation, mass and real-time characteristics of stream data make the storage and query of such data extremely difficult. Using localized relational data for processing will greatly delay the speed of data query and the amount of stored data. Aiming at this problem, a lot of researches have been done at home and abroad. A more traditional approach is to solve this problem locally by using a real-time database or integrating a real-time database with a relational database. However, in th...

AI Technical Summary

Problems solved by technology

[0003] In order to solve the problem of real-time query of streaming data and the technical problem of limited local storage capacity, the present invention proposes a cloud-based streaming data processing system and its storage method, which can solve the problem of real-time query of streaming data and local storage capacity limited problems, and distinguish real-time data from historical data in streaming data, which can effectively store and process data, which can not only reduce the cost of the server system, but also achieve the effect of fast query of real-time data

Images