Online memory database loading method

A database and data technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as inability to optimize data arrangement, complex application processing, performance impact, etc., and achieve the effect of increasing application complexity

Active Publication Date: 2011-05-18
NR ELECTRIC CO LTD +1
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The disadvantage is that special processing needs to be applied, and the application processing is

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
  • Online memory database loading method
  • Online memory database loading method
  • Online memory database loading method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0032] Take a substation monitoring system as an example. The real-time database scadamdl stores all the equipment that needs to be monitored in the substation, including information about switches, transformers, etc.; the process fe_server is responsible for communicating with the physical switch, obtaining the status of the physical switch, and recording it in the database; the process scada_server traverses scadamdl periodically , when the switch state changes, an alarm signal is generated to prompt the operator. The following example describes the process of how to add a switch in the database.

[0033] 1. There is a Breaker table in Scadamdl that describes the switch information. Among them, the field Name is the name of the switch (String type), and Status is the state of the switch (Bool type). Name can only be modified during maintenance, and will not change during runtime, so it is regarded as static data; Status can only be modified during runtime (corresponding to...

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 memory database loading method. A database is divided into a dynamic subarea and a static subarea for storing respectively. The database loading comprises the following steps in time process order: 1, in an initial stage, modifying data on a maintenance database independent of an online database; 2, when starting loading data, loading the data in the static subarea of a new database into a memory; 3, finishing modifying, namely finishing loading the static subarea of the new database; 4, finishing performing log increment on the dynamic subarea of an old database; 5,transmitting a loading switching event to the database connection of each application process through message oriented middleware by using a database server; 6, switching all application to the new database and performing log deletion on the dynamic subarea; and 7, finishing unloading the old database, wherein the online database is the new database. When loading the new database, the online loading of the memory database is realized by firstly loading a new static subarea, sharing the dynamic subarea by the new database and the old database, and then switching the database connection of the application process to the new database quickly from the old database in turn, and finally unloading the old database.

Description

technical field [0001] The invention relates to a method for loading a memory database and various monitoring and real-time analysis and calculation software for electric power systems using the method. Background technique [0002] At present, the real-time monitoring software of electric power automation generally uses the memory database as the basis of data processing. This type of software has high requirements on real-time and continuous operation capabilities, and requires its data maintenance process to minimize the impact on system operation. [0003] Taking a typical database maintenance process as an example, a substation contains hundreds of objects, and it takes several days to input parameters. During this process, due to incomplete data or incorrect parameters, the substation and its transformers cannot participate in the process. analysis caculate. Only when all parameters are entered and verified to be correct, the substation can participate in the analysis...

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 NR ELECTRIC CO LTD
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