A method and system for statistically analyzing substation data

Abstract

The present invention provides a substation data statistics method and system, comprising: filtering the acquired substation telesignal position change information once to obtain abnormal data and normal data; filtering the normal data twice to obtain abnormal operating state data and normal operating state data, as well as malfunction data and non-malfunction data; and respectively counting the abnormal data, abnormal operating state data, malfunction data, normal operating state data and non-malfunction data, thereby assisting operation and maintenance personnel to more intuitively and timely discover and eliminate potential defects and safety hazards of equipment or system functions, thereby improving the intelligence level and safe operation capability of the substation.

Description

Technical Field

[0001] The invention belongs to the technical field of substation automation, and in particular relates to a substation data statistics method and system. Background Art

[0002] In the early construction and promotion of smart substations, intelligent advanced application functions have achieved a series of results as important functional requirements and intelligent features. However, according to the operating conditions, equipment monitoring and equipment status assessment still rely mainly on manual monitoring and experience analysis, with a low degree of intelligence. Advanced applications such as intelligent alarms have not achieved the purpose of reducing operation and maintenance workload and assisting decision-making. It is still necessary to fully draw on relevant technologies such as data statistical analysis and mining, and visual display to break through the limitations of traditional monitoring technology, realize the rapid identification, fusion and core information extraction of large amounts of information, form a cross-professional data comprehensive processing and equipment operation analysis and evaluation framework, establish an intelligent application decision-making assistance mechanism, improve the level of intelligence of substation functional applications, and meet the management needs of modern power grid enterprises. Summary of the invention

[0003] In order to overcome the deficiencies of the above-mentioned prior art, the present invention proposes a substation data statistics method and system. The method and system combine the substation operation and maintenance on-site operation experience, use statistical methods, analyze and process a large amount of substation historical alarm data and visualize it, provide reliable technical means for discovering the objective laws of the operating status of secondary equipment, solve the problems of insufficient practicality and intelligence level of advanced substation applications, discover hidden defects of equipment or system functions, guide operation and maintenance decisions, and support the remote operation and maintenance and unmanned operation needs of substations under large-scale operation and maintenance conditions.

[0004] The solutions adopted to achieve the above objectives are:

[0005] A substation data statistics method, the improvement of which comprises:

[0006] Filter the acquired substation remote signal change information once to obtain abnormal data and normal data;

[0007] Performing secondary filtering on the normal data to obtain abnormal operation status data and normal operation status data, as well as malfunction data and non-malfunction data;

[0008] The abnormal data, abnormal operation status data, malfunction data, normal operation status data and non-malfunction data are respectively counted.

[0009] The first preferred technical solution provided by the present invention is improved in that the acquisition of the substation remote signal displacement information includes:

[0010] According to the substations to be counted, read the configuration file information corresponding to the substations;

[0011] Based on the profile information, connecting to a database;

[0012] If the connection fails, modify the configuration file information until the connection succeeds;

[0013] Acquire the remote signal change information of the substation from the database;

[0014] The database includes remote signal change information in the historical data of the monitoring host, and the configuration file information of the database includes user name, password, database name and substation name; the remote signal change information includes: occurrence time, remote signal name, remote signal value and status value.

[0015] The second preferred technical solution provided by the present invention is improved in that the acquired substation remote signal change information is filtered once to obtain abnormal data and normal data, including:

[0016] For the obtained substation telesignal change information, filter out the telesignal change information with two consecutive identical telesignal values ​​of the same telesignal name;

[0017] The remaining telesignal change information is regarded as normal data, and the telesignal change information of two consecutive identical telesignal values ​​of the same telesignal name is regarded as abnormal data.

[0018] The third preferred technical solution provided by the present invention is improved in that the normal data is filtered twice to obtain abnormal operation status data and normal operation status data, including:

[0019] For normal data, the telesignal change information with the total number of telesignal changes exceeding the first threshold value is screened out;

[0020] The remaining telesignal position change information is taken as the normal operating status data, and the telesignal position change information with the total number of telesignal position changes exceeding the first threshold value occurring every day is taken as the abnormal operating status data.

[0021] The fourth preferred technical solution provided by the present invention is improved in that the normal data is filtered twice to obtain the malfunction data and the non-malfunction data, including:

[0022] For normal data, the telesignal position change information with the total number of telesignal position changes exceeding the second threshold value per minute is screened out;

[0023] The remaining data are regarded as non-false data, and the remote signal position change information whose total number of remote signal position changes per minute exceeds the second threshold is regarded as false data.

[0024] The fifth preferred technical solution provided by the present invention is improved in that the statistics of abnormal data, abnormal operating state data and malfunction data include:

[0025] For abnormal data, abnormal operation status data and malfunction data, the number of occurrences of each telesignal change is counted by telesignal name, the number of days for occurrence of each telesignal change is counted by telesignal name, the number of telesignal changes is counted by day, and the number of telesignal changes of designated telesignals is counted by day.

[0026] The sixth preferred technical solution provided by the present invention is improved in that the statistics of the normal operating state data and the non-malfunction data include:

[0027] For normal operating status data and non-malfunction data, the number of telesignal position changes is counted by time, the number of each telesignal position is counted by telesignal name, and the number of designated telesignal position is counted by time.

[0028] The seventh preferred technical solution provided by the present invention is improved in that the counting of the number of remote signal changes according to time includes:

[0029] The number of remote signal changes is counted annually, the number of remote signal changes is counted monthly, and the number of remote signal changes is counted daily.

[0030] The eighth preferred technical solution provided by the present invention is improved in that the counting of each remote signal change according to the remote signal name includes:

[0031] According to the name of the remote signal, the number of occurrences of each remote signal change and the number of days of occurrence of each remote signal change are counted.

[0032] The ninth preferred technical solution provided by the present invention is improved in that the counting of the number of designated remote signal changes according to time includes:

[0033] The designated telesignals shall be counted on an annual basis for telesignal position changes, the designated telesignals shall be counted on a monthly basis for telesignal position changes, and the designated telesignals shall be counted on a daily basis for telesignal position changes.

[0034] The tenth preferred technical solution provided by the present invention is improved in that the statistics include:

[0035] Statistics include count, mean, standard deviation, minimum, 1 / 4 quantile, 1 / 2 quantile, 3 / 4 quantile, maximum, variance, range, and upper and lower bounds for detecting outliers.

[0036] The eleventh preferred technical solution provided by the present invention is improved in that, after respectively collecting statistics on the abnormal data, the abnormal operating state data, the malfunction data, the normal operating state data and the non-malfunction data, it further comprises:

[0037] The statistical results are visualized in drawings and charts.

[0038] A substation data statistics system, the improvement of which is that it comprises: a data preprocessing module and a data analysis module;

[0039] The data preprocessing module is used to filter the acquired substation remote signal change information once to obtain abnormal data and normal data, and to filter the normal data twice to obtain abnormal operation status data and normal operation status data, as well as malfunction data and non-malfunction data;

[0040] The data analysis module is used to collect statistics on the abnormal data, abnormal operation status data, malfunction data, normal operation status data and non-malfunction data respectively.

[0041] The twelfth preferred technical solution provided by the present invention is improved in that it further includes a data reading module for reading the substation remote signal change information, and the data reading module includes: a configuration reading unit, a connection unit and a data acquisition unit;

[0042] The configuration reading unit is used to read the configuration file information corresponding to the substation according to the substations that need to be counted;

[0043] The connection unit is used to connect to the database based on the configuration file information, and if the connection fails, modify the configuration file information until the connection is successful;

[0044] The data acquisition unit is used to acquire the remote signal change information of the substation from the database;

[0045] The database includes remote signal change information in the historical data of the monitoring host, and the configuration file information of the database includes user name, password, database name and substation name; the remote signal change information includes: occurrence time, remote signal name, remote signal value and status value.

[0046] The thirteenth preferred technical solution provided by the present invention is improved in that the data preprocessing module includes a first screening unit and a first data dividing unit;

[0047] The first screening unit is used to screen out the telesignaling change information of the substation with two consecutive telesignaling values ​​of the same telesignaling name from the acquired telesignaling change information of the substation;

[0048] The first data division unit is used to regard the remaining telesignal change information as normal data and regard the telesignal change information of two consecutive identical telesignal values ​​of the same telesignal name as abnormal data.

[0049] The fourteenth preferred technical solution provided by the present invention is improved in that the data preprocessing module further includes a second screening unit and a second data division unit;

[0050] The second screening unit is used to screen out the remote signal change information of which the total number of remote signal changes per day exceeds the first threshold value from the normal data;

[0051] The second data division unit is used to use the remaining remote signal change information as normal operating status data, and use the remote signal change information with a total number of remote signal changes exceeding a first threshold value occurring every day as abnormal operating status data.

[0052] The fifteenth preferred technical solution provided by the present invention is improved in that the data preprocessing module further includes a third screening unit and a third data division unit;

[0053] The third screening unit is used to screen out the remote signal position change information of which the total number of remote signal position changes per minute exceeds the second threshold value from the normal data;

[0054] The third data division unit is used to regard the remaining data as non-error data, and regard the remote signal position change information with a total number of remote signal position changes exceeding a second threshold value per minute as error data.

[0055] The sixteenth preferred technical solution provided by the present invention is improved in that the data analysis module includes a first statistical unit and a second statistical unit;

[0056] The first statistical unit is used to count the number of occurrences of each remote signal change according to the remote signal name, the number of days for occurrence of each remote signal change according to the remote signal name, the number of remote signal changes by day, and the number of remote signal changes of designated remote signals by day for abnormal data, abnormal operating status data and malfunction data.

[0057] The second statistical unit is used to count the number of telesignal position changes by time, count the number of telesignal position changes by telesignal name, and count the number of designated telesignal position changes by time for the normal operating status data and the number of non-error operations.

[0058] Compared with the closest prior art, the present invention has the following beneficial effects:

[0059] The present invention proposes a substation data statistics method and system, which performs a primary filtering on the acquired substation telesignal position change information to obtain abnormal data and normal data; performs a secondary filtering on the normal data to obtain abnormal operating status data and normal operating status data, as well as malfunction data and non-malfunction data; and performs statistics on the abnormal data, abnormal operating status data, malfunction data, normal operating status data and non-malfunction data respectively, thereby assisting operation and maintenance personnel to more intuitively and timely discover and eliminate potential defects and safety hazards of equipment or system functions, thereby improving the intelligence level and safe operation capability of the substation.

[0060] The present invention also displays the statistical results, and the display methods include visual displays such as bar charts, pie charts, scatter plots, line charts, histograms, density plots, and box plots, as well as displaying the statistical query result data and the count, average, standard deviation, minimum value, 1 / 4 quantile, 1 / 2 quantile, 3 / 4 quantile, maximum value, variance, range, upper and lower bounds of detecting outliers calculated from the statistical query result data in a table, so as to make the statistical results more intuitive, facilitate the discovery of hidden defects in equipment or system functions, guide operation and maintenance decisions, and support the needs of remote operation and maintenance and unmanned operation of substations under large-scale operation and maintenance conditions. BRIEF DESCRIPTION OF THE DRAWINGS

[0061] Figure 1 A schematic diagram of a substation data statistics method provided by the present invention;

[0062] Figure 2 A schematic diagram of a data reading process in a substation data statistics method provided by the present invention;

[0063] Figure 3 A schematic diagram of a data preprocessing process in a substation data statistics method provided by the present invention;

[0064] Figure 4 A schematic diagram of data statistical analysis content in a substation data statistical method provided by the present invention;

[0065] Figure 5 A schematic diagram of the result display content in a substation data statistics method provided by the present invention;

[0066] FIG6 is a graph showing the number of occurrences of signals with more than 3 telesignaling changes per minute in 2016 according to daily statistics in an embodiment of the present invention, wherein FIG6(a) is a scatter plot and the number of statistics, and FIG6(b) is a box plot and the basic statistics of the number of statistics;

[0067] Figure 7 This is a graph showing the number of occurrences of signals with more than 3 telesignal changes per minute according to telesignal names in an embodiment of the present invention;

[0068] Figure 8 This is a graph showing the result of daily statistics of the number of occurrences of "2205 circuit breaker closing position on the 220kV side of No. 5 main transformer" in an embodiment of the present invention;

[0069] FIG9 is a graph showing the result of counting the number of telesignal position changes of a signal with no more than 3 telesignal position changes per minute according to the telesignal name in an embodiment of the present invention, wherein FIG9(a) is a scatter plot and the result of the number of counts, and FIG9(b) is a box plot and the result of the number of counts;

[0070] Fig.10It is a display diagram of the result of counting the number of days of telesignal change occurrence of signals with no more than 3 telesignal change numbers per minute according to the telesignal name in an embodiment of the present invention;

[0071] Fig.11 It is a result display diagram of the number of occurrences of "Wu Ning Line 2218 three-phase inconsistent action" in the signal where the number of telesignal changes per minute does not exceed 3 times according to daily statistics in an embodiment of the present invention;

[0072] Fig.12 A basic structural diagram of a substation data statistics system provided by the present invention;

[0073] Fig.13 A detailed structural diagram of a substation data statistics system provided by the present invention;

[0074] Fig.14 This is a schematic diagram of the operating principle of the substation data statistics system provided by the present invention. DETAILED DESCRIPTION

[0075] The specific implementation modes of the present invention are further described in detail below with reference to the accompanying drawings.

[0076] Embodiment 1:

[0077] A flow chart of a substation data statistics method provided by the present invention is as follows: Figure 1 As shown, including:

[0078] Step 1: Filter the acquired substation remote signal change information to obtain abnormal data and normal data;

[0079] Step 2: Perform secondary filtering on the normal data to obtain abnormal operation status data and normal operation status data, as well as malfunction data and non-malfunction data;

[0080] Step 3: Collect statistics on abnormal data, abnormal operation status data, malfunction data, normal operation status data and non-malfunction data respectively.

[0081] Substation data statistics methods include:

[0082] Step 101: Data reading

[0083] The data of the present invention is derived from the historical data of remote signal change of the integrated monitoring system of the intelligent substation. The remote signal change information of the substation to be analyzed is read out by using an offline file export method. The specific reading method is as follows:

[0084] Step 101-1, create a new user and database in the relational database. Create a configuration file to store the database user name, password, database name and substation name, and its organization is as follows:

[0085]

[0086] Step 101-2: Use offline file export to export the remote signal change information in the historical data of the monitoring host and store it in the newly created database. The table name is yx_data and the table structure is as follows:

[0087]

[0088]

[0089] Step 101-3: Select the substation to be analyzed according to actual needs, read the corresponding database configuration file information, and connect to the database. If the connection fails, check whether the configuration file is correct, modify it and reconnect until it succeeds.

[0090] Step 101-3 The specific process is as follows Figure 2 shown.

[0091] Step 102: Data preprocessing

[0092] Step 102 Figure 3 As shown, the data screening and cleaning process mainly includes the following three aspects:

[0093] Step 102-1: Perform a filter to filter out signals with two consecutive 0 or 1 values ​​of the same remote signal.

[0094] A telesignal value of 1 represents occurrence, and 0 represents recovery. Under normal circumstances, the telesignal value of the same telesignal should not have consecutive values ​​of 0 or 1. If it does, it means that the alarm data has abnormalities such as mis-sending or missing. This patent screens out two consecutive alarm messages of 0 or 1 and divides them into abnormal data and normal data for statistics.

[0095] Create a new Structured Query Language (SQL) query statement to filter data as follows:

[0096] 102-1-1. Create a temporary table temp_yx_data_ts. Add a field ts for calculating timestamp based on the original table yx_data. The field type is bigint (8 bytes long) and the value of the field is OCCUR_TIME+OCCUR_MS. This is to improve the query speed in the future, which is equivalent to exchanging space for time.

[0097] 102-1-2. Create indexes for the two fields YX_ID and ts;

[0098] 102-1-3. Create temp_yx_data_bad and temp_yx_data_good tables. The fields are the same as those of temp_yx_data_ts table, but they do not contain any data. They are used to store the screening result data later.

[0099] 102-1-4. Parse the data and sort by YX_ID and ts. If the YX_ID and YX_VAL of the current record are the same as those of the previous record, store the current record in the temp_yx_data_bad table, otherwise store it in the temp_yx_data_good table. That is, the temp_yx_data_bad table stores abnormal data filtered out once, and the temp_yx_data_good table stores normal data filtered out once.

[0100] Step 102-2: Perform secondary filtering to filter out signals where the total number of telesignal position changes exceeds the first threshold every day.

[0101] The number of daily alarms of the same telesignal should not exceed the first threshold. If it exceeds, it may be in a test state or abnormal normal operation state such as frequent signal jitter. Therefore, this patent, on the basis of filtering out the telesignal alarm signals with two consecutive 0 or 1 telesignal values ​​of the same telesignal, screens out the signals with the total number of telesignal position changes exceeding the first threshold every day, and divides the abnormal normal operation state data and the normal operation state data for statistical analysis. The first threshold can be set to 10 times.

[0102] Create a new SQL query statement to filter data as follows:

[0103] 102-2-1. Create temp_yx_data_good_d_good table and temp_yx_data_good_d_bad table. The fields are the same as those of temp_yx_data_good table, which are used to store the screening result data later.

[0104] 102-2-2. Query the data that occurs no more than 10 times a day from the temp_yx_data_good table and store it in the temp_yx_data_good_d_good table. That is, the temp_yx_data_good_d_good table contains the normal operating status data after secondary filtering;

[0105] 102-2-3. Query the data that occurs more than 10 times a day from the temp_yx_data_good table and store it in the temp_yx_data_good_d_bad table. That is, the temp_yx_data_good_d_bad table contains the abnormal operating status data filtered out by secondary filtering.

[0106] Step 102-3: Perform secondary filtering to filter out signals where the number of telesignal changes per minute exceeds the second threshold

[0107] When a telesignal position changes frequently above the second threshold in 1 minute, it can be judged as a false operation. Based on filtering out the telesignal alarm signals with two consecutive 0 or 1 values ​​of the same telesignal, this patent screens out the signals with the number of telesignal changes exceeding the second threshold per minute, and divides the false operation data and non-false operation data for statistical analysis. The second threshold can be set to 3 times.

[0108] Create a new SQL query statement to filter data as follows:

[0109] 102-3-1. Create temp_yx_data_good_m_good table and temp_yx_data_good_m_bad table. The fields are the same as those of temp_yx_data_good table, which are used to store the screening result data later.

[0110] 102-3-2. Query the data with the occurrence frequency of no more than 3 times per minute from the temp_yx_data_good table and store it in the temp_yx_data_good_m_good table. That is, the temp_yx_data_good_m_good table contains the non-false operation data after secondary filtering;

[0111] 102-3-3. Query the data that occurs more than 3 times per minute from the temp_yx_data_good table and store it in the temp_yx_data_good_m_bad table. That is, the temp_yx_data_good_m_bad table contains the malfunction data selected by secondary filtering.

[0112] Step 103: Data Statistical Analysis

[0113] Data analysis includes two categories: one is statistical analysis of the data screened out by the three types of preprocessing, and the other is statistical analysis of the preprocessed data. The specific statistical analysis content is as follows: Figure 4 shown.

[0114] The statistical analysis is as follows:

[0115] Step 103-1: Perform the following statistical analysis on the data filtered out by the above three pre-processing methods:

[0116] That is, the following statistical analysis is performed on abnormal data, abnormal operating status data and malfunction data respectively:

[0117] 103-1-1. Count the number of remote signal changes by remote signal name

[0118] 103-1-2. Count the number of days each remote signal changes according to its name

[0119] 103-1-3. Daily statistics of remote signal changes

[0120] 103-1-4. Daily statistics of the number of remote signal changes of designated remote signals

[0121] Step 103-2: Statistical analysis of preprocessed data

[0122] That is, statistical analysis of normal operating status data and non-malfunction data

[0123] The pre-processed data selected in this embodiment is the data in the temp_yx_data_good_m_good table, that is, the data that has been subjected to the following two-level screening: first, the signals with two consecutive 0 or 1 values ​​of the same remote signal are screened out, and then the signals with more than 3 remote signal changes per minute are screened out. The statistical analysis of the pre-processed data mainly includes the following three aspects of analysis:

[0124] 103-2-1. The number of telesignal changes can be divided into the following three categories according to the time period:

[0125] 103-2-1-1. Annual statistics of remote signal changes

[0126] 103-2-1-2. Monthly statistics of remote signal changes

[0127] 103-2-1-3. Daily statistics of remote signal changes

[0128] 103-2-2. The remote signal changes can be divided into the following two categories according to the remote signal name:

[0129] 103-2-2-1. Count the number of remote signal changes by remote signal name

[0130] 103-2-2-2. Count the number of days each remote signal changes according to the remote signal name

[0131] 103-2-3. The number of designated telesignal changes can be divided into the following three categories according to time statistics:

[0132] 103-2-3-1. Statistical number of telesignal position changes by year for designated telesignals

[0133] 103-2-3-2. Statistical number of telesignal position changes by month for designated telesignals

[0134] 103-2-3-3. Specify the number of telesignal changes to be counted daily

[0135] For the above different contents, the statistical analysis methods are similar. Taking the annual statistics of the number of telesignal changes of the pre-processed data as an example, the analysis method is as follows:

[0136] 1) Create a new SQL query statement to query the number of telesignal position changes by year, as shown below:

[0137]

[0138] 2) Call the Python database interface and execute the above SQL query statement to obtain the statistical query results of "year" and "number of entries" in the data frame format;

[0139] 3) Calculate the count, mean, standard deviation, minimum, 1 / 4 quantile, 1 / 2 quantile, 3 / 4 quantile, maximum, variance, range, and upper and lower bounds for detecting outliers in the "Number of Items" column in the statistical query results. The data format is DataFrame format.

[0140] Step 104: Result display

[0141] There are two main types of result display content: one is the visual drawing display of statistical results, and the other is the display of statistical results in tables. The specific result display content is as follows: Figure 5 shown.

[0142] 104-1. Visualization of statistical results

[0143] For the visual drawing display of statistical results, the Pyplot interface of the Python language Matplotlib drawing toolkit is used to draw the statistical query results in the DataFrame format of the above data analysis.

[0144] Different display methods are designed according to the amount of data and different functional effects, including bar charts, pie charts, scatter plots, line charts, histograms, density maps, and box plots. The specific display methods are shown in the following table.

[0145]

[0146] 104-2. Display of statistical results in tables

[0147] The results of the above statistical analyses are presented in tables, mainly including the following two aspects:

[0148] 104-2-1. Statistical query result data;

[0149] 104-2-2. The basic statistics calculated from the statistical query results include: count, mean, standard deviation, minimum value, 1 / 4 quantile, 1 / 2 quantile, 3 / 4 quantile, maximum value, variance, range, and upper and lower bounds for detecting outliers.

[0150] Embodiment 2:

[0151] The following is a specific example of substation data statistics to verify the correctness and feasibility of this method. Taking Tianjin 500kV Wuzhuang substation as an example, the remote signal change information in the historical alarm data is read. The alarm time interval is 2015-11-12 ~ 2017-12-15, and the number of records in the remote signal change table is 825605. Table 1 is a list of data items after data preprocessing. It can be preliminarily known that 122734 (14.9%) signals have the problem of sending two 0 or 1 change information in succession, and the relevant signals are worthy of attention; the number of change signals with daily alarms>10 is 578492, and the number of data with alarms>3 is 523648, accounting for 82.3% and 74.5% of the total, respectively. It can be seen that frequent and jitter signals account for a large proportion, so the normal operation of the remote signal change signal will be buried in these large numbers of frequent jitter signals.

[0152] Table 1 List of data items after data preprocessing

[0153]

[0154]

[0155] Then, we analyze the data filtered out by preprocessing. The filtered data are all noteworthy, but we should also analyze the key points. Figure 6 shows the result of daily statistics of the number of signals with more than 3 telesignal changes per minute in 2016. As shown in Figure 6(a), there are 132,087 alarms on 2016-05-06, which is much more than the number of alarms on other days. This day is particularly noteworthy. As shown in Figure 6(b), the upper limit of the abnormal value detected by the box plot is 303.25 days and the lower limit is 4 days. The data outside this limit are all outliers (abnormal values). Figure 7 The result of counting the number of signals with more than 3 telesignal changes per minute by telesignal name is shown in the figure. As can be seen from the figure, the number of alarms of "2205 circuit breaker closed on the 220kV side of No. 5 main transformer" is 131,449, which is much more than the number of alarms of other telesignals. This telesignal is particularly noteworthy. Figure 8 This is a chart showing the number of "2205 circuit breaker closed on the 220kV side of No. 5 main transformer" statistics on a daily basis. As can be seen from the chart, there were 131,449 remote signal alarms on 2016-05-06.

[0156] From the above, we can see that there was an abnormal alarm on 2016-05-06. The abnormal remote signal was "2205 circuit breaker on the 220kV side of No. 5 main transformer was closed", and the dates with daily alarms outside the range of 4 to 303 are worth noting. Other analyses are similar.

[0157] Finally, the pre-processed data is statistically analyzed. Figure 9 shows the result of counting the number of telesignal changes per minute for signals with no more than 3 telesignal changes per minute according to the telesignal name. Combined with the relevant operation and maintenance professional knowledge of the substation, it can be seen from Figure 9(a) that the number of telesignals of "Wuning Line 1 2218 three-phase inconsistent action" is 2118, which is too much and abnormal and worthy of attention; as shown in Figure 9(b), the upper limit of the abnormal value detected by the box plot is 60 and the lower limit is 1. The data outside this limit are all outliers (abnormal values), and it is also judged that the number of "Wuning Line 1 2218 three-phase inconsistent action" is too many. Fig.10 This is a graph showing the number of days that telesignal changes occur for signals with no more than 3 telesignal changes per minute, according to the telesignal name. It can be seen from the figure that the number of days that "Wuning Line 2218 three-phase inconsistent action" occurred was 319 days, while the upper limit of the abnormal value detected by the box plot is 16 days and the lower limit is 1 day, which means that the number of days it occurred is too many. Fig.11 This chart shows the number of "Wuning Line 1 2218 three-phase inconsistent action" in the signal with no more than 3 telesignal changes per minute, which is counted on a daily basis. The chart shows the alarm occurrence date and the corresponding number of occurrences of this telesignal. This signal and the related date are worthy of attention from operation and maintenance personnel.

[0158] Embodiment 3:

[0159] Based on the same inventive concept, the present invention also provides a substation data statistics system. Since the principles of these devices for solving technical problems are similar to the substation data statistics method, the repeated parts will not be repeated.

[0160] The basic structure of the system is as follows Fig.12 As shown, it includes: a primary filtering module, a secondary filtering module and a statistical module;

[0161] Among them, the primary filtering module is used to filter the acquired substation remote signal change information to obtain abnormal data and normal data;

[0162] A secondary filtering module is used to perform secondary filtering on normal data to obtain abnormal operation status data and normal operation status data, as well as malfunction data and non-malfunction data;

[0163] The statistical module is used to collect statistics on abnormal data, abnormal operating state data, malfunction data, normal operating state data and non-malfunction data respectively.

[0164] Among them, the detailed structure of the substation data statistics system is as follows: Fig.13As shown, it also includes a data reading module for reading the substation remote signal change information, and the data reading module includes: a configuration reading unit, a connection unit and a data acquisition unit;

[0165] A configuration reading unit is used to read configuration file information corresponding to the substation according to the substations to be counted;

[0166] A connection unit, used to connect to the database based on the configuration file information, and if the connection fails, modify the configuration file information until the connection succeeds;

[0167] A data acquisition unit, used to acquire the remote signal change information of the substation from the database;

[0168] The database includes the remote signal change information in the historical data of the monitoring host. The configuration file information of the database includes the user name, password, database name and substation name; the remote signal change information includes: occurrence time, remote signal name, remote signal value and status value.

[0169] Wherein, the primary filtering module includes a first screening unit and a first data dividing unit;

[0170] The first screening unit is used to screen out the telesignal change information of the substation with two consecutive telesignal values ​​of the same telesignal name from the acquired telesignal change information of the substation;

