Monitoring management method for tunnel support construction

Abstract

The invention relates to the technical field of construction management, in particular to a monitoring management method for tunnel support construction, which comprises the following steps: setting a unique operation ID for single guniting operation and single anchor rod mounting operation, associating the operation ID with construction time, an operation team, an equipment number, a material batch number and design parameters, collecting all operation data, and storing the collected data into a database; and a tunnel support full-period construction information base is established. According to the method, the unique operation ID is set for each guniting operation and single anchor rod installation operation, the ID is bound with the construction time, the operation team, the equipment number, the material batch number, the design parameters and other information, a traceable data basis is formed, the whole-process traceability of the construction behavior is achieved, and after an abnormal signal of a monitoring point is triggered, the operation of the single anchor rod is completed. And reversely retrieving associated operation information by adopting process sequence logic, constructing a quality problem tracing chain, and realizing accurate defect positioning and responsibility path restoration.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of construction management, and particularly relates to a monitoring and management method for tunnel support construction. BACKGROUND

[0002] The technical field of construction management is a key component in the engineering construction and project execution control system, mainly involving plan preparation, resource allocation, progress control, quality monitoring, safety management, cost accounting and collaborative scheduling in the construction process.

[0003] In the prior art, information fragmentation in the construction management process makes the defect responsibility division in the construction process ambiguous, especially in a multi-party collaboration environment, the responsibility determination often relies on artificial experience or fragmentary records, and there is a lack of unified data standard, which reduces the objectivity of quality evaluation. For example, when quality problems occur in support operations, it is difficult to restore the specific batch of anchor rod construction, the materials used and the construction personnel path, and only post-evaluation can be made based on the result level, which delays the defect processing period, increases construction cost and safety risk. At the same time, the prior art fails to form an effective linkage between supplier material performance and construction results, making it difficult to evaluate the material end risk simultaneously. Therefore, improvement is needed. SUMMARY

[0004] The purpose of the present application is to solve the problems existing in the prior art and to provide a monitoring and management method for tunnel support construction.

[0005] In order to achieve the above-mentioned purpose, the present application adopts the following technical scheme, a monitoring and management method for tunnel support construction, comprising the following steps:

[0006] A unique operation ID is set for single-shot grouting operation and single-anchor rod installation operation, the operation ID is associated with construction time, operation team, equipment number, material batch number and design parameters, all operation data are collected, and a tunnel support full-cycle construction information database is established;

[0007] According to the tunnel support full-cycle construction information database, the process sequence logic of drilling, hole cleaning and grouting in anchor rod construction is preset, when an abnormal signal of a target monitoring point ID is received, the data bound to the monitoring point ID in the tunnel support full-cycle construction information database is traversed in reverse, a defect associated operation ID sequence is obtained, all associated operation IDs and bound information are extracted according to the process sequence logic, and a quality problem traceability chain is formed in combination with the defect associated operation ID sequence;

[0008] According to the quality problem traceability chain, the associated material suppliers are extracted, the index data of each supplier is collected, and a material supply chain logistics stability index is calculated and obtained;

[0009] According to the quality problem traceability chain, the frequencies of each construction team and anchor rod material supplier appearing in multiple quality problem traceability chains are counted, a multi-source subject associated quality problem frequency table is established, the multi-source subject associated quality problem frequency table is jointly configured with a material supply chain logistics stability index of the supplier, and a construction quality comprehensive responsibility result is generated.

[0010] Preferably, the tunnel support full-cycle construction information database is obtained by:

[0011] The construction time, operation team, equipment number, material batch number, and design parameters are called according to the unique operation ID, a one-to-one binding relationship between the unique operation ID and the parameters is established, and a time and operation identifier is generated for each binding relationship record to generate a unique operation ID binding record.

[0012] According to the unique operation ID binding record, all operation items are gathered piece by piece, a retrieval index is established according to the unique operation ID, a sorting index is established according to the construction time, and auxiliary indexes are established according to the operation team and the material batch number to form a structured storage, and a tunnel support full-cycle construction information database is obtained.

[0013] According to the unique operation ID binding record, all operation items are gathered piece by piece, a retrieval index is established according to the unique operation ID, a sorting index is established according to the construction time, and auxiliary indexes are established according to the operation team and the material batch number to form a structured storage, and a tunnel support full-cycle construction information database is obtained.

[0014] Preferably, the defect associated operation ID sequence is obtained by:

[0015] According to the tunnel support full-cycle construction information database, the drilling record field, the hole cleaning record field, and the grouting record field are extracted, the process label, the process sequence code, and the front and rear constraint are marked, the fixed parallel flag and the timeout processing flag are fixed, the mapping relationship between the process label and the process sequence code is established, and the anchor rod construction process sequence logic is obtained.

[0016] According to the anchor rod construction process sequence logic, the abnormal signal of the target monitoring point ID is received, the operation ID, timestamp, construction time, operation team, equipment number, material batch number, and design parameters bound with the target monitoring point ID in the tunnel support full-cycle construction information database are retrieved, the adjacent process positions and cross-process intervals are recorded piece by piece in reverse order according to the timestamp, and the defect associated operation ID sequence is generated.

[0017] Preferably, the quality problem traceability chain is obtained by:

[0018] According to the defect-related operation ID sequence, adjacent process comparison and cross-process missing verification are performed on the operation ID in the anchor rod construction process sequence logic, construction time, operation team, equipment number, material batch number and design parameters bound by the operation ID are aggregated, and a traceable node chain is formed according to the defect-related operation ID sequence, so that a quality problem traceability chain is formed.

[0019] Preferably, the obtaining step of the material supply chain logistics stability index is:

