Method and system for monitoring abnormal data in cigarette production process

Abstract

The invention discloses a method and a system for monitoring abnormal data in a cigarette production process, and the method comprises the steps: connecting an industrial control computer corresponding to a quality detection device additionally arranged on cigarette equipment of each unit to an industrial network, so as to be in network connection with a remote server; the collected data are stored in a MySQL database or a SQL Server database of the corresponding industrial personal computer; a data interaction APP is arranged on the remote server so as to read the detection data in the MySQL database or the SQL Server database of each industrial personal computer, and whether the detection data is abnormal or not is judged; if yes, a data abnormity alarm is reported, and a judgment result is stored in a MySQL or SQL Server database of the remote server. According to the method, the intelligence of cigarette production can be improved, and the consistency of cigarette quality is improved.

Description

Technical Field

[0001] The present invention relates to the technical field of cigarette production data monitoring, and more specifically, to a method and system for monitoring abnormal data in a cigarette production process. Background Art

[0002] Many quality problems are prone to occur during the production of cigarettes. In order to prevent defective products from flowing into the next production process, many detection devices have been installed on cigarette equipment, such as cigarette appearance quality detection, cigarette physical index detection, box defect detection and strip defect detection. The use of these detection devices has greatly reduced the probability of defective products flowing into the next process, which plays an important role in improving product quality. However, these devices are often provided by different manufacturers, and the data collection standards are not unified. In addition, these detection devices are in a long-term running state during the actual production process, and it is easy for the detection software to "abnormally get stuck". Due to the lack of monitoring of these detection data, existing problems cannot be discovered in time, which can easily cause quality defects in cigarette production. Therefore, it is of great significance to effectively detect cigarette production data and improve the stability of cigarette production quality. Summary of the invention

[0003] The present invention provides a monitoring method and system for abnormal data in a cigarette production process, which solves the problem that "abnormal stuck" in existing cigarette production detection data cannot be discovered in time, which easily causes cigarette quality defects. The method can improve the intelligence of cigarette production and the consistency of cigarette quality.

[0004] To achieve the above objectives, the present invention provides the following technical solutions:

[0005] A method for monitoring abnormal data in a cigarette production process, comprising:

[0006] Connect the industrial computers corresponding to the quality inspection devices installed on each unit of cigarette equipment to the industrial network to connect to the remote server network;

[0007] Save the collected data to the MySQL database or SQL Server database of the corresponding industrial computer;

[0008] A data interaction APP is provided on the remote server to read the detection data in the MySQL or SQL Server database of each industrial computer and determine whether the detection data has data anomalies;

[0009] If so, report the data abnormality alarm and store the judgment result in the MySQL or SQL Server database of the remote server.

[0010] Preferably, it also includes:

[0011] A client terminal is provided, through which the online status of data collection of the quality inspection device installed on each unit of cigarette equipment, the abnormal status of the inspection equipment and the inspection data are checked.

[0012] Preferably, it also includes:

[0013] Query the production management scheduling data and determine whether there is scheduling information. If yes, query the corresponding MySQL or SQL Server database to obtain the corresponding 5-minute cigarette machine and packaging machine operating speed and output time series data information;

[0014] The average value of the running speed is calculated, and the integral operation result is obtained by performing mathematical integration operation on the production time series data, and the integral operation result is divided by the calculation result of the average value of the running speed as the intermediate result;

[0015] It is determined whether the value of the intermediate result is equal to the set threshold value. If so, it is determined whether the detection data has data anomaly.

[0016] Preferably, the determining whether the detection data has data anomaly includes:

[0017] The detection counts of the quality inspection devices installed on the cigarette making machine and the packaging machine within 5 minutes are obtained in sequence to determine whether the detection counts have changed. If not, it is determined that the quality inspection equipment has an "abnormal jam" fault and there is data abnormality.

[0018] Preferably, it also includes:

[0019] When the remote server determines that a data anomaly occurs, the anomaly information is pushed to the mobile terminal of the equipment personnel through the data interaction APP to remind them to handle it in time.

[0020] The present invention also provides a monitoring system for abnormal data in a cigarette production process, using the above monitoring method, comprising: a quality detection device, an industrial computer and a remote server;

[0021] Install the quality inspection device on each cigarette making equipment unit to collect inspection data of each cigarette making equipment unit;

[0022] The quality detection device is connected to the industrial computer by signal, and the industrial computer is connected to the industrial network to be connected to the remote server network;

[0023] The remote server is provided with a data interaction APP to read the detection data in the MySQL or SQL Server database of each industrial computer and determine whether the detection data has data anomalies;

[0024] If so, report the data abnormality alarm and store the judgment result in the MySQL or SQL Server database of the remote server.

[0025] Preferably, it also includes: a client terminal;

[0026] A plurality of client terminals are connected to the remote server network, and the data collection online status, abnormal status of the detection equipment and detection data of each quality detection device are viewed through the client terminals.

[0027] Preferably, it also includes: an alarm device;

[0028] The alarm device is connected to the industrial computer by signal. When the remote server determines that the detection data of the corresponding quality detection device is abnormal, it sends an alarm instruction to the corresponding industrial computer, and the industrial computer controls the alarm device to sound an alarm.

[0029] Preferably, the alarm device includes at least any one of the following: an indicator light, a buzzer and an audible and visual alarm.

[0030] Preferably, the quality inspection device includes: cigarette appearance inspection equipment, cigarette physical index inspection equipment, cigarette empty end leakage inspection device, small package appearance inspection device, carton appearance inspection device, small package loose package inspection device and wire pulling inspection device.

[0031] The present invention provides a monitoring method and system for abnormal data in the cigarette production process, wherein the detection data collected by the quality detection device on the cigarette equipment of each unit is stored in the MySQL or SQL Server database of the local industrial computer, and the remote server reads the detection data from the industrial computer through the industrial network, and reports the data abnormality alarm when the detection data is abnormal. The problem that the existing cigarette production detection data cannot be discovered in time when "abnormal stuck" occurs, which easily causes cigarette quality defects, can be solved, and the intelligence of cigarette production can be improved, and the consistency of cigarette quality can be improved. BRIEF DESCRIPTION OF THE DRAWINGS

[0032] In order to more clearly illustrate the specific embodiments of the present invention, the drawings required for use in the embodiments are briefly introduced below.

[0033] Figure 1 It is a schematic diagram of a method for monitoring abnormal data in a cigarette production process provided by the present invention.

[0034] Figure 2 It is a flow chart for determining "abnormal stuck" of detection data provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0035] In order to enable persons skilled in the art to better understand the solutions of the embodiments of the present invention, the embodiments of the present invention are further described in detail below in conjunction with the accompanying drawings and implementation modes.

[0036] In view of the fact that abnormalities in detection data in the current cigarette production process cannot be discovered in time, which easily leads to cigarette quality defects, the present invention provides a monitoring method and system for abnormal data in the cigarette production process, which solves the problem that "abnormal stuck" in the existing cigarette production detection data cannot be discovered in time, which easily leads to cigarette quality defects. The method can improve the intelligence of cigarette production and improve the consistency of cigarette quality.

[0037] like Figure 1 and Figure 2 As shown, a method for monitoring abnormal data in a cigarette production process comprises:

[0038] S1: Connect the industrial computers corresponding to the quality inspection devices installed on each unit of cigarette equipment to the industrial network to connect to the remote server network.

[0039] S2: Save the collected data to the MySQL database or SQL Server database of the corresponding industrial computer.

[0040] S3: A data interaction APP is provided on the remote server to read the detection data in the MySQL or SQL Server database of each industrial computer and determine whether the detection data has data anomalies.

[0041] S4: If yes, report the data abnormality alarm and store the determination result in the MySQL or SQL Server database of the remote server.

[0042] Specifically, the collected data is saved in a local MySQL database or SQL Server database, and the collected data includes detection data, such as the number of qualified tests, defect trees, etc., and detection device operation status data, such as the detection software operation status and rejection switch status. The data interaction APP set on the remote server can use C# to develop the webapi backend interface based on the .net platform to realize the addition, deletion, modification and query functions of the detection data in the MySQL or SQL Server database, develop the front-end display interface based on the Vue framework, and deploy the front-end program on the remote server to display data and information interaction. The remote server reads the detection data of each industrial computer through the data interaction APP, and uniformly manages the detection data. It can monitor whether data anomalies occur in real time by comparing the change status of the detection data, and report the abnormal alarm in real time when the data anomaly occurs, and promptly remind relevant personnel to handle it, which can solve the problem that the existing cigarette production detection data cannot be discovered in time when "abnormal stuck", which is easy to cause cigarette quality defects, and can improve the intelligence of cigarette production and the consistency of cigarette quality.

[0043] The method also includes: setting a client terminal, and checking the data collection online status of the quality detection device installed on each unit of cigarette equipment, the abnormal status of the detection equipment and the detection data through the client terminal.

[0044] The method further includes:

[0045] Query the production management scheduling data and determine whether there is scheduling information. If so, query the corresponding MySQL or SQL Server database to obtain the corresponding 5-minute cigarette machine and packaging machine operating speed and output time series data information.

[0046] The average value of the running speed is calculated, and the integral operation result is obtained by performing a mathematical integral operation on the production time series data. The integral operation result is divided by the calculation result of the average value of the running speed as an intermediate result.

[0047] It is determined whether the value of the intermediate result is equal to the set threshold value. If so, it is determined whether the detection data has data anomaly.

[0048] Furthermore, the determination of whether data anomalies occur in the detection data includes: sequentially acquiring detection counts of the quality inspection devices installed on the cigarette making machine and the packaging machine within 5 minutes, and determining whether the detection counts change; if not, determining that the quality inspection equipment has an "abnormal stuck" fault and that data anomalies exist.

[0049] Specifically, to realize the judgment of "abnormal jamming" of the installed quality inspection software, it is necessary to combine the production management scheduling data and the cigarette equipment production data for judgment. Specifically, it is necessary to query the current scheduling information of a certain unit of cigarette equipment, and then query the operating speed and output data in the current period, and finally query the detection data of the quality inspection device installed on the unit in the corresponding time period. If there are changes in the operating speed and output information during this period, but the detection data of the corresponding detection device has not changed, it is considered that the detection device is "abnormally stuck" and the judgment result is saved in the remote server MySQL or SQL Server database.

[0050] The method also includes: when the remote server determines that a data anomaly occurs, the anomaly information is pushed to the mobile terminal of the equipment personnel through the data interaction APP to remind timely processing.

[0051] In actual applications, information such as "abnormal jamming" of detection equipment is sent to relevant functional personnel in the form of text messages or corporate WeChat messages to facilitate their subsequent handling.

[0052] It can be seen that the present invention provides a monitoring method for abnormal data in the cigarette production process, in which the detection data collected by the quality detection device on the cigarette equipment of each unit is stored in the MySQL or SQL Server database of the local industrial computer, and the remote server reads the detection data from the industrial computer through the industrial network, and reports the data abnormality alarm when the detection data is abnormal. The problem that the existing cigarette production detection data cannot be discovered in time when "abnormal stuck" occurs, which easily causes cigarette quality defects, can improve the intelligence of cigarette production, and improve the consistency of cigarette quality.

[0053] Correspondingly, the present invention also provides a monitoring system for abnormal data in the cigarette production process, using the above-mentioned monitoring method, including: a quality inspection device, an industrial computer and a remote server. The quality inspection device is installed on each unit of cigarette equipment to collect the inspection data of each unit of cigarette equipment. The quality inspection device is connected to the industrial computer signal, and the industrial computer is connected to the industrial network to connect to the remote server network. The remote server is provided with a data interaction APP to read the inspection data in the MySQL or SQL Server database of each industrial computer, and determine whether the inspection data has data anomalies. If so, report the data anomaly alarm, and store the judgment result in the MySQL or SQL Server database of the remote server.

[0054] The system also includes: a client terminal; a plurality of the client terminals are connected to the remote server network, and the data collection online status, abnormal status of the detection equipment and detection data of each quality detection device are checked through the client terminal.

[0055] The system also includes: an alarm device; the alarm device is connected to the industrial computer by signal, and when the remote server determines that the detection data of the corresponding quality detection device is abnormal, it sends an alarm instruction to the corresponding industrial computer, and the industrial computer controls the alarm device to alarm.

[0056] Furthermore, the alarm device includes at least any one of the following: an indicator light, a buzzer, and an audible and visual alarm.

[0057] Furthermore, the quality inspection device includes: cigarette appearance inspection equipment, cigarette physical index inspection equipment, cigarette empty end leakage inspection device, small package appearance inspection device, carton appearance inspection device, small package loose package inspection device and wire pulling inspection device.

[0058] It can be seen that the present invention provides a monitoring system for abnormal data in the cigarette production process, which stores the detection data collected by the quality detection device on the cigarette equipment of each unit in the MySQL or SQL Server database of the local industrial computer, and the remote server reads the detection data from the industrial computer through the industrial network, and reports the data abnormality alarm when the detection data is abnormal. It solves the problem that the existing cigarette production detection data cannot be discovered in time when it is "abnormally stuck", which easily causes cigarette quality defects, and can improve the intelligence of cigarette production and the consistency of cigarette quality.

[0059] The above describes in detail the structure, features and effects of the present invention based on the embodiments shown in the drawings. The above is only a preferred embodiment of the present invention, but the present invention is not limited to the scope of implementation shown in the drawings. Any changes made in accordance with the concept of the present invention, or modifications to equivalent embodiments with equivalent changes, which still do not exceed the spirit covered by the description and drawings, should be within the protection scope of the present invention.

Claims

1. A method for monitoring abnormal data in a cigarette production process, characterized in that: include: Connect the industrial computers corresponding to the quality inspection devices installed on each unit of cigarette equipment to the industrial network to connect to the remote server network; Save the collected data to the MySQL database or SQL Server database of the corresponding industrial computer; A data interaction APP is provided on the remote server to read the detection data in the MySQL or SQL Server database of each industrial computer and determine whether the detection data has data anomalies; If so, report the data abnormality alarm and store the judgment result in the MySQL or SQL Server database of the remote server.

2. The method for monitoring abnormal data in the cigarette production process according to claim 1, characterized in that: Also includes: A client terminal is provided, through which the online status of data collection of the quality inspection device installed on each unit of cigarette equipment, the abnormal status of the inspection equipment and the inspection data are checked.

3. The method for monitoring abnormal data in the cigarette production process according to claim 2, characterized in that: Also includes: Query the production management scheduling data and determine whether there is scheduling information. If yes, query the corresponding MySQL or SQL Server database to obtain the corresponding 5-minute cigarette machine and packaging machine operating speed and output time series data information; The average value of the running speed is calculated, and the integral operation result is obtained by performing mathematical integration operation on the production time series data, and the integral operation result is divided by the calculation result of the average value of the running speed as the intermediate result; It is determined whether the value of the intermediate result is equal to the set threshold value. If so, it is determined whether the detection data has data anomaly.

4. The method for monitoring abnormal data in the cigarette production process according to claim 3, characterized in that: The determining whether the detection data has data anomaly includes: The detection counts of the quality inspection devices installed on the cigarette making machine and the packaging machine within 5 minutes are obtained in sequence to determine whether the detection counts have changed. If not, it is determined that the quality inspection equipment has an "abnormal jam" fault and there is data abnormality.

5. The method for monitoring abnormal data in cigarette production process according to claim 4, characterized in that: Also includes: When the remote server determines that a data anomaly occurs, the anomaly information is pushed to the mobile terminal of the equipment personnel through the data interaction APP to remind them to handle it in time.

6. A monitoring system for abnormal data in a cigarette production process, using the monitoring method according to any one of claims 1 to 5, characterized in that: include: Quality inspection equipment, industrial computers and remote servers; Install the quality inspection device on each cigarette making equipment unit to collect inspection data of each cigarette making equipment unit; The quality detection device is connected to the industrial computer by signal, and the industrial computer is connected to the industrial network to be connected to the remote server network; The remote server is provided with a data interaction APP to read the detection data in the MySQL or SQL Server database of each industrial computer and determine whether the detection data has data anomalies; If so, report the data abnormality alarm and store the judgment result in the MySQL or SQL Server database of the remote server.

7. The monitoring system for abnormal data in cigarette production process according to claim 6, characterized in that: Also includes: Client terminal; A plurality of client terminals are connected to the remote server network, and the data collection online status, abnormal status of the detection equipment and detection data of each quality detection device are viewed through the client terminals.

8. The monitoring system for abnormal data in cigarette production process according to claim 7, characterized in that: Also includes: Alarm device; The alarm device is connected to the industrial computer by signal. When the remote server determines that the detection data of the corresponding quality detection device is abnormal, it sends an alarm instruction to the corresponding industrial computer, and the industrial computer controls the alarm device to alarm.

9. The monitoring system for abnormal data in cigarette production process according to claim 8, characterized in that: The alarm device includes at least any one of the following: an indicator light, a buzzer and an audible and visual alarm.

10. The monitoring system for abnormal data in cigarette production process according to claim 9, characterized in that: The quality inspection device includes: cigarette appearance inspection equipment, cigarette physical index inspection equipment, cigarette empty end leakage inspection device, small package appearance inspection device, strip box appearance inspection device, small package loose package inspection device and wire pulling inspection device.

Images