[0171] The first data division unit is used to regard the remaining telesignal change information as normal data and regard the telesignal change information of two consecutive identical telesignal values ​​of the same telesignal name as abnormal data.

[0172] Wherein, the secondary filtering module includes a second screening unit and a second data division unit;

[0173] The second screening unit is used to screen out the remote signal change information of which the total number of remote signal changes occurring every day exceeds the first threshold value from the normal data;

[0174] The second data division unit is used to use the remaining remote signal change information as normal operating status data, and use the remote signal change information with a total number of remote signal changes exceeding a first threshold value occurring every day as abnormal operating status data.

[0175] Wherein, the secondary filtering module further includes a third screening unit and a third data division unit;

[0176] The third screening unit is used to screen out the remote signal position change information of which the total number of remote signal position changes per minute exceeds the second threshold value from the normal data;

[0177] The third data division unit is used to regard the remaining data as non-error data and regard the remote signal position change information with the total number of remote signal position changes exceeding the second threshold value per minute as error data.

[0178] Wherein, the statistical module includes a first statistical unit and a second statistical unit;

[0179] The first statistical unit is used for counting the number of occurrences of each telesignal change by telesignal name, the number of days for occurrence of each telesignal change by telesignal name, the number of telesignal changes by day, and the number of telesignal changes of designated telesignals by day for abnormal data, abnormal operating status data and malfunction data.

[0180] The second statistical unit is used to count the number of telesignal position changes by time, count the number of telesignal position changes by telesignal name, and count the number of designated telesignal position changes by time for the normal operating status data and the non-error data.

[0181] Among them, the substation data statistics system also includes a result display module;

[0182] The result display module is used to visualize the statistical results through drawing and charting.

[0183] The operation principle of the substation data statistics system is as follows Fig.14 shown.

[0184] Those skilled in the art will appreciate that the embodiments of the present application may be provided as methods, systems, or computer program products. Therefore, the present application may adopt the form of a complete hardware embodiment, a complete software embodiment, or an embodiment in combination with software and hardware. Moreover, the present application may adopt the form of a computer program product implemented in one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) that include computer-usable program code.

[0185] The present application is described with reference to the flowcharts and / or block diagrams of the methods, devices (systems), and computer program products according to the embodiments of the present application. It should be understood that each process and / or box in the flowchart and / or block diagram, as well as the combination of the processes and / or boxes in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0186] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0187] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 A step that specifies a function in one or more boxes.

[0188] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present application rather than to limit its protection scope. Although the present application has been described in detail with reference to the above embodiments, ordinary technicians in the relevant field should understand that after reading the present application, those skilled in the art can still make various changes, modifications or equivalent substitutions to the specific implementation methods of the application, but these changes, modifications or equivalent substitutions are all within the protection scope of the claims to be approved.

Claims

1. A substation data statistics method, characterized in that: include: Filter the acquired substation remote signal change information once to obtain abnormal data and normal data; Performing secondary filtering on the normal data to obtain abnormal operation status data and normal operation status data, as well as malfunction data and non-malfunction data; respectively collecting statistics on the abnormal data, abnormal operation status data, malfunction data, normal operation status data and non-malfunction data; The acquisition of the substation remote signal change information includes: According to the substations to be counted, read the configuration file information corresponding to the substations; Based on the profile information, connecting to a database; If the connection fails, modify the configuration file information until the connection succeeds; Acquire the remote signal change information of the substation from the database; The database includes remote signal change information in the historical data of the monitoring host, and the configuration file information of the database includes user name, password, database name and substation name; the remote signal change information includes: occurrence time, remote signal name, remote signal value and status value.

2. The method according to claim 1, characterized in that The obtained substation remote signal change information is filtered once to obtain abnormal data and normal data, including: For the obtained substation telesignal change information, filter out the telesignal change information with two consecutive identical telesignal values ​​of the same telesignal name; The remaining telesignal change information is regarded as normal data, and the telesignal change information of two consecutive identical telesignal values ​​of the same telesignal name is regarded as abnormal data.

3. The method according to claim 2, characterized in that The secondary filtering of the normal data to obtain abnormal operation status data and normal operation status data includes: For normal data, the telesignal change information with the total number of telesignal changes exceeding the first threshold value is screened out; The remaining telesignal position change information is taken as the normal operating status data, and the telesignal position change information with the total number of telesignal position changes exceeding the first threshold value occurring every day is taken as the abnormal operating status data.

4. The method according to claim 2, characterized in that The secondary filtering of the normal data to obtain the malfunction data and the non-malfunction data includes: For normal data, the telesignal position change information with the total number of telesignal position changes exceeding the second threshold value per minute is screened out; The remaining data are regarded as non-false data, and the remote signal position change information whose total number of remote signal position changes per minute exceeds the second threshold is regarded as false data.