[0020] According to the quality problem traceability chain, the material batch number field, the supplier name field and the supplier code field bound by the defect-related operation ID are read, the consistency of the supplier name and the supplier code is verified piece by piece and repeated items are removed, and the operation ID, the corresponding timestamp and the material batch number are recorded to generate an associated material supplier list;

[0021] According to the associated material supplier list, the arrival record and the planned arrival record are extracted for comparison to obtain the arrival punctuality rate, the inspection record is extracted to calculate the batch quality pass rate, the procurement record and the shipping record are compared to obtain the supply quantity satisfaction degree and the transit loss rate, the price record is extracted to calculate the price fluctuation coefficient, the emergency replenishment record is extracted to calculate the emergency replenishment response time, all indicators are interval normalized to determine the positive ideal value and the negative ideal value, and a normalized indicator set and a positive and negative ideal solution set are generated;

[0022] According to the normalized indicator set and the positive and negative ideal solution set, the material supply chain logistics stability index is calculated.

[0023] Preferably, the obtaining step of the multi-source subject-related quality problem frequency table is:

[0024] According to the quality problem traceability chain, a pairing key is established according to the construction team name and the anchor rod material supplier name, the occurrence number of the pairing key is accumulated piece by piece, and the construction team operation number, the associated operation ID list, the first timestamp and the last timestamp are accumulated synchronously, the repeated pairing keys are merged and the field consistency is checked, and a multi-source subject-related quality problem frequency table is generated.

[0025] Preferably, the obtaining step of the construction quality comprehensive responsibility result is: according to the multi-source subject-related quality problem frequency table, a bilateral joint responsibility index is calculated.

[0026] Preferably, the obtaining step of the construction quality comprehensive responsibility result further includes: the bilateral joint responsibility index is sorted in descending order according to the construction team name and the anchor rod material supplier name, the bilateral joint responsibility index, the first timestamp, the last timestamp and the associated operation ID list of each pair are extracted, and a construction quality comprehensive responsibility result is formed.

[0027] Compared with the prior art, the advantages and positive effects of the present application are that:

[0028] The application sets a unique operation ID for each shotcrete operation and single anchor rod installation operation, binds the ID with construction time, operation team, equipment number, material batch number and design parameters, forms a traceable data basis, makes the construction behavior have whole-process traceability, after an abnormal signal of a monitoring point is triggered, reversely searches the associated operation information according to the process sequence logic, constructs a quality problem trace chain, realizes accurate positioning of defects and restoration of responsibility path, further extracts the material suppliers involved in the trace chain, constructs a logistics stability index around the stability of the supply index, establishes a joint responsibility evaluation model of the construction team and the material supplier combined with the appearance frequency of the construction team in multiple trace chains, quantitatively fuses the statistical frequency and the stability index, the operation ID granularity control enhances the fineness of the basic data, the process logic embedding improves the context accuracy of information extraction, the supply chain and construction responsibility joint evaluation enhances the horizontal collaborative identification ability, improves the response efficiency and accuracy of responsibility pointing of abnormal quality problems, and ensures the control of the construction process in complex engineering scenes. BRIEF DESCRIPTION OF DRAWINGS

[0029] Figure 1 The figure is a schematic diagram of the steps of the application. DETAILED DESCRIPTION

[0030] In order to make the purpose, technical scheme and advantages of the application more clear, the application will be further described in detail below in combination with the drawings and examples. It should be understood that the specific examples described herein are only used to explain the application and do not limit the application.

[0031] Please refer to Figure 1 The application provides a technical scheme, a monitoring and management method for tunnel support construction, comprising the following steps:

[0032] A unique operation ID is set for single shotcrete operation and single anchor rod installation operation, the operation ID is associated with construction time, operation team, equipment number, material batch number and design parameters, all operation data is collected, and a tunnel support whole-cycle construction information database is established;

[0033] According to the tunnel support whole-cycle construction information database, the process sequence logic of drilling, hole cleaning and grouting in anchor rod construction is preset, when an abnormal signal of a target monitoring point ID is received, the data bound with the monitoring point ID in the tunnel support whole-cycle construction information database is traversed in reverse, a defect associated operation ID sequence is obtained, all associated operation IDs and bound information are extracted according to the process sequence logic, a quality problem trace chain is formed combined with the defect associated operation ID sequence;

[0034] According to the quality problem traceability chain, the associated material suppliers are extracted, the index data of each supplier is collected, and the material supply chain logistics stability index is calculated and obtained;

[0035] According to the quality problem traceability chain, the frequency of each construction team and anchor rod material supplier appearing in multiple quality problem traceability chains is counted, a multi-source subject associated quality problem frequency table is established, the multi-source subject associated quality problem frequency table and the material supply chain logistics stability index of the supplier are jointly configured, and a construction quality comprehensive responsibility result is generated.

[0036] The acquisition steps of the tunnel support full-cycle construction information database are:

[0037] For single-shot guniting operation and single-anchor rod installation operation, the construction time is analyzed, the operation team is extracted, the equipment number is read, the material batch number is searched, the design parameters are imported, the fixed field order is spliced and compared, it is verified whether there is a duplicate record, and a unique operation ID is obtained;

[0038] According to the unique operation ID, the construction time, the operation team, the equipment number, the material batch number and the design parameters are called, a one-to-one binding relationship between the unique operation ID and the parameters is established, the time and the operation identifier are generated for each binding relationship record, and a unique operation ID binding record is generated;

[0039] According to the unique operation ID binding record, all operation items are gathered piece by piece, a retrieval index is established according to the unique operation ID, a sorting index is established according to the construction time, auxiliary indexes are established according to the operation team and the material batch number, a structured storage is formed, and a tunnel support full-cycle construction information database is obtained.

