Convenient analysis and management method and system for assessment indexes of power distribution network

Abstract

The invention relates to the technical field of data processing, in particular to a convenient analysis and management method and system for assessment indexes of a power distribution network. Comprising the steps of constructing a data index storage standard, and performing data storage and extraction according to the data index storage standard; defining a target operation relational expression of the first-level index and the second-level index of the target through a graphical calculation tool, and calculating the first-level index of the target according to the target operation relational expression; constructing an index data filtering component according to the target operation relational expression, and extracting a second-level index corresponding to the target first-level index according to the index data filtering component to obtain target basic data; according to the target basic data, performing standardized extraction and charting display on the target first-level indexes and the corresponding second-level indexes; and monitoring the target first-level index and the target basic data, and giving an alarm when an abnormality is found. The analysis efficiency and accuracy are improved through standardized storage, graphical definition of the operation relation, data filtering, standardized extraction and display and abnormity monitoring and alarming.

Description

Technical Field

[0001] The present invention relates to the technical field of data processing, and in particular to a method and system for convenient analysis and management of distribution network assessment indicators. Background Art

[0002] With the accelerated advancement of smart grid construction, the digital level of distribution networks has been significantly improved. However, this process is also accompanied by new challenges. There are many professional systems in the field of distribution networks, the assessment index system is complex and changeable, and the relationship between the systems is intricate, which brings great difficulty to the management of assessment indicators. Each assessment indicator needs to be further refined into secondary indicators and summarized into primary indicators through specific calculation formulas. This multi-level structure requires the management system to have a high degree of flexibility and adaptability.

[0003] At present, a key issue that distribution network companies generally face is how to effectively use digital means to achieve convenient analysis and management of assessment indicators to improve operational efficiency and management level. Although existing technologies have solved the problem of unified caliber specifications and standard processes for basic data across business systems to a certain extent, established a unified data indicator management center, and realized the automatic extraction and aggregation of basic data through SQL specifications, there are still significant deficiencies in handling the management of assessment indicator settlement.

[0004] Specifically, existing technologies mainly focus on the unified processing of basic data, but are unable to cope with the calculation and management of assessment indicators. The calculation of each assessment indicator requires a separate calculation program, and there is a lack of a unified and reusable solution. In addition, with the continuous changes in business needs, assessment indicators and their calculation formulas often need to be adjusted frequently, which requires the system to respond quickly to these changes, and existing technologies usually need to be achieved through reprogramming, which greatly increases maintenance costs and time costs. More importantly, existing technologies often only focus on the changing trends and over-limit analysis of primary indicators, ignoring the specific impact of secondary indicators on primary indicators. In actual operations, when primary indicators are abnormal, manual intervention is often required to locate specific secondary indicator problems through cumbersome deduction and calculation processes, which is not only inefficient, but also prone to errors, and it is difficult to meet the needs of quickly locating problems and accurately implementing policies. Summary of the invention

[0005] The purpose of the present invention is to provide a convenient analysis and management method and system for distribution network assessment indicators in order to solve at least one of the above technical problems. The present invention aims to achieve instant response and adjustment of the assessment indicator calculation method, allowing business departments to flexibly submit new calculation formulas and immediately obtain accurate settlement results; with the help of advanced digital and intelligent means, the present invention can automatically analyze the deep relationship between secondary indicators and primary indicators, quickly lock the specific secondary indicators behind the primary indicators that cause problems, and achieve advance warning and precise positioning of problems. The present invention not only ensures the dynamic adaptability of assessment indicators in complex and changing business environments, but also greatly enhances the ability to trace problems, providing strong support for distribution companies, helping them to achieve rapid analysis, precise policy implementation and efficient management of assessment indicators.

[0006] The present invention provides a convenient analysis and management method for distribution network assessment indicators, comprising the following steps:

[0007] Construct data index storage standards, and store and extract data according to the data index storage standards;

[0008] Define the target operation relationship between the target primary indicator and the secondary indicator through a graphical calculation tool, and calculate the target primary indicator according to the target operation relationship;

[0009] Constructing an indicator data filtering component according to the target operation relational expression, and extracting the secondary indicator corresponding to the target primary indicator according to the indicator data filtering component to obtain target basic data;

[0010] Based on the target basic data, the target primary indicators and their corresponding secondary indicators are extracted and displayed in a standardized manner and in a graphical form;

[0011] Monitor the target primary indicators and the target basic data, and issue an alarm when an abnormality is found.

[0012] Further, the data indicator storage standard includes: an indicator definition table, an indicator dictionary table and an indicator storage table;

[0013] The indicator definition table includes the following standard attribute fields: indicator parameter, indicator name, parent node, indicator unit;

[0014] The indicator dictionary table includes the following standard attribute fields: dictionary code, dictionary name, dictionary type; wherein the standard attribute fields of the dictionary type include indicator frequency, data source and data type;

[0015] The indicator storage table includes the following standard attribute fields for data: indicator code, indicator value, indicator unit, indicator frequency, data source, data type, and indicator time.

