CN117216048A - Screening method, screening device, screening equipment and storage medium for monitoring data of electromechanical equipment - Google Patents
Screening method, screening device, screening equipment and storage medium for monitoring data of electromechanical equipment Download PDFInfo
- Publication number
- CN117216048A CN117216048A CN202311182023.4A CN202311182023A CN117216048A CN 117216048 A CN117216048 A CN 117216048A CN 202311182023 A CN202311182023 A CN 202311182023A CN 117216048 A CN117216048 A CN 117216048A
- Authority
- CN
- China
- Prior art keywords
- data
- abnormal
- monitoring
- equipment
- electromechanical
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000012544 monitoring process Methods 0.000 title claims abstract description 185
- 238000012216 screening Methods 0.000 title claims abstract description 49
- 238000000034 method Methods 0.000 title claims abstract description 45
- 238000003860 storage Methods 0.000 title claims abstract description 29
- 230000002159 abnormal effect Effects 0.000 claims abstract description 161
- 238000012545 processing Methods 0.000 claims abstract description 67
- 238000010586 diagram Methods 0.000 claims description 12
- 238000004458 analytical method Methods 0.000 claims description 9
- 238000009826 distribution Methods 0.000 claims description 8
- 238000004590 computer program Methods 0.000 claims description 5
- 230000002547 anomalous effect Effects 0.000 claims 1
- 238000007405 data analysis Methods 0.000 abstract description 3
- 230000000694 effects Effects 0.000 abstract description 2
- 238000004891 communication Methods 0.000 description 5
- 230000006870 function Effects 0.000 description 5
- 238000012806 monitoring device Methods 0.000 description 5
- 238000005516 engineering process Methods 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 238000006073 displacement reaction Methods 0.000 description 2
- 239000000284 extract Substances 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000002093 peripheral effect Effects 0.000 description 2
- KLDZYURQCUYZBL-UHFFFAOYSA-N 2-[3-[(2-hydroxyphenyl)methylideneamino]propyliminomethyl]phenol Chemical compound OC1=CC=CC=C1C=NCCCN=CC1=CC=CC=C1O KLDZYURQCUYZBL-UHFFFAOYSA-N 0.000 description 1
- 241001310793 Podium Species 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 239000003245 coal Substances 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 201000001098 delayed sleep phase syndrome Diseases 0.000 description 1
- 208000033921 delayed sleep phase type circadian rhythm sleep disease Diseases 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000036541 health Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000000717 retained effect Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
Landscapes
- Testing Or Calibration Of Command Recording Devices (AREA)
Abstract
The application relates to a screening method, a screening device, screening equipment and a storage medium for monitoring data of electromechanical equipment, belonging to the technical field of data analysis, wherein the screening method comprises the following steps: acquiring a database to be stored, wherein the database to be stored comprises electromechanical equipment monitoring data uploaded by monitoring equipment; screening electromechanical equipment monitoring data in the database to be stored to obtain data to be processed, wherein the data to be processed comprises repeated data and abnormal data; analyzing the data to be processed to obtain a processing mode, wherein the processing mode comprises deleting the data to be processed from the database to be stored; and processing the data to be processed based on the processing mode. The application has the effect of reducing the storage pressure of the computer.
Description
Technical Field
The present application relates to the field of data analysis technologies, and in particular, to a method, an apparatus, a device, and a storage medium for screening monitoring data of an electromechanical device.
Background
With the development of big data technology, more and more enterprises pay attention to analysis of historical monitoring data of the electromechanical equipment so as to quantitatively evaluate the on-line health state of the electromechanical equipment in real time and discover abnormal conditions of the operation of the electromechanical equipment in time.
Currently, sensors are typically installed on an electromechanical device, and the operating parameters of the electromechanical device are collected by the sensors, and the computer stores all the collected operating parameters in a database. However, the operation data collected by the sensor may have a large amount of repeated data or invalid abnormal data, and the data has no effect on the analysis of the operation condition of the electromechanical equipment, and occupies a large amount of memory of the computer, so that the storage pressure of the computer is greatly increased.
Disclosure of Invention
In order to reduce the storage pressure of a computer, the application provides a method, a device, equipment and a storage medium for screening monitoring data of electromechanical equipment.
In a first aspect, the present application provides a screening method for monitoring data of an electromechanical device, which adopts the following technical scheme:
an electromechanical device monitoring data screening method, comprising:
acquiring a database to be stored, wherein the database to be stored comprises electromechanical equipment monitoring data uploaded by monitoring equipment;
screening electromechanical equipment monitoring data in the database to be stored to obtain data to be processed, wherein the data to be processed comprises repeated data and abnormal data;
analyzing the data to be processed to obtain a processing mode, wherein the processing mode comprises deleting the data to be processed from the database to be stored;
and processing the data to be processed based on the processing mode.
By adopting the technical scheme, the electromechanical equipment monitoring data in the database to be stored is screened, so that the data to be processed comprising the repeated data and the abnormal data is determined, the data to be processed is analyzed to obtain the processing mode of the data to be processed, and the invalid abnormal data and the repeated data are deleted by processing the data to be processed in the processing mode, so that the storage pressure of a computer is reduced.
Optionally, the screening the electromechanical device monitoring data in the database to be stored includes:
grouping the electromechanical device monitoring data based on a preset time period to obtain a plurality of data groups;
acquiring a data threshold corresponding to the electromechanical device monitoring data;
querying each of the data packets for the presence of electromechanical device monitoring data greater than the data threshold;
if electromechanical equipment monitoring data larger than the data threshold exists, the electromechanical equipment monitoring data larger than the data threshold is used as the abnormal data;
inquiring whether electromechanical equipment monitoring data with a numerical value difference value within a preset range exists in the data packet;
if the electromechanical equipment monitoring data with the numerical value difference in the preset range exists, extracting all the electromechanical equipment monitoring data with the numerical value difference in the preset range, and taking the extracted electromechanical equipment monitoring data as the repeated data.
By adopting the technical scheme, abnormal data are screened through the data threshold value, repeated data are screened through the value difference value in the preset range, and data to be processed are determined through the abnormal data and the repeated data, so that the screening of the electromechanical equipment monitoring data in the database to be stored is facilitated.
Optionally, if the data to be processed is duplicate data, analyzing the data to be processed to obtain a processing mode, including:
acquiring monitoring time corresponding to the repeated data in each data packet;
judging whether the monitoring time corresponding to the repeated data forms a continuous time period or not;
if yes, determining that the processing mode is to store one of the repeated data, and generating the data to be stored based on the stored repeated data and the time period.
By adopting the technical scheme, when the repeated data exist and the monitoring time corresponding to the repeated data forms a continuous time period, only one of the repeated data is reserved, and the reserved repeated data and the time period are used for generating the data to be stored, so that the data quantity stored by the computer is reduced, and the storage pressure of the computer is further reduced.
Optionally, if the data to be processed is abnormal data, the analyzing the data to be processed includes:
acquiring a first total number of electromechanical device monitoring data and a second total number of abnormal data in each data packet;
calculating a number ratio of the first total to the second total;
judging that the number ratio is smaller than a ratio threshold;
if the monitoring time is smaller than the ratio threshold, inquiring whether the monitoring time corresponding to the abnormal data is in a first preset time period or not;
and if the abnormal data is not in the first preset time period, determining the processing mode to delete the abnormal data in the data packet.
By adopting the technical scheme, whether the abnormal data can be deleted or not is determined through the relation between the quantity ratio, the ratio threshold value and the monitoring time and the first preset time period, so that the possibility that invalid abnormal data occupy the storage space of the computer is reduced.
Optionally, if the first preset time period is in the first preset time period, the method includes:
acquiring a packet number of the data packet;
determining a data packet adjacent to the packet number based on the first preset time period;
the electromechanical device monitoring data of adjacent data groups in a second preset time period are used as comparison data;
judging whether the comparison data can be combined with the abnormal data or not;
if yes, determining that the processing mode is to merge the abnormal data into the data packet adjacent to the packet number.
By adopting the technical scheme, when the monitoring time corresponding to the abnormal data is in the first preset time period, the comparison data in the second preset time period of the adjacent data packet is used for judging, so that whether the comparison data and the abnormal data can be combined or not is determined, and when the abnormal data and the comparison data are combined, the stored data volume is reduced, and further the storage space of a computer is saved.
Optionally, if the ratio is greater than the ratio threshold, the method further includes:
acquiring electromechanical equipment corresponding to abnormal data, and taking the electromechanical equipment corresponding to the abnormal data as equipment to be analyzed;
acquiring an electromechanical device distribution diagram;
determining comparison equipment of the equipment to be analyzed in a preset range based on the electromechanical equipment distribution diagram;
inquiring whether the electromechanical equipment monitoring data of the comparison equipment is abnormal in the monitoring time corresponding to the abnormal data;
if so, judging whether the electromechanical equipment monitoring data of the equipment to be analyzed and the comparison equipment have correlation;
if the correlation exists, determining the processing mode based on the first abnormal time when the comparison equipment starts to generate abnormal data and the second abnormal time when the equipment to be analyzed starts to generate abnormal data.
Optionally, the determining the processing manner based on the first abnormal time when the comparison device starts to generate the abnormal data and the second abnormal time when the device to be analyzed starts to generate the abnormal data includes:
when the first abnormal time is earlier than the second abnormal time, calculating a time difference value between the first abnormal time and the second abnormal time;
judging whether the time difference value is larger than a preset value or not;
if yes, determining the processing mode to delete the abnormal data in the data packet.
By adopting the technical scheme, when the first abnormal time of the comparison equipment is earlier than the second abnormal time and the time difference between the first abnormal time and the second abnormal time is larger than the preset value, the abnormal data generated by the equipment to be analyzed is determined to be caused by the comparison equipment, and the abnormal data is deleted in the data packet at the moment, so that the storage space of the computer is saved.
In a second aspect, the application provides an electromechanical device monitoring data screening device, which adopts the following technical scheme:
an electromechanical device monitoring data screening apparatus, comprising:
the acquisition module is used for acquiring a database to be stored, wherein the database to be stored comprises electromechanical equipment monitoring data uploaded by monitoring equipment;
the screening module is used for screening the electromechanical equipment monitoring data in the database to be stored to obtain data to be processed, wherein the data to be processed comprises repeated data and abnormal data;
the analysis module is used for analyzing the data to be processed to obtain a processing mode, wherein the processing mode comprises deleting the data to be processed from the database to be stored;
and the processing module is used for processing the data to be processed based on the processing mode.
By adopting the technical scheme, the electromechanical equipment monitoring data in the database to be stored is screened, so that the data to be processed comprising the repeated data and the abnormal data is determined, the data to be processed is analyzed to obtain the processing mode of the data to be processed, and the invalid abnormal data and the repeated data are deleted by processing the data to be processed in the processing mode, so that the storage pressure of a computer is reduced.
In a third aspect, the present application provides an electronic device, which adopts the following technical scheme:
an electronic device comprising a processor and a memory, the processor coupled with the memory;
the processor is configured to execute a computer program stored in the memory to cause the electronic device to perform the method according to any one of the first aspects.
In a fourth aspect, the present application provides a computer readable storage medium, which adopts the following technical scheme:
a computer readable storage medium comprising a computer program or instructions which, when run on a computer, cause the computer to perform the method of any of the first aspects.
Drawings
Fig. 1 is a flow chart of a screening method for monitoring data of an electromechanical device according to an embodiment of the present application.
Fig. 2 is a schematic flow chart of screening abnormal data according to an embodiment of the present application.
Fig. 3 is a flowchart illustrating a specific step of step S16 according to an embodiment of the present application.
Fig. 4 is a flowchart illustrating a specific step of step S17 in the embodiment of the present application.
Fig. 5 is a block diagram of a screening device for monitoring data of an electromechanical device according to an embodiment of the present application.
Fig. 6 is a block diagram of an electronic device embodying an embodiment of the present application.
Detailed Description
The present application will be described in further detail with reference to the accompanying drawings.
The present embodiment is only for explanation of the present application and is not to be construed as limiting the present application, and modifications to the present embodiment, which may not creatively contribute to the present application as required by those skilled in the art after reading the present specification, are all protected by patent laws within the scope of claims of the present application.
For the purpose of making the objects, technical solutions and advantages of the embodiments of the present application more apparent, the technical solutions of the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present application, and it is apparent that the described embodiments are some embodiments of the present application, but not all embodiments of the present application. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.
In addition, the term "and/or" herein is merely an association relationship describing an association object, and means that three relationships may exist, for example, a and/or B may mean: a exists alone, A and B exist together, and B exists alone. In this context, unless otherwise specified, the term "/" generally indicates that the associated object is an "or" relationship.
Embodiments of the application are described in further detail below with reference to the drawings.
The embodiment of the application provides an electromechanical device monitoring data screening method, which can be executed by electronic equipment, wherein the electronic equipment can be a server or terminal equipment, and the server can be an independent physical server, a server cluster or a distributed system formed by a plurality of physical servers, or a cloud server for providing cloud computing service. The terminal device may be, but is not limited to, a smart phone, a tablet computer, a desktop computer, etc.
As shown in fig. 1, a method for screening monitoring data of an electromechanical device is described as follows (steps S101 to S104):
step S101, acquiring a database to be stored, wherein the database to be stored comprises electromechanical equipment monitoring data uploaded by monitoring equipment;
in this embodiment, the monitoring device uploads the monitored monitoring data of the electromechanical device to the electronic device in real time, where the monitoring device includes, but is not limited to, a sensor for monitoring the electromechanical device, for example, a vibration sensor, a displacement sensor, a temperature sensor, and the like, and the monitoring data of the electromechanical device includes operation parameters of the electromechanical device, which include, but are not limited to, a vibration parameter, a displacement parameter, and a temperature parameter, and the electromechanical device may be a device in a factory or a device in coal mine production, which is not limited specifically.
And uploading the electromechanical device monitoring data to the electronic device by the monitoring device in real time, and storing the received electromechanical device monitoring data into a database to be stored by the electronic device.
In particular, when the electromechanical device monitoring data is abnormal, the operations of sending the early warning information to the staff and storing the electromechanical device monitoring data in the database to be stored may be performed simultaneously.
Step S102, screening electromechanical equipment monitoring data in a database to be stored to obtain data to be processed, wherein the data to be processed comprises repeated data and abnormal data;
specifically, the electromechanical device monitoring data are grouped based on a preset time period to obtain a plurality of data groups; acquiring a data threshold corresponding to monitoring data of the electromechanical equipment; inquiring whether electromechanical device monitoring data greater than a data threshold exists in each data packet; if electromechanical equipment monitoring data larger than the data threshold exists, the electromechanical equipment monitoring data larger than the data threshold is used as abnormal data; inquiring whether electromechanical equipment monitoring data with a numerical value difference value within a preset range exists in the data packet; if the electromechanical device monitoring data with the numerical value difference in the preset range exists, extracting all the electromechanical device monitoring data with the numerical value difference in the preset range, and taking the extracted electromechanical device monitoring data as repeated data.
In this embodiment, the electronic device needs to screen the data in the database to be stored, where the electromechanical device monitoring data to be screened includes two types, repeated data and abnormal data.
When screening the electromechanical equipment monitoring data in the database to be stored, the electromechanical equipment monitoring data of the database to be stored is required to reach a certain quantity, and then the data monitoring data of the database to be stored is screened, so that the screening times are reduced, and the screening efficiency is improved.
The manner of achieving a certain number may be determined by monitoring the duration, and when the duration of monitoring the data by the electromechanical device stored in the database to be stored reaches the preset duration, the data in the database to be stored is screened, for example, the preset duration may be 1 hour or 2 hours, which is not limited specifically.
When the data in the database to be stored needs to be screened, dividing the electromechanical device monitoring data into a plurality of data packets, wherein the preset time period can be 1 minute or 2 minutes, and the data packets are numbered according to time sequence when the electromechanical device monitoring data are divided into the plurality of data packets without specific limitation.
Wherein, each type of electromechanical device monitors data and each type of electromechanical device corresponds to a corresponding data threshold. And in the database to be stored, different types of electromechanical equipment monitoring data are stored in a classified mode, and corresponding data thresholds are determined according to electromechanical equipment and types corresponding to the electromechanical equipment monitoring data.
In this embodiment, all data packets may be screened simultaneously to obtain abnormal data, so as to improve screening efficiency.
For the screening of the repeated data, searching electromechanical device monitoring data, wherein the difference value between the electromechanical device monitoring data and the first data in the data packet is in a preset range, and taking the electromechanical device monitoring data as the repeated data, for example, the data in the data packet are respectively 10, 11, 12 and 11, and when the preset range is 0-1, the 10 and 11 belong to the repeated data.
In particular, the electromechanical device monitoring data includes not only the operating parameters of the device, but also the monitoring time corresponding to the operating parameters.
Step S103, analyzing the data to be processed to obtain a processing mode, wherein the processing mode comprises deleting the data to be processed in a database to be stored;
step S104, processing the data to be processed based on the processing mode.
Wherein the data to be processed includes abnormal data and repeated data, the repeated data and the abnormal data are respectively described below.
1. Repeating data
Specifically, acquiring monitoring time corresponding to repeated data in each data packet; judging whether the monitoring time corresponding to the repeated data forms a continuous time period or not; if yes, determining that the processing mode is to store one of the repeated data, and generating the data to be stored based on the stored repeated data and the time period.
In this embodiment, the monitoring time corresponding to the repeated data in each data packet is extracted, and the monitoring time is analyzed, so that it is determined that the monitoring time corresponding to the repeated data is a continuous time period, and when the monitoring time is a continuous time period, it may be determined that the repeated data is deleted, only one data is reserved, and the saved repeated data and the time period corresponding to the repeated data together form one data to be stored, so that the data amount stored in the database to be stored is reduced.
(II) abnormal data
Specifically, as shown in fig. 2, the method comprises the following steps (steps S11 to S17):
step S11, obtaining a first total number of electromechanical device monitoring data and a second total number of abnormal data in each data packet;
step S12, calculating the number ratio of the first total number to the second total number;
in this embodiment, when the electronic device screens out abnormal data, a first total number of electromechanical device monitoring data and a second total number of abnormal data in each group of data packets are counted, the first total number is used as a packet, and the second total number is used as a numerator calculation number ratio.
Step S13, judging that the number ratio is smaller than a ratio threshold; if yes, executing step S16, otherwise executing step S14;
and when the electronic equipment obtains the quantity ratio, comparing the quantity ratio with the ratio threshold so as to determine whether the abnormal data has an influence on the electromechanical equipment monitoring data in the data packet, wherein the ratio threshold can be 1/100.
Step S14, inquiring whether the monitoring time corresponding to the abnormal data is in a first preset time period or not; if yes, executing step S17, otherwise executing step S15;
in this embodiment, the first preset time period refers to a start time period and an end time period in the data packet, for example, a monitoring time period included in one of the data packets is 1: 00-2: 00, the monitoring time period corresponding to the abnormal data is 1:00-1:10, and at the moment, the monitoring time corresponding to the abnormal data is judged to be in a first preset time period; the monitoring time period corresponding to the abnormal data is 1:50-2:00, and at the moment, the monitoring time corresponding to the abnormal data is judged to be in a first preset time period.
In step S15, the processing manner is determined such that the abnormal data is deleted in the data packet.
In this embodiment, the abnormal data is not in the first preset time, which proves that the abnormal data has no influence on the overall operation condition of the electromechanical device, and may be a false detection of the monitoring device, and the data analysis is not effective, so that the abnormal data is deleted in the data packet.
As shown in fig. 3, step S16 includes the following steps (steps S21 to S27):
step S21, electromechanical equipment corresponding to the abnormal data is obtained, and the electromechanical equipment corresponding to the abnormal data is used as equipment to be analyzed;
in this embodiment, the electronic device obtains an electromechanical device corresponding to the abnormal data, and uses the obtained electromechanical device as the device to be analyzed, where the device to be analyzed may be identified by a name or a number of the electromechanical device.
Step S22, acquiring an electromechanical equipment distribution diagram;
step S23, determining comparison equipment of equipment to be analyzed in a preset range based on an electromechanical equipment distribution diagram;
in this embodiment, the electromechanical device profile is stored in the electronic device, where the electromechanical device profile may be a plan view, or may be a three-dimensional view, which is not limited specifically.
The electromechanical devices in the same workshop can have mutual influence, and when one of the electromechanical device monitoring data is abnormal, the other electromechanical devices can be influenced, so that the electromechanical device monitoring data of the other electromechanical devices are abnormal.
For example, the operating temperature of the mechatronic device, when the temperature of one of the mechatronic devices is too high, the temperature of the mechatronic device surrounding the mechatronic device is affected by the one of the mechatronic devices, resulting in an abnormal temperature of the mechatronic device surrounding the one of the mechatronic device.
In this embodiment, a circular area with a radius of 20 meters may be used as a preset range by using the position of the device to be analyzed as the center of a circle, and other methods may be used, which are not specifically limited in this embodiment.
The electronic device extracts all electromechanical devices within a preset range, and uses the extracted electromechanical devices as comparison devices, wherein the identification of the comparison devices can be the names or numbers of the electromechanical devices, and the identification is not particularly limited.
Step S24, inquiring whether the electromechanical equipment monitoring data of the comparison equipment is abnormal in the monitoring time corresponding to the abnormal data; if yes, executing step S25, otherwise executing step S27;
in this embodiment, the electronic device acquires a monitoring time when the device to be analyzed starts to generate abnormal data and an ending time when the abnormal data disappears, extracts electromechanical device monitoring data of all comparison devices between the starting time and the ending data, uses the electromechanical device monitoring data of the comparison devices as reference data, and determines that the electromechanical device monitoring data of the comparison devices are abnormal when reference data larger than a data threshold exists in the reference data.
Step S25, judging whether correlation exists between electromechanical equipment monitoring data of equipment to be analyzed and comparison equipment; if yes, executing step S26, otherwise executing step S27;
the method for judging whether the electromechanical device monitoring data of the device to be analyzed and the comparison device have correlation may be as follows:
the method comprises the steps of obtaining a first electromechanical device monitoring operation parameter of the to-be-analyzed device independently operated within a period of time, and obtaining a second electromechanical device monitoring operation parameter of the to-be-analyzed device within a period of time when the workshop electromechanical devices are operated together, wherein the period of time can be one hour or half an hour, and the method is not particularly limited.
Calculating a first average value of the first electromechanical device monitoring operation parameters and a second average value of the second electromechanical device monitoring operation parameters, calculating a data difference value of the first average value and the second average value, judging whether the data difference value is larger than a preset value, if so, judging that the electromechanical device monitoring data of the device to be analyzed and the electromechanical device monitoring data of the comparison device have correlation, wherein the preset value can be 1, and can be set according to the requirement, and the correlation is not particularly limited.
Step S26, determining a processing mode based on the first abnormal time when the abnormal data starts to appear in the comparison equipment and the second abnormal time when the abnormal data starts to appear in the equipment to be analyzed.
Specifically, when the first abnormal time is earlier than the second abnormal time, calculating a time difference value between the first abnormal time and the second abnormal time; judging whether the time difference value is larger than a preset value or not; if yes, determining the processing mode to delete the abnormal data in the data packet.
In this embodiment, when there is a correlation between the comparison device and the device to be analyzed, it is proved that the operation parameters of the comparison device have an influence on the operation parameters of the device to be analyzed.
When the abnormal data is generated by the equipment to be analyzed due to the abnormal monitoring parameters of the electromechanical equipment of the comparison equipment, a certain time difference value often exists, and therefore when the first abnormal time of the comparison equipment is earlier than the second abnormal time and the time difference value of the first abnormal time and the second abnormal time is larger than a preset value, the abnormal data generated by the equipment to be analyzed is judged to be generated by the comparison equipment, and the abnormal data is deleted in the data packet.
Step S27, retaining the abnormal data.
In this embodiment, when there is no correlation between the electromechanical device monitoring data of the device to be analyzed and the comparison device, the abnormal data is retained, so as to improve the accuracy of the analysis result when the data is analyzed.
As shown in fig. 4, step S17 includes the following steps (steps S31 to S36):
step S31, obtaining the packet number of the data packet;
step S32, determining data packets adjacent to the packet number based on a first preset time period;
step S33, electromechanical device monitoring data of adjacent data packets in a second preset time period are used as comparison data;
step S34, judging whether the comparison data can be combined with the abnormal data; if yes, executing step S35, otherwise executing step S36;
step S35, determining the processing mode to merge the abnormal data into the data packet adjacent to the packet number;
in this embodiment, when the monitoring time corresponding to the abnormal data is not in the first preset time period, the packet number corresponding to the abnormal data is extracted, for example, the starting time of the abnormal data in the data packet, and then the last data packet of the packet number corresponding to the abnormal data is obtained; judging whether the electromechanical equipment monitoring number which belongs to data repetition with the abnormal data exists in the adjacent data packets, wherein the monitoring time which belongs to the repeated data and the monitoring time corresponding to the abnormal data form continuous time; if yes, merging the abnormal data into the adjacent data packets, and executing the steps of determining a processing mode to store one of the repeated data and generating the data to be stored based on the stored repeated data and the time period.
For example, the packet number corresponding to the abnormal data is 10, the corresponding monitoring time is 10:00-10:50, the monitoring time corresponding to the abnormal data is 10:00-10:10, at this time, the data packet with the packet number of 9 is obtained, the monitoring time corresponding to the data packet with the packet number of 9 is 9:10-9:59, when the electromechanical device monitoring data which is the abnormal data and belongs to the repeated data exists in the 9:55-9:59, the abnormal data is merged into the data packet with the packet number of 9, and then the step of generating the data to be stored based on the saved repeated data and the time period is executed, wherein the judgment of the electromechanical device monitoring data which belongs to the repeated data is consistent with the mode of judging the repeated data, and the repeated data is not repeated.
The purpose of merging is to merge the abnormal data when the abnormal data in the adjacent data packet and the abnormal data in the current data packet belong to repeated data and are continuous in time, so that the storage space of the monitoring data of the electromechanical equipment is saved.
In step S36, the abnormal data is not processed.
When the comparison data cannot be combined with the abnormal data, the abnormal data is not processed.
The method is characterized in that after screening of the electromechanical device monitoring data in the database to be stored is completed, the electromechanical device monitoring data in the database to be stored is stored in the historical database so as to be subjected to a series of operations such as analysis and modeling of the electromechanical device monitoring data in the later period, and after the electromechanical device monitoring data is stored in the historical database, the electromechanical device monitoring data in the database to be stored needs to be completely emptied.
Fig. 5 is a block diagram of a device 200 for screening monitoring data of an electromechanical device according to the present application. As shown in fig. 5, the electromechanical device monitoring data screening apparatus 200 mainly includes:
the obtaining module 201 is configured to obtain a database to be stored, where the database to be stored includes electromechanical device monitoring data uploaded by a monitoring device;
the screening module 202 is configured to screen electromechanical device monitoring data in a database to be stored to obtain data to be processed, where the data to be processed includes repeated data and abnormal data;
the analysis module 203 is configured to analyze the data to be processed to obtain a processing manner, where the processing manner includes deleting the data to be processed in the database to be stored;
a processing module 204 for processing the data to be processed based on the processing mode
As an alternative implementation manner of this embodiment, the screening module 202 is specifically configured to:
grouping electromechanical device monitoring data based on a preset time period to obtain a plurality of data groups; acquiring a data threshold corresponding to monitoring data of the electromechanical equipment; inquiring whether electromechanical device monitoring data greater than a data threshold exists in each data packet; if electromechanical equipment monitoring data larger than the data threshold exists, the electromechanical equipment monitoring data larger than the data threshold is used as abnormal data; inquiring whether electromechanical equipment monitoring data with a numerical value difference value within a preset range exists in the data packet; if the electromechanical device monitoring data with the numerical value difference in the preset range exists, extracting all the electromechanical device monitoring data with the numerical value difference in the preset range, and taking the extracted electromechanical device monitoring data as repeated data.
As an alternative implementation of this embodiment, the analysis module 203 is configured to:
the time acquisition sub-module is used for acquiring the monitoring time corresponding to the repeated data in each data packet;
the time judging sub-module is used for judging whether the monitoring time corresponding to the repeated data forms a continuous time period or not; if yes, the determined processing mode is to store one of the repeated data, and the data to be stored is generated based on the stored repeated data and the time period.
As an alternative implementation of this embodiment, the analysis module 203 is further configured to:
acquiring a first total number of electromechanical device monitoring data and a second total number of abnormal data in each data packet;
the ratio calculating sub-module is used for calculating the number ratio of the first total number to the second total number;
the judging and inquiring sub-module is used for judging that the quantity ratio is smaller than the ratio threshold; if the monitoring time is smaller than the ratio threshold value, inquiring whether the monitoring time corresponding to the abnormal data is in a first preset time period or not; if the abnormal data is not in the first preset time period, determining the processing mode to delete the abnormal data in the data packet.
In this optional embodiment, the judging and querying sub-module is specifically configured to:
acquiring a packet number of a data packet; determining a data packet adjacent to the packet number based on a first preset time period; the electromechanical device monitoring data of adjacent data groups in a second preset time period are used as comparison data; judging whether the comparison data can be combined with the abnormal data or not; if yes, determining the processing mode to merge the abnormal data into the data packet adjacent to the packet number.
In this optional embodiment, the determining query sub-module further includes:
the first acquisition unit is used for acquiring electromechanical equipment corresponding to the abnormal data, and taking the electromechanical equipment corresponding to the abnormal data as equipment to be analyzed;
the second acquisition unit is used for acquiring an electromechanical equipment distribution diagram;
the determining unit is used for determining the comparison equipment of the equipment to be analyzed in a preset range based on the electromechanical equipment distribution diagram;
the inquiring judging unit is used for inquiring whether the electromechanical equipment monitoring data of the comparison equipment is abnormal in the monitoring time corresponding to the abnormal data; if so, judging whether the electromechanical equipment monitoring data of the equipment to be analyzed and the comparison equipment have correlation; if the correlation exists, determining a processing mode based on the first abnormal time when the comparison equipment starts to generate the abnormal data and the second abnormal time when the equipment to be analyzed starts to generate the abnormal data.
In this optional embodiment, the query determining unit is specifically configured to:
when the first abnormal time is earlier than the second abnormal time, calculating a time difference value between the first abnormal time and the second abnormal time; judging whether the time difference value is larger than a preset value or not; if yes, determining the processing mode to delete the abnormal data in the data packet
The functional modules in the embodiment of the application can be integrated together to form an independent part, or each module can exist independently, or two or more modules can be integrated to form an independent part. The functions, if implemented in the form of software functional modules and sold or used as a stand-alone product, may be stored on a computer readable storage medium. Based on such understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution in the form of a software product stored in a storage medium comprising several instructions for causing an electronic device (which may be a personal computer, a server or a network device, etc.) to perform all or part of the steps of an electromechanical device monitoring data screening method of the various embodiments of the present application.
It will be clearly understood by those skilled in the art that, for convenience and brevity of description, specific working procedures of the above-described system, apparatus and module may refer to corresponding procedures in the foregoing method embodiments, which are not repeated herein.
Fig. 6 is a block diagram of an electronic device 300 according to an embodiment of the present application. As shown in fig. 6, the electronic device 300 includes a memory 301, a processor 302, and a communication bus 303; the memory 301 and the processor 302 are connected by a communication bus 303. The memory 301 has stored thereon a method of screening electromechanical device monitoring data that can be loaded and executed by the processor 302 as provided in the above-described embodiments.
Memory 301 may be used to store instructions, programs, code sets, or instruction sets. The memory 301 may include a stored program area and a stored data area, wherein the stored program area may store instructions for implementing an operating system, instructions for at least one function, instructions for implementing an electromechanical device monitoring data screening method provided by the above-described embodiments, and the like; the data storage area may store data and the like involved in the method for screening monitoring data of the electromechanical device provided in the above embodiment.
Processor 302 may include one or more processing cores. The processor 302 performs the various functions of the present application and processes data by executing or executing instructions, programs, code sets, or instruction sets stored in the memory 301, invoking data stored in the memory 301. The processor 602 may be at least one of an application specific integrated circuit (Application Specific Integrated Circuit, ASIC), a digital signal processor (Digital Signal Processor, DSP), a digital signal processing device (Digital Signal Processing Device, DSPD), a programmable logic device (Programmable Logic Device, PLD), a field programmable gate array (Field Programmable Gate Array, FPGA), a central processing unit (Central Processing Unit, CPU), a controller, a microcontroller, and a microprocessor. It will be appreciated that the electronics for implementing the functions of the processor 302 described above may be other for different devices, and embodiments of the present application are not particularly limited.
Communication bus 303 may include a path to transfer information between the components. The communication bus 303 may be a PCI (Peripheral Component Interconnect, peripheral component interconnect standard) bus or an EISA (Extended Industry Standard Architecture ) bus, or the like. The communication bus 303 may be classified into an address bus, a data bus, a control bus, and the like. For ease of illustration, only one double arrow is shown in fig. 6, but not only one bus or one type of bus.
An embodiment of the present application provides a computer readable storage medium storing a computer program capable of being loaded by a processor and executing a method for screening monitoring data of an electromechanical device as provided in the above embodiment.
In this embodiment, the computer-readable storage medium may be a tangible device that holds and stores instructions for use by the instruction execution device. The computer readable storage medium may be, but is not limited to, an electronic storage device, a magnetic storage device, an optical storage device, an electromagnetic storage device, a semiconductor storage device, or any combination of the preceding. In particular, the computer readable storage medium may be a portable computer disk, hard disk, USB flash disk, random Access Memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), podium random access memory (SRAM), portable compact disc read-only memory (CD-ROM), digital Versatile Disk (DVD), memory stick, floppy disk, optical disk, magnetic disk, mechanical coding device, and any combination of the foregoing.
The terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus.
The above description is only illustrative of the preferred embodiments of the present application and of the principles of the technology employed. It will be appreciated by persons skilled in the art that the scope of the application is not limited to the specific combinations of the features described above, but also covers other embodiments which may be formed by any combination of the features described above or their equivalents without departing from the spirit of the application. Such as the above-mentioned features and the technical features having similar functions (but not limited to) applied for in the present application are replaced with each other.
Claims (10)
1. A method for screening monitoring data of an electromechanical device, comprising:
acquiring a database to be stored, wherein the database to be stored comprises electromechanical equipment monitoring data uploaded by monitoring equipment;
screening electromechanical equipment monitoring data in the database to be stored to obtain data to be processed, wherein the data to be processed comprises repeated data and abnormal data;
analyzing the data to be processed to obtain a processing mode, wherein the processing mode comprises deleting the data to be processed from the database to be stored;
and processing the data to be processed based on the processing mode.
2. The method of claim 1, wherein the screening of the electromechanical device monitoring data in the database to be stored comprises:
grouping the electromechanical device monitoring data based on a preset time period to obtain a plurality of data groups;
acquiring a data threshold corresponding to the electromechanical device monitoring data;
querying each of the data packets for the presence of electromechanical device monitoring data greater than the data threshold;
if electromechanical equipment monitoring data larger than the data threshold exists, the electromechanical equipment monitoring data larger than the data threshold is used as the abnormal data;
inquiring whether electromechanical equipment monitoring data with a numerical value difference value within a preset range exists in the data packet;
if the electromechanical equipment monitoring data with the numerical value difference in the preset range exists, extracting all the electromechanical equipment monitoring data with the numerical value difference in the preset range, and taking the extracted electromechanical equipment monitoring data as the repeated data.
3. The method according to claim 2, wherein if the data to be processed is duplicate data, the analyzing the data to be processed to obtain a processing manner includes:
acquiring monitoring time corresponding to the repeated data in each data packet;
judging whether the monitoring time corresponding to the repeated data forms a continuous time period or not;
if yes, determining that the processing mode is to store one of the repeated data, and generating the data to be stored based on the stored repeated data and the time period.
4. A method according to claim 2 or 3, wherein if the data to be processed is anomalous data, the analyzing the data to be processed comprises:
acquiring a first total number of electromechanical device monitoring data and a second total number of abnormal data in each data packet;
calculating a number ratio of the first total to the second total;
judging whether the number ratio is smaller than a ratio threshold;
if the monitoring time is smaller than the ratio threshold, inquiring whether the monitoring time corresponding to the abnormal data is in a first preset time period or not;
and if the abnormal data is not in the first preset time period, determining the processing mode to delete the abnormal data in the data packet.
5. The method of claim 4, wherein if in a first predetermined time period, the method comprises:
acquiring a packet number of the data packet;
determining a data packet adjacent to the packet number based on the first preset time period;
the electromechanical device monitoring data of adjacent data groups in a second preset time period are used as comparison data;
judging whether the comparison data can be combined with the abnormal data or not;
if yes, determining that the processing mode is to merge the abnormal data into the data packet adjacent to the packet number.
6. The method of claim 4, wherein if greater than the ratio threshold, the method further comprises:
acquiring electromechanical equipment corresponding to abnormal data, and taking the electromechanical equipment corresponding to the abnormal data as equipment to be analyzed;
acquiring an electromechanical device distribution diagram;
determining comparison equipment of the equipment to be analyzed in a preset range based on the electromechanical equipment distribution diagram;
inquiring whether the electromechanical equipment monitoring data of the comparison equipment is abnormal in the monitoring time corresponding to the abnormal data;
if so, judging whether the electromechanical equipment monitoring data of the equipment to be analyzed and the comparison equipment have correlation;
if the correlation exists, determining the processing mode based on the first abnormal time when the comparison equipment starts to generate abnormal data and the second abnormal time when the equipment to be analyzed starts to generate abnormal data.
7. The method of claim 6, wherein the determining the processing mode based on the first anomaly time when the comparison device starts to present the anomaly data and the second anomaly time when the device to be analyzed starts to present the anomaly data comprises:
when the first abnormal time is earlier than the second abnormal time, calculating a time difference value between the first abnormal time and the second abnormal time;
judging whether the time difference value is larger than a preset value or not;
if yes, determining the processing mode to delete the abnormal data in the data packet.
8. An electromechanical device monitoring data screening apparatus, comprising:
the acquisition module is used for acquiring a database to be stored, wherein the database to be stored comprises electromechanical equipment monitoring data uploaded by monitoring equipment;
the screening module is used for screening the electromechanical equipment monitoring data in the database to be stored to obtain data to be processed, wherein the data to be processed comprises repeated data and abnormal data;
the analysis module is used for analyzing the data to be processed to obtain a processing mode, wherein the processing mode comprises deleting the data to be processed from the database to be stored;
and the processing module is used for processing the data to be processed based on the processing mode.
9. An electronic device comprising a processor and a memory, the processor coupled to the memory;
the processor is configured to execute a computer program stored in the memory to cause the electronic device to perform the method of any one of claims 1 to 7.
10. A computer readable storage medium comprising a computer program or instructions which, when run on a computer, cause the computer to perform the method of any of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311182023.4A CN117216048A (en) | 2023-09-13 | 2023-09-13 | Screening method, screening device, screening equipment and storage medium for monitoring data of electromechanical equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311182023.4A CN117216048A (en) | 2023-09-13 | 2023-09-13 | Screening method, screening device, screening equipment and storage medium for monitoring data of electromechanical equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117216048A true CN117216048A (en) | 2023-12-12 |
Family
ID=89043661
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311182023.4A Pending CN117216048A (en) | 2023-09-13 | 2023-09-13 | Screening method, screening device, screening equipment and storage medium for monitoring data of electromechanical equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117216048A (en) |
-
2023
- 2023-09-13 CN CN202311182023.4A patent/CN117216048A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107871190B (en) | Service index monitoring method and device | |
| CN108989150B (en) | Login abnormity detection method and device | |
| CN111143102B (en) | Abnormal data detection method and device, storage medium and electronic equipment | |
| CN110417901B (en) | Data processing method and device and gateway server | |
| CN106104496A (en) | The abnormality detection not being subjected to supervision for arbitrary sequence | |
| CN109857618B (en) | Monitoring method, device and system | |
| CN115689396B (en) | Pollutant emission control method, device, equipment and medium | |
| CN113934720A (en) | Data cleaning method and equipment and computer storage medium | |
| CN115454778A (en) | Intelligent monitoring system for abnormal time sequence indexes in large-scale cloud network environment | |
| CN113722134A (en) | Cluster fault processing method, device and equipment and readable storage medium | |
| CN112988512A (en) | Method, device and equipment for detecting time sequence data abnormity and storage medium | |
| CN117076258A (en) | Remote monitoring method and system based on Internet cloud | |
| CN115935286A (en) | Abnormal point detection method, device and terminal for railway bearing state monitoring data | |
| CN113536066A (en) | Data anomaly detection algorithm determination method and device and computer equipment | |
| KR101960755B1 (en) | Method and apparatus of generating unacquired power data | |
| CN117473514B (en) | Intelligent operation and maintenance method and system of industrial control system | |
| CN113938306A (en) | Credible authentication method and system based on data cleaning rule | |
| CN113123955B (en) | Plunger pump abnormity detection method and device, storage medium and electronic equipment | |
| CN117216048A (en) | Screening method, screening device, screening equipment and storage medium for monitoring data of electromechanical equipment | |
| CN116074215B (en) | Network quality detection method, device, equipment and storage medium | |
| CN111797287A (en) | Energy-saving electric power cabinet control method and device based on remote control alarm recognition | |
| CN115150294B (en) | Data analysis method, device and medium for monitoring Internet of things device | |
| JP6290777B2 (en) | Data-related information processing apparatus and program | |
| CN116108376A (en) | Monitoring system and method for preventing electricity stealing, electronic equipment and medium | |
| CN115238779A (en) | Anomaly detection method, device, equipment and medium for cloud disk |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |