MES data verification method

Abstract

The invention discloses an MES data verification method, and relates to the field of MES data verification, the MES data verification method comprises a data receiving step, a storage verification step, a feedback verification step and a comprehensive verification step, comprehensive systematic analysis is performed on data receiving, data storage and data sending corresponding to an MES system, so that MES data verification has comprehensiveness, and the verification efficiency is improved. By eliminating the interference of network performance and the limitation of a storage device, the analysis of a single variable is kept to the greatest extent, the accuracy and effectiveness of the MES data verification result are effectively improved, and the data corresponding to the decision is ensured to be true and credible, so that the quality and accuracy of the decision are improved.

Description

Technical Field

[0001] The present application relates to the field of MES data verification, and in particular to a method for verifying MES data. Background Art

[0002] The MES system relies on accurate data to drive production decisions and process optimization. If the data is inaccurate or contains errors, the decisions made based on this data may lead to low production efficiency, waste of resources, and even quality problems. The MES system provides support for decision-making by collecting and analyzing production data. If the data is not verified, the decisions made based on this data may deviate from the actual situation and lead to wrong decisions. Data verification can ensure that the data corresponding to the decision is authentic and reliable, thereby improving the quality and accuracy of the decision. However, the existing technology still has the following shortcomings; When verifying MES data, existing technologies usually use a one-by-one comparison and confirmation method. This method not only has a large workload but also has low work efficiency, which indirectly reduces the timeliness and effectiveness of MES data verification, and further reduces the accuracy of MES data verification results. Existing technologies do not conduct a systematic analysis of the entire process of receiving, storing and sending data when verifying MES data, which makes the judgment of the MES data verification results one-sided, further reducing the accuracy of the MES data verification results, and is not conducive to all parties driving production decisions and process optimization based on accurate data. Summary of the invention

[0003] The object of the present invention is to provide a method for verifying MES data to solve the problems raised in the above background technology.

[0004] To achieve the above object, the present invention provides the following technical solution: a method for verifying MES data, comprising: Data receiving step: MES receives the uploaded data from each work unit and obtains the data receiving set corresponding to MES; Storage verification step: used to perform data reception verification and data storage verification on the data reception set corresponding to the MES, and obtain the preliminary abnormality index corresponding to the MES; Feedback verification step: used to perform feedback verification on the data receiving set corresponding to the MES to obtain the data feedback anomaly coefficient corresponding to the MES; Comprehensive verification step: used to perform a total score analysis based on the preliminary abnormality index corresponding to the MES and the data feedback abnormality coefficient corresponding to the MES to obtain the verification result of the MES data.

[0005] In a preferred embodiment of the present invention, the specific implementation method of the data receiving step is as follows: Each work unit corresponding to the MES uploads data according to the preset data upload timestamp. The MES receives the uploaded data set from each work unit through the API interface, and obtains the timestamp of the uploaded data set of each work unit. The uploaded data set includes the data packet corresponding to each work unit, the data upload timestamp, the data volume and the data content, wherein the data content includes work data and feedback data. The uploaded data set of each work unit received by the MES is recorded as the data receiving set corresponding to the MES.

