Stepwise timing data matching method, system and device for monitoring equipment operation

Abstract

The application discloses a kind of step timing data matching method, system and device for monitoring equipment operation, the method of the application includes: according to the power consumption data of each device on intelligent electric meter acquisition, obtain the current step timing data group of the equipment in specific time, add data column to the current step timing data group, respectively obtain the current step timing data matrix of each device, carry out horizontal matching operation to the current step timing data matrix of each device, obtain the result of equipment operating condition.The power consumption data is processed by mathematical matching method, realizes the integration of equipment monitoring, visualization, can quickly real-time monitor equipment operating condition, and reduce cost.

Description

Technical Field

[0001] This invention relates to the field of equipment monitoring technology, specifically to a method, system, and apparatus for matching step time-series data for monitoring equipment operation. Background Technology

[0002] Enterprises need to monitor the operating status of equipment to ensure that the equipment operates synchronously and maintain the stability of the enterprise's current operation. Traditional monitoring methods require going to each equipment operating point to collect information, which cannot detect abnormal equipment operation in a timely manner. Therefore, step timing data matching methods, systems and devices for detecting equipment operation have become essential.

[0003] Existing methods rely on visual observation of equipment operation, which suffers from untimely and inaccurate data collection. Installing advanced sensors to monitor equipment operation is prohibitively expensive. The new technology uses a smart meter integrated into the equipment to collect and process current data. Through mathematical fitting calculations, it accurately and in real time determines the equipment's operating status. Summary of the Invention

[0004] In view of this, embodiments of the present invention provide a method, system, and apparatus for matching step time-series data for monitoring equipment operation.

[0005] The present invention adopts the following technical solution:

[0006] A method for matching step time series data during monitoring equipment operation includes the following steps:

[0007] Based on the electricity consumption data collected by the smart meters on each device, a current step timing data set of the device within a specific time period is obtained.

[0008] Add a data column to the current step timing data group to obtain the current step timing data matrix for each device;

[0009] A horizontal matching operation is performed on the current step timing data matrix of each device to obtain the device operating status result.

[0010] As one possible implementation, obtaining the current step timing data set of the device within a specific time period includes the following steps:

[0011] The time of each current step in the device is recorded in the current step time series data column, and the current step time series data column is recorded once every t time.

[0012] Select t1 as the minimum gap time, divide time t into t / t1 parts, and use a bit to record whether a current step occurs during the minimum gap time. If a current step occurs, the bit value of the minimum gap time is 1, otherwise it is 0.

[0013] The noise values ​​in the current step value column of the device are cleaned. If there are non-zero values ​​in the current step value when the device is not running, the non-zero values ​​are deleted. The current step value column with deleted non-zero values ​​is recorded to obtain the current step data column.

[0014] The current step data series is statistically processed to obtain the current step time series data group.

[0015] As one possible implementation, the current step is the transient change of the device current, and the transient change is the change of current exceeding n amperes within a time t2, where time t2 is a value that conforms to the transient change law of current.

[0016] As one possible implementation, the current step data group is obtained by statistical processing based on the data characteristics of the current step data column, including at least the box ID data column, phase data column, and date data column corresponding to the device current step data column.

[0017] As one possible implementation, adding data columns to the current step timing data group to obtain the current step timing data matrix for each device includes the following steps:

[0018] A status data column is added to each group of device current step timing data. The value of the status data column is a value that identifies the device's operating status. If the value of the corresponding bit is greater than 0, it is identified as 1; otherwise, it is identified as 0.

[0019] A new shift comparison data column is added to each group of device current step timing data. The value of the shift comparison data column is the value of the gap time that the status data column is misaligned with.

[0020] A new "judge" column is added to each group of device current step timing data. The value of the "judge" column is the value compared between the "status" column and the "shift" column. If the values ​​of the corresponding data are the same, it is marked as 0; otherwise, it is marked as 1.