[0040] Specifically, for single shotcrete operation and single anchor rod installation operation respectively, first, the original data stream is obtained from the industrial computer or data acquisition terminal carried by the equipment, which contains timestamp, equipment status code and operation parameters. For the construction time field, it is parsed according to the ISO 8601 standard format, that is, "YYYY-MM-DDTHH:mm:ss.sssZ", and converted into Coordinated Universal Time (UTC) timestamp. When extracting the operation team information, it is queried through the interface with the construction scheduling management system, and the team identifier is matched with the construction timestamp. The equipment number is directly extracted from the preset field of the data stream to obtain the unique equipment asset code. The material batch number needs to call the records of the material management system, and according to the operation time and the equipment used, the material batch information allocated to the equipment in the time period is queried reversely. At the same time, when importing design parameters, according to the tunnel mileage position where the operation occurs, the corresponding support design requirements are called from the Building Information Model (BIM) or design parameter database, such as shotcrete thickness, anchor rod length, anchor rod spacing and other parameters. Then, according to the fixed field order of "tunnel mileage_operation type_equipment number_operation team ID_material batch number", the original identification string is generated by string splicing. In order to generate a compact and unique ID, SHA-256 hashing algorithm is used to calculate the original identification string after splicing, and the first 32 hexadecimal characters are taken as the candidate unique operation ID. Before formal determination, duplicate record checking is carried out. The checking mechanism sets a time window threshold, which is calculated according to the historical operation data statistics. The specific calculation method is to calculate the average time interval of all adjacent two operations, and take one fourth of the average value as the judgment standard. For example, if the average operation interval is 20 minutes, the threshold is 5 minutes. When a new candidate unique operation ID is generated, it is checked whether there is a record with the same ID and within the 5-minute window. If there is, the current record is marked as potential duplicate data, and the manual review process is triggered. If not, the candidate ID is confirmed as a valid unique operation ID. In this way, a reliable and conflict-free identity is given to each independent construction activity, and finally the unique operation ID is obtained.

[0041] According to the unique job ID generated in the previous step, the full set of parameters associated with it are immediately called, including the parsed construction time, the matched operation team ID, the read equipment number, the retrieved material batch number, and the design parameters imported from the design library. In order to establish a one-to-one binding relationship between the unique job ID and these parameters, a key-value pair data structure is used for encapsulation, where the key is the unique job ID and the value is a structured object containing all associated parameters, such as a JSON object. The object clearly divides the information of the five dimensions of time, personnel, equipment, materials, and design, ensuring the integrity of the data and the convenience of subsequent calls. When generating the binding relationship, two additional metadata fields, namely time and operation ID, are attached to each record. Among them, the time identifier is the server system timestamp that records the current binding operation, which is used to trace the exact moment when the data is entered into the database, and the operation identifier is a predefined code used to mark the status of the record. For example, '10' represents "create", '20' represents "update", and '30' represents "archive". When the binding relationship is first established, the identifier is uniformly set to '10'. This process is completed through an atomic database transaction, that is, the generation of a unique job ID and its binding with parameters are submitted as an indivisible operation unit, ensuring data consistency. There will be no "orphan" data with only ID but no corresponding parameters. The specific binding record is represented as a complete record with metadata tags at the data level. For example, { "Job ID": "a1b2c3d4e5f6...", "Related data": { "Construction time": "2023-11-01T10:30:00Z", "Operation team": "CZ-01", "Equipment number": "SGJ-05","Material batch number": "SN-20231028-003", "Design parameters": { "Spraying thickness": "25cm", "Initial setting time":"8min"}}, "Record generation time": "2023-11-01T10:30:05.123Z", "Operation identifier": "10"}, Through this series of operations, a unique job ID binding record with a regular structure and complete information is generated.

[0042] According to the series of unique job ID binding records generated in the previous step, these records are gathered and stored in a central database one by one to build the entity of the information library. This process is not simply stacking, but is accompanied by the establishment of indexes and the optimization of storage structure. At the data storage level, a relational database management system is selected, and a core data table named "Supporting Operation Information Table" is designed. Each row of the table corresponds to a unique job ID binding record, and the columns correspond to unique job ID, construction time, operation team, equipment number, material batch number, and a JSONB or TEXT type field for storing design parameters. In order to achieve efficient data retrieval and analysis, multiple indexes are established according to the preset index strategy while data is being written. First, the unique job ID field is set as the primary key index, which is a unique, non-empty clustered index, ensuring the highest performance when querying by job ID. Second, a B-tree type sorting index is established for the construction time field, which supports quick filtering of data by time range and time sorting of the results. Auxiliary indexes are also established for the operation team and material batch number fields, which can speed up the query speed for all jobs related to a specific team or a specific batch of materials, reducing the overhead of full table scanning. Through this multi-index parallel strategy, the originally discrete job entries are organized into a highly structured data set, forming a logically clear and easily accessible structured storage, and ultimately obtaining a tunnel support full-cycle construction information library that supports multi-dimensional and high-performance queries.

[0043] The acquisition step of the defect-related job ID sequence is:

[0044] According to the tunnel support full-cycle construction information library, the drilling record field, hole cleaning record field, and grouting record field are extracted, the process label, process sequence code, and pre-post constraint are labeled, the fixed parallel flag and timeout processing flag are fixed, the mapping relationship between the process label and the process sequence code is established, and the anchor rod construction process sequence logic is obtained.

[0045] According to the anchor rod construction process sequence logic, the abnormal signal of the target monitoring point ID is received, the job ID, timestamp, construction time, operation team, equipment number, material batch number, and design parameters bound to the target monitoring point ID in the tunnel support full-cycle construction information library are retrieved, the adjacent process positions and cross-process intervals are recorded in reverse order according to the timestamp, and the defect-related job ID sequence is generated.

[0046] Specifically, according to the tunnel support full-cycle construction information base, firstly, the work type filtering condition is set, for example, the record of the work type field is 'anchor rod drilling', 'anchor rod hole cleaning' or 'anchor rod grouting', all the drilling record fields, hole cleaning record fields and grouting record fields related to anchor rod installation are extracted from the information base, then, the three types of work records are standardized labeled, specifically, the 'anchor rod drilling' record is given the process label 'DRILL' and the process sequence code '1', the 'anchor rod hole cleaning' record is given the process label 'CLEAN' and the process sequence code '2', the 'anchor rod grouting' record is given the process label 'GROUT' and the process sequence code '3', then the pre-post constraint between them is defined, it is clearly specified that the work with the process sequence code '2' must be completed as a prerequisite for the pre-process '1', the work with the process sequence code '3' must be completed as a prerequisite for the pre-process '2', for the linear process of anchor rod construction, the fixed parallel flag is set to 'FALSE', indicating that the three processes cannot be performed at the same time on the same anchor rod, then, the timeout processing flag is set, which is a specific time threshold value for judging whether the interval between adjacent processes is too long, the threshold value is set based on historical data analysis, the specific method is to randomly select at least 5000 complete anchor rod construction records from the tunnel support full-cycle construction information base, calculate the time difference between the 'drilling' completion time and the 'hole cleaning' start time, and the time difference between the 'hole cleaning' completion time and the 'grouting' start time, respectively form two time difference data sets, calculate the average value and standard deviation of each data set, the timeout threshold is set to the average value plus 1.5 times the standard deviation, for example, if the average interval between 'hole cleaning' and 'grouting' is 45 minutes, the standard deviation is 10 minutes, then the timeout threshold is 45 + 1.5 * 10 = 60 minutes, finally, all the defined information, including process label, process sequence code, pre-post constraint, parallel flag and calculated timeout threshold, are organized into a structured configuration table or mapping set, the mapping relationship between the process label and the process sequence code is established, and the anchor rod construction process sequence logic is obtained.

[0047] According to the anchor rod construction procedure sequence logic, when receiving the abnormal signal of the target monitoring point ID from the site automation monitoring system, the signal usually contains the monitoring point number, such as 'MP_K10+500_R', the abnormal occurrence timestamp, and the abnormal type, such as 'displacement overrun'. Immediately, the information is input to search the tunnel support full-cycle construction information database. The search range is not global, but a localized query based on space and time. Spatially, according to the mileage position information contained in the target monitoring point ID, all anchor rod installation operation records within a distance of less than a preset radius, for example, 2 meters, from the position in three-dimensional space are filtered out in the information database. Temporally, the search range is limited to the operations completed within 72 hours before the abnormal occurrence timestamp. Through this spatio-temporal joint filtering, the operation set most likely related to the abnormality is accurately locked, and the IDs, timestamps, construction times, operation teams, equipment numbers, material batch numbers, and design parameters of these operations are obtained. Then, the filtered operation set is arranged in descending order according to the timestamp, starting from the most recent operation, and each operation is traced back in reverse order. In the backtracking process, the procedural logic relationship between the current operation and the previous operation (i.e., the operation earlier in time) is recorded, for example, if the procedural sequence code of the current operation is '3' and the previous operation is '2', it is recorded as adjacent procedures, and the difference between the timestamps of the two operations is calculated as the cross-procedure interval. This interval is compared with the corresponding timeout threshold in the anchor rod construction procedure sequence logic. If the interval is greater than the threshold, the operation ID is marked with 'timeout'. If the procedural sequence code of the current operation is '3' and the previous operation is '1', it is determined as a cross-procedure, and the operation ID is marked with'missing step'. This backtracking process continues until a complete 'GROUT'- 'CLEAN'- 'DRILL' procedure chain is found or all filtered operation records are traversed. Finally, all operation IDs recorded in the backtracking process are arranged in reverse order to form the defect-associated operation ID sequence.

[0048] The acquisition steps of the quality problem traceability chain are:

[0049] According to the defect-associated operation ID sequence, the operation IDs are compared for adjacent procedures and cross-procedure missing according to the anchor rod construction procedure sequence logic. The construction time, operation team, equipment number, material batch number, and design parameter bound to the operation ID are organized into a traceable node chain in the order of the defect-associated operation ID sequence to form the quality problem traceability chain.

[0050] Specifically, according to the defect-associated job ID sequence generated in the previous step, a verification and data aggregation process is started. First, the job ID in the sequence is re-checked according to the anchor construction process sequence logic. Specifically, it starts from the first job ID in the sequence (the latest job in time), reads its process sequence code, and then reads the process sequence code of the next job ID in the sequence. Adjacent processes are compared according to the preceding and following constraint rules in the anchor construction process sequence logic to verify whether the sequence codes of the two are continuously decreasing. For example, the current one is '3', and the next one should be '2'. If not, it is confirmed that there is a cross-process missing, and a 'logical break' mark is added to the connection between the two IDs. At the same time, the timestamps corresponding to the two IDs are extracted, the difference is calculated, and compared with the timeout threshold set in the anchor construction process sequence logic to confirm whether there is a timeout. After completing the verification of the entire sequence, each job in the sequence is checked. Data aggregation is performed for each job ID. That is, each job ID is used as an index to initiate a precise query to the tunnel support full-cycle construction information database, and all detailed information bound one-to-one with the ID, including construction time, operating team, equipment number, material batch number, and design parameters including anchor length, diameter, angle and other parameters, are completely extracted. Finally, these job records that aggregate all information are organized strictly according to the original order of the defect-related job ID sequence to construct a chain data structure, in which each node represents a specific job. The node stores all the information of the job and the status identifier generated during the verification process (such as "normal", "timeout", and "predecessor missing"). The nodes are linked in reverse chronological order through pointers or indexes, forming a traceable node chain with complete information and clear logic from the quality problem manifestation (abnormal signal) to the construction source, ultimately forming a quality problem traceability chain.