[0006] In the preferred embodiment of this scheme, the specific implementation method of the preliminary verification step is as follows: Obtain the network performance data set corresponding to MES; According to the data upload timestamps corresponding to each work unit, statistics are performed to obtain the theoretical total amount of data received by MES corresponding to each timestamp; Establish a data extraction relationship between the preliminary verification step and the database, extract the theoretical receiving time of each total amount of data corresponding to each network performance data set stored in the database, and obtain the theoretical receiving time of each timestamp corresponding to the MES according to the network performance data set corresponding to the MES and the theoretical data receiving total amount corresponding to each timestamp of the MES; Obtain the data receiving log of MES; extract data from the data receiving log of MES to obtain the actual total amount of data received and the actual receiving duration of MES corresponding to each timestamp; By calculating the formula , calculate the data reception anomaly index corresponding to MES ; Extracting a database performance set stored in the database, wherein the database performance set refers to theoretical storage durations corresponding to different amounts of stored data; The total amount of actual data received by the MES corresponding to each timestamp is recorded as the total amount of theoretical data that needs to be stored by the MES corresponding to each timestamp, and the theoretical storage duration of the MES corresponding to each timestamp is obtained by screening according to the total amount of theoretical data that needs to be stored by the MES corresponding to each timestamp; Obtain the storage log corresponding to the database, perform data screening and extraction on the storage log corresponding to the database, and obtain the actual total amount of data stored corresponding to each timestamp MES and the actual storage duration of the actual total amount of data stored corresponding to each timestamp MES; By calculating the formula , calculate the data storage anomaly index corresponding to MES ; By calculating the formula , calculate the preliminary abnormal index corresponding to MES ,in Represented as the number of each timestamp, Expressed as the number of timestamps, , , , They represent the theoretical total amount of data received, theoretical receiving time, theoretical total amount of data to be stored, and theoretical storage time of MES corresponding to each timestamp. , , , They respectively represent the actual total amount of data received, actual receiving duration, actual total amount of data stored, and actual storage duration of the MES corresponding to each timestamp. , They are respectively represented as the preset data reception anomaly index impact factor and data storage anomaly index impact factor.

[0007] In the preferred embodiment of this scheme, the specific implementation method of the feedback verification step is as follows: The feedback data corresponding to each work unit includes the timestamp of the last data transmission of the work unit and the latest instruction information set sent by the system to the work unit, wherein the instruction information set includes the instruction sending timestamp and the instruction data set, and the instruction data set includes the instruction data packet, data volume and instruction content; Establish a data extraction relationship between the feedback verification step and the database, extract data from the database according to the timestamp of the last data transmission of each work unit, and obtain the work data corresponding to the timestamp of the last data transmission of each work unit; Perform data analysis on the work data corresponding to each work unit and the work data corresponding to the timestamp of the last data transmission of each work unit to obtain the actual change amount of each sub-work data corresponding to each work unit; Extracting the standard data change set corresponding to each combination of work data and instruction content corresponding to each work unit stored in the database, wherein the data change set includes the standard change amount of each sub-work data, and filtering the work data corresponding to the timestamp of the last data transmission of each work unit and the actual instruction content of the latest instruction information set corresponding to each work unit to obtain the standard data change set corresponding to each work unit; By calculating the formula , calculate the data change difference coefficient corresponding to each work unit, and record it as the work data difference coefficient corresponding to each work unit ,in It represents the number of each sub-work data. It is expressed as the number of types of sub-work data. , They are respectively represented as the standard change and actual change corresponding to each sub-work data. It is expressed as the working data difference coefficient influencing factor; Obtain the corresponding instruction sending log of MES, filter the data of the instruction sending log corresponding to MES according to the sending timestamp of the latest instruction information set sent by the system to the work unit, and obtain the actual instruction content of the latest instruction information set corresponding to each work unit, where the instruction content refers to each control item; Match the actual instruction content of the latest instruction information set corresponding to each work unit with the instruction content in the feedback data corresponding to each work unit, and obtain the missing control items and the number of missing control items in the instruction content in the feedback data corresponding to each work unit; and obtain the proportion of the number of missing control items to the total number of control items corresponding to the actual instruction content. By calculating the formula , calculate the data transmission anomaly index corresponding to MES ; By calculating the formula , calculate the data feedback anomaly coefficient corresponding to MES ,in It is represented by the number of each work unit. Expressed as the number of work unit types, , They are respectively expressed as the number of missing control items in the instruction content in the feedback data of each work unit and the ratio of the number of missing control items to the total number of control items corresponding to the actual instruction content, Represented as a preset data transmission anomaly index impact factor.

