Device and method for collecting detection data of concrete pressure testing machine

Abstract

The invention relates to a detection data acquisition device and method for a concrete pressure testing machine. The detection data acquisition device comprises an acquisition module, a standardization module, a database module, a management analysis module and a cloud platform, the acquisition module is used for performing full-quantitative data acquisition on the accessed concrete pressure testing machine based on the test number so as to collect real-time data generated when the equipment executes the test; the acquisition module uploads acquired data to the database module through the communication module; the standardization module is used for cleaning and filtering the collected data, identifying and extracting feature data, then performing clustering analysis on the feature data, and configuring a corresponding standardization rule for each piece of clustering data to form standardized data; the cloud platform is used for receiving and storing the standardized data; the management analysis module is used for analyzing and processing the standardized data so as to judge the state corresponding to the test data; and finally, real-time dynamic monitoring of the quality of the whole test operation process is presented through a visual graphic tool. According to the invention, automatic acquisition, analysis and early warning of concrete test block strength detection data and test images are realized.

Description

Technical Field

[0001] The present invention relates to the technical field of concrete compression testing machines, and particularly relates to a device and method for collecting detection data of a concrete compression testing machine. Background Art

[0002] As one of the most widely used building materials in the field of building structures in the world today, concrete materials play an incomparably important role in the field of civil engineering. Compressive strength, as the core index to measure the quality of concrete, is directly related to the safety, durability and service life of buildings and structures, and its importance is self-evident.

[0003] A concrete compression testing machine, this key device, applies pressure through a precise hydraulic system to cause the concrete specimen to fail under controlled conditions, thereby accurately measuring the compressive strength of the concrete. In this process, the pressure sensor plays a crucial role. It is responsible for accurately measuring and transmitting the pressure data applied to the specimen to the data acquisition system. However, when the specimen reaches the failure limit, although the data acquisition system can automatically stop recording, there are still significant deficiencies in the current concrete compression testing machine in terms of data management.

[0004] Specifically, the detection data has not yet achieved seamless docking with the information platform, and the automated acquisition and upload mechanism is not yet perfect. It still mainly relies on manual daily records. This traditional method is not only inefficient, but also difficult to ensure the authenticity and uniqueness of the data, thus causing a series of problems such as low reliability and insufficient security.

[0005] At the same time, there are a variety of concrete compression testing machines at the current construction site, with different manufacturers, models and uneven technical levels. This situation has led to a problem that cannot be ignored: the lack of a unified and efficient automatic data acquisition system and its supporting devices for concrete compression testing machines to achieve the automated acquisition of detection data of different specifications of testing machines.

[0006] In view of this, the integration of traditional concrete compression testing machines and Internet of Things technology is still insufficient, and the informatization and intelligent level of concrete quality control methods need to be improved, and the depth and breadth of control also need to be expanded urgently. Therefore, it is particularly important to build an all-round and three-dimensional concrete quality control system at the construction site. Based on this background, researching and developing a device and method for collecting detection data of a concrete compression testing machine undoubtedly has extremely high practical significance and urgency. Summary of the Invention

[0007] In view of this, the purpose of the present invention is to provide a detection data acquisition device and method for a concrete compression testing machine, which effectively solves the problems that in the existing concrete compression testing machines, due to different models, diverse data formats and data types, it is difficult to collect data, the difficulty of data discrimination is large, and there is a large deviation between the uploaded data and the real data.

[0008] To achieve the above object, the technical solution adopted by the present invention is: a detection data acquisition device for a concrete compression testing machine, including an acquisition module, a standardization module, a database module, a management and analysis module, and a cloud platform; The acquisition module performs full-quantification data acquisition on the connected concrete compression testing machine based on the test number to collect the real-time data generated by the equipment during the execution of the test; the acquisition module uploads the collected data to the database module through the communication module; The standardization module is used to clean and filter the collected data, identify and extract characteristic data, then perform clustering analysis on the characteristic data, and configure corresponding standardization rules for each cluster data respectively to form standardized data; The cloud platform is used to receive and store the standardized data; The management and analysis module analyzes and processes the standardized data to determine the state corresponding to the test data; finally, the real-time dynamic monitoring of the quality of the entire test operation process is presented through a visualization graphic tool.

[0009] Further, the acquisition module includes a power supply module, a pressure transmitter, and a remote IO module; the power supply module is connected to the pressure transmitter and the remote IO module, the pressure transmitter converts the physical pressure value of the pressure device into an analog electrical signal, and then sends the signal to the local environment through the serial port standard protocol, and is received by the script program.

[0010] Further, the pressure transmitter includes multiple groups of pressure sensors, and the multiple groups of pressure sensors are distributed on the pressure plate of the concrete compression testing machine to obtain different pressure points of the concrete test block; the state image of the concrete test block during the compression process is collected by a camera, and the state of the concrete test block at the corresponding moment is obtained through the image.

[0011] Further, the acquisition module further includes an access node for sending an access request to the database module, and the access request includes the device model and the device coordinates. The database module receives the access request, verifies the device model, and feedbacks the verification result. If the verification passes, a storage area is allocated for the device. If it fails, it feedbacks that it fails and requests manual intervention, and customizes the allocation of the storage area.

[0012] Further, for the devices that pass the verification, the standardization module assigns corresponding standard rules to these devices; for the devices that fail the verification, the standardization module provides custom rules, processes the data uploaded by these devices according to the custom rules, and stores the device types in the database module.

[0013] Further, the real-time data includes project name, experiment number, device number, device ID, experiment duration, maximum force, and maximum test rate.

[0014] Further, the standardization module first obtains the data for cleaning and filtering to remove redundant information therein, and then completes the data according to a preset data table. When completing the data, the data is filled into the preset data table, and it is judged whether there are missing items. If there are, the retrieved data and its adjacent data are further identified to obtain the missing data, and the obtained data is supplemented into the preset data table.

[0015] A method for collecting test data of a concrete compression testing machine, using the above-mentioned device for collecting test data of a concrete compression testing machine, includes the following steps: S1. The collection device uses the experiment number as the collection index to collect the real-time data of this experiment. After the collection of this experiment data is completed, a data packet is formed, and a data upload instruction is sent to the database. S2. The database identifies the upload instruction, configures the corresponding storage space according to the corresponding allocation rules, and sends a feedback allowing upload to the collection device. S3. After receiving the feedback, the collection module uploads the data packet to the database. S4. The database decompresses the data packet, extracts the feature information in the data packet, and stores it in the feature form. S5. The standardization module extracts the information of the feature form and performs standardization processing on the feature form according to the pre-allocated standardization rules according to the form information, so as to generate a standardized form. S6. Upload the standardized form to the cloud platform. S7. The management and analysis module processes the standardized form to obtain the experiment data of this experiment number. S8. The experiment data is visually presented through a presentation tool.

[0016] Further, in S4, when extracting the data, first sort the decompressed data packet according to the data type to obtain a data queue, initially judge the data integrity according to the data queue. If the data is missing, a missing data packet is fed back; if the data is complete, the data queue is further identified to form a standard queue corresponding to the feature form, and it is stored in the feature form.

[0017] Further, the method for constructing the standardization rules includes extracting the historical data of the concrete compression testing machine, cleaning and filtering the historical data, identifying multiple data types after removing redundant data, constructing a mapping model between the data types and the standard data, and training to obtain a standardization model.

[0018] The beneficial effects of the above technical solution are: In specific implementation, the present invention takes the experiment number of the experiment as the processing object, encapsulates it into a data packet, and then uploads it to the database through the communication module. After the database receives the data, it squeezes the data, identifies the feature information, and stores the feature information in the feature form, performs standardization processing to obtain unified standard data. The experimental conditions of the corresponding compression testing machine are visually displayed through the standard data.

[0019] At the same time, in order to quickly identify redundant data, the present invention first sorts the data according to the data type, and quickly determines whether the data is complete according to the serial number of the data queue, which can quickly identify redundant data. After one identification, the data is identified again, improving the data processing efficiency.

[0020] In addition, the standardization module of the present invention is used to clean and filter the collected data, identify and extract the feature data, then perform clustering analysis on the feature data, and configure corresponding standardization rules for each cluster data respectively to form standardized data. The data is aggregated in a clustering manner and corresponding standard rules are configured respectively, which can process multiple data types and improve the data standardization efficiency.

[0021] Therefore, the present invention provides a data automatic acquisition device and a data acquisition method for a concrete compression testing machine, realizing the automatic acquisition, analysis, and early warning of the concrete block strength detection data and test images. Deeply integrating the concrete compression testing machine on the construction site with the Internet of Things technology, realizing the automatic and real-time upload of the detection data to the engineering bureau Internet of Things platform, ensuring the authenticity, uniqueness, and traceability of the detection results. Controlling the strength of the concrete standard curing and same-curing blocks through the concrete compression testing machine, enhancing the overall management and control of the concrete quality on the construction site by the engineering bureau, and having important significance for helping to improve the quality and quality of the project. BRIEF DESCRIPTION OF THE DRAWINGS

[0022] Figure 1 is the implementation flowchart of the present invention; Figure 2 is the data transmission schematic diagram of the present invention; Figure 3 is the implementation structural schematic diagram of the acquisition module; DETAILED DESCRIPTION OF THE INVENTION

[0023] The present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments: Example 1. This example aims to provide a data acquisition device for detecting the data of a concrete compression testing machine, which is mainly used to collect the data generated by the concrete compression testing machine during the test operation. After standardized processing, the data is visually displayed. For the current concrete compression testing machines with different models, various data formats and data types, which lead to difficulties in data acquisition, large difficulties in data discrimination, and large deviations between the uploaded data and the real data, this example provides an automatic data acquisition device for concrete compression testing machines to realize the automatic acquisition, analysis, and early warning of the strength detection data and test images of concrete test blocks.

[0024] As Figure 1 shown in [figure], a data acquisition device for detecting the data of a concrete compression testing machine includes an acquisition module, a standardization module, a database module, a management and analysis module, and a cloud platform; mainly uses the Java high-level programming language, the Spring Boot microservice framework, and the Mybatis persistence operation framework. The database uses the MySQL relational database and the Redis non-relational database. The Java language is used because of its characteristic of "compile once and deploy everywhere", which can conveniently solve the problem that test equipment in different environments and scenarios can report pressure data in the same way, conveniently, safely, and controllably.

[0025] Among them, the acquisition module performs full-quantification data acquisition on the connected concrete compression testing machine based on the test number to collect the real-time data generated by the equipment during the execution of the test; the real-time data includes the project name, experiment number, equipment number, equipment ID, experiment duration, maximum force, and maximum test rate.

[0026] As Figures 2 - 3 shown in [figure], the acquisition module uploads the collected data to the database module through the communication module; the acquisition module includes a power supply module, a pressure transmitter, and a remote IO module; the power supply module is connected to the pressure transmitter and the remote IO module. The pressure transmitter converts the physical pressure value of the pressure equipment into an analog electrical signal, and then sends the signal to the local environment through the serial standard protocol, which is received by the script program. The pressure transmitter includes multiple groups of pressure sensors, and the multiple groups of pressure sensors are distributed on the pressure plate of the concrete compression testing machine to obtain different pressure points of the concrete test block; the state image of the concrete test block during the compression process is collected by a camera, and the state of the concrete test block at the corresponding moment is obtained through the image.

[0027] When this example is implemented, as Figure 1As shown in the figure, the database receives data and stores it. At the same time, the database is also used to further process the data. The standardization module is used to clean and filter the collected data, identify and extract feature data, then perform clustering analysis on the feature data, and configure corresponding standardization rules for each cluster of data to form standardized data. The cloud platform is used to receive and store the standardized data. The management and analysis module analyzes and processes the standardized data to determine the status corresponding to the test data. Finally, the real-time dynamic monitoring of the quality of the entire test operation process is presented through a visualization graphic tool.

[0028] The acquisition module also includes an access node, which is used to send an access request to the database module. The access request includes the device model and device coordinates. The database module receives the access request, verifies the device model, and feedbacks the verification result. If the verification passes, a storage area is allocated for the device. If it fails, it feedbacks that it fails, requests manual intervention, and customizes the allocation of the storage area. For the device that passes the verification, the standardization module allocates corresponding standard rules for the device. For the device that fails the verification, the standardization module provides custom rules and performs standard processing on the data uploaded by the device according to the custom rules, and at the same time stores the device type in the database module.

[0029] The standardization module first obtains the data for cleaning and filtering to remove redundant information therein. Subsequently, the data is complemented according to a preset data table. When complementing the data, the data is filled into the preset data table, and it is judged whether there are missing items. If so, the retrieved data and its adjacent data are further identified to obtain the missing data, and the obtained data is supplemented into the preset data table.

[0030] In this embodiment, a method for collecting detection data of a concrete pressure testing machine uses the above-mentioned device for collecting detection data of a concrete pressure testing machine, and includes the following steps: S1. The acquisition device uses the experiment number as the acquisition index to acquire the real-time data of the experiment. When the acquisition of the experiment data is completed, it identifies the character indicating the end of the experiment, summarizes the useful information formed during this time period into a data packet, and sends a data upload instruction to the database. In this embodiment, the acquisition device acquires data and actively sends a request to the database, and packs and sends the acquired data to the database.

[0031] S2. The database identifies the upload instruction, configures the corresponding storage space according to the corresponding allocation rules, and sends a feedback allowing upload to the acquisition device. When the database identifies the upload instruction, it will identify the configuration information of the concrete pressure testing machine, provide the corresponding storage space for the data packet according to the configuration information, and feedback the instruction allowing upload.

[0032] S3. After receiving the feedback, the acquisition module uploads the data packet to the database. During implementation, through a standardized API interface, the Hypertext Transfer Protocol (HTTP) is used, and Token security data encryption verification is added during the transmission process. At the same time, it will be reported to the platform database in the first time to ensure the security and timeliness of the data.

[0033] S4. The database stores the data packet in the allocated space. At the same time, the database decompresses the data packet, extracts the feature information in the data packet, and stores it in the feature form. When extracting data, first sort the decompressed data packet according to the data type to obtain a data queue. Then, preliminarily judge the data integrity based on the data queue. If data is missing, the missing data packet will be feedback. If the data is complete, further identify the data queue to form a standard queue corresponding to the feature form and store it in the feature form.

[0034] In this embodiment, sorting is first performed according to the data type. The classification standard of the data type can be format classification. By identifying the data format and performing cluster analysis on the feature data, corresponding standardized rules are configured for each cluster of data to form standardized data. The clustering method can cluster according to the data format and provide a standardized rule for this type of data at the same time, which is convenient for unifying the data format, avoiding different types of data formats, and providing a basis for the standardized display of data.

[0035] S5. The standardization module extracts the information of the feature form and performs standardization processing on the feature form according to the pre-allocated standardization rules in the form information, thereby generating a standardized form. The construction method of the standardization rules includes extracting the historical data of the concrete pressure testing machine, performing data cleaning and filtering on the historical data, removing redundant data, then identifying multiple data types, constructing a mapping model between the data type and the standard data, and training to obtain a standardized model.

[0036] S6. Upload the standardized form to the cloud platform. S7. The management and analysis module processes the standardized form to obtain the experimental data of the experimental number. S8. The experimental data is visually presented through a presentation tool.

[0037] In this embodiment, aiming at the problems of different models of concrete pressure testing machines, diverse data formats and data types, the device realizes the unified acquisition and processing of data from different models of testing machines through the full-quantification data acquisition of the acquisition module and the cleaning, filtering, feature extraction and cluster analysis of the standardization module, effectively solving the problem of difficult data acquisition.

[0038] During implementation, through the settings of pressure transmitters and multiple groups of pressure sensors, data of concrete test blocks at different pressure points can be accurately obtained. At the same time, combined with the images of the compression process state collected by the camera, the accuracy and reliability of the data are further improved. After the standardized module cleans, filters, extracts features and conducts cluster analysis on the collected data, corresponding standardization rules are configured for each cluster of data to form standardized data. This not only unifies the data format but also provides a basis for the standardized display of data, facilitating subsequent data analysis and processing. During the data transmission process, the HTTP hypertext transfer protocol is adopted, and Token security data encryption verification is added to ensure the security and timeliness of the data. At the same time, through the standardized API interface, the rapid upload and storage of data are realized. The management and analysis module analyzes and processes the standardized data, and presents the real-time dynamic monitoring of the quality of the entire test operation process through visual graphic tools. This not only improves the transparency of the test process but also provides an intuitive and easy-to-understand way of presenting test data for testers, realizing the automatic collection, analysis, and early warning of the strength detection data of concrete test blocks, greatly reducing manual intervention and data processing time, and improving the test efficiency.

[0039] The embodiments of the present invention described above do not constitute a limitation to the protection scope of the present invention. Any modifications, equivalent replacements, improvements, etc. made within the spirit and principle of the present invention shall be included within the protection scope of the claims of the present invention.

Claims

