A water pump data processing system and method based on tunnel inclined shaft

Abstract

A water pump data processing system and method based on a tunnel inclined shaft belongs to the field of data processing technology. It starts by calculating the reduction of key values ​​to grasp the floating status of value changes, and performs standardization processing through the reduction ratio to make the detection process more sensitive and more suitable. Then, through leveling processing and balancing operations, a separation point critical value that can efficiently detect outliers is obtained, so as to accurately lock the outliers within the key values. The advantage of this method is that it has good suitability, compatibility and accuracy, and can be suitable for several categories of values, while simultaneously ensuring good detection performance even when the value distribution is messy.

Description

Technical Field

[0001] The invention belongs to the technical field of data processing, and in particular relates to a water pump data processing system and method based on a tunnel inclined shaft. Background Art

[0002] Tunnel inclined shaft is a kind of vertical shaft or inclined shaft to increase the working surface in order to shorten the construction period during the construction of long tunnel. Sometimes parallel pilot pits, vertical shafts or inclined shafts are set up.

[0003] In the application of tunnel inclined shaft, as mentioned in the prior art solution with patent publication number "CN217001965U", the tunnel inclined shaft is arranged on the reverse slope section, and a water pump is arranged in the reverse slope section for drainage.

[0004] It can be seen that the water pump is an important tool to ensure the normal use of the inclined and reverse slope sections of the tunnel. Therefore, it is necessary to perform sampling of key values ​​of the water pump installed in the reverse slope section to realize the corresponding monitoring function. At present, the key values ​​of the water pump in the reverse slope section are generally sampled by sensors and transmitted to the controller. Then the controller determines the condition of the water pump through the key values ​​of the water pump in the reverse slope section transmitted by the sampling.

[0005] To identify the condition of the water pump is to identify whether the water pump has failed. The current method of identifying whether the water pump has failed is mainly to determine whether the key value of the water pump in the reverse slope section is an outlier. The current common outlier detection method is based on a pre-defined constant critical value. This method defines different critical values ​​according to the key value characteristics of different water pumps to suit high and low key values. However, because the number and specifications of water pumps in the reverse slope section are complex and the key value quantity is large, the definition rules of the critical value are often also very complex, and this type of constant critical value method is insufficient in detection accuracy when facing scenes with large value changes. In addition, the current method also has the defect of poor applicability, that is, the outlier detection performance is quite different when facing different value categories or value distributions. Summary of the invention

[0006] In order to solve the defects in the prior art, the present invention proposes a water pump data processing system and method based on a tunnel inclined shaft, which effectively avoids the defects in the prior art such as complicated definition rules of critical quantities, insufficient detection accuracy and poor applicability of the constant critical quantity method when facing scenarios with large numerical changes.

[0007] The present invention utilizes the following technical solutions.

[0008] A method for processing water pump data based on a tunnel inclined shaft, comprising:

[0009] The sensor samples the key values ​​of the water pump in the reverse slope section and transmits them to the controller. The controller determines the status of the water pump by sampling the key values ​​of the water pump in the reverse slope section.

[0010] To determine the condition of the water pump is to determine whether the water pump has failed;

[0011] Methods for determining whether a water pump has failed include:

[0012] Step 1: Receive the source key values ​​of the water pump, remove useless values, and sort them in descending order of the key values ​​to obtain a key value queue;

[0013] Step 2: sequentially calculate the decrements of the next key value and the previous key value in the key value queue to obtain a decrement queue, and respectively calculate the ratio of the decrements in the total decrement value to obtain a decrement ratio queue;

[0014] Step 3: Calculate the ratio of the standard deviation of the reduction to the total value of the standard deviation of the reduction in turn, and obtain the standard deviation ratio queue of the reduction;

[0015] Step 4: Multiply the key value queue starting from the first key value and each reduction standard deviation ratio of the reduction standard deviation ratio queue in turn to obtain the critical amount of the starting point leveling separation point, and multiply the key value queue starting from the second key value and each reduction standard deviation ratio of the reduction standard deviation ratio queue in turn to obtain the critical amount of the ending point leveling separation point;

[0016] Step 5: Calculate the mean of the critical value of the starting point and the critical value of the ending point to obtain the critical value of the outlier separation point;