[0016] Furthermore, the graphical calculation tool is a set of graphical drag-and-drop calculation formula assembly tools, which includes various secondary indicator names and operators. At least part of the secondary indicator names and operators are combined by dragging as needed to obtain the target operation relationship.

[0017] Further, calculating the target primary index according to the target operation relational expression specifically includes:

[0018] According to the target operation relational expression, a selected calculation period and calculation frequency are obtained, and according to the selected calculation period and calculation frequency, a data extraction time point is obtained to form a target indicator time series;

[0019] Splitting the target operation relational expression according to the operator of the target operation relational expression to obtain an indicator element point sequence composed of indicator element point information;

[0020] Obtain the indicator value of the target indicator time series according to each indicator element point information, and generate the indicator value information corresponding to each indicator element point at each time point;

[0021] Calculate the primary indicator value corresponding to each time point according to the indicator value information;

[0022] The target first-level indicator corresponding to the target indicator time series is generated based on the first-level indicator values ​​corresponding to each time point.

[0023] Furthermore, the target operation relational expression includes an indicator code, an indicator frequency, and a data type;

[0024] The indicator element point information includes indicator code, indicator frequency, and data type.

[0025] Furthermore, the indicator data filtering component includes the following functions: indicator frequency filtering, data type filtering, indicator name filtering, and time range filtering.

[0026] Furthermore, the standardized extraction includes: extracting the target basic data using a unified interface, and presenting the target basic data in a two-dimensional table;

[0027] The graphical presentation includes displaying the target basic data using at least one of the following tools: a bar chart, a line chart, a pie chart;

[0028] At least one of the following information of the image is set based on the target basic data: title, data sequence, x-axis, y-axis.

[0029] Further, monitoring the target primary indicator and the target basic data, and issuing an alarm when an abnormality is found, including: obtaining the correlation between each secondary indicator and the target primary indicator according to the target operation relationship; listing the positively correlated secondary indicators in the positive indicator list, and listing the negatively correlated secondary indicators in the negative indicator list;

[0030] Conduct trend analysis and anomaly analysis on the secondary indicators in the positive indicator list and the negative indicator list, and include abnormal data in the abnormal indicator list;

[0031] Determine whether the target data in the abnormal indicator list meets the warning triggering conditions. If so, issue an alarm for the target data.

[0032] Furthermore, the warning triggering condition is: the change trend of the target data exceeds the set condition, or the change value of the target data exceeds the control line;

[0033] The setting conditions and the control line can be set according to actual needs.

[0034] The present invention also provides a convenient analysis and management system for distribution network assessment indicators, including:

[0035] A storage and extraction module is used to construct a data index storage standard and perform data storage and extraction according to the data index storage standard;

[0036] A calculation module, used to define a target operation relationship between a target primary indicator and a secondary indicator through a graphical calculation tool, and calculate the target primary indicator according to the target operation relationship;

[0037] A data screening module, used to construct an indicator data filtering component according to the target operation relational expression, and extract the secondary indicator corresponding to the target primary indicator according to the indicator data filtering component to obtain the target basic data;

[0038] A data display module, for performing standardized extraction and graphical display of the target primary indicators and their corresponding secondary indicators based on the target basic data;

[0039] The monitoring and alarm module is used to monitor the target primary indicators and the target basic data, and to issue an alarm when an abnormality is found.

[0040] The beneficial effects of the present invention are:

[0041] Data standardization and unified management: The present invention realizes the unified storage and efficient management of various assessment indicators by defining a comprehensive set of data standards. It not only ensures the consistency of data writing and extraction methods, but also simplifies the data operation process, so that a variety of indicator parameter data can be managed through a unified interface, greatly improving the convenience and efficiency of data management.

[0042] Flexibility and dynamism of calculation formulas: The present invention adopts string-style management of calculation formulas to achieve maintainability and convenient updating of calculation formulas; this management method allows users to adjust the calculation formulas at any time according to business needs, and the system can automatically interpret them into executable calculation programs, and automatically retrieve corresponding secondary indicator parameters for calculation based on rules, thereby quickly obtaining primary indicator parameter results, providing a solid foundation for subsequent storage, management and analysis applications.

[0043] Automated correlation analysis and precise positioning: The present invention introduces automated correlation analysis technology, which breaks through the limitations of traditional primary indicator analysis and extends the depth of analysis to the secondary indicator level. By real-time monitoring of the dynamic relationship between secondary indicators and primary indicators, the system can automatically identify and warn of changes in secondary indicators that may cause the deterioration of primary indicators, thereby achieving advanced discovery and precise positioning of problems. This not only helps companies take timely measures to intervene, but also effectively reduces losses caused by delayed problem discovery.

[0044] Visual presentation and intuitive understanding: By presenting the changing trends of various indicators in a visual way, the present invention makes complex data analysis results intuitive and easy to understand. Both management and front-line operators can quickly grasp the changes in indicators, providing strong data support for decision-making.

[0045] Traceability and early warning mechanism: The present invention has established a complete traceability system, so that any abnormal change of the primary indicator can be quickly traced back to the specific secondary indicator, providing a clear path for tracing the root cause of the problem. At the same time, combined with the early warning mechanism, the system can issue an early warning in advance when the trend of the secondary indicator changes indicates that the primary indicator may deteriorate, helping enterprises to take timely measures to prevent it before it happens. BRIEF DESCRIPTION OF THE DRAWINGS