1. A data acquisition device for a concrete pressure testing machine, characterized in that: It includes collection module, standardization module, database module, management and analysis module and cloud platform; The acquisition module performs full quantitative data acquisition on the connected concrete pressure testing machine based on the test number to collect real-time data generated by the equipment when executing the test; The acquisition module uploads the collected data to the database module through the communication module; The standardization module is used to clean and filter the collected data, identify and extract feature data, then perform cluster analysis on the feature data, and configure corresponding standardization rules for each cluster data to form standardized data; The cloud platform is used to receive and store standardized data; The management and analysis module analyzes and processes the standardized data to determine the status corresponding to the test data; and finally presents real-time dynamic monitoring of the quality of the entire test operation process through a visual graphic tool.

2. The detection data acquisition device for a concrete pressure testing machine according to claim 1, characterized in that: The acquisition module includes a power module, a pressure transmitter and a remote IO module; the power module is connected to the pressure transmitter and the remote IO module, and the pressure transmitter converts the physical pressure value of the pressure equipment into an analog electrical signal, and then sends the signal to the local environment through the serial port standard protocol and is received by the script program.

3. The detection data acquisition device for a concrete pressure testing machine according to claim 2 is characterized in that: The pressure transmitter includes multiple groups of pressure sensors, which are distributed on the pressure plate of the concrete pressure testing machine to obtain different pressure points of the concrete test block; the state image of the concrete test block during the pressure process is collected by a camera, and the state of the concrete test block at the corresponding moment is obtained through the image.

4. The detection data acquisition device for a concrete pressure testing machine according to claim 2, characterized in that: The acquisition module also includes an access node for sending an access request to the database module, wherein the access request includes the device model and device coordinates. The database module receives the access request, verifies the device model, and feeds back the verification result. If the verification passes, a storage area is allocated to the device. If not, a feedback is given that it fails, manual intervention is requested, and a custom storage area is allocated.

5. The detection data acquisition device for a concrete pressure testing machine according to claim 4 is characterized in that: For devices that pass the verification, the standardization module assigns corresponding standard rules to the device; for devices that fail the verification, the standardization module provides custom rules and performs standard processing on the data uploaded by the device according to the custom rules, and stores the device type in the database module.

6. The detection data acquisition device for a concrete pressure testing machine according to claim 1, characterized in that: The real-time data includes project name, experiment number, equipment number, equipment ID, experiment duration, maximum force and maximum test rate.

7. The detection data acquisition device for a concrete pressure testing machine according to claim 1, characterized in that: The standardization module first obtains the data for cleaning and filtering to remove redundant information, and then completes the data according to the preset data table. When completing the data, the data is filled into the preset data table and it is determined whether there are missing items. If so, the retrieved data and its adjacent data are further identified to obtain the missing data, and the obtained data is supplemented into the preset data table.

8. A method for collecting detection data of a concrete pressure testing machine, using the detection data collection device of the concrete pressure testing machine according to claim 1, characterized in that: The steps include: S1. The collection device uses the experiment number as the collection index to collect the real-time data of the experiment. When the experimental data is collected, it forms a data packet and sends a data upload instruction to the database; S2, the database identifies the upload instruction, configures the corresponding storage space according to the corresponding allocation rules, and sends a feedback to the collection device to allow uploading; S3, after receiving the feedback, the acquisition module uploads the data packet to the database; S4, the database decompresses the data packet, extracts the characteristic information in the data packet, and stores it in the characteristic form; S5, the standardization module extracts characteristic form information, and performs standardization processing on the characteristic form according to the form information and the pre-assigned standardization rules, thereby generating a standardized form; S6. Upload the standardized form to the cloud platform; S7, the management and analysis module processes the standardized form to obtain the experimental data of the experimental number; S8. Experimental data are visualized through presentation tools.

9. The method for collecting detection data of a concrete pressure testing machine according to claim 8, characterized in that: In S4, when extracting data, the decompressed data packets are first sorted according to the data type to obtain a data queue. The data integrity is preliminarily judged based on the data queue. If the data is missing, the missing data packet is fed back; if the data is complete, the data queue is further identified to form a standard queue corresponding to the feature form and stored in the feature form.

10. The method for collecting detection data of a concrete pressure testing machine according to claim 8, characterized in that: The method for constructing the standardization rules includes extracting the historical data of the concrete pressure testing machine, cleaning and filtering the historical data, removing redundant data, identifying the data types to obtain multiple data types, constructing a mapping model between the data types and standard data, and training to obtain a standardized model.

Images