[0017] Step 6: Obtain the outlier queue by comparing the outlier separation point critical value and the key value. If there is no outlier in the outlier queue, it is determined that the water pump has not failed. If there is an outlier in the outlier queue, it is determined that the corresponding water pump has failed. The controller transmits the message of the outlier and the corresponding water pump failure to the LCD screen for display.

[0018] Further, in step 1, the source key value of the water pump is the key value of the water pump in the reverse slope section transmitted through sampling; the key value of the water pump in the reverse slope section is the speed value of the water pump in the reverse slope section, the working current value of the water pump in the reverse slope section or the active value of the water pump in the reverse slope section; the sensor is a speed sensor, a current sensor or an active sensor arranged on the water pump in the reverse slope section.

[0019] Further, in step 1, the source key value of the water pump is received by sampling the key value of the water pump at a set time interval during the operation of the water pump.

[0020] Furthermore, in step 1, the useless values ​​include NULL values, redundant values, illegal values, and set period values.

[0021] Further, in step 2, the amount of The operational equation is: ; Here, is the key value queue, is the sequence code of the key value in the key value queue, Is the first in the key value queue Key values, Is the first in the key value queue Key values, Is the first in the reduction queue A reduction.

[0022] Further, in step 2, the total value is reduced The operational equation is: ; Here, is the number of key values ​​in the key value queue.

[0023] Furthermore, in step 2, the reduction ratio The operational equation is: , It is the first The reduction ratio of a reduction.

[0024] Further, in step 3, the standard deviation is reduced The operational equation is: , The first The standard deviation of the reduction.

[0025] Further, in step 3, the total value of the standard deviation is reduced The operational equation is: .

[0026] Further, in step 3, the standard deviation ratio is reduced The operational equation is: , is the standard deviation ratio of the reduction in the first The reduction is within the total standard deviation of all reductions, that is, the first in the reduction standard deviation ratio queue. The ratio of the standard deviation of the reduction.

[0027] Further, in step 4, the starting point is aligned with the separation point critical amount The operational equation is: .

[0028] Further, in step 4, the end point is aligned with the separation point critical amount The operational equation is: .

[0029] Furthermore, in step 5, the outlier separation point critical value The operational equation is: .

[0030] Further, in step 6, clustering is performed based on the critical value of being lower than or not lower than the outlier separation point, the number of key values ​​in each cluster is totaled, and the cluster value with the lower number in a pair of clusters is confirmed to be an outlier, which is specifically:

[0031] Step 6-1: Take the key value that is not less than the outlier separation point as clustering queue 1;

[0032] Step 6-2: Take the critical value below the outlier separation point as clustering queue 2;

[0033] Step 6-3: Treat the clustered queue with a lower number of key values ​​as the outlier queue.

[0034] A water pump data processing system based on a tunnel inclined shaft, comprising:

[0035] The tunnel inclined shaft is set on the reverse slope section, and a water pump is set in the reverse slope section for drainage. The sensor and the LCD screen are connected to the controller. The sensor is used to sample the key values ​​of the water pump in the reverse slope section and transmit them to the controller. The controller is used to identify the condition of the water pump through the key values ​​of the water pump in the reverse slope section transmitted by the sampling.

[0036] The modules running on the controller include:

[0037] A removal module is used to receive the source key values ​​of the water pump, remove useless values, and perform arrangement in order from low to high of the key values ​​to obtain a key value queue;

[0038] A calculation module, which is used to calculate the decrements of the next key value and the previous key value in the key value queue in sequence to obtain a decrement queue, and respectively calculate the ratio of the decrement in the total decrement value to obtain a decrement ratio queue;

[0039] A ratio module, which is used to sequentially calculate the ratio of the standard deviation of the reduction to the total value of the standard deviation of the reduction, and obtain a reduction standard deviation ratio queue;

[0040] A separation module is used to sequentially perform multiplication operations on the key value queue starting from the first key value and each reduction standard deviation ratio of the reduction standard deviation ratio queue to obtain the critical amount of the start point level separation point, and sequentially perform multiplication operations on the key value queue starting from the second key value and each reduction standard deviation ratio of the reduction standard deviation ratio queue to obtain the critical amount of the end point level separation point;

[0041] A mean value module is used to calculate the mean of the critical value of the starting point and the critical value of the end point to obtain the critical value of the outlier separation point;