[0008] In the preferred embodiment of this scheme, the specific implementation method of the comprehensive verification step is as follows: By calculating the formula , calculate the comprehensive data deviation coefficient corresponding to MES ; The comprehensive data deviation coefficient corresponding to the MES is compared and analyzed with the preset comprehensive data deviation coefficient threshold. If the comprehensive data deviation coefficient corresponding to the MES is less than or equal to the preset comprehensive data deviation coefficient threshold, it means that the MES has passed the data verification and the MES works normally. The MES is not processed, and the MES passes the data verification and the MES works normally is recorded as the verification result of the MES data. If the comprehensive data deviation coefficient corresponding to the MES is greater than the preset comprehensive data deviation coefficient threshold, it means that the MES has not passed the data verification and the MES is in an abnormal working state. The MES is processed accordingly, and the MES has not passed the data verification and the MES is in an abnormal working state is recorded as the verification result of the MES data.

[0009] Compared with the prior art, the present invention has the following beneficial effects: The present invention makes comprehensive MES data verification by conducting a comprehensive and systematic analysis of data reception, data storage and data transmission corresponding to the MES system, thereby increasing the accuracy and effectiveness of the MES data verification results; The present invention eliminates the interference of network performance and the limitation of storage devices, maintains the analysis of a single variable to the greatest extent, effectively improves the accuracy and effectiveness of MES data verification results, ensures that the data corresponding to the decision is authentic, and thus improves the quality and accuracy of the decision. BRIEF DESCRIPTION OF THE DRAWINGS

[0010] The present invention is further described using the accompanying drawings, but the embodiments in the accompanying drawings do not constitute any limitation to the present invention. A person skilled in the art can obtain other drawings based on the following drawings without creative work.

[0011] Figure 1 It is a schematic diagram of the connection steps of an embodiment of the present invention. DETAILED DESCRIPTION

[0012] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0013] See also Figure 1 , the present invention provides a method for verifying MES data, the method comprising a data receiving step, a storage verification step, a feedback verification step and a comprehensive verification step; The data receiving step is connected to the storage verification step and the feedback verification step, the storage verification step is connected to the integrated verification step, and the feedback verification step is connected to the integrated verification step.

[0014] Data receiving step: MES receives the uploaded data from each work unit and obtains the data receiving set corresponding to MES; Furthermore, the specific execution mode of the data receiving step is as follows: Each work unit corresponding to the MES uploads data according to the preset data upload timestamp. The MES receives the uploaded data set from each work unit through the API interface, and obtains the timestamp of the uploaded data set of each work unit. The uploaded data set includes the data packet corresponding to each work unit, the data upload timestamp, the data volume and the data content, wherein the data content includes work data and feedback data. The uploaded data set of each work unit received by the MES is recorded as the data receiving set corresponding to the MES.

[0015] It should be noted that data volume refers to the data size of a data packet, such as 2kb or 1mb, and data content refers to the specific content of a data packet, such as monitoring data of a monitoring device or progress data of a working device.

[0016] The storage verification step is used to perform data reception verification and data storage verification on the data reception set corresponding to the MES, and obtain the preliminary abnormality index corresponding to the MES; Furthermore, the specific implementation of the preliminary verification step is as follows: Obtain the network performance data set corresponding to MES; According to the data upload timestamps corresponding to each work unit, statistics are performed to obtain the theoretical total amount of data received by MES corresponding to each timestamp; Establish a data extraction relationship between the preliminary verification step and the database, extract the theoretical receiving time of each total amount of data corresponding to each network performance data set stored in the database, and obtain the theoretical receiving time of each timestamp corresponding to the MES according to the network performance data set corresponding to the MES and the theoretical data receiving total amount corresponding to each timestamp of the MES; Obtain the data receiving log of MES; extract data from the data receiving log of MES to obtain the actual total amount of data received and the actual receiving duration of MES corresponding to each timestamp; By calculating the formula , calculate the data reception anomaly index corresponding to MES ; Extracting a database performance set stored in the database, wherein the database performance set refers to theoretical storage durations corresponding to different amounts of stored data; The total amount of actual data received by the MES corresponding to each timestamp is recorded as the total amount of theoretical data that needs to be stored by the MES corresponding to each timestamp, and the theoretical storage duration of the MES corresponding to each timestamp is obtained by screening according to the total amount of theoretical data that needs to be stored by the MES corresponding to each timestamp; Obtain the storage log corresponding to the database, perform data screening and extraction on the storage log corresponding to the database, and obtain the actual total amount of data stored corresponding to each timestamp MES and the actual storage duration of the actual total amount of data stored corresponding to each timestamp MES; By calculating the formula , calculate the data storage anomaly index corresponding to MES ; By calculating the formula , calculate the preliminary abnormal index corresponding to MES ,in Represented as the number of each timestamp, Expressed as the number of timestamps, , , , They represent the theoretical total amount of data received, theoretical receiving time, theoretical total amount of data to be stored, and theoretical storage time of MES corresponding to each timestamp. , , , They respectively represent the actual total amount of data received, actual receiving duration, actual total amount of data stored, and actual storage duration of the MES corresponding to each timestamp. , They are respectively represented as the preset data reception anomaly index impact factor and data storage anomaly index impact factor.

