Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

A real-time database online expansion method, system, equipment and storage medium

A database and data table technology, applied in the direction of database design/maintenance, database update, database index, etc., can solve the problem of inability to dynamically expand the real-time database, and achieve the effect of dynamic expansion requirements.

Active Publication Date: 2021-11-16
XIAN THERMAL POWER RES INST CO LTD +1
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Aiming at the technical problems existing in the prior art, the present invention provides a real-time database online expansion method, system, equipment and storage medium to solve the technical problem that the real-time database cannot be dynamically expanded in the existing distributed control system

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
  • A real-time database online expansion method, system, equipment and storage medium
  • A real-time database online expansion method, system, equipment and storage medium
  • A real-time database online expansion method, system, equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0085] The following takes the expansion process of the alarm database in the distributed control system of a certain power plant as an example; wherein, before the expansion, the alarm database contains three data tables, and the IDs of the three data tables are respectively No. 1 data table and No. 2 data table. Data table No. 3 and data table No. 3; first expand the capacity of data table No. 2. The maximum number of tuples of No. 2 data before expansion is 1000, and the maximum number of tuples after expansion is 1500.

[0086] This embodiment provides a real-time database online expansion method, including the following steps:

[0087] Step 1, according to the format of original real-time database, set up blank data file; Among the present invention, blank data file comprises header, index area and data area; The preservation path of blank data file is identical with original real-time database, and the title of blank data file is "alarm database+exp.dat"; the format of t...

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 online capacity expansion method, system, equipment and storage medium, comprising: establishing a blank data file according to the format of the original real-time database; mapping the blank data file to the memory, and copying the table according to the preset expansion Head data to the blank data file, and modify the maximum number of tuples; set the index area and data area capacity of the blank data table to the preset capacity, and rebuild the index to obtain the expanded data file; the original real-time database The original data is copied to the expanded data file, and the memory is mapped to the expanded data file to obtain the expanded real-time database; the invention can complete the expansion of the real-time database without restarting and loading the newly imported data database Update to realize the online expansion of the real-time database; during the expansion process, there is no need to stop the original real-time database query and other services, so as to realize the dynamic expansion requirements of the real-time database.

Description

technical field [0001] The invention belongs to the technical field of distributed control systems, and in particular relates to a real-time database online expansion method, system, equipment and storage medium. Background technique [0002] Distributed Control System (DCS) is a new type of control equipment that uses computer technology to centralize monitoring, operation, management and decentralized control of industrial production processes. It is widely used in industrial production fields such as electric power; The scale of the system is getting bigger and bigger, the structure is more and more complex, and the management of power equipment is becoming more and more important. [0003] In the field of industrial production such as electric power, the system configuration and other data in the current distributed control system are generally stored in the real-time database; in order to ensure the access speed of the system, the maximum number of tuples of all data ta...

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 Patents(China)
IPC IPC(8): G06F16/21G06F16/22G06F16/23G05B19/418
CPCG06F16/21G06F16/2228G06F16/2379G05B19/41835Y02P90/02
Inventor 张军杨渊史豪杰杨柳王宾王鑫张斌蔡戎彧杜明伟
Owner XIAN THERMAL POWER RES INST CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products