Real-time database history data organizational management method

Abstract

The invention discloses a real-time database history data organizational management method. The method mainly comprises: real-time database history buffer area management and real-time database history file indexing modes. Through the history data organizational management method disclosed by the invention, a memory space with a designated size is allocated to the history data buffer area in advance, and the buffer area reading / writing management is performed in the memory space in a unified manner; the history data can be quickly written through history file management and the improved mode of indexing the history data by use of b+ tree in combination with proper buffer policy, page request mode and dirty page cleaning mode; and a history data index is established at relatively low cost at the time of writing so that the search for history data is very efficient. Meanwhile, by adopting a history data buffer area with a fixed size and a management mode of unifying reading / writing and buffering, the history data management model is greatly simplified, and the stability of the whole real-time database history data management module is improved.

Description

Technical field [0001] The invention relates to real-time database technology, in particular to a method for managing historical data of a real-time database. Background technique [0002] Real-time database is the product of the combination of database technology and real-time system. Real-time databases are widely used in process industries (petrochemical, electric power, steel). It can be used for automatic collection, storage and monitoring of the production process, and it can also store multi-year data of each process point online. It is the core of the enterprise MES. However, the real-time database does not exist in isolation. It forms complex systems such as SIS and ERP together with other hardware and software components, which involves a series of complex systems such as DCS, PLC, fieldbus, relational database, and man-machine interface configuration. concept. Therefore, the quality of a real-time database depends not only on its own, but also on whether it can work...

AI Technical Summary

Problems solved by technology

[0004] The current real-time database products have many problems in the organization and management of historical data, which are mainly reflected in (1) using multiple small files of fixed size to store historical data, which makes the management process of historical files very complicated and the performance is not good. High (2) The data indexing method of historical data files is relatively simple, lacks flexibility, and the performance of historical data search is not good. (3) The buffer management of historical files is not paid attention to, and the file buffer mechanism borrowed from the operating system itself is too dependent. It cannot effectively adapt to the laws of real-time database historical data access, so the efficiency of writing and reading historical data is not high

Images