[0046] Figure 1 A working principle diagram of a distribution network assessment index analysis and management method in the prior art;

[0047] Figure 2 A flow chart of a convenient analysis and management method for distribution network assessment indicators according to an embodiment of the present invention;

[0048] Figure 3A working principle diagram of a convenient analysis and management method for distribution network assessment indicators according to an embodiment of the present invention;

[0049] Figure 4 A schematic diagram of a data index storage standard for an implementation of the present invention Figure 1 ;

[0050] Figure 5 A schematic diagram of a data index storage standard for an implementation of the present invention Figure 2 ;

[0051] Figure 6 A schematic diagram of a data index storage standard for an implementation of the present invention Figure 3 ;

[0052] Figure 7 A graphical computing work schematic diagram of an embodiment of the present invention;

[0053] Figure 8 Schematic diagram of standardized extraction and graphical display of an embodiment of the present invention Figure 1 ;

[0054] Fig. 9 Schematic diagram of standardized extraction and graphical display of an embodiment of the present invention Figure 2 ;

[0055] Fig.10 A schematic diagram of correlation analysis between each secondary indicator and the target primary indicator in one embodiment of the present invention;

[0056] Fig.11 A schematic diagram of a convenient analysis and management system for distribution network assessment indicators according to an embodiment of the present invention. DETAILED DESCRIPTION

[0057] The content of the present invention will now be discussed with reference to exemplary embodiments. It should be understood that the embodiments discussed are only to enable those skilled in the art to better understand and thus implement the content of the present invention, rather than implying any limitation on the scope of the present invention.

[0058] As used herein, the term “including” and variations thereof are to be interpreted as open-ended terms meaning “including, but not limited to.” The term “based on” is to be interpreted as “based, at least in part, on.” The terms “one embodiment” and “an embodiment” are to be interpreted as “at least one embodiment.”

[0059] Embodiment 1

[0060] Figure 1 A working principle diagram of a distribution network assessment index analysis and management method in the prior art; Figure 2A flow chart of a convenient analysis and management method for distribution network assessment indicators according to an embodiment of the present invention; Figure 3 The working principle diagram of the convenient analysis and management method of distribution network assessment indicators according to one embodiment of the present invention. Figure 2-3 As shown, according to an embodiment of the present invention, a convenient analysis and management method for distribution network assessment indicators includes the following steps:

[0061] Step S102, constructing a data index storage standard, and performing data storage and extraction according to the data index storage standard;

[0062] Step S104, defining a target operation relationship between the target primary indicator and the secondary indicator through a graphical calculation tool, and calculating the target primary indicator according to the target operation relationship;

[0063] Step S106, constructing an indicator data filtering component according to the target operation relational expression, and extracting the secondary indicator corresponding to the target primary indicator according to the indicator data filtering component to obtain the target basic data;

[0064] Step S108, based on the target basic data, the target primary indicators and their corresponding secondary indicators are extracted in a standardized manner and displayed in a graphical form;

[0065] Step S110, monitor the target primary indicators and target basic data, and issue an alarm when an abnormality is found.

[0066] In this embodiment, the implementation process of the convenient analysis and management method for distribution network assessment indicators begins with the construction of a unified data indicator storage standard, which ensures that all relevant assessment indicator data can be stored in a predetermined format and structure, which is convenient for subsequent data extraction and analysis. Subsequently, using graphical calculation tools, users can intuitively define the operation relationship between the primary indicator and the secondary indicator. This step simplifies the complex mathematical operation process, allowing users with non-technical backgrounds to easily participate in indicator setting. Based on these operation relationships, the system automatically builds an indicator data filtering component, which can accurately filter out the secondary indicator data directly related to the target primary indicator from massive data, that is, the target basic data. Next, the system standardizes the extracted target basic data to ensure the consistency and comparability of the data, and displays the details of the primary indicator and its secondary indicator in a graphical manner, making the analysis results more intuitive and easy to understand. Finally, the system continuously monitors the changes in the target primary indicator and the target basic data. Once abnormal data or indicators deviate from the preset range, the alarm mechanism is immediately triggered so that timely measures can be taken to solve the problem.

[0067] The present invention significantly improves the analysis and management efficiency and accuracy of distribution network assessment indicators by building a standardized data storage and extraction mechanism, graphically defining operation relationships, automatic data filtering and standardized processing, and real-time abnormal monitoring and alarm functions. The present invention not only simplifies the complex analysis process and reduces the dependence on technical personnel, but also helps managers quickly understand the operating status of the distribution network through intuitive chart display and timely abnormal alarms, and promptly discover and solve potential problems, thereby ensuring the safe and stable operation of the distribution network and improving the overall operating efficiency and service quality.

[0068] Figure 4 A schematic diagram of a data index storage standard for an implementation of the present invention Figure 1 ; Figure 5 A schematic diagram of a data index storage standard for an implementation of the present invention Figure 2 ; Figure 6 A schematic diagram of a data index storage standard for an implementation of the present invention Figure 3 .like Figure 4-6 As shown, according to one embodiment of the present invention, the data indicator storage standard includes: an indicator definition table, an indicator dictionary table and an indicator storage table;

