Storage method of real-time database

A database and data technology, which is applied in database indexing, digital data processing, structured data retrieval, etc., can solve the problems of complex query conditions for historical alarm data and complex quadruple structure, and achieves improved concurrent access capability, convenience and efficiency. The effect of quick query service

Active Publication Date: 2015-04-08
QINGDAO HISENSE TRANS TECH
View PDF3 Cites 15 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] It can be seen from the above that the type of historical alarm data is much more complex than the quadruple structure adopted by analog historical data and switch historical data, so the query conditions for historical alarm data are also more complicated than analog historical data and switch historical data much more

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
  • Storage method of real-time database
  • Storage method of real-time database
  • Storage method of real-time database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0061] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below with reference to the accompanying drawings and examples.

[0062] This embodiment provides a storage method for a real-time database.

[0063] figure 1 It is a schematic flowchart of the storage method of the real-time database in the embodiment of the present invention. figure 2 It is a schematic diagram of the storage method of the historical data of the real-time database in the embodiment of the present invention (the storage method of the historical alarm data and figure 2 similar, not in figure 2 shown in ). Such as figure 1 and figure 2 As shown, the storage method of the real-time database in the embodiment of the present invention mainly includes the following steps:

[0064] Step 11, when writing the historical data and the historical alarm data, respectively write the historical data and th...

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 storage method of a real-time database. The method comprises the following steps: during writing of history data and history alarm data, writing the history data and the history alarm data into a corresponding memory table and a corresponding operation log buffer area respectively; when a current memory table is full, compressing the history data or the history alarm data in the current memory table, writing the compressed history data or history alarm data into a minute scale file, and applying for a new memory table for serving as a current memory table; combining threads, checking periodically, and combining a plurality of minute scale history data files and history alarm data into a day scale history data file and a history alarm data file respectively at preset time every day; combining a plurality of day scale files into a month scale file respectively at preset time every month; combining a plurality of month scale files into a year scale file respectively at preset time every year. Through the method, history data and history alarm data can be stored and accessed simultaneously in the real-time database, and the storage and access speeds of the history alarm data are increased.

Description

technical field [0001] The invention relates to a real-time database technology, in particular to a storage method of a real-time database. Background technique [0002] Currently, relational databases are generally used in many fields to store historical data. However, in many application scenarios with high-frequency sampling and massive data (for example, comprehensive monitoring of rail transit), relational databases have encountered bottlenecks in read and write performance and storage capacity, and it is difficult to meet the needs of comprehensive monitoring systems for historical data processing. . Taking the field of integrated rail transit monitoring as an example, operations such as report statistics, accident inversion, and training simulation all need to process massive amounts of historical operation data. Therefore, integrated monitoring systems have higher and higher requirements for historical data processing, and relational databases It is becoming more a...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/219G06F16/22
Inventor 廖常斌万思军刘见刘东海宋艳荣张洪波
Owner QINGDAO HISENSE TRANS TECH
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