A multi-source data alignment access method based on coordinate calibration

Abstract

The application provides a multi-source data alignment access method based on coordinate calibration, and relates to the technical field of data processing. The method comprises the following steps: acquiring outer diameter sampling records and traction speed regulation records of an upstream outer diameter detection station and a downstream outer diameter detection station of a medical catheter extrusion line; determining response moments of outer diameter changes caused by the same traction speed regulation reaching the two outer diameter detection stations; calibrating catheter axial coordinates corresponding to the two response moments as the same catheter axial coordinates; establishing a conversion relationship before and after the response moments and determining the catheter axial coordinates of each outer diameter sampling record. The two groups of outer diameter values are resampled according to the same axial coordinate interval, and the outer diameter values of the same medical catheter section are combined and written into a quality detection data set according to the catheter axial coordinates as indexes, so that the wrong combination of outer diameter values of different catheter sections is reduced.

Description

Technical Field

[0001] This application relates to the field of data processing technology, and in particular to a method for aligning and accessing multi-source data based on coordinate calibration. Background Technology

[0002] Edge computing enables data reception and processing close to production equipment, making it suitable for real-time data generated during continuous production. Industrial production lines typically generate detection data, equipment operation data, and control data simultaneously, which are recorded separately by different production devices.

[0003] Building upon this, the production line side also needs to address the differences in data sources, sampling rhythms, and recording methods among different equipment. Multimodal data access is used to organize the aforementioned data, enabling test data and operational data to enter the same quality management process. Continuous extrusion production of medical catheters, characterized by continuous conveying and multi-station testing, represents a specific application scenario for this data access method.

[0004] During continuous extrusion of medical catheters, a laser diameter gauge can collect the catheter's outer diameter, a length measuring device can record the catheter's delivery length, and a programmable logic controller can save changes in traction speed. These devices generate detection data and operational data respectively. Current data access methods typically involve first standardizing the field and time formats, and then merging the data according to sampling time or recording order.

[0005] The arrival times of the same medical catheter segment at different testing positions on the production line vary, and changes in traction speed also alter the distance the catheter travels between adjacent sampling times. When merging outer diameter values ​​from different testing positions according to a fixed time difference or a fixed record number, the time correspondence changes with the traction speed, which means that the outer diameter value in the same testing record may originate from different medical catheter segments. Summary of the Invention

[0006] This application provides a multi-source data alignment and access method based on coordinate calibration to solve the problem in the prior art where the same medical catheter segment arrives at two outer diameter detection stations successively and the traction speed adjustment changes the correspondence between the sampling time and the catheter delivery position, resulting in the outer diameter value merged at the two outer diameter detection stations according to the sampling time possibly corresponding to different medical catheter segments.

[0007] To address the aforementioned technical problems, this application provides a multi-source data alignment and access method based on coordinate calibration, comprising:

[0008] Acquire outer diameter sampling records and traction speed regulation records at the upstream and downstream outer diameter detection stations of the medical catheter extrusion line. The outer diameter sampling records include the outer diameter value, sampling time, and catheter delivery length.

[0009] From the outer diameter sampling records of the two outer diameter detection stations, determine the response times of the outer diameter change caused by the same traction speed adjustment to reach the two outer diameter detection stations respectively;

[0010] The delivery length of the conduit corresponding to the two response times is calibrated to the same conduit axial coordinate, and the conversion relationship between the delivery length of the conduit and the conduit axial coordinate before and after the corresponding response time is established for each outer diameter detection station.

[0011] Based on the relationship between the sampling time and the corresponding response time of each outer diameter sampling record, the corresponding transformation relationship is selected when the sampling time is earlier or later than the corresponding response time, and the same calibrated axial coordinate of the same catheter is used when the sampling time is equal to the corresponding response time to determine the axial coordinate of the catheter corresponding to each outer diameter sampling record.

[0012] The outer diameter values ​​of the two outer diameter detection stations were resampled at the same axial coordinate interval to obtain two sets of outer diameter sequences with consistent coordinate intervals.

[0013] Using the axial coordinate of the catheter as an index, the outer diameter values ​​of the same medical catheter segment in the two sets of outer diameter sequences are merged into a test record, and the test record is written into the quality test dataset.

[0014] Optionally, determining the response times of the outer diameter change caused by the same traction speed adjustment reaching the two outer diameter detection stations from the outer diameter sampling records of the two outer diameter detection stations includes:

[0015] Read the speed regulation time, traction speed before speed regulation, and traction speed after speed regulation from the traction speed regulation record;

[0016] The outer diameter values ​​of each outer diameter testing station are arranged according to the sampling time.

[0017] When the traction speed after speed adjustment is greater than the traction speed before speed adjustment, find the first set of three consecutively decreasing outer diameter sampling records from the outer diameter values ​​after the speed adjustment time; when the traction speed after speed adjustment is less than the traction speed before speed adjustment, find the first set of three consecutively increasing outer diameter sampling records from the outer diameter values ​​after the speed adjustment time.

[0018] The sampling time of the first outer diameter sampling record among the three outer diameter sampling records is determined as the response time of the corresponding outer diameter detection station;

[0019] When the response time of the downstream outer diameter detection station is not later than the response time of the upstream outer diameter detection station, the next set of three continuously decreasing or continuously increasing outer diameter sampling records in the downstream outer diameter detection station are selected in sequence, and the response time of the downstream outer diameter detection station is re-determined until the response time of the downstream outer diameter detection station is later than the response time of the upstream outer diameter detection station.

[0020] Optionally, establishing the transformation relationship includes:

[0021] According to the corresponding response time, the outer diameter sampling records of each outer diameter detection station are divided into outer diameter sampling records with sampling times earlier than the corresponding response time, equal to the corresponding response time, and later than the corresponding response time;

[0022] The catheter delivery length in the outer diameter sampling record at the sampling time is equal to the corresponding response time, and is correlated with the same catheter axial coordinate calibrated at the two response times;

