CN110189093A - Data error prevention system - Google Patents

Abstract

The invention provides a data error prevention system, which belongs to the field of production data collection. The data error prevention system includes a verification rule library, a real-time early warning module, and a prompt module; an automatic repair module, a statistical query module, and a manual data supplement Record five modules, the system of the present invention utilizes the data acquisition interface and network foundation of MES, does not need to expand equipment and software, and can save funds for purchasing hardware equipment; adopts MES bottom layer data codes and other module functions, saves a lot of program editing time, and its safety Sex is consistent with MES.

Description

A data error prevention system

technical field

The invention belongs to the field of statistical analysis of production data, and more specifically relates to a data error prevention system.

Background technique

The application of manufacturing system (MES) in the production process has played a positive role in the stable improvement of online product quality and created an opportunity for the transformation of product quality inspection methods. In the process of use in recent years, a large amount of online data collection has been applied to product quality inspection data, so that the data can not only be statistically analyzed in real time, but also minimize the amount of manual data, making the final result more objective and fair. The application of the system can not only discover the quality problems in the production process in time, but also strengthen the product quality control in the production process.

However, some problems have been encountered in the actual use process: 1. Since the data collection is based on the production plan, when the data transmission of the planning and scheduling server is unstable, the batches produced on shift cannot be created, and the batches cannot be created. The online and offline data cannot be collected or manually input, resulting in the lack of quality inspection data of this batch of products; 2. The data collection is at the second level when the production is normal, and the amount of product quality data in each batch is huge, and errors and omissions are inevitable. And it is not easy to find and search; 3. After a period of time, the lack of batch data or the accumulation of data errors will cause uncertainty in the statistical results of the data, uncertainty in quality improvement and quality problem handling.

Contents of the invention

The system of the present invention utilizes the data acquisition interface and network foundation of MES, without the need to expand equipment and software, and can save funds for purchasing hardware equipment; adopts MES bottom layer data codes and other module functions, saving a lot of program editing time, and its security is comparable to that of MES consistent. The establishment of this system will provide a strong guarantee for the accuracy of product quality inspection data.

In order to achieve the above object, the present invention is achieved through the following technical solutions: the data error prevention system includes a verification rule library, a real-time early warning module and a prompt module, an automatic repair module, a statistical query module, and five modules for data supplementary recording .

Preferably, the verification rule library mainly stores pre-established missing and wrong data discovery methods, repair, isolation, supplementary data and other rules. The entire system operates around these rules and is the core module of the platform.

Preferably, the real-time early warning module and prompt module are modules used to provide early warning and prompt to relevant personnel when problematic data is found in the data collected by the MES system according to the verification rules.

Preferably, the automatic repair module is used for repairing or identifying and isolating data according to relevant technical standards according to the rules in the verification rule base.

Preferably, the statistical query module is used to perform statistics on various problem data and display graphical results or perform conditional query manually.

Preferably, the data re-recording module is used to perform operations such as manual re-recording of statistical problematic data or deletion of isolated data.

Preferably, the data error prevention system is deployed in the form of an MES system, all terminals connected to the server can access the system, and the underlying database of the entire system is established according to statistical methods.

Preferably, the real-time early warning and the early warning in the prompting module are mainly performed when there is missing or no data in the data collected by the online detection instrument, and the prompt is performed when the manually entered data exceeds the standard range.

Beneficial effects of the present invention:

The system of the present invention utilizes the data acquisition interface and network foundation of MES, without the need to expand equipment and software, and can save funds for purchasing hardware equipment; adopts MES bottom layer data codes and other module functions, saving a lot of program editing time, and its security is comparable to that of MES consistent. The establishment of this system will provide a strong guarantee for the accuracy of product quality inspection data.

It is the first time to realize the use of computer programs to verify data; realize manual data entry error system prompts; complete automatic monitoring and early warning of online data collection; propose methods for labeling and isolating problem data; realize graphical error data statistics.

Description of drawings

Fig. 1 is a system block diagram of the present invention;

Fig. 2 is a flow chart of the system of the present invention;

Fig. 3 is a schematic diagram of the verification rule library;

Fig. 4 data acquisition finds wrong data illustration;

Figure 5 Manual input error data prompt;

Figure 6 The system automatically identifies and isolates;

Fig. 7 Data error situation of every shift every day;

Figure 8 data error rate arrangement;

Figure 9 supplements the data.

Detailed ways

In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and examples, but the given examples are not intended to limit the present invention.

As shown in Figure 1-2, the stability of product quality in the production process is achieved through the control of the processing parameters of the production process, and the accuracy and integrity of the data is the foundation; in order to ensure the accuracy and integrity of the data, the design is based on MES product quality inspection data error prevention system. The system uses the corresponding error prevention program to quickly compare and verify the relevant inspection data, isolate and label redundant and inconsistent data, and provide error prompts and related parameter range prompts for manually entered data. Or isolation during analysis is a feasible method. According to the pre-set judgment rules, the online collection data and offline data are analyzed and checked, and the data that does not conform to the rules or the missing data is found to be processed according to the rules. The main processing methods are divided into: real-time early warning, real-time reminder, automatic repair, Statistical query, data supplementary recording, etc.

The program is deployed in the form of an MES system, and all terminals connected to the server can access the system. While establishing the system framework, the underlying database of the entire system is established according to statistical methods, fully considering the differences between different data and the standardization of processing procedures, so that the system has better adaptability and operability.

This system is a system software that depends on the .net platform. It is based on the c programming system word and is programmed with the c# programming language. The business relational database and real-time historical record database used are SQL SERVER and Wonderware Historian; the upper analysis component adopts the Wonderware QI Analyst SPC analysis component; the overall business process of the organization adopts the Wonderware ArchestrA Workflow workflow component. This flexible business process management application enables the platform to model, execute, analyze and improve its internal and external information, thus ensuring the stability and scalability of the system.

The system is based on production equipment online product quality testing instruments, laboratory testing instruments, and manual inspection data, and compares the data in the MES data acquisition module database through system verification rules. The verification time reaches the millisecond level, and it is highly sensitive to data changes, fully satisfying the real-time verification and analysis of online and offline data in the production process. The system consists of five modules: verification rule base; real-time early warning module, prompt module; automatic repair module; statistical query module; data supplementary recording. The MES system data collection and manual input module sends the collected data into the verification rule library, and the data processed and analyzed by the verification rule library is sent to the real-time early warning module and the prompt module, and the real-time early warning module and the prompt module send the input to the automatic repair module, the automatic repair module sends the data to the statistical query module, the data supplementary recording module, the statistical query module, and the data supplementary recording module, and then sends the repaired data to the verification rule base for processing.

As shown in Figure 3, the verification rule base: mainly stores the missing and wrong data discovery methods formulated in advance, repair, isolation, and supplementary data and other rules. The entire system operates around these rules and is the core module of the platform.

As shown in Figure 4-5, real-time early warning and reminder module: the module that provides early warning and reminder to relevant personnel after the data collected by MES finds problem data according to the verification rules. The early warning is mainly carried out when there is missing or no data in the data collected by the online detection instrument, and the reminder is carried out when the manually entered data exceeds the standard range.

As shown in Figure 6, the automatic repair module: according to the rules in the verification rule base, the data is repaired or identified and isolated according to relevant technical standards.

As shown in Figure 7-8, statistical query module: perform statistics on various problem data and display graphical results or perform conditional query manually.

As shown in Figure 9, the data re-recording module: manually re-record the statistical problem data or delete the isolated data.

In the actual production process, after the application of this system, the data loss caused by the missing planned production batches is reduced from 1-3 batches/day to 1-3 batches/month; the number of manual data entry errors is reduced from 3-4 times/day , reduced to 0 times; the statistical error rate of product quality inspection results was reduced from 1% to 0%; the error data discovery rate of online instrument inspection was increased from 0% to 100%; the accuracy rate of online product quality evaluation was increased to 100%.

The present invention realizes the use of computer programs to verify data for the first time; realizes manual data entry error system prompt; completes automatic monitoring and early warning of online data collection; proposes a method for labeling and isolating problem data; realizes graphical error data statistics .

The above only further illustrates the technical content of the present invention by means of embodiments, so as to make it easier for readers to understand. The general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the invention. Therefore, the present invention will not be limited to the embodiments shown herein, and any technical extension or reconstruction made according to the present invention is protected by the present invention.

Claims (8)

1. a kind of system of data error protection, it is characterised in that: the system of the data error protection includes verification rule base, reality When warning module and five cue module, automatic repairing module, statistical query module, data amended record modules.

2. a kind of system of data error protection according to claim 1, it is characterised in that: the verification rule base is main The missing completed is formulated in storage in advance, wrong data finds method, and rules, the whole systems such as reparation, isolation, amended record data are enclosed It is the nucleus module of platform around these rule operations.

3. a kind of system of data error protection according to claim 1, it is characterised in that: the real-time early warning module with Cue module, it is pre- for being carried out after the collected data of MES system are according to verification rule discovery problem data to related personnel Alert, prompt module.

4. a kind of system of data error protection according to claim 1, it is characterised in that: the automatic repairing module, For data to be repaired or are identified with isolation according to Its Relevant Technology Standards by the rule in verification rule base.

5. a kind of system of data error protection according to claim 1, it is characterised in that: the statistical query module, It is shown for being counted to various problem datas with graphic result or by manually carrying out condition query.

6. a kind of system of data error protection according to claim 1, it is characterised in that: the data amended record module, For carrying out artificial amended record to data the problem of counting or carrying out the operation such as deleting to isolated data.

7. a kind of system of data error protection according to claim 1, it is characterised in that: the data error protection is The form based on MES system of uniting carries out the deployment of program, and the terminal of all connection servers can be carried out the access of system, entirely The database of system bottom is established according to statistical method.

8. a kind of system of data error protection according to claim 3, it is characterised in that: the real-time early warning, prompt There is shortage of data or no data when progress mainly for on-line checking instrument acquisition data in early warning in module, prompts for artificial Logging data carries out when exceeding critical field.