[0069] The indicator definition table includes the following standard attribute fields for data: indicator parameter, indicator name, parent node, indicator unit;

[0070] The indicator dictionary table includes the following standard attribute fields: dictionary code, dictionary name, and dictionary type; among which, the standard attribute fields of the dictionary type include indicator frequency, data source, and data type;

[0071] The indicator storage table includes the following standard attribute fields for data: indicator code, indicator value, indicator unit, indicator frequency, data source, data type, and indicator time.

[0072] In this implementation, by constructing a data indicator storage standard including an indicator definition table, an indicator dictionary table and an indicator storage table, unified definition, classification and storage management of data indicators are achieved, providing consistent data caliber and standardized processes between different business systems.

[0073] The present invention realizes the unified management of data indicators across business systems and improves the consistency and shareability of data.

[0074] Figure 7 FIG. 1 is a diagram of a graphical computing operation of an embodiment of the present invention. Figure 3 and Figure 7As shown, according to one embodiment of the present invention, the graphical calculation tool is a set of graphical drag-and-drop calculation formula assembly tools. The graphical calculation tool includes various secondary indicator names and operators. At least part of the secondary indicator names and operators are combined by dragging as needed to obtain the target operation relationship.

[0075] Designing a set of graphical drag-and-drop calculation formula assembly tools can effectively avoid the need for complex programming for each primary indicator, and data calculation can be efficiently calculated by simply dragging. The calculation formula assembly tool can drag and drop materials including the names of each secondary indicator and operators (including +, -, ×, ÷, brackets), and the assembly area accepts any order combination.

[0076] The assembly process automatically fills in the extraction rules of the corresponding indicators connected by “_”, including indicator code, data frequency, and data type, such as “param001_frequence001_datatype_001”.

[0077] After the formula verification is completed, save the calculation formula of the first-level indicator, such as:

[0078] "First level index name 1 = (param001_frequency001_datatype_001-

[0079] param002_frequence002_datatype_002)

[0080] / param003_frequence003_datatype_003".

[0081] Preferably, the target primary index is calculated according to the target operation relation, specifically including:

[0082] Step 1: Obtain the selected calculation period and calculation frequency according to the target operation relation, obtain the data extraction time point according to the selected calculation period and calculation frequency and form the target indicator time series;

[0083] The target operation relation includes indicator coding, indicator frequency, and data type;

[0084] Step 2, splitting the target operation relational expression according to the operator of the target operation relational expression to obtain an indicator element point sequence composed of indicator element point information;

[0085] The indicator element point information includes indicator code, indicator frequency, and data type.

[0086] Step 3: Obtain the indicator value of the target indicator time series according to each indicator element point information, and generate the indicator value information corresponding to each indicator element point at each time point;

[0087] Step 4: Calculate the first-level indicator value corresponding to each time point according to the indicator value information;

[0088] Step 5: Generate the target first-level indicator corresponding to the target indicator time series based on the first-level indicator values ​​corresponding to each time point.

[0089] In this implementation, the first step of the translation program is to obtain the calculation period selected by the operator, including the start time (starttime) and the end time (endtime), and then obtain all the data extraction time points according to the calculation frequency of the indicator (such as daily, monthly, and annual), to form an indicator time series. The second step is to split the calculation formula according to calculation connectors such as addition, subtraction, multiplication, and division to form a sequence of indicator element points. Each indicator element point contains information such as indicator code, indicator frequency, and data type; the third step is to convert the indicator values ​​under a series of indicator time series according to the information of each indicator element point to form the indicator value information corresponding to a certain indicator element point at a certain time. The fourth step is to complete the conversion of the formula at different time points, that is, by

[0090] "First level index name 1 = (param001_frequency001_datatype_001-

[0091] param002_frequence002_datatype_002)

[0092] / param003_frequence003_datatype_003”

[0093] Converted to "first-level indicator name 1 = (value 1 - value 2) / value 3", a specific example is "first-level indicator name 1 = (2.8-1.3) / 1.6".

[0094] In the fifth step, the system applies the commonly used eval function to convert the string formula into an executable algorithm formula, automatically calculates the first-level indicator value of each time node based on the basic data, and forms a series of first-level indicator calculation values ​​under time series.

[0095] This embodiment proposes an innovative graphical drag-and-drop calculation formula assembly tool, which aims to simplify the programming requirements in the complex data calculation process and improve the calculation efficiency and flexibility. Through an intuitive user interface, the tool allows users to freely combine secondary indicator names and operators (such as addition, subtraction, multiplication, division, brackets, etc.) by dragging and dropping, so as to quickly build the required target operation relation. During the assembly process, the system automatically fills in the extraction rules for each indicator element point, expressed in a standardized format (such as "param001_frequence001_datatype_001"), to ensure the consistency and accuracy of the data. After completing the formula assembly, the system further supports the verification and saving of the formula to facilitate subsequent calculation applications. In the actual calculation process, the system first determines the time point of data extraction according to the calculation cycle and frequency selected by the user to form a target indicator time series. Subsequently, the system obtains the indicator element point sequence by segmenting the target operation relation, and queries the indicator values ​​at each time point one by one. Finally, the system uses the eval function to convert the string formula into an executable algorithm, automatically calculates the primary indicator values ​​at each time point, and generates a complete target indicator time series data. This process greatly simplifies the complexity of data calculation and improves the degree of automation of data processing.