[0017] The feedback verification step is used to perform feedback verification on the data receiving set corresponding to the MES to obtain the data feedback anomaly coefficient corresponding to the MES; Furthermore, the specific implementation of the feedback verification step is as follows: The feedback data corresponding to each work unit includes the timestamp of the last data transmission of the work unit and the latest instruction information set sent by the system to the work unit, wherein the instruction information set includes the instruction sending timestamp and the instruction data set, and the instruction data set includes the instruction data packet, data volume and instruction content; Establish a data extraction relationship between the feedback verification step and the database, extract data from the database according to the timestamp of the last data transmission of each work unit, and obtain the work data corresponding to the timestamp of the last data transmission of each work unit; Perform data analysis on the work data corresponding to each work unit and the work data corresponding to the timestamp of the last data transmission of each work unit to obtain the actual change amount of each sub-work data corresponding to each work unit; It should be noted that the latest instruction information sent by the system to the work unit is obtained by analyzing the work data transmitted by the work unit last time; Extracting the standard data change set corresponding to each combination of work data and instruction content corresponding to each work unit stored in the database, wherein the data change set includes the standard change amount of each sub-work data, and filtering the work data corresponding to the timestamp of the last data transmission of each work unit and the actual instruction content of the latest instruction information set corresponding to each work unit to obtain the standard data change set corresponding to each work unit; By calculating the formula , calculate the data change difference coefficient corresponding to each work unit, and record it as the work data difference coefficient corresponding to each work unit ,in It represents the number of each sub-work data. It is expressed as the number of types of sub-work data. , They are respectively represented as the standard change and actual change corresponding to each sub-work data. It is expressed as the working data difference coefficient influencing factor; Obtain the corresponding instruction sending log of MES, filter the data of the instruction sending log corresponding to MES according to the sending timestamp of the latest instruction information set sent by the system to the work unit, and obtain the actual instruction content of the latest instruction information set corresponding to each work unit, where the instruction content refers to each control item; Match the actual instruction content of the latest instruction information set corresponding to each work unit with the instruction content in the feedback data corresponding to each work unit, and obtain the missing control items and the number of missing control items in the instruction content in the feedback data corresponding to each work unit; and obtain the proportion of the number of missing control items to the total number of control items corresponding to the actual instruction content. It should be noted that the missing control items refer to the control items that are present in the actual instruction content but not in the instruction content in the feedback data during the matching process between the control items in the instruction content in the feedback data and the control items corresponding to the actual instruction content.

[0018] By calculating the formula , calculate the data transmission anomaly index corresponding to MES ; By calculating the formula , calculate the data feedback anomaly coefficient corresponding to MES ,in It is represented by the number of each work unit. Expressed as the number of work unit types, , They are respectively expressed as the number of missing control items in the instruction content in the feedback data of each work unit and the ratio of the number of missing control items to the total number of control items corresponding to the actual instruction content, Represented as a preset data transmission anomaly index impact factor.