[0042] The outlier module is used to obtain the outlier queue by comparing the outlier separation point critical value and the key value. If there is no outlier in the outlier queue, it is determined that the water pump has no failure condition. If there is an outlier in the outlier queue, it is determined that the corresponding water pump has a failure condition. The controller transmits the message of the outlier and the corresponding water pump failure condition to the LCD screen for display.

[0043] The beneficial effects of the present invention are that, compared with the prior art, the technical effects of the present invention include:

[0044] 1. Appropriate numerical detection: The present invention can actively perform outlier detection according to the actual conditions of key numerical values ​​in the water pump, without relying on a pre-defined fixed critical value. By automatically calculating the numerical decrement and the decrement standard deviation, a matching outlier separation point critical value is automatically formed, thereby achieving outlier detection for different numerical intervals and numerical categories;

[0045] 2. Improved detection accuracy: By performing detailed analysis on the reduction and standard deviation of key values, the present invention can accurately identify outliers. Especially in the case of disorderly and diversified distribution of values, the detection method of the present invention is more accurate and reliable than the current critical value method, and can effectively reduce the occurrence of misidentification and under-identification;

[0046] 3. Enhanced compatibility: The outlier analysis method of the present invention is applicable to key values ​​of various categories. Regardless of whether the key values ​​are high or low, higher or lower than zero, they can all be efficiently processed by this method, so that the controller can be widely used in different water pumps and detection scenarios with better compatibility;

[0047] 4. Streamlining controller settings: Current methods often require defining critical values ​​for different pumps or value categories independently, which is complicated and often leads to errors. The active analytical controller of the present invention simplifies the controller setting process by intelligently calculating the critical value of the outlier separation point, reduces the hidden dangers of manual intervention and definition errors, and improves the efficiency of the controller.

[0048] 5. Real-time numerical processing: The present invention can efficiently process a large number of key numerical values ​​generated on the water pump, detect and select outliers in real time, and is suitable for informing and preventing the occurrence of hidden water pump failures in advance. BRIEF DESCRIPTION OF THE DRAWINGS

[0049] Figure 1 It is a flow chart of the water pump data processing method based on the tunnel inclined shaft described in the present invention;

[0050] Figure 2 It is a partial structural diagram of the water pump data processing system based on the tunnel inclined shaft described in the present invention. DETAILED DESCRIPTION

[0051] In order to make the purpose, technical solution and advantages of the present invention clearer, the following will be combined with the drawings in the embodiments of the present invention to clearly and completely express the technical solution of the present invention. The embodiments expressed in this application are only partial embodiments of the present invention, not all embodiments. According to the spirit of the present invention, other embodiments obtained by technicians in this field without making creative work are all within the protection scope of the present invention.

[0052] like Figure 1 As shown, the water pump data processing method based on the tunnel inclined shaft of the present invention comprises:

[0053] The sensor samples the key values ​​of the water pump in the reverse slope section and transmits them to the controller. The controller determines the status of the water pump by sampling the key values ​​of the water pump in the reverse slope section.

[0054] To determine the condition of the water pump is to determine whether the water pump has failed;

[0055] Methods for determining if a pump has failed (running on the controller) include:

[0056] Step 1: Receive the source key values ​​of the water pump, remove useless values, and sort them in descending order of the key values ​​to obtain a key value queue;

[0057] In a preferred but non-restrictive embodiment of the present invention, in step 1, the source key value of the water pump is the key value of the water pump in the reverse slope section transmitted via sampling; the key value of the water pump in the reverse slope section is the speed value of the water pump in the reverse slope section, the working current value of the water pump in the reverse slope section, or the active value of the water pump in the reverse slope section; the sensor is a speed sensor, current sensor, or active sensor provided on the water pump in the reverse slope section. After removing useless values, the key value in the arrangement according to the order of key values ​​from low to high is the remaining value after removing useless values ​​from the source key value.

[0058] In a preferred but non-limiting embodiment of the present invention, in step 1, the source key value of the receiving water pump is the key value of the receiving water pump sampled and transmitted during a set time interval during the operation of the receiving water pump (the set time interval may be 1 hour before the current time point, 30 minutes before the current time point, 15 minutes before the current time point, or 5 minutes before the current time point).

