CN1258728C - Application method and network system of fully distributed protected information processing system real-time database - Google Patents
Application method and network system of fully distributed protected information processing system real-time database Download PDFInfo
- Publication number
- CN1258728C CN1258728C CN 200310103518 CN200310103518A CN1258728C CN 1258728 C CN1258728 C CN 1258728C CN 200310103518 CN200310103518 CN 200310103518 CN 200310103518 A CN200310103518 A CN 200310103518A CN 1258728 C CN1258728 C CN 1258728C
- Authority
- CN
- China
- Prior art keywords
- real
- node
- time data
- network
- data base
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Expired - Lifetime
Links
- 238000000034 method Methods 0.000 title claims abstract description 48
- 230000010365 information processing Effects 0.000 title abstract description 7
- 230000006870 function Effects 0.000 claims abstract description 26
- 230000005540 biological transmission Effects 0.000 claims abstract description 10
- 230000008569 process Effects 0.000 claims description 29
- 238000012545 processing Methods 0.000 claims description 19
- 238000004891 communication Methods 0.000 claims description 11
- 238000012423 maintenance Methods 0.000 claims description 7
- 230000002093 peripheral effect Effects 0.000 claims description 7
- 238000011084 recovery Methods 0.000 claims description 5
- 230000001360 synchronised effect Effects 0.000 claims description 4
- 230000000977 initiatory effect Effects 0.000 claims description 3
- 230000002159 abnormal effect Effects 0.000 claims description 2
- 238000007726 management method Methods 0.000 description 18
- 238000010586 diagram Methods 0.000 description 6
- 238000005259 measurement Methods 0.000 description 5
- 230000011664 signaling Effects 0.000 description 5
- 210000001367 artery Anatomy 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 4
- 210000003462 vein Anatomy 0.000 description 4
- 230000006399 behavior Effects 0.000 description 2
- 230000007246 mechanism Effects 0.000 description 2
- 206010033799 Paralysis Diseases 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 239000012141 concentrate Substances 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000008570 general process Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000001681 protective effect Effects 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
- 239000011800 void material Substances 0.000 description 1
Images
Landscapes
- Computer And Data Communications (AREA)
Abstract
The present invention relates to an application method and a network system thereof for a distributed protected information processing system real-time database used for electric network relay protection and failure information processing. The distributed protected information processing system real-time database is used as a database management system (DBMS), provide DBMS basic functions, and is a real-time system based on a memory, when used as a data set, the distributed protected information processing system real-time database is an integral body. However, the of fully distributed protected information processing system real-time database is distributed on different network nodes on a physical level, the original copy of the distributed database is positioned on a data server, and the duplicate copy of the database is stored on a different node. Thus, the cost of network transmission is reduced. In the system, each node has a local data base management system and high self-government performance, and the position of the node is transparent to users. Compared with a centralized database, and the present invention has high reliability and flexibility.
Description
Technical field:
The present invention relates to electric grid relay protection and failure message treatment technology, relate in particular to a kind of application process of the distributed protection information handling system real-time data base that electric grid relay protection and failure message handle and its network system of being used for.
Background technology:
In recent years; along with the fast development of computing machine and network communications technology with popularize; the operation and management level of electrical network; protection; control; very big variation has all taken place in every aspects such as decision-making; so electric grid relay protection and failure message disposal system; as one with dispatching centers at different levels; transformer station; the generating plant; isolated islands such as concentrator station carry out integrated connection; and can with existing SAS (electric substation automation system); the EMS system; mis system; Internet etc. realize interconnected; relay protection running management is provided; failure data analyzing; the senior application of electric power; the system of functions such as expert system has obtained increasing concern.
Construct an outstanding electric grid relay protection and failure message disposal system, healthy and strong, good real time data processing kernel is crucial.The network structure pattern that at present in electric grid relay protection and failure message disposal system, generally adopts Client/Server and Browse/Server to combine; functions such as Server end (server) carrying communication scheduling, Message Processing, data base administration and WEB service, and Client end (client) runs application and the WEB inquiry.Based on this pattern, the many employings in storehouse in real time are centralized, be that real-time data base concentrates on the Server end, the application program of moving on other network node does not load real-time storehouse as the Client end, send request to the Server end when application program needs data, the Server response request also provides corresponding service.The building method in this real-time storehouse can guarantee the consistance of data with comparalive ease, but weak point is:
1) system is high for the reliability requirement of Server end, in case Server brings out existing problem, certainly will cause the paralysis of the real-time information interaction of system;
2) system requires must satisfy the data request service of online a plurality of nodes simultaneously than higher for the information processing capability of Server end;
3) strengthened the expense of Network Transmission;
4) the expansion leeway of system is little.
At above problem, the method for some solutions has appearred at present, such as adopting dual-computer redundancy mode treatment problem 1, deal with problems 2 with the high-performance data server, improve bandwidth and network transfer speeds and solve problem 3.But for reducing cost, the dirigibility of raising system configuration and system are to the consideration of fault-resistant ability, and above solution is not the scheme of ratio of performance to price optimum, and this then is the immediate cause that we propose the distributing real-time data bank system.
Summary of the invention:
Distributed protection information handling system real-time data base at first is a data base management system (DBMS), and it provides the basic function of DBMS, comprising: permanent data management, and it comprises the definition, storage, maintenance etc. of database; Active data access, various data manipulation, query processing, integrity checking; Transaction management, scheduling, concurrent control and execution; Access control, safety examination; The reliability Restoration Mechanism of database etc.
Secondly, it is a real-time system based on internal memory, has internal storage access algorithm efficiently, and implement that concurrent transaction is handled, the priority policy of Real-time Transaction etc.
It is a distributing real-time data bank system on the network concept at last, and it possesses perfect network management and each application process management and running function of this node, Message Processing center, data security, concurrent behavior intervention, data synchronization processing strategy etc.It belongs to same integral body in logic as being integrated into of data, but be distributed on the physical layer on the different network nodes, consider the performance and the efficient of system, distributed data base is placed on data server with the database original, while leaves the copy of database on the different nodes in again, to reduce the expense of Network Transmission.In system, each node all has the data base management system (DBMS) of oneself, has the autonomy of height, and its position is transparent for the user, compares with centralized data base, and reliability and dirigibility are higher.
Be the network structure pattern that adopts Client/Server and Browse/Server to combine equally, but break down or groundless will can not influence the work of other nodes when withdrawing from when arbitrary node on the network.When restarting after malfunctioning node recovers normally, system can obtain database automatically from other node, and this has improved the fault-resistant ability of system greatly.System provides the master/slave data server of dual-computer redundancy pattern, and this makes Database Backup, automatic recovery ability show more outstanding.
System is that upper layer application provides wieldy API in the mode of middleware, and this is very easy to the new application program of exploitation based on real time access.API supports the user to pass through the interconnected of Web interface, SQL interface, file interface realization and other system.
In addition, distributed mode of operation has increased the required expense of copy data storehouse renewal operation.Therefore to the loading in copy data storehouse, deposit, strategy such as synchronous refresh, data consistency and implementation method be an important feature of native system.
Description of drawings
Fig. 1 is the node distribution schematic diagram of distributing real-time data bank;
Fig. 2 is the modular structure synoptic diagram of distributing real-time data bank;
Fig. 3 is a real-time data base start-up course process flow diagram;
Fig. 4 is the general process flow diagram that connects real-time storehouse of using.
Embodiment
● the major function that system possesses
The major function of system has the following aspects:
1. be applied to the distributed real-time system in electric grid relay protection and the failure message process field.
2. can realize between many copies real-time data base and the original synchronously.
3. system provides stable application programming interfaces (API), conveniently carries out the exploitation of new upper layer application process.
4. application program adopts " plug and play " technology, i.e. the unlatching of upper layer application does not influence the operation in real-time storehouse.
5. the arbitrary node fault does not influence the real-time storehouse operation of other node in the network.
6. the database change behavior on the arbitrary node will feed through to whole working field automatically, each node synchronous refresh in the territory.
7. can realize " node manually shields ".After shielding was provided with, the data access of this node and network others node disconnected, up to removing shielding setting.
8. the incident and the warning function that have priority policy.
9. online data maintenance function.
The whole network to the time function.
11. the redundant processing capacity of data server two-node cluster hot backup.
12. support several data storehouse access interface (file I/O, SQL, Web etc.).
● the node of real-time data base distributes
The node of full distributed protection information handling system real-time data base on network distributes as shown in Figure 1.
B01-master data server node.The total system real-time data base is based upon this node the earliest, so be referred to as original.
B02-is equipped with data server node.This node and B01 form the data server of stand-by heat each other.
B03-communication processor node.The function of this node is to finish communicating by letter between protection information handling system main website that is placed on the power-management and communication centre and the substation that is placed on factory's station end.
The B04-workstation nodes.This node carries out the operator's console of system operation, maintenance for the operator.
The B05-Web workstation nodes.This node provides the issue of Web information for the computing machine that links to each other with system.
● the modular structure of real-time data base
Figure 2 shows that the modular structure synoptic diagram of real-time data base.
The B01-log management module is finished the record to various operations.This module is carried out message exchange by B07 issued transaction and scheduler module and other module.
The B02-network management module is finished the management to the master station communication network information.This module is carried out message exchange by B07 issued transaction and scheduler module and other module.
B03-data safety management module is finished the security credential management of various operations.This module is carried out message exchange by B07 issued transaction and scheduler module and other module.
B04-data backup and fault recovery module are finished data backup under system's normal condition and the fault recovery under the abnormal conditions.This module is carried out message exchange by B07 issued transaction and scheduler module and other module.
B05-is redundant to be handled, and realizes the dual-computer redundancy function.This module is carried out message exchange by B07 issued transaction and scheduler module and other module.
B06-management of process and scheduler module realize the management of process that intranodal needs, and finish the scheduling of process.This module is carried out message exchange by B07 issued transaction and scheduler module and other module.
B07-issued transaction and scheduler module.This module is the core of whole real-time data base, and other all functions processing module all is to carry out message exchange by this module.
The B08-data processing unit is realized functions such as real time data processing, process data processing, historical data processing, statistical computation.Real time data processing is directly finished real time data maintenance and inquiry by B09 real-time data access interface; Process data is handled, historical data is handled and statistical computation can be finished Processing tasks directly by B10 historical data access interface visit B12 disk file and B13 business database.The task of data processing then obtains from other module by B07 issued transaction and scheduler module.
B09-real-time data access interface module, management by realizing the real time data region of memory and access algorithm provide maintenance and the inquiry to real time data.The information source of real time data operation both can be the data processing unit of B08, also can come from other module by B07 issued transaction and scheduler module.The deposit data zone of this module is B11 shared drive data field and B12 disk file.
B10-historical data access interface module.This module visits B12 disk file for other each functional module and the B13 business database provides operation-interface.
B11-shared drive data field.Real time data is deposited according to the real-time data base data structure definition in this data area.Other module is visited this zone by the access algorithm that the real-time storehouse of B09 access interface provides.
The B12-disk file.The backup of real time data and special historical data are all deposited in this zone.
The B13-business database.Historical data deposits business database in by B10 historical data access interface, and each section of real time data also deposits business database in.
● the information structure model of real-time data base
The information structure model of real time data mainly comprises: the database of standing, system library and parameters of electric power storehouse.
(1) the database information structure of standing
| Content | The shared drive piece | Explanation | |
| The attribute of standing | ST_Head： | Counter structure Station_Head counts siRealStNum etc. comprising the substation | |
| The description of standing | StationDesc 1ST Size 1ST OffSet 2ST Size 2ST OffSet ...... | The stand distribution condition of shared drive under the database: 1～siRealStNum substation, the size of each shared memory block in substation and start offset amount | |
| Substation 1 | The substation attribute | 1ST tagSubStation | Deposit the bulk properties of substation, as name of station, IP address, protection/oscillograph number etc.; Referring to structure tagSubStation. |
| The substation is described | 1ST 1 ProtDev OfrSet 1ST 2 ProtDev OffSet ...... 1ST 1 Bay OfrSet ...... 1ST 1 Recorder OffSet ...... | The internal memory reference position of each protection of the distribution condition of shared drive, interval and oscillograph under the database of substation | |
| Substation 1 protection tabulation | 1ST 1 ProtDev 1ST 2 ProtDev ...... | Each protection of the property value of each protective device is a structure tagProtDev in the substation | |
| 1 interval 1, substation | 1ST 1 Bay tagBay | 1 property value is referring to structure tagBay at interval | |
| 1ST 1 Bay 1 Ana 1ST 1 Bay 2 Ana ..... 1ST 1 Bay 1 Dig 1ST 1 Bay 2 Dig ..... 1ST 1 Bay 1 Pulse 1ST 1 Bay 2 Pulse ..... | The physical quantity at interval 1 comprises remote measurement: each remote measurement is structure tagAnalog remote signalling: each remote signalling is a distant arteries and veins of structure tagDigital: each distant arteries and veins is a structure tagPulse | ||
| Interval 2 | 1ST 2 Bay | Similar interval 1, just how many differences of each physical quantity | |
| ...... | ...... | ||
| Substation 1 oscillograph 1 | 1ST 1 Recorder | The property value of oscillograph 1 is referring to structure tagRecorder in the substation | |
| 1ST 1 Recorder 1 Ana 1ST 1 Recorder 2 Ana ..... 1ST 1 Recorder 1 Dig 1ST 1 Recorder 2 Dig ..... | The physical quantity of oscillograph 1 in the substation comprises the oscillograph remote measurement: referring to the remote signalling of structure tagRecorderAna oscillograph: referring to structure tagRecorderDig | ||
| Substation 1 oscillograph 2 | ..... | Similar oscillograph 1 is how many differences of physical quantity just | |
| ....... | |||
| Substation 2 | Similar substation 2 | ||
| .... | |||
| Substation N |
The database of standing is mainly handled following data: stand, at interval, protection, record ripple, at interval in remote measurement, at interval in remote signalling, at interval in distant arteries and veins, record mode intend passage, record wave number word passage
(2) system library message structure
| Content | Memory block | Explanation |
| System library is described | Sys_Head SiRealUserNum... siRealSysDisNum UserSize UserOff ... SysDigSize SysDigOff | Counter structure Sys_Head comprises user, node, process, communication port ... wait every number, memory size and skew (at the skew of system library) |
| User data block | User1 User2 ... | The tabulation of 1～siRealUserNum user data: each data is structure tagUser; |
| The Protocol piece | All be the tabulation of such data in each piece of similar user data block, each list items is that a structure is referring to source program | |
| The IONode piece | ||
| The NetNode piece | ||
| The Process piece | ||
| The computing formula piece | ||
| System Ana piece | ||
| System Dig piece | ||
| System Pulse piece | ||
| System Other piece |
System library is handled following data: user, process, stipulations, IO node, network node, computing formula, system's remote measurement, system's remote signalling, the distant arteries and veins of system
(3) parameters of electric power library information structure
| Content | Memory block | Explanation |
| The parameters of electric power storehouse is described | Power_Head SiRealLineNum UlLineSize UlLineOff ... SysDigSize SysDigofr | Counter structure Power_Head comprises number of lines, memory size and skew (at the skew in parameters of electric power storehouse) |
| The line parameter circuit value piece | Line_Recorder1 Line_Recorder2 ... | Each list items of the tabulation of 1～siRealLineNum line parameter circuit value is a structure tagLine_Recorder |
● the application management process of real-time data base
The structure of real-time data base realizes that by application management process LocalManager other application program is by calling operation and the visit of api function realization to real-time data base.LocalManager finishes two main tasks: one is to utilize information model to set up real-time data base, and another then is to handle real-time information, as: protection actuating signal, calling definite value, straighforward operation etc.
The real-time data base start-up course of LocalManager as shown in Figure 3.Each step function among Fig. 3 is explained as follows:
S01-reads this node configuration information.Because this method real-time data base of constructing is to be distributed in each node on the network, therefore need read the configuration information of this node earlier.
S02-judges whether this node is master server.Read the configuration information of this node among the S01, judged that by the node type of configuration whether this node is master server, establishes if master server then enters S03
Put the master server sign, judge whether this node is to be equipped with server otherwise enter S04.
S03-is provided with the master server sign.If this node is a master server, then need to be provided with the master server sign.
S04-judges whether this node is to be equipped with server.Judged result then judges whether it is to be equipped with server if not master server among the S02 in this step.If this node is to be equipped with server then to enter S05 server sign fully is set, otherwise enters S06.
S05-is provided with and is equipped with the server sign.If this node is to be equipped with server, then need to be provided with server sign fully.
Whether S06-judgment data storehouse is to load from this locality.The node type sign that obtains according to S03, S04, S05 determines whether this node is the original of database, and promptly whether real-time data base loads from this locality.Then enter S07 from this locality loading if desired the city edition sign is set, network edition sign is set otherwise enter S08.
S07-is provided with the city edition sign.If real-time data base need load from this locality, the city edition sign is set then.
S08-is provided with network edition sign.If real-time data base does not need to load from this locality, but obtains from network, network edition sign is set then.
S09-judges whether it is from the business database loading data.In the loading procedure of real time data, the data section that its Data Source keeps in business database or disk file nothing but exactly.Therefore, this step judges whether it is from the business database loading data, reads the business database sign if then enter the S10 setting, otherwise enter S11 data file path is set.
S10-is provided with and reads commercial storehouse sign.If desired from the business database loading data, this sign is set then.
S11-is provided with data file path.If not from the business database loading data, the path of data file is set according to the configuration information that reads among the S01 then.
S12-judges whether to carry out network port initialization.If the configuration network port then needs to enter the initialization of the S12 network port, judge whether this node is led or be equipped with server otherwise enter S16.
The initialization of the S13-network port.This step need be finished:
(4) set up TCP webserver port.This port is responsible for communicating by letter of this node and network others node.
(5) when this node is the network edition, set up TCP network data base synchronous port.This port by with network on other server communication, finish the initialization, Refresh Data of local data base, synchronously.
(6) set up UDP message processing threads group, finish the transmission of non-significant data.
S14-judges whether network port initialization is successful.Enter S16 if S13 network port initialization procedure is successful and judge that whether this node is main or is equipped with server, returns otherwise enter the S15 failure.
The S15-failure is returned.If the failure of the start-up course of real-time data base all enters this step.
S16-judges whether this node is active/standby server.If this node type is a server, then enter the active/standby server initialization of S17; Otherwise this node should be workstation, enters the initialization of S18 workstation.
The active/standby server initialization of S17-.This step need be finished:
(1) if the real-time data base on this node still was carried in the shared drive district originally, then directly connects the shared drive district.
(2) other node sends request of data on network, if do not receive the data that need in specified time period, perhaps clearly formulating this node is master server, then carries out the loading of local real-time data base.
(3) if receive the data that other node (should be master server) is sent in specified time period, then this node is to be equipped with server, and handles the data that receive on the network, carries out the establishment of local real-time data base.
(4) after this node is finished the loading of real-time data base to online transmission " in real time storehouse start successfully " message, and this node state sign is changed to running status.
The initialization of S18-workstation.This step need be finished:
(1) if the real-time data base on this node still was carried in the shared drive district originally, then directly connects the shared drive district.
(2) other node sends request of data on network, if in specified time period, do not receive the data that need, and the then loading procedure of real-time data base failure.
(3) if in specified time period, receive the data that other node (should be master server) is sent, then handle the data that receive on the network, carry out the establishment of local real-time data base.
(4) after this node is finished the loading of real-time data base to online transmission " in real time storehouse start successfully " message, and this node state sign is changed to running status.
S19-judges whether real-time storehouse loading procedure is successful.Judge according to the return results of S17, two steps of S18 whether the real-time data base loading procedure is successful.If success then enter S20 and start heartbeat is returned otherwise enter the S15 failure.
S20-starts heartbeat.The function of this step is after real-time data base loads successfully, sets up a module that is similar to " heartbeat ", shows whether the running status of this node is normal.
S21-judges whether this node is the network edition.If this node is the network edition, then need on network, notify other node, promptly enter S22; Otherwise entering S23 successfully returns.
S22-sends " Data Receiving is normal " message on network.When this node was the network edition, this node carried out synchronously with other node in the real-time data base loading procedure, if real-time data base loads successfully, then notified other node on network.
S23-successfully returns.This step shows that the start-up course of the real-time data base on this node finishes smoothly.
● peripheral applications is to the connection of real-time data base
General peripheral applications program need connect the real-time data base on this node, so that can conduct interviews and operate real-time data base.Figure 4 shows that general peripheral applications program connects the process flow diagram of real-time data base.Each step is explained as follows:
S01-obtains the memory database handle.Peripheral applications at first needs to obtain the handle of the real-time data base in the shared drive district when connecting database, enter S02 then and judge whether the handle that obtains is effective.
S02-judges whether the real-time data base handle is effective.If handle is effective, then enters S03 and read this node configuration information; Otherwise entering the S13 failure returns.
S03-reads this node configuration information.The effect of this step is should enter S04 then with judging some information that whether comprised this node in the real-time data base in order to make.
S04-judges the information whether this node is arranged in the real-time data base.If have then enter S05, return otherwise enter the S13 failure.
Whether S05-judges should with being the task manager module.The task manager module be each node than an indispensable functional module, other all functional module is all dispatched by task manager.Therefore, this module might not require to dispose in database, but exists as the functional module of acquiescence.If should then directly enter S07, otherwise enter S06 with being task manager.
S06-judges whether the information that should use is arranged in the real-time data base.Should use if in real-time data base, dispose, then can enter S07, return otherwise enter the S13 failure.
S07-creates client port.Behind an application start, must set up a client port that can connect real-time data base earlier and just can remove to connect the open serve port of real-time data base, enter S08.
S08-Connection Service port.The api function that provides by real-time data base removes to connect the serve port of real-time data base, so that visit real-time data base, enters S09 then and judges whether the connection real-time data base is successful.
S09-judges whether the connection real-time data base is successful.Judge whether successful connection of real-time data base according to the return results of S08 Connection Service port.If success then enters S10; Otherwise entering the S13 failure returns.
It is " RUN " that S10-is provided with process status, and sends " process initiation success message " on network.Initial conditions is S09.After should using the success of connection real-time data base, showing should be with having possessed the ability of visiting and operating real-time data base, the state of a process sign is set to the " RUN " state, and other node is notified in transmission " process initiation success message " on network, enters S11 then.
S11-starts heartbeat.The function of this step is after peripheral applications connects the real-time data base success, sets up a mechanism that is similar to " heartbeat ", shows whether the running status that should use is normal.
S12-successfully returns.This step shows and should finish smoothly with the process that connects real-time data base.
The S13-failure is returned.This step shows should be with connecting the real-time data base failure.
● the application interface function of real-time data base
Real-time data base provides simple clear and definite application programming interfaces (API) function library for the application of periphery and has deposited among the RtdbProt.dll, and other application program can realize visit and operation to real-time data base by calling each api function in this document.These API comprise:
■ Short RtGetStationEleIDByKey (byte bDataType, short siStKey, short siKey, short siParam) obtains element ID by the element KEY value of station database
■ short RtGetStationEleIDByName (byte bDataType, charu
*PName, short siParam1, short siParam2) obtain element ID by the element term of station database
■ short RtGetStationEleIDByGateName (bytebDataType, char
*PName, short siParam1 shortsiParam2) obtains the ID of measuring point element by the control point title of station database
■ short RtGetStationEleIDByIOAddrName (bytebDataType, char
*PName, short siParam1 is shortsiParam2) by the ID of IO address name acquiring measuring point element of station database
■ short RtGetSysEleIDByKey (byte bDataType, shortsiStKey, short siKey) is obtained the ID of element by the element KEY value of system library
■ short RtGetSysEleIDByName (byte bDataType, shortsiStID, char
*PName) obtain the ID of element by the element term of system library
(byte bDataType shortsiKey) obtains element ID by the element KEY value in parameters of electric power storehouse to ■ short RtGetPowerEleIDByKey
■ short RtGetPowerEleIDByName (byte bDataType, char
*PName) element term by the parameters of electric power storehouse obtains electric power element ID
■ short RtGetStationNum (void) obtains the number of standing in the real-time storehouse
■ short RtGetStationEleNum (short siStID, bytebDataType, short siParam) obtains the number of specifying designed element in the station
■ BOOL RtGetStationByID (short siStID, tagSubStation
*POutData) obtain the station information of specifying by station ID
■ BOOL RtGetStationEleByID (short soStID, bytebDataType, short siEleID, Char
*POutData shortsiParam) obtains designed element information in the station
■ BOOL RtSetStationEleAttr (byte bDataType, shortsiEleID, short siAttr, char
*PlnData, short siParam1, short siParam2) modification station Database Properties
■......
Native system can be applicable to main website, substation and the substation of electric grid relay protection and failure message disposal system.By full distributed real-time data base building method, can realize the function cutting of system module neatly, and can accomplish the unification of main website, substation and substation software.
Claims (4)
1. application process that is used for the distributed protection information handling system real-time data base that electric grid relay protection and failure message handle; described real-time data base is distributed on each node on the network; wherein the database original leaves on the master server; Database Replica leaves on other each node of network, and described method comprises step:
S01-reads this node configuration information;
S02-judges that whether this node is master server, if master server then enters S03, otherwise enters S04
S03-is provided with the master server sign;
S04-judges that whether this node is to be equipped with server, if this node is to be equipped with server then to enter S05, otherwise enters S06;
S05-is provided with and is equipped with the server sign;
Whether S06-judgment data storehouse is to load from this locality, loads from this locality if desired and then enters S07, otherwise enter S08;
S07-is provided with the city edition sign;
S08-is provided with network edition sign;
S09-judges whether it is from the business database loading data, if then enter S10, otherwise enters S11;
S10-is provided with and reads commercial storehouse sign;
S11-is provided with data file path;
S12-judges whether to carry out network port initialization, if the configuration network port needs the initialization of the network port, otherwise enters S16;
The initialization of the S13-network port;
(1) set up TCP webserver port, this port is responsible for communicating by letter of this node and network others node;
(2) when this node is the network edition, set up TCP network data base synchronous port, this port by with network on other server communication, finish the initialization, Refresh Data of local data base, synchronously;
(3) set up UDP message processing threads group, finish the transmission of non-significant data,
S14-judges whether success of network port initialization, if S13 network port initialization procedure success then enter S16, otherwise would enter S15;
The S15-failure is returned;
S16-judges that whether this node is active/standby server, if this node type is a server, then enters S17, otherwise enters S18;
The active/standby server initialization of S17-;
(1) if the real-time data base on this node still was carried in the shared drive district originally, then directly connects the shared drive district;
(2) other node sends request of data on network, if do not receive the data that need in specified time period, perhaps clearly formulating this node is master server, then carries out the loading of local real-time data base;
(3) if receive the data that other node is sent in specified time period, then this node is to be equipped with server, and handles the data that receive on the network, carries out the establishment of local real-time data base;
(4) after this node is finished the loading of real-time data base to online transmission " in real time storehouse start successfully " message, and this node state sign is changed to running status;
The initialization of S18-workstation;
(1) if the real-time data base on this node still was carried in the shared drive district originally, then directly connects the shared drive district;
(2) other node sends request of data on network, if in specified time period, do not receive the data that need, and the then loading procedure of real-time data base failure;
(3) if receiving other node in specified time period is the data that master server is sent, then handle the data that receive on the network, carry out the establishment of local real-time data base;
(4) after this node is finished the loading of real-time data base to online transmission " in real time storehouse start successfully " message, and this node state sign is changed to running status;
S19-judges the whether success of real-time storehouse loading procedure, if success then enter S20, otherwise would enter S15;
S20-starts heartbeat, is used to show whether the running status of this node is normal;
S21-judges that whether this node is the network edition, if this node is the network edition, then enters S22; Otherwise enter S23;
S22-sends " Data Receiving is normal " message on network;
S23-successfully returns.
2. method as claimed in claim 1, the real-time data base of wherein said node provides application programming interface API for the peripheral applications program, and API supports the user to pass through the interconnected of Web interface, SQL interface, file interface realization and other system.
3. method as claimed in claim 2, wherein the step of peripheral applications program connection real-time data base comprises:
P01-obtains the memory database handle;
P02-judges whether the real-time data base handle is effective, if handle is effective, then enters P03, otherwise enters P13;
P03-reads this node configuration information;
P04-judges the information whether this node is arranged in the real-time data base, if having then enter P05, otherwise enters P13;
Whether P05-judges should with being the task manager module, if should then directly enter P07, otherwise enter P06 with being the task manager module;
Whether P06-judges the information that should use in the real-time data base, should use if dispose in real-time data base, then enters P07, otherwise enters P13;
P07-creates client port;
P08-Connection Service port;
P09-judges whether the connection real-time data base is successful, if success then enters P10; Otherwise enter P13;
It is " RUN " that P10-is provided with process status, and sends " process initiation success message " on network;
P11-starts heartbeat, shows whether the running status that should use is normal;
P12-successfully returns;
The P13-failure is returned.
4. one kind is used for the network system that electric grid relay protection and failure message are handled, the protection information handling system real-time data base of application distribution wherein, and described real-time data base is distributed on each node of network system, and described network system comprises;
The master data server node loads the real-time data base original;
Be equipped with data server node, load the real-time data base copy, this node and master data server node form the data server of stand-by heat each other;
The communication processor node loads the real-time data base copy, is used to finish communicating by letter between protection information handling system main website that is placed on the power-management and communication centre and the substation that is placed on factory's station end;
Workstation nodes loads the real-time data base copy, is used for the operator's console that the operator carries out system operation, maintenance;
The Web workstation nodes loads the real-time data base copy, is used to the computing machine that links to each other with system that the issue of Web information is provided,
Described real-time data base comprises:
The B01-log management module is finished the record to various operations;
The B02-network management module is finished the management to the master station communication network information;
B03-data safety management module is finished the security credential management of various operations;
B04-data backup and fault recovery module are finished data backup under system's normal condition and the fault recovery under the abnormal conditions;
B05-is redundant to be handled, and realizes the dual-computer redundancy function;
B06-management of process and scheduler module realize the management of process that intranodal needs, and finish the scheduling of process;
B07-issued transaction and scheduler module, this module are the core of whole real-time data base, and other all functions processing module all is to carry out message exchange by this module;
The B08-data processing unit realizes that real time data processing, process data are handled, historical data is handled, the statistical computation function;
B09-real-time data access interface module, management by realizing the real time data region of memory and access algorithm provide maintenance and the inquiry to real time data;
B10-historical data access interface module, this module visits B12 disk file for other each functional module and the B13 business database provides operation-interface;
B11-shared drive data field, real time data is deposited according to the real-time data base data structure definition in this data area;
The B12-disk file, the backup of real time data and special historical data are all deposited in this zone;
The B13-business database, historical data deposits business database in by B10 historical data access interface, and each section of real time data also deposits business database in.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200310103518 CN1258728C (en) | 2003-11-06 | 2003-11-06 | Application method and network system of fully distributed protected information processing system real-time database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200310103518 CN1258728C (en) | 2003-11-06 | 2003-11-06 | Application method and network system of fully distributed protected information processing system real-time database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1542652A CN1542652A (en) | 2004-11-03 |
| CN1258728C true CN1258728C (en) | 2006-06-07 |
Family
ID=34333306
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 200310103518 Expired - Lifetime CN1258728C (en) | 2003-11-06 | 2003-11-06 | Application method and network system of fully distributed protected information processing system real-time database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1258728C (en) |
Families Citing this family (19)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100416562C (en) * | 2004-12-24 | 2008-09-03 | 许继集团有限公司 | Real time database management system for automatic system of electric power, and implementation method |
| US7941405B2 (en) * | 2007-03-30 | 2011-05-10 | Data Center Technologies | Password protection for file backups |
| US8886669B2 (en) * | 2008-03-21 | 2014-11-11 | Trimble Navigation Limited | File access via conduit application |
| CN101493826B (en) * | 2008-12-23 | 2012-12-19 | 中兴通讯股份有限公司 | Database system based on WEB application and data management method thereof |
| US8538907B2 (en) * | 2010-11-08 | 2013-09-17 | International Business Machines Corporation | Autonomous intelligent content items |
| CN102033930A (en) * | 2010-12-17 | 2011-04-27 | 北京世纪互联工程技术服务有限公司 | Distributed memory database system |
| CN102184209B (en) * | 2011-04-29 | 2014-03-12 | 中国电力科学研究院 | Simulation data accessing method based on power grid CIM (Common Information Model) interface |
| CN103020077A (en) * | 2011-09-24 | 2013-04-03 | 国家电网公司 | Method for managing memory of real-time database of power system |
| CN102436409B (en) * | 2011-11-04 | 2013-09-11 | 青岛海信网络科技股份有限公司 | Redundancy management and switching method of dual-computer redundancy system |
| CN102769664B (en) * | 2012-06-21 | 2015-07-01 | 许继电气股份有限公司 | Synchronous access method of realtime banks and transformer substation monitoring system |
| CN103077189B (en) * | 2012-12-20 | 2016-01-20 | 中国电力科学研究院 | A kind of parallel real-time database node positioning system towards bulk power grid |
| CN103218450B (en) * | 2013-04-26 | 2016-05-04 | 国电南瑞科技股份有限公司 | A kind of many application real-time data base method of data synchronization |
| CN104378439A (en) * | 2014-11-24 | 2015-02-25 | 上海许继电气有限公司 | System and method for achieving real-time transmission of transformer substation device information based on shared memory |
| CN105139127A (en) * | 2015-08-25 | 2015-12-09 | 国网浙江省电力公司 | Relay protection device, full container data cloning method and recovery method |
| CN105260401A (en) * | 2015-09-17 | 2016-01-20 | 国网北京市电力公司 | Method and device for querying and storing electric data |
| CN106230814A (en) * | 2016-07-29 | 2016-12-14 | 上海爱数信息技术股份有限公司 | The management method of distributed site, system and there is the server of this system |
| CN110427383A (en) * | 2019-05-13 | 2019-11-08 | 国网冀北电力有限公司 | Mysql cluster online data redistribution method and relevant device based on data redundancy |
| CN110753103A (en) * | 2019-10-16 | 2020-02-04 | 长春银彩通信息科技有限公司 | Method and system for distributed efficient data sealing |
| CN112052243B (en) * | 2020-09-08 | 2021-05-14 | 贵州乌江水电开发有限责任公司东风发电厂 | Continuous waveform recording method based on database technology |
-
2003
- 2003-11-06 CN CN 200310103518 patent/CN1258728C/en not_active Expired - Lifetime
Also Published As
| Publication number | Publication date |
|---|---|
| CN1542652A (en) | 2004-11-03 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN1258728C (en) | Application method and network system of fully distributed protected information processing system real-time database | |
| CN1190733C (en) | Method and system for failure recovery for data management and application program | |
| CN1224905C (en) | Resource action in clustered computer system incorporating prepare operation | |
| CN1285055C (en) | Method and system for providing dynamic hosted sevvice management | |
| CN1203425C (en) | Device and method of controlling intergroup resource utilization | |
| CN1143209C (en) | Operating system rebooting method | |
| CN103036946B (en) | A kind of method and system processing file backup task for cloud platform | |
| CN1138207C (en) | Method for use of remote JAVA object allocator | |
| CN1311380C (en) | Polymerization of service registraion form | |
| CN1836232A (en) | Automatic and dynamic provisioning of databases | |
| US20090254571A1 (en) | System and method of synchronizing data sets across distributed systems | |
| CN106776212A (en) | The supervisory systems and method of container clustered deploy(ment) multi-process application | |
| CN101980207B (en) | Method and system for implementing database access | |
| CN101034364A (en) | Method, device and system for implementing RAM date backup | |
| CN103049268B (en) | A kind of application and development based on Naplet management system | |
| CN101040486A (en) | Method, system and program product for automated topology formation in dynamic distributed environments | |
| CN1313929C (en) | Method and apparatus for affirming and arranging in order the resource mapping to geology | |
| CN1910555A (en) | Geographically distributed clusters | |
| CN1338175A (en) | Method and apparatus for deploying service modules among service nodes distributed in an intelligent network | |
| CN1858704A (en) | Method of upgrading sequence | |
| CN101354720B (en) | Distributed memory database data system and sharing method thereof | |
| CN101562804A (en) | Region management server system based on mobile P2P and deploying method thereof | |
| CN112579288A (en) | Cloud computing-based intelligent security data management system | |
| CN1787524A (en) | Distributed active web service registered information managing system and realizing method thereof | |
| CN1670652A (en) | Storage management method and storage management system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| C56 | Change in the name or address of the patentee |
Owner name: BEIJING SIFANG JIBAO AUTOMATION CO., LTD. Free format text: FORMER NAME OR ADDRESS: SIFANG JIBAO AUTOMATION CO., LTD., BEIJING |
|
| CP03 | Change of name, title or address |
Address after: No. four, 9 street, Beijing, Haidian District Patentee after: BEIJING SIFANG AUTOMATION Co.,Ltd. Address before: No. four, 9 street, information industry base, Haidian District, Beijing Patentee before: Beijing Sifang Automation Co.,Ltd. |
|
| TR01 | Transfer of patent right |
Effective date of registration: 20190321 Address after: 100085 9, four street, Shang Di information industry base, Haidian District, Beijing. Co-patentee after: BEIJING SIFANG ENGINEERING Co.,Ltd. Patentee after: BEIJING SIFANG AUTOMATION Co.,Ltd. Address before: 100085 No. 9 Shangdi 4th Street, Haidian District, Beijing Patentee before: BEIJING SIFANG AUTOMATION Co.,Ltd. |
|
| TR01 | Transfer of patent right | ||
| CX01 | Expiry of patent term |
Granted publication date: 20060607 |
|
| CX01 | Expiry of patent term |