CN102929744B - A kind of Local Area Network real-time database date storage method and system - Google Patents
A kind of Local Area Network real-time database date storage method and system Download PDFInfo
- Publication number
- CN102929744B CN102929744B CN201110444392.7A CN201110444392A CN102929744B CN 102929744 B CN102929744 B CN 102929744B CN 201110444392 A CN201110444392 A CN 201110444392A CN 102929744 B CN102929744 B CN 102929744B
- Authority
- CN
- China
- Prior art keywords
- real
- time database
- management machine
- data
- time
- 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 - Fee Related
Links
- 238000000034 method Methods 0.000 title claims abstract description 28
- 238000007726 management method Methods 0.000 claims description 108
- 238000012360 testing method Methods 0.000 claims description 9
- 238000013500 data storage Methods 0.000 claims description 8
- 230000005540 biological transmission Effects 0.000 claims description 2
- 239000006185 dispersion Substances 0.000 abstract description 4
- 238000012545 processing Methods 0.000 abstract description 2
- 238000011084 recovery Methods 0.000 abstract description 2
- 238000010586 diagram Methods 0.000 description 5
- 238000005516 engineering process Methods 0.000 description 3
- 230000003993 interaction Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000009977 dual effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005259 measurement Methods 0.000 description 1
- 238000012797 qualification Methods 0.000 description 1
- 230000011664 signaling Effects 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a kind of Local Area Network real-time database date storage method and system, belong to local area network protection management system. originally the data that should be stored in unit real-time data base are stored in multiple real-time data base according to certain regular-scattered by the present invention, the real-time database of one of them machine stores, as backup real-time database, all data that in other server run except oneself, real-time data base stores, wherein the real-time database of a selected machine is as the management machine of real-time database, dispersion for data stores the principle that rule adopts load balancing, so, although physically data be dispersion be stored in multiple real-time data base, but acquisition is but the partial data of whole system for client terminal, thus achieve integrity in logic. when the real-time database of one of them or multiple stage machine breaks down for a certain reason, data can be carried out Recovery processing timely by the present invention.
Description
Technical field
The present invention relates to a kind of Local Area Network real-time database date storage method and system, belong to local area network protection management system.
Background technology
Local area network protection management system needs run by protected object to carry out supervision in real time, control and management, not only need to safeguard a large amount of shared data and control knowledge; And the completing and there is the strict time limit of these application activities, require within certain moment or certain finite time from can only IED(IntelligentElectronicDevice) gather the remote measurement, remote signalling and the electric quantity data that come, by association access to each other and process, the working lipe of these data is of short duration, out-of-date, lost efficacy, therefore the exactness of electric substation automation system not only depends on logic result, but also depends on the logic resultant time. Therefore, in order to obtain upgrading the response extremely fast with inquiry, meet the needs of application in real time, adopt real-time data base RTDB(RealTimeDatabase) carry out storing to data and process. Real-time data base is exactly the database that its data and affairs have explicit timing restriction, ensure to share the consistence of data when the constraint of time, the exactness of data not only depends on logic result, and depends on the generation time of logic result and derive the time consistency that result is used data. But, for the Application Areas producing huge data volume instantaneously, due to the restriction of hardware, single real-time database is difficult to carry so big data volume thus has given play to optimum efficiency, there is the bottleneck in performance.
Summary of the invention
Under it is an object of the invention to solve Dual OMU Servers Mode traditional in Local Area Network, single real-time database runs the bottleneck problem run into.
The present invention provides a kind of Local Area Network real-time database date storage method for solving the problems of the technologies described above, and the step that the method specifically comprises is:
1). a real-time database in selected zone network real-time database is set to backup real-time database, all data that in other server run except oneself for storing, real-time data base stores, a real-time database in selected zone network real-time database is real-time database management machine again, for the relevant information of real data created and safeguard each real-time database and storage thereof;
2). judge whether real-time database management machine breaks down at real-time database operational process, if real-time database management machine breaks down, its administration authority and relevant data handover are given the real-time database specified in advance and inherit as management machine by this real-time database management machine, and send notice to other real-time database, inform the change that other real-time database is relevant;
3). in real-time database operational process, judge whether the real-time database of non-management machine breaks down, if the real-time database having non-management machine breaks down, management machine real-time database can utilize backup storehouse to take over the relevant data of real-time database of non-management machine and the business of this generation fault, management machine real-time database sends notice to other real-time database, informs the change that other real-time database is relevant.
Described step 2) concrete steps as follows:
A. when real-time database management machine breaks down, first judging the management of this real-time database, function is no initiatively notifies other real-time database, if other real-time database can initiatively be notified, this real-time database management machine sends message notice by private network and specifies the real-time database inherited as management machine in advance, then step b is entered, if this real-time database management machine can initiatively not notify other real-time database, the real-time database inherited as management machine is specified to send test frame to this real-time database management machine in advance, and do not receive the reply frame of this real-time database management machine at the appointed time, this real-time database being designated is automatically upgraded to management machine, then steps d is entered,
B. the real-time database being designated sends after receiving this frame and confirms that frame represents and receives notice;
C. then administration authority and relevant data handover are given the real-time database being designated by real-time database management machine, and this real-time database real-time database being designated is replied after receiving information and confirmed that frame represents and receive authority and data;
D. this real-time database being designated sends request frame to backup storehouse, request backup storehouse sends the storage data of real-time database management machine, the relevant data and then sending real-time database management machine after confirming frame are replied in backup storehouse after receiving request, after this real-time database being designated receives data, " real-time database management table " is carried out corresponding modify, and send notice to other real-time database, inform the change that other real-time database is relevant.
The concrete steps of described step 3) are as follows:
A). judge that can the non-management machine real-time database of this generation fault initiatively notify other real-time database, if other real-time database can initiatively be notified, management machine real-time database is that the non-management machine that this breaks down sends a frame test frame by private network, the non-management machine real-time database of this generation fault is replied by private network and is confirmed frame, then step b) is entered, if can initiatively not notify other real-time database, management machine real-time database is that the non-management machine that this breaks down sends a frame test frame by private network, step c) is entered after not receiving the reply frame of this non-management machine broken down at the appointed time,
B). management machine real-time database sends the relevant data of non-management machine real-time database and the request frame of business of this generation fault of adapter, and this non-management machine real-time database is replied after receiving and confirmed frame;
C). management machine real-time database sends request frame to backup storehouse, and request sends the relevant data of the non-management machine real-time database that fault occurs, and backup storehouse is replied after receiving request frame and confirmed frame, the relevant data of the non-management machine real-time database of send generation fault;
D). management machine real-time database receives backup storehouse and sends relevant data, revises its " real-time database management table ", and sends notice to other real-time database, informs the associated change that other real-time database occurs.
The present invention also provides a kind of Local Area Network real-time database data-storage system for solving the problems of the technologies described above, this real-time database data-storage system at least comprises three real-time database, for being carried out data transmission by public network and client terminal, one of them real-time database is backup real-time database, all data that in other server run except oneself for storing, real-time data base stores, a real-time database is real-time database management machine, for the relevant information of real data created and safeguard each real-time database and storage thereof, communicated by private network between each real-time database.
Its administration authority and relevant data handover are given the real-time database specified in advance and inherit as management machine when there is fault by described real-time database management machine, and relevant data and the business of the real-time database of the non-management machine of backup storehouse adapter generation fault can be utilized, and send notice to other real-time database, inform the change that other real-time database is relevant.
The invention has the beneficial effects as follows: the present invention is by being stored into multiple real-time data base by the data that originally should be stored in unit real-time data base according to certain regular-scattered, the real-time database of one of them machine stores, as backup real-time database, all data that in other server run except oneself, real-time data base stores, the real-time database of a machine, as the management machine of real-time database, creates and safeguards " real-time database management table. When the real-time database of one of them or multiple stage machine breaks down for a certain reason, data can be carried out Recovery processing timely by the present invention.
Accompanying drawing explanation
Fig. 1 is the schematic diagram of the deployment way of the embodiment of the present invention;
Fig. 2 is the schematic diagram of embodiment of the present invention real-time database when initiatively notifying other real-time database when breaking down;
Fig. 3 is the operation reserve schematic diagram of real-time database of the present invention when cannot initiatively notify other real-time database when breaking down;
Fig. 4 is the operation reserve schematic diagram of embodiment of the present invention real-time database when initiatively notifying other real-time database when breaking down;
Fig. 5 is the operation reserve schematic diagram of embodiment of the present invention real-time database when cannot initiatively notify other real-time database when breaking down.
Embodiment
Below in conjunction with accompanying drawing, the specific embodiment of the present invention is described further.
The embodiment of a kind of Local Area Network real-time database date storage method of the present invention
We adopt the supervisory system of C/S framework for integral deployment as shown in Figure 1, and this supervisory system adopts client terminal to obtain relative information displaying from server to the pattern of user. With traditional C/S framework the difference is that, its real-time database adopts concentrating type to dispose, and the real-time database in every station server stores respectively and processes a part of data information of whole system, dispersion stores in physics realization, but for client terminal, what obtain is but the complete information of whole system, carries out information interaction by public network between client terminal and server. The concrete steps of its real-time database data storage means comprise:
1. real-time database is but communicated by private network each other, disposes one of them real-time database, as management machine, all real-time database is carried out unified management.
2. dispose the full detail that one of them real-time database is used for storing whole system as backup storehouse, what the delta data produced when other real-time database is run was real-time is synchronously sent to backup storehouse, so that a real-time database carries out date restoring timely after breaking down wherein.
3. in operational process, as shown in Figure 2, when one of them real-time database A(manage machine) break down for a certain reason cannot work time, send message notice by private network immediately to specify in advance and inherit as the real-time database B of management machine, it is designated to send after real-time database B receives this frame and confirms that frame represents and receive notice; Then administration authority and relevant data handover are given the real-time database B being designated by real-time database A, and real-time database B replys after receiving information and confirms that frame represents and receive authority and data; Then real-time database B sends request frame to backup storehouse, request backup storehouse sends the storage data of real-time database A, the relevant data and then sending real-time database A after confirming frame are replied in backup storehouse after receiving request, after real-time database B receives data, " real-time database management table " is carried out corresponding modify, and send notice to other real-time database, inform the change that other real-time database is relevant.By above flow process, it is achieved that after there is network fault as the real-time database of management machine, as netting twine disconnects, the phenomenon such as net card failure reaches the object of network protection after occurring.
4. in operational process, as shown in Figure 3, when one of them real-time database A(manage machine) break down and cannot work and then cannot communicate with other real-time database time, the real-time database B with management machine qualification specified in advance by real-time database A sends test frame to real-time database A, if not replying frame at the appointed time, real-time database B is automatically upgraded to management machine; Then to backing up and send request frame, request backup storehouse sends the former management machine of real-time database A() the middle data stored, to continue to store and to process the data of real-time database A, backup storehouse sends the relevant data confirming that frame after image real-time database B sends request after receiving request, " real-time database management table " is carried out corresponding modify by last real-time database B, and send notice to other real-time database, inform the associated change that other real-time database occurs.
5. in operational process, as shown in Figure 4, when wherein any one real-time database (non-management machine) break down for a certain reason cause working time, as management machine real-time database A immediately by private network be the real-time database B broken down send one frame test frame, real-time database B is replied by private network equally subsequently and confirms frame, then real-time database A sends the request frame of the relevant data of adapter real-time database B and business, real-time database B replys after receiving and confirms frame, real-time database A sends request frame to backup storehouse, request sends the relevant data of real-time database B, backup storehouse is replied after receiving request frame and is confirmed frame, receive the relevant data sending real-time database B to real-time database A, last real-time database A revises " real-time database management table " after receiving data and sends notice to other real-time database, inform the change that other real-time database is relevant.
6. in operational process, as shown in Figure 5, when one of them real-time database B(non-management machine) break down when cannot work and then cannot communicate with other real-time database, real-time database A as management machine sends a frame test frame to real-time database B, when not receiving reply frame in the specified time, namely can't detect when existing of real-time database B, real-time database A sends request frame to backup storehouse, request sends the relevant data of real-time database B, to continue to store and to process relevant data, backup storehouse is replied after receiving request frame and is confirmed frame, the relevant data of send real-time database B, real-time database A revises " real-time database management table " after receiving relevant data, and send notice to other real-time database, inform the associated change that other real-time database occurs.
The embodiment of a kind of Local Area Network real-time database data-storage system of the present invention
As shown in Figure 1, this Local Area Network real-time database data-storage system adopts client terminal to obtain relative information displaying from server to the pattern of user. With traditional C/S framework the difference is that, its real-time database adopts concentrating type to dispose, and the real-time database in every station server stores respectively and processes a part of data information of whole system, dispersion stores in physics realization, but for client terminal, what obtain is but the complete information of whole system, carries out information interaction by public network between client terminal and server. This system comprises five client terminals, three station servers and a backup machine, wherein in three station server real-time database one be real-time database management machine, for the relevant information of real data created and safeguard each real-time database and storage thereof, all data that in other server that backup machine is running except oneself for storing, real-time data base stores, are communicated by private network between each real-time database.Its administration authority and relevant data handover are given the real-time database specified in advance and inherit as management machine when there is fault by described real-time database management machine, and relevant data and the business of the real-time database of the non-management machine of backup storehouse adapter generation fault can be utilized, and send notice to other real-time database, inform the change that other real-time database is relevant. Its concrete treating processes, as described in last embodiment, is not just describing in detail here.
Claims (4)
1. a Local Area Network real-time database date storage method, it is characterised in that: the concrete steps of this storage means are as follows:
1). a real-time database in selected zone network real-time database is backup real-time database, all data that in other server run except oneself for storing, real-time data base stores, a real-time database in selected zone network real-time database is real-time database management machine again, for the relevant information of real data created and safeguard each real-time database and storage thereof; Real-time database adopts concentrating type to dispose, and each real-time database stores respectively and processes a part of data information of whole system;
2). judge whether real-time database management machine breaks down at real-time database operational process, if real-time database management machine breaks down, its administration authority and relevant data handover are given the real-time database specified in advance and inherit as management machine by this real-time database management machine, and send notice to other real-time database, inform the change that other real-time database is relevant;
3). in real-time database operational process, judge whether the real-time database of non-management machine breaks down, if the real-time database having non-management machine breaks down, management machine real-time database can utilize backup storehouse to take over the relevant data of real-time database of non-management machine and the business of this generation fault, management machine real-time database sends notice to other real-time database, informs the change that other real-time database is relevant.
Described step 2) concrete steps as follows:
A. when real-time database management machine breaks down, first judging the management of this real-time database, function is no initiatively notifies other real-time database, if other real-time database can initiatively be notified, this real-time database management machine sends message notice by private network and specifies the real-time database inherited as management machine in advance, then step b is entered, if this real-time database management machine can initiatively not notify other real-time database, the real-time database inherited as management machine is specified to send test frame to this real-time database management machine in advance, and do not receive the reply frame of this real-time database management machine at the appointed time, this real-time database being designated is automatically upgraded to management machine, then steps d is entered,
B. the real-time database being designated sends after receiving this frame and confirms that frame represents and receives notice;
C. then administration authority and relevant data handover are given the real-time database being designated by real-time database management machine, and this real-time database being designated is replied after receiving information and confirmed that frame represents and receive authority and data;
D. this real-time database being designated sends request frame to backup storehouse, request backup storehouse sends the storage data of real-time database management machine, the relevant data and then sending real-time database management machine after confirming frame are replied in backup storehouse after receiving request, after this real-time database being designated receives data, " real-time database management table " is carried out corresponding modify, and send notice to other real-time database, inform the change that other real-time database is relevant.
2. Local Area Network real-time database date storage method according to claim 1, it is characterised in that: described step 3) concrete steps as follows:
A). judge that can the non-management machine real-time database of this generation fault initiatively notify other real-time database, if other real-time database can initiatively be notified, management machine real-time database is that the non-management machine that this breaks down sends a frame test frame by private network, the non-management machine real-time database of this generation fault is replied by private network and is confirmed frame, then step b is entered), if can initiatively not notify other real-time database, management machine real-time database is that the non-management machine that this breaks down sends a frame test frame by private network, step c is entered) after not receiving the reply frame of this non-management machine broken down at the appointed time,
B). management machine real-time database sends the relevant data of non-management machine real-time database and the request frame of business of this generation fault of adapter, and this non-management machine real-time database is replied after receiving and confirmed frame;
C). management machine real-time database sends request frame to backup storehouse, and request sends the relevant data of the non-management machine real-time database that fault occurs, and backup storehouse is replied after receiving request frame and confirmed frame, the relevant data of the non-management machine real-time database of send generation fault;
D). management machine real-time database receives backup storehouse and sends relevant data, revises its " real-time database management table ", and sends notice to other real-time database, informs the associated change that other real-time database occurs.
3. one kind for realizing the Local Area Network real-time database data-storage system of method described in claim 1, it is characterized in that: this real-time database data-storage system at least comprises three real-time database, for being carried out data transmission by public network and client terminal, one of them real-time database is backup real-time database, all data that in other server run except oneself for storing, real-time data base stores, a real-time database is real-time database management machine, for the relevant information of real data created and safeguard each real-time database and storage thereof, communicated by private network between each real-time database, real-time database adopts concentrating type to dispose, and each real-time database stores respectively and processes a part of data information of whole system.
4. Local Area Network real-time database data-storage system according to claim 3, it is characterized in that: its administration authority and relevant data handover are inherited the real-time database for management machine to appointment in advance when there is fault by described real-time database management machine, and relevant data and the business of the real-time database of the non-management machine of backup storehouse adapter generation fault can be utilized, and send notice to other real-time database, inform the change that other real-time database is relevant.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110444392.7A CN102929744B (en) | 2011-12-27 | 2011-12-27 | A kind of Local Area Network real-time database date storage method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110444392.7A CN102929744B (en) | 2011-12-27 | 2011-12-27 | A kind of Local Area Network real-time database date storage method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102929744A CN102929744A (en) | 2013-02-13 |
| CN102929744B true CN102929744B (en) | 2016-06-08 |
Family
ID=47644550
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201110444392.7A Expired - Fee Related CN102929744B (en) | 2011-12-27 | 2011-12-27 | A kind of Local Area Network real-time database date storage method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102929744B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104077367A (en) * | 2014-06-18 | 2014-10-01 | 国电南瑞科技股份有限公司 | History data cluster processing method for power grid dispatching monitoring system |
| US11418632B2 (en) * | 2015-12-15 | 2022-08-16 | Intel Corporation | High speed flexible packet classification using network processors |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101546189A (en) * | 2008-03-26 | 2009-09-30 | 上海宝信软件股份有限公司 | Method for controlling real-time database system |
| CN102142008A (en) * | 2010-12-02 | 2011-08-03 | 华为技术有限公司 | Method and system for implementing distributed memory database, token controller and memory database |
| CN102158540A (en) * | 2011-02-18 | 2011-08-17 | 广州从兴电子开发有限公司 | System and method for realizing distributed database |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030126133A1 (en) * | 2001-12-27 | 2003-07-03 | Slamdunk Networks, Inc. | Database replication using application program event playback |
-
2011
- 2011-12-27 CN CN201110444392.7A patent/CN102929744B/en not_active Expired - Fee Related
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101546189A (en) * | 2008-03-26 | 2009-09-30 | 上海宝信软件股份有限公司 | Method for controlling real-time database system |
| CN102142008A (en) * | 2010-12-02 | 2011-08-03 | 华为技术有限公司 | Method and system for implementing distributed memory database, token controller and memory database |
| CN102158540A (en) * | 2011-02-18 | 2011-08-17 | 广州从兴电子开发有限公司 | System and method for realizing distributed database |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102929744A (en) | 2013-02-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN204886410U (en) | Secondary equipment state monitoring system based on intelligent substation | |
| CN103888277B (en) | A kind of gateway disaster-tolerant backup method, device and system | |
| CN103383689A (en) | Service process fault detection method, device and service node | |
| CN103812699A (en) | Monitoring management system based on cloud computing | |
| CN110851278A (en) | Distribution network automation master station mobile application service management method and system based on micro-service architecture | |
| CN102857371B (en) | A kind of dynamic allocation management method towards group system | |
| CN110138876B (en) | Task deployment method, device, equipment and platform | |
| CN103001806A (en) | Distributed operation and maintenance monitoring system used for information technology (IT) system | |
| CN107016479A (en) | Task scheduling and managing method, apparatus and system | |
| CN105610946B (en) | A kind of cloud springboard machine system based on docker technologies | |
| CN110611597A (en) | Cross-domain operation and maintenance system based on unidirectional network gate environment | |
| CN104243195A (en) | Remote disaster recovery processing method and device | |
| CN108848132A (en) | A kind of distribution scheduling station system based on cloud | |
| CN108345617A (en) | A kind of method of data synchronization, device and electronic equipment | |
| CN101741635A (en) | Method, system and device for synchronous altering message | |
| CN107247648A (en) | Method, the apparatus and system of remote items system supervisory are realized based on Docker | |
| CN111061741B (en) | Power test data management method, system, terminal and storage medium | |
| CN103973516A (en) | Method and device for achieving monitoring function in data processing system | |
| CN108199901A (en) | Hardware reports method, system, equipment, hardware management server and storage medium for repairment | |
| CN113778615A (en) | Rapid and stable network shooting range virtual machine construction system | |
| CN109005076A (en) | A kind of intelligent substation switch monitoring system and interchanger monitoring method | |
| CN102929744B (en) | A kind of Local Area Network real-time database date storage method and system | |
| Corradi et al. | SIRDAM4. 0: A support infrastructure for reliable data acquisition and management in industry 4.0 | |
| CN116185697B (en) | Container cluster management method, device and system, electronic equipment and storage medium | |
| CN116346834A (en) | Session synchronization method, device, computing equipment and computer storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| ASS | Succession or assignment of patent right |
Owner name: XUJI ELECTRIC CO., LTD. Free format text: FORMER OWNER: XUJI GROUP CO., LTD. Effective date: 20131202 |
|
| C41 | Transfer of patent application or patent right or utility model | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20131202 Address after: No. 1298 Xuchang City, Henan province 461000 XJ Avenue Applicant after: Xuji Electric Co., Ltd. Applicant after: Xuchang Xuji Software Technology Co., Ltd. Applicant after: State Grid Corporation of China Address before: No. 1298 Xuchang City, Henan province 461000 XJ Avenue Applicant before: Xuji Group Co., Ltd. Applicant before: Xuji Electric Co., Ltd. Applicant before: Xuchang Xuji Software Technology Co., Ltd. Applicant before: State Grid Corporation of China |
|
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20160608 Termination date: 20191227 |