[0023] For outer diameter sampling records whose sampling time is earlier than the corresponding response time, the axial coordinates of the catheter with decreasing values ​​are determined sequentially according to the reverse order of sampling time and the difference in catheter delivery length between adjacent outer diameter sampling records.

[0024] For outer diameter sampling records whose sampling time is later than the corresponding response time, the axial coordinates of the catheter with increasing values ​​are determined sequentially according to the forward order of sampling time and the difference in catheter delivery length between adjacent outer diameter sampling records.

[0025] Based on the catheter delivery length and corresponding catheter axial coordinates in each outer diameter sampling record, the transformation relationship before and after the corresponding response time is formed respectively.

[0026] Optionally, the step of resampling the outer diameter values ​​of the two outer diameter detection stations according to the same axial coordinate interval to obtain two sets of outer diameter sequences with consistent coordinate intervals includes:

[0027] Starting from the same axial coordinate of the conduit calibrated at two response times, generate the coordinates to be sampled in the direction of decreasing coordinates and the direction of increasing coordinates, respectively, according to the same axial coordinate interval;

[0028] The sampling coordinates with values ​​less than the same catheter axial coordinate are matched with the outer diameter sampling records whose sampling time is earlier than the corresponding response time; the sampling coordinates with values ​​equal to the same catheter axial coordinate are matched with the outer diameter sampling records whose sampling time is equal to the corresponding response time; and the sampling coordinates with values ​​greater than the same catheter axial coordinate are matched with the outer diameter sampling records whose sampling time is later than the corresponding response time.

[0029] For each sampling coordinate whose value is less than or greater than the same catheter axial coordinate, only the outer diameter value of the outer diameter sampling record with the smallest absolute value of the difference between the catheter axial coordinate and the sampling coordinate is selected from the outer diameter sampling records on the same side at the corresponding response time. The outer diameter value in the outer diameter sampling record whose sampling time is equal to the corresponding response time is taken as the outer diameter value corresponding to the sampling coordinate whose value is equal to the same catheter axial coordinate.

[0030] The selected outer diameter values ​​are arranged according to the axial coordinate of the conduit to form an outer diameter sequence for two outer diameter testing stations.

[0031] Optionally, merging the outer diameter values ​​of the same medical catheter segment from the two sets of outer diameter sequences into a detection record includes:

[0032] Read the three outer diameter values ​​in each outer diameter sequence, which are consecutively arranged starting from the same axial coordinate of the catheter and along the direction of increasing axial coordinate of the catheter;

[0033] When three adjacent outer diameter values ​​in two sets of outer diameter sequences do not increase or decrease simultaneously, the next set of three outer diameter sampling records that continuously decrease or increase are selected sequentially in the downstream outer diameter detection station to redetermine the response time of the downstream outer diameter detection station.

[0034] Based on the redefined response time of the downstream outer diameter detection station, the conversion relationship and the outer diameter sequence of the two outer diameter detection stations are re-formed until three adjacent outer diameter values ​​in the two sets of outer diameter sequences increase or decrease simultaneously and continuously.

[0035] After three adjacent outer diameter values ​​in two sets of outer diameter sequences increase or decrease simultaneously and continuously, the outer diameter values ​​of the two outer diameter detection stations are paired according to the axial coordinate of the conduit, and the paired outer diameter values ​​are merged into a detection record.

[0036] Optionally, the selection of the outer diameter value corresponding to the coordinate to be sampled includes:

[0037] Find the outer diameter sampling record on the same side at the corresponding response time. When there are outer diameter sampling records on both sides of the coordinate to be sampled, select the outer diameter sampling record with the smallest absolute value of the difference between the axial coordinate of the catheter and the coordinate to be sampled. When there is an outer diameter sampling record on only one side, select the outer diameter sampling record with the smallest absolute value of the difference between the axial coordinate of the catheter and the coordinate to be sampled from the outer diameter sampling records on that side. When the absolute values ​​of the difference between the axial coordinate of the catheter and the coordinate to be sampled are the same for two outer diameter sampling records and both are the minimum values, select the one with the smallest axial coordinate value of the catheter among the two outer diameter sampling records, and use the outer diameter value in the selected outer diameter sampling record as the outer diameter value corresponding to the coordinate to be sampled.

[0038] Optionally, merging the paired outer diameter values ​​into a detection record includes:

[0039] Using the axial coordinate of each conduit as an index, the outer diameter values ​​of the paired upstream and downstream outer diameter detection stations are written into the same detection record.

[0040] Optionally, writing the detection record into the quality detection dataset includes:

[0041] The test records are arranged in ascending order of the axial coordinate of the conduit, and then written into the quality test dataset in sequence.

[0042] Optionally, writing the detection record into the quality detection dataset includes:

[0043] Before writing to the quality inspection dataset, the two outer diameter values ​​in each inspection record are compared with the upper limit and lower limit of the outer diameter tolerance, respectively. When both outer diameter values ​​are greater than the upper limit or less than the lower limit, an outer diameter defect label is added to the corresponding axial coordinate of the conduit. When the two outer diameter values ​​are not simultaneously greater than the upper limit and not simultaneously less than the lower limit, the two outer diameter values ​​are retained and no outer diameter defect label is added. The inspection record that completes the outer diameter defect judgment is then written to the quality inspection dataset.

[0044] Optionally, writing the inspection record that completes the outer diameter defect judgment into the quality inspection dataset includes:

[0045] The inspection records with outer diameter defect labels are arranged according to the axial coordinate of the conduit. Inspection records with adjacent axial coordinates and a coordinate interval equal to the resampled axial coordinate interval are grouped into the same continuous coordinate interval. The starting and ending axial coordinates of the continuous coordinate interval are written into the inspection records within the continuous coordinate interval. All inspection records that have completed the outer diameter defect judgment are written into the quality inspection dataset according to the order of the axial coordinates of the conduit.

[0046] The technical solution provided in this application has the following beneficial effects:

