CN112070400A - Method and device for evaluating security situation of power grid database - Google Patents
Method and device for evaluating security situation of power grid database Download PDFInfo
- Publication number
- CN112070400A CN112070400A CN202010940964.XA CN202010940964A CN112070400A CN 112070400 A CN112070400 A CN 112070400A CN 202010940964 A CN202010940964 A CN 202010940964A CN 112070400 A CN112070400 A CN 112070400A
- Authority
- CN
- China
- Prior art keywords
- situation
- power grid
- information
- grid database
- safety
- 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
- 238000000034 method Methods 0.000 title claims abstract description 43
- 238000004519 manufacturing process Methods 0.000 claims abstract description 49
- 230000008447 perception Effects 0.000 claims abstract description 46
- 238000000605 extraction Methods 0.000 claims abstract description 11
- 238000011156 evaluation Methods 0.000 claims description 35
- 230000007613 environmental effect Effects 0.000 claims description 30
- 238000001514 detection method Methods 0.000 claims description 27
- 238000006243 chemical reaction Methods 0.000 claims description 22
- 238000007781 pre-processing Methods 0.000 claims description 21
- 238000012800 visualization Methods 0.000 claims description 20
- 238000012545 processing Methods 0.000 claims description 18
- 230000035945 sensitivity Effects 0.000 claims description 17
- 238000005406 washing Methods 0.000 claims description 15
- 230000008859 change Effects 0.000 claims description 14
- 238000004140 cleaning Methods 0.000 claims description 11
- 238000004364 calculation method Methods 0.000 claims description 7
- 230000036541 health Effects 0.000 claims description 7
- 238000012423 maintenance Methods 0.000 abstract description 11
- 238000005516 engineering process Methods 0.000 abstract description 7
- 238000011161 development Methods 0.000 abstract description 6
- 230000009471 action Effects 0.000 abstract description 5
- 238000013507 mapping Methods 0.000 description 6
- 230000008569 process Effects 0.000 description 6
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000003860 storage Methods 0.000 description 3
- 230000002159 abnormal effect Effects 0.000 description 2
- 239000003086 colorant Substances 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 238000012795 verification Methods 0.000 description 2
- 230000000007 visual effect Effects 0.000 description 2
- 230000005856 abnormality Effects 0.000 description 1
- 230000006399 behavior Effects 0.000 description 1
- 238000004040 coloring Methods 0.000 description 1
- 230000010485 coping Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000013524 data verification Methods 0.000 description 1
- 238000013079 data visualisation Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000005855 radiation Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000003319 supportive effect Effects 0.000 description 1
- 230000016776 visual perception Effects 0.000 description 1
Images
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
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06393—Score-carding, benchmarking or key performance indicator [KPI] analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/26—Visual data mining; Browsing structured data
-
- 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—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- Human Resources & Organizations (AREA)
- Economics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Educational Administration (AREA)
- General Business, Economics & Management (AREA)
- Development Economics (AREA)
- Tourism & Hospitality (AREA)
- Quality & Reliability (AREA)
- Health & Medical Sciences (AREA)
- Probability & Statistics with Applications (AREA)
- Marketing (AREA)
- Water Supply & Treatment (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Public Health (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Game Theory and Decision Science (AREA)
- Operations Research (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application provides a method and a device for evaluating the security situation of a power grid database, and the method and the device are based on the situation perception technology, the situation perception element information of the power grid database is acquired and comprises environment element information and production element information, the preprocessed situation perception element information is subjected to information extraction, the obtained element statistical information is combined with a dynamic topology model of the power grid database to calculate the security situation index value of a node, and the security situation index value is used as a sequential prediction index of the recent development trend of the power grid database to make decision and action, so that the current situation of passive maintenance is overcome, and the technical problem of low reliability of security maintenance of the existing power grid database is solved.
Description
Technical Field
The application relates to the technical field of data security, in particular to a method and a device for evaluating security situation of a power grid database.
Background
With the rise of big data technology, a lot of enterprises begin to pay attention to data storage and application, the current power grid company information system is greatly centralized, business data is centralized to be operated on the provincial company level, business types and data volume are linearly increased, and performance maintenance of a database becomes an important factor restricting operation of a business system in the big environment.
At present, an information visualization model is generally adopted in a power grid database security maintenance mode in the power industry, and real-time information is combined to reflect a real-time state of a power grid database, but when the information visualization model is actually applied, when the information visualization model shows that a state is abnormal, the abnormality really exists, and negative effects brought by the abnormal state are generated, so that operation and maintenance personnel can only passively maintain the state to reduce the negative effects, and the technical problem of low reliability of the current power grid database security maintenance is caused.
Disclosure of Invention
The application provides a method and a device for evaluating the security situation of a power grid database, which are used for solving the technical problem of low reliability of the security maintenance of the existing power database.
First, a first aspect of the present application provides a method for evaluating a security situation of a power grid database, including:
acquiring situation perception element information of a power grid database, wherein the situation perception element information comprises: environmental element information and production element information;
carrying out data cleaning pretreatment and format conversion pretreatment on the situation perception element information;
performing information extraction on the preprocessed situation perception element information through a data association classification engine according to the association relation of the situation perception element information on the time dimension and the space dimension to obtain the environment element statistical information and the production element statistical information;
associating the environmental element information, the production element information and each node in a topology model corresponding to the power grid database based on the spatial dimensions of the environmental element statistical information and the production element statistical information;
and calculating the safety situation index values of the nodes based on the time dimensions of the associated nodes, the environment element statistical information and the production element statistical information, so as to obtain a safety situation evaluation result of the power grid database based on the safety situation index values corresponding to the nodes.
Preferably, the safety situation index value specifically includes: the probability of a health state, the probability of an alert state, the probability of a fault state, the probability of load flow safety, the probability of load flow overload and the probability of load flow overload shedding.
Preferably, the data cleaning preprocessing specifically includes: zero data washing, error data washing and repeated data washing;
the format conversion preprocessing specifically comprises: time format processing, decimal processing, and line-column conversion processing.
Preferably, after obtaining the evaluation result of the security situation of the power grid database, the method further includes:
and combining and displaying the safety situation evaluation result of the power grid database and the dynamic topology model of the power grid database through a graphic visualization tool.
Preferably, after obtaining the evaluation result of the security situation of the power grid database, the method further includes:
based on the evaluation result of the security situation of the power grid database, carrying out security detection on nodes which do not pass the evaluation result of the security situation of the power grid database so as to obtain a security detection result;
and calculating the change sensitivity by using the nodes which do not pass the safety detection result based on the safety detection result to obtain the situation change sensitivity.
Secondly, the second aspect of the present application provides a device for evaluating the security situation of a power grid database, comprising:
the element acquisition unit is used for acquiring situation perception element information of a power grid database, wherein the situation perception element information comprises: environmental element information and production element information;
the preprocessing unit is used for carrying out data cleaning preprocessing and format conversion preprocessing on the situation perception element information;
the extraction unit is used for extracting the information of the preprocessed situation perception element information through a data association classification engine according to the association relation of the situation perception element information on the time dimension and the space dimension to obtain the environment element statistical information and the production element statistical information;
the topology association unit is used for associating the environmental element information and the production element information with each node in a topology model corresponding to the power grid database based on the spatial dimensions of the environmental element statistical information and the production element statistical information;
and the safety situation evaluation unit is used for calculating the safety situation index values of the nodes based on the time dimensions of the associated nodes, the environment element statistical information and the production element statistical information so as to obtain the safety situation evaluation result of the power grid database based on the safety situation index values corresponding to the nodes.
Preferably, the safety situation index value specifically includes: the probability of a health state, the probability of an alert state, the probability of a fault state, the probability of load flow safety, the probability of load flow overload and the probability of load flow overload shedding.
Preferably, the data cleaning preprocessing specifically includes: zero data washing, error data washing and repeated data washing;
the format conversion preprocessing specifically comprises: time format processing, decimal processing, and line-column conversion processing.
Preferably, the method further comprises the following steps:
and the visualization unit is used for displaying the safety situation evaluation result of the power grid database and the dynamic topology model of the power grid database in a combined manner through a graphic visualization tool.
Preferably, the method further comprises the following steps:
the safety detection unit is used for carrying out safety detection on nodes which do not pass the safety situation evaluation result of the electric network database based on the safety situation evaluation result of the electric network database so as to obtain a safety detection result;
and the sensitivity calculation unit is used for calculating the change sensitivity of the nodes which do not pass the safety detection result based on the safety detection result to obtain the situation change sensitivity.
According to the technical scheme, the embodiment of the application has the following advantages:
the application provides a method for evaluating the security situation of a power grid database in a first aspect, which comprises the following steps: acquiring situation perception element information of a power grid database, wherein the situation perception element information comprises: environmental element information and production element information; carrying out data cleaning pretreatment and format conversion pretreatment on the situation perception element information; performing information extraction on the preprocessed situation perception element information through a data association classification engine according to the association relation of the situation perception element information on the time dimension and the space dimension to obtain the environment element statistical information and the production element statistical information; associating the environmental element information, the production element information and each node in a topology model corresponding to the power grid database based on the spatial dimensions of the environmental element statistical information and the production element statistical information; and calculating the safety situation index values of the nodes based on the time dimensions of the associated nodes, the environment element statistical information and the production element statistical information, so as to obtain a safety situation evaluation result of the power grid database based on the safety situation index values corresponding to the nodes.
The situation awareness element information of the power grid database is acquired based on the situation awareness technology and comprises environment element information and production element information, the preprocessed situation awareness element information is subjected to information extraction, the obtained element statistical information is combined with the dynamic topological model of the power grid database to calculate the safety situation index value of the node, the safety situation index value is used as a sequential prediction index of the recent development trend of the power grid database to perform decision and action, the current situation of passive maintenance is overcome, and the technical problem that the existing power grid database is low in safety maintenance reliability is solved.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present application, and it is obvious for those skilled in the art that other drawings can be obtained according to the drawings without inventive exercise.
Fig. 1 is a schematic flowchart of a first embodiment of a method for evaluating a security situation of a power grid database according to the present application.
Fig. 2 is a schematic flowchart of a method for evaluating a security situation of a power grid database according to a second embodiment of the present disclosure.
Fig. 3 is a schematic structural diagram of a first embodiment of an apparatus for evaluating a security situation of a power grid database according to the present application.
Detailed Description
The embodiment of the application provides a method and a device for evaluating the security situation of a power grid database, which are used for solving the technical problem of low reliability of the security maintenance of the existing power database.
In order to make the objects, features and advantages of the present invention more apparent and understandable, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present application, and it is apparent that the embodiments described below are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
Situation Awareness (situational Awareness) is an environment-based ability to dynamically and integrally know security risks, and is a way to improve the ability of discovering, recognizing, understanding, analyzing, responding and handling security threats from a global perspective on the basis of security big data. The concept of situational awareness was first proposed in the military field, covering three levels of awareness, understanding, and prediction. And is upgraded to "network situational Awareness (CSA)" with the rise of the network. The method aims to acquire, understand and display security elements which can cause network situation changes in a large-scale network environment, and perform sequential prediction of recent development trend so as to make decisions and actions.
Referring to fig. 1, a first embodiment of the present application provides a method for evaluating security posture of a power grid database, including:
When the method of the present application is implemented, first, situation awareness element information, including environment element information and production element information of a power grid database, is collected for a power grid database object that needs to be subjected to security situation assessment. According to the decision task and the target, a decision maker purposefully selects the environmental elements to obtain the attributes, characteristics and states of the elements so as to form a standard data table. A data layer of the visual perception model of the power grid database is defined from decision tasks and targets, the integrity of a data acquisition range can be guaranteed, and necessary environmental element data are prevented from being leaked.
And 102, carrying out data cleaning pretreatment and format conversion pretreatment on the situation perception element information.
In step 102, the information is preprocessed to remove bad data, so as to improve the accuracy of the subsequent steps.
And 103, extracting information of the preprocessed situation perception element information through a data association classification engine according to the association relation of the situation perception element information in the time dimension and the space dimension to obtain environment element statistical information and production element statistical information.
In step 103, based on the data preprocessed in step 102, the preprocessed situation awareness element information is extracted through a data association classification engine to obtain environment element statistical information and production element statistical information. The element statistical information comprises a space dimension attribute and a time dimension attribute, and the incidence relation of the situation awareness element information on the time dimension and the space dimension can be understood as that when the time dimension attribute and the space dimension attribute of the environment element statistical information and the production element statistical information are the same, that is, the environment element statistical information and the production element statistical information belong to the same node in the power grid database and are information generated under the same time node.
And 104, associating the environmental element information and the production element information with each node in the topology model corresponding to the power grid database based on the spatial dimensions of the environmental element statistical information and the production element statistical information.
In step 104, based on a preset topology model corresponding to the power grid database, the environment element statistical information and the production element statistical information are matched and associated with nodes in the topology model according to the spatial dimension attributes in the element statistical information.
And 105, calculating the safety situation index values of the nodes based on the time dimensions of the associated nodes, the environmental element statistical information and the production element statistical information, and obtaining a safety situation evaluation result of the power grid database based on the safety situation index values corresponding to the nodes.
Then, in step 105, based on the correspondence between the model node and the two types of element statistical information determined in step 104, the change situation and the association situation of the two types of element statistical information of the model node with time are determined according to the time dimension of the element statistical information, and the security situation index value of the node is calculated, so as to obtain the overall security situation evaluation result of the grid database according to the calculated security situation index value corresponding to each node in the grid database.
The embodiment of the application is based on a situation awareness technology, situation awareness element information of a power grid database is acquired and comprises environment element information and production element information, the preprocessed situation awareness element information is subjected to information extraction, the obtained element statistical information and a dynamic topological model of the power grid database are combined to calculate the safety situation index value of a node, and the safety situation index value is used as a sequential prediction index of the recent development trend of the power grid database to further perform decision and action.
The above is a detailed description of a first embodiment of a method for evaluating a security situation of a power grid database provided by the present application, and the following is a detailed description of a second embodiment of a method for evaluating a security situation of a power grid database provided by the present application.
Referring to fig. 2, based on the first embodiment, a second embodiment of the present application provides a method for evaluating a security situation of a power grid database, including:
In step 202, the information is preprocessed to remove bad data, so as to improve the accuracy of the subsequent steps.
More specifically, in the extraction process, a database language script is adopted to perform data verification and then clean error data, for example, zero data, error format data and repeated data are cleaned, the data is cleaned and stored in a temporary database for data format conversion, the cleaned data is put into the temporary database for format conversion according to a data structure required by situation awareness, and the content of the format conversion can include date format processing, decimal processing and row-column conversion.
And 203, extracting the information of the preprocessed situation perception element information through a data association classification engine according to the association relation of the situation perception element information in the time dimension and the space dimension to obtain the environment element statistical information and the production element statistical information.
And 204, associating the environmental element information and the production element information with each node in the topology model corresponding to the power grid database based on the spatial dimensions of the environmental element statistical information and the production element statistical information.
And step 205, calculating the safety situation index values of the nodes based on the time dimensions of the associated nodes, the environmental element statistical information and the production element statistical information, so as to obtain a safety situation evaluation result of the power grid database based on the safety situation index values corresponding to the nodes.
The evaluation result of the security situation of the power grid database specifically comprises the following steps: the probability of a health state, the probability of an alert state, the probability of a fault state, the probability of load flow safety, the probability of load flow overload and the probability of load flow overload shedding.
And step 206, displaying the safety situation evaluation result of the power grid database and the dynamic topology model of the power grid database in a combined manner through a graphic visualization tool.
The current safety risk situation is reflected visually through three indexes of the health state probability, the alert state probability and the fault state probability, and the safety risk development situation is reflected through three indexes of the tide safety probability, the tide overload probability and the tide overload load shedding probability.
The power grid database security situation assessment knowledge is visualized, and the environment understanding and predicting capability of decision makers can be improved.
Specifically, in order to enable the graphic elements to accurately reflect the actual running condition of the power grid, the IEC61580 standard is strictly followed in the process of designing the graphic elements; the visualization technology adopted in the step can comprise visualization of a color mapping table, a three-dimensional surface map, a dynamic topological tree and the like. The color mapping table expresses numerical values with different sizes by different colors, so that people can intuitively compare the relative sizes of the numerical values. Therefore, the color mapping table scheme responsible for mapping numerical values to colors becomes the key to visualizing functional color applications. The good color mapping scheme should meet the color variation range, has good numerical discrimination, accords with the visual habit of people, and is easy to understand and memorize. In the most commonly used color mapping table scheme, "temperature color", as the value increases, the color changes according to the trend of continuously changing dark blue, cyan, green, yellow, orange, red and dark red, the voltage of some physical quantity stations defined on points in the three-dimensional curved surface graph power system can be defined and expanded to the whole plane by using a spatial interpolation method, and then the definition is expressed in the form of a commonly used three-dimensional curved surface graph visualized by a two-dimensional scalar field, the display of the three-dimensional curved surface graph is similar to a topographic map in a geographic map, the higher areas of the curved surface have larger corresponding values, the lower areas of the curved surface have smaller values, the dynamic topology tree provides a means for the user to calculate and display the graph in real time and dynamically by using a designated bus as a root node, And a dynamic topological graph of the power grid database is quickly formed, so that a user can quickly and accurately master the operation condition of the current operation and maintenance power grid database. The dynamic topological tree picture supports two picture layout modes of a tree hierarchical mode and a radiation mesh mode. The dynamic topological tree image reflects the topological connection relation between the calculation buses and the calculation lines, and the operation condition of the power grid database is displayed in the dynamic topological tree in modes of topological coloring, power flow flowing and the like.
Under a basic situation awareness framework, the power grid database situation awareness provided by the embodiment includes three layers of a perception layer, an understanding layer and a prediction layer. The perception layer is responsible for perceiving various elements in the environment, including the state and the attribute of the environment, the dynamic change of the environment and the like. The understanding layer is used for understanding the power grid situation and building on the perception layer, measuring the importance degree of the environment elements on achieving the goal, and comprehensively understanding various elements. The prediction layer predicts the state of the database of the power grid, simulates the highest level of the state perception of the database of the prediction power grid, and predicts the next state and behavior of each element in the environment on the basis of the perception layer and the understanding layer. And driving situation perception in the interactive process according to interaction between perception targets and tasks and the visual view, wherein the environment element visualization is three-layer situation perception basic statistic comprehensive data visualization, and the visualization is an explanatory and supportive function for understanding the basic knowledge visualization of the power grid situation layer.
and step 208, based on the safety detection result, calculating the change sensitivity of the node which does not pass the safety detection result to obtain the situation change sensitivity.
More specifically, the interaction of database situation awareness with a visualization view specifically includes: the method comprises the steps of managing two parts of the state of a power grid database and the state of a forecast power grid database, understanding the state of the power grid, carrying out safety verification on the severity of environmental data and equipment and power grid load flow identification, carrying out sensitivity calculation on the influence degree of the equipment and the power grid load flow which do not pass the safety verification on a station bus, and determining a safety risk coping strategy and a safety margin adjusting strategy by using the state of the forecast power grid database as a basis for forecasting the safety state of the power grid database through a sensitivity calculation result.
The embodiment of the application is based on a situation awareness technology, situation awareness element information of a power grid database is acquired and comprises environment element information and production element information, the preprocessed situation awareness element information is subjected to information extraction, the obtained element statistical information and a dynamic topological model of the power grid database are combined to calculate the safety situation index value of a node, and the safety situation index value is used as a sequential prediction index of the recent development trend of the power grid database to further perform decision and action.
Meanwhile, the method can acquire and understand information of various elements in the environment and predict the future state of the environment in a certain space-time range based on the situation awareness technology, and solves the problems that the presentation form of the knowledge visualization of the power grid database is single, and the potential safety hazard exists in the operation of the power grid database due to the fact that workers are inconvenient to comprehensively and timely solve the meaning expressed by the knowledge visualization of the power grid database in the prior art.
The above is a detailed description of a second embodiment of the method for evaluating a security situation of a power grid database provided by the present application, and the following is a detailed description of a second embodiment of the device for evaluating a security situation of a power grid database provided by the present application.
A second embodiment of the present application provides a device for evaluating a security situation of a power grid database, including:
an element collecting unit 301, configured to collect situation awareness element information of a grid database, where the situation awareness element information includes: environmental element information and production element information;
the preprocessing unit 302 is used for performing data cleaning preprocessing and format conversion preprocessing on the situation awareness element information;
the extracting unit 303 is configured to perform information extraction on the preprocessed situational awareness element information according to an incidence relation of the situational awareness element information in a time dimension and a space dimension through a data association classification engine to obtain environment element statistical information and production element statistical information;
a topology association unit 304, configured to associate, based on the spatial dimensions of the environmental element statistical information and the production element statistical information, the environmental element information and the production element information with each node in a topology model corresponding to the power grid database;
and the safety situation evaluation unit 305 is configured to calculate a safety situation index value of the node based on the time dimension of the associated node, the environmental element statistical information, and the production element statistical information, so as to obtain a safety situation evaluation result of the power grid database based on the safety situation index value corresponding to each node.
More specifically, the safety situation index values specifically include: the probability of a health state, the probability of an alert state, the probability of a fault state, the probability of load flow safety, the probability of load flow overload and the probability of load flow overload shedding.
More specifically, the data cleansing preprocessing specifically includes: zero data washing, error data washing and repeated data washing;
the format conversion preprocessing specifically comprises: time format processing, decimal processing, and line-column conversion processing.
More specifically, the method further comprises the following steps:
and the visualization unit 306 is used for displaying the evaluation result of the security situation of the power grid database and the dynamic topology model of the power grid database in a combined manner through a graphic visualization tool.
More specifically, the method further comprises the following steps:
a safety detection unit 307, configured to perform safety detection on nodes that do not pass the evaluation result of the security posture of the power grid database based on the evaluation result of the security posture of the power grid database, so as to obtain a safety detection result;
and the sensitivity calculation unit 308 is configured to calculate, based on the result of the security detection, a situation change sensitivity by using a change sensitivity of a node that does not pass the result of the security detection.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described systems, apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the several embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The terms "first," "second," "third," "fourth," and the like in the description of the application and the above-described figures, if any, are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the application described herein are, for example, capable of operation in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
The above embodiments are only used for illustrating the technical solutions of the present application, and not for limiting the same; although the present application has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions in the embodiments of the present application.
Claims (10)
1. A method for evaluating the security situation of a power grid database is characterized by comprising the following steps:
acquiring situation perception element information of a power grid database, wherein the situation perception element information comprises: environmental element information and production element information;
carrying out data cleaning pretreatment and format conversion pretreatment on the situation perception element information;
performing information extraction on the preprocessed situation perception element information through a data association classification engine according to the association relation of the situation perception element information on the time dimension and the space dimension to obtain the environment element statistical information and the production element statistical information;
associating the environmental element information, the production element information and each node in a topology model corresponding to the power grid database based on the spatial dimensions of the environmental element statistical information and the production element statistical information;
and calculating the safety situation index values of the nodes based on the time dimensions of the associated nodes, the environment element statistical information and the production element statistical information, so as to obtain a safety situation evaluation result of the power grid database based on the safety situation index values corresponding to the nodes.
2. The method according to claim 1, wherein the safety situation index value specifically comprises: the probability of a health state, the probability of an alert state, the probability of a fault state, the probability of load flow safety, the probability of load flow overload and the probability of load flow overload shedding.
3. The method for evaluating the safety situation of the power grid database according to claim 1, wherein the data cleaning preprocessing specifically comprises: zero data washing, error data washing and repeated data washing;
the format conversion preprocessing specifically comprises: time format processing, decimal processing, and line-column conversion processing.
4. The method for evaluating the security posture of the electric network database according to claim 1, wherein the obtaining of the evaluation result of the security posture of the electric network database further comprises:
and combining and displaying the safety situation evaluation result of the power grid database and the dynamic topology model of the power grid database through a graphic visualization tool.
5. The method for evaluating the security posture of the electric network database according to claim 1, wherein the obtaining of the evaluation result of the security posture of the electric network database further comprises:
based on the evaluation result of the security situation of the power grid database, carrying out security detection on nodes which do not pass the evaluation result of the security situation of the power grid database so as to obtain a security detection result;
and calculating the change sensitivity by using the nodes which do not pass the safety detection result based on the safety detection result to obtain the situation change sensitivity.
6. An apparatus for evaluating a security situation of a grid database, comprising:
the element acquisition unit is used for acquiring situation perception element information of a power grid database, wherein the situation perception element information comprises: environmental element information and production element information;
the preprocessing unit is used for carrying out data cleaning preprocessing and format conversion preprocessing on the situation perception element information;
the extraction unit is used for extracting the information of the preprocessed situation perception element information through a data association classification engine according to the association relation of the situation perception element information on the time dimension and the space dimension to obtain the environment element statistical information and the production element statistical information;
the topology association unit is used for associating the environmental element information and the production element information with each node in a topology model corresponding to the power grid database based on the spatial dimensions of the environmental element statistical information and the production element statistical information;
and the safety situation evaluation unit is used for calculating the safety situation index values of the nodes based on the time dimensions of the associated nodes, the environment element statistical information and the production element statistical information so as to obtain the safety situation evaluation result of the power grid database based on the safety situation index values corresponding to the nodes.
7. The device according to claim 6, wherein the safety situation index value specifically comprises: the probability of a health state, the probability of an alert state, the probability of a fault state, the probability of load flow safety, the probability of load flow overload and the probability of load flow overload shedding.
8. The grid database security situation assessment device according to claim 6, wherein the data cleansing pre-processing specifically comprises: zero data washing, error data washing and repeated data washing;
the format conversion preprocessing specifically comprises: time format processing, decimal processing, and line-column conversion processing.
9. The grid database security posture assessment device according to claim 6, further comprising:
and the visualization unit is used for displaying the safety situation evaluation result of the power grid database and the dynamic topology model of the power grid database in a combined manner through a graphic visualization tool.
10. The grid database security posture assessment device according to claim 6, further comprising:
the safety detection unit is used for carrying out safety detection on nodes which do not pass the safety situation evaluation result of the electric network database based on the safety situation evaluation result of the electric network database so as to obtain a safety detection result;
and the sensitivity calculation unit is used for calculating the change sensitivity of the nodes which do not pass the safety detection result based on the safety detection result to obtain the situation change sensitivity.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010940964.XA CN112070400A (en) | 2020-09-09 | 2020-09-09 | Method and device for evaluating security situation of power grid database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010940964.XA CN112070400A (en) | 2020-09-09 | 2020-09-09 | Method and device for evaluating security situation of power grid database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112070400A true CN112070400A (en) | 2020-12-11 |
Family
ID=73662993
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010940964.XA Pending CN112070400A (en) | 2020-09-09 | 2020-09-09 | Method and device for evaluating security situation of power grid database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112070400A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113065798A (en) * | 2021-04-23 | 2021-07-02 | 湖北君鸿安全环保科技有限公司 | Safety production risk early warning method and system |
| CN113254674A (en) * | 2021-07-12 | 2021-08-13 | 深圳市永达电子信息股份有限公司 | Network security equipment knowledge inference method, device, system and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103679296A (en) * | 2013-12-24 | 2014-03-26 | 云南电力调度控制中心 | Grid security risk assessment method and model based on situation awareness |
| CN104680260A (en) * | 2015-03-17 | 2015-06-03 | 云南电力调度控制中心 | Method and system for establishing power grid visualized perceptual model |
| CN105631597A (en) * | 2015-12-31 | 2016-06-01 | 中国南方电网有限责任公司 | Construction method for transformer substation three-dimensional visual platform |
| CN108900541A (en) * | 2018-08-10 | 2018-11-27 | 哈尔滨工业大学（威海） | One kind being directed to cloud data center SDN Security Situation Awareness Systems and method |
-
2020
- 2020-09-09 CN CN202010940964.XA patent/CN112070400A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103679296A (en) * | 2013-12-24 | 2014-03-26 | 云南电力调度控制中心 | Grid security risk assessment method and model based on situation awareness |
| CN104680260A (en) * | 2015-03-17 | 2015-06-03 | 云南电力调度控制中心 | Method and system for establishing power grid visualized perceptual model |
| CN105631597A (en) * | 2015-12-31 | 2016-06-01 | 中国南方电网有限责任公司 | Construction method for transformer substation three-dimensional visual platform |
| CN108900541A (en) * | 2018-08-10 | 2018-11-27 | 哈尔滨工业大学（威海） | One kind being directed to cloud data center SDN Security Situation Awareness Systems and method |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113065798A (en) * | 2021-04-23 | 2021-07-02 | 湖北君鸿安全环保科技有限公司 | Safety production risk early warning method and system |
| CN113254674A (en) * | 2021-07-12 | 2021-08-13 | 深圳市永达电子信息股份有限公司 | Network security equipment knowledge inference method, device, system and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104680260B (en) | A kind of power grid visualization sensor model construction method and system | |
| US9158035B2 (en) | System and method of automated acquisition, correlation and display of power distribution grid operational parameters and weather events | |
| CN110097297A (en) | A kind of various dimensions stealing situation Intellisense method, system, equipment and medium | |
| CN112598343B (en) | Risk inspection method, device, equipment and storage medium for data center | |
| CN111178396A (en) | Method and device for identifying abnormal electricity consumption user | |
| US20240142063A1 (en) | Method for troubleshooting potential safety hazards of compressor in smart gas pipeline network and internet of things system thereof | |
| CN113902242A (en) | Comprehensive state evaluation method and system of power grid equipment based on digital twinning | |
| CN106570778A (en) | Big data-based data integration and line loss analysis and calculation method | |
| CN117196159A (en) | Intelligent water service partition metering system based on Internet big data analysis | |
| CN112070400A (en) | Method and device for evaluating security situation of power grid database | |
| CN116914917A (en) | Big data-based monitoring and management system for operation state of power distribution cabinet | |
| CN115358155A (en) | Power big data abnormity early warning method, device, equipment and readable storage medium | |
| CN117854013A (en) | Fire monitoring system and method for electrical equipment | |
| CN113205238A (en) | Situation awareness defense capacity assessment method for power plant industrial control system | |
| CN113902241A (en) | Power grid equipment maintenance strategy system and method based on comprehensive state evaluation | |
| CN113554360A (en) | Power transmission line running state visual management method and system and storage medium | |
| CN116955434A (en) | Full life cycle management and multidimensional energy efficiency analysis system for industrial equipment | |
| CN115766096A (en) | Network security protection system based on big data | |
| CN107121943A (en) | A kind of method and apparatus for being used to obtain the health forecast information of intelligence instrument | |
| CN114202179A (en) | Target enterprise identification method and device | |
| CN117639228A (en) | Power distribution network running state prediction method and system based on digital twin | |
| CN115146715A (en) | Power utilization potential safety hazard diagnosis method, device, equipment and storage medium | |
| CN117955245B (en) | Method and device for determining running state of power grid, storage medium and electronic equipment | |
| Olar et al. | The Design and Applications of Dashboards Used in Electrical and Power Systems | |
| Zheng et al. | Implementation of IOC and its application in distribution system operation and maintenance management |
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 | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20211118 Address after: No.757 Dongfeng East Road, Yuexiu District, Guangzhou City, Guangdong Province 510000 Applicant after: GUANGDONG POWER GRID Co.,Ltd. Address before: Room 509, 808 Dongfeng East Road, Yuexiu District, Guangzhou, Guangdong 510060 Applicant before: Guangdong Electric Power Information Technology Co.,Ltd. |