5. The method according to claim 1, characterized in that The statistics of abnormal data, abnormal operation status data and malfunction data include: For abnormal data, abnormal operation status data and malfunction data, the number of occurrences of each telesignal change is counted by telesignal name, the number of days for occurrence of each telesignal change is counted by telesignal name, the number of telesignal changes is counted by day, and the number of telesignal changes of designated telesignals is counted by day.

6. The method according to claim 1, characterized in that The statistics of normal operation status data and non-malfunction data include: For normal operating status data and non-malfunction data, the number of telesignal position changes is counted by time, the number of each telesignal position is counted by telesignal name, and the number of designated telesignal position is counted by time.

7. The method according to claim 6, characterized in that The counting of the number of remote signal changes according to time includes: The number of remote signal changes is counted annually, the number of remote signal changes is counted monthly, and the number of remote signal changes is counted daily.

8. The method according to claim 6, characterized in that The above-mentioned counting of each remote signal position change according to the remote signal name includes: According to the name of the remote signal, the number of occurrences of each remote signal change and the number of days of occurrence of each remote signal change are counted.

9. The method according to claim 6, characterized in that The time-based statistics of the number of remote signal changes include: The designated telesignals shall be counted on an annual basis for telesignal position changes, the designated telesignals shall be counted on a monthly basis for telesignal position changes, and the designated telesignals shall be counted on a daily basis for telesignal position changes.

10. The method according to any one of claims 2 to 9, characterized in that: The statistics include: Statistics include count, mean, standard deviation, minimum, 1 / 4 quantile, 1 / 2 quantile, 3 / 4 quantile, maximum, variance, range, and upper and lower bounds for detecting outliers.

11. The method according to claim 1, characterized in that After respectively collecting statistics on the abnormal data, the abnormal operation status data, the malfunction data, the normal operation status data and the non-malfunction data, the method further includes: The statistical results are visualized in drawings and charts.

12. A substation data statistics system, characterized in that: include: Data preprocessing module and data analysis module; The data preprocessing module is used to filter the acquired substation remote signal change information once to obtain abnormal data and normal data, and to filter the normal data twice to obtain abnormal operation status data and normal operation status data, as well as malfunction data and non-malfunction data; The data analysis module is used to collect statistics on the abnormal data, abnormal operation status data, malfunction data, normal operation status data and non-malfunction data respectively; It also includes a data reading module for reading the substation remote signal change information, the data reading module includes: a configuration reading unit, a connection unit and a data acquisition unit; The configuration reading unit is used to read the configuration file information corresponding to the substation according to the substations that need to be counted; The connection unit is used to connect to the database based on the configuration file information, and if the connection fails, modify the configuration file information until the connection is successful; The data acquisition unit is used to acquire the remote signal change information of the substation from the database; The database includes remote signal change information in the historical data of the monitoring host, and the configuration file information of the database includes user name, password, database name and substation name; the remote signal change information includes: occurrence time, remote signal name, remote signal value and status value.

13. The system of claim 12, wherein: The data preprocessing module includes a first screening unit and a first data dividing unit; The first screening unit is used to screen out the telesignaling change information of the substation with two consecutive telesignaling values ​​of the same telesignaling name from the acquired telesignaling change information of the substation; The first data division unit is used to regard the remaining telesignal change information as normal data and regard the telesignal change information of two consecutive identical telesignal values ​​of the same telesignal name as abnormal data.

14. The system of claim 13, wherein: The data preprocessing module also includes a second screening unit and a second data division unit; The second screening unit is used to screen out the remote signal change information of which the total number of remote signal changes per day exceeds the first threshold value from the normal data; The second data division unit is used to use the remaining remote signal change information as normal operating status data, and use the remote signal change information with a total number of remote signal changes exceeding a first threshold value occurring every day as abnormal operating status data.

15. The system of claim 13, wherein: The data preprocessing module also includes a third screening unit and a third data division unit; The third screening unit is used to screen out the remote signal position change information of which the total number of remote signal position changes per minute exceeds the second threshold value from the normal data; The third data division unit is used to regard the remaining data as non-error data, and regard the remote signal position change information with a total number of remote signal position changes exceeding a second threshold value per minute as error data.

16. The system of claim 12, wherein: The data analysis module includes a first statistical unit and a second statistical unit; The first statistical unit is used to count the number of occurrences of each remote signal change according to the remote signal name, the number of days for occurrence of each remote signal change according to the remote signal name, the number of remote signal changes according to the day, and the number of remote signal changes of the designated remote signal according to the day for abnormal data, abnormal operating status data and malfunction data; The second statistical unit is used to count the number of telesignal position changes by time, count the number of telesignal position changes by telesignal name, and count the number of designated telesignal position changes by time for the normal operation status data and the non-error data.

Images