[0059] The useless values ​​contained in the source key values ​​will weaken the performance of the values, which is not conducive to the accuracy and credibility of the subsequent analysis and disposal. The useless values ​​in the source key values ​​should be removed. In the preferred but non-restrictive implementation of the present invention, in step 1, the useless values ​​include NULL values, redundant values, illegal values ​​and set period values. Here, NULL values, that is, no values, cannot perform numerical analysis processing. It is generally caused by incorrect sensor sampling or invalid value reading, so it should be removed. Redundant values ​​will be not conducive to the correctness of the analytical value, so they should also be removed. Illegal values ​​are values ​​that significantly do not meet the numerical compliance. Just like facing the key values ​​that are required to be higher than zero, the values ​​below zero should be removed, just like the speed value of the water pump in the reverse slope segment, the working current value of the water pump in the reverse slope segment or the active value of the water pump in the reverse slope segment, the set period value is like the period of repairing the water pump within the set time interval, and the values ​​in the period of repairing the water pump should be removed to prevent it from being not conducive to the accuracy of the calculation.

[0060] Step 2: sequentially calculate the decrements of the next key value and the previous key value in the key value queue to obtain a decrement queue, and respectively calculate the ratio of the decrements in the total decrement value to obtain a decrement ratio queue;

[0061] In a preferred but non-limiting embodiment of the present invention, in step 2, the reduction The operational equation is: ; Here, is the key value queue, It is the sequence code of the key value in the key value queue (the sequence code is a code that is configured by increasing the key values ​​in the key value queue by one starting from 1 according to their sequence), Is the first in the key value queue Key values, Is the first in the key value queue Key values, Is the first in the reduction queue If the number of key values ​​is , the reduction is the key value minus the ) item, so the number of decrements is indivual.

[0062] In a preferred but non-limiting embodiment of the present invention, in step 2, the total value of the reduction is The operational equation is: ; Here, is the number of key values ​​in the key value queue.

[0063] In a preferred but non-limiting embodiment of the present invention, in step 2, the reduction ratio is The operational equation is: , It is the first The reduction ratio of a reduction.

[0064] Step 3: Calculate the ratio of the standard deviation of the reduction to the total value of the standard deviation of the reduction in turn, and obtain the standard deviation ratio queue of the reduction;

[0065] In a preferred but non-limiting embodiment of the present invention, in step 3, the standard deviation is reduced The operational equation is: , The first The standard deviation of the reduction.

[0066] In a preferred but non-limiting embodiment of the present invention, in step 3, the total value of the standard deviation of the reduction The operational equation is: .

[0067] In a preferred but non-limiting embodiment of the present invention, in step 3, the standard deviation ratio of the reduction The operational equation is: , is the standard deviation ratio of the reduction in the first The reduction is within the total standard deviation of all reductions, that is, the first in the reduction standard deviation ratio queue. The ratio of the standard deviation of the reduction.

[0068] Step 4: Multiply the key value queue starting from the first key value and each reduction standard deviation ratio of the reduction standard deviation ratio queue in turn to obtain the critical amount of the starting point leveling separation point, and multiply the key value queue starting from the second key value and each reduction standard deviation ratio of the reduction standard deviation ratio queue in turn to obtain the critical amount of the ending point leveling separation point;

[0069] As if the number of key values ​​is , then the number of reduction ratio data and reduction standard deviation ratio are , it will cause the key value queue to be unable to be aligned one-to-one with the reduction ratio queue and the reduction standard deviation ratio queue. Therefore, the key value queue, the reduction ratio queue and the reduction standard deviation ratio queue must be aligned. In this application, two types of alignment methods can be used, one is the starting point alignment and the other is the end point alignment. If only one type of value alignment method is used to perform the operation, there will definitely be a highest or lowest value that cannot be calculated. Therefore, this application uses the method of step 5 below to achieve alignment.

[0070] In a preferred but non-limiting embodiment of the present invention, in step 4, the starting point is aligned with the separation point critical amount The operational equation is: .

[0071] In a preferred but non-limiting embodiment of the present invention, in step 4, the end point is aligned with the separation point critical amount The operational equation is: .

[0072] Step 5: Calculate the mean of the critical value of the starting point and the critical value of the ending point to obtain the critical value of the outlier separation point;

[0073] In a preferred but non-limiting embodiment of the present invention, in step 5, the outlier separation point critical value The operational equation is: .

[0074] Step 6: Obtain the outlier queue by comparing the outlier separation point critical value and the key value. If there is no outlier in the outlier queue, it is determined that the water pump has no failure. If there is an outlier in the outlier queue, it is determined that the corresponding water pump has a failure. The controller transmits the outlier and the corresponding water pump failure message to the LCD screen for display. After obtaining the outlier separation point critical value, the relationship between the outlier and the outlier separation point critical value can be defined in advance according to the specific situation, so as to achieve outlier detection.

[0075] In a preferred but non-limiting embodiment of the present invention, in step 6, clustering is performed based on the critical value of being lower than or not lower than the outlier separation point, the number of key values ​​in each cluster is totaled, and according to the principle that outliers are often lower values, a cluster value with a lower number in a pair of clusters is confirmed to be an outlier, which is specifically:

[0076] Step 6-1: Take the key value that is not less than the outlier separation point as clustering queue 1;

[0077] Step 6-2: Take the critical value below the outlier separation point as clustering queue 2;

[0078] Step 6-3: Treat the clustered queue with a lower number of key values ​​as the outlier queue.

[0079] In step 6, based on the principle that outliers are often lower values, a clearer method can be used to extract and display outliers, which is as follows:

[0080] According to the sampling time point of the key value, the key value in the key value queue is marked on the rectangular coordinate system to form a coordinate point, the horizontal coordinate of the coordinate point is the sampling time point of the key value, and the vertical coordinate of the coordinate point is the value of the key value;

[0081] Draw a horizontal line on the rectangular coordinate system with the ordinate being the critical value of the outlier separation point;

[0082] Compare the number of coordinate points on both sides of the horizontal line, and treat the vertical coordinate of the coordinate point on the side with fewer numbers as an outlier.

[0083] You can also use different colors to mark non-outliers and outliers to make the coordinate points more distinctive and easier to identify.

[0084] The various equations in the method for determining whether the water pump has failed can be integrated into:

[0085] ;

[0086] Here, is the standard deviation of the reduction , represents the amplitude of the value change. By performing quadratic processing on the reduction of all key values, the difference is enlarged, and the position and amplitude of the numerical difference are highlighted, which is conducive to better locking of outliers.

[0087] It is the ratio of the reduction standard deviation to the total reduction standard deviation. It transforms the original numerical amplitude into a ratio amplitude, that is, it performs standardization, which reflects the ratio of the outlier contribution of each numerical point reduction, and is suitable for the subsequent calculation of the critical value of the outlier point.

[0088] and They are the starting point, leveling point, and separation point critical value. Align the end point with the critical value of the separation point , because the decrement value is the amount obtained by subtracting a pair of adjacent values, the decrement amount will always be one value lower than the source key value. It is necessary to take into account both the start point alignment and the end point alignment methods, and the decrement It represents the relationship between the next value and the previous value in the queue. When the subtraction is not low, the probability that at least one of the next value and the previous value is an outlier is not low. However, it is impossible to accurately identify which of them is an outlier. Therefore, the construction and To overcome this defect, The next value in is considered as the previous value. and The values ​​of represent the amplitude of outliers when a value is used as the previous value and the next value.

[0089] Then get the starting point and separation point critical value Align the end point with the critical value of the separation point The mean of the outlier separation point is obtained The idea of ​​this kind of mean treatment is to balance the calculation values ​​under the two-class leveling method and ensure the stability and reliability of outlier detection.

[0090] This application starts with calculating the reduction of key values ​​to grasp the floating state of value changes, and performs standardization processing through the reduction ratio to make the detection process more sensitive and more suitable. Then, through leveling and balancing operations, a separation point critical value that can effectively detect outliers is obtained, so as to accurately lock the outliers within the key values. The advantage of this method is that it has good suitability, compatibility and accuracy, and can be suitable for several categories of values, while simultaneously ensuring good detection performance even when the value distribution is cluttered.

[0091] This application provides two types of methods:

[0092] One method is method 1, in which the controller initially determines that there are often outliers in the key values, so the entire detection process must be fully executed (that is, the method of determining whether the pump has a failure). This method assumes that all values ​​have the probability of hidden outliers, so no matter what the initial properties of the values ​​are, the controller will perform comprehensive outlier detection according to the pre-defined equations and methods. Steps 1 to 6 carefully parameterize the entire process of this method, through step-by-step calculation of the value reduction, reduction standard deviation and the corresponding separation point threshold, and finally identify and send out the outlier queue. This method is suitable for scenarios that are very sensitive to values ​​and must ensure that hidden outliers are not lost.