[0096] The present invention simplifies and improves the data calculation process through a graphical drag-and-drop calculation formula assembly tool; users can quickly build calculation formulas through an intuitive operation interface without having to have complex programming knowledge, which lowers the technical threshold and improves work efficiency; the system's automated data processing and calculation functions ensure the accuracy and consistency of the data, providing strong support for data analysis and decision-making across business systems.

[0097] According to one embodiment of the present invention, the indicator data filtering component includes the following functions: indicator frequency filtering, data type filtering, indicator name filtering, and time range filtering.

[0098] Figure 8 Schematic diagram of standardized extraction and graphical display of an embodiment of the present invention Figure 1 ; Fig. 9 Schematic diagram of standardized extraction and graphical display of an embodiment of the present invention Figure 2 Preferably, if Figure 8-9 As shown, the standardized extraction includes: extracting the target basic data using a unified interface and presenting the target basic data in a two-dimensional table;

[0099] Graphical presentation includes displaying the target basic data using at least one of the following tools: bar graph, line graph, pie chart;

[0100] At least one of the following information of the image is set based on the target basic data: title, data series, x-axis, y-axis.

[0101] This implementation method provides a comprehensive data processing and display process, covering the entire process from data filtering to graphical display. Specifically, through the integrated indicator data filtering component, users can flexibly filter out the required target basic data based on conditions such as indicator frequency, data type, indicator name, and time range. This process ensures the accuracy and pertinence of the data. Subsequently, a unified interface is used to extract the filtered data and intuitively present it in the form of a two-dimensional table, which is convenient for users to quickly browse and understand the data. In order to further improve the readability and analyzability of the data, this technical solution also introduces a graphical display function, which supports the use of a variety of graphical tools such as bar charts, line charts, pie charts, etc. to convert tabular data into visual charts. During the graphical display process, users can customize the chart title, data series, x-axis, y-axis and other key information to meet the display needs in different scenarios.

[0102] The present invention achieves high efficiency and flexibility in data processing through integrated data filtering, standardized extraction and graphical display functions; users can easily filter out target data that meets specific conditions and display them through intuitive two-dimensional tables and graphical charts, greatly improving the efficiency and accuracy of data analysis and decision-making; unified interface design and standardized data extraction process also provide a solid foundation for subsequent data processing and application.

[0103] Fig.10 Schematic diagram of correlation analysis between each secondary index and the target primary index in one embodiment of the present invention. Fig.10 As shown, according to an embodiment of the present invention, step S110 includes: obtaining the correlation between each secondary indicator and the target primary indicator according to the target operation relationship; listing the positively correlated secondary indicators in the positive indicator list, and listing the negatively correlated secondary indicators in the negative indicator list;

[0104] Conduct trend analysis and anomaly analysis on the secondary indicators in the positive indicator list and negative indicator list, and include abnormal data in the abnormal indicator list;

[0105] Determine whether the target data in the abnormal indicator list meets the warning trigger conditions. If so, issue an alarm for the target data.

[0106] Preferably, the early warning triggering condition is: the change trend of the target data exceeds the set condition, or the change value of the target data exceeds the control line;

[0107] Setting conditions and control lines can be set according to actual needs.

[0108] In this implementation, first, according to the predefined target operation relationship, the correlation between each secondary indicator and the target primary indicator is deeply analyzed to clarify which secondary indicators are positively correlated with the target indicator (that is, when these secondary indicators rise, the target primary indicator also rises accordingly) and which are negatively correlated (that is, when these secondary indicators rise, the target primary indicator falls instead). Subsequently, these positively correlated indicators are classified into the positive indicator list, and the negatively correlated indicators are classified into the negative indicator list for subsequent differentiated management and analysis. Next, each secondary indicator in the positive indicator list and the negative indicator list is subjected to detailed trend analysis and abnormal analysis. By monitoring the changes in these indicators, abnormal data, such as sudden large fluctuations or values ​​that deviate from the normal range for a long time, are promptly discovered and identified, and these abnormal data are included in the abnormal indicator list. This process helps to accurately locate the potential source of the problem and provide strong support for subsequent problem solving. Finally, the system will evaluate the target data in the abnormal indicator list in real time to determine whether it meets the preset warning trigger conditions. These conditions usually include whether the change trend of the target data exceeds the set threshold range, or whether the change value of the target data exceeds the predetermined control line. If any warning condition is met, the system will immediately trigger the alarm mechanism and send an alarm to relevant personnel, reminding them to pay attention to and deal with possible abnormal situations, thereby effectively preventing the deterioration trend of assessment indicators and ensuring the stable operation and efficient management of the distribution network.

[0109] The present invention provides strong technical support for the convenient analysis and management of distribution network assessment indicators through refined correlation analysis, trend and anomaly monitoring, and intelligent early warning mechanism.