[0021] Add an assistant data column to each group of device current step timing data. The value of the assistant data column is the sum of the values ​​of the judge data column.

[0022] As one possible implementation, the status data column is a data column representing the device's operating status, and the value of the status data column is calculated according to the following formula:

[0023]

[0024] Where, f(x) i ) represents the device current step data. When the bit value corresponding to the device current step data is greater than 0, it is marked as 1; otherwise, it is marked as 0. xi is the value of the status data column corresponding to i, and i is the number of rows and columns of the data.

[0025] The shift comparison data column is a value obtained by misaligning the status data column by the specified time interval. The value of the shift comparison data column is calculated according to the following formula:

[0026] g(x i )=f(x i-1 i = 2, 3, 4, ... n

[0027] Wherein, g(x) i ) represents the shift comparison data column, f(x) i-1 ) represents the status data column, x i The value of the status data column corresponding to i is i, where i is the number of rows and columns of the data;

[0028] The judge column is a mathematical value obtained by comparing the status column and the shift column. The value of the judge column is calculated according to the following formula:

[0029]

[0030] Where h(x) i ) represents the judge data column, g(x) i ) represents the shift comparison data column, x i The value of the status data column corresponding to i is i, where i is the number of rows and columns of the data;

[0031] The assistant data column is the sum of the values ​​in the judge data column, and its value is calculated according to the following formula:

[0032]

[0033] Wherein, g(x) i ) represents the auxiliary data column for the assistant, h(x) i) represents the judge's judgment data column, x i The value of the status data column corresponding to i is i, where i is the number of rows and columns of the data.

[0034] As one possible implementation, the lateral matching operation includes the following steps:

[0035] The status data column of the device is used as the vertical axis, and the assistant data column of the device is used as the horizontal axis to create a current time series line chart.

[0036] The current time sequence line charts of the two devices are fitted and regression analyzed to obtain the fitting function. The fitting function is compared. If the comparison result exceeds the preset threshold, it indicates that the two devices are not operating synchronously.

[0037] A system for matching step time series data of monitoring equipment operation includes a data acquisition module, a data processing module, and a data diagnosis module;

[0038] The data acquisition module is used to obtain the current step data group of the device based on the historical power consumption data of the device.

[0039] The data processing module adds data columns to the current step timing data group according to a preset mathematical matching method, thereby obtaining the current step timing data matrix for each device.

[0040] The data diagnostic module determines the operating status of the device by performing a horizontal matching operation on the data columns of the current step timing data matrix.

[0041] A step timing data matching device for monitoring equipment operation includes a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, it implements the following method:

[0042] Based on the electricity consumption data collected by the smart meters on each device, a current step timing data set of the device within a specific time period is obtained.

[0043] Add a data column to the current step timing data group to obtain the current step timing data matrix for each device;

[0044] A horizontal matching operation is performed on the current step timing data matrix of each device to obtain the device operating status result.

[0045] A readable storage medium storing information for performing the following method:

[0046] Based on the electricity consumption data collected by the smart meters on each device, a current step timing data set of the device within a specific time period is obtained.

[0047] Add a data column to the current step timing data group to obtain the current step timing data matrix for each device;

[0048] A horizontal matching operation is performed on the current step timing data matrix of each device to obtain the device operating status result.

[0049] The advantages of this invention are that it can save manpower and material resources, and it uses mathematical methods and power consumption data of the equipment to calculate the synchronous operation status of the equipment, which reduces the difficulty of implementation and makes it scalable and implementable. Attached Figure Description

[0050] Figure 1 A flowchart of the method of the present invention is provided for an embodiment of the present invention;

[0051] Figure 2 A schematic diagram of the system of the present invention is provided for an embodiment of the present invention. Detailed Implementation

[0052] Although embodiments of the present invention have been clearly described, those skilled in the art can make various changes, modifications, substitutions and variations to these embodiments without departing from the principles and spirit of the inventive method. These variations still fall within the scope of the method described in the present invention and are still protected by patent.