[0051] The steps to obtain the material supply chain logistics stability index are:

[0052] Based on the quality problem traceability chain, the system reads the material batch number field, supplier name field, and supplier code field bound to the defect-related job ID, verifies the consistency of the supplier name and supplier code one by one, and removes duplicates. The system also records the job ID, corresponding timestamp, and material batch number to generate a list of related material suppliers.

[0053] Based on the list of associated material suppliers, the system extracts arrival records from each supplier and compares them with planned arrival records to determine the on-time arrival rate. It extracts inspection records to calculate the batch quality acceptance rate. It extracts purchase records and compares them with shipping records to determine the supply quantity satisfaction and in-transit loss rate. It extracts price records to calculate the price fluctuation coefficient. It extracts emergency replenishment records to calculate the emergency replenishment response time. All indicators are interval-normalized and positive and negative ideal values ​​are determined to generate a set of normalized indicators and a set of positive and negative ideal solutions.

[0054] According to the normalized index set and the positive and negative ideal solution set, the material supply chain logistics stability index is calculated. The calculation formula is:

[0055] ;

[0056] in, For the The material supply chain logistics stability index of each supplier, For the Supplier in the The value of a normalized indicator, For the The positive ideal value of a normalized indicator, For the The negative ideal value of a normalized indicator, is the total number of normalized indicators, is the supplier's serial number, is the serial number of the normalized indicator, For the The historical instability coefficient of a normalized indicator comes from the relative volatility of the historical series of the normalized indicator. For the The correlation criticality coefficient between a standardized indicator and the current quality problem traceability chain.

[0057] Specifically, according to the quality problem traceability chain, each traceable node in the chain is traversed, and for each node associated with a unique job ID, a query is initiated to the tunnel support full-cycle construction information database to read its bound material batch number field to obtain batch number information such as "SN20231101A". Then, using this material batch number, an associated query is performed in the material management system to extract the corresponding supplier name field, such as "XX Special Building Materials Co., Ltd.", and the supplier code field, such as "GS0087". Subsequently, data consistency verification is performed to combine the queried supplier name and supplier code, and match and verify them against a preconfigured qualified supplier master data table. This master data table is entered at the start of the project and updated periodically, and contains the official full name and unique internal code of all cooperating suppliers. If a completely matching record cannot be found in the master data table, the job ID and its associated supplier information are marked as "to be verified", and a data cleaning task is generated. After the verification is completed, in order to construct a list of suppliers without duplication, the supplier code is used as a unique identifier, and all involved supplier information is aggregated and deduplicated. The specific operation is to use a hash table structure, with the supplier code as the key. When a new supplier code is encountered, a new entry is created in the hash table, and the current job ID, corresponding timestamp, and material batch number are stored as initial information in the entry. If the encountered supplier code already exists in the hash table, only the new job ID, timestamp, and material batch number are appended to the information list of the corresponding entry. Through a series of data extraction, verification, and aggregation operations, the associated material supplier list is finally generated.

[0058] According to the generated associated material supplier list in the previous step, for each supplier in the list, a series of logistics support capability indicators are calculated by calling data from different modules in the enterprise resource planning (ERP) system. First, to calculate the on-time delivery rate, all past six months of delivery records and corresponding planned delivery records of the supplier are extracted from the procurement and logistics module. The actual delivery date is compared with the planned delivery date, and a 24-hour grace period is set, i.e. the actual delivery date is not later than the planned delivery date plus 24 hours, which is considered on-time. The on-time delivery rate calculation formula is: on-time delivery rate = (number of on-time delivery batches / total number of delivery batches) X 100%. Second, to calculate the batch quality pass rate, all material batch entry inspection records are retrieved from the quality management module. The batch quality pass rate is equal to the number of batches with a test result of "pass" divided by the total number of test batches, multiplied by 100%. Third, to obtain the supply quantity satisfaction degree and the transit loss rate, the procurement order records of the procurement module are compared with the actual warehouse entry records of the warehouse module. The supply quantity satisfaction degree is the cumulative actual warehouse entry total quantity of all orders divided by the cumulative order requirement total quantity, and the transit loss rate is the difference between the cumulative shipment quantity and the cumulative warehouse entry quantity divided by the cumulative shipment quantity. Fourth, to calculate the price fluctuation coefficient, the historical purchase price records of the same standard anchor rod material are extracted from the financial module. The standard deviation of these prices is calculated, and then divided by the average price to obtain the price fluctuation coefficient. Finally, to calculate the emergency replenishment response time, orders marked as "urgent" or "emergency" in the procurement records are selected, and the average length of time from order placement to final warehouse entry of the material is calculated to obtain the emergency replenishment response time. After obtaining the six original indicators (on-time delivery rate, batch quality pass rate, supply quantity satisfaction degree, transit loss rate, price fluctuation coefficient, and emergency replenishment response time), interval normalization processing is performed on them to convert all indicator values to the range of 0 to 1. For positive indicators such as on-time delivery rate, the normalization formula is For negative indicators such as transit loss rate, the formula is where and are the maximum and minimum values of all suppliers in the past year for the indicator. Through this method, the positive ideal value of all indicators is determined as 1, and the negative ideal value is determined as 0. Finally, a normalized indicator set and a unified positive and negative ideal solution set are generated for each supplier.