[0110] The present invention significantly improves the management efficiency and accuracy of distribution network assessment indicators through the comprehensive means of digitization, standardization, visualization and early warning. The present invention not only simplifies the data storage, extraction and analysis process, but also helps users quickly grasp the changes in assessment indicators through flexible indicator calculation formulas and visual data display. At the same time, the present invention realizes the timely discovery and effective response to potential problems through the tracking and tracing and early warning mechanism of the secondary indicators of the problem, thereby effectively avoiding the risk of deterioration of assessment indicators. This technical solution provides strong support for the refined management of the distribution network, and helps to improve the overall operational efficiency and safety and stability.

[0111] Embodiment 2

[0112] According to an embodiment of the present invention, a distribution network assessment index analysis and management method includes the following steps:

[0113] Step S202, storing and outputting the distribution network assessment indicators according to the storage and output rules; specifically,

[0114] Standardized storage and output of assessment indicators: Define a set of data indicator storage standards, including indicator definition table, indicator dictionary table and indicator storage table.

[0115] The indicator definition table mainly includes standard attribute fields such as indicator parameters, indicator name, parent node, indicator unit, etc.

[0116] The indicator dictionary table contains standard attribute fields such as dictionary code, dictionary name, and dictionary type. The dictionary type includes indicator frequency, data source, and data type.

[0117] The indicator storage table contains standard attribute fields such as indicator code, indicator value, indicator unit, indicator frequency (annual, monthly, daily, etc.), data source (specific information system), data type (current value, cumulative value, year-on-year value, etc.), and indicator time.

[0118] Through the design of data index storage standards, a scalable general index data storage method is implemented. All index data are stored in a unified table, simplifying the storage and extraction process. A set of standard data storage and extraction interfaces are designed to ensure that all data can be managed in a standardized manner based on the same interface. After designing according to this method, you only need to update the index parameter table and dictionary table to expand and manage new index data without restrictions.

[0119] Step S204: Standardize and extract the basic indicator data and display them in charts according to the display rules; specifically,

[0120] Standardized extraction of basic indicator data and graphical display:

[0121] Defines common standard indicator data filtering components, including indicator frequency, data type, indicator name filtering, time range filtering and other functions.

[0122] Under the unified indicator frequency and data type, the specific indicator data of any multiple indicators at each time point can be screened out. On the one hand, the standard indicator data filtering component can be used to extract the basic data of the target indicator for two-dimensional tabular presentation. On the other hand, the standard data extraction interface is designed to facilitate the software program to read the data of multiple indicator parameters and multiple time nodes of a certain indicator frequency and data type.

[0123] Graphical display, with the help of common graphical tools such as bar charts, line charts, pie charts, etc., to achieve graphical presentation of table data. The specific implementation method is to set the basic information such as the title, data sequence, x-axis, y-axis, etc. of the graph based on the table data.

[0124] Step S206, using a graphical calculation tool to define a target operation relationship between the primary index and the secondary index, and calculating the target primary index according to the target operation relationship;

[0125] Intelligent extraction, calculation, display and analysis of primary indicator data: One primary indicator needs to be calculated through addition, subtraction, multiplication and division operations of multiple secondary indicators.

[0126] Designing a set of graphical drag-and-drop calculation formula assembly tools can effectively avoid the need for complex programming for each primary indicator, and data calculation can be efficiently calculated by simply dragging. The calculation formula assembly tool can drag and drop materials including the names of each secondary indicator and operators (including +, -, ×, ÷, brackets), and the assembly area accepts any order combination.

[0127] The assembly process automatically fills in the extraction rules of the corresponding indicators connected by “_”, including indicator code, data frequency, and data type, such as “param001_frequence001_datatype_001”.

[0128] After the formula verification is completed, save the calculation formula of the first-level indicator, such as

[0129] "First level index name 1 = (param001_frequency001_datatype_001-

[0130] param002_frequence002_datatype_002)

[0131] / param003_frequence003_datatype_003".

[0132] The first step of the translation program is to obtain the calculation period selected by the operator, including the start time (starttime) and the end time (endtime), and then obtain all the data extraction time points according to the calculation frequency of the indicator (such as daily, monthly, and annual) to form an indicator time series.

[0133] The second step is to split the calculation formula according to calculation connectors such as addition, subtraction, multiplication and division to form a sequence of indicator element points. Each indicator element point contains information such as indicator code, indicator frequency, and value type.

[0134] The third step is to convert the indicator value information of each indicator element point into a series of indicator time series to form the indicator value information corresponding to a certain indicator element point at a certain time.

[0135] The fourth step is to complete the transformation of the formula at different time points, that is,

[0136] "First level index name 1 = (param001_frequency001_datatype_001-

[0137] param002_frequence002_datatype_002)

[0138] / param003_frequence003_datatype_003”

[0139] Converted to "first-level indicator name 1 = (value 1 - value 2) / value 3", a specific example is "first-level indicator name 1 = (2.8-1.3) / 1.6".