[0047] This application utilizes the timing of the outer diameter change caused by the same traction speed adjustment at two different outer diameter detection stations to identify the same medical catheter segment observed by both stations. The catheter delivery lengths corresponding to the two response times are then calibrated to the same catheter axial coordinate. The outer diameter sampling records before and after the response time are then converted into catheter axial coordinates based on their respective catheter delivery lengths, transforming the temporal sampling data generated during the traction speed change into spatial data arranged along the medical catheter axis. After the outer diameter values ​​at the two outer diameter detection stations are resampled at the same axial coordinate interval, they can be merged point by point according to the catheter axial coordinate, thereby reducing the occurrence of outer diameter values ​​of different medical catheter segments being written into the same detection record. This also enables the quality inspection dataset to save the detection results of the two outer diameter detection stations according to the actual axial position of the medical catheter. Attached Figure Description

[0048] To more clearly illustrate the technical solutions in the embodiments of this application or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0049] Figure 1 This is a schematic diagram of the detection scenario and data connection structure for the extrusion line of a medical catheter provided in an embodiment of this application.

[0050] Figure 2 This is a flowchart illustrating a multi-source data alignment and access method based on coordinate calibration, provided in an embodiment of this application.

[0051] Figure 3 This is a schematic diagram illustrating the writing of resampling, outer diameter value merging, and quality inspection datasets provided in the embodiments of this application.

[0052] Reference numerals: 10, extrusion molding device; 11, catheter forming position; 20, cooling tank; 30, traction device; 31, rotary encoder; 40, upstream outer diameter detection station; 50, downstream outer diameter detection station; 60, traction controller; 70, edge computing device; 80, medical catheter. Detailed Implementation

[0053] To enable those skilled in the art to better understand the present application, the present application will be further described in detail below with reference to the accompanying drawings and specific embodiments. Obviously, the described embodiments are merely some embodiments of the present application, and not all embodiments. Based on the embodiments in this application, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of this application.

[0054] Continuous extrusion production of medical catheters requires online quality inspection without interrupting the supply. The catheter moves continuously on the production line, and quality information from each inspection point is continuously recorded throughout the production process, allowing for subsequent review of the inspection results of the same catheter segment at different locations.

[0055] like Figure 1 As shown, in this embodiment, the medical catheter 80 is output from the catheter forming position 11 of the extrusion molding device 10, cooled by the cooling tank 20, and then pulled and conveyed by the traction device 30, passing sequentially through the upstream outer diameter detection station 40 and the downstream outer diameter detection station 50. The medical catheter 80 passes through the measurement openings of the two stations along the direction of the solid arrow. Each production device continuously generates geometric detection data and operational data, but the data generation time and recording rhythm are not consistent, requiring the scattered records to be organized into detection results corresponding to the axial position of the catheter.

[0056] For the above scenarios, such as Figure 2 As shown in the figure, this embodiment provides a multi-source data alignment and access method based on coordinate calibration, including the following steps.

[0057] S101, acquire the outer diameter sampling records and traction speed adjustment records of the upstream and downstream outer diameter detection stations of the medical catheter extrusion line. The outer diameter sampling records include the outer diameter value, sampling time and catheter delivery length.

[0058] S102, determine the response time of the outer diameter change caused by the same traction speed adjustment to reach the two outer diameter detection stations from the outer diameter sampling records of the two outer diameter detection stations.

[0059] S103, the catheter delivery length corresponding to the two response times is calibrated as the same catheter axial coordinate, the conversion relationship between the catheter delivery length and the catheter axial coordinate before and after the corresponding response time is established for each outer diameter detection station, and the catheter axial coordinate corresponding to each outer diameter sampling record is determined according to the order of sampling time and corresponding response time.

[0060] S104, the outer diameter values ​​of the two outer diameter detection stations are resampled according to the same axial coordinate interval to obtain two sets of outer diameter sequences with consistent coordinate intervals.

[0061] S105, using the catheter axial coordinate as an index, merges the outer diameter values ​​of the same medical catheter segment in two sets of outer diameter sequences into a test record.

[0062] S106, Write the detection records into the quality detection dataset.

[0063] In S101, the edge computing device 70 is located on the medical catheter extrusion line side and is a data processing device that performs S101 to S106. It can be an industrial computer or edge controller with data receiving, processing, and storage access functions. The edge computing device 70 receives the outer diameter sampling records formed by the upstream outer diameter detection station 40 and the downstream outer diameter detection station 50 through the existing data interface of the production line, and receives the traction speed regulation records stored by the traction controller 60. The edge computing device 70 also accesses the storage location of the quality inspection dataset to write the processed inspection records into the quality inspection dataset. The edge computing device 70 thus connects the original records formed by the production equipment with the quality inspection dataset, undertaking the tasks of record acquisition, axial position alignment, outer diameter value merging, and inspection record access.

[0064] Specifically, the outer diameter value can be obtained from an existing laser diameter gauge. The rotary encoder 31 is connected to the rotating component of the traction device 30, collects counting information used to determine the length of the guide tube, and transmits it to the traction controller 60. The traction controller 60 can be a programmable logic controller (PLC) to control the traction speed of the traction device 30 and save the traction speed adjustment records. Figure 1The dashed arrows in the diagram indicate the transmission direction of detection data, length information, traction speed regulation records, and traction control signals. All dashed arrows converge into the edge computing device 70, indicating that the edge computing device 70 obtains the data source required for subsequent processing.

[0065] After receiving the two types of records, the edge computing device 70 retains the correspondence between the outer diameter value, sampling time, and catheter delivery length in each outer diameter sampling record, and organizes subsequent processing based on the speed adjustment event indicated by the traction speed adjustment record. The edge computing device 70 determines the response time of the two outer diameter detection stations in S102, converts the outer diameter sampling records of the two outer diameter detection stations to the same catheter axial coordinate system in S103, forms two sets of outer diameter sequences with consistent coordinate intervals in S104, merges the two outer diameter values ​​of the same medical catheter segment into a detection record in S105, and finally writes it into the quality inspection dataset in S106. In this embodiment, the edge computing device 70's role is thus implemented as continuous data processing from receiving the production line record to writing the quality inspection dataset, ensuring that the outer diameter values ​​formed by different detection stations are integrated according to the axial position of the medical catheter.

[0066] The sampling time in the outer diameter sampling record corresponds to the time when the outer diameter value was formed, and the catheter delivery length corresponds to the delivery length already recorded when the outer diameter value was formed. The outer diameter value, sampling time, and catheter delivery length all come from the same outer diameter sampling record, and therefore can collectively describe a sampling location. The traction speed regulation record includes the speed regulation time, the traction speed before speed regulation, and the traction speed after speed regulation, used to indicate a traction speed adjustment that has occurred. Thus, the outer diameter sampling record provides catheter geometric inspection results, and the traction speed regulation record provides production operation events; these two types of records constitute the multimodal data processed in this embodiment.

[0067] When two types of records enter the same processing, a traction speed regulation record is used as the event starting point. The edge computing device reads the conveying distance from the guide tube forming position to each outer diameter detection station from the production line equipment layout data, and accumulates the guide tube conveying length from the current speed regulation time. When the accumulated guide tube conveying length reaches the corresponding conveying distance, the corresponding outer diameter sampling record is used as the starting point of the candidate record interval for the current speed regulation event at the corresponding outer diameter detection station. After the next traction speed regulation record arrives, the starting point of the candidate record interval for the next speed regulation event at the corresponding outer diameter detection station is determined in the same way, and the starting point of the candidate record interval for the next speed regulation event is used as the end point of the current candidate record interval. The two outer diameter detection stations thus form candidate record intervals that are delayed with the guide tube conveying process. When the next traction speed regulation record has not yet been received, the current speed regulation event remains in a pending state, and the last received outer diameter sampling record is not used as the permanent end point of the candidate record interval; when production ends, the candidate record interval that is still in a pending state ends with the last outer diameter sampling record. Each outer diameter sampling record retains the correlation between the outer diameter value and the corresponding sampling time and catheter delivery length. The record sorting only changes the processing order and does not split the three data in the same record.

[0068] When comparing the speed adjustment time with the sampling time, all records use a unified time reference. For example, two outer diameter detection stations and a traction controller can use the system time of the same programmable logic controller. When each device has an independent clock, the existing Precision Time Protocol (PTP) can be used to calibrate the recording time. Time calibration only maintains the order of records; the spatial position of the same medical catheter segment is determined by the subsequent catheter delivery length conversion.

[0069] After data acquisition, S102 searches for outer diameter changes within the candidate record intervals corresponding to the two outer diameter detection stations. The response time refers to the sampling time at which continuous outer diameter changes caused by the same traction speed adjustment begin to reach the corresponding outer diameter detection station. When the traction speed after speed adjustment is greater than the traction speed before speed adjustment, the first group of three continuously decreasing outer diameter sampling records is searched within the candidate record interval. When the traction speed after speed adjustment is less than the traction speed before speed adjustment, the first group of three continuously increasing outer diameter sampling records is searched within the candidate record interval. The first record in each group of three records provides the response time of the corresponding outer diameter detection station. When there are two or more groups of upstream continuous change records that meet the conditions within the candidate record interval, the merging process of the current traction speed adjustment records ends, and the original outer diameter sampling records of the two outer diameter detection stations are retained.

[0070] The relationship between traction speed regulation and the direction of outer diameter change stems from material distribution during continuous extrusion. When the traction speed increases, the length of the guide tube being traction increases per unit time, and the amount of extruded material per unit length of guide tube decreases accordingly, resulting in a continuous decrease in the outer diameter sampling record. When the traction speed decreases, the amount of extruded material per unit length of guide tube increases, resulting in a continuous increase in the outer diameter sampling record. S102 directly checks the actual outer diameter sampling record within the candidate record interval corresponding to each outer diameter detection station. If no three corresponding continuous change records are formed after the candidate record interval ends, the current traction speed regulation record will not be included in subsequent coordinate calibration.

[0071] For example, three consecutive records can form two comparisons of adjacent outer diameter values, allowing for continuous verification of the direction of change. Using two records only allows for one direction comparison, making a single outer diameter fluctuation more likely to be selected as the response starting point. Using four to five records requires waiting for more sampling records to confirm the same direction of change, shifting the confirmation time accordingly. The response time is still taken from the first outer diameter sampling record in the selected consecutive records. The number of consecutive records can be verified by comparing the historical traction speed control records with the corresponding outer diameter sampling records. This embodiment uses three records to determine the response time.

[0072] After obtaining the response times at the two outer diameter detection stations, the timing relationship is then checked. Since the medical catheter moves from the upstream to the downstream outer diameter detection station, the response time of the downstream outer diameter detection station should be later than that of the upstream station. If the initially determined response time of the downstream outer diameter detection station does not conform to the above timing relationship, the next set of three continuously changing outer diameter sampling records is searched within the candidate record interval corresponding to the downstream outer diameter detection station, following the direction of increasing sampling time. The response time of the downstream outer diameter detection station is then re-determined based on the sampling time of the first record in the new set.

[0073] Then, step S103 is executed. The medical catheter segment collected at the upstream outer diameter detection station at the response time is transported to the downstream outer diameter detection station, forming the response time of the downstream outer diameter detection station. The two response times thus correspond to the same medical catheter segment. During processing, the catheter transport length in the records corresponding to the two response times is calibrated to the same catheter axial coordinate. The same catheter axial coordinate is a shared spatial starting point used by both outer diameter detection stations, used to place outer diameter sampling records under different sampling times and different length counting starting points into the same axial coordinate system.

[0074] For example, the axial coordinates of the conduit corresponding to two response times can both be marked as 0mm. 0mm is only used as the starting point of the coordinates. The outer diameter sampling records before the response time are arranged along the direction of decreasing coordinates, and the outer diameter sampling records after the response time are arranged along the direction of increasing coordinates. Even if the length counting starting points of the two outer diameter detection stations are different, the coordinate recursion can be completed by using the difference in conduit delivery length between adjacent outer diameter sampling records within each station.

[0075] In the specific conversion process, the outer diameter sampling records of each outer diameter detection station are first divided into records with sampling times earlier than, equal to, and later than the corresponding response time, according to the corresponding response time. For outer diameter sampling records with sampling times earlier than the corresponding response time, the processing is reversed from the response record according to the sampling time. For each record processed backward, the axial coordinate of the conduit with the decreasing value is determined based on the difference in conduit delivery length between adjacent records. This yields the conversion relationship before the response time.

[0076] For outer diameter sampling records where the sampling time is later than the corresponding response time, processing proceeds forward from the response record according to the sampling time. For each record processed forward, the axial coordinate of the conduit, whose value increases, is determined based on the difference in conduit delivery length between adjacent records, thus forming the transformation relationship after the response time. Records with a sampling time equal to the corresponding response time are directly assigned 0mm, while records earlier and later than the corresponding response time are assigned their respective transformation relationships.

[0077] The conversion relationship consists of the correspondence between the guide tube delivery length and the guide tube axial coordinate within the same outer diameter detection station. The conversion relationship before the response time is used to process records before the coordinate starting point, and the conversion relationship after the response time is used to process records after the coordinate starting point. After S103 outputs the guide tube axial coordinate corresponding to each outer diameter sampling record, the outer diameter sampling records formed by the two outer diameter detection stations with different sampling times and length counting starting points are normalized. S104 can continue to process the outer diameter value according to the guide tube axial coordinate.

[0078] After the conversion is completed, S104 begins to unify the spatial sampling positions of the two outer diameter detection stations. For example... Figure 3As shown, first, the axial coordinate segments of the guide tubes that have outer diameter sampling records after conversion at both outer diameter detection stations are selected. The starting point of the segment is the larger value of the smallest axial coordinate of the guide tube at the two outer diameter detection stations, and the ending point of the segment is the smaller value of the largest axial coordinate of the guide tube at the two outer diameter detection stations. The two boundaries constitute a common coordinate segment for two sets of outer diameter sampling records. The sampling period of the outer diameter detection equipment is read from the sampling configuration of the corresponding equipment; when adjacent outer diameter sampling records correspond to two consecutive sampling periods, the coordinate segment between the adjacent outer diameter sampling records is determined as the valid sampling segment; when there is no outer diameter sampling record between two sampling periods, the coordinate segment corresponding to the missing record is determined as the missing sampling segment. The intersection of the valid sampling segments of the two outer diameter detection stations forms a common valid coordinate segment, and the coordinates to be sampled are only generated within the common valid coordinate segment.

[0079] Starting from 0mm, sampling coordinates are generated in both decreasing and increasing directions according to the same axial coordinate interval. These sampling coordinates represent the axial position of the conduit from which the outer diameter value needs to be obtained after resampling. To determine the axial coordinate interval, adjacent outer diameter sampling records for each consecutive sampling period are obtained at each outer diameter detection station. The conduit delivery length difference between adjacent outer diameter sampling records is calculated and arranged according to its value. If the number of conduit delivery length differences is odd, the median value is taken; if the number is even, the average of the two median values ​​is taken. This yields the median conduit delivery length difference for each outer diameter detection station. The larger of the two median conduit delivery length differences is then used as the axial coordinate interval shared by both outer diameter detection stations. The conduit delivery length difference corresponding to a missed sampling section is not included in the determination of the median, nor is it used to generate sampling coordinates within that section. A large conduit delivery length difference resulting from a single missed sampling will not change the axial coordinate interval for the remaining common effective coordinate sections.

[0080] After the coordinates to be sampled are generated, coordinates with values ​​less than 0 mm are selected only from the outer diameter sampling records whose sampling time is earlier than the response time, while coordinates with values ​​greater than 0 mm are selected only from the outer diameter sampling records whose sampling time is later than the response time. 0 mm values ​​use the outer diameter value corresponding to the response time. The response time thus divides the resampling records into two sides, allowing the outer diameter values ​​on each side to continue using the coordinates formed by the corresponding transformation relationship.

[0081] When selecting the outer diameter value, the existing nearest neighbor resampling method can be used. If outer diameter sampling records exist on both sides of the coordinate to be sampled, the outer diameter sampling record with the smallest absolute value of the difference between the guide tube axial coordinate and the coordinate to be sampled is selected. If an outer diameter sampling record exists only on one side of the boundary of a common valid coordinate segment, the outer diameter sampling record with the smallest absolute value of the difference between the guide tube axial coordinate and the coordinate to be sampled is selected from the outer diameter sampling records on the corresponding side. If the absolute values ​​of the differences between the guide tube axial coordinate and the coordinate to be sampled are the same for two outer diameter sampling records and both are minimum values, the one with the smallest guide tube axial coordinate value is selected. No coordinates to be sampled are generated within the missing sampling segment, therefore the outer diameter sampling records on both sides of the missing sampling segment are not used to fill the missing positions. After selecting the results according to the guide tube axial coordinate, the two outer diameter detection stations each form a set of outer diameter sequences.

[0082] The resulting two sets of outer diameter sequences use the same axial coordinate interval and arrangement direction, and stop taking values ​​in the same missing sampling section. Each retained sampling coordinate corresponds to an outer diameter value in each of the two sets of outer diameter sequences. S105 can directly find the paired outer diameter values ​​of the two outer diameter detection stations by using the axial coordinate of the guide tube, without using the sampling time difference between the original records of the two outer diameter detection stations for pairing.

[0083] After the two sets of outer diameter sequences are formed, S105 first checks whether each set of outer diameter sequences has two consecutive outer diameter values ​​at 0mm and in the direction of increasing axial coordinate along the guide tube. If the candidate record interval corresponding to the two outer diameter detection stations has not yet ended, the current speed adjustment event that lacks an outer diameter value at 0mm or two consecutive outer diameter values ​​remains in a pending state; if three consecutive outer diameter values ​​starting from 0mm cannot be formed after the candidate record interval ends, the merging process of the current speed adjustment event ends and the original outer diameter sampling records of the two outer diameter detection stations are retained. If both sets of outer diameter sequences have three consecutive outer diameter values ​​starting from 0mm, the direction of change of the three outer diameter values ​​is then checked. During the process of increasing the traction speed, the three outer diameter values ​​in the two sets of outer diameter sequences need to decrease simultaneously and continuously. When decreasing the traction speed, the three outer diameter values ​​in the two sets of outer diameter sequences need to increase simultaneously and continuously. Only when the continuous changes in the upstream and downstream are respectively located in the candidate record intervals corresponding to the two outer diameter detection stations of the current speed regulation event, the downstream response time is later than the upstream response time, and the change direction verification of the three outer diameter values ​​passes, are the two response times considered as the response times corresponding to the same traction speed regulation.

[0084] If the direction of change of three adjacent outer diameter values ​​fails verification, the response time of the upstream outer diameter detection station is retained, and the next set of three continuously changing outer diameter sampling records is sequentially selected from the candidate record interval corresponding to the downstream outer diameter detection station. After re-determining the response time of the downstream outer diameter detection station, the same guide axial coordinate calibration, transformation relationship establishment, and resampling of the two sets of outer diameter sequences are performed again. After reprocessing, if the three adjacent outer diameter values ​​in the two sets of outer diameter sequences simultaneously increase or decrease continuously, the newly determined response time of the downstream outer diameter detection station is used to continue forming detection records.

[0085] If the candidate record interval corresponding to the downstream outer diameter detection station has not yet ended, the current speed regulation event remains in a pending state and continues to receive downstream outer diameter sampling records. If no further set of three continuously changing downstream outer diameter sampling records exists after the candidate record interval ends, the merging process corresponding to the current traction speed regulation record ends, and the original outer diameter sampling records of the two outer diameter detection stations are retained. The next traction speed regulation record will re-execute response time identification according to the candidate record intervals corresponding to the two outer diameter detection stations.

[0086] After verification, the outer diameter values ​​of the two outer diameter detection stations are paired according to the catheter's axial coordinate. The detection record is a data record indexed by a catheter's axial coordinate and simultaneously contains the outer diameter values ​​of both the upstream and downstream outer diameter detection stations. The two merged outer diameter values ​​point to the same medical catheter segment, thus providing the same spatial object for subsequent outer diameter comparisons.

[0087] The merging operation retains the source of each outer diameter measurement station corresponding to the two outer diameter values ​​and uses the catheter axial coordinate as a common index for both. When reading a measurement record, the outer diameter values ​​of the same medical catheter segment formed at both the upstream and downstream outer diameter measurement stations can be obtained simultaneously. Therefore, the purpose of data merging is to establish the correspondence between the same medical catheter segment and the two outer diameter values, providing consistent input for determining in S106 whether the two outer diameter values ​​are both greater than the upper limit or less than the lower limit of the outer diameter tolerance. The response time provides the temporal correspondence, and the catheter axial coordinate provides the spatial correspondence; the two results together complete the spatiotemporal alignment of the outer diameter values ​​at the two outer diameter measurement stations.

[0088] Finally, step S106 is executed. Inspection records are arranged in ascending order of the duct axial coordinates and then written sequentially to the quality inspection dataset. The quality inspection dataset is used to store inspection records that have undergone normalization and spatiotemporal alignment. For example, an existing relational database can be used to store the inspection records, with the duct axial coordinates as the index field. The write location is determined by the production line's data management configuration and does not change the fields or arrangement order of the inspection records.

[0089] Before writing to the quality inspection dataset, each inspection record can be assessed for outer diameter defects. The upper and lower limits of the outer diameter tolerance can be directly read from the product drawings, inspection procedures, or product technical documents for the corresponding specification of the medical catheter. For example, when the product document uses nominal outer diameter and permissible deviation to record the acceptable range, the upper limit of the outer diameter tolerance is the sum of the nominal outer diameter and the positive permissible deviation, and the lower limit of the outer diameter tolerance is the sum of the nominal outer diameter and the negative permissible deviation. Therefore, each type of medical catheter uses the range from the lower to the upper limit of the outer diameter tolerance already given in the corresponding product document.

[0090] The comparison results are categorized into four types. When both outer diameter values ​​are between the lower and upper limits of the outer diameter tolerance, both values ​​are retained without adding an outer diameter defect marker. When both outer diameter values ​​are greater than the upper limit or less than the lower limit, an outer diameter defect marker is added to the corresponding catheter axial coordinate. When only one outer diameter value is outside the range between the lower and upper limits, both values ​​are retained without adding an outer diameter defect marker. When one outer diameter value is greater than the upper limit and the other is less than the lower limit, both values ​​are retained without adding an outer diameter defect marker. When two outer diameter testing stations produce out-of-tolerance results in the same direction for the same medical catheter segment, an outer diameter defect marker is generated; otherwise, both outer diameter values ​​are retained.

[0091] After the outer diameter defect markers are generated, the inspection records with outer diameter defect markers are arranged according to the axial coordinates of the catheter. When the difference in the axial coordinates of adjacent inspection records is equal to the resampling axial coordinate interval, the adjacent inspection records are grouped into the same continuous coordinate interval. The continuous coordinate interval is a set of inspection records with outer diameter defect markers continuously along the catheter axis. The starting axial coordinate is the smallest axial coordinate of the catheter in the set, and the ending axial coordinate is the largest axial coordinate of the catheter in the set.

[0092] When a detection record without an outer diameter defect label appears between a current detection record with an outer diameter defect label and a previous detection record with an outer diameter defect label, the previous continuous coordinate interval ends at the corresponding position, and the current detection record becomes the starting point of the next continuous coordinate interval. The division of continuous coordinate intervals is directly determined by the resampling axial coordinate interval to determine the adjacency relationship, thus maintaining the same spatial scale as the outer diameter sequence formed by S104.

[0093] After dividing the continuous coordinate intervals, the starting and ending axial coordinates are written into the inspection records within the corresponding continuous coordinate intervals. Then, according to the order of the catheter axial coordinates, inspection records where both outer diameter values ​​are within the outer diameter tolerance range, inspection records where both outer diameter inspection stations are out of tolerance in the same direction, inspection records where only one outer diameter inspection station is out of tolerance, and inspection records where both outer diameter inspection stations are out of tolerance in opposite directions are all written into the quality inspection dataset. After processing, the quality inspection dataset saves the inspection records corresponding to the same medical catheter segment and locates continuous outer diameter defect segments using the starting and ending axial coordinates.

[0094] The following is a specific example. A traction speed adjustment record shows that the traction speed after adjustment is greater than the traction speed before adjustment. The upstream outer diameter detection station first shows three consecutive decreasing outer diameter sampling records, and the downstream outer diameter detection station subsequently shows an outer diameter change in the same direction. The sampling time of the first consecutive decreasing record at each of the two outer diameter detection stations is taken as the response time, and the conduit delivery length corresponding to the two response times is calibrated as 0mm.

[0095] After establishing a forward and backward conversion relationship based on 0mm, the outer diameter sampling records from both outer diameter detection stations obtain the axial coordinates of the guide tube. The processing generates the coordinates to be sampled from the common valid coordinate segment of the two outer diameter detection stations, and forms two sets of outer diameter sequences according to the same axial coordinate intervals. No coordinates are generated for missing sampling segments. After both sets of outer diameter sequences form three outer diameter values ​​continuously arranged from 0mm along the increasing direction of the guide tube's axial coordinate, a verification of the change direction of the three outer diameter values ​​is performed. If the first verification fails, the downstream outer diameter detection station sequentially selects the next set of three continuously decreasing records, re-determines the response time, and re-forms the downstream outer diameter sequence.

[0096] After the two newly formed outer diameter sequences are verified by the direction of change of three adjacent outer diameter values, the two outer diameter values ​​under the same axial coordinate of the conduit are written into the same inspection record. A normal record is formed when both outer diameter values ​​are between the lower and upper limits of the outer diameter tolerance; an outer diameter defect marker is added when both outer diameter values ​​exceed the upper limit or are both below the lower limit; when only one outer diameter value is outside the outer diameter tolerance range, both outer diameter values ​​are retained without adding an outer diameter defect marker; similarly, when one outer diameter value exceeds the upper limit and the other is below the lower limit, both outer diameter values ​​are retained without adding an outer diameter defect marker. When the difference between the axial coordinates of adjacent marked inspection records is continuously equal to the resampling axial coordinate interval, a continuous coordinate interval is formed. Finally, the corresponding starting axial coordinate, ending axial coordinate, and all inspection records are written into the quality inspection dataset.

[0097] The foregoing has provided a detailed description of a multi-source data alignment and access method based on coordinate calibration provided in this application. Specific examples have been used to illustrate the principles and implementation methods of this application. The descriptions of the embodiments above are merely for the purpose of helping to understand the method and its core ideas. It should be noted that those skilled in the art can make various improvements and modifications to this application without departing from its principles, and these improvements and modifications also fall within the protection scope of this application.

Claims

1. A method for aligning and accessing multi-source data based on coordinate calibration, characterized in that, include: Acquire outer diameter sampling records and traction speed regulation records at the upstream and downstream outer diameter detection stations of the medical catheter extrusion line. The outer diameter sampling records include the outer diameter value, sampling time, and catheter delivery length. From the outer diameter sampling records of the two outer diameter detection stations, determine the response times of the outer diameter change caused by the same traction speed adjustment to reach the two outer diameter detection stations respectively; The delivery length of the conduit corresponding to the two response times is calibrated to the same conduit axial coordinate, and the conversion relationship between the delivery length of the conduit and the conduit axial coordinate before and after the corresponding response time is established for each outer diameter detection station. Based on the relationship between the sampling time and the corresponding response time of each outer diameter sampling record, the corresponding transformation relationship is selected when the sampling time is earlier or later than the corresponding response time, and the same calibrated axial coordinate of the same catheter is used when the sampling time is equal to the corresponding response time to determine the axial coordinate of the catheter corresponding to each outer diameter sampling record. The outer diameter values ​​of the two outer diameter detection stations were resampled at the same axial coordinate interval to obtain two sets of outer diameter sequences with consistent coordinate intervals. Using the axial coordinate of the catheter as an index, the outer diameter values ​​of the same medical catheter segment in the two sets of outer diameter sequences are merged into a test record, and the test record is written into the quality test dataset.

2. The method according to claim 1, characterized in that, Determining the response times of the outer diameter change caused by the same traction speed adjustment reaching the two outer diameter detection stations from the outer diameter sampling records of the two outer diameter detection stations includes: Read the speed regulation time, traction speed before speed regulation, and traction speed after speed regulation from the traction speed regulation record; The outer diameter values ​​of each outer diameter testing station are arranged according to the sampling time. When the traction speed after speed adjustment is greater than the traction speed before speed adjustment, find the first set of three consecutively decreasing outer diameter sampling records from the outer diameter values ​​after the speed adjustment time; when the traction speed after speed adjustment is less than the traction speed before speed adjustment, find the first set of three consecutively increasing outer diameter sampling records from the outer diameter values ​​after the speed adjustment time. The sampling time of the first outer diameter sampling record among the three outer diameter sampling records is determined as the response time of the corresponding outer diameter detection station; When the response time of the downstream outer diameter detection station is not later than the response time of the upstream outer diameter detection station, the next set of three continuously decreasing or continuously increasing outer diameter sampling records in the downstream outer diameter detection station are selected in sequence, and the response time of the downstream outer diameter detection station is re-determined until the response time of the downstream outer diameter detection station is later than the response time of the upstream outer diameter detection station.

3. The method according to claim 2, characterized in that, The establishment of the transformation relationship includes: According to the corresponding response time, the outer diameter sampling records of each outer diameter detection station are divided into outer diameter sampling records with sampling times earlier than the corresponding response time, equal to the corresponding response time, and later than the corresponding response time; The catheter delivery length in the outer diameter sampling record at the sampling time is equal to the corresponding response time, and is correlated with the same catheter axial coordinate calibrated at the two response times; For outer diameter sampling records whose sampling time is earlier than the corresponding response time, the axial coordinates of the catheter with decreasing values ​​are determined sequentially according to the reverse order of sampling time and the difference in catheter delivery length between adjacent outer diameter sampling records. For outer diameter sampling records whose sampling time is later than the corresponding response time, the axial coordinates of the catheter with increasing values ​​are determined sequentially according to the forward order of sampling time and the difference in catheter delivery length between adjacent outer diameter sampling records. Based on the catheter delivery length and corresponding catheter axial coordinates in each outer diameter sampling record, the transformation relationship before and after the corresponding response time is formed respectively.

4. The method according to claim 3, characterized in that, The process of resampling the outer diameter values ​​of the two outer diameter detection stations according to the same axial coordinate interval to obtain two sets of outer diameter sequences with consistent coordinate intervals includes: Starting from the same axial coordinate of the conduit calibrated at two response times, generate the coordinates to be sampled in the direction of decreasing coordinates and the direction of increasing coordinates, respectively, according to the same axial coordinate interval; The sampling coordinates with values ​​less than the same catheter axial coordinate are matched with the outer diameter sampling records whose sampling time is earlier than the corresponding response time; the sampling coordinates with values ​​equal to the same catheter axial coordinate are matched with the outer diameter sampling records whose sampling time is equal to the corresponding response time; and the sampling coordinates with values ​​greater than the same catheter axial coordinate are matched with the outer diameter sampling records whose sampling time is later than the corresponding response time. For each sampling coordinate whose value is less than or greater than the same catheter axial coordinate, only the outer diameter value of the outer diameter sampling record with the smallest absolute value of the difference between the catheter axial coordinate and the sampling coordinate is selected from the outer diameter sampling records on the same side at the corresponding response time. The outer diameter value in the outer diameter sampling record whose sampling time is equal to the corresponding response time is taken as the outer diameter value corresponding to the sampling coordinate whose value is equal to the same catheter axial coordinate. The selected outer diameter values ​​are arranged according to the axial coordinate of the conduit to form an outer diameter sequence for two outer diameter testing stations.

5. The method according to claim 4, characterized in that, The process of merging the outer diameter values ​​of the same medical catheter segment from two sets of outer diameter sequences into a single detection record includes: Read the three outer diameter values ​​in each outer diameter sequence, which are consecutively arranged starting from the same axial coordinate of the catheter and along the direction of increasing axial coordinate of the catheter; When three adjacent outer diameter values ​​in two sets of outer diameter sequences do not increase or decrease simultaneously, the next set of three outer diameter sampling records that continuously decrease or increase are selected sequentially in the downstream outer diameter detection station to redetermine the response time of the downstream outer diameter detection station. Based on the redefined response time of the downstream outer diameter detection station, the conversion relationship and the outer diameter sequence of the two outer diameter detection stations are re-formed until three adjacent outer diameter values ​​in the two sets of outer diameter sequences increase or decrease simultaneously and continuously. After three adjacent outer diameter values ​​in two sets of outer diameter sequences increase or decrease simultaneously and continuously, the outer diameter values ​​of the two outer diameter detection stations are paired according to the axial coordinate of the conduit, and the paired outer diameter values ​​are merged into a detection record.

6. The method according to claim 4, characterized in that, The selection of the outer diameter value corresponding to the coordinate to be sampled includes: Find the outer diameter sampling record on the same side at the corresponding response time. When there are outer diameter sampling records on both sides of the coordinate to be sampled, select the outer diameter sampling record with the smallest absolute value of the difference between the axial coordinate of the catheter and the coordinate to be sampled. When there is an outer diameter sampling record on only one side, select the outer diameter sampling record with the smallest absolute value of the difference between the axial coordinate of the catheter and the coordinate to be sampled from the outer diameter sampling records on that side. When the absolute values ​​of the difference between the axial coordinate of the catheter and the coordinate to be sampled are the same for two outer diameter sampling records and both are the minimum values, select the one with the smallest axial coordinate value of the catheter among the two outer diameter sampling records, and use the outer diameter value in the selected outer diameter sampling record as the outer diameter value corresponding to the coordinate to be sampled.

7. The method according to claim 5, characterized in that, The process of merging the paired outer diameter values ​​into a detection record includes: Using the axial coordinate of each conduit as an index, the outer diameter values ​​of the paired upstream and downstream outer diameter detection stations are written into the same detection record.

8. The method according to claim 7, characterized in that, The step of writing the detection records into the quality detection dataset includes: The test records are arranged in ascending order of the axial coordinate of the conduit, and then written into the quality test dataset in sequence.

9. The method according to claim 8, characterized in that, The step of writing the detection records into the quality detection dataset includes: Before writing to the quality inspection dataset, the two outer diameter values ​​in each inspection record are compared with the upper limit and lower limit of the outer diameter tolerance, respectively. When both outer diameter values ​​are greater than the upper limit or less than the lower limit, an outer diameter defect label is added to the corresponding axial coordinate of the conduit. When the two outer diameter values ​​are not simultaneously greater than the upper limit and not simultaneously less than the lower limit, the two outer diameter values ​​are retained and no outer diameter defect label is added. The inspection record that completes the outer diameter defect judgment is then written to the quality inspection dataset.

10. The method according to claim 9, characterized in that, The step of writing the inspection record that completes the outer diameter defect judgment into the quality inspection dataset includes: The inspection records with outer diameter defect labels are arranged according to the axial coordinate of the conduit. Inspection records with adjacent axial coordinates and a coordinate interval equal to the resampled axial coordinate interval are grouped into the same continuous coordinate interval. The starting and ending axial coordinates of the continuous coordinate interval are written into the inspection records within the continuous coordinate interval. All inspection records that have completed the outer diameter defect judgment are written into the quality inspection dataset according to the order of the axial coordinates of the conduit.

Images