Real-time database history data organizational management method

A historical data and organizational management technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problem of not being able to effectively adapt to the laws of historical data access in real-time databases, low performance, and complex historical file management processes, etc. question

Inactive Publication Date: 2012-09-05
华北计算机系统工程研究所
View PDF3 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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 s

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Real-time database history data organizational management method
  • Real-time database history data organizational management method
  • Real-time database history data organizational management method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0049] figure 2 It is a schematic diagram of the three-stage page request mechanism in the first embodiment. Such as figure 2 As shown, the process of the page request mechanism mainly includes the following steps:

[0050] Step 101: Locate the page address through a hash function.

[0051] After the user gives the requested file number and page number, they are combined into a long integer. Through the hash function, find the corresponding hash address, scan the page table entries one by one along the linked list, compare whether the pgno field of the page table entry matches the given page number, and if it matches, return the corresponding page address. If the scan is completed , If the corresponding page table entry is not found, turn to page fault processing.

[0052] When scanning on the corresponding hash address, it should be noted that when a page table entry is queried, if the page table entry has been matched, and the content of the corresponding buffer page is accesse...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

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...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/30
Inventor 徐新国朱廷劭杜冀秦
Owner 华北计算机系统工程研究所
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap