CN111273628A - Data acquisition system and device for intelligent manufacturing of weighing sensor - Google Patents
Data acquisition system and device for intelligent manufacturing of weighing sensorDownload PDFInfo
- Publication number
- CN111273628A CN111273628ACN202010189909.1ACN202010189909ACN111273628ACN 111273628 ACN111273628 ACN 111273628ACN 202010189909 ACN202010189909 ACN 202010189909ACN 111273628 ACN111273628 ACN 111273628A
- Authority
- CN
- China
- Prior art keywords
- data
- data acquisition
- detection
- excel
- file
- 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
- 238000004519manufacturing processMethods0.000titleclaimsabstractdescription73
- 238000005303weighingMethods0.000titleclaimsabstractdescription25
- 238000001514detection methodMethods0.000claimsabstractdescription126
- 238000007619statistical methodMethods0.000claimsabstractdescription76
- 238000004891communicationMethods0.000claimsabstractdescription22
- 230000010354integrationEffects0.000claimsabstractdescription8
- 230000000007visual effectEffects0.000claimsdescription25
- 238000011179visual inspectionMethods0.000claimsdescription17
- 238000013480data collectionMethods0.000claimsdescription12
- 239000011159matrix materialSubstances0.000claimsdescription7
- 238000013500data storageMethods0.000claimsdescription6
- 238000011161developmentMethods0.000claimsdescription6
- 238000012545processingMethods0.000claimsdescription6
- 238000000034methodMethods0.000claimsdescription4
- 238000006243chemical reactionMethods0.000claimsdescription3
- 238000013524data verificationMethods0.000claimsdescription3
- 230000008569processEffects0.000claimsdescription3
- 238000011958production data acquisitionMethods0.000abstractdescription4
- 230000008859changeEffects0.000description15
- 230000002950deficientEffects0.000description8
- 230000003203everyday effectEffects0.000description4
- 238000012360testing methodMethods0.000description3
- 230000002354daily effectEffects0.000description2
- 230000006872improvementEffects0.000description2
- 238000012986modificationMethods0.000description2
- 230000004048modificationEffects0.000description2
- 230000009286beneficial effectEffects0.000description1
- 238000010586diagramMethods0.000description1
- 230000000694effectsEffects0.000description1
- 238000007689inspectionMethods0.000description1
- 238000012216screeningMethods0.000description1
- 238000011895specific detectionMethods0.000description1
Images
Classifications
- G—PHYSICS
- G05—CONTROLLING; REGULATING
- G05B—CONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
- G05B19/00—Programme-control systems
- G05B19/02—Programme-control systems electric
- G05B19/418—Total factory control, i.e. centrally controlling a plurality of machines, e.g. direct or distributed numerical control [DNC], flexible manufacturing systems [FMS], integrated manufacturing systems [IMS] or computer integrated manufacturing [CIM]
- G05B19/4183—Total factory control, i.e. centrally controlling a plurality of machines, e.g. direct or distributed numerical control [DNC], flexible manufacturing systems [FMS], integrated manufacturing systems [IMS] or computer integrated manufacturing [CIM] characterised by data acquisition, e.g. workpiece identification
- G—PHYSICS
- G05—CONTROLLING; REGULATING
- G05B—CONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
- G05B2219/00—Program-control systems
- G05B2219/30—Nc systems
- G05B2219/31—From computer integrated manufacturing till monitoring
- G05B2219/31282—Data acquisition, BDE MDE
- 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/02—Total factory control, e.g. smart factories, flexible manufacturing systems [FMS] or integrated manufacturing systems [IMS]
Landscapes
- Engineering & Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Manufacturing & Machinery (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Automation & Control Theory (AREA)
- General Factory Administration (AREA)
Abstract
Description
Technical Field
The invention relates to the technical field of industrial application, in particular to a data acquisition system and a data acquisition device for intelligent manufacturing of a weighing sensor.
Background
At present, when a product is produced, data of each production and detection station is difficult to collect, and related data in each production process cannot be analyzed and counted, so that the related statistical analysis result in the production process is difficult to understand visually, the integration of industrialization and informatization cannot be realized, and improvement is needed.
Disclosure of Invention
Objects of the invention
In order to solve the technical problems in the background art, the invention provides a data acquisition system and a device thereof for intelligent manufacturing of a weighing sensor, which are used for acquiring the data of each production station and each detection station into a database server through a production data acquisition and statistical analysis system, so that the production data and the detection data can be inquired, tracked, counted and analyzed, various statistical data can be inquired and displayed conveniently, various statistical analysis results can be known visually, the integration of industrialization and informatization is realized, and the intelligent degree is high.
(II) technical scheme
The invention provides a data acquisition system for intelligent manufacturing of a weighing sensor, which comprises a data acquisition subsystem, a database server and a statistical analysis subsystem, wherein the data acquisition subsystem is used for acquiring a weighing sensor;
the input end of the database server is in communication connection with the data acquisition subsystem, and the output end of the database server is in communication connection with the statistical analysis subsystem;
the data acquisition subsystem is in communication connection with the platform scale sensor, the price computing scale sensor, the automatic grouping module, the visual detection module and the chip mounter and is used for acquiring data from each production and detection station and uploading the acquired data to the database server, wherein the acquired data comprises platform scale sensor data, price computing scale sensor data, automatic grouping sensor detection data, visual detection data and chip mounter production data;
the data acquisition subsystem comprises a data acquisition client and a data acquisition server, wherein the data acquisition client is in communication connection with the data acquisition server; the data acquisition client runs on each computer connected with the production or detection station equipment, and the data acquisition server runs on the application server;
the statistical analysis subsystem is in communication connection with the query module and is used for acquiring related data from the database according to input conditions, analyzing and counting the related data and forming related reports and charts;
the statistical analysis subsystem comprises a statistical analysis front-end program and a statistical analysis back-end program, and the statistical analysis front-end program is in communication connection with the statistical analysis back-end program; the statistical analysis front-end program runs on a browser, and the statistical analysis back-end program runs on a server.
Preferably, the database server comprises a data collection module, a data output module and a data storage module;
the data collection module is used for collecting data; the data output module is used for outputting related data; and the data storage module is used for storing the related data.
Preferably, the operation steps of the data acquisition client and the data acquisition server are as follows:
s1, obtaining relevant information such as detection/production equipment type, equipment number/detection line number, file reading path, Excel file naming rule and the like by reading relevant configuration files;
s2, timing execution and checking of Excel data files of each production and detection station, and sending the not-uploaded Excel data files or the uploaded Excel files added with new production detection record data to an application server;
and S3, the data acquisition server receives the Excel file, analyzes and processes the received Excel file, including data verification, data comparison and code analysis, and then adds the latest production and detection data into a corresponding table of the database.
Preferably, the statistical analysis front-end program and the statistical analysis back-end program operate as follows:
s1, inputting query and statistical conditions by an operator through a query module, and acquiring the input query and statistical conditions by a statistical analysis front-end program;
s2, the statistical analysis back-end program acquires data from the relevant table of the database server according to the query and statistical conditions acquired by the statistical analysis front-end program;
s3, the statistical analysis back-end program performs statistics, analysis and processing on the acquired data, and feeds back the results of statistics, analysis and processing to the statistical analysis front-end program;
and S4, displaying the query, statistics and analysis results in a webpage form by the statistical analysis front-end program according to the fed back statistical analysis result data, wherein the display mode comprises a report and a chart.
Preferably, the software architecture of the data acquisition system is B/S architecture, the development language is Java and Kotlin, the adopted frameworks are spring-mvc, spring-boot and spring-data-jpa, the database is MySQL, and the development integration environment is Intellij IDEA.
Preferably, when detecting data acquisition is performed on a platform scale sensor/price computing scale sensor/automatic grouping module, storing daily detection data in an Excel file, namely the daily detection data corresponds to one Excel file;
when the detection data statistical results of the platform scale sensor/the pricing scale sensor/the automatic grouping module are collected, the detection data statistical results of each month are stored in an Excel file, namely the detection data statistical results of each month correspond to one Excel file, and the detection data statistical results of each day of the month correspond to one row of an Excel table.
Preferably, the detection data acquisition and the statistical result acquisition of the platform scale sensor/the valuation scale sensor/the automatic grouping module are completed by the data acquisition client and the data acquisition server together;
in the detection data acquisition, a data acquisition client traverses all detection data Excel files according to a path specified by a configuration file, finds out the detection data Excel files which are not uploaded yet or the Excel files added with new detection records after uploading, and then sends the Excel files to an application server; the data acquisition server side analyzes the Excel file of the detection data sent by the data acquisition client side, compares the Excel file with the cache content of the uploaded file, adds the data record which is not uploaded to a corresponding table of the database, and automatically adds field information such as date, equipment/detection line and the like;
in the statistical result acquisition, the data acquisition client searches an Excel file storing the statistical result of the detection data in the current month according to a path specified by the configuration file, and sends the Excel file to the application server; and the data acquisition server analyzes the Excel file of the detection data statistical result sent by the data acquisition client, and adds the statistical result record which is not uploaded and the updated data record in the file to a corresponding table of the database by comparing the Excel file with the uploaded record cache content.
Preferably, the visual inspection module further comprises a visual inspection data uploading module, and the operation steps of the visual inspection data acquisition are as follows:
s1, visual detection is mainly performed on the strain gauge plates, the visual detection result of each strain gauge plate is stored in an Excel file, the file name of the file is the bar code of the sensor film, the content of the file is a square matrix formed by 0 and 1, each unit corresponds to one strain gauge, 1 represents a good product, 0 represents a bad product, and the product of the line number m and the column number n of the square matrix represents the number of the strain gauges in one strain gauge plate;
s2, the visual detection data uploading module checks the visual detection Excel files which are not uploaded yet, then the data of the Excel tables are read out and corresponding connection and disconnection conversion is carried out, namely, one Excel file is converted into one record, and the record is added into the corresponding table of the database;
s3, traversing all visual inspection data Excel files by the data acquisition client according to the path designated by the configuration file, finding out the visual inspection data Excel files which are not uploaded, and then sending the Excel files to the application server;
s4, the data acquisition server analyzes the visual detection data Excel file sent by the data acquisition client, analyzes the bar code, date, model, furnace number, resistance adjuster, projector and inspector of the strain gauge plate according to the file name, analyzes the line number, column number, bit string, total number of sensors, good product number, bad product number and the like of the strain gauge plate according to the file content, and then adds the visual detection record to a corresponding table of a database.
Preferably, the statistical result of the production data of the chip mounter is stored in an Excel file, one record is recorded every day, the record comprises date, yield, failure rate, equipment utilization rate and the like, the statistical result every day corresponds to one line of the Excel table, and the statistical result collection of the production data of the chip mounter is completed by a data collection client and a data collection server together;
the data acquisition client searches an Excel file of the production statistical result of the chip mounter according to a path specified by the configuration file, and sends the Excel file to the application server; and the data acquisition server analyzes the Excel file of the chip mounter production statistical result sent by the data acquisition client, compares the Excel file with the uploaded record cache content, and appends the statistical result record which is not uploaded and the updated data record in the file to a corresponding table of the database.
The invention also provides a data acquisition device for the intelligent manufacturing of the weighing sensor, which comprises the data acquisition system for the manufacturing of the weighing sensor.
The technical scheme of the invention has the following beneficial technical effects:
according to the invention, the production data acquisition and statistical analysis system is used for acquiring the data of each production and detection station into the database server, so that the production and detection data can be inquired, tracked, counted and analyzed, various statistical data can be inquired and displayed conveniently, various statistical analysis results can be known visually, the industrialization and informatization integration is realized, and the intelligent degree is high.
Drawings
Fig. 1 is a system block diagram of a data acquisition system and a device thereof for intelligent manufacturing of a weighing sensor according to the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention will be described in further detail with reference to the accompanying drawings in conjunction with the following detailed description. It should be understood that the description is intended to be exemplary only, and is not intended to limit the scope of the present invention. Moreover, in the following description, descriptions of well-known structures and techniques are omitted so as to not unnecessarily obscure the concepts of the present invention.
As shown in fig. 1, the data acquisition system for intelligent manufacturing of a weighing sensor provided by the invention comprises a data acquisition subsystem, a database server and a statistical analysis subsystem;
the input end of the database server is in communication connection with the data acquisition subsystem, and the output end of the database server is in communication connection with the statistical analysis subsystem;
the data acquisition subsystem is in communication connection with the platform scale sensor, the price computing scale sensor, the automatic grouping module, the visual detection module and the chip mounter and is used for acquiring data from each production and detection station and uploading the acquired data to the database server, wherein the acquired data comprises platform scale sensor data, price computing scale sensor data, automatic grouping sensor detection data, visual detection data and chip mounter production data;
the data acquisition subsystem comprises a data acquisition client and a data acquisition server, wherein the data acquisition client is in communication connection with the data acquisition server; the data acquisition client runs on each computer connected with the production or detection station equipment, and the data acquisition server runs on the application server;
the statistical analysis subsystem is in communication connection with the query module and is used for acquiring related data from the database according to input conditions, analyzing and counting the related data and forming related reports and charts;
the statistical analysis subsystem comprises a statistical analysis front-end program and a statistical analysis back-end program, and the statistical analysis front-end program is in communication connection with the statistical analysis back-end program; the statistical analysis front-end program runs on a browser, and the statistical analysis back-end program runs on a server.
In an optional embodiment, the database server comprises a data collection module, a data output module and a data storage module; the data collection module is used for collecting data; the data output module is used for outputting related data; and the data storage module is used for storing the related data.
In an alternative embodiment, the data collection client and the data collection server operate as follows:
s1, obtaining relevant information such as detection/production equipment type, equipment number/detection line number, file reading path, Excel file naming rule and the like by reading relevant configuration files;
s2, timing execution and checking of Excel data files of each production and detection station, and sending the not-uploaded Excel data files or the uploaded Excel files added with new production detection record data to an application server;
and S3, the data acquisition server receives the Excel file, analyzes and processes the received Excel file, including data verification, data comparison and code analysis, and then adds the latest production and detection data into a corresponding table of the database.
In an alternative embodiment, the statistical analysis front-end program and the statistical analysis back-end program operate as follows:
s1, inputting query and statistical conditions by an operator through a query module, and acquiring the input query and statistical conditions by a statistical analysis front-end program;
s2, the statistical analysis back-end program acquires data from the relevant table of the database server according to the query and statistical conditions acquired by the statistical analysis front-end program;
s3, the statistical analysis back-end program performs statistics, analysis and processing on the acquired data, and feeds back the results of statistics, analysis and processing to the statistical analysis front-end program;
and S4, displaying the query, statistics and analysis results in a webpage form by the statistical analysis front-end program according to the fed back statistical analysis result data, wherein the display mode comprises a report and a chart.
In an optional embodiment, the software architecture of the data acquisition system is a B/S architecture, the development languages are Java and Kotlin, the adopted frameworks are spring-mvc, spring-boot and spring-data-jpa, the database is MySQL, and the development integration environment is Intellij IDEA.
In an optional embodiment, when detection data of a platform scale sensor/a price computing scale sensor/an automatic grouping module are acquired, the detection data of each day are stored in an Excel file, namely the detection data of each day correspond to one Excel file;
when the detection data statistical results of the platform scale sensor/the pricing scale sensor/the automatic grouping module are collected, the detection data statistical results of each month are stored in an Excel file, namely the detection data statistical results of each month correspond to one Excel file, and the detection data statistical results of each day of the month correspond to one row of an Excel table.
In an optional embodiment, the detection data acquisition and the statistical result acquisition of the platform scale sensor/pricing scale sensor/automatic grouping module are jointly completed by the data acquisition client and the data acquisition server;
in the detection data acquisition, a data acquisition client traverses all detection data Excel files according to a path specified by a configuration file, finds out the detection data Excel files which are not uploaded yet or the Excel files added with new detection records after uploading, and then sends the Excel files to an application server; the data acquisition server side analyzes the Excel file of the detection data sent by the data acquisition client side, compares the Excel file with the cache content of the uploaded file, adds the data record which is not uploaded to a corresponding table of the database, and automatically adds field information such as date, equipment/detection line and the like;
in the statistical result acquisition, the data acquisition client searches an Excel file storing the statistical result of the detection data in the current month according to a path specified by the configuration file, and sends the Excel file to the application server; and the data acquisition server analyzes the Excel file of the detection data statistical result sent by the data acquisition client, and adds the statistical result record which is not uploaded and the updated data record in the file to a corresponding table of the database by comparing the Excel file with the uploaded record cache content.
In an optional embodiment, the visual inspection module further comprises a visual inspection data uploading module, and the operation steps of the visual inspection data acquisition are as follows:
s1, visual detection is mainly performed on the strain gauge plates, the visual detection result of each strain gauge plate is stored in an Excel file, the file name of the file is the bar code of the sensor film, the content of the file is a square matrix formed by 0 and 1, each unit corresponds to one strain gauge, 1 represents a good product, 0 represents a bad product, and the product of the line number m and the column number n of the square matrix represents the number of the strain gauges in one strain gauge plate;
s2, the visual detection data uploading module checks the visual detection Excel files which are not uploaded yet, then the data of the Excel tables are read out and corresponding connection and disconnection conversion is carried out, namely, one Excel file is converted into one record, and the record is added into the corresponding table of the database;
s3, traversing all visual inspection data Excel files by the data acquisition client according to the path designated by the configuration file, finding out the visual inspection data Excel files which are not uploaded, and then sending the Excel files to the application server;
s4, the data acquisition server analyzes the visual detection data Excel file sent by the data acquisition client, analyzes the bar code, date, model, furnace number, resistance adjuster, projector and inspector of the strain gauge plate according to the file name, analyzes the line number, column number, bit string, total number of sensors, good product number, bad product number and the like of the strain gauge plate according to the file content, and then adds the visual detection record to a corresponding table of a database.
In an optional embodiment, the statistical result of the production data of the chip mounter is stored in an Excel file, one record is recorded every day, the record comprises date, yield, failure rate, equipment utilization rate and the like, the statistical result every day corresponds to one line of the Excel table, and the statistical result collection of the production data of the chip mounter is completed by a data collection client and a data collection server together;
the data acquisition client searches an Excel file of the production statistical result of the chip mounter according to a path specified by the configuration file, and sends the Excel file to the application server; and the data acquisition server analyzes the Excel file of the chip mounter production statistical result sent by the data acquisition client, compares the Excel file with the uploaded record cache content, and appends the statistical result record which is not uploaded and the updated data record in the file to a corresponding table of the database.
In an optional embodiment, the query statistical analysis subsystem is implemented in a B/S mode, and a user logs in the query statistical analysis subsystem through a browser and then performs related query, statistical analysis operation, and the like according to the user right.
In an optional embodiment, when inquiring the detection data of the platform scale sensor, according to the input time period and the detection line number, inquiring to obtain the detection data of the platform scale, wherein the detection data comprises the detection line number, an operator, a date, time, a sequence number, a platform number, zero voltage, zero drift duration, zero drift zero point, loading voltage, creep duration, creep voltage, zero return voltage, a K value, a zero drift value, a creep value, a zero return value, a zero drift proportion, a creep proportion, a result, a repeated K value 1, a repeated K value 2, a repeated K value 3 and repeatability;
counting the detection data of the platform scale sensor according to the time period and the equipment/detection line number; the platform balance sensor detection data statistical chart comprises the following steps: counting the change condition line graphs of the yield, the good products and the bad products for a period of time according to the time period; counting a change condition line graph of the yield and the defective rate for a period of time according to the time period; counting the change condition line graphs of the starting time and the utilization time according to the time period; counting a change condition line graph of the equipment utilization rate according to the time period; counting a comparison histogram of good products/bad products in the total output according to the time period; and (4) counting a quality Pareto chart comparing zero over/K over/zero drift/creep/return to zero problems in the defective products according to time periods.
In an alternative embodiment, when inquiring the price computing scale sensor detection data, inquiring the price computing scale detection data meeting the conditions according to the input time period, the equipment/detection line number and the operator, comprising: detecting line, operator, date, time, sequence number, station number, zero voltage, zero drift duration, zero drift zero point, loading voltage, creep duration, creep voltage, zero return voltage, K value, zero drift value, creep value, zero return value, zero drift proportion, creep proportion, result and the like;
counting the detection data of the price computing scale sensor according to the time period and the detection line number; the price computing scale sensor detection data statistical chart comprises the following steps: counting the change condition line graphs of the yield, the good products and the bad products for a period of time according to the time period; counting a change condition line graph of the yield and the defective rate for a period of time according to the time period; counting the change condition line graphs of the starting time and the utilization time according to the time period; counting a line graph of the change condition of the equipment utilization rate according to the time period; counting a comparison histogram of good products/bad products in the total output according to the time period; and (4) counting a comparison quality Pareto chart of zero over/K over/zero drift/creep/return-to-zero problems in the defective products according to time periods.
In an optional embodiment, when querying the detection data of the automatic grouping module, querying to obtain qualified automatic grouping detection data according to the input time period, the device/detection line number, and the serial number, includes: detecting line, operator, date, time, machine station number, test model, zero voltage, zero drift time, zero drift zero point, loading voltage, creep time, creep voltage, zero return voltage, grouping value, zero drift value, creep value, zero return value, zero drift proportion, creep proportion, result, serial number and the like;
and counting the detection data of the automatic grouping module according to the time period and the detection line number; the automatic grouping module detection data statistical chart comprises the following steps: counting the total test number, good product and bad product change condition line graphs in a period of time according to the time period; counting a line graph of the change conditions of the yield and the defective rate for a period of time according to the time period; according to the time period, calculating the line graphs of the change conditions of the starting time and the running time; counting a histogram of the comparison of good products/bad products in the total output according to the time period; and (4) counting a comparison quality Pareto chart of zero over/K over/zero drift/creep/return-to-zero problems in the defective products according to time periods.
In an optional embodiment, in the visual inspection data query, according to the input date range, model, resistance adjuster, inspector and the like, the detection records meeting the conditions are queried and obtained, and the detection records comprise information of inspection date, bar code, specification model, good product number, defective product number, sensor number, resistance adjuster, projector, inspector and the like. For the specific detection result of the strain gauge plate, good products and bad products can be displayed in a square matrix;
and the time period is used as a statistical screening condition, and a resistance adjuster/a projector/a detector is used as a statistical basis to count visual detection data; the visual inspection data statistical chart comprises: counting a line graph of the total number change condition of the test films in a period of time according to conditions such as a time period, a resistance adjuster, a model and the like; counting line graphs of the change conditions of the number of sensors, the number of good products and the number of bad products detected in a period of time according to conditions such as a time period, a resistance adjuster, a model and the like; according to conditions such as time periods, resistance regulators, models and the like, calculating a line graph of the change conditions of the yield and the defective rate of the product in a period; and counting the comparison histogram of good products/bad products according to conditions such as time periods, resistance regulators, models and the like.
In an optional embodiment, when the production data of the chip mounter is counted, the production data of the chip mounter is counted according to a time period and a production equipment number, wherein the data comprises date, yield, failure rate, equipment utilization rate and the like; the statistical chart of the production data of the chip mounter comprises the following steps: and (4) counting the line graphs of the production yield change conditions of the chip mounter in a period of time according to the period of time and the equipment number.
In the invention, the production data acquisition and statistical analysis system acquires the data of each production and detection station into the database server, so that the production and detection data can be inquired, tracked, counted and analyzed, the inquiry and the display of each statistical data are facilitated, each statistical analysis result can be visually known, the industrialization and informatization integration is realized, and the intelligent degree is high.
The invention also provides a data acquisition device for the intelligent manufacturing of the weighing sensor, which comprises the data acquisition system for the manufacturing of the weighing sensor.
It is to be understood that the above-described embodiments of the present invention are merely illustrative of or explaining the principles of the invention and are not to be construed as limiting the invention. Therefore, any modification, equivalent replacement, improvement and the like made without departing from the spirit and scope of the present invention should be included in the protection scope of the present invention. Further, it is intended that the appended claims cover all such variations and modifications as fall within the scope and boundaries of the appended claims or the equivalents of such scope and boundaries.
Claims (10)
1. A data acquisition system for intelligent manufacturing of weighing sensors is characterized by comprising a data acquisition subsystem, a database server and a statistical analysis subsystem;
the input end of the database server is in communication connection with the data acquisition subsystem, and the output end of the database server is in communication connection with the statistical analysis subsystem;
the data acquisition subsystem is in communication connection with the platform scale sensor, the price computing scale sensor, the automatic grouping module, the visual detection module and the chip mounter and is used for acquiring data from each production and detection station and uploading the acquired data to the database server, wherein the acquired data comprises platform scale sensor data, price computing scale sensor data, automatic grouping sensor detection data, visual detection data and chip mounter production data;
the data acquisition subsystem comprises a data acquisition client and a data acquisition server, wherein the data acquisition client is in communication connection with the data acquisition server; the data acquisition client runs on each computer connected with the production or detection station equipment, and the data acquisition server runs on the application server;
the statistical analysis subsystem is in communication connection with the query module and is used for acquiring related data from the database according to input conditions, analyzing and counting the related data and forming related reports and charts;
the statistical analysis subsystem comprises a statistical analysis front-end program and a statistical analysis back-end program, and the statistical analysis front-end program is in communication connection with the statistical analysis back-end program; the statistical analysis front-end program runs on a browser, and the statistical analysis back-end program runs on a server.
2. The data acquisition system for intelligent manufacturing of weighing sensors as claimed in claim 1, wherein the database server comprises a data collection module, a data output module and a data storage module;
the data collection module is used for collecting data; the data output module is used for outputting related data; and the data storage module is used for storing the related data.
3. The data acquisition system for intelligent manufacturing of the weighing sensor as claimed in claim 1, wherein the data acquisition client and the data acquisition server operate as follows:
s1, obtaining relevant information such as detection/production equipment type, equipment number/detection line number, file reading path, Excel file naming rule and the like by reading relevant configuration files;
s2, timing execution and checking of Excel data files of each production and detection station, and sending the not-uploaded Excel data files or the uploaded Excel files added with new production detection record data to an application server;
and S3, the data acquisition server receives the Excel file, analyzes and processes the received Excel file, including data verification, data comparison and code analysis, and then adds the latest production and detection data into a corresponding table of the database.
4. The data acquisition system for the intelligent manufacturing of weighing sensors according to claim 1, characterized in that the operation steps of the statistical analysis front-end program and the statistical analysis back-end program are as follows:
s1, inputting query and statistical conditions by an operator through a query module, and acquiring the input query and statistical conditions by a statistical analysis front-end program;
s2, the statistical analysis back-end program acquires data from the relevant table of the database server according to the query and statistical conditions acquired by the statistical analysis front-end program;
s3, the statistical analysis back-end program performs statistics, analysis and processing on the acquired data, and feeds back the results of statistics, analysis and processing to the statistical analysis front-end program;
and S4, displaying the query, statistics and analysis results in a webpage form by the statistical analysis front-end program according to the fed back statistical analysis result data, wherein the display mode comprises a report and a chart.
5. The data acquisition system for the intelligent manufacturing of the weighing sensor as claimed in claim 1, wherein the software architecture of the data acquisition system is B/S architecture, the development language is Java and Kotlin, the adopted frameworks are spring-mvc, spring-boot and spring-data-jpa, the database is MySQL, and the development integration environment is Intellij IDEA.
6. The data acquisition system for intelligent manufacturing of the weighing sensor as claimed in claim 1, wherein when detecting data acquisition aiming at the platform scale sensor/the price computing scale sensor/the automatic grouping module, daily detection data is stored in an Excel file, namely the daily detection data corresponds to one Excel file;
when the detection data statistical results of the platform scale sensor/the pricing scale sensor/the automatic grouping module are collected, the detection data statistical results of each month are stored in an Excel file, namely the detection data statistical results of each month correspond to one Excel file, and the detection data statistical results of each day of the month correspond to one row of an Excel table.
7. The data acquisition system for intelligent manufacturing of the weighing sensor as claimed in claim 6, wherein the detection data acquisition and the statistic result acquisition of the platform scale sensor/the price scale sensor/the automatic grouping module are jointly completed by the data acquisition client and the data acquisition server;
in the detection data acquisition, a data acquisition client traverses all detection data Excel files according to a path specified by a configuration file, finds out the detection data Excel files which are not uploaded yet or the Excel files added with new detection records after uploading, and then sends the Excel files to an application server; the data acquisition server side analyzes the Excel file of the detection data sent by the data acquisition client side, compares the Excel file with the cache content of the uploaded file, adds the data record which is not uploaded to a corresponding table of the database, and automatically adds field information such as date, equipment/detection line and the like;
in the statistical result acquisition, the data acquisition client searches an Excel file storing the statistical result of the detection data in the current month according to a path specified by the configuration file, and sends the Excel file to the application server; and the data acquisition server analyzes the Excel file of the detection data statistical result sent by the data acquisition client, and adds the statistical result record which is not uploaded and the updated data record in the file to a corresponding table of the database by comparing the Excel file with the uploaded record cache content.
8. The data acquisition system for intelligent manufacturing of weighing sensors according to claim 1, wherein the visual inspection module further comprises a visual inspection data uploading module, and the operation steps of the visual inspection data acquisition are as follows:
s1, visual detection is mainly performed on the strain gauge plates, the visual detection result of each strain gauge plate is stored in an Excel file, the file name of the file is the bar code of the sensor film, the content of the file is a square matrix formed by 0 and 1, each unit corresponds to one strain gauge, 1 represents a good product, 0 represents a bad product, and the product of the line number m and the column number n of the square matrix represents the number of the strain gauges in one strain gauge plate;
s2, the visual detection data uploading module checks the visual detection Excel files which are not uploaded yet, then the data of the Excel tables are read out and corresponding connection and disconnection conversion is carried out, namely, one Excel file is converted into one record, and the record is added into the corresponding table of the database;
s3, traversing all visual inspection data Excel files by the data acquisition client according to the path designated by the configuration file, finding out the visual inspection data Excel files which are not uploaded, and then sending the Excel files to the application server;
s4, the data acquisition server analyzes the visual detection data Excel file sent by the data acquisition client, analyzes the bar code, date, model, furnace number, resistance adjuster, projector and inspector of the strain gauge plate according to the file name, analyzes the line number, column number, bit string, total number of sensors, good product number, bad product number and the like of the strain gauge plate according to the file content, and then adds the visual detection record to a corresponding table of a database.
9. The data acquisition system for the intelligent manufacturing of the weighing sensor as claimed in claim 1, wherein the statistical result of the production data of the chip mounter is stored in an Excel file, one record per day comprises date, yield, failure rate, equipment utilization rate and the like, the statistical result per day corresponds to one line of the Excel table, and the statistical result acquisition of the production data of the chip mounter is completed by a data acquisition client and a data acquisition server;
the data acquisition client searches an Excel file of the production statistical result of the chip mounter according to a path specified by the configuration file, and sends the Excel file to the application server; and the data acquisition server analyzes the Excel file of the chip mounter production statistical result sent by the data acquisition client, compares the Excel file with the uploaded record cache content, and appends the statistical result record which is not uploaded and the updated data record in the file to a corresponding table of the database.
10. A data acquisition device for intelligent manufacturing of weighing sensors, which is characterized by comprising the data acquisition system for manufacturing of weighing sensors as described in any one of the items 1-9.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010189909.1ACN111273628A (en) | 2020-03-18 | 2020-03-18 | Data acquisition system and device for intelligent manufacturing of weighing sensor |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010189909.1ACN111273628A (en) | 2020-03-18 | 2020-03-18 | Data acquisition system and device for intelligent manufacturing of weighing sensor |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111273628Atrue CN111273628A (en) | 2020-06-12 |
Family
ID=70998118
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010189909.1APendingCN111273628A (en) | 2020-03-18 | 2020-03-18 | Data acquisition system and device for intelligent manufacturing of weighing sensor |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111273628A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113656463A (en)* | 2021-08-19 | 2021-11-16 | 江苏亨通光导新材料有限公司 | A method and system for collecting and uploading gas consumption data for optical fiber preform production |
| CN118277449A (en)* | 2024-03-25 | 2024-07-02 | 东莞捷璞电子科技有限公司 | Industrial production test data management method and system |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030150908A1 (en)* | 2001-12-28 | 2003-08-14 | Kimberly-Clark Worldwide, Inc. | User interface for reporting event-based production information in product manufacturing |
| CN103440542A (en)* | 2013-07-25 | 2013-12-11 | 中国计量学院 | Quality tracing system and method of expansion valves |
| CN103745311A (en)* | 2013-12-25 | 2014-04-23 | 天通精电新科技有限公司 | Production data management information system |
| CN107015540A (en)* | 2017-04-18 | 2017-08-04 | 江苏信息职业技术学院 | A kind of creation data real-time acquisition system based on DCS |
| CN109614430A (en)* | 2018-12-05 | 2019-04-12 | 云南大学 | WLAN-based configurable data acquisition and data verification system and method |
| CN110737712A (en)* | 2019-10-19 | 2020-01-31 | 南京凯盛国际工程有限公司 | InfluxDB time sequence data storage system |
- 2020
- 2020-03-18CNCN202010189909.1Apatent/CN111273628A/enactivePending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030150908A1 (en)* | 2001-12-28 | 2003-08-14 | Kimberly-Clark Worldwide, Inc. | User interface for reporting event-based production information in product manufacturing |
| CN103440542A (en)* | 2013-07-25 | 2013-12-11 | 中国计量学院 | Quality tracing system and method of expansion valves |
| CN103745311A (en)* | 2013-12-25 | 2014-04-23 | 天通精电新科技有限公司 | Production data management information system |
| CN107015540A (en)* | 2017-04-18 | 2017-08-04 | 江苏信息职业技术学院 | A kind of creation data real-time acquisition system based on DCS |
| CN109614430A (en)* | 2018-12-05 | 2019-04-12 | 云南大学 | WLAN-based configurable data acquisition and data verification system and method |
| CN110737712A (en)* | 2019-10-19 | 2020-01-31 | 南京凯盛国际工程有限公司 | InfluxDB time sequence data storage system |
Non-Patent Citations (1)
| Title |
|---|
| 范占峰: "称重传感器检测系统的设计与实现", 《中国优秀硕士学位论文全文数据库 信息科技辑》* |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113656463A (en)* | 2021-08-19 | 2021-11-16 | 江苏亨通光导新材料有限公司 | A method and system for collecting and uploading gas consumption data for optical fiber preform production |
| CN118277449A (en)* | 2024-03-25 | 2024-07-02 | 东莞捷璞电子科技有限公司 | Industrial production test data management method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110489314A (en) | Model method for detecting abnormality, device, computer equipment and storage medium | |
| CN110864795B (en) | Weighing abnormity alarm system | |
| CN116342073B (en) | Book printing digital information management system and method thereof | |
| US20220230476A1 (en) | Systems and methods for analyzing machine performance | |
| CN111273628A (en) | Data acquisition system and device for intelligent manufacturing of weighing sensor | |
| CN109934268A (en) | Abnormal transaction detection method and system | |
| JP2012159942A (en) | Data storage device, and control method and control program of data storage device | |
| CN119204835A (en) | Quality traceability system of traditional Chinese medicine granules based on data fusion | |
| CN114254951A (en) | Power grid equipment arrival sampling inspection method based on digitization technology | |
| CN118505246B (en) | Traditional Chinese medicine production traceability method and system based on big data | |
| CN117891789B (en) | Nuclear power metadata storage management method and system | |
| CN112685846B (en) | Load spectrum acquisition test method and system | |
| CN116521092B (en) | Industrial equipment data storage method and device | |
| CN117787782B (en) | Enterprise evaluation method and system based on big data | |
| CN117290183A (en) | ETL-based cross-system exception monitoring processing method and device | |
| JP2013178824A (en) | Data collection device, and control method and control program for data collection device | |
| CN113781068B (en) | Online problem solving method, device, electronic equipment and storage medium | |
| CN117234762A (en) | Exception handling method and system | |
| CN103575327A (en) | Automatic detection and analysis device for cigarette physical indexes | |
| CN112598379A (en) | Cost-benefit analysis system and method for instrumentation in power industry | |
| CN118089819B (en) | Online temperature and humidity testing system and method | |
| CN120561186B (en) | NFC (near field communication) equipment-based operation and maintenance object information query and work order automatic generation system | |
| CN113190553B (en) | BPMN-based data reporting system and data reporting method | |
| CN115145990B (en) | Data processing method and related equipment for customs electronic declaration | |
| CN111832979A (en) | A single product quality inspection process tracking and details query system in batch inspection |
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 | ||
| RJ01 | Rejection of invention patent application after publication | Application publication date:20200612 | |
| RJ01 | Rejection of invention patent application after publication |