[0093] Another method is method 2, in which the controller starts to perform an initial outlier confirmation on the key values ​​before executing the complete detection process. The initial confirmation is intended to quickly evaluate the overall status of the values ​​and confirm whether they contain outliers. If the initial confirmation value indicates that it contains outliers, the controller will continue to execute the subsequent detection method and then analyze the values ​​to accurately lock the outliers; otherwise, if the initially confirmed representative values ​​do not have outliers, the controller can terminate the subsequent detection process according to specific requirements, thereby saving computing power and processing time. In addition, the operator can also continue to execute the subsequent process when there is no outlier in the initial confirmation, to ensure the comprehensiveness of the detection and find out the hidden outliers of subtle differences. This method is particularly suitable for processing scenes with large amounts of values ​​and limited computing power, or for conditions with high real-time requirements.

[0094] The second approach is:

[0095] Step S3 also includes before calculating the reduction standard deviation:

[0096] Step 3-1: Set the numerical reduction ratio. The numerical reduction ratio can be set by analyzing the corresponding attributes of the outliers in the past in a total manner to ensure that the set value can accurately reflect the outlier characteristics of the value. The following is a method for achieving step 3-1:

[0097] Step 3-1-1: Past value collection: collect the past key values ​​of the set quantity stored in the controller, which contain the detected outliers and non-outliers, to ensure that the collected values ​​are typical and can cover different pumps, different time intervals and various outlier conditions;

[0098] Step 3-1-2: Total analysis: By performing distribution summation on outliers in the past, the variation range and distribution norm of outliers under outlier conditions are determined, which is achieved through methods such as histogram analysis and maximum likelihood estimation;

[0099] Step 3-1-3: Ratio threshold setting: Based on the above total analytical value, determine an appropriate reduction ratio threshold. This threshold is often based on the total attribute of the outlier change. The outlier threshold can be defined by setting a point (such as the first value to the fifth value of the key value sequence) to ensure that changes within the threshold range are identified as outliers;

[0100] Step 3-1-4: Set value determination: Apply the set reduction ratio threshold to the new value set and perform calibration. By comparing the detected outliers with the actual conditions, determine the availability of the threshold and perform relevant adjustments based on the calibration results.

[0101] Step 3-2: Calculate the ratio of the highest value in the reduction queue to the total value of all reductions, and obtain the highest numerical reduction ratio.

[0102] Step 3-3: If the numerical value reduction ratio is lower than the maximum numerical value reduction ratio, then continue to execute the subsequent process, otherwise terminate the process. For example, if the numerical value reduction ratio can be 20, when the maximum numerical value reduction ratio is not less than 20, execute the subsequent step 4 to find out the specific outlier value. When the maximum numerical value reduction ratio is less than 20, terminate the subsequent process.

[0103] like Figure 2 As shown, the water pump data processing system based on the tunnel inclined shaft of the present invention comprises:

[0104] The tunnel inclined shaft is arranged on the reverse slope section, and a water pump is arranged in the reverse slope section for drainage. The sensor and the LCD screen are connected to the controller. The sensor is used to sample the key values ​​of the water pump in the reverse slope section and transmit them to the controller. The controller is used to identify the condition of the water pump by sampling the key values ​​of the water pump in the reverse slope section transmitted. The reverse slope section can be the first reverse slope section.

[0105] The modules running on the controller include:

[0106] A removal module is used to receive the source key values ​​of the water pump, remove useless values, and perform arrangement in order from low to high of the key values ​​to obtain a key value queue;

[0107] A calculation module, which is used to calculate the decrements of the next key value and the previous key value in the key value queue in sequence to obtain a decrement queue, and respectively calculate the ratio of the decrement in the total decrement value to obtain a decrement ratio queue;

[0108] A ratio module, which is used to sequentially calculate the ratio of the standard deviation of the reduction to the total value of the standard deviation of the reduction, and obtain a reduction standard deviation ratio queue;

[0109] A separation module is used to sequentially perform multiplication operations on the key value queue starting from the first key value and each reduction standard deviation ratio of the reduction standard deviation ratio queue to obtain the critical amount of the start point level separation point, and sequentially perform multiplication operations on the key value queue starting from the second key value and each reduction standard deviation ratio of the reduction standard deviation ratio queue to obtain the critical amount of the end point level separation point;

[0110] A mean value module is used to calculate the mean of the critical value of the starting point and the critical value of the end point to obtain the critical value of the outlier separation point;

[0111] The outlier module is used to obtain an outlier queue by comparing the outlier separation point critical quantity and the key value. If there is no outlier in the outlier queue, it is determined that the water pump has no failure. If there is an outlier in the outlier queue, it is determined that the corresponding water pump has a failure. The controller transmits the outlier and the corresponding water pump failure message to the LCD screen for display. The controller can be an industrial computer, a single-chip microcomputer or a PLC.

[0112] The beneficial effects of the present invention are that, compared with the prior art, the technical effects of the present invention include:

[0113] 1. Appropriate numerical detection: The present invention can actively perform outlier detection according to the actual conditions of key numerical values ​​in the water pump, without relying on a pre-defined fixed critical value. By automatically calculating the numerical decrement and the decrement standard deviation, a matching outlier separation point critical value is automatically formed, thereby achieving outlier detection for different numerical intervals and numerical categories;

[0114] 2. Improved detection accuracy: By performing detailed analysis on the reduction and standard deviation of key values, the present invention can accurately identify outliers. Especially in the case of disorderly and diversified distribution of values, the detection method of the present invention is more accurate and reliable than the current critical value method, and can effectively reduce the occurrence of misidentification and under-identification;

[0115] 3. Enhanced compatibility: The outlier analysis method of the present invention is applicable to key values ​​of various categories. Regardless of whether the key values ​​are high or low, higher or lower than zero, they can all be efficiently processed by this method, so that the controller can be widely used in different water pumps and detection scenarios with better compatibility;

[0116] 4. Streamlining controller settings: Current methods often require defining critical values ​​for different pumps or value categories independently, which is complicated and often leads to errors. The active analytical controller of the present invention simplifies the controller setting process by intelligently calculating the critical value of the outlier separation point, reduces the hidden dangers of manual intervention and definition errors, and improves the efficiency of the controller.

[0117] 5. Real-time numerical processing: The present invention can efficiently process a large number of key numerical values ​​generated on the water pump, detect and select outliers in real time, and is suitable for informing and preventing the occurrence of hidden water pump failures in advance.

[0118] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention rather than to limit it. Although the present invention has been described in detail with reference to the above embodiments, those skilled in the art should understand that the specific implementation methods of the present invention can still be modified or replaced by equivalents, and any modifications or equivalent replacements that do not deviate from the spirit and scope of the present invention should be covered within the protection scope of the claims of the present invention.

Claims

1. A method for processing water pump data based on tunnel inclined shaft, characterized in that: include: The sensor samples the key values ​​of the water pump in the reverse slope section and transmits them to the controller. The controller determines the status of the water pump by sampling the key values ​​of the water pump in the reverse slope section. To determine the condition of the water pump is to determine whether the water pump has failed; Methods for determining whether a water pump has failed include: Step 1: Receive the source key values ​​of the water pump, remove useless values, and sort them in descending order of the key values ​​to obtain a key value queue; Step 2: sequentially calculate the decrements of the next key value and the previous key value in the key value queue to obtain a decrement queue, and respectively calculate the ratio of the decrements in the total decrement value to obtain a decrement ratio queue; Step 3: Calculate the ratio of the standard deviation of the reduction to the total value of the standard deviation of the reduction in turn, and obtain the standard deviation ratio queue of the reduction; Step 4: Multiply the key value queue starting from the first key value and each reduction standard deviation ratio of the reduction standard deviation ratio queue in turn to obtain the critical amount of the starting point leveling separation point, and multiply the key value queue starting from the second key value and each reduction standard deviation ratio of the reduction standard deviation ratio queue in turn to obtain the critical amount of the ending point leveling separation point; Step 5: Calculate the mean of the critical value of the starting point and the critical value of the ending point to obtain the critical value of the outlier separation point; Step 6: Obtain the outlier queue by comparing the outlier separation point critical value and the key value. If there is no outlier in the outlier queue, it is determined that the water pump has not failed. If there is an outlier in the outlier queue, it is determined that the corresponding water pump has failed. The controller transmits the message of the outlier and the corresponding water pump failure to the LCD screen for display.

2. The method for processing water pump data based on tunnel inclined shaft according to claim 1 is characterized in that: In step 1, the source key value of the water pump is the key value of the water pump in the reverse slope section transmitted via sampling; the key value of the water pump in the reverse slope section is the speed value of the water pump in the reverse slope section, the working current value of the water pump in the reverse slope section, or the active value of the water pump in the reverse slope section; The sensor is a rotation speed sensor, a current sensor or an active power sensor arranged on the water pump in the reverse slope section.

