CN113656463A - Method and system for acquiring and uploading gas consumption data for optical fiber preform production - Google Patents
Method and system for acquiring and uploading gas consumption data for optical fiber preform production Download PDFInfo
- Publication number
- CN113656463A CN113656463A CN202110953400.4A CN202110953400A CN113656463A CN 113656463 A CN113656463 A CN 113656463A CN 202110953400 A CN202110953400 A CN 202110953400A CN 113656463 A CN113656463 A CN 113656463A
- Authority
- CN
- China
- Prior art keywords
- optical fiber
- data
- production
- server
- module
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 73
- 238000004519 manufacturing process Methods 0.000 title claims abstract description 53
- 239000013307 optical fiber Substances 0.000 title claims abstract description 52
- 239000002994 raw material Substances 0.000 claims abstract description 26
- 238000011161 development Methods 0.000 claims abstract description 13
- 238000004891 communication Methods 0.000 claims abstract description 9
- 238000003860 storage Methods 0.000 claims abstract description 7
- 239000007789 gas Substances 0.000 claims description 68
- 238000005065 mining Methods 0.000 claims description 15
- 238000012545 processing Methods 0.000 claims description 12
- 238000004458 analytical method Methods 0.000 claims description 7
- 230000008021 deposition Effects 0.000 claims description 5
- 238000000151 deposition Methods 0.000 claims description 5
- 239000001301 oxygen Substances 0.000 claims description 5
- 229910052760 oxygen Inorganic materials 0.000 claims description 5
- 238000007726 management method Methods 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 238000004806 packaging method and process Methods 0.000 description 2
- 238000009412 basement excavation Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000007418 data mining Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000009434 installation Methods 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000005259 measurement Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 238000013386 optimize process Methods 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 238000005245 sintering Methods 0.000 description 1
- 238000003466 welding Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2465—Query processing support for facilitating data mining operations in structured databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L12/00—Data switching networks
- H04L12/28—Data switching networks characterised by path configuration, e.g. LAN [Local Area Networks] or WAN [Wide Area Networks]
- H04L12/42—Loop networks
Abstract
The invention discloses a method and a system for acquiring and uploading gas consumption data for producing an optical fiber preform, wherein the method comprises the following steps: the method comprises the steps of collecting and recording raw material consumption data in the production process of the optical fiber perform in real time, collecting and excavating the lump raw material consumption data after the production of the optical fiber perform is finished, obtaining product information in the production process of the optical fiber perform, uploading the product information 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 invention can count all gas consumption in the current product production period in real time, realize the communication connection between each process server and the database server and the MES system by developing the VB script, and automatically upload the gas consumption data of a single product to the database server and the MES system for process engineers to debug and provide a data base, and does not change equipment hardware and increase the development cost of any equipment function.
Description
Technical Field
The invention belongs to the technical field of optical fiber perform preparation, and particularly relates to a method and a system for acquiring and uploading gas consumption data for optical fiber perform production.
Background
With the coming of the 5G era, the country increases policy support for information industry, the optical communication industry develops rapidly, optical fibers are widely used as transmission media of optical communication, the current optical fiber perform manufacturing process flow covers the aspects of welding, deposition, sintering, extension and the like, a large amount of gas is used in the process production process, the current gas usage collection method is fixed, and if gas data measurement is carried out through a pipeline installation instrument, the method has higher cost for the process using more types of gas, needs regular maintenance and is more complicated to operate. In the early years, the applicant calculates the gas consumption manually by pulling a gas flow historical curve in an upper computer interface, but the method is time-consuming and labor-consuming and has extremely low working efficiency. At present, the research on automatic gas data acquisition in the field of optical fiber preform manufacturing is less, so that a method for acquiring product gas consumption data, which is convenient and rapid and has higher automation degree, is necessary to be developed.
Disclosure of Invention
In order to solve the technical problems in the prior art, the invention aims to provide a method and a system for acquiring and uploading gas consumption data for producing an optical fiber preform.
In order to achieve the purpose and achieve the technical effect, the invention adopts the technical scheme that:
a method for collecting and uploading gas usage data for optical fiber preform production comprises the following steps:
the method comprises the steps of collecting raw material consumption data in the production process of the optical fiber perform in real time and recording the raw material consumption data, collecting lump raw material consumption data after the production of the optical fiber perform is finished and carrying out mining processing on the lump raw material consumption data, obtaining product information in the production process of the optical fiber perform, uploading the lump raw material consumption data to a process server through a workshop ring network module for analysis and processing, realizing communication connection between the process server and a database server and an MES system through developing a VB script, and uploading the data processed by the process server to the database server and the MES system for storage and remote viewing.
Further, gas consumption data in the production process of the optical fiber perform is collected in real time and recorded, lump gas consumption data are collected and mined after the optical fiber perform is produced, product information in the production process of the optical fiber perform is obtained, including deposition rate and raw material utilization rate, the lump gas consumption data are uploaded to a process server through a workshop ring network module to be analyzed and processed, the process server is communicated with a database server and an MES system through developing a VB script, and the data processed by the process server are uploaded to the database server and the MES system to be stored and remotely checked.
Furthermore, gas consumption data in the production process of the optical fiber preform rod are collected in real time through a gas consumption counting module, the record is carried out one by one according to the loose body number and the machine number, the starting time and the ending time are recorded simultaneously, and the repeatability, the delta value and the hydrogen-oxygen ratio of a produced product can be obtained by a user according to the data collected by the gas consumption counting module; the gas consumption mining and analyzing module is used for mining and processing gas consumption data in the production process of the optical fiber perform rod, product information in the production process of the optical fiber perform rod is obtained, and the product information comprises the raw material utilization rate and the production rate, the processed data information is uploaded to the process server through the workshop ring network module to be analyzed and processed, and then the processed data information is uploaded to the database server and the MES system to be stored and remotely checked.
The invention discloses a gas usage data acquisition and uploading system for optical fiber perform production, which adopts a gas usage data acquisition and uploading method for optical fiber perform production to acquire and upload gas usage data, and comprises the following steps:
a gas dosage statistic module;
a gas usage mining and analyzing module;
a workshop looped network module;
a VB script development module;
a process server;
a database server;
a MES system;
the gas consumption counting module is connected with the gas consumption mining and analyzing module and then connected to the process server, the process server comprises a VB script development module, and the process server is respectively connected with the database server and the MES system through the VB script development module to realize data sharing.
The invention collects the gas consumption data in the production process of the optical fiber perform in real time, but the data uploaded to the server and the MES system is the total gas consumption data after the production of the optical fiber perform is finished, and the data mining process adopts the following method:
the corresponding information such as deposition rate, raw material utilization rate and the like is obtained by calculation according to the consumption data of different types of gases, and the information is uploaded to an MES system to serve as relevant data information of products.
The process engineer exports the gas consumption data from the database server in the form of EXCEL table, screens the related data, and obtains the data of repeatability, delta value, hydrogen-oxygen ratio and the like of the produced product by calculating or forming a trend graph to analyze the data, thereby providing a basis for adjusting the process parameters. And accounting the total consumption of each gas in the last month through a table, calculating the consumption cost of the gas and the raw materials by combining the corresponding unit price, and providing data support for calculating the profit of the product.
Compared with the prior art, the invention has the beneficial effects that:
1. the invention does not change the hardware of the equipment, maintains the stability of the equipment and does not increase the development cost of any equipment function;
2. in the aspect of function popularization, the invention can realize packaging popularization, has stronger function applicability in the field of optical fiber perform manufacturing, greatly saves labor cost and improves the information level of a workshop;
3. the automatic data uploading VB development script has strong openness, is not limited to gas consumption data, and provides a channel for the overall packaging and uploading of other related data of the product;
4. the collected data are recorded one by one according to the number of the loose body and the number of the machine station, the starting time and the ending time are recorded, and a process engineer can screen the collected data information as required;
5. through the collected data, a data base and a data support are provided for a process engineer to perform data analysis on the stability of a machine station and the repeatability, the delta value, the hydrogen-oxygen ratio and the like of a produced product;
6. the acquisition of gas data provides support for the calculation of product information such as raw material utilization rate, production rate and the like, thereby providing a precondition for the deep excavation of the product information;
7. the data are automatically uploaded to a database server and an MES system to enable product data to be shared, process engineers optimize process parameters and improve product quality, a financial department performs cost and profit accounting according to the data, and finally, information is fed back to other related departments to provide data basis for optimization management.
Drawings
Fig. 1 is a schematic block diagram of the present invention.
Detailed Description
The present invention is described in detail below with reference to the attached drawings so that the advantages and features of the present invention can be more easily understood by those skilled in the art, thereby clearly defining the protection scope of the present invention.
The following presents a simplified summary of one or more aspects in order to provide a basic understanding of such aspects. This summary is not an extensive overview of all contemplated aspects, and is intended to neither identify key or critical elements of all aspects nor delineate the scope of any or all aspects. Its sole purpose is to present some concepts of one or more aspects in a simplified form as a prelude to the more detailed description that is presented later.
As shown in fig. 1, a method for collecting and uploading gas usage data for optical fiber preform production can count all gas usage of a current product of equipment in real time from production start to production start of a next product, realize communication connection between each process server and a database server and an MES system by developing a VB script, and automatically upload gas usage data of a single product to the database server and the MES system for a process engineer to perform process debugging and provide a data base, and mainly includes the following steps:
the method comprises the steps of collecting raw material consumption data in the production process of the optical fiber perform in real time and recording the raw material consumption data, collecting lump raw material consumption data after the production of the optical fiber perform is finished and carrying out mining processing on the lump raw material consumption data, obtaining product information in the production process of the optical fiber perform, uploading the lump raw material consumption data to a process server through a workshop ring network module for analysis and processing, realizing communication connection between the process server and a database server and an MES system through developing a VB script, and uploading the data processed by the process server to the database server and the MES system for storage and remote viewing.
As a specific implementation mode, the method can realize the real-time collection and recording of gas consumption data in the production process of the optical fiber perform, the lump gas consumption data is collected and mined after the optical fiber perform is produced, product information including deposition rate and raw material utilization rate in the production process of the optical fiber perform is obtained, the product information is uploaded to a process server for analysis and processing through a workshop ring network module, the process server realizes the communication connection with a database server and an MES system through developing a VB script, and the data processed by the process server is uploaded to the database server and the MES system for storage and remote viewing.
As a more specific implementation manner, the invention preferably collects the gas consumption data in the production process of the optical fiber preform in real time through the gas consumption statistical module, records the data item by item according to the loose body number and the machine number, and records the start time and the end time at the same time, so that the user can obtain the repeatability, the delta value, the hydrogen-oxygen ratio and the like of the produced product according to the data collected by the gas consumption statistical module; the gas consumption mining and analyzing module is used for mining and processing gas consumption data in the production process of the optical fiber perform to acquire product information in the production process of the optical fiber perform, wherein the product information comprises the raw material utilization rate, the production rate and the like, the gas consumption mining and analyzing module uploads the processed data information to the process server through the workshop ring network module for analysis and processing, and then the processed data information is uploaded to the database server and the MES system for storage and remote check.
The invention also discloses a system for acquiring and uploading the gas consumption data for producing the optical fiber preform, which comprises the following components:
a gas dosage statistic module;
a gas usage mining and analyzing module;
a workshop looped network module;
a VB script development module;
a process server;
a database server;
a MES system;
gas consumption statistics module and gas consumption are excavated and analysis module link to each other and are reconnected to the process server, the process server includes VB script development module, the process server passes through VB script development module and links to each other with database server and MES system respectively, realize data sharing, maximize its data value, each department is according to the data of uploading at technology, cost, the aspect such as management is optimized, improve technology for the process engineer, improve quality and financial department and carry out the cost, profit accounting provides data support, the technological parameter is greatly optimized to this kind of function, improve product quality, can practice thrift the cost of labor, improve workshop informatization level, realize product closed-loop management.
The parts of the invention not specifically described can be realized by adopting the prior art, and the details are not described herein.
The above description is only an embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by the present specification, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (4)
1. A method for collecting and uploading gas usage data for optical fiber preform production is characterized by comprising the following steps:
the method comprises the steps of collecting raw material consumption data in the production process of the optical fiber perform in real time and recording the raw material consumption data, collecting lump raw material consumption data after the production of the optical fiber perform is finished and carrying out mining processing on the lump raw material consumption data, obtaining product information in the production process of the optical fiber perform, uploading the lump raw material consumption data to a process server through a workshop ring network module for analysis and processing, realizing communication connection between the process server and a database server and an MES system through developing a VB script, and uploading the data processed by the process server to the database server and the MES system for storage and remote viewing.
2. The method for collecting and uploading the gas usage data for the production of the optical fiber preform as claimed in claim 1, wherein the gas usage data in the production process of the optical fiber preform is collected in real time and recorded, the mass gas usage data is collected and mined after the production of the optical fiber preform is finished, product information including deposition rate and raw material utilization rate in the production process of the optical fiber preform is obtained and uploaded to a process server for analysis and processing through a workshop ring network module, the process server is in communication connection with the database server and an MES system through development of a VB script, and the data processed by the process server is uploaded to the database server and the MES system for storage and remote viewing.
3. The method for collecting and uploading the gas usage data for the production of the optical fiber preform as claimed in claim 2, wherein the gas usage data during the production of the optical fiber preform is collected in real time by the gas usage statistics module and is recorded item by item according to the loose body number and the machine number, and the start time and the end time are recorded at the same time, so that the repeatability, the delta value and the hydrogen-oxygen ratio of the produced product can be obtained by a user according to the data collected by the gas usage statistics module; the gas consumption mining and analyzing module is used for mining and processing gas consumption data in the production process of the optical fiber perform rod, product information in the production process of the optical fiber perform rod is obtained, and the product information comprises the raw material utilization rate and the production rate, the processed data information is uploaded to the process server through the workshop ring network module to be analyzed and processed, and then the processed data information is uploaded to the database server and the MES system to be stored and remotely checked.
4. A gas usage data acquisition and upload system for optical fiber preform production, characterized in that, the gas usage data acquisition and upload method for optical fiber preform production according to any one of claims 1 to 3 is adopted for gas usage data acquisition and upload, comprising:
a gas dosage statistic module;
a gas usage mining and analyzing module;
a workshop looped network module;
a VB script development module;
a process server;
a database server;
a MES system;
the gas consumption counting module is connected with the gas consumption mining and analyzing module and then connected to the process server, the process server comprises a VB script development module, and the process server is respectively connected with the database server and the MES system through the VB script development module to realize data sharing.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110953400.4A CN113656463A (en) | 2021-08-19 | 2021-08-19 | Method and system for acquiring and uploading gas consumption data for optical fiber preform production |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110953400.4A CN113656463A (en) | 2021-08-19 | 2021-08-19 | Method and system for acquiring and uploading gas consumption data for optical fiber preform production |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113656463A true CN113656463A (en) | 2021-11-16 |
Family
ID=78481256
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110953400.4A Pending CN113656463A (en) | 2021-08-19 | 2021-08-19 | Method and system for acquiring and uploading gas consumption data for optical fiber preform production |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113656463A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114398529A (en) * | 2021-12-27 | 2022-04-26 | 江苏亨通数字智能科技有限公司 | Optical wand detaching method and device and storage medium |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104572975A (en) * | 2014-12-31 | 2015-04-29 | 中国石油天然气股份有限公司 | Real-time data processing analysis system |
| CN104635640A (en) * | 2013-11-12 | 2015-05-20 | 宁夏巨能机器人系统有限公司 | Informatization production management system of equipment for machining before bearing grinding |
| CN107911367A (en) * | 2017-11-17 | 2018-04-13 | 广州中国科学院沈阳自动化研究所分所 | One kind digitlization workshop network and data exchange system |
| CN108388223A (en) * | 2018-04-03 | 2018-08-10 | 深圳市同富信息技术有限公司 | It is a kind of to be used for apparatus control system of the wisdom factory based on data closed loop |
| CN207976762U (en) * | 2017-12-08 | 2018-10-16 | 中国科学院自动化研究所 | Wide area network Distributed Real Time Data Acquisition and management system |
| CN111104535A (en) * | 2019-11-20 | 2020-05-05 | 中国第一汽车股份有限公司 | Data management system and data management method |
| CN111273628A (en) * | 2020-03-18 | 2020-06-12 | 电子科技大学中山学院 | Data acquisition system and device for intelligent manufacturing of weighing sensor |
| CN111624960A (en) * | 2020-04-23 | 2020-09-04 | 北京机械工业自动化研究所有限公司 | Intelligent remote parameter monitoring system of manned spacecraft manufacturing equipment production line |
-
2021
- 2021-08-19 CN CN202110953400.4A patent/CN113656463A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104635640A (en) * | 2013-11-12 | 2015-05-20 | 宁夏巨能机器人系统有限公司 | Informatization production management system of equipment for machining before bearing grinding |
| CN104572975A (en) * | 2014-12-31 | 2015-04-29 | 中国石油天然气股份有限公司 | Real-time data processing analysis system |
| CN107911367A (en) * | 2017-11-17 | 2018-04-13 | 广州中国科学院沈阳自动化研究所分所 | One kind digitlization workshop network and data exchange system |
| CN207976762U (en) * | 2017-12-08 | 2018-10-16 | 中国科学院自动化研究所 | Wide area network Distributed Real Time Data Acquisition and management system |
| CN108388223A (en) * | 2018-04-03 | 2018-08-10 | 深圳市同富信息技术有限公司 | It is a kind of to be used for apparatus control system of the wisdom factory based on data closed loop |
| CN111104535A (en) * | 2019-11-20 | 2020-05-05 | 中国第一汽车股份有限公司 | Data management system and data management method |
| CN111273628A (en) * | 2020-03-18 | 2020-06-12 | 电子科技大学中山学院 | Data acquisition system and device for intelligent manufacturing of weighing sensor |
| CN111624960A (en) * | 2020-04-23 | 2020-09-04 | 北京机械工业自动化研究所有限公司 | Intelligent remote parameter monitoring system of manned spacecraft manufacturing equipment production line |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114398529A (en) * | 2021-12-27 | 2022-04-26 | 江苏亨通数字智能科技有限公司 | Optical wand detaching method and device and storage medium |
| CN114398529B (en) * | 2021-12-27 | 2023-12-01 | 江苏亨通数字智能科技有限公司 | Optical wand disassembly method, optical wand disassembly device and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108971807B (en) | Intelligent management control method and management system for field welding construction process | |
| KR101935652B1 (en) | System and Method of Smart Factory Operation Management Solution Service Using Big Data Platform | |
| CN104468259B (en) | A kind of communication traffic rate automated testing method | |
| CN105761010A (en) | Method and system for real-time monitoring of group enterprise audit based on real-time data acquisition | |
| CN113435054A (en) | Carbon emission assessment method and system based on digital twin model | |
| CN107909300A (en) | Intelligent plant management platform and method | |
| CN116308211B (en) | Enterprise intelligent management system and method based on big data | |
| CN113656463A (en) | Method and system for acquiring and uploading gas consumption data for optical fiber preform production | |
| CN111178688A (en) | Self-service analysis method and system for power technology supervision data, storage medium and computer equipment | |
| CN112446608A (en) | OEE and Andon safety lamp management system and working method thereof | |
| CN109344168A (en) | Supervise method, platform, equipment and the storage medium of plant produced operation state | |
| CN105223927B (en) | Manufacture system is researched and developed in a kind of continuously casting cloud computing | |
| CN109101001B (en) | Composite probe value chain data acquisition and monitoring method | |
| CN108983723A (en) | A kind of site construction technology intelligent management control method and management system | |
| CN113506098A (en) | Power plant metadata management system and method based on multi-source data | |
| CN113065737A (en) | DevOps-based efficiency measurement method and system | |
| CN116187622A (en) | Digital production management method and system based on polishing workshop | |
| CN115587798A (en) | Supply chain information collaborative management system based on block chain | |
| CN116051025A (en) | Digital twin foundation development platform oriented to energy consumption of park | |
| CN113888018A (en) | Steelmaking process production big data system | |
| CN115097797A (en) | Distributed energy cloud management and control system based on internet | |
| CN113359567A (en) | Energy consumption monitoring platform for key energy consumption unit | |
| CN110008245B (en) | Method suitable for searching equipment fault early warning model time period | |
| CN1704947A (en) | Mold processing productivity load disposal system and method | |
| CN112329410A (en) | Graphical report batch generation tool |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |