CN110610295A - Universal integrated acquisition system and method for resource environment load data - Google Patents
Universal integrated acquisition system and method for resource environment load data Download PDFInfo
- Publication number
- CN110610295A CN110610295A CN201910749647.7A CN201910749647A CN110610295A CN 110610295 A CN110610295 A CN 110610295A CN 201910749647 A CN201910749647 A CN 201910749647A CN 110610295 A CN110610295 A CN 110610295A
- Authority
- CN
- China
- Prior art keywords
- data
- sensor
- acquisition
- measured
- value
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 53
- 238000012545 processing Methods 0.000 claims abstract description 34
- 238000004364 calculation method Methods 0.000 claims abstract description 32
- 238000005070 sampling Methods 0.000 claims abstract description 29
- 230000002159 abnormal effect Effects 0.000 claims abstract description 26
- 239000000428 dust Substances 0.000 claims abstract description 20
- 239000012855 volatile organic compound Substances 0.000 claims abstract description 17
- 238000005303 weighing Methods 0.000 claims abstract description 13
- 230000008030 elimination Effects 0.000 claims abstract description 12
- 238000003379 elimination reaction Methods 0.000 claims abstract description 12
- 230000007613 environmental effect Effects 0.000 claims abstract description 12
- 238000004891 communication Methods 0.000 claims abstract description 11
- 239000000463 material Substances 0.000 claims description 11
- 238000005259 measurement Methods 0.000 claims description 11
- 239000000126 substance Substances 0.000 claims description 11
- 238000003754 machining Methods 0.000 claims description 8
- 238000003860 storage Methods 0.000 claims description 7
- 238000009826 distribution Methods 0.000 claims description 5
- 238000013500 data storage Methods 0.000 claims description 4
- 230000001419 dependent effect Effects 0.000 claims description 4
- 238000009792 diffusion process Methods 0.000 claims description 4
- 238000012417 linear regression Methods 0.000 claims description 4
- MWUXSHHQAYIFBG-UHFFFAOYSA-N Nitric oxide Chemical compound O=[N] MWUXSHHQAYIFBG-UHFFFAOYSA-N 0.000 abstract description 25
- RAHZWNYVWXNFOC-UHFFFAOYSA-N Sulphur dioxide Chemical compound O=S=O RAHZWNYVWXNFOC-UHFFFAOYSA-N 0.000 abstract description 17
- UGFAIRIUMAVXCW-UHFFFAOYSA-N Carbon monoxide Chemical compound [O+]#[C-] UGFAIRIUMAVXCW-UHFFFAOYSA-N 0.000 abstract description 12
- 229910002091 carbon monoxide Inorganic materials 0.000 abstract description 12
- CBENFWSGALASAD-UHFFFAOYSA-N Ozone Chemical compound [O-][O+]=O CBENFWSGALASAD-UHFFFAOYSA-N 0.000 abstract description 2
- 239000007789 gas Substances 0.000 description 19
- 238000004519 manufacturing process Methods 0.000 description 7
- 239000002173 cutting fluid Substances 0.000 description 4
- 238000001514 detection method Methods 0.000 description 3
- 239000003344 environmental pollutant Substances 0.000 description 3
- 231100000719 pollutant Toxicity 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 238000005034 decoration Methods 0.000 description 2
- 239000010419 fine particle Substances 0.000 description 2
- 238000009776 industrial production Methods 0.000 description 2
- 230000010354 integration Effects 0.000 description 2
- 238000012544 monitoring process Methods 0.000 description 2
- 231100000331 toxic Toxicity 0.000 description 2
- 230000002588 toxic effect Effects 0.000 description 2
- 238000012935 Averaging Methods 0.000 description 1
- 208000028571 Occupational disease Diseases 0.000 description 1
- 231100000570 acute poisoning Toxicity 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 238000005520 cutting process Methods 0.000 description 1
- 230000001627 detrimental effect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000007599 discharging Methods 0.000 description 1
- 238000005265 energy consumption Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000004880 explosion Methods 0.000 description 1
- 238000000227 grinding Methods 0.000 description 1
- 231100000206 health hazard Toxicity 0.000 description 1
- 238000009434 installation Methods 0.000 description 1
- 238000003801 milling Methods 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 150000002894 organic compounds Chemical class 0.000 description 1
- 239000002245 particle Substances 0.000 description 1
- 239000002994 raw material Substances 0.000 description 1
- 239000002910 solid waste Substances 0.000 description 1
- 238000007514 turning Methods 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
- 239000002351 wastewater Substances 0.000 description 1
- -1 workpieces Substances 0.000 description 1
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/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
- G06F17/10—Complex mathematical operations
- G06F17/18—Complex mathematical operations for evaluating statistical data, e.g. average values, frequency distributions, probability functions, regression analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/04—Manufacturing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Strategic Management (AREA)
- Economics (AREA)
- Tourism & Hospitality (AREA)
- Computational Mathematics (AREA)
- Entrepreneurship & Innovation (AREA)
- Mathematical Physics (AREA)
- Development Economics (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Educational Administration (AREA)
- General Engineering & Computer Science (AREA)
- General Business, Economics & Management (AREA)
- Pure & Applied Mathematics (AREA)
- Mathematical Optimization (AREA)
- Mathematical Analysis (AREA)
- Quality & Reliability (AREA)
- Health & Medical Sciences (AREA)
- Bioinformatics & Cheminformatics (AREA)
- Bioinformatics & Computational Biology (AREA)
- Primary Health Care (AREA)
- Evolutionary Biology (AREA)
- General Health & Medical Sciences (AREA)
- Life Sciences & Earth Sciences (AREA)
- Probability & Statistics with Applications (AREA)
- Manufacturing & Machinery (AREA)
- Algebra (AREA)
- Game Theory and Decision Science (AREA)
- Software Systems (AREA)
- Arrangements For Transmission Of Measured Signals (AREA)
Abstract
The invention discloses a universal integrated acquisition system and a universal integrated acquisition method for resource environmental load data, wherein the acquisition system comprises a data acquisition module, a data communication module and a data processing module, and is used for realizing integrated acquisition of various data and processing the acquired data by integrating sensors such as dust, noise, power, volatile organic compounds, sulfur dioxide, nitric oxide, carbon monoxide, ozone, an electronic weighing meter and the like; the collecting method comprises the steps of setting gas index concentration sampling points and arranging sensors at points to be measured; determining the index quantity needing to be collected in real time; after the data indexes are stable, data acquisition is carried out; and performing missing value compensation and data abnormal value elimination on the data, and performing weighted calculation on the measured data after the data missing value compensation and the abnormal value elimination. The invention can solve the problems of low acquisition efficiency and inaccurate acquisition result of the related indexes of the existing process workshop.
Description
Technical Field
The invention belongs to the field of workshop process environment monitoring, and particularly relates to a universal integrated acquisition system and method for resource environment load data.
Background
Modern manufacturing industries consume large quantities of materials and energy in the manufacturing process of converting resources into products, and produce large quantities of waste and harmful pollutants, which pose serious hazards to the environment and the health of operators. In the process resource load, the consumption of materials and energy is the main process input. In the process environment load, dust is the most common cause of various occupational diseases, and large-particle dust (PM100) is also easy to generate dust explosion in a production workshop; volatile Organic Compounds (VOCs) are products using organic compounds in production raw materials, and are easy to cause acute poisoning of workers; sulfur dioxide (SO)2) Nitrogen oxides (NOx), carbon monoxide (CO), ozone (O)3) The method is characterized in that the method is a common method for discharging toxic and harmful pollutants in the environment and is also an important occupational health hazard index; high decibel noise also can be detrimental to worker hearing and can affect surrounding residents. However, the detection aiming at the indexes is mainly realized by a single sensor at present, the steps are complicated, and the data samples are few; the detection of the related sensors mainly aims at the atmospheric environment, and the regulations of collection methods such as sampling positions and sampling time and the like when a workshop, particularly a single device, collects are lacked; a general integrated acquisition system and a general integrated acquisition method capable of integrally acquiring environmental load data of various resources in a workshop are lacked.
Chinese patent publication No. CN108351335A discloses an apparatus and method for collecting and recording density of fine particles and/or NOx gas in air, which introduces a vehicle-mounted apparatus and a mobile method for collecting and recording density of fine particles and NOx gas in air, the method mainly includes PM2.5 and NOx as measurement indexes, the detection indexes are few, and the integration level of collecting various sensors is low. Chinese patent publication No. CN105548502A discloses an air quality detector, which is mainly used in the field of environmental monitoring, and is suitable for being arranged everywhere in a city, but is not suitable for detecting in a complex workshop process environment because of insufficient index analysis of a relatively closed workshop environment in an industrial production scene, and cannot acquire data for a single discrete machine tool. Chinese patent publication No. CN 105865993a discloses an air quality detector, which mainly aims at toxic and harmful gases generated by interior decoration, and also cannot acquire data for a single machine tool. Meanwhile, the above patents do not perform data processing on the measured values, and do not propose related acquisition methods such as arrangement of an index acquisition sensor and setting of sampling frequency.
In summary, the current collection devices mainly aim at atmospheric environment and interior decoration, no collection system which can collect pollutants related to a single machine tool in a workshop in an integrated manner and is simple to operate exists, and the regulations on collection methods such as collection positions and sampling time are lacked, so that the green optimization of the manufacturing process and the improvement and development of occupational health of operators in the workshop are seriously hindered.
Disclosure of Invention
The invention aims to provide a universal integrated acquisition system and a universal integrated acquisition method for resource environmental load data, which aim to solve the problems of low acquisition efficiency and inaccurate acquisition result of relevant indexes of the existing process workshop.
The technical solution for realizing the purpose of the invention is as follows:
a resource environment load data general integrated acquisition system comprises a data acquisition module, a communication module and a data processing module;
the data acquisition module comprises a dust sensor, a noise sensor, a power sensor, an electronic weighing meter, an RFID reader-writer, a VOCs sensor and an SO2Sensor with a sensor elementNOx sensor, CO sensor, O3Any one or more of any combination of sensors; the dust sensor is used for collecting the dust content; the noise sensor is used for collecting noise; the power sensor is used for measuring the power of the machine tool in the machining process in real time; the electronic weighing meter is used for weighing the input and output weight of the material; the RFID reader is used for identifying material information; the VOCs sensor and SO2Sensor, NOx sensor, CO sensor, O3The sensors are used for measuring corresponding gas concentrations;
the communication module is used for sending the data acquired by the data acquisition module to the data processing module;
the data processing module comprises a data missing value compensation unit, a data abnormal value removing unit, a data weighting calculation unit and a storage unit; the data missing value compensation unit is used for compensating the missing data of the abnormal acquisition points measured by the gas sensor through a regression interpolation method; the abnormal value eliminating unit is used for eliminating the abnormal value measured by the gas sensor; the data weighting calculation unit is used for carrying out weighting calculation on the measurement data processed by the data missing value compensation unit and the abnormal value elimination unit; and the storage unit is used for carrying out real-time display, curve drawing and data storage on the processed data.
A resource environment load data general integrated acquisition method comprises the following steps:
step 1, setting gas index concentration sampling points, and arranging sensors at points to be measured;
step 2, determining the index quantity needing to be collected in real time;
step 3, data acquisition: after the data indexes are stable, data acquisition is carried out;
and 4, data processing: and performing missing value compensation and data abnormal value elimination on the data, and performing weighted calculation on the measured data after the data missing value compensation and the abnormal value elimination.
Compared with the prior art, the invention has the following remarkable advantages:
(1) the acquisition system can acquire dust, VOCs and SO2、NOx、CO、O3Resource environmental load data in various processing technologies such as power, material information, noise and the like; compared with the method that various independent sensors are used for acquisition respectively, the device is high in portability, the installation and acquisition processes of the sensors are greatly simplified, and the data acquisition efficiency is improved; the integration is strong, the data of all indexes at the same time can be collected, and a plurality of sensors of the same kind are used for collecting data of multiple points; therefore, a proper resource environmental load data acquisition system is provided for the industrial scene to evaluate the process environment influence and acquire relevant data.
(2) The system is provided with a data processing module, and performs missing value compensation, abnormal value elimination and related weighted average calculation processing on related data, so that the acquired data is more complete and accurate, and the distribution condition of the measured value data in different time periods or different areas can be better reflected.
(3) The acquisition method of the acquisition system capable of synchronously and integrally acquiring the environmental load data of various resources sets the acquisition position and the sampling time of an instrument, sets the acquisition points of the gas index concentration aiming at different processing scenes of closed and open machine tools, and provides a data acquisition scheme and a calculation method for the acquisition of equipment-level data of a single machine tool and the whole workshop-level data, improves the quality of the acquired data, and has great advantages in the application of data acquisition of industrial production workshops.
Drawings
Fig. 1 is a schematic structural diagram of a resource environmental load data acquisition system.
Fig. 2 is a schematic view of a main view of an in-box device of the resource environmental load data acquisition system.
Detailed Description
The invention is further described with reference to the following figures and embodiments.
With reference to fig. 1 and fig. 2, the resource environmental load data general integrated acquisition system of the present invention includes a data acquisition module, a communication module, and a data processing module;
the data acquisition module comprises a dust sensor 5, a noise sensor 11 and a power transmitterSensor, electronic weighing meter, RFID reader-writer, VOCs (volatile organic compounds) sensor 3 and SO2Sensor 2, NOx sensor 8, CO sensor 9, O3Any one or more of the sensors 10 in any combination; the dust sensor 5 is used for collecting PM100 dust content; the noise sensor 11 is used for collecting noise; the power sensor is used for measuring the power of the machine tool in the machining process in real time to calculate the energy consumption; the electronic weighing meter is used for weighing input and output weights of materials such as workpieces, cutting fluid and the like; the RFID reader-writer is used for identifying material information such as machine tool model, workpiece material, cutting fluid oil, cutter material, geometric angle and the like; VOCs sensor 3, SO2Sensor 2, NOx sensor 8, CO sensor 9, O3The sensor 10 is used to measure the corresponding gas concentration. Various gas sensors can adopt diffusion type sampling and also can adopt pump suction type sampling; a sensor adopting diffusion type sampling is integrated on a sensor mounting plate 4 in a main control machine box 1 and is contacted with ambient gas for sampling through a through hole on the surface of the machine box; the sensor adopting the pump suction type sampling and the sensors of other indexes are connected with the main controller box 1 through cables.
The communication module is used for sending the data acquired by the data acquisition module to the data processing module; the method comprises the steps of sending data acquired by a data acquisition module to a data processing module in a wired or wireless mode; for example, the wired mode can adopt wired communication modules such as a data acquisition card 6, an RS232 and an RS485 to carry out data communication of the sensor near the main control machine box; the wireless mode comprises wireless communication modules such as WiFi, ZIGBEE, GPRS and the like, and the sensors are arranged at the far end for data communication, so that multipoint data can be monitored simultaneously. This allows for a free arrangement of the sensors in the acquisition module.
The data processing module comprises a data missing value compensation unit, a data abnormal value removing unit, a data weighting calculation unit and a storage unit;
the data missing value compensation unit is used for compensating missing data (missing value) of an abnormal acquisition point measured by the gas sensor through a regression interpolation method, and the specific process is as follows:
taking the lost data of the abnormal acquisition points as dependent variables and other normally measured data as independent variables, establishing a regression model by utilizing the fitting relation between the lost data and the other normally measured data under the normal acquisition condition to predict missing values, and performing missing value interpolation by utilizing a multiple linear regression model:
taking the lost data y of the sensor as a dependent variable, namely a missing value; data x measured normally by n sensors1,x2,...,xnFor the independent variables, i.e. other measured values related to the missing values, a multiple linear regression model was established:
y=β0+β1x1+β2x2+...+βnxn+ε (1)
wherein, beta0,β1,β2,...,βnIs a coefficient of the relevant parameter; epsilon is a constant, obeys the classical assumptions of zero mean, mutual independence and homovariance obeying normal distribution, etc.;
calculating a parameter beta0,β1,β2,...,βnEstimated value of (a):
the parameter beta can be obtained by using the data normally measured by n sensors in actual measurement and adopting a least square method0,β1,β2,...,βnIs estimated value ofAfter the parameter estimation value is solved, a multiple regression equation can be obtained:
and substituting the value of the independent variable to obtain the missing value.
The abnormal value eliminating unit is used for eliminating the abnormal value measured by the gas sensor, and the specific process is as follows: according to the Lauda criterion (3 sigma), the measured quantity of a single sensor is measured with equal precision, and the data x under the same condition are independently obtained1,x2,...,xnCalculating x1,x2,...,xnIs arithmetic mean ofAnd residual errorAnd calculating the standard deviation sigma according to Bessel formula, if a certain measured value xbResidual error v ofb(1. ltoreq. b. ltoreq. n) satisfying the following formula (3):
then consider xbThe bad values containing the gross error values are eliminated.
After the data are processed by the data missing value compensation unit and the abnormal value elimination unit, the acquired data have no free position and invalid data, and have no overlarge data and overlarge data.
The data which are not influenced by the environment are stored by a data storage unit, such as data measured by a power sensor, an electronic weighing meter and an RFID reader-writer. The data affected by the environment needs to be weighted and calculated by a data weighting and calculating unit.
The data weighting calculation unit is used for carrying out weighting calculation on the measurement data processed by the data missing value compensation unit and the abnormal value elimination unit; the method comprises an area weight calculation unit and a time weight calculation unit:
the time weighting calculation unit is used for selecting at least 3 different time intervals for collecting the collected values of the index concentration of the data gas of the equipment level of a single machine tool according to the morning, noon, afternoon or several typical production working days in the work system of 8h a day, respectively, so as to obtain the highest value of the index data, and calculating to obtain the weighted average concentration values of the time intervals, wherein the specific calculation process is as follows:
C=(C1T1+C2T2+……+CnTn)/(T1+T2+……+Tn) (4)
in the formula: c is the time-weighted average concentration of harmful substances in the air, mg/m3;
C1、C2、……、CnConcentration of harmful substances in air, mg/m, measured at different time intervals3;
T1、T2、……、TnThe working time of workers under different periods of harmful substance concentration is h.
The area weighting calculation unit is used for dividing the collected value of the whole workshop level data into at least 3 different processing areas according to the cutting processes of turning, milling, grinding and the like or the equipment types of closed type and open type machine tools and the like for collection respectively to obtain the highest value of the index data, and calculating to obtain the weighted average concentration values of the areas, wherein the specific calculation process is as follows:
Cworkshop=(C1S1+C2S2+……+CnSn)/(S1+S2+……+Sn) (5)
In the formula: cWorkshopThe concentration of the whole harmful substances in the workshop is mg/m3;
C1、C2、……、CnConcentration of harmful substance measured for different representative regions, mg/m3;
S1、S2、……、SnIs the area of the different regions, m2。
The original measurement data is processed by a weighted average processing and calculating method to obtain a characteristic value, so that the distribution condition of the measurement data in different time periods or different areas can be better reflected; and then the storage unit carries out real-time display, curve drawing and data storage on the acquired and processed data.
Based on the acquisition system, the invention also provides an acquisition method capable of synchronously and integrally acquiring the environmental load data of various resources, which comprises the following steps:
step 1, judging the type of a machine tool to be measured, setting gas index concentration sampling points according to different closed and open machine tools and processing scenes, arranging all sensors at the points to be measured, connecting a power supply, connecting a data transmission module with an upper computer, and opening upper computer software. The gas index concentration sampling points are arranged to face the production source of the equipment to be tested, such as the machining position of a cutter. If the tool moving range is small, data of a single acquisition point near the tool is adopted, for example, a closed machine tool sampling point is arranged at a machine tool door, and an open machine tool sampling point is arranged at a machined side of a workpiece; however, if the moving range of the tool is large, such as the gas diffusion caused by the gaps around the closed machine tool or the rotary machining of the tool in a larger plane by the open machine tool, a plurality of same sensors are arranged in the front, back, left, right and other directions of the machine tool for acquisition.
And 2, determining the index quantity needing to be collected in real time, collecting corresponding gas by using dust, VOCs, SO2, NOx, CO and O3 sensors, collecting noise by using a noise sensor, and collecting voltage and current information by using a power sensor. Meanwhile, for other process scene information, the weights of the workpiece, the cutting fluid, the waste water and the solid waste can be weighed by an electronic weighing meter, and the related information of the machine tool, the workpiece, the cutting fluid and the cutter can be acquired by an RFID reader-writer.
Step 3, data acquisition: operating the machine tool to carry out actual machining, and stopping the machine tool equipment which possibly generates interference around the machine tool; in the initial stage of equipment operation, the concentration of the relevant index can be continuously increased along with the processing, but tends to be stable after a period of time, so that the measurement of the effective data of the index is carried out after the machine tool operates for 15-30 min.
Step 4, displaying the acquired data, dust, VOCs and SO through a display screen of the storage unit2、NOX、CO、O3And drawing a data curve by taking time as a horizontal axis and taking an index value as a vertical axis, and after the acquisition is finished, processing and storing the data. And (3) acquiring data of a single machine tool equipment level or data of the whole workshop level according to the needs, repeating the steps 1-4, acquiring for at least 3 times, and averaging by using different weighted calculation units.
The processing process in the method is based on the processing process of the data processing module, and comprises missing value compensation, data abnormal value elimination and data weighting calculation, and the specific content is the same as the processing process of the data processing module, and is not described herein again.
Further, dust, VOCs, SO2、NOX、CO、O3The noise sensor is integrated near the main control box due to the similar collection method and index generation source, and the position of the sampling point is 0.5-1m away from the machining position of the cutter; the power sensor is arranged at the power supply input end of the machine tool motor; the electronic weighing meter has any working position and is connected with the upper computer software through a transmission line. The gas sensors such as dust, VOCs, SO2, NOx, CO, O3 and the like can read once every 1-10s during collection; the sampling frequency of the noise sensor can reach 5-20kHz, and the sampling frequency of the power sensor can reach 25-70 Hz; the data of each time period should be collected for 10-30min, and the collection time selected in the time period should be at least 1h to avoid the interference among the data of different time periods.
Claims (10)
1. A resource environmental load data general integrated acquisition system is characterized by comprising a data acquisition module, a communication module and a data processing module;
the data acquisition module comprises a dust sensor, a noise sensor, a power sensor, an electronic weighing meter, an RFID reader-writer, a VOCs sensor and an SO2Sensor, NOx sensor, CO sensor, O3Any one or more of any combination of sensors; the dust sensor is used for collecting the dust content; the noise sensor is used for collecting noise; the power sensor is used for measuring the power of the machine tool in the machining process in real time; the electronic weighing meter is used for weighing the input and output weight of the material; the RFID reader is used for identifying material information; the VOCs sensor and SO2Sensor, NOx sensor, CO sensor, O3The sensors are used for measuring corresponding gas concentrations;
the communication module is used for sending the data acquired by the data acquisition module to the data processing module;
the data processing module comprises a data missing value compensation unit, a data abnormal value removing unit, a data weighting calculation unit and a storage unit; the data missing value compensation unit is used for compensating the missing data of the abnormal acquisition points measured by the gas sensor through a regression interpolation method; the abnormal value eliminating unit is used for eliminating the abnormal value measured by the gas sensor; the data weighting calculation unit is used for carrying out weighting calculation on the measurement data processed by the data missing value compensation unit and the abnormal value elimination unit; and the storage unit is used for carrying out real-time display, curve drawing and data storage on the processed data.
2. The acquisition system according to claim 1, wherein the data missing value compensation unit specifically operates as follows:
data x normally measured by n sensors by taking lost data y of the sensors as a dependent variable1,x2,...,xnEstablishing a multiple linear regression model for the independent variable:
y=β0+β1x1+β2x2+...+βnxn+ε (1)
wherein, beta0,β1,β2,...,βnIs a coefficient of the relevant parameter; epsilon is a constant, obeys the classical assumptions of zero mean, mutual independence and homovariance obeying normal distribution, etc.;
calculating a parameter beta0,β1,β2,...,βnEstimated value of (a):
the parameter beta can be obtained by using the data normally measured by n sensors in actual measurement and adopting a least square method0,β1,β2,...,βnIs estimated value ofAfter the parameter estimation value is solved, a multiple regression equation can be obtained:
and substituting the value of the independent variable to obtain the missing value.
3. The acquisition system according to claim 1, wherein the abnormal value eliminating unit specifically works as follows:
according to the Lauda criterion, the measured quantity of a single sensor is measured with equal precision, and the data x under the same condition is independently obtained1,x2,...,xnCalculating x1,x2,...,xnIs arithmetic mean ofAnd residual errorAnd calculating the standard deviation sigma according to Bessel formula, if a certain measured value xbResidual error v ofb(1. ltoreq. b. ltoreq. n) satisfying the following formula:
then consider xbThe bad values containing the gross error values are eliminated.
4. The acquisition system according to claim 1, wherein the data weight calculation unit includes an area weight calculation unit and a time weight calculation unit;
the time weighting calculation unit is used for selecting the highest values obtained in different time periods for the acquired values of the index concentration of the data gas at the equipment level of the single machine tool, and calculating to obtain weighted average concentration values C in the time periods;
C=(C1T1+C2T2+……+CnTn)/(T1+T2+……+Tn) (4)
wherein C is1、C2、……、CnThe concentration of harmful substances in the air is measured in different time periods; t is1、T2、……、TnThe working time of workers under different periods of harmful substance concentration is shortened;
the area weighting calculation unit is used for selecting the highest values of different processing areas for the acquired values of the whole workshop-level data and calculatingObtaining weighted average concentration values C of the regionsWorkshop;
CWorkshop=(C1S1+C2S2+……+CnSn)/(S1+S2+……+Sn) (5)
Wherein C is1、C2、……、CnThe concentrations of the harmful substances measured for different representative regions; s1、S2、……、SnAre the areas of the different regions.
5. The acquisition system according to claim 1, wherein the sensor adopting diffusion type sampling is integrated on a sensor mounting plate in the main control case and is in contact with the ambient gas for sampling through a through hole on the surface of the case; the sensor adopting the pump suction type sampling and the sensors of other indexes are connected with the main control machine box through cables.
6. Acquisition method of an acquisition system according to any of claims 1 to 5, characterized in that it comprises the following steps:
step 1, setting gas index concentration sampling points, and arranging sensors at points to be measured;
step 2, determining the index quantity needing to be collected in real time;
step 3, data acquisition: after the data indexes are stable, data acquisition is carried out;
and 4, data processing: and performing missing value compensation and data abnormal value elimination on the data, and performing weighted calculation on the measured data after the data missing value compensation and the abnormal value elimination.
7. The acquisition method according to claim 6, wherein the missing value compensation in step 4 specifically comprises: data x normally measured by n sensors by taking lost data y of the sensors as a dependent variable1,x2,...,xnEstablishing a multiple linear regression model for the independent variable:
y=β0+β1x1+β2x2+...+βnxn+ε (1)
wherein, beta0,β1,β2,...,βnIs a coefficient of the relevant parameter; epsilon is a constant, obeys the classical assumptions of zero mean, mutual independence and homovariance obeying normal distribution, etc.;
calculating a parameter beta0,β1,β2,...,βnEstimated value of (a):
the parameter beta can be obtained by using the data normally measured by n sensors in actual measurement and adopting a least square method0,β1,β2,...,βnIs estimated value ofAfter the parameter estimation value is solved, a multiple regression equation can be obtained:
and substituting the value of the independent variable to obtain the missing value.
8. The acquisition method according to claim 6, wherein the data outlier rejection in step 4 is specifically: according to the Lauda criterion, the measured quantity of a single sensor is measured with equal precision, and the data x under the same condition is independently obtained1,x2,...,xnCalculating x1,x2,...,xnIs arithmetic mean ofAnd residual errorAnd calculating the standard deviation sigma according to Bessel formula, if a certain measured value xbResidual error v ofb(1. ltoreq. b. ltoreq. n) satisfying the following formula:
then consider xbThe bad values containing the gross error values are eliminated.
9. The acquisition method according to claim 6, wherein the weighted calculation of the data in step 4 comprises area weighted calculation and time weighted calculation:
the time weighted calculation is used for selecting the highest values obtained in different time periods for the acquired values of the data gas index concentration of the equipment level of a single machine tool, and calculating to obtain weighted average concentration values C in the time periods;
C=(C1T1+C2T2+……+CnTn)/(T1+T2+……+Tn) (4)
wherein C is1、C2、……、CnThe concentration of harmful substances in the air is measured in different time periods; t is1、T2、……、TnThe working time of workers under different periods of harmful substance concentration is shortened;
the area weighting calculation is used for selecting the highest values of different processing areas from the acquired values of the whole workshop-level data and calculating to obtain the weighted average concentration value C of the areasWorkshop;
CWorkshop=(C1S1+C2S2+……+CnSn)/(S1+S2+……+Sn) (5)
Wherein C is1、C2、……、CnThe concentrations of the harmful substances measured for different representative regions; s1、S2、……、SnAre the areas of the different regions.
10. The acquisition method according to claim 6, wherein sampling points are set according to different types of the machine tool to be detected and different processing scenes before acquisition, the closed machine tool sampling points are arranged at a machine tool door, and the open machine tool sampling points are arranged at a processed side of the workpiece; if open type machine toolWhen the rotary processing of the cutter is carried out in a processing plane, at least 1 sensor is arranged in each of the front, the back, the left and the right directions of the machine tool for acquisition; the measurement of effective data during collection is carried out after the equipment works for 15-30 min; the dust, VOCs and SO2、NOX、CO、O3The position of a sampling point of the noise sensor is 0.5-1m away from the machining position of the cutter; the power sensor is arranged at the power supply input end of the machine tool motor; the gas sensors such as dust, VOCs, SO2, NOx, CO, O3 and the like can read once every 1-10s during collection; the sampling frequency of the noise sensor can reach 5-20kHz, and the sampling frequency of the power sensor can reach 25-70 Hz; the data of each time interval should be collected for 10-30min, and the selected collection time interval should be at least 1 h.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910749647.7A CN110610295B (en) | 2019-08-14 | 2019-08-14 | Universal integrated acquisition system and method for resource environment load data |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910749647.7A CN110610295B (en) | 2019-08-14 | 2019-08-14 | Universal integrated acquisition system and method for resource environment load data |
Publications (2)
Publication Number | Publication Date |
---|---|
CN110610295A true CN110610295A (en) | 2019-12-24 |
CN110610295B CN110610295B (en) | 2022-08-16 |
Family
ID=68890941
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910749647.7A Active CN110610295B (en) | 2019-08-14 | 2019-08-14 | Universal integrated acquisition system and method for resource environment load data |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110610295B (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2021179742A1 (en) * | 2020-03-10 | 2021-09-16 | 中国科学院深圳先进技术研究院 | Ozone missing data interpolation method, apparatus and device |
WO2022083177A1 (en) * | 2020-10-19 | 2022-04-28 | 长鑫存储技术有限公司 | Environmental data monitoring method and monitoring system |
CN115524449A (en) * | 2022-09-15 | 2022-12-27 | 山东大学 | Dynamic collection method and system for inventory data of electromechanical product service process |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104516991A (en) * | 2013-09-27 | 2015-04-15 | 中国石油化工集团公司 | Gamma sensor full-temperature range compensation method |
CN106870080A (en) * | 2017-01-23 | 2017-06-20 | 哈尔滨工程大学 | A kind of method of real-time suitable for marine diesel SCR system NH3, NOx concentration and residing temperature |
US20190205843A1 (en) * | 2017-12-31 | 2019-07-04 | Bull Sas | System and process for maintenance management during a mass gathering |
-
2019
- 2019-08-14 CN CN201910749647.7A patent/CN110610295B/en active Active
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104516991A (en) * | 2013-09-27 | 2015-04-15 | 中国石油化工集团公司 | Gamma sensor full-temperature range compensation method |
CN106870080A (en) * | 2017-01-23 | 2017-06-20 | 哈尔滨工程大学 | A kind of method of real-time suitable for marine diesel SCR system NH3, NOx concentration and residing temperature |
US20190205843A1 (en) * | 2017-12-31 | 2019-07-04 | Bull Sas | System and process for maintenance management during a mass gathering |
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2021179742A1 (en) * | 2020-03-10 | 2021-09-16 | 中国科学院深圳先进技术研究院 | Ozone missing data interpolation method, apparatus and device |
WO2022083177A1 (en) * | 2020-10-19 | 2022-04-28 | 长鑫存储技术有限公司 | Environmental data monitoring method and monitoring system |
US11928948B2 (en) | 2020-10-19 | 2024-03-12 | Changxin Memory Technologies, Inc. | Environmental data monitoring method and monitoring system |
CN115524449A (en) * | 2022-09-15 | 2022-12-27 | 山东大学 | Dynamic collection method and system for inventory data of electromechanical product service process |
CN115524449B (en) * | 2022-09-15 | 2024-06-11 | 山东大学 | Dynamic collection method and system for electromechanical product service process list data |
Also Published As
Publication number | Publication date |
---|---|
CN110610295B (en) | 2022-08-16 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110610295B (en) | Universal integrated acquisition system and method for resource environment load data | |
CN101033989B (en) | Environmental monitoring device and method | |
CN201607390U (en) | Ambient air quality monitoring device | |
CN106442888B (en) | Automobile environment-protection exhaust pollution analyte detection chassis dynamometer integrated correction system | |
CN107677614B (en) | Online early warning system and method for risk of heavy metal pollution in water | |
CN108614071B (en) | Distributed outdoor air quality monitoring precision correction system and parameter updating method | |
CN105486812A (en) | Electronic nose stink grade assignment method in continuous environment air quality monitoring process and application | |
CN116468204B (en) | Industrial product carbon footprint online monitoring method, system, equipment and storage medium | |
CN116758719A (en) | Online monitoring system for production workshop equipment environment | |
Gontarz et al. | Energy Consumption Measurement with a Multichannel Measurement System on a machine tool | |
CN104062409B (en) | Intelligence soot gas analyzes method and apparatus | |
CN102778445A (en) | Intelligent analyzer and detection method for standard state dry basis | |
Tuo et al. | Dynamic acquisition and real-time distribution of carbon emission for machining through mining energy data | |
CN108775921A (en) | Industrial smoke on-line continuous monitoring device | |
CN203909009U (en) | Continuous online monitoring system for flue gas | |
CN205002802U (en) | System for on -line monitoring atmospheric pollutants | |
CN115792165B (en) | Intelligent environmental water quality monitoring method and system | |
CN116659568A (en) | On-spot environmental monitoring system of boats and ships application workshop | |
CN113804595B (en) | Multi-parameter air quality monitoring system | |
CN207410366U (en) | The accurate monitoring system of air gridding | |
CN2510858Y (en) | Infrared-ray gas analyser | |
CN202101700U (en) | Online solid physical-optical characteristic analyzer | |
CN216956755U (en) | Tunnel environment monitoring equipment precision detection device | |
CN117054616B (en) | Remote middle station atmosphere pollution tracing system based on artificial intelligence | |
CN211179409U (en) | Cotton surface density automatic measuring device of glass |
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 | ||
GR01 | Patent grant | ||
GR01 | Patent grant |