CN117435422A - Parallel real-time database active-standby switching management system for power grid management - Google Patents
Parallel real-time database active-standby switching management system for power grid management Download PDFInfo
- Publication number
- CN117435422A CN117435422A CN202311263048.7A CN202311263048A CN117435422A CN 117435422 A CN117435422 A CN 117435422A CN 202311263048 A CN202311263048 A CN 202311263048A CN 117435422 A CN117435422 A CN 117435422A
- Authority
- CN
- China
- Prior art keywords
- database
- power grid
- grid management
- target power
- evaluation coefficient
- 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.)
- Pending
Links
- 238000011156 evaluation Methods 0.000 claims description 153
- 238000004458 analytical method Methods 0.000 claims description 37
- 230000001360 synchronised effect Effects 0.000 claims description 33
- 238000004364 calculation method Methods 0.000 claims description 30
- 238000000034 method Methods 0.000 claims description 23
- 238000012544 monitoring process Methods 0.000 claims description 11
- 230000002159 abnormal effect Effects 0.000 claims description 7
- 230000007547 defect Effects 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 3
- 238000012423 maintenance Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000011084 recovery Methods 0.000 description 1
Landscapes
- Supply And Distribution Of Alternating Current (AREA)
Abstract
The invention discloses a parallel real-time database active-standby switching management system aiming at power grid management, which relates to the technical field of active-standby switching.
Description
Technical Field
The invention relates to the technical field of master-slave switching, in particular to a parallel real-time database master-slave switching management system aiming at power grid management.
Background
The wide application of the active-standby switching technology can effectively reduce the influence of system faults on the power grid management system, so that the running efficiency and reliability of the power grid management are improved, the overall performance level of the power grid management system can also be improved, and the data synchronization and state recovery operation of the database are automatically carried out, so that the downtime of the power grid management system is reduced, and the availability and the intelligence of the power grid management system are improved.
The current technology mainly focuses on the monitoring of the real-time database, and does not analyze the active-standby switching technology of the real-time database, so that when the real-time database of the power grid management is problematic, the real-time database of the power grid management cannot be maintained and corrected in time, further, the running efficiency of the power grid management is reduced, meanwhile, certain loss of the power grid management data is caused, the performance and stability of the real-time database of the power grid management are greatly reduced, the power grid management becomes heavier, and time and energy are very wasted.
Disclosure of Invention
Aiming at the technical defects, the invention aims to provide a parallel real-time database active-standby switching management system aiming at power grid management.
In order to solve the technical problems, the invention adopts the following technical scheme: the invention provides a parallel real-time database master-slave switching management system aiming at power grid management, which comprises the following components: the connection state monitoring module is used for acquiring database state information corresponding to the target power grid management, wherein the state information comprises connection time length, connection quantity and disconnection times, further analyzing and obtaining database connection state evaluation coefficients corresponding to the target power grid management, and judging the database connection state corresponding to the target power grid management according to the database connection state evaluation coefficients corresponding to the target power grid management;
the performance information analysis module is used for acquiring database performance information corresponding to the target power grid management, wherein the performance information comprises inquiry response time, read-write speed, read-write throughput, cache utilization rate and index utilization rate, and further analyzing and obtaining database performance evaluation coefficients corresponding to the target power grid management;
the synchronous information acquisition module is used for acquiring database synchronous information corresponding to the target power grid management, wherein the synchronous information comprises synchronous delay time length, synchronous speed and synchronous error quantity, and further analyzing and obtaining database synchronous evaluation coefficients corresponding to the target power grid management;
the switching state analysis module is used for acquiring database switching information corresponding to the target power grid management, wherein the switching information comprises switching duration and switching speed, and further analyzing and obtaining database switching evaluation coefficients corresponding to the target power grid management;
the running state monitoring module is used for analyzing and obtaining a database running evaluation coefficient corresponding to the target power grid management according to the database performance evaluation coefficient, the synchronous evaluation coefficient and the switching evaluation coefficient corresponding to the target power grid management, and judging the running state of the database corresponding to the target power grid management according to the database running evaluation coefficient corresponding to the target power grid management;
and the early warning terminal is used for carrying out early warning prompt when the operation state of the database corresponding to the target power grid management is abnormal.
Preferably, the analyzing obtains a database connection state evaluation coefficient corresponding to the target power grid management, and judges the database connection state corresponding to the target power grid management, and the specific analyzing process is as follows: by calculation formulaAnalyzing to obtain database connection state evaluation coefficient corresponding to target power grid management>ρ ' is the set connection duration, η ' is the set connection number, μ ' is the set disconnection number, ρ is the database connection duration corresponding to the target grid management, η is the database connection number corresponding to the target grid management, μ is the database disconnection number corresponding to the target grid management, s 1 、s 2 、s 3 Respectively setting weight factors of connection time length, connection quantity and disconnection times;
comparing the database connection state evaluation coefficient corresponding to the target power grid management with a connection state evaluation coefficient threshold stored in the database, judging that the database connection state corresponding to the target power grid management is unstable if the database connection state evaluation coefficient corresponding to the target power grid management is smaller than the connection state evaluation coefficient threshold stored in the database, and judging that the database connection state corresponding to the target power grid management is stable if the database connection state evaluation coefficient corresponding to the target power grid management is larger than or equal to the connection state evaluation coefficient threshold stored in the database.
Preferably, the analysis obtains a database performance evaluation coefficient corresponding to the target power grid management, and the specific analysis process is as follows: according to the database query response time length, the read-write speed and the read-write throughput corresponding to the target power grid management, calculating to obtain a database read-write evaluation coefficient corresponding to the target power grid management, and recording the database read-write evaluation coefficient as theta 1;
calculating to obtain a database efficiency evaluation coefficient corresponding to the target power grid management according to the database cache utilization rate and the index utilization rate corresponding to the target power grid management, and marking the database efficiency evaluation coefficient as theta 2;
by calculation formulaCalculating to obtain a database efficiency evaluation coefficient theta, theta 1' corresponding to target power grid management, wherein theta 1' is a set read-write evaluation coefficient, theta 2' is a set efficiency evaluation coefficient, and v 1 ，ν 2 And e is a natural constant, wherein the weight factors are respectively set read-write evaluation coefficients and efficiency evaluation coefficients.
Preferably, the database read-write evaluation coefficient corresponding to the target power grid management is obtained through calculation, and the specific calculation process is as follows: by calculation formulaCalculating to obtain a database read-write evaluation coefficient theta 1, χ 'corresponding to the target power grid management, wherein the χ' is the set inquiry response time length>For the set read-write speed, gamma' is setFixed read-write throughput, x is the corresponding database query response time length of target power grid management,/->For the database read-write speed corresponding to the target power grid management, gamma is the database read-write throughput corresponding to the target power grid management, and sigma 1 、σ 2 、σ 3 Respectively set weight factors of query response time length, read-write speed and read-write throughput.
Preferably, the calculating obtains a database efficiency evaluation coefficient corresponding to the target power grid management, and the specific calculating process is as follows: by calculation formulaCalculating to obtain database efficiency evaluation coefficients theta 2, < corresponding to target power grid management->For the set cache usage, ω' is the set index usage, ++>Caching utilization rate for database corresponding to target power grid management, wherein omega is utilization rate of index of database corresponding to target power grid management, and alpha 1 、α 2 Respectively set weight factors of buffer utilization rate and index utilization rate.
Preferably, the analysis obtains a database synchronization evaluation coefficient corresponding to the target power grid management, and the specific analysis process is as follows: by calculation formulaAnalyzing to obtain database synchronization evaluation coefficient corresponding to target power grid management>ζ ' is the set synchronization delay time length, ψ ' is the set synchronization speed, δ ' is the set synchronization error number, ζ is the database corresponding to the target power grid managementThe synchronization delay time length, psi is the database synchronization speed corresponding to the target power grid management, delta is the database synchronization error number corresponding to the target power grid management, and tau is the database synchronization error number corresponding to the target power grid management 1 、τ 2 、τ 3 Respectively set weight factors of synchronization delay time length, synchronization speed and synchronization error number.
Preferably, the analysis obtains a database switching evaluation coefficient corresponding to the target power grid management, and the specific analysis process is as follows: by calculation formulaAnalyzing to obtain a database switching evaluation coefficient B corresponding to the target power grid management, wherein X 'is a set switching duration, M' is a set switching speed, X is a database switching duration corresponding to the target power grid management, M is a database switching speed corresponding to the target power grid management, and h is a switching speed of the database corresponding to the target power grid management 1 、h 2 Respectively set weight factors of the switching time length and the switching speed.
Preferably, the analysis obtains a database operation evaluation coefficient corresponding to the target power grid management, and the specific analysis process is as follows: by calculation formulaAnalyzing to obtain a database operation evaluation coefficient Z, theta corresponding to the target power grid management, wherein theta is a database performance evaluation coefficient corresponding to the target power grid management>For the synchronous evaluation coefficient of the database corresponding to the target power grid management, B is the switching evaluation coefficient of the database corresponding to the target power grid management, and r 1 、r 2 、r 3 The weight factors of the performance evaluation coefficient, the synchronous evaluation coefficient and the switching evaluation coefficient are respectively.
Preferably, the specific judging process includes the following steps: comparing the database operation evaluation coefficient corresponding to the target power grid management with an operation evaluation coefficient threshold stored in the database, judging that the database operation state corresponding to the target power grid management is abnormal if the database operation evaluation coefficient corresponding to the target power grid management is smaller than the operation evaluation coefficient threshold stored in the database, and judging that the database operation state corresponding to the target power grid management is normal if the database operation evaluation coefficient corresponding to the target power grid management is larger than or equal to the operation evaluation coefficient threshold stored in the database.
Compared with the prior art, the invention has the beneficial effects that: the invention provides a parallel real-time database active-standby switching management system aiming at power grid management, which is characterized in that the state information of a database corresponding to the target power grid management is deeply analyzed, the connection state of the database corresponding to the target power grid management is better judged, the performance information, the synchronous information and the switching information of the database corresponding to the target power grid management are analyzed, the database operation evaluation coefficient corresponding to the target power grid management is better obtained, the operation state of the database corresponding to the target power grid management is further judged, when the problem occurs in the real-time database of the power grid management is better treated, the active-standby switching and the maintenance can be obtained, the stable operation of the real-time database of the power grid management is better ensured, the defects existing in the prior art are overcome, the continuous operation of the power grid management system and the effective storage of data are ensured, the influence of system faults on the power grid management system is greatly reduced, the operation efficiency of the real-time database of the power grid management is effectively improved, and the consumption of time and manpower is reduced.
Drawings
In order to more clearly illustrate the embodiments of the invention or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, it being obvious that the drawings in the following description are only some embodiments of the invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a schematic diagram of the system structure of the present invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
Referring to fig. 1, a system for managing primary and backup switching of parallel real-time databases for power grid management includes a connection state monitoring module, a performance information analysis module, a synchronization information acquisition module, a switching state analysis module, an operation state monitoring module and an early warning terminal.
The connection state monitoring module is respectively connected with the performance information analysis module and the synchronous information acquisition module, and the switching state analysis module is respectively connected with the running state monitoring module and the early warning terminal.
The connection state monitoring module is used for acquiring database state information corresponding to the target power grid management, wherein the state information comprises connection time length, connection quantity and disconnection times, further analyzing and obtaining database connection state evaluation coefficients corresponding to the target power grid management, and judging the database connection state corresponding to the target power grid management according to the database connection state evaluation coefficients corresponding to the target power grid management;
the corresponding state information is acquired from the implementation database.
As an optional implementation manner, the analyzing obtains a database connection state evaluation coefficient corresponding to the target power grid management, and judges the database connection state corresponding to the target power grid management, and the specific analysis process is as follows: by calculation formulaAnalyzing to obtain database connection state evaluation coefficient corresponding to target power grid management>ρ ' is the set connection duration, η ' is the set number of connections, μ ' is the set number of breaks,ρ is the database connection duration corresponding to the target power grid management, η is the database connection number corresponding to the target power grid management, μ is the database disconnection number corresponding to the target power grid management, s 1 、s 2 、s 3 Respectively setting weight factors of connection time length, connection quantity and disconnection times;
comparing the database connection state evaluation coefficient corresponding to the target power grid management with a connection state evaluation coefficient threshold stored in the database, judging that the database connection state corresponding to the target power grid management is unstable if the database connection state evaluation coefficient corresponding to the target power grid management is smaller than the connection state evaluation coefficient threshold stored in the database, and judging that the database connection state corresponding to the target power grid management is stable if the database connection state evaluation coefficient corresponding to the target power grid management is larger than or equal to the connection state evaluation coefficient threshold stored in the database.
The performance information analysis module is used for acquiring database performance information corresponding to the target power grid management, wherein the performance information comprises inquiry response time, read-write speed, read-write throughput, cache utilization rate and index utilization rate, and further analyzing and obtaining database performance evaluation coefficients corresponding to the target power grid management;
it should be noted that, the start time and the end time of each query are recorded, and then the execution time of the query is calculated to obtain the query response time, so as to obtain the corresponding query response time, the number of times and time consumption of reading and writing operations of the database are obtained, and then the calculation is performed to obtain the corresponding read-write speed, the number of times of cache hits and misses are recorded, and then the corresponding cache hit rate is obtained, the cache hits represent the number of times of obtaining data from the cache, the cache misses represent the number of times of needing to read data from the database, and the number of times of scanning indexes and the number of times of hitting indexes are obtained from the database, so as to obtain the corresponding index utilization rate, the number of times of indexes are used when the database queries, and the number of times of index hits represent the number of times of indexes being used successfully when the query is performed.
As an optional implementation manner, the analysis obtains the database performance evaluation coefficient corresponding to the target power grid management, and the specific analysis process is as follows: according to the database query response time length, the read-write speed and the read-write throughput corresponding to the target power grid management, calculating to obtain a database read-write evaluation coefficient corresponding to the target power grid management, and recording the database read-write evaluation coefficient as theta 1;
calculating to obtain a database efficiency evaluation coefficient corresponding to the target power grid management according to the database cache utilization rate and the index utilization rate corresponding to the target power grid management, and marking the database efficiency evaluation coefficient as theta 2;
by calculation formulaCalculating to obtain a database efficiency evaluation coefficient theta, theta 1' corresponding to target power grid management, wherein theta 1' is a set read-write evaluation coefficient, theta 2' is a set efficiency evaluation coefficient, and v 1 ，ν 2 And e is a natural constant, wherein the weight factors are respectively set read-write evaluation coefficients and efficiency evaluation coefficients.
As an optional implementation manner, the database read-write evaluation coefficient corresponding to the target power grid management is obtained through calculation, and the specific calculation process is as follows: by calculation formulaCalculating to obtain a database read-write evaluation coefficient theta 1, χ 'corresponding to the target power grid management, wherein the χ' is the set inquiry response time length>For the set read-write speed, gamma' is the set read-write throughput, χ is the corresponding database query response time length of target power grid management, +.>For the database read-write speed corresponding to the target power grid management, gamma is the database read-write throughput corresponding to the target power grid management, and sigma 1 、σ 2 、σ 3 Respectively set weight factors of query response time length, read-write speed and read-write throughput.
As an optional implementation manner, the calculating obtains the database efficiency evaluation coefficient corresponding to the target power grid management, and the specific calculating process is as follows: by calculation formulaCalculating to obtain database efficiency evaluation coefficients theta 2, < corresponding to target power grid management->For the set cache usage, ω' is the set index usage, ++>Caching utilization rate for database corresponding to target power grid management, wherein omega is utilization rate of index of database corresponding to target power grid management, and alpha 1 、α 2 Respectively set weight factors of buffer utilization rate and index utilization rate.
The synchronous information acquisition module is used for acquiring database synchronous information corresponding to the target power grid management, wherein the synchronous information comprises synchronous delay time length, synchronous speed and synchronous error quantity, and further analyzing and obtaining database synchronous evaluation coefficients corresponding to the target power grid management;
it should be noted that, the corresponding synchronization delay time length is obtained by obtaining the start time and the end time of each synchronization from the database, and then calculating, and the corresponding synchronization speed is obtained by obtaining the number of times and time consumption of the synchronization operation of the database, and then calculating, and the number of synchronization errors is obtained from the database.
As an optional implementation manner, the analysis obtains the database synchronization evaluation coefficient corresponding to the target power grid management, and the specific analysis process is as follows: by calculation formulaAnalyzing to obtain database synchronization evaluation coefficient corresponding to target power grid management>ζ ' is the set synchronization delay time length, ψ ' is the set synchronization speed, δ ' is the set synchronization error number, ζ is the database synchronization delay time length corresponding to the target power grid management, ψ is the database synchronization speed corresponding to the target power grid management, δ is the database synchronization error number corresponding to the target power grid management, τ 1 、τ 2 、τ 3 Respectively set weight factors of synchronization delay time length, synchronization speed and synchronization error number.
The switching state analysis module is used for acquiring database switching information corresponding to the target power grid management, wherein the switching information comprises switching duration and switching speed, and further analyzing and obtaining database switching evaluation coefficients corresponding to the target power grid management;
it should be noted that, the start time and the end time of each switching are obtained from the database, and then calculated to obtain the corresponding switching duration, and the number of times and the time consumption of the switching operation of the database are obtained, and then calculated to obtain the corresponding switching speed, and the number of synchronization errors is obtained from the database.
As an optional implementation manner, the analysis obtains the database switching evaluation coefficient corresponding to the target power grid management, and the specific analysis process is as follows: by calculation formulaAnalyzing to obtain a database switching evaluation coefficient B corresponding to the target power grid management, wherein X 'is a set switching duration, M' is a set switching speed, X is a database switching duration corresponding to the target power grid management, M is a database switching speed corresponding to the target power grid management, and h is a switching speed of the database corresponding to the target power grid management 1 、h 2 Respectively set weight factors of the switching time length and the switching speed.
The running state monitoring module is used for analyzing and obtaining a database running evaluation coefficient corresponding to the target power grid management according to the database performance evaluation coefficient, the synchronous evaluation coefficient, the switching evaluation coefficient and the abnormal evaluation coefficient corresponding to the target power grid management, and judging the running state of the database corresponding to the target power grid management according to the database running evaluation coefficient corresponding to the target power grid management;
as an optional implementation manner, the analysis obtains the database operation evaluation coefficient corresponding to the target power grid management, and the specific analysis process is as follows: by calculation formulaAnalyzing to obtain a database operation evaluation coefficient Z, theta corresponding to the target power grid management, wherein theta is a database performance evaluation coefficient corresponding to the target power grid management>For the synchronous evaluation coefficient of the database corresponding to the target power grid management, B is the switching evaluation coefficient of the database corresponding to the target power grid management, and r 1 、r 2 、r 3 The weight factors of the performance evaluation coefficient, the synchronous evaluation coefficient and the switching evaluation coefficient are respectively.
As an optional implementation manner, the specific judging process of the database running state corresponding to the target power grid management is as follows: comparing the database operation evaluation coefficient corresponding to the target power grid management with an operation evaluation coefficient threshold stored in the database, judging that the database operation state corresponding to the target power grid management is abnormal if the database operation evaluation coefficient corresponding to the target power grid management is smaller than the operation evaluation coefficient threshold stored in the database, and judging that the database operation state corresponding to the target power grid management is normal if the database operation evaluation coefficient corresponding to the target power grid management is larger than or equal to the operation evaluation coefficient threshold stored in the database.
And the early warning terminal is used for carrying out early warning prompt when the operation state of the database corresponding to the target power grid management is abnormal.
The invention provides a parallel real-time database active-standby switching management system aiming at power grid management, which is characterized in that the state information of a database corresponding to the target power grid management is deeply analyzed, the connection state of the database corresponding to the target power grid management is better judged, the performance information, the synchronous information and the switching information of the database corresponding to the target power grid management are analyzed, the database operation evaluation coefficient corresponding to the target power grid management is better obtained, the operation state of the database corresponding to the target power grid management is further judged, when the problem occurs in the real-time database of the power grid management is better treated, the active-standby switching and the maintenance can be obtained, the stable operation of the real-time database of the power grid management is better ensured, the defects existing in the prior art are overcome, the continuous operation of the power grid management system and the effective storage of data are ensured, the influence of system faults on the power grid management system is greatly reduced, the operation efficiency of the real-time database of the power grid management is effectively improved, and the consumption of time and manpower is reduced.
The preferred embodiments of the invention disclosed above are intended only to assist in the explanation of the invention. The preferred embodiments are not intended to be exhaustive or to limit the invention to the precise form disclosed. Obviously, many modifications and variations are possible in light of the above teaching. The embodiments were chosen and described in order to best explain the principles of the invention and the practical application, to thereby enable others skilled in the art to best understand and utilize the invention. The invention is limited only by the claims and the full scope and equivalents thereof.
Claims (9)
1. A parallel real-time database active-standby switching management system for power grid management, comprising:
the connection state monitoring module is used for acquiring database state information corresponding to the target power grid management, wherein the state information comprises connection time length, connection quantity and disconnection times, further analyzing and obtaining database connection state evaluation coefficients corresponding to the target power grid management, and judging the database connection state corresponding to the target power grid management according to the database connection state evaluation coefficients corresponding to the target power grid management;
the performance information analysis module is used for acquiring database performance information corresponding to the target power grid management, wherein the performance information comprises inquiry response time, read-write speed, read-write throughput, cache utilization rate and index utilization rate, and further analyzing and obtaining database performance evaluation coefficients corresponding to the target power grid management;
the synchronous information acquisition module is used for acquiring database synchronous information corresponding to the target power grid management, wherein the synchronous information comprises synchronous delay time length, synchronous speed and synchronous error quantity, and further analyzing and obtaining database synchronous evaluation coefficients corresponding to the target power grid management;
the switching state analysis module is used for acquiring database switching information corresponding to the target power grid management, wherein the switching information comprises switching duration and switching speed, and further analyzing and obtaining database switching evaluation coefficients corresponding to the target power grid management;
the running state monitoring module is used for analyzing and obtaining a database running evaluation coefficient corresponding to the target power grid management according to the database performance evaluation coefficient, the synchronous evaluation coefficient and the switching evaluation coefficient corresponding to the target power grid management, and judging the running state of the database corresponding to the target power grid management according to the database running evaluation coefficient corresponding to the target power grid management;
and the early warning terminal is used for carrying out early warning prompt when the operation state of the database corresponding to the target power grid management is abnormal.
2. The system for managing the primary and backup switching of parallel real-time databases according to claim 1, wherein the analysis obtains a database connection state evaluation coefficient corresponding to the target power grid management, and judges the database connection state corresponding to the target power grid management, and the specific analysis process is as follows:
by calculation formulaAnalyzing to obtain database connection state evaluation coefficient corresponding to target power grid management>ρ ' is the set connection duration, η ' is the set number of connections, μ ' is the set number of breaks, ρ is the database connection duration corresponding to the target grid management, η is the targetThe number of database connections corresponding to target grid management is marked, mu is the number of database disconnection times corresponding to target grid management, s 1 、s 2 、s 3 Respectively setting weight factors of connection time length, connection quantity and disconnection times;
comparing the database connection state evaluation coefficient corresponding to the target power grid management with a connection state evaluation coefficient threshold stored in the database, judging that the database connection state corresponding to the target power grid management is unstable if the database connection state evaluation coefficient corresponding to the target power grid management is smaller than the connection state evaluation coefficient threshold stored in the database, and judging that the database connection state corresponding to the target power grid management is stable if the database connection state evaluation coefficient corresponding to the target power grid management is larger than or equal to the connection state evaluation coefficient threshold stored in the database.
3. The system for master-slave switching management of parallel real-time databases for power grid management according to claim 1, wherein the analysis obtains the database performance evaluation coefficient corresponding to the target power grid management, and the specific analysis process is as follows:
according to the database query response time length, the read-write speed and the read-write throughput corresponding to the target power grid management, calculating to obtain a database read-write evaluation coefficient corresponding to the target power grid management, and recording the database read-write evaluation coefficient as theta 1;
calculating to obtain a database efficiency evaluation coefficient corresponding to the target power grid management according to the database cache utilization rate and the index utilization rate corresponding to the target power grid management, and marking the database efficiency evaluation coefficient as theta 2;
by calculation formulaCalculating to obtain a database efficiency evaluation coefficient theta, theta 1' corresponding to target power grid management, wherein theta 1' is a set read-write evaluation coefficient, theta 2' is a set efficiency evaluation coefficient, and v 1 ，ν 2 And e is a natural constant, wherein the weight factors are respectively set read-write evaluation coefficients and efficiency evaluation coefficients.
4. The system for master-slave switching management of parallel real-time databases for power grid management according to claim 3, wherein the calculation is performed to obtain the database read-write evaluation coefficients corresponding to the target power grid management, and the specific calculation process is as follows:
by calculation formulaCalculating to obtain a database read-write evaluation coefficient theta 1, χ 'corresponding to the target power grid management, wherein the χ' is the set inquiry response time length>For the set read-write speed, gamma' is the set read-write throughput, χ is the corresponding database query response time length of target power grid management, +.>For the database read-write speed corresponding to the target power grid management, gamma is the database read-write throughput corresponding to the target power grid management, and sigma 1 、σ 2 、σ 3 Respectively set weight factors of query response time length, read-write speed and read-write throughput.
5. The system for master-slave switching management of parallel real-time databases for power grid management according to claim 3, wherein the calculation is performed to obtain the database efficiency evaluation coefficient corresponding to the target power grid management, and the specific calculation process is as follows:
by calculation formulaCalculating to obtain database efficiency evaluation coefficients theta 2, < corresponding to target power grid management->For the set cache usage, ω' is the set index usage, ++>Caching utilization rate for database corresponding to target power grid management, wherein omega is utilization rate of index of database corresponding to target power grid management, and alpha 1 、α 2 Respectively set weight factors of buffer utilization rate and index utilization rate.
6. The system for master-slave switching management of parallel real-time databases for power grid management according to claim 1, wherein the analysis obtains a database synchronization evaluation coefficient corresponding to the target power grid management, and the specific analysis process is as follows:
by calculation formulaAnalyzing to obtain database synchronization evaluation coefficient corresponding to target power grid management>ζ ' is the set synchronization delay time length, ψ ' is the set synchronization speed, δ ' is the set synchronization error number, ζ is the database synchronization delay time length corresponding to the target power grid management, ψ is the database synchronization speed corresponding to the target power grid management, δ is the database synchronization error number corresponding to the target power grid management, τ 1 、τ 2 、τ 3 Respectively set weight factors of synchronization delay time length, synchronization speed and synchronization error number.
7. The parallel real-time database active-standby switching management system for power grid management according to claim 1, wherein the analysis obtains a database switching evaluation coefficient corresponding to the target power grid management, and the specific analysis process is as follows:
by calculation formulaAnalyzing to obtain a database switching evaluation coefficient B and X' corresponding to target power grid managementThe set switching time length, m' is the set switching speed, X is the database switching time length corresponding to the target power grid management, m is the database switching speed corresponding to the target power grid management, h 1 、h 2 Respectively set weight factors of the switching time length and the switching speed.
8. The system for managing the primary and backup switching of parallel real-time databases for power grid management according to claim 1, wherein the analysis obtains the database operation evaluation coefficients corresponding to the target power grid management, and the specific analysis process is as follows:
by calculation formulaAnalyzing to obtain a database operation evaluation coefficient Z, theta corresponding to the target power grid management, wherein theta is a database performance evaluation coefficient corresponding to the target power grid management>For the synchronous evaluation coefficient of the database corresponding to the target power grid management, B is the switching evaluation coefficient of the database corresponding to the target power grid management, and r 1 、r 2 、r 3 The weight factors of the performance evaluation coefficient, the synchronous evaluation coefficient and the switching evaluation coefficient are respectively.
9. The system for managing the primary and backup switching of parallel real-time databases according to claim 1, wherein the determining the running state of the database corresponding to the target power grid management specifically includes the following steps:
comparing the database operation evaluation coefficient corresponding to the target power grid management with an operation evaluation coefficient threshold stored in the database, judging that the database operation state corresponding to the target power grid management is abnormal if the database operation evaluation coefficient corresponding to the target power grid management is smaller than the operation evaluation coefficient threshold stored in the database, and judging that the database operation state corresponding to the target power grid management is normal if the database operation evaluation coefficient corresponding to the target power grid management is larger than or equal to the operation evaluation coefficient threshold stored in the database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311263048.7A CN117435422A (en) | 2023-09-27 | 2023-09-27 | Parallel real-time database active-standby switching management system for power grid management |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311263048.7A CN117435422A (en) | 2023-09-27 | 2023-09-27 | Parallel real-time database active-standby switching management system for power grid management |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117435422A true CN117435422A (en) | 2024-01-23 |
Family
ID=89552432
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311263048.7A Pending CN117435422A (en) | 2023-09-27 | 2023-09-27 | Parallel real-time database active-standby switching management system for power grid management |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117435422A (en) |
-
2023
- 2023-09-27 CN CN202311263048.7A patent/CN117435422A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9047212B2 (en) | Error estimation module and estimation method thereof for flash memory | |
| CN104834608A (en) | Cache replacement method under heterogeneous memory environment | |
| CN112528279B (en) | Method and device for establishing intrusion detection model | |
| CN116775731B (en) | Sliding window-based calculation method for fault-connection trace-back electric quantity of three-phase electric energy meter | |
| CN104331347B (en) | Variable error rate-oriented check point interval real-time determining method | |
| CN115248757A (en) | Hard disk health assessment method and storage device | |
| CN113326612A (en) | Power distribution network reliability assessment method and device | |
| WO2022037168A1 (en) | Method and system for testing conversion relationship between block reading and page reading in flash memory chip | |
| CN117435422A (en) | Parallel real-time database active-standby switching management system for power grid management | |
| CN110377598B (en) | Multi-source heterogeneous data storage method based on intelligent manufacturing process | |
| CN111767546B (en) | Deep learning-based input structure inference method and device | |
| CN108491432A (en) | Electric system cumulative amount storage based on eap-message digest and abstracting method, electronic equipment and storage medium | |
| CN117472679A (en) | Anomaly detection method and system combining data flow and control flow drift discovery | |
| CN115460061B (en) | Health evaluation method and device based on intelligent operation and maintenance scene | |
| CN116089537A (en) | Incremental data synchronization method, system, computer and storage medium | |
| CN110954727A (en) | Electric energy meter data complementary copying method based on mirror image method | |
| CN105786668A (en) | Method for memory error detection based on Redhat system | |
| CN115543702A (en) | Multi-source solid state disk collaborative fault diagnosis method, system, equipment and medium | |
| CN112231141B (en) | Method and device for improving Raid data backup efficiency | |
| US11972361B2 (en) | Performance optimization of object grouping schema in a network key-value storage device using adaptive regression | |
| CN110457284B (en) | Multi-time point data recovery method and system based on SQLServer database | |
| CN112714288A (en) | Intelligent monitoring method and device and monitoring equipment | |
| CN111309612A (en) | Distributed file system based data current limiting test method and system | |
| CN116414839B (en) | SSD-oriented time sequence data storage method and system based on LSM_Tree | |
| CN117873641A (en) | Virtual machine thermal migration result prediction method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |