A method and system for collecting and uploading gas consumption data for optical fiber preform production

Abstract

The present invention discloses a method and system for collecting and uploading gas consumption data for optical fiber preform production, the method comprising the following steps: real-time collection of raw material consumption data during the production of optical fiber preform and keeping records, collection of total raw material consumption data after the production of optical fiber preform is completed and mining and processing thereof, obtaining product information during the production of optical fiber preform, and uploading it to a process server, and uploading the data processed by the process server to a database server and an MES system for storage and remote viewing. The present invention can count all gas consumption during the current product production in real time, and realize the communication connection between each process server and the database server and the MES system by developing a VB script, and automatically upload the gas consumption data of a single product to the database server and the MES system, so as to provide a data basis for process engineers to perform process debugging, without making any changes to the equipment hardware, and without increasing any equipment function development costs.

Description

Technical Field

[0001] The invention belongs to the technical field of optical fiber preform preparation, and in particular relates to a method and system for collecting and uploading gas consumption data for optical fiber preform production. Background Art

[0002] With the advent of the 5G era, the country has increased its policy support for the information industry, and the optical communication industry has developed rapidly. Optical fiber, as a transmission medium for optical communication, has also been widely used. The current manufacturing process of optical fiber preforms covers welding, deposition, sintering, and extension. A large amount of gas is used in these processes. The current methods for collecting gas usage are relatively fixed, such as installing instruments and meters through pipelines to measure gas data. This method is costly for processes that use a large number of gas types, and requires regular maintenance, and the operation is relatively cumbersome. In the early years, the applicant manually calculated the gas usage by pulling the gas flow history curve in the upper computer interface, but this method was time-consuming and labor-intensive, and the work efficiency was extremely low. There is currently little research on automatic gas data collection in the field of optical fiber preform manufacturing. Therefore, it is necessary to develop a convenient, fast, and highly automatic method for collecting product gas usage data. Summary of the invention

[0003] In order to solve the technical problems existing in the prior art, the purpose of the present invention is to provide a method and system for collecting and uploading gas consumption data for optical fiber preform production.

[0004] In order to achieve the above purpose and the above technical effect, the technical solution adopted by the present invention is:

[0005] A method for collecting and uploading gas consumption data for optical fiber preform production comprises the following steps:

[0006] The raw material usage data in the optical fiber preform production process is collected in real time and recorded. After the optical fiber preform production is completed, the total raw material usage data is collected and mined to obtain the product information in the optical fiber preform production process. It is then uploaded to the process server through the workshop ring network module for analysis and processing. The process server develops VB scripts to achieve communication connection with the database server and MES system. The data processed by the process server is uploaded to the database server and MES system for storage and remote viewing.

[0007] Furthermore, the gas usage data in the optical fiber preform production process is collected in real time and recorded. After the optical fiber preform production is completed, the total gas usage data is collected and mined to obtain product information in the optical fiber preform production process, including deposition rate and raw material utilization rate. The data is then uploaded to the process server through the workshop ring network module for analysis and processing. The process server develops a VB script to achieve communication connection with the database server and the MES system. The data processed by the process server is uploaded to the database server and the MES system for storage and remote viewing.

[0008] Furthermore, the gas usage statistics module collects the gas usage data in the optical fiber preform production process in real time and records them one by one according to the loose body number and machine number, and records the start time and the end time at the same time. The user can obtain the repeatability, △ value and hydrogen-oxygen ratio of the production product based on the data collected by the gas usage statistics module; the gas usage mining and analysis module mines and processes the gas usage data in the optical fiber preform production process to obtain product information in the optical fiber preform production process, including raw material utilization and production rate. The gas usage mining and analysis module uploads the processed data information to the process server through the workshop ring network module for analysis and processing, and then uploads it to the database server and MES system for storage and remote viewing.

[0009] The present invention discloses a system for collecting and uploading gas usage data for optical fiber preform production, and adopts a method for collecting and uploading gas usage data for optical fiber preform production to collect and upload gas usage data, including:

[0010] Gas usage statistics module;

[0011] Gas usage mining and analysis module;

[0012] Workshop ring network module;

[0013] VB script development module;

[0014] Process server;

[0015] Database server;

[0016] MES system;

[0017] The gas usage statistics module is connected to the gas usage mining and analysis module and then connected to the process server. The process server includes a VB script development module. The process server is connected to the database server and the MES system respectively through the VB script development module to achieve data sharing.

[0018] The present invention collects the gas consumption data in the optical fiber preform production process in real time, but the data finally uploaded to the server and the MES system is the total gas consumption data after the optical fiber preform production is completed. The data mining process adopts the following method:

[0019] The corresponding deposition rate, raw material utilization rate and other information are calculated mainly based on the usage data of different types of gases. These information will be uploaded to the MES system as product-related data information.

[0020] The process engineer exports the gas consumption data from the database server in the form of an EXCEL table, and then screens the relevant data, calculates or forms a trend chart to analyze the data to obtain the repeatability, △ value and hydrogen-oxygen ratio of the production products, providing a basis for adjusting the process parameters. The finance department uses a table to calculate the total consumption of each gas in the previous month, and calculates the consumption cost of gas and raw materials in combination with the corresponding unit price, providing data support for calculating product profits.

[0021] Compared with the prior art, the present invention has the following beneficial effects:

[0022] 1. The present invention does not make any changes to the device hardware, maintains the stability of the device, and does not increase any device function development costs;

[0023] 2. In terms of function promotion, the present invention can be promoted in packages, has strong functional applicability in the field of optical fiber preform manufacturing, greatly saves labor costs, and improves the level of workshop informatization;

[0024] 3. The VB development script for automatic data upload is highly open and is not limited to gas consumption data. It provides a channel for the overall package upload of other relevant product data;

[0025] 4. The collected data are recorded one by one according to the loose body number and machine number, and the start and end time are recorded. The process engineer can filter the collected data information according to the needs;

[0026] 5. The collected data provide data basis and data support for process engineers to analyze the machine stability and the repeatability, △ value, hydrogen-oxygen ratio, etc. of the produced products;

[0027] 6. The collection of gas data provides support for the calculation of product information such as raw material utilization rate and production rate, thus providing a prerequisite for in-depth mining of product information;

[0028] 7. Data is automatically uploaded to the database server and MES system to share product data. Process engineers optimize process parameters and improve product quality. The finance department calculates costs and profits based on the data, and finally feeds back the information to other relevant departments to provide data basis for optimized management. BRIEF DESCRIPTION OF THE DRAWINGS

[0029] Figure 1 It is a principle block diagram of the present invention. DETAILED DESCRIPTION

[0030] The present invention is described in detail below in conjunction with the accompanying drawings so that the advantages and features of the present invention can be more easily understood by those skilled in the art, thereby making a clearer and more definite definition of the protection scope of the present invention.

[0031] A brief summary of one or more aspects is given below to provide a basic understanding of these aspects. This summary is not an exhaustive overview of all conceived aspects, and is neither intended to identify the key or critical elements of all aspects nor to define the scope of any or all aspects. Its only purpose is to give some concepts of one or more aspects in a simplified form as a prelude to a more detailed description that will be given later.

[0032] like Figure 1 As shown, a method for collecting and uploading gas consumption data for optical fiber preform production can count all gas consumption of the current product of the equipment from the start of production to the start of production of the next product in real time, and realize the communication connection between each process server and the database server and the MES system by developing VB scripts, and automatically upload the gas consumption data of a single product to the database server and the MES system, so as to provide a data basis for process engineers to perform process debugging, which mainly includes the following steps:

[0033] The raw material usage data in the optical fiber preform production process is collected in real time and recorded. After the optical fiber preform production is completed, the total raw material usage data is collected and mined to obtain the product information in the optical fiber preform production process. It is then uploaded to the process server through the workshop ring network module for analysis and processing. The process server develops VB scripts to achieve communication connection with the database server and MES system. The data processed by the process server is uploaded to the database server and MES system for storage and remote viewing.

[0034] As a specific implementation method, the present invention can realize real-time collection of gas usage data during the production of optical fiber preforms and keep records. After the production of optical fiber preforms is completed, the total gas usage data is collected and mined to obtain product information during the production of optical fiber preforms, including deposition rate and raw material utilization rate, which is then uploaded to the process server through the workshop ring network module for analysis and processing. The process server develops a VB script to achieve communication connection with the database server and the MES system. The data processed by the process server is uploaded to the database server and the MES system for storage and remote viewing.

[0035] As a more specific implementation mode, the present invention preferably collects the gas usage data in the optical fiber preform production process in real time through the gas usage statistics module and records them one by one according to the loose body number and the machine number, and records the start time and the end time at the same time. The user can obtain the repeatability, △ value and hydrogen-oxygen ratio of the production product based on the data collected by the gas usage statistics module; the gas usage data in the optical fiber preform production process is mined and processed through the gas usage mining and analysis module to obtain the product information in the optical fiber preform production process, including the raw material utilization rate and the production rate, etc. The gas usage mining and analysis module uploads the processed data information to the process server through the workshop ring network module for analysis and processing, and then uploads it to the database server and MES system for storage and remote viewing.

[0036] The present invention also discloses a gas consumption data collection and uploading system for optical fiber preform production, comprising:

[0037] Gas usage statistics module;

[0038] Gas usage mining and analysis module;

[0039] Workshop ring network module;

[0040] VB script development module;

[0041] Process server;

[0042] Database server;

[0043] MES system;

[0044] The gas usage statistics module is connected to the gas usage mining and analysis module and then to the process server. The process server includes a VB script development module. The process server is connected to the database server and the MES system respectively through the VB script development module to realize data sharing and maximize its data value. Each department optimizes the process, cost, management and other aspects based on the uploaded data, providing data support for process engineers to improve the process and improve the quality, and for the finance department to perform cost and profit accounting. This function greatly optimizes process parameters, improves product quality, saves labor costs, improves the level of workshop informatization, and realizes closed-loop management of products.

[0045] Parts not specifically described in the present invention may adopt existing technologies and will not be described in detail here.

[0046] The above descriptions are merely embodiments of the present invention and are not intended to limit the patent scope of the present invention. Any equivalent structure or equivalent process transformation made using the contents of the present invention specification, or directly or indirectly applied in other related technical fields, are also included in the patent protection scope of the present invention.

Claims

1. A method for collecting and uploading gas consumption data for optical fiber preform production, characterized in that: The optical fiber preform production gas consumption data collection and uploading system is used to collect and upload data. The optical fiber preform production gas consumption data collection and uploading system includes: Gas usage statistics module; Gas usage mining and analysis module; Workshop ring network module; VB script development module; Process server; Database server; MES system; The gas usage statistics module is connected to the gas usage mining and analysis module and then connected to the process server. The process server includes a VB script development module. The process server is connected to the database server and the MES system through the VB script development module to achieve data sharing. The method comprises the following steps: Collect gas usage data in the optical fiber preform production process in real time and keep records. After the optical fiber preform production is completed, collect total gas usage data and mine and process it to obtain product information in the optical fiber preform production process, including deposition rate and raw material utilization rate. Then upload it to the process server through the workshop ring network module for analysis and processing. The process server develops VB scripts to achieve communication connection with the database server and MES system. The data processed by the process server is uploaded to the database server and MES system for storage and remote viewing. The gas usage statistics module collects the gas usage data in the optical fiber preform production process in real time and records them one by one according to the loose body number and machine number, and records the start time and end time at the same time. The user can obtain the repeatability, △ value and hydrogen-oxygen ratio of the production product based on the data collected by the gas usage statistics module; the gas usage mining and analysis module mines and processes the gas usage data in the optical fiber preform production process to obtain product information in the optical fiber preform production process, including raw material utilization and production rate. The gas usage mining and analysis module uploads the processed data information to the process server through the workshop ring network module for analysis and processing, and then uploads it to the database server and MES system for storage and remote viewing; The user exports the gas usage data from the database server in the form of an EXCEL table, and then filters the relevant data and analyzes the data by calculation or forming a trend chart to obtain the repeatability, △ value and hydrogen-oxygen ratio of the production products, providing a basis for adjusting the process parameters; the total usage of each gas in the previous month is statistically calculated through a table, and the consumption cost of gas and raw materials is calculated in combination with the corresponding unit price, providing data support for calculating product profits.

Images