[0053] In the description of this specification, the terms "comprising," "including," "having," and "containing" are open-ended terms, meaning they include but are not limited to. The illustrative expressions of the above terms in this specification do not necessarily refer to the same embodiments or examples. Furthermore, the specific features, structures, or characteristics described may be combined in any suitable manner in one or more embodiments or examples. The order of steps involved in the various embodiments is used to illustrate the implementation of this application, and the order of steps is not limited and can be adjusted appropriately as needed.

[0054] Example 1: A method for matching step time-series data during the operation of monitoring equipment according to an embodiment of the present invention, such as... Figure 1 As shown, it includes the following steps:

[0055] S100. Based on the electricity consumption data collected by the smart meter on each device, obtain the current step timing data group of the device within a specific time period.

[0056] S200: Add data columns to the current step timing data group to obtain the current step timing data matrix of each device;

[0057] S300. Perform a horizontal matching operation on the current step timing data matrix of each device to obtain the matching result of the device operating status.

[0058] This technical solution can improve the problems of untimely and inaccurate monitoring in the current technology. Through horizontal matching calculation, it can accurately know the operating status of the two devices.

[0059] In step S100, the electricity consumption data collected by the smart meter may be, but is not limited to, daily electricity consumption data collected on a daily basis.

[0060] As an example, the electricity consumption data is daily electricity consumption data for a duration of n days, that is, daily electricity consumption data S=[X1,X2,...,Xn-1], where X1 represents the time of the first day, X2 represents the time of the second day, and so on.

[0061] In step S200, the current step time series data column may be recorded once every 24 hours, or the minimum gap time may be selected as 1 minute. The device current step is the transient change of the device current. The transient change of current may be, but is not limited to, a change of current exceeding 5 amperes within 0.02s. The data characteristics of the current step data column are statistically processed, including feature data such as, but not limited to, meter box ID data column, phase data column, and date data column.

[0062] For example, if the current step timing matrix collects power data as electricity data with a 24-hour duration and a 1-minute interval, then a total of 1440 data items are obtained, including at least the current step timing data column, the meter box ID data column, the phase data column, the date data column, and the bit value column, and the current step timing data group is arranged in the time sequence.

[0063] In step S300, it may be, but is not limited to, performing a horizontal matching operation between production equipment and environmental protection equipment, and may be, but is not limited to, adding the following data columns;

[0064] As an example, the current time series data matrix Ix1 of the production equipment in the 24 hours of the meter box with ID 001 and phase x1 is obtained, and the current time series data matrix Ix2 of the environmental protection equipment in the 24 hours of the meter box with ID 002 and phase x2 is obtained.

[0065] Add a status data column to each group of device current step timing data, which is a data column containing 1440 items consisting of consecutive 0s and 1s;

[0066] Add a shift comparison data column to each group of device current step timing data, which is a data column containing 1440 items consisting of consecutive 0s and 1s;

[0067] Add a judge data column to each group of device current step timing data, which is a data column containing 1440 items consisting of consecutive 0s and 1s;

[0068] Add an assistant data column to each group of device current step timing data. The value of the assistant data column is the sum of the values ​​of the judge data column.

[0069] For example, selecting devices with meter box IDs 001 and 002, performing regression analysis on the current time series line charts of these two devices to obtain a fitting function, and comparing the fitting functions, we obtain y = a1x 2 +b1x+c1,R 2 =k1 and y=a2x 2 +b²x+c², R 2 If the two polynomials = k2 are compared, and a1 and a2, k1 and k2 are compared, and the results exceed the function fitting threshold range of the device, it indicates that the device is not operating synchronously.

[0070] In another embodiment, the status data column is a data column representing the device's operating status, and the value of the status data column is calculated according to the following formula: Where, f(x) i The step data of the device current is defined as follows: when the bit value corresponding to the step data of the device current is greater than 0, it is marked as 1; otherwise, it is marked as 0. i The value of the status data column corresponding to i is i, where i is the number of rows and columns of the data;

[0071] The shift comparison data column is the value obtained by misaligning the status data column by the t1 interval time. The value of the shift comparison data column is calculated according to the following formula: g(x i )=f(x i-1 ) i = 2, 3, 4, ... n where g(x i ) represents the shift comparison data column, f(x) i-1 ) represents the status data column, x i The value of the status data column corresponding to i is i, where i is the number of rows and columns of the data;

[0072] The `judge` column is a mathematical value compared to the `status` column and the `shift` column. The value of the `judge` column is calculated using the following formula: Where h(x) i ) represents the judge data column, g(x) i) represents the shift comparison data column, x i The value of the status data column corresponding to i is i, where i is the number of rows and columns of the data;

[0073] The assistant data column is the sum of the values ​​in the judge data column. The value of the assistant data column is calculated according to the following formula: Wherein, g(x) i ) represents the auxiliary data column for the assistant, h(x) i ) represents the judge's judgment data column, x i The value of the status data column corresponding to i is i, where i is the number of rows and columns of the data.

[0074] The horizontal matching operation method is as follows: the status data column of the device is used as the vertical axis, and the assistant data column of the device is used as the horizontal axis. A current time series line chart of the device is established. Two devices are selected, and the current time series line charts of the two devices are input into the computer system for fitting regression analysis to obtain the fitting function. The fitting functions are compared. If the difference in the function terms exceeds the threshold, it means that the devices are not running synchronously.

[0075] Example 2:

[0076] A step time series data matching system for monitoring equipment operation, such as Figure 2 As shown, it includes:

[0077] The data acquisition module 100 is used to obtain the current step data group of the device based on the historical power consumption data of the device.

[0078] The data processing module 200 adds data columns to the current step timing data group according to a preset mathematical matching method, thereby obtaining the current step timing data matrix for each device.

[0079] The data diagnostic module 300 performs a horizontal matching operation on the data columns of the current step timing data matrix to obtain the operating range of the device, compares the operating range of each device, and determines the operating status of the device.

[0080] As the device embodiment is basically similar to the method embodiment, the description is relatively simple, and relevant parts can be found in the description of the method embodiment.

[0081] The various embodiments in this specification are described in a progressive manner, with each embodiment focusing on the differences from other embodiments. The same or similar parts between the various embodiments can be referred to each other.

[0082] Those skilled in the art will understand that embodiments of the present invention can be provided as methods, apparatus, or computer program products. Therefore, the present invention can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, the present invention can take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0083] This invention is described with reference to flowchart illustrations and / or block diagrams of the method, terminal device (system), and computer program product according to the invention. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing terminal device to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing terminal device, generate instructions for implementing the flowchart illustrations and / or block diagrams. Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.

[0084] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing terminal device to operate in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.

[0085] These computer program instructions can also be loaded onto a computer or other programmable data processing terminal equipment, causing a series of operational steps to be performed on the computer or other programmable terminal equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable terminal equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the function specified in one or more boxes.

[0086] The specific embodiments described above further illustrate the purpose, technical solution, and beneficial effects of the present invention. It should be understood that the above descriptions are merely specific embodiments of the present invention and are not intended to limit the scope of protection of the present invention. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the present invention should be included within the scope of protection of the present invention.

Claims

1. A method for matching step time series data during the operation of monitoring equipment, characterized in that, Includes the following steps: Based on the electricity consumption data collected by the smart meters on each device, a current step timing data set of the device within a specific time period is obtained. Add a data column to the current step timing data group to obtain the current step timing data matrix for each device; Specifically: Add a "status" column to each group of device current step timing data. The value of the "status" column is... The numerical value used to indicate the device's operating status is marked as 1 if the value of the corresponding bit is greater than 0, and as 0 otherwise. Add a shift comparison data column to each group of device current step timing data. The value of the shift comparison data column is the value of the misalignment gap time of the status data column. A new "judge" column is added to each group of device current step timing data. The value of the "judge" column is the value compared between the "status" column and the "shift" column. If the values ​​of the corresponding data are the same, it is marked as 0; otherwise, it is marked as 1. Add an assistant data column to each group of device current step timing data. The value of the assistant data column is the sum of the values ​​of the judge data column. A horizontal matching operation is performed on the current step timing data matrix of each device to obtain the device operating status result.

2. The step time series data matching method for monitoring equipment operation according to claim 1, characterized in that, Obtaining the current step timing data set of the device within a specific time period includes the following steps: The time of each current step in the device is recorded in the current step time series data column, and the current step time series data column is recorded once every t time. Select t1 as the minimum gap time, divide time t into t / t1 parts, and use a bit to record whether a current step occurs during the minimum gap time. If a current step occurs, the bit value of the minimum gap time is 1, otherwise it is 0. The noise values ​​in the current step value column of the device are cleaned. If there are non-zero values ​​in the current step value when the device is not running, the non-zero values ​​are deleted. The current step value column with deleted non-zero values ​​is recorded to obtain the current step data column. The current step data series is statistically processed to obtain the current step time series data group.

3. The step time series data matching method for monitoring equipment operation according to claim 2, characterized in that, The current step refers to the transient change in the device current, and the transient change is the change in current exceeding n amperes within a time interval t2, where t2 is a value that conforms to the transient change law of current.

4. The step time series data matching method for monitoring equipment operation according to claim 2, characterized in that, The current step data group is obtained by statistical processing based on the data characteristics of the current step data column, and includes at least the box ID data column, phase data column, and date data column corresponding to the device current step data column.

5. The step time series data matching method for monitoring equipment operation according to claim 1, characterized in that, The status data column represents the device's operating status. The value of the status data column is calculated using the following formula: in, The step data represents the device current. A bit value greater than 0 is identified as 1, otherwise it is identified as 0. To and The corresponding value in the status data column. The number of rows and columns of the data; The shift comparison data column is a value obtained by misaligning the status data column by the specified time interval. The value of the shift comparison data column is calculated according to the following formula: in, For the shift comparison data column, For the status data column, To and The corresponding value in the status data column. The number of rows and columns of the data; The judge column is a mathematical value obtained by comparing the status column and the shift column. The value of the judge column is calculated according to the following formula: in, For the judge data column, For the shift comparison data column, To and The corresponding value in the status data column. The number of rows and columns of the data; The assistant data column is the sum of the values ​​in the judge data column, and its value is calculated according to the following formula: in, For the auxiliary data column of the assistant, For the judge data column, To and The corresponding value in the status data column. This represents the number of rows and columns of the data.

6. The step time series data matching method for monitoring equipment operation according to claim 1, characterized in that, The horizontal matching operation includes the following steps: The status data column of the device is used as the vertical axis, and the assistant data column of the device is used as the horizontal axis to create a current time series line chart. The current time sequence line charts of the two devices are fitted and regression analyzed to obtain the fitting function. The fitting function is compared. If the comparison result exceeds the preset threshold, it indicates that the two devices are not operating synchronously.

7. A system for matching step time-series data during monitoring equipment operation, characterized in that, It includes a data acquisition module, a data processing module, and a data diagnostic module; The data acquisition module is used to obtain the current step data group of the device based on the historical power consumption data of the device. The data processing module adds data columns to the current step timing data group according to a preset mathematical matching method, thereby obtaining the current step timing data matrix for each device. The data diagnostic module determines the operating status of the device by performing a horizontal matching operation on the data columns of the current step timing data matrix.

8. A step timing data matching device for monitoring equipment operation, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that, When the processor executes the computer program, it implements the method as described in any one of claims 1 to 6.

9. A readable storage medium, characterized in that, The readable storage medium stores the method for performing any one of claims 1 to 6.

Images