3. The method for processing water pump data based on tunnel inclined shaft according to claim 2 is characterized in that: In step 1, the source key value of the receiving water pump is the key value of the receiving water pump sampled and transmitted in the set time interval during the working period; In step 1, useless values ​​include NULL values, redundant values, illegal values, and set-period values.

4. The method for processing water pump data based on tunnel inclined shaft according to claim 3 is characterized in that: In step 2, reduce The operational equation is: ; Here, is the key value queue, is the sequence code of the key value in the key value queue, Is the first in the key value queue Key values, Is the first in the key value queue Key values, Is the first in the reduction queue A reduction; In step 2, decrement the total value The operational equation is: ; Here, is the number of key values ​​in the key value queue; In step 2, the reduction ratio The operational equation is: , It is the first The reduction ratio of a reduction.

5. The method for processing water pump data based on tunnel inclined shaft according to claim 4 is characterized in that: In step 3, decrement the standard deviation The operational equation is: , The first The standard deviation of the reduction; In step 3, decrement the total standard deviation The operational equation is: ; In step 3, decrement the standard deviation ratio The operational equation is: , is the standard deviation ratio of the reduction in the first The reduction is within the total standard deviation of all reductions, that is, the first in the reduction standard deviation ratio queue. The ratio of the standard deviation of the reduction.

6. The method for processing water pump data based on tunnel inclined shaft according to claim 5 is characterized in that: In step 4, the starting point is aligned with the separation point critical amount The operational equation is: .

7. The method for processing water pump data based on tunnel inclined shaft according to claim 6 is characterized in that: In step 4, the end point is aligned with the separation point critical amount The operational equation is: .

8. The method for processing water pump data based on tunnel inclined shaft according to claim 7 is characterized in that: In step 5, the outlier separation point critical volume The operational equation is: .

9. The method for processing water pump data based on tunnel inclined shaft according to claim 8 is characterized in that: In step 6, clustering is performed based on the critical value of being below or not below the outlier separation point, the number of key values ​​in each cluster is summed up, and the cluster value with the lower number in a pair of clusters is confirmed to be an outlier, which is specifically: Step 6-1: Take the key value that is not less than the outlier separation point as clustering queue 1; Step 6-2: Take the critical value below the outlier separation point as clustering queue 2; Step 6-3: Treat the clustered queue with a lower number of key values ​​as the outlier queue.

10. A water pump data processing system based on tunnel inclined shaft, characterized in that: include: The tunnel inclined shaft is set on the reverse slope section, and a water pump is set in the reverse slope section for drainage. The sensor and the LCD screen are connected to the controller. The sensor is used to sample the key values ​​of the water pump in the reverse slope section and transmit them to the controller. The controller is used to identify the condition of the water pump through the key values ​​of the water pump in the reverse slope section transmitted by the sampling. The modules running on the controller include: A removal module is used to receive the source key values ​​of the water pump, remove useless values, and perform arrangement in order from low to high of the key values ​​to obtain a key value queue; A calculation module, which is used to calculate the decrements of the next key value and the previous key value in the key value queue in sequence to obtain a decrement queue, and respectively calculate the ratio of the decrement in the total decrement value to obtain a decrement ratio queue; A ratio module, which is used to sequentially calculate the ratio of the standard deviation of the reduction to the total value of the standard deviation of the reduction, and obtain a reduction standard deviation ratio queue; A separation module is used to sequentially perform multiplication operations on the key value queue starting from the first key value and each reduction standard deviation ratio of the reduction standard deviation ratio queue to obtain the critical amount of the start point level separation point, and sequentially perform multiplication operations on the key value queue starting from the second key value and each reduction standard deviation ratio of the reduction standard deviation ratio queue to obtain the critical amount of the end point level separation point; A mean value module is used to calculate the mean of the critical value of the starting point and the critical value of the end point to obtain the critical value of the outlier separation point; The outlier module is used to obtain the outlier queue by comparing the outlier separation point critical value and the key value. If there is no outlier in the outlier queue, it is determined that the water pump has no failure condition. If there is an outlier in the outlier queue, it is determined that the corresponding water pump has a failure condition. The controller transmits the message of the outlier and the corresponding water pump failure condition to the LCD screen for display.

Images