[0019] The comprehensive verification step is used to perform a total score analysis based on the preliminary anomaly index corresponding to the MES and the data feedback anomaly coefficient corresponding to the MES to obtain the verification result of the MES data.

[0020] Furthermore, the specific implementation of the comprehensive verification step is as follows: By calculating the formula , calculate the comprehensive data deviation coefficient corresponding to MES ; The comprehensive data deviation coefficient corresponding to the MES is compared and analyzed with the preset comprehensive data deviation coefficient threshold. If the comprehensive data deviation coefficient corresponding to the MES is less than or equal to the preset comprehensive data deviation coefficient threshold, it means that the MES has passed the data verification and the MES works normally. The MES is not processed, and the MES passes the data verification and the MES works normally is recorded as the verification result of the MES data. If the comprehensive data deviation coefficient corresponding to the MES is greater than the preset comprehensive data deviation coefficient threshold, it means that the MES has not passed the data verification and the MES is in an abnormal working state. The MES is processed accordingly, and the MES has not passed the data verification and the MES is in an abnormal working state is recorded as the verification result of the MES data.

[0021] The above are all preferred embodiments of the present application, and the protection scope of the present application is not limited thereto. Therefore, any equivalent changes made according to the structure, shape, and principle of the present application should be included in the protection scope of the present application.

Claims

1. A method for verifying MES data, characterized in that: include: Data receiving step: MES receives the uploaded data from each work unit and obtains the data receiving set corresponding to MES; Storage verification step: used to perform data reception verification and data storage verification on the data reception set corresponding to the MES, and obtain the preliminary abnormality index corresponding to the MES; Feedback verification step: used to perform feedback verification on the data receiving set corresponding to the MES to obtain the data feedback anomaly coefficient corresponding to the MES; Comprehensive verification step: used to perform a total score analysis based on the preliminary abnormality index corresponding to the MES and the data feedback abnormality coefficient corresponding to the MES, and obtain the verification result of the MES data.

2. A method for verifying MES data according to claim 1, characterized in that: The specific execution mode of the data receiving step is as follows: Each work unit corresponding to the MES uploads data according to the preset data upload timestamp. The MES receives the uploaded data set from each work unit through the API interface, and obtains the timestamp of the uploaded data set of each work unit. The uploaded data set includes the data packet corresponding to each work unit, the data upload timestamp, the data volume and the data content, wherein the data content includes work data and feedback data. The uploaded data set of each work unit received by the MES is recorded as the data receiving set corresponding to the MES.

3. The MES data verification method according to claim 1, characterized in that: The specific implementation method of the preliminary verification step is as follows: Obtain the network performance data set corresponding to MES; According to the data upload timestamps corresponding to each work unit, statistics are performed to obtain the theoretical total amount of data received by MES corresponding to each timestamp; Establish a data extraction relationship between the preliminary verification step and the database, extract the theoretical receiving time of each total amount of data corresponding to each network performance data set stored in the database, and obtain the theoretical receiving time of each timestamp corresponding to the MES according to the network performance data set corresponding to the MES and the theoretical data receiving total amount corresponding to each timestamp of the MES; Get the data receiving log of MES; Extract data from the data receiving log of MES to obtain the actual total amount of data received and the actual receiving duration corresponding to each timestamp of MES; By calculating the formula , calculate the data reception anomaly index corresponding to MES ; Extracting a database performance set stored in the database, wherein the database performance set refers to theoretical storage durations corresponding to different amounts of stored data; The total amount of actual data received by the MES corresponding to each timestamp is recorded as the total amount of theoretical data that needs to be stored by the MES corresponding to each timestamp, and the theoretical storage duration of the MES corresponding to each timestamp is obtained by screening according to the total amount of theoretical data that needs to be stored by the MES corresponding to each timestamp; Obtain the storage log corresponding to the database, perform data screening and extraction on the storage log corresponding to the database, and obtain the actual total amount of data stored corresponding to each timestamp MES and the actual storage duration of the actual total amount of data stored corresponding to each timestamp MES; By calculating the formula , calculate the data storage anomaly index corresponding to MES ; By calculating the formula , calculate the preliminary abnormal index corresponding to MES ,in Represented as the number of each timestamp, Expressed as the number of timestamps, , , , They represent the theoretical total amount of data received, theoretical receiving time, theoretical total amount of data to be stored, and theoretical storage time of MES corresponding to each timestamp. , , , They represent the actual total amount of data received, actual receiving duration, actual total amount of data stored, and actual storage duration of MES corresponding to each timestamp. , They are respectively represented as the preset data reception anomaly index impact factor and data storage anomaly index impact factor.

4. The method for verifying MES data according to claim 2, characterized in that: The specific implementation method of the feedback verification step is as follows: The feedback data corresponding to each work unit includes the timestamp of the last data transmission of the work unit and the latest instruction information set sent by the system to the work unit, wherein the instruction information set includes the instruction sending timestamp and the instruction data set, and the instruction data set includes the instruction data packet, data volume and instruction content; Establish a data extraction relationship between the feedback verification step and the database, extract data from the database according to the timestamp of the last data transmission of each work unit, and obtain the work data corresponding to the timestamp of the last data transmission of each work unit; Perform data analysis on the work data corresponding to each work unit and the work data corresponding to the timestamp of the last data transmission of each work unit to obtain the actual change amount of each sub-work data corresponding to each work unit; Extracting the standard data change set corresponding to each combination of work data and instruction content corresponding to each work unit stored in the database, wherein the data change set includes the standard change amount of each sub-work data, and filtering the work data corresponding to the timestamp of the last data transmission of each work unit and the actual instruction content of the latest instruction information set corresponding to each work unit to obtain the standard data change set corresponding to each work unit; By calculating the formula , calculate the data change difference coefficient corresponding to each work unit, and record it as the work data difference coefficient corresponding to each work unit ,in It represents the number of each sub-work data. It is expressed as the number of types of sub-work data. , They are respectively represented as the standard change and actual change corresponding to each sub-work data. It is expressed as the working data difference coefficient influencing factor; Obtain the corresponding instruction sending log of MES, filter the data of the instruction sending log corresponding to MES according to the sending timestamp of the latest instruction information set sent by the system to the work unit, and obtain the actual instruction content of the latest instruction information set corresponding to each work unit, where the instruction content refers to each control item; Match the actual instruction content of the latest instruction information set corresponding to each work unit with the instruction content in the feedback data corresponding to each work unit, and obtain each control missing item and the number of control missing items in the instruction content in the feedback data corresponding to each work unit; The proportion of the number of missing items in regulation to the total number of regulation items corresponding to the actual instruction content is obtained by statistics; By calculating the formula , calculate the data transmission anomaly index corresponding to MES ; By calculating the formula , calculate the data feedback anomaly coefficient corresponding to MES ,in It is represented by the number of each work unit. Expressed as the number of work unit types, , They are respectively expressed as the number of missing control items in the instruction content in the feedback data of each work unit and the ratio of the number of missing control items to the total number of control items corresponding to the actual instruction content, Represented as a preset data transmission anomaly index impact factor.

5. A method for verifying MES data according to claim 4, characterized in that: The specific implementation method of the comprehensive verification step is as follows: By calculating the formula , calculate the comprehensive data deviation coefficient corresponding to MES ; The comprehensive data deviation coefficient corresponding to the MES is compared and analyzed with the preset comprehensive data deviation coefficient threshold. If the comprehensive data deviation coefficient corresponding to the MES is less than or equal to the preset comprehensive data deviation coefficient threshold, it means that the MES has passed the data verification and the MES works normally. The MES is not processed, and the MES passes the data verification and the MES works normally is recorded as the verification result of the MES data. If the comprehensive data deviation coefficient corresponding to the MES is greater than the preset comprehensive data deviation coefficient threshold, it means that the MES has not passed the data verification and the MES is in an abnormal working state. The MES is processed accordingly, and the MES has not passed the data verification and the MES is in an abnormal working state is recorded as the verification result of the MES data.

Images