[0140] In the fifth step, the system applies the commonly used eval function to convert the string formula into an executable algorithm formula, automatically calculates the first-level indicator value of each time node based on the basic data, and forms a series of first-level indicator calculation values ​​under time series.

[0141] Step S208, analyzing the correlation between the target primary index and the secondary index according to the target operation relational expression; specifically,

[0142] Correlation analysis between secondary indicators and primary indicators: Based on the calculation formula of the primary indicators formed above, the system automatically adjusts and reduces the relevant secondary indicators, tries to calculate the impact of the adjustment and reduction of secondary indicators on the primary indicators, and draws a positive or negative correlation conclusion. The positively correlated secondary indicators are included in the list of positive indicators, and the negatively correlated secondary indicators are included in the list of negative indicators.

[0143] Step S210, based on the correlation between the target primary indicator and the secondary indicator, the problem secondary indicator is tracked and traced; specifically,

[0144] Tracking and tracing of secondary indicators of problems: Carry out trend analysis and abnormal analysis for each secondary indicator. For the positive indicator list, focus on tracking the decline of indicators, and for the negative indicator list, focus on tracking the increase of indicators. When anomalies are found, they are included in the abnormal indicator list to achieve accurate positioning of abnormal indicators. Early warning is carried out for abnormal trend changes, and alarm is issued when the change value exceeds the control line.

[0145] The present invention forms a method for convenient analysis and management of distribution network assessment indicators through a combination of the above steps and methods, which can expand the control of arbitrary assessment indicators, quickly locate and analyze abnormal points in basic data, perform precise positioning and precise policy implementation, and ensure that assessment indicators are under real-time control.

[0146] Apply the above method to build a digital system to realize digital control of assessment indicators. It can effectively avoid the problems of large amount of calculation and easy errors in manual statistical calculation, and a set of methods can be applied to any assessment indicator control. It can not only calculate the first-level assessment indicators accurately, but also track the change trend of the first-level assessment indicators, and locate the problematic second-level indicators. The control frequency of manual calculation control is at least one time per month, and the control frequency of this method is real-time. This method has extremely high application value and effectively improves the control efficiency and work quality of distribution network assessment indicators.

[0147] Embodiment 3

[0148] Fig.11 Schematic diagram of a convenient analysis and management system for distribution network assessment indicators according to an embodiment of the present invention. Fig.11 As shown, according to one embodiment of the present invention, a convenient analysis and management system for distribution network assessment indicators includes:

[0149] The storage and extraction module 10 is used to construct a data index storage standard and store and extract data according to the data index storage standard;

[0150] A calculation module 20, used to define a target operation relationship between the target primary indicator and the secondary indicator through a graphical calculation tool, and calculate the target primary indicator according to the target operation relationship;

[0151] The data screening module 30 is used to construct an indicator data filtering component according to the target operation relational expression, and extract the secondary indicators corresponding to the target primary indicators according to the indicator data filtering component to obtain the target basic data;

[0152] The data display module 40 is used to perform standardized extraction and graphical display of the target primary indicators and their corresponding secondary indicators based on the target basic data;

[0153] The monitoring and alarm module 50 is used to monitor the target primary indicators and target basic data, and to generate an alarm when an abnormality is found.

[0154] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working process of the system described above can refer to the corresponding process in the aforementioned method embodiment, and will not be repeated here.

[0155] The present invention can be compatible with the management of any indicator data by constructing a set of indicator data management standards; the calculation formula of the indicator data no longer relies on a specific algorithm implementation, and only needs to input a string-like calculation formula to complete the automatic recognition, translation and calculation of the program; the problem tracing of abnormal indicator data no longer relies on manual analysis, and abnormal secondary indicators can be automatically tracked based on the designed rules.

[0156] The present invention can support unified storage management of various types of data, unified writing methods, and unified extraction methods through the unification of data standards, support rule-based data reading and writing operations, and unify one interface to manage countless types of indicator parameter data.

[0157] The present invention automatically interprets the calculation formula into an executable calculation program through string management, automatically retrieves the secondary indicator parameters based on the rules, executes the interpreted calculation program, obtains the primary indicator parameter results, and performs storage management analysis and application.

[0158] The present invention supports the correlation analysis of any secondary indicator and primary indicator by applying automated correlation analysis technology, extends the tracking management of indicator data from simple primary indicator analysis to tracking analysis of secondary indicators, and can automatically identify secondary indicators that cause the deterioration of primary indicators.

[0159] The present invention realizes the standardized storage, extraction and quick extraction and analysis of distribution network assessment indicators through digital means. By defining a set of standards, it is possible to maintain more basic indicator data in an extensible manner, update the calculation formulas of each indicator in a maintainable and convenient manner, visualize the change trend of each indicator, trace the secondary indicators with problems, and warn which secondary indicators' change trends will lead to the deterioration of assessment indicators.

[0160] The above description is only a preferred embodiment of the present application and an explanation of the technical principles used. Those skilled in the art should understand that the scope of the invention involved in the present application is not limited to the technical solution formed by a specific combination of the above technical features, but should also cover other technical solutions formed by any combination of the above technical features or their equivalent features without departing from the inventive concept. For example, the above features are replaced with (but not limited to) technical features with similar functions disclosed in the present application.

[0161] It should be understood that the size of the serial numbers of each step in the content of the invention and the embodiments of the present invention does not absolutely mean the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of the present invention.

Claims

1. A convenient analysis and management method for distribution network assessment indicators, characterized in that: The steps include: Construct data index storage standards, and store and extract data according to the data index storage standards; Define the target operation relationship between the target primary indicator and the secondary indicator through a graphical calculation tool, and calculate the target primary indicator according to the target operation relationship; Constructing an indicator data filtering component according to the target operation relational expression, and extracting the secondary indicator corresponding to the target primary indicator according to the indicator data filtering component to obtain target basic data; Based on the target basic data, the target primary indicators and their corresponding secondary indicators are extracted and displayed in a standardized manner and in a graphical form; Monitor the target primary indicators and the target basic data, and issue an alarm when an abnormality is found.

2. The method for convenient analysis and management of distribution network assessment indicators according to claim 1 is characterized in that: The data indicator storage standard includes: an indicator definition table, an indicator dictionary table and an indicator storage table; The indicator definition table includes the following standard attribute fields: indicator parameter, indicator name, parent node, indicator unit; The indicator dictionary table includes the following standard attribute fields: dictionary code, dictionary name, dictionary type; wherein the standard attribute fields of the dictionary type include indicator frequency, data source and data type; The indicator storage table includes the following standard attribute fields for data: indicator code, indicator value, indicator unit, indicator frequency, data source, data type, and indicator time.

3. The method for convenient analysis and management of distribution network assessment indicators according to claim 1 is characterized in that: The graphical calculation tool is a set of graphical drag-and-drop calculation formula assembly tools. The graphical calculation tool includes various secondary indicator names and operators. At least some of the secondary indicator names and operators are combined by dragging as needed to obtain the target operation relationship.

4. The method for convenient analysis and management of distribution network assessment indicators according to claim 1 is characterized in that: Calculating the target primary indicator according to the target operation relational expression specifically includes: According to the target operation relational expression, a selected calculation period and calculation frequency are obtained, and according to the selected calculation period and calculation frequency, a data extraction time point is obtained to form a target indicator time series; Splitting the target operation relational expression according to the operator of the target operation relational expression to obtain an indicator element point sequence composed of indicator element point information; Obtain the indicator value of the target indicator time series according to each indicator element point information, and generate the indicator value information corresponding to each indicator element point at each time point; Calculate the primary indicator value corresponding to each time point according to the indicator value information; The target first-level indicator corresponding to the target indicator time series is generated based on the first-level indicator values ​​corresponding to each time point.

5. The method for convenient analysis and management of distribution network assessment indicators according to claim 4 is characterized in that: The target operation relational expression includes indicator code, indicator frequency, and data type; The indicator element point information includes indicator code, indicator frequency, and data type.

6. The method for convenient analysis and management of distribution network assessment indicators according to claim 1 is characterized in that: The indicator data filtering component includes the following functions: indicator frequency filtering, data type filtering, indicator name filtering, and time range filtering.

7. The convenient analysis and management method for distribution network assessment indicators according to claim 1 is characterized in that: The standardized extraction includes: extracting the target basic data using a unified interface and presenting the target basic data in a two-dimensional table; The graphical presentation includes displaying the target basic data using at least one of the following tools: a bar chart, a line chart, a pie chart; At least one of the following information of the image is set based on the target basic data: title, data sequence, x-axis, y-axis.

8. The method for convenient analysis and management of distribution network assessment indicators according to claim 1 is characterized in that: Monitoring the target primary indicator and the target basic data, and giving an alarm when an abnormality is found, including: obtaining the correlation between each secondary indicator and the target primary indicator according to the target operation relationship; listing the positively correlated secondary indicators in the positive indicator list, and listing the negatively correlated secondary indicators in the negative indicator list; Conduct trend analysis and anomaly analysis on the secondary indicators in the positive indicator list and the negative indicator list, and include abnormal data in the abnormal indicator list; Determine whether the target data in the abnormal indicator list meets the warning triggering conditions. If so, issue an alarm for the target data.

9. The convenient analysis and management method for distribution network assessment indicators according to claim 8 is characterized in that: The warning triggering condition is: the change trend of the target data exceeds the set condition, or the change value of the target data exceeds the control line; The setting conditions and the control line can be set according to actual needs.

10. A convenient analysis and management system for distribution network assessment indicators, characterized in that: The system comprises: A storage and extraction module is used to construct a data index storage standard and perform data storage and extraction according to the data index storage standard; A calculation module, used to define a target operation relationship between a target primary indicator and a secondary indicator through a graphical calculation tool, and calculate the target primary indicator according to the target operation relationship; A data screening module, used to construct an indicator data filtering component according to the target operation relational expression, and extract the secondary indicator corresponding to the target primary indicator according to the indicator data filtering component to obtain the target basic data; A data display module, for performing standardized extraction and graphical display of the target primary indicators and their corresponding secondary indicators based on the target basic data; The monitoring and alarm module is used to monitor the target primary indicators and the target basic data, and to issue an alarm when an abnormality is found.

Images