[0059] In the material supply chain logistics stability index calculation formula, the dynamic weighting improved TOPSIS method is used to evaluate the supply chain logistics stability of a specific supplier under the current quality problem background. The formula introduces a dynamic weight factor composed of the historical instability coefficient and the current problem association key degree coefficient ​The weight can adaptively adjust the influence of each evaluation index in the comprehensive evaluation according to the historical performance stability of the index and the correlation with the current specific quality problem, so that the evaluation result is more targeted and objective. The Euclidean distance between the weighted sample point (supplier) and the positive and negative ideal solutions is calculated, and the relative closeness is used to quantify the advantages and disadvantages. The denominator is the sum of the weighted distances to the positive and negative ideal solutions, and the numerator is the weighted distance to the negative ideal solution, so that the result falls in the interval [0, 1]. The closer the value is to 1, the closer the supplier is to the ideal state and the higher the stability.

[0060] The acquisition step of the parameter is the value of the first supplier on the first normalized index, which is derived from the generated normalized index set, which quantifies and unifies the performance of the supplier in multiple dimensions such as on-time delivery rate, batch quality pass rate, etc. to the interval [0, 1]. In this example, the supplier A (i.e. ) is evaluated, which involves the values of 6 normalized indices (i.e. ): on-time delivery rate , batch quality pass rate , supply quantity satisfaction , transit loss rate (normalized, the higher the value represents less transit loss), price fluctuation coefficient (normalized, the higher the value represents more stable price), emergency replenishment response time (normalized, the higher the value represents faster response).

[0061] The acquisition step of the parameter is the positive ideal value of the first normalized index. After normalization and interval normalization, the best performance of all indices corresponds to the value 1, so for all 6 indices in this example, the positive ideal value is 1, i.e. .

[0062] The acquisition step of the parameter is the negative ideal value of the first normalized index. Corresponding to the positive ideal value, after normalization, the worst performance of all indices corresponds to the value 0, so for all 6 indices in this example, the negative ideal value is 0, i.e. .

[0063] The acquisition step of the parameter is the total number of normalized indices, which is determined by the evaluation system design. In this method, 6 core indices are selected to evaluate the stability of the supply chain, so .

[0064] The acquisition step is that the parameter is the historical instability coefficient of the first normalized index, which is obtained by calculating the relative volatility (i.e., the coefficient of variation) of the historical data sequence of the index. Specifically, the original data of the index in the past 24 months is collected, and the ratio of the standard deviation to the average value is calculated. For example, for the index 1 (on-time delivery rate), 24 data points are collected, the average value is calculated to be 91%, the standard deviation is calculated to be 4.55%, and the instability coefficient is , and the instability coefficients of other indexes are calculated as follows: , , , , .

[0065] The acquisition step is that the parameter is the historical instability coefficient of the first normalized index, which is obtained by calculating the relative volatility (i.e., the coefficient of variation) of the historical data sequence of the index. Specifically, the original data of the index in the past 24 months is collected, and the ratio of the standard deviation to the average value is calculated. For example, for the index 1 (on-time delivery rate), 24 data points are collected, the average value is calculated to be 91%, the standard deviation is calculated to be 4.55%, and the instability coefficient is , , , , , .

[0066] According to the parameters, the calculation is as follows:

[0067] First, calculate the dynamic weight of each index :

[0068] ;

[0069] ;

[0070] ;

[0071] ;

[0072] ;

[0073] ;

[0074] Next, the weighted distance of supplier A to the negative ideal solution is calculated :

[0075] ;

[0076] ;

[0077] ;

[0078] Then, the weighted distance of supplier A to the positive ideal solution is calculated :

[0079] ;

[0080] ;

[0081] ;

[0082] Finally, the material supply chain logistics stability index is calculated :

[0083] ;

[0084] The results show that the material supply chain logistics stability index of supplier A is 0.884, which is very close to 1, indicating that the supplier is very close to the ideal state after considering the historical stability and the correlation of current quality problems, and the stability of the logistics supply chain is high. Although the quality problem traces back to the material of the supplier, from the comprehensive evaluation of multiple dimensions and long period, the supplier is still a highly reliable partner.

[0085] The steps for obtaining the multi-source subject associated quality problem frequency table are:

[0086] According to the quality problem traceability chain, the pairing key is established according to the construction team name and the anchor rod material supplier name, the appearance frequency of the pairing key is accumulated piece by piece, and the construction team operation frequency, the associated operation ID list, the first time stamp and the last time stamp are accumulated synchronously, the repeated pairing keys are merged and the field consistency is checked, and the multi-source subject associated quality problem frequency table is generated.

[0087] Specifically, according to the quality problem traceability chain, traverse each operation node on the chain, extract the operation team name field and material batch number field from the node data, and then obtain the corresponding anchor material supplier name field by querying the material management system database based on the material batch number. Subsequently, the "construction team name" and the "anchor material supplier name" are concatenated with a specific separator (such as "|") to form a unique pairing key, such as "CZ-01 Team|XXX Special Building Materials Co., Ltd.". Next, initialize a hash table structure for dynamic statistics, with the pairing key as the key of the hash table and the value as a composite object containing multiple statistical items. These statistical items include: the number of pairing key occurrences, the total number of operations of the construction team, the list of associated operation IDs, the first timestamp and the last timestamp. When processing each node of the traceability chain, the corresponding pairing key is generated and updated in the hash table. The value of this key, if the key appears for the first time, creates a new entry, sets the number of occurrences to 1, and records the current job ID and timestamp; if the key already exists, adds 1 to the number of occurrences, and appends the new job ID to the associated job ID list. At the same time, the last timestamp is compared and updated. While processing the pairing key, the construction information database is asynchronously queried to count the total number of operations of the construction team since the start of the project, and this value is updated to the composite object corresponding to the pairing key. After traversing all quality problem traceability chains, a merge verification procedure is executed. This procedure merges duplicate pairing keys with essentially the same content but different names according to the preset alias mapping table (for example, "Shift 1" and "Construction Team 1" are both mapped to "CZ-01 Team"), and their statistical data are accumulated. Finally, all entries in the hash table are converted into a tabular form to generate a multi-source subject-associated quality problem frequency table.

[0088] The steps for obtaining the comprehensive responsibility results for construction quality are as follows:

[0089] According to the frequency table of quality problems associated with multiple sources, the bilateral joint responsibility index is calculated using the following formula:

[0090] ;

[0091] in, For the construction team With anchor material suppliers The bilateral joint responsibility index, For the construction team With anchor material suppliers The ratio of the number of paired occurrences in the multi-source subject association quality problem frequency table divided by the sum of all paired occurrences, For the construction team The historical defect index is equal to the construction team The number of related quality issues divided by the number of construction teams the value obtained by interval normalization after the number of times of operation, the stability index of the material supply chain logistics of the anchor rod material supplier , the serial number of the construction team, the serial number of the anchor rod material supplier;

[0092] The bilateral joint responsibility index is sorted in descending order according to the construction team name and the anchor rod material supplier name, and the bilateral joint responsibility index, the first timestamp, the last timestamp and the associated operation ID list of each pair are extracted to form the construction quality comprehensive responsibility result.

[0093] Specifically, the formula is: The above formula is to establish a quantitative model that can comprehensively measure the joint responsibility of the construction team and the material supplier in a specific quality problem. The term in the formula is the basic weight, which directly reflects the frequency of the specific "team-supplier" combination in the current analyzed quality problem sample, and embodies its direct association strength with the problem. The product term in the square root combines the historical defect tendency of the construction team with the potential instability of the supplier (obtained by taking the inverse of the stability index ). A poorly performing team and a poorly stable supplier working together can amplify the potential risk of causing problems in the form of a product, and finally, the square root operation is used to process this superimposed risk, which can moderately smooth the influence of extreme values, so that the final responsibility index will not be exaggerated due to the extreme bad performance of one party, so as to more fairly evaluate the joint responsibility of both parties.

[0094] The acquisition step is that the parameter represents the frequency of the occurrence of the construction team and the anchor rod material supplier pairing, which is derived from statistical analysis of the generated multi-source subject associated quality problem frequency table, and the calculation formula is: Wherein is the number of occurrences of a specific "team -supplier " pairing found in the frequency table, and is the total number of all pairing occurrences recorded in the table. For example, in an analysis batch containing 10 quality problem traceability chains, a total of 50 "team-supplier" pairing records are generated, of which the pairing of "CZ-01 team" and "XX special building materials" occurs 15 times, and the frequency of this pair is .

[0095] ​The acquisition step of the parameter is the construction team 's historical defect index, which reflects the long-term construction quality level of the team, and its calculation is divided into two steps: first, calculate the original defect rate , the formula is , where is the sum of all times of the team appearing in the multi-source subject correlation quality problem frequency table (for example, the number of times paired with all suppliers is accumulated), is the total number of operations recorded by the team in the tunnel support full-cycle construction information database; second, the original defect rates of all teams are normalized by maximum and minimum to eliminate dimensional effects and map them to the [0, 1] interval, the normalization formula is , where and are the maximum and minimum values of the original defect rates of all construction teams in the current project, for example, team "CZ-01" has a total of 20 quality problems, a total of 500 operations, and an original defect rate , if the value range of all teams is [0.01, 0.08], then the historical defect index of the team .

[0096] The acquisition step of the parameter is the material supply chain logistics stability index of the anchor rod material supplier , which is obtained through the aforementioned material supply chain logistics stability index calculation step. It is a comprehensive score between [0, 1], which directly calls the calculation results of the previous step, for example, the stability index of supplier "XX Special Building Materials" is calculated as .

[0097] According to the parameters, calculate:

[0098] the bilateral joint responsibility index of "CZ-01 team" and "XX Special Building Materials" .

[0099] Given parameters:

[0100] ;

[0101] ;

[0102] ;

[0103] Substitute the formula:

[0104] ;

[0105] ;

[0106] ;

[0107] ;

[0108] ;

[0109] The result shows that the bilateral joint responsibility index of the combination of "CZ-01 team" and "XX special building materials" is about 0.06689, and this value will be used as the basis for subsequent responsibility sorting and division. When the responsibility indexes of all relevant combinations are calculated, the high-risk combination that contributes most to the quality problem can be clearly identified by comparing the sizes of these indexes. For example, if the index of another combination is 0.15, its responsibility is much greater than that of the current combination.

[0110] According to the bilateral joint responsibility index calculated for each "construction team-anchor rod material supplier" pair in the previous step, the data is integrated and presented. First, a result set is created, which contains the construction team name, anchor rod material supplier name and corresponding bilateral joint responsibility index for each record. Then, the result set is sorted by the bilateral joint responsibility index as the primary sorting key in descending order, so that the pair with the highest responsibility index is placed at the top of the list and becomes the first object of attention. After sorting, further enrich the information of each record by querying the multi-source subject associated quality problem frequency table with the construction team name and supplier name as the joint primary key to extract additional diagnostic information related to the pair. Specifically, it includes the timestamp of the first association to the quality problem, the latest association timestamp, and a detailed list containing all unique job IDs related to the pair. By binding the sorted responsibility index with these detailed time and job information, a structured and comprehensive construction quality comprehensive responsibility result is finally formed, which quantifies and sorts the responsibilities of each party.

[0111] The above is only a preferred embodiment of the present application, and does not limit the form of the present application in other ways. Any skilled person in the art can use the disclosed technical content to make changes or modifications to equivalent embodiments applied to other fields, but any simple modification, equivalent change and modification made in accordance with the technical essence of the present application to the above embodiments shall fall within the protection scope of the present application.

Claims

