CN109165228A - Smart grid Dispatching Control System real-time data base monitoring system and method - Google Patents
Smart grid Dispatching Control System real-time data base monitoring system and method Download PDFInfo
- Publication number
- CN109165228A CN109165228A CN201810889735.2A CN201810889735A CN109165228A CN 109165228 A CN109165228 A CN 109165228A CN 201810889735 A CN201810889735 A CN 201810889735A CN 109165228 A CN109165228 A CN 109165228A
- Authority
- CN
- China
- Prior art keywords
- real
- data base
- time data
- monitoring
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/06—Electricity, gas or water supply
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Abstract
The present invention provides a kind of smart grid Dispatching Control System real-time data base monitoring system and methods, are related to database technical field, which includes mode monitoring module, data monitoring module and middle layer monitoring module；The mode monitoring module is for monitoring the correctness of mode of real-time data base and the consistency of the mode of the real-time data base and the mode of relational database；The data monitoring module is used to monitor the consistency of data between the consistency and standby machine real-time data base of the data of the real-time data base and the data of the relational database；The middle layer monitoring module is used to monitor the operating status of middle layer.A kind of smart grid Dispatching Control System real-time data base monitoring system and method provided in an embodiment of the present invention can carry out automated surveillance to real-time data base, improve O&M efficiency, effectively improve operation stability and the safety of real-time data base.
Description
Technical field
The present invention relates to database technical fields, more particularly, to a kind of smart grid Dispatching Control System real-time data base
Monitoring system and method.
Background technique
Real-time data base is specifically used to provide efficient real time data access, realizes the monitoring, control and electricity of electric system
Net analysis.Inside smart grid scheduling support system, the application that real-time has higher requirements is required to construct and counted in real time
On library, at the same real-time data base be also apply between platform, between application and application data interaction basis.
An extremely important component part of the real-time data base as smart grid Dispatching Control System, fills under commercial library
Data simultaneously provide data access service to tools such as application all on platform and pictorial statements.Real-time data base entity only exists
Application service end administration, client do not have real-time data base: the requirement in order to meet system real time, real-time data base use magnetic
The memory management mechanism of disk File Mapping, efficiency will be significantly larger than commercial library, simultaneously because the importance of system, does not require nothing more than and mention
The data service efficiency of confession wants high, more requires accurately and reliably, in addition real-time data base in smart grid Dispatching Control System
System also provides various access interfaces, including local interface and network interface, in order to which third equation to real time data and is gone through
History data access, and optimize the efficiency of service to greatest extent while guaranteeing data reliability.
Currently, real-time data base can only checked manually when something goes wrong by O&M and research staff, inefficiency.
Summary of the invention
In view of this, the purpose of the present invention is to provide a kind of smart grid Dispatching Control System real-time data base monitoring systems
System and method can carry out automated surveillance to real-time data base, improve O&M efficiency, effectively improve real-time data base
Operation stability and safety.
In a first aspect, the embodiment of the invention provides a kind of smart grid Dispatching Control System real-time data base monitoring systems
System, comprising: mode monitoring module, data monitoring module and middle layer monitoring module；The mode monitoring module is for monitoring in real time
The consistency of the correctness of the mode of database and the mode of the real-time data base and the mode of relational database；Data prison
Depending on module for monitoring that the consistency of the data of the real-time data base and the data of the relational database and standby machine count in real time
According to the consistency of data between library；The middle layer monitoring module is used to monitor the operating status of middle layer.
With reference to first aspect, the embodiment of the invention provides the first possible embodiments of first aspect, wherein should
Mode monitoring module includes System Management Mode monitoring unit, table schema monitoring unit and attributed scheme monitoring unit；The system
Management mode monitoring unit is used to monitor the consistency of the management mode of the real-time data base and relational database；Table schema prison
It is used to monitor in the real-time data base and historical data base depending on unit and model table number in the standby machine real-time data base
The consistency of consistency and model table essential information；The attributed scheme monitoring unit is for monitoring that each domain information table is real-time at this
Consistency in database and the historical data base and in the standby machine real-time data base.
The possible embodiment of with reference to first aspect the first, the embodiment of the invention provides second of first aspect
Possible embodiment, wherein the monitoring content of the System Management Mode monitoring unit includes: of state on monitored node
All database tables on number, the application of the title of state, state, the real-time database table quantity of application and monitored node.
The possible embodiment of with reference to first aspect the first, the embodiment of the invention provides the third of first aspect
Possible embodiment, wherein the model table essential information includes: the English name of the Chinese of database table, database table
Claim, the description information of application and database table belonging to database table.
The possible embodiment of with reference to first aspect the first, the embodiment of the invention provides the 4th kind of first aspect
Possible embodiment, wherein the monitoring step of above-mentioned attributed scheme monitoring unit, comprising: database table more to be monitored
It is whether consistent in the real-time data base and the attribute type in historical data base and in the standby machine real-time data base；If so,
Then compare attribute of the database table in the real-time data base and the historical data base and in the standby machine real-time data base
Whether length is consistent；If so, comparing the database table in the real-time data base and the historical data base and the standby machine
Whether the attribute excursion in real-time data base is consistent；If so, the attributed scheme monitoring result for exporting the database table is attribute
Mode is consistent.
With reference to first aspect, the embodiment of the invention provides the 5th kind of possible embodiments of first aspect, wherein should
Data monitoring module includes that model maintenance operation monitoring unit, model maintenance data loading monitoring unit and real-time data base are active and standby
Machine conformance monitoring unit；The model maintenance operation monitoring unit is used to monitor the model maintenance operation of user；The model maintenance
Data loading monitoring unit is used to monitor the operation of model maintenance data loading；The real-time data base standby machine conformance monitoring list
Member is for monitoring the real-time and consistency of real-time data base standby machine node dynamic refresh data.
The 5th kind of possible embodiment with reference to first aspect, the embodiment of the invention provides the 6th kind of first aspect
Possible embodiment, wherein the monitoring information of the model maintenance operation monitoring unit includes: the Hostname of operation, operation
Person's user name, the time of operation, action type, the major key information of operation note and the threshold information of the operation note.
The 5th kind of possible embodiment with reference to first aspect, the embodiment of the invention provides the 7th kind of first aspect
Possible embodiment, wherein the monitoring step of above-mentioned model maintenance data loading monitoring unit includes: to receive model maintenance circle
The first data modification information in face；Judge whether to receive the second data modification information that relationship model data maintenance service issues；
If so, comparing the first data modification information and whether the second data modification information is consistent；If so, judging whether to receive
The third data modification information that model real time data safeguard service issues；If so, comparing the first data modification information and being somebody's turn to do
Whether third data modification information is consistent；If so, the monitoring result for exporting the model maintenance data loading monitoring unit is mould
Type safeguards data loading success.
The 5th kind of possible embodiment with reference to first aspect, the embodiment of the invention provides the 8th kind of first aspect
Possible embodiment, wherein the monitoring step of the real-time data base standby machine conformance monitoring unit includes: to compare standby machine
Whether the record number in real-time data base is consistent；If so, whether the major key compared in the standby machine real-time data base is consistent；If
It is whether then compare the corresponding record attribute of the major key consistent；If so, exporting the real-time data base standby machine conformance monitoring
The monitoring result of unit is that the data of standby machine real-time data base are consistent.
Second aspect, the embodiment of the invention also provides a kind of real-time data bases to monitor method, comprising: judges real time data
Whether the mode in library is correct, and compares the whether consistent of the mode of the real-time data base and the mode of relational database；If so, defeated
Mode monitoring result out, and whether the data for comparing the real-time data base are consistent and active and standby with the data of the relational database
Whether data are consistent between machine real-time data base；If so, output data monitoring result, and monitor the operation information of middle layer；It should
Operation information includes at least CPU usage, number of network connections and coredump record；Export the operation information.
The embodiment of the present invention bring it is following the utility model has the advantages that
A kind of smart grid Dispatching Control System real-time data base monitoring system and method provided in an embodiment of the present invention, should
System includes mode monitoring module, data monitoring module and middle layer monitoring module；The mode monitoring module is for monitoring in real time
The consistency of the correctness of the mode of database and the mode of the real-time data base and the mode of relational database；Data prison
Depending on module for monitoring that the consistency of the data of the real-time data base and the data of the relational database and standby machine count in real time
According to the consistency of data between library；The middle layer monitoring module is used to monitor the operating status of middle layer；It can be to real time data
Library carries out automated surveillance, improves O&M efficiency, effectively improves operation stability and the safety of real-time data base.
Other feature and advantage of the disclosure will illustrate in the following description, alternatively, Partial Feature and advantage can be with
Deduce from specification or unambiguously determine, or by implement the disclosure above-mentioned technology it can be learnt that.
To enable the above objects, features, and advantages of the disclosure to be clearer and more comprehensible, preferred embodiment is cited below particularly, and cooperate
Appended attached drawing, is described in detail below.
Detailed description of the invention
It, below will be to specific in order to illustrate more clearly of the specific embodiment of the invention or technical solution in the prior art
Embodiment or attached drawing needed to be used in the description of the prior art be briefly described, it should be apparent that, it is described below
Attached drawing is some embodiments of the present invention, for those of ordinary skill in the art, before not making the creative labor
It puts, is also possible to obtain other drawings based on these drawings.
Fig. 1 is a kind of knot of smart grid Dispatching Control System real-time data base monitoring system provided in an embodiment of the present invention
Structure schematic diagram；
Fig. 2 is a kind of application environment schematic diagram of real-time data base provided in an embodiment of the present invention；
Fig. 3 is a kind of application environment schematic diagram of the middle layer of real-time data base provided in an embodiment of the present invention；
Fig. 4 is the flow chart that a kind of attributed scheme provided in an embodiment of the present invention monitors method；
Fig. 5 is the flow chart that a kind of model maintenance data loading provided in an embodiment of the present invention monitors method；
Fig. 6 is a kind of flow chart of real-time data base standby machine conformance monitoring method provided in an embodiment of the present invention；
Fig. 7 is the stream that a kind of smart grid Dispatching Control System real-time data base provided in an embodiment of the present invention monitors method
Cheng Tu.
Icon:
11- mode monitoring module；12- data monitoring module；13- middle layer monitoring module；The scheduling control of 100- smart grid
System real-time database monitoring system processed.
Specific embodiment
In order to make the object, technical scheme and advantages of the embodiment of the invention clearer, below in conjunction with attached drawing to the present invention
Technical solution be clearly and completely described, it is clear that described embodiments are some of the embodiments of the present invention, rather than
Whole embodiments.Based on the embodiments of the present invention, those of ordinary skill in the art are not making creative work premise
Under every other embodiment obtained, shall fall within the protection scope of the present invention.
Currently, real-time data base can only be solved by way of manually checking when something goes wrong in operation, the O&M of personnel
Difficulty, and inefficiency.Based on this, a kind of smart grid Dispatching Control System real-time data base provided in an embodiment of the present invention
Monitoring system and method can carry out automated surveillance to real-time data base, improve O&M efficiency, effectively improve real-time number
Operation stability and safety according to library.
To dispatch control to a kind of smart grid disclosed in the embodiment of the present invention first convenient for understanding the present embodiment
System real-time database monitoring system processed describes in detail.
Embodiment one
As shown in Figure 1, for a kind of smart grid Dispatching Control System real-time data base monitoring provided in an embodiment of the present invention
The structural schematic diagram of system, as seen from Figure 1, the smart grid Dispatching Control System real-time data base monitoring system 100 include mould
Formula monitoring module 11, data monitoring module 12 and middle layer monitoring module 13.
Wherein, mode monitoring module 11 is used to monitor the correctness and the real-time data base of the mode of real-time data base
The consistency of mode and the mode of relational database.Pass through real-time data base mode monitoring module 11, it is ensured that real time data
The normal access in library.
Also, data monitoring module 12 is for monitoring the one of the data of the real-time data base and the data of the relational database
The consistency of data between cause property and standby machine real-time data base.Here, the array of real-time data base mainly includes two portions
Point, one is the data in real-time data base, one be real-time data base source data, i.e. the pattern number of relational database
According to.Only this two-part data is correct and consistent, just can guarantee that the data that real-time data base externally provides are correct
's.And the data in real-time data base, and be divided into two parts, one be the real-time data base in host data, one is
The array of real-time data base in standby host, only this two-part data is correct and is consistent, and can guarantee real-time number
According to the safe and stable operation in library.
It referring to fig. 2, is a kind of application environment schematic diagram of real-time data base provided in an embodiment of the present invention, it is real in Fig. 2
When database fill data under commercial library, and the tools such as application and pictorial statement all on platform is given to provide data access clothes
Business, real-time data base entity are only affixed one's name in application service end, and client does not have real-time database.Real-time database is using disk file mapping
Memory management mechanism, efficiency will be significantly larger than commercial library, and real-time database subsystem also provides various access interfaces, in order to third party
Program accesses to real time data and historical data.In this way, guaranteeing number in real time by real-time data base data monitoring module 12
According to the consistency of real-time data base data between library and the consistency and standby machine of the data of relational database, so as to protect
Card real-time data base normally provides correct and complete real time data for each application.
In the smart grid Dispatching Control System real-time data base monitoring system 100, middle layer monitoring module 13 is used for
Monitor the operating status of middle layer.Real-time data base middle layer is mainly made of service, the safe and stable operation of middle layer, is determined
Real-time data base whether normally can externally listen access service.And monitor the operating status of middle layer, it is substantially exactly to monitor
The operating status of service.
By taking smart grid Dispatching Control System as an example, real-time data base middle layer is each in smart grid Dispatching Control System
The bridge of the real-time data base of a application access, real-time data base middle layer ensure that the reliability and convenience of each application access
Property, while the safety and stability for also ensuring real-time data base itself.It is provided in an embodiment of the present invention one referring to Fig. 3
The application environment schematic diagram of the middle layer of kind real-time data base, as seen from Figure 3, real-time data base middle layer is divided into data access layer
And Business Logic.Wherein, data access layer is in the bottom, is to the non-primary data (real-time database of real-time data base
Put the form of data) operation layer, without referring to initial data, that is to say, that be the operation to real-time data base, and be business
Logical layer provides data service.The service of data access layer specifically includes that rtdb_server and download_server.Separately
Outside, Business Logic is the operation for specific problem, it is understood that the operation of paired data layer, to data service logic
Processing, if data Layer is building blocks, that logical layer is exactly to build to these building blocks.The service that Business Logic mainly includes
Are as follows: middata, midmmi and middata_fes.
In wherein one or more possible embodiments, the monitoring of real-time data base middle layer relevant information includes pair
The CPU usage of middle layer, memory use, state, the starting time, the duration, sub-line number of passes, number of network connections,
The monitoring of the state index of coredump record and disk read-write.Monitor that these indexs are capable of the operation shape of actual response middle layer
State guarantees the safe and stable operation of real-time data base data access.
In alternatively possible embodiment, the smart grid Dispatching Control System real-time data base monitoring system 100
Further include output module, the output module respectively with mode monitoring module 11, data monitoring module 12 and middle layer monitoring module
13 are connected, for exporting the monitoring result of these three modules.In this way, passing through mode monitoring module 11, data monitoring module 12
With middle layer monitoring module 13, the automation of the database schema to real-time data base, database data and middle layer is realized
Monitoring, can monitor the respective consistency in above three part and correctness, real-time data base when something goes wrong, can show
Currently practical monitoring result, facilitates problem to check, and is checked manually without operation maintenance personnel or research staff, O&M efficiency
It is higher, the safer stabilization of the operation of real-time data base.
A kind of smart grid Dispatching Control System real-time data base monitoring system provided in an embodiment of the present invention, the system packet
Include mode monitoring module, data monitoring module and middle layer monitoring module；The mode monitoring module is for monitoring real-time data base
The correctness of mode and the mode of the real-time data base and the mode of relational database consistency；The data monitoring module
For monitor the data of the real-time data base and the data of the relational database consistency and standby machine real-time data base it
Between data consistency；The middle layer monitoring module is used to monitor the operating status of middle layer；Real-time data base can be carried out
Automated surveillance improves O&M efficiency, effectively improves operation stability and the safety of real-time data base.
Embodiment two
The embodiment of the present invention mainly describes in a kind of smart grid Dispatching Control System real-time data base monitoring system
The monitoring method of mode monitoring module.
In the present embodiment, mode monitoring module includes System Management Mode monitoring unit, table schema monitoring unit and category
Sexual norm monitoring unit.Wherein, which is used to monitor the real-time data base and relational database
The consistency of management mode forgets that lower dress leads to real-time database and the relationship library of part of nodes so as to avoid the node occurred once in a while
The inconsistent problem of mode.Here, the content of System Management Mode monitoring unit monitoring includes:
(a1) it is monitored the number of state on node；
(a2) it is monitored the title of each state on node；
(a3) it is monitored the application on node included under each state；
(a4) it is monitored on node and respectively applies lower real-time database table quantity；
(a5) it is monitored database table all on node.
The monitoring method of System Management Mode monitoring unit is the storage organization according to real-time data base, and definition is deposited accordingly
Then storage structure object obtains the application for including under state number, state title, state in real-time data base storage organization, real time data
The table data volume in library and relevant real-time data base table information.Because all of above information is all to deposit in a structured way
Storage is in the management information of real-time data base, so acquisition modes are more convenient.
In addition, the table schema monitoring unit in the mode monitoring module is for monitoring the real-time data base and historical data
The consistency of the consistency of model table number and model table essential information in library and in the standby machine real-time data base.Here,
The essential information of model table includes:
(b1) Chinese of database table；
(b2) English name of database table；
(b3) application belonging to database table；
(b4) database table description information.
After getting corresponding table schema information by the storage organization of real-time data base, more each node is needed
Whether real-time database and the table schema information in relationship library are consistent.Firstly, detecting the table information table and relationship library EMS on each node
In table information table data it is whether consistent；Then, then the table information table of the table information table and this node on each standby host node is detected
It is whether consistent.If information above is all consistent, illustrate that the table schema information of real-time data base is substantially consistent.
In the present embodiment, the attributed scheme monitoring unit is for monitoring each domain information table in the real-time data base and being somebody's turn to do
Consistency in historical data base and in the standby machine real-time data base.It is main by comparing each node domain information table
Whether data are consistent.Wherein, monitor that the information of each attribute of domain information table in each node real-time database specifically includes that
(c1) Chinese of attribute；
(c2) English name of attribute；
(c3) data type of attribute；
(c4) data length of attribute；
(c5) offset of attribute；
(c6) application belonging to attribute；
(c7) attribute information whether be consistent in relational database.
After getting corresponding attributed scheme information by the storage organization of real-time data base, more each node is needed
Real-time database and the attributed scheme information in relationship library it is whether consistent.Firstly, detecting the domain information table and relationship on each node
Whether the domain information table data in the EMS of library are consistent；Then, then domain information table on each standby host node is detected and the domain of this node is believed
Whether consistent cease table.If information above is all consistent, illustrate that the attributed scheme information of real-time data base is substantially consistent.
It referring to fig. 4, is a kind of flow chart of attributed scheme monitoring method provided in an embodiment of the present invention, from fig. 4, it can be seen that should
Method the following steps are included:
Step S402: database table more to be monitored the real-time data base in historical data base and this is active and standby
Whether the attribute type in machine real-time data base is consistent.
Step S404: if so, comparing the database table in the real-time data base and the historical data base and the master
Whether the attribute length in standby host real-time data base is consistent.
If it is not, then showing that attributed scheme is inconsistent.
Step S406: if so, comparing the database table in the real-time data base and the historical data base and the master
Whether the attribute excursion in standby host real-time data base is consistent.
If it is not, then showing that attributed scheme is inconsistent.
Step S408: if so, the attributed scheme monitoring result for exporting the database table is that attributed scheme is consistent.
If it is not, then showing that attributed scheme is inconsistent, and exporting monitoring result is that attributed scheme is inconsistent.
In this way, smart grid Dispatching Control System real-time data base monitoring system provided in this embodiment, mode monitoring
Module, can by the monitoring of the System Management Mode monitoring unit, table schema monitoring unit and attributed scheme monitoring unit of subordinate
With the status information of automated surveillance System Management Mode, table schema and attributed scheme.
Embodiment three
The embodiment of the present invention mainly describes in a kind of smart grid Dispatching Control System real-time data base monitoring system
The monitoring method of data monitoring module.
In the present embodiment, which includes model maintenance operation monitoring unit, model maintenance data loading
Monitoring unit and real-time data base standby machine conformance monitoring unit.Wherein, the model maintenance operation monitoring unit is for monitoring
The model maintenance of user operates, and the monitoring information of the model maintenance operation monitoring unit includes:
(d1) Hostname operated；
(d2) operator's user name；
(d3) time operated；
(d4) action type (addition, is deleted at modification)；
(d5) the major key information of operation note；
(d6) the thresholding information of operation note.
In addition, the model maintenance data loading monitoring unit is used to monitor the operation of model maintenance data loading.Referring to figure
5, for a kind of flow chart of model maintenance data loading monitoring method provided in an embodiment of the present invention, as seen from Figure 5, this method
Step includes:
Step S502: the first data modification information at model maintenance interface is received.
Step S504: judge whether to receive the second data modification information that relationship model data maintenance service issues.
If not receiving the second data modification information, then it represents that synchronize commercialization in the model data of model maintenance interface modification
Library failure.
Step S505: if so, comparing the first data modification information and whether the second data modification information is consistent.
If the first data modification information and the second data modification information are inconsistent, then it represents that synchronize commercial library mistake.
Step S506: if so, judging whether that the third data modification for receiving the sending of model real time data safeguard service is believed
Breath.
If not receiving third data modification information, then it represents that the model data of model maintenance interface modification synchronizes real-time number
Fail according to library.
Step S510: if so, comparing the first data modification information and whether the third data modification information is consistent.
If the first data modification information is different with third data modification information, then it represents that synchronous real-time data base mistake.
Step S512: if so, the monitoring result for exporting the model maintenance data loading monitoring unit is model maintenance number
According to being put in storage successfully.
In the smart grid Dispatching Control System real-time data base monitoring system, the real-time data base standby machine consistency
Monitoring unit is used to monitor the real-time and consistency of real-time data base standby machine node dynamic refresh data.One kind can wherein
In the embodiment of energy, as shown in fig. 6, be a kind of flow chart of real-time data base standby machine conformance monitoring method, it can by Fig. 6
See, the step of standby machine conformance monitoring method includes:
Step S602: whether the record number compared in standby machine real-time data base is consistent.
If not, then it represents that the record number of standby machine real-time data base is inconsistent.
Step S604: if so, whether the major key compared in the standby machine real-time data base is consistent.
If not, then it represents that the standby machine real-time data base record inconsistent there are major key.Compare host real-time database and standby host
Exist in the record which has different in real-time database, including host real-time database but standby host real-time database is not present and standby host is real-time
Exist in library but record that host real-time database is not present lists major key existing for all standby machines not by the analysis of the step
Consistent record.
Step S606: if so, whether compare the corresponding record attribute of the major key consistent.
If it is not, then listing all discrepant records of standby machine attribute.
Step S608: if so, the monitoring result for exporting the real-time data base standby machine conformance monitoring unit is active and standby
The data of machine real-time data base are consistent.
In this way, smart grid Dispatching Control System real-time data base monitoring system provided in this embodiment, data monitoring
Module passes through model maintenance operation monitoring unit, model maintenance data loading monitoring unit and the real-time data base standby machine of subordinate
The monitoring of conformance monitoring unit, can be with the operation of automated surveillance model maintenance, model maintenance data loading and real-time data base
The status information of standby machine consistency.
Example IV
The embodiment of the present invention mainly describes in a kind of smart grid Dispatching Control System real-time data base monitoring system
The monitoring method of middle layer monitoring module.
In the present embodiment, the information of middle layer monitoring module monitoring includes: CPU usage, and memory uses, state,
Start time, duration, sub-line number of passes, number of network connections, coredump record, disk read-write etc..
In a kind of wherein possible embodiment, for the CPU usage of middle layer, memory usage, network communication
Number sub thread number, the monitoring of the state indexs such as disk read-write can be believed by the file under file system/proc/pid/
Breath obtains basic data.For example, capture program can periodically acquire/proc/pid/ in the calculating of CPU usage
Information in stat and/proc/cpuinfo file, using in/proc/pid/stat collected cpu usage amount subtract
The secondary collected CPU usage amount of collection period, obtains the usage amount of process CPU time；Then, recycling/proc/cpuinfo
In collected data calculate CPU usage amount of the server in piece this period；Finally, with the CPU usage amount of middle layer
Divided by the usage amount of server, the CPU usage of middle layer is then obtained.In addition, multiple-core server is also needed multiplied by core cpu
Number obtains CPU usage.
The acquisition of middle layer program coredump information can allow user timely to understand the operating condition of middle layer.At least
In a kind of possible embodiment, monitor the program of middle layer every certain period (such as 30s) traversal it is primary/bin/ catalogue
Under file, check whether the coredump file of middle layer, and then collect middle layer whithin a period of time
The newest time of coredump quantity and coredump.
In addition, the monitoring of real-time data base mid-level network connection number can be ordered by the netstat of (SuSE) Linux OS
It enables and obtaining, which is used to print the status information of network system in Linux, can learn the network feelings of entire linux system
Condition.It can check under the port there is which client according to the port numbers of real-time data base middle layer and netstat order
The middle layer is connected, and the connection sum of client under the port can be counted.The detailed link information of the client of middle layer
Realization order are as follows: netstat-nat | grep-i " port numbers "；The realization order of the client connection sum of middle layer are as follows:
Netstat-nat | grep-i " port numbers " | wc-l.
In this way, smart grid Dispatching Control System real-time data base monitoring system provided in this embodiment, wherein interbed is supervised
It can be used depending on module with automated surveillance middle layer CPU usage, memory, state, the starting time, the duration, sub-line number of passes,
Number of network connections, coredump record, the state indexs such as disk read-write can be guaranteed with the operating status of actual response middle layer
The safe and stable operation of real-time data base data access.
Embodiment five
The embodiment of the invention also provides a kind of smart grid Dispatching Control System real-time data bases to monitor method, such as Fig. 7
It is shown, it is the flow chart that a kind of smart grid Dispatching Control System real-time data base provided in an embodiment of the present invention monitors method,
As seen from Figure 7, this method comprises the following steps:
Step S702: judge whether the mode of real-time data base is correct, and compare the mode and relationship of the real-time data base
The mode of database it is whether consistent.
If it is not, then output mode mistake or inconsistent information.
Step S704: if so, output mode monitoring result, and compare the data and the relational database of the real-time data base
Whether data consistent and standby machine real-time data base between data it is whether consistent.
If it is not, the then inconsistent information of output data.
Step S706: if so, output data monitoring result, and monitor the operation information of middle layer；The operation information is at least
It is recorded including CPU usage, number of network connections and coredump.
Step S708: the operation information is exported.
Smart grid Dispatching Control System real-time data base provided in an embodiment of the present invention monitors method, with above-described embodiment
The smart grid Dispatching Control System real-time data base monitoring system technical characteristic having the same of offer, so also can solve phase
Same technical problem, reaches identical technical effect.
Unless specifically stated otherwise, the opposite step of the component and step that otherwise illustrate in these embodiments, digital table
It is not limit the scope of the invention up to formula and numerical value.
The flow chart and block diagram in the drawings show the system of multiple embodiments according to the present invention, method and computer journeys
The architecture, function and operation in the cards of sequence product.In this regard, each box in flowchart or block diagram can generation
A part of one module, section or code of table, a part of the module, section or code include one or more use
The executable instruction of the logic function as defined in realizing.It should also be noted that in some implementations as replacements, being marked in box
The function of note can also occur in a different order than that indicated in the drawings.For example, two continuous boxes can actually base
Originally it is performed in parallel, they can also be executed in the opposite order sometimes, and this depends on the function involved.It is also noted that
It is the combination of each box in block diagram and or flow chart and the box in block diagram and or flow chart, can uses and execute rule
The dedicated hardware based system of fixed function or movement is realized, or can use the group of specialized hardware and computer instruction
It closes to realize.
In addition, in the description of the embodiment of the present invention unless specifically defined or limited otherwise, term " installation ", " phase
Even ", " connection " shall be understood in a broad sense, for example, it may be being fixedly connected, may be a detachable connection, or be integrally connected；It can
To be mechanical connection, it is also possible to be electrically connected；It can be directly connected, can also can be indirectly connected through an intermediary
Connection inside two elements.For the ordinary skill in the art, above-mentioned term can be understood at this with concrete condition
Concrete meaning in invention.
In the description of the present invention, it should be noted that term " center ", "upper", "lower", "left", "right", "vertical",
The orientation or positional relationship of the instructions such as "horizontal", "inner", "outside" be based on the orientation or positional relationship shown in the drawings, merely to
Convenient for description the present invention and simplify description, rather than the device or element of indication or suggestion meaning must have a particular orientation,
It is constructed and operated in a specific orientation, therefore is not considered as limiting the invention.In addition, term " first ", " second ",
" third " is used for descriptive purposes only and cannot be understood as indicating or suggesting relative importance.
The calculating of smart grid Dispatching Control System real-time data base monitoring method is carried out provided by the embodiment of the present invention
Machine program product, the computer readable storage medium including storing the executable non-volatile program code of processor are described
The instruction that program code includes can be used for executing previous methods method as described in the examples, and specific implementation can be found in method and implement
Example, details are not described herein.
In several embodiments provided herein, it should be understood that disclosed systems, devices and methods, it can be with
It realizes by another way.The apparatus embodiments described above are merely exemplary, for example, the division of the unit,
Only a kind of logical function partition, there may be another division manner in actual implementation, in another example, multiple units or components can
To combine or be desirably integrated into another system, or some features can be ignored or not executed.Another point, it is shown or beg for
The mutual coupling, direct-coupling or communication connection of opinion can be through some communication interfaces, device or unit it is indirect
Coupling or communication connection can be electrical property, mechanical or other forms.
The unit as illustrated by the separation member may or may not be physically separated, aobvious as unit
The component shown may or may not be physical unit, it can and it is in one place, or may be distributed over multiple
In network unit.It can select some or all of unit therein according to the actual needs to realize the mesh of this embodiment scheme
's.
It, can also be in addition, the functional units in various embodiments of the present invention may be integrated into one processing unit
It is that each unit physically exists alone, can also be integrated in one unit with two or more units.
It, can be with if the function is realized in the form of SFU software functional unit and when sold or used as an independent product
It is stored in the executable non-volatile computer-readable storage medium of a processor.Based on this understanding, of the invention
Technical solution substantially the part of the part that contributes to existing technology or the technical solution can be with software in other words
The form of product embodies, which is stored in a storage medium, including some instructions use so that
One computer equipment (can be personal computer, server or the network equipment etc.) executes each embodiment institute of the present invention
State all or part of the steps of method.And storage medium above-mentioned includes: USB flash disk, mobile hard disk, read-only memory (ROM, Read-
Only Memory), random access memory (RAM, Random Access Memory), magnetic or disk etc. are various can be with
Store the medium of program code.
Finally, it should be noted that embodiment described above, only a specific embodiment of the invention, to illustrate the present invention
Technical solution, rather than its limitations, scope of protection of the present invention is not limited thereto, although with reference to the foregoing embodiments to this hair
It is bright to be described in detail, those skilled in the art should understand that: anyone skilled in the art
In the technical scope disclosed by the present invention, it can still modify to technical solution documented by previous embodiment or can be light
It is readily conceivable that variation or equivalent replacement of some of the technical features；And these modifications, variation or replacement, do not make
The essence of corresponding technical solution is detached from the spirit and scope of technical solution of the embodiment of the present invention, should all cover in protection of the invention
Within the scope of.Therefore, protection scope of the present invention should be based on the protection scope of the described claims.
Claims (10)
1. a kind of smart grid Dispatching Control System real-time data base monitoring system characterized by comprising mode monitors mould
Block, data monitoring module and middle layer monitoring module；
The mode monitoring module is used to monitor the correctness of the mode of real-time data base and the mode of the real-time data base
With the consistency of the mode of relational database；
The data monitoring module is for monitoring that the data of the real-time data base are consistent with the data of the relational database
The consistency of data between property and standby machine real-time data base；
The middle layer monitoring module is used to monitor the operating status of middle layer.
2. smart grid Dispatching Control System real-time data base monitoring system according to claim 1, which is characterized in that institute
The mode monitoring module of stating includes System Management Mode monitoring unit, table schema monitoring unit and attributed scheme monitoring unit；
The System Management Mode monitoring unit is used to monitor the management mode of the real-time data base and the relational database
Consistency；
The table schema monitoring unit for monitor the real-time data base in historical data base and the standby machine is real-time
The consistency of the consistency of model table number and model table essential information in database；
The attributed scheme monitoring unit is for monitoring each domain information table in the real-time data base and the historical data base
In and the standby machine real-time data base in consistency.
3. smart grid Dispatching Control System real-time data base monitoring system according to claim 2, which is characterized in that institute
The monitoring content for stating System Management Mode monitoring unit includes: the number of state on monitored node, the title of the state, the state
Application, the application real-time database table quantity and the monitored node on all database table.
4. smart grid Dispatching Control System real-time data base monitoring system according to claim 2, which is characterized in that institute
State English name, the database table institute of Chinese, the database table that model table essential information includes: database table
The application of category and the description information of the database table.
5. smart grid Dispatching Control System real-time data base monitoring system according to claim 2, which is characterized in that institute
State the monitoring step of attributed scheme monitoring unit, comprising:
Database table more to be monitored the real-time data base in the historical data base and the standby machine is real-time
Whether the attribute type in database is consistent；
If so, the database table is in the real-time data base and the historical data base and the standby machine
Whether the attribute length in real-time data base is consistent；
If so, the database table is in the real-time data base and the historical data base and the standby machine
Whether the attribute excursion in real-time data base is consistent；
If so, the attributed scheme monitoring result for exporting the database table is that attributed scheme is consistent.
6. smart grid Dispatching Control System real-time data base monitoring system according to claim 1, which is characterized in that institute
Stating data monitoring module includes model maintenance operation monitoring unit, model maintenance data loading monitoring unit and real-time data base master
Standby host conformance monitoring unit；
The model maintenance operation monitoring unit is used to monitor the model maintenance operation of user；
The model maintenance data loading monitoring unit is used to monitor the operation of model maintenance data loading；
The real-time data base standby machine conformance monitoring unit is for monitoring real-time data base standby machine node dynamic refresh number
According to real-time and consistency.
7. smart grid Dispatching Control System real-time data base monitoring system according to claim 6, which is characterized in that institute
State model maintenance operation monitoring unit monitoring information include: the Hostname of operation, operator's user name, operation time,
The threshold information of action type, the major key information of operation note and the operation note.
8. smart grid Dispatching Control System real-time data base monitoring system according to claim 6, which is characterized in that institute
The monitoring step for stating model maintenance data loading monitoring unit includes:
Receive the first data modification information at model maintenance interface；
Judge whether to receive the second data modification information that relationship model data maintenance service issues；
If so, whether the first data modification information and the second data modification information are consistent；
If so, judging whether to receive the third data modification information that model real time data safeguard service issues；
If so, whether the first data modification information and the third data modification information are consistent；
If so, exporting the monitoring result of the model maintenance data loading monitoring unit as the success of model maintenance data loading.
9. smart grid Dispatching Control System real-time data base monitoring system according to claim 6, which is characterized in that institute
The monitoring step for stating real-time data base standby machine conformance monitoring unit includes:
Whether the record number compared in the standby machine real-time data base is consistent；
If so, whether the major key in the standby machine real-time data base is consistent；
If so, whether the corresponding record attribute of the major key is consistent；
If so, the monitoring result for exporting the real-time data base standby machine conformance monitoring unit is that the standby machine counts in real time
It is consistent according to the data in library.
10. a kind of smart grid Dispatching Control System real-time data base monitors method characterized by comprising
Judge whether the mode of real-time data base is correct, and the mode of the mode of the real-time data base and relational database
It is whether consistent；
If so, output mode monitoring result, and the data of the real-time data base and the data of the relational database are
Whether data are consistent between no consistent and standby machine real-time data base；
If so, output data monitoring result, and monitor the operation information of middle layer；The operation information is used including at least CPU
Rate, number of network connections and coredump record；
Export the operation information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810889735.2A CN109165228A (en) | 2018-08-06 | 2018-08-06 | Smart grid Dispatching Control System real-time data base monitoring system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810889735.2A CN109165228A (en) | 2018-08-06 | 2018-08-06 | Smart grid Dispatching Control System real-time data base monitoring system and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109165228A true CN109165228A (en) | 2019-01-08 |
Family
ID=64895290
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810889735.2A Pending CN109165228A (en) | 2018-08-06 | 2018-08-06 | Smart grid Dispatching Control System real-time data base monitoring system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109165228A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110008198A (en) * | 2019-03-07 | 2019-07-12 | 深圳供电局有限公司 | A kind of database structure and dispatch automated system |
| CN112182079A (en) * | 2020-09-22 | 2021-01-05 | 国电南瑞科技股份有限公司 | Real-time model and historical model data comparison method for automatic system |
| CN112416308A (en) * | 2020-11-30 | 2021-02-26 | 上海汽车集团股份有限公司 | Software optimization method and device and software architecture |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103491354A (en) * | 2013-10-10 | 2014-01-01 | 国家电网公司 | System operation monitoring and controlling visual platform |
| US20140129746A1 (en) * | 2012-11-02 | 2014-05-08 | Accenture Global Services Limited | Real-time data management for a power grid |
| CN104331425A (en) * | 2014-10-20 | 2015-02-04 | 许继电气股份有限公司 | Data synchronization method for real-time database of power grid monitoring system |
| CN105740352A (en) * | 2016-01-26 | 2016-07-06 | 华中电网有限公司 | Historical data service system used for smart power grid dispatching control system |
| CN106096804A (en) * | 2016-04-28 | 2016-11-09 | 北京科东电力控制系统有限责任公司 | A kind of supervision method of intelligent grid Dispatching Control System model maintenance overall process |
-
2018
- 2018-08-06 CN CN201810889735.2A patent/CN109165228A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140129746A1 (en) * | 2012-11-02 | 2014-05-08 | Accenture Global Services Limited | Real-time data management for a power grid |
| CN103491354A (en) * | 2013-10-10 | 2014-01-01 | 国家电网公司 | System operation monitoring and controlling visual platform |
| CN104331425A (en) * | 2014-10-20 | 2015-02-04 | 许继电气股份有限公司 | Data synchronization method for real-time database of power grid monitoring system |
| CN105740352A (en) * | 2016-01-26 | 2016-07-06 | 华中电网有限公司 | Historical data service system used for smart power grid dispatching control system |
| CN106096804A (en) * | 2016-04-28 | 2016-11-09 | 北京科东电力控制系统有限责任公司 | A kind of supervision method of intelligent grid Dispatching Control System model maintenance overall process |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110008198A (en) * | 2019-03-07 | 2019-07-12 | 深圳供电局有限公司 | A kind of database structure and dispatch automated system |
| CN112182079A (en) * | 2020-09-22 | 2021-01-05 | 国电南瑞科技股份有限公司 | Real-time model and historical model data comparison method for automatic system |
| CN112416308A (en) * | 2020-11-30 | 2021-02-26 | 上海汽车集团股份有限公司 | Software optimization method and device and software architecture |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104486445B (en) | Distributed extendable resource monitoring system based on cloud platform | |
| CN102739435B (en) | Failure detection and recovery as service | |
| CN102638378B (en) | Mass storage system monitoring method integrating heterogeneous storage devices | |
| CN109165228A (en) | Smart grid Dispatching Control System real-time data base monitoring system and method | |
| CN104915756B (en) | Data consistency cloud audit system and implementation method | |
| CN103812699A (en) | Monitoring management system based on cloud computing | |
| CN108092813A (en) | Data center's total management system server hardware Governance framework and implementation method | |
| CN103458020B (en) | A kind of monitoring method and system of the cloud platform based on XCP | |
| CN107168841A (en) | The remote test method and device of a kind of mobile device | |
| CN104506348A (en) | Method for automatically discovering and configuring monitoring object | |
| CN105447681A (en) | Physicochemical detection control and information management system | |
| CN108446326B (en) | A kind of isomeric data management method and system based on container | |
| CN110489407A (en) | Data filling mining method, apparatus, computer equipment and storage medium | |
| CN107645410A (en) | A kind of virtual machine management system and method based on OpenStack cloud platforms | |
| CN104683147A (en) | Hardware management method and system for large-scale data centre | |
| CN109450094A (en) | A kind of substation relay protection method for inspecting and system | |
| CN106209974B (en) | A kind of method of data synchronization, equipment and system | |
| CN107506194A (en) | Application version, which retracts, determines method and device | |
| CN109873714A (en) | Cloud computing node configures update method and terminal device | |
| CN112865311A (en) | Method and device for monitoring message bus of power system | |
| CN115643316A (en) | Data processing method and device for Internet of things gateway, gateway equipment and storage medium | |
| CN104378233A (en) | Equipment unified management method, incorporation method and corresponding devices | |
| CN101820356A (en) | Network fault diagnosis system based on ARM-Linux | |
| CN107977467A (en) | Database monitoring device | |
| CN107846460A (en) | A kind of recurrence system and method for Military Information System information flow |
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 | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20191217 Address after: 430070, 47 East Main Street, Hongshan District, Hubei, Wuhan Applicant after: State Grid Center China Grid Company Limited Address before: 430070, 47 East Main Street, Hongshan District, Hubei, Wuhan Applicant before: State Grid Center China Grid Company Limited Applicant before: Beijing Kedong Power Control System Co., Ltd. |
|
| TA01 | Transfer of patent application right | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190108 |
|
| RJ01 | Rejection of invention patent application after publication |