Real-time data storage and reading method of relational database

Abstract

The invention discloses a real-time data storage and reading method of a relational database, and the method comprises the following steps of real-time data storage: receiving external data; searching a data cache block corresponding to the received data; utilizing the data recorded by the data cache block to judge whether the currently received data is required to record or not; writing the currently received data into the data cache block; judging whether the data cache block is filled or not; submitting the data in the data cache block to a database engine; and real-time data reading: transmitting a data inquiry request; searching a data cache block corresponding to the inquired data; judging whether the currently inquired data is completely filled in the data cache block; submitting an inquiry request to the database engine, and writing the data returned by the database engine into a temporary cache zone; restoring corresponding data; and merging the data in the data cache block and the data in the temporary cache zone, and returning the inquiry result. Due to the adoption of the method, the problems that the traditional relational database is slow in reading-writing speed and poor in access performance can be solved.

Description

technical field [0001] The invention relates to a method for storing and reading data of a database, in particular to a method for storing and reading real-time data of a relational database. Background technique [0002] The production process of an enterprise is a constantly changing dynamic process, and the process parameters that characterize the production operation, such as temperature, pressure, flow, liquid level, etc., are constantly changing; the material basis for the existence of the production process of the enterprise is the production equipment, and the operation of the production equipment Parameters such as status, current, voltage, power, vibration indicators, etc. are also constantly changing; environmental conditions such as atmospheric pressure, temperature, humidity, flammable, explosive, toxic, and harmful gas concentrations in the production process are also changing. constantly changing. [0003] The real-time data of the production process is undou...

AI Technical Summary

Problems solved by technology

[0032] Purpose of the invention: In view of the problems and deficiencies in the above-mentioned prior art, the purpose of the invention is to provide a real-time data storage and reading method of a relational database, which solves the problem of slow reading and writing speed when the traditional relational database accesses large-scale real-time data. , poor access performance, and low storage efficiency

Images