1. A monitoring and management method for tunnel support construction, characterized in that: The following steps are involved: A unique operation ID is set for each shotcrete operation and single anchor bolt installation operation. The operation ID is associated with the construction time, operation team, equipment number, material batch number and design parameters. All operation data is collected to establish a full-cycle construction information database for tunnel support. Based on the tunnel support full-cycle construction information database, the process sequence logic of drilling, cleaning, and grouting in anchor bolt construction is preset. When an abnormal signal of the target monitoring point ID is received, the data bound to the monitoring point ID in the tunnel support full-cycle construction information database is reversely traversed to obtain the defect-related operation ID sequence. Then, all related operation IDs and all bound information are extracted according to the process sequence logic, and combined with the defect-related operation ID sequence to form a quality problem traceability chain; Based on the quality problem traceability chain, the related material suppliers are extracted, the indicator data of each supplier is collected, and the material supply chain logistics stability index is calculated; According to the quality problem traceability chain, the frequency of each construction team and anchor material supplier appearing in multiple quality problem traceability chains is counted, and a frequency table of multi-source subject-related quality problems is established. The frequency table of multi-source subject-related quality problems is jointly configured with the supplier's material supply chain logistics stability index to generate a comprehensive construction quality responsibility result.

2. The monitoring and management method for tunnel support construction according to claim 1, characterized in that: The steps for obtaining the tunnel support full-cycle construction information database are as follows: For each shotcrete operation and anchor bolt installation operation, the construction time is parsed, the operating team is extracted, the equipment number is read, the material batch number is retrieved, and the design parameters are imported. The fields are then spliced ​​and compared according to the fixed field order to check for duplicate records and obtain a unique operation ID. Based on the unique operation ID, the construction time, operation team, equipment number, material batch number and design parameters are called to establish a one-to-one binding relationship between the unique operation ID and the parameters, and a time and operation identifier is generated for each binding relationship record to generate a unique operation ID binding record; According to the unique job ID binding record, all job entries are gathered one by one, a retrieval index is established according to the unique job ID, a sorting index is established according to the construction time, and an auxiliary index is established according to the operating team and material batch number to form a structured storage and obtain a tunnel support full-cycle construction information database.

3. The monitoring and management method for tunnel support construction according to claim 1, characterized in that: The steps for obtaining the defect-related job ID sequence are: Based on the tunnel support full-cycle construction information database, the drilling record field, the hole cleaning record field, and the grouting record field are extracted, the process labels, process sequence codes, and pre- and post-processing constraints are marked, the parallel permission flag and the timeout processing flag are fixed, and a mapping relationship between the process labels and process sequence codes is established to obtain the anchor bolt construction process sequence logic; According to the anchor bolt construction process sequence logic, the abnormal signal of the target monitoring point ID is received, and the operation ID, timestamp, construction time, operation team, equipment number, material batch number and design parameters bound to the target monitoring point ID in the tunnel support full-cycle construction information database are retrieved. The adjacent process positions and cross-process intervals are traced back one by one in reverse order of the timestamp to generate a defect-related operation ID sequence.

4. The monitoring and management method for tunnel support construction according to claim 1, characterized in that: The steps for obtaining the quality problem traceability chain are: According to the defect-associated operation ID sequence, the operation ID is compared with adjacent processes and cross-process missing verification is carried out according to the logic of the anchor construction process sequence. The construction time, operation team, equipment number, material batch number and design parameters bound to the operation ID are aggregated and organized into a traceable node chain in the order of the defect-associated operation ID sequence to form a quality problem traceability chain.

5. The monitoring and management method for tunnel support construction according to claim 1, characterized in that: The steps for obtaining the material supply chain logistics stability index are as follows: According to the quality problem traceability chain, the material batch number field, supplier name field, and supplier code field bound to the defect-related job ID are read, the consistency of the supplier name and supplier code are verified one by one, and duplicates are removed. At the same time, the job ID, corresponding timestamp, and material batch number are recorded to generate a list of related material suppliers; Based on the list of related material suppliers, the system extracts arrival records from each supplier and compares them with planned arrival records to obtain the on-time arrival rate. It extracts inspection records to calculate the batch quality pass rate. It extracts purchase records and compares them with shipping records to obtain the supply quantity satisfaction and in-transit loss rate. It extracts price records to calculate the price fluctuation coefficient. It extracts emergency replenishment records to calculate the emergency replenishment response time. All indicators are interval-normalized and positive and negative ideal values ​​are determined to generate a set of normalized indicators and a set of positive and negative ideal solutions. The material supply chain logistics stability index is calculated based on the normalized indicator set and the positive and negative ideal solution sets.

6. The monitoring and management method for tunnel support construction according to claim 1, characterized in that: The steps for obtaining the frequency table of multi-source subject-related quality issues are as follows: According to the quality problem traceability chain, pairing keys are established according to the construction team name and the anchor material supplier name. The number of pairing key occurrences is accumulated one by one, and the number of construction team operations, the associated operation ID list, the first timestamp and the last timestamp are accumulated simultaneously. Duplicate pairing keys are merged and the field consistency is checked to generate a frequency table of multi-source subject-related quality problems.

7. The monitoring and management method for tunnel support construction according to claim 1, characterized in that: The steps for obtaining the comprehensive construction quality responsibility results are: calculating the bilateral joint responsibility index based on the multi-source subject-related quality problem frequency table.

8. The monitoring and management method for tunnel support construction according to claim 7, characterized in that: The step of obtaining the comprehensive construction quality responsibility result also includes: sorting the bilateral joint responsibility index in descending order according to the construction team name and the anchor material supplier name, extracting each pair of bilateral joint responsibility index, first timestamp, last timestamp and associated job ID list to form the comprehensive construction quality responsibility result.

Images