A traceability management system for dangerous chemical medicine transportation

Abstract

This application relates to the field of data processing system technology, specifically to a traceability management system for the transportation of hazardous chemicals and pharmaceuticals. The system includes a pre-transportation management module, a transportation management module, an acceptance feedback module, and a traceability query module. The transportation management module includes a trajectory completion unit, which clusters the historical transportation trajectories of the target transporter corresponding to the currently missing trajectory based on trajectory similarity. It determines the trajectory availability based on the number of historical transportation trajectories in each cluster, the number of historical missing points in each historical transportation trajectory, and road complexity. It then identifies matching trajectory points for the currently missing point in the historical transportation trajectories of each cluster, predicts the location and initial environmental values ​​of the currently missing point based on the location and environmental data of the matching trajectory points, and performs a weighted calculation on the location and initial environmental values ​​based on the trajectory availability to obtain the location and environmental data of the currently missing point. This application can effectively support the traceability of transportation trajectories.

Description

Technical Field

[0001] This application relates to the field of data processing system technology, specifically to a traceability management system for the transfer of hazardous chemicals and pharmaceuticals. Background Technology

[0002] Hazardous chemicals pose high risks during production, storage, and transportation. Leaks or accidents can cause serious casualties and environmental pollution. Currently, mainstream hazardous chemical transport traceability technologies rely on Internet of Things (IoT) identification and coding technology. This involves placing one-dimensional and two-dimensional barcodes on the surface of containers such as hazardous chemical cylinders, carrying basic information such as product serial numbers and filling unit codes for rapid scanning and data collection. Simultaneously, electronic tags are installed on containers or vehicles, enabling contactless, batch monitoring of cargo status, thus achieving monitorable and traceable hazardous chemical transport.

[0003] However, in actual transportation, hazardous chemicals undergo multiple transport routes from the producer to the receiver. When traversing complex environments (such as tunnels and densely populated high-rise areas), wireless signals are easily blocked or interfered with, leading to insufficient stability. This results in interruptions in the collection of critical data (such as real-time temperature control data and precise location data of the transport containers), resulting in data gaps. Existing intelligent hazardous chemical transport traceability management systems lack effective mechanisms to address this data gap. The missing data cannot be replenished, creating a data black hole in subsequent traceability processes. This leads to an incomplete traceability chain for the entire hazardous chemical transport process, failing to provide continuous and complete data support for traceability analysis and making it difficult to meet the accuracy and reliability requirements of hazardous chemical transport traceability. Summary of the Invention

[0004] This application provides a traceability management system for the transportation of hazardous chemicals and pharmaceuticals to address the problem that existing intelligent traceability management systems for hazardous chemicals lack an effective mechanism to deal with missing data, resulting in an incomplete traceability chain for the entire process of hazardous chemical transportation, failing to provide continuous and complete data support for traceability analysis, and making it difficult to meet the accuracy and reliability requirements of hazardous chemical transportation traceability.

[0005] The traceability management system for the transfer of hazardous chemicals and pharmaceuticals proposed in this application adopts the following technical solution: One embodiment of this application provides a traceability management system for the transportation of hazardous chemicals and pharmaceuticals, the system comprising: The pre-transportation management module is used to receive hazardous chemical demand information and generate a hazardous chemical list, and record the hazardous chemical demand information, hazardous chemical information and hazardous chemical operation information. The transfer management module is used to record transfer box information and transfer personnel information, and to collect the transfer box's transfer trajectory and environmental data in real time during the delivery process; The acceptance feedback module is used to record the handover information between the transferor and the receiver; The traceability query module is used to provide query services for hazardous chemical transfer information; The transfer management module further includes a trajectory completion unit, which is used to cluster the historical transfer trajectories of the target transferor corresponding to the current missing trajectory based on trajectory similarity; determine the trajectory availability based on the number of historical transfer trajectories in each cluster, the number of historical missing points in each historical transfer trajectory, and road complexity; determine the matching trajectory point of the current missing point in the current missing trajectory in the historical transfer trajectories of each cluster; predict the initial position value and initial environment value of the current missing point based on the position data of the matching trajectory point and the environmental data; and perform a weighted calculation on the initial position value and initial environment value based on the trajectory availability to obtain the position data and environmental data of the current missing point, so as to complete the current missing trajectory.

[0006] For example, the trajectory completion unit determines the trajectory similarity using the following method: using a preset time period as the time unit, calculating the average value of the trajectory coordinates in the historical transit trajectory within each time unit, recording the average value of the trajectory coordinates corresponding to each time unit as a feature trajectory data, and generating a feature trajectory data set corresponding to the historical transit trajectory; for any two historical transit trajectories, determining the feature trajectory data pairs in the corresponding two sets of feature trajectory data sets whose Euclidean distance is less than a preset threshold, recording them as similar feature trajectory data pairs, and obtaining a first number of similar feature trajectory data pairs; obtaining the number of feature trajectory data in any two historical transit trajectories respectively, and recording the larger value as a second number; calculating the Euclidean distance between the endpoints of any two historical transit trajectories, recording it as the endpoint distance; and determining the trajectory similarity between any two historical transit trajectories based on the endpoint distance, the first number, and the second number.

[0007] For example, the trajectory completion unit implements the clustering of the historical transfer trajectories of the target transferor corresponding to the current missing trajectory based on trajectory similarity through the following method: using the K-means clustering algorithm to cluster the historical transfer trajectories with the trajectory similarity as the clustering basis, and determining the number of clusters based on the silhouette coefficient method.

[0008] For example, the trajectory completion unit implements the determination of trajectory availability based on the number of historical transfer trajectories in each cluster, the number of historical missing points in each historical transfer trajectory, and road complexity through the following method: determining the ratio of the number of historical transfer trajectories in the cluster to the total number of historical transfer trajectories of the target transferor, denoted as cluster reference degree; extracting the historical missing points in each historical transfer trajectory in the cluster, obtaining the number of road types where the historical missing points are located and the preset type complexity of each road type; obtaining the maximum value among the preset type complexities of each road type, denoted as road complexity extreme value, and determining the road type complexity of the historical missing points based on the number of road types and the road complexity extreme value; determining the building density based on the distribution of buildings within the target range where the historical missing points are located, and determining the road complexity of the historical missing points based on the road type complexity and the building density; and determining the trajectory availability of the cluster based on the cluster reference degree and the road complexity of each historical missing point in each historical transfer trajectory.

[0009] For example, the trajectory completion unit implements the determination of the trajectory availability of the cluster based on the cluster reference degree and the road complexity of each historical missing point in each historical transit trajectory through the following method: for each historical transit trajectory in the cluster, determining the trajectory missing degree of the historical transit trajectory based on the number of historical missing points and the road complexity of each historical missing point; determining the cluster average missing degree of the cluster based on the number of historical transit trajectories in the cluster and the trajectory missing degree of each historical transit trajectory; and determining the trajectory availability based on the cluster reference degree and the cluster average missing degree.

[0010] For example, the trajectory completion unit implements the following method to determine the matching trajectory point of the current missing point in the current missing trajectory in the historical transit trajectories of each cluster, and predict the initial position value and initial environmental value of the current missing point based on the position data of the matching trajectory point and the environmental data, including: determining the trajectory point that is closest to the current missing point in time and position in the historical transit trajectories of each cluster, and denoting it as the matching trajectory point; and using the Kalman filter method to predict the initial position value and initial environmental value of the current missing point based on the position data of the matching trajectory point and the environmental data.

[0011] For example, the trajectory completion unit implements the weighted operation of the initial position value and the initial environment value based on the trajectory availability to obtain the location data and environment data of the current missing point in order to complete the current missing trajectory by the following method: using the trajectory availability of the cluster in which the historical transit trajectory is located as a weight, the initial position value and the initial environment value are weighted to obtain the location data and environment data of the current missing point in order to complete the current missing trajectory.

[0012] For example, the pre-transport management module further includes a smart barcode scanning device. The pre-transport management module scans the barcodes of hazardous chemicals using the smart barcode scanning device to verify the hazardous chemical list through the barcodes. After verification, the module records the hazardous chemical demand information, the hazardous chemical information, and the hazardous chemical operation information. The hazardous chemical demand information includes the prescription number, prescribing department, prescribing doctor, prescription time, and patient information. The hazardous chemical information includes the hazardous chemical code, hazardous chemical name, hazardous chemical specifications, and hazardous chemical dosage. The hazardous chemical operation information includes the operator's identification, operation time, and reviewer information.

[0013] For example, the transfer management module records the transfer box information including transfer box number, transfer box type, associated hazardous chemical list number, transfer box status, and hazardous chemical loading quantity; the environmental data is collected by multiple sensors built into the transfer box; the transfer trajectory is collected by vehicle radar and positioning chip built into the transfer box, the vehicle radar is used to locate the overall position of the hazardous chemical transfer vehicle, and the positioning chip is used to locate the position of the transfer box.

[0014] For example, the handover information recorded by the acceptance feedback module includes the handover time between the transferor and the receiver, confirmation records, and acceptance feedback information. The acceptance feedback information includes the appearance inspection results of the hazardous chemicals and the transfer container, as well as on-site feedback records. The confirmation records are in the form of signature records or barcode records, and the appearance inspection results include two states: intact or damaged.

[0015] The beneficial effects of the technical solution in this application are as follows: In the traceability management system for the transportation of hazardous chemicals and pharmaceuticals provided in this application, the pre-transport management module receives hazardous chemical demand information and generates a hazardous chemical list, recording hazardous chemical demand information, hazardous chemical information, and hazardous chemical operation information. This allows for the creation of a complete data archive based on real-time recording of all-dimensional information, providing authentic and verifiable source data for subsequent traceability and eliminating the risk of missing or tampered information. The transportation management module records transportation box information and transportation personnel information, and collects the transportation trajectory and environmental data of the transportation boxes in real time during delivery, thus clearly reconstructing the transportation path and environmental changes, meeting the basic requirements of monitorable and traceable transportation processes. Furthermore, when the transportation trajectory is missing, this application can also use the trajectory completion unit in the aforementioned transportation management module to... The system clusters historical trajectories of target transporters based on trajectory similarity, and determines the usability of trajectories by combining the number of trajectories in each cluster, the number of missing historical points, and road complexity. It then predicts initial values ​​by matching trajectory points and completes the data with weighted availability, ensuring that the final output of missing point location data and environmental data more closely reflects the actual transport situation. This effectively fills data gaps and provides continuous and complete data support for hazardous chemical transport traceability, meeting the accuracy and reliability requirements of hazardous chemical transport traceability. The acceptance feedback module records handover information between transporters and receivers, clarifying the responsibility at the end of the transport process. The traceability query module provides query services for hazardous chemical transport information, integrating data from all stages to form a full-process traceability chain, effectively ensuring the monitorability of the hazardous chemical transport process and the quality and safety of hazardous chemicals. Attached Figure Description

[0016] 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 only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0017] Figure 1 A structural block diagram of a traceability management system for the transfer of hazardous chemicals and pharmaceuticals provided in this application; Figure 2 The flowchart illustrates a method for completing missing trajectories using the trajectory completion unit of the transfer management module in a traceability management system for hazardous chemical and pharmaceutical transfer provided in this application. Detailed Implementation

[0018] To further illustrate the technical means and effects adopted by this application to achieve the intended purpose of the invention, the following, in conjunction with the accompanying drawings and preferred embodiments, details the specific implementation, structure, features, and effects of a traceability management system for the transfer of hazardous chemicals and pharmaceuticals proposed in this application. In the following description, different "one embodiment" or "another embodiment" do not necessarily refer to the same embodiment. Furthermore, specific features, structures, or characteristics in one or more embodiments can be combined in any suitable form.

[0019] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this application pertains.

[0020] The following description, in conjunction with the accompanying drawings, details the specific scheme of a traceability management system for the transfer of hazardous chemicals and pharmaceuticals provided in this application.

[0021] Please see Figure 1 This document illustrates a structural block diagram of a traceability management system for the transfer of hazardous chemicals and pharmaceuticals, provided in one embodiment of this application. The system includes a pre-transfer management module 110, a transfer management module 120, an acceptance feedback module 130, and a traceability query module 140; wherein: The pre-transportation management module is used to receive hazardous chemical demand information and generate a hazardous chemical list, and record hazardous chemical demand information, hazardous chemical information, and hazardous chemical operation information. The transfer management module is used to record transfer box information and transfer personnel information, and to collect the transfer box's transfer trajectory and environmental data in real time during the delivery process; The acceptance feedback module is used to record the handover information between the transferor and the receiver; The traceability query module is used to provide query services for hazardous chemical transfer information; The aforementioned transfer management module also includes a trajectory completion unit. This unit is used to cluster the historical transfer trajectories of the target transferor corresponding to the current missing trajectory based on trajectory similarity; determine the trajectory availability based on the number of historical transfer trajectories in each cluster, the number of historical missing points in each historical transfer trajectory, and road complexity; determine the matching trajectory point of the current missing point in the current missing trajectory from the historical transfer trajectories in each cluster; predict the initial location value and initial environmental value of the current missing point based on the location data and environmental data of the matching trajectory point; and perform a weighted calculation on the initial location value and initial environmental value based on the trajectory availability to obtain the location data and environmental data of the current missing point, so as to complete the current missing trajectory.

[0022] The functions of each module in the above-mentioned traceability management system for the transfer of hazardous chemicals and pharmaceuticals are described in detail below in one embodiment: The aforementioned pre-transportation management module is used to receive hazardous chemical demand information and generate a hazardous chemical list, and to record hazardous chemical demand information, hazardous chemical information, and hazardous chemical operation information.

[0023] In this embodiment of the application, the aforementioned pre-transportation management module is a functional module responsible for the information management and operation control of the entire process of hazardous chemical allocation. Its core function is to provide real and verifiable source data support for the subsequent transfer and traceability of hazardous chemicals by receiving hazardous chemical demand information, generating a hazardous chemical list, intelligently verifying hazardous chemicals, and recording information in all dimensions.

[0024] The aforementioned hazardous chemical demand information refers to demand-side information related to the source and destination of hazardous chemicals. For example, this hazardous chemical demand information specifically includes prescription number, prescribing department, prescribing doctor, prescription time, and patient information.

[0025] In this embodiment of the application, the aforementioned hazardous chemical information refers to attribute information related to the hazardous chemical to be dispensed. For example, this hazardous chemical information specifically includes information such as hazardous chemical code (a unique identifier for the hazardous chemical, used for accurate identification), hazardous chemical name (the standard name of the hazardous chemical), hazardous chemical specification (the dosage form and content specifications of the hazardous chemical), and hazardous chemical dosage (the dosage of the hazardous chemical used in the prescription, used to specify the dispensing quantity).

[0026] In this embodiment, the aforementioned hazardous chemicals list refers to a list file automatically generated by the pre-transportation management module based on the received hazardous chemicals demand information, used to guide actual operations. For example, this hazardous chemicals list specifically includes the types of hazardous chemicals to be allocated, the quantity of each type, and other information.

[0027] In this embodiment of the application, the aforementioned hazardous chemical operation information is management information used to record operational behaviors generated during the hazardous chemical preparation process. For example, this hazardous chemical operation information specifically includes operator identification (a unique code for the personnel performing the hazardous chemical preparation operation), operation time (the specific start and end times of the hazardous chemical preparation operation), reviewer information, and other information.

[0028] In this embodiment of the application, the pre-transportation management module also includes an intelligent barcode scanning device. This intelligent barcode scanning device is a hardware device used to collect hazardous chemical identification information. It can scan the barcodes on the packaging of hazardous chemicals (such as hazardous chemical traceability codes, commodity barcodes, etc.) to realize the automatic comparison between hazardous chemical demand information and the hazardous chemical list.

[0029] For example, the aforementioned pre-transport management module can achieve full-process information management and operational control of the hazardous chemical dispensing process by executing the following methods: Hazardous chemical demand information is automatically synchronized or entered into the pre-transport management module by staff; after receiving the hazardous chemical demand information, the pre-transport management module automatically parses the hazardous chemical information. Specifically, it can calculate the types of hazardous chemicals to be dispensed and the total quantity of each type based on the names and dosages of the hazardous chemicals prescribed in the prescription, generating a structured hazardous chemical list. This list clearly indicates the name, specifications, and quantity of each hazardous chemical. Furthermore, this embodiment can also include the corresponding prescription number in the hazardous chemical list to achieve the association between the prescription and the hazardous chemical list; when dispensing hazardous chemicals, the operator uses a smart barcode scanner to scan the barcodes on the packaging of each hazardous chemical to be dispensed, collecting information such as the hazardous chemical code, name, and specifications corresponding to the barcode, and automatically uploads the collected hazardous chemical information to the pre-transport management module. The pre-transport management module compares the hazardous chemical demand information obtained through scanning with a smart barcode scanner with the generated hazardous chemical list. If the comparison results match, a verification success message is displayed; if the comparison results do not match, a verification anomaly message is displayed with the reason for the anomaly (such as mismatched hazardous chemical names, excessive quantity, etc.), and the process is paused until the operator corrects the error and re-verifies. Once all hazardous chemicals have passed the barcode scanning verification, the pre-transport management module automatically triggers the information recording process, recording the hazardous chemical demand information, hazardous chemical information, and hazardous chemical operation information generated during the process and synchronizing them to the backend database in real time for subsequent retrieval, preventing information from being arbitrarily tampered with or deleted.

[0030] The aforementioned transfer management module is used to record transfer box information and transfer personnel information, and to collect transfer box transfer trajectory and environmental data in real time during the delivery process; and, through the trajectory completion unit, to cluster the historical transfer trajectories of the target transfer personnel corresponding to the current missing trajectory based on trajectory similarity; to determine the trajectory availability based on the number of historical transfer trajectories in each cluster, the number of historical missing points in each historical transfer trajectory, and road complexity; to determine the matching trajectory point of the current missing point in the current missing trajectory from the historical transfer trajectories of each cluster, to predict the initial position value and initial environmental value of the current missing point based on the location data and environmental data of the matching trajectory point, and to perform a weighted calculation on the initial position value and initial environmental value based on the trajectory availability to obtain the location data and environmental data of the current missing point, so as to complete the current missing trajectory.

[0031] In this embodiment, the aforementioned transfer management module is a functional module responsible for the full-process information management and key data collection of the hazardous chemical distribution process. Its core function is to record the association information between the transfer box and the transferor before delivery, and to collect the transfer trajectory and environmental data of the transfer box in real time through positioning and sensing devices during the delivery process. When the trajectory is missing, the data is completed by the trajectory completion unit, and all information is synchronously stored in the system's backend database, providing continuous and accurate transfer process data support for the monitoring and traceability of the hazardous chemical transfer process.

[0032] In this embodiment, the aforementioned transfer box is a dedicated container used to carry hazardous chemicals during the transfer process; the aforementioned transfer box information is structured data used to uniquely identify the transfer box, associate it with hazardous chemical tasks, and record its usage status. For example, the transfer box information specifically includes the transfer box number (a unique code to distinguish the transfer box and ensure traceability throughout the entire process), the transfer box type (a category based on hazardous chemical storage requirements, such as ambient temperature medicine boxes, refrigerated medicine boxes, etc., matching different storage standards for hazardous chemicals), the associated hazardous chemical list number (a unique code corresponding to the hazardous chemical list in the transfer box), the transfer box status (the current usage stage of the medicine box, such as waiting to be loaded, loaded with hazardous chemicals, in transit, returned, etc.), and the quantity of hazardous chemicals loaded (the total quantity of hazardous chemicals actually loaded in the transfer box), etc.

[0033] In this embodiment, the aforementioned transporter is the direct executor of the hazardous chemical transport task, bearing the responsibility for the physical transportation of hazardous chemicals from the producer to the receiver; the transporter information is management information used to identify the personnel performing the hazardous chemical transport task and clarify their transport responsibilities. For example, this transporter information specifically includes a transporter identification identifier (a code used to uniquely identify the transporter, bound to the system login account to ensure traceability of operations), the transporter's name, and contact information.

[0034] In this embodiment, the aforementioned transfer trajectory refers to the continuous positional change data of the transfer container during the delivery process. Exemplarily, this transfer trajectory can be collected using vehicle-mounted radar and a positioning chip built into the transfer container. The vehicle-mounted radar is used to locate the overall position of the hazardous materials transfer vehicle to obtain macroscopic positional information during vehicle movement. The positioning chip built into the transfer container is used to accurately locate the real-time position of the transfer container itself to avoid deviation between the vehicle's position and the container's position.

[0035] In this embodiment, the aforementioned environmental data refers to the monitoring data of the environment in which the transport container is located during transport. For example, this environmental data can be collected through multiple sensors (such as temperature sensors, humidity sensors, vibration sensors, etc.) built into the transport container. Specifically, the environmental data includes temperature control data (real-time temperature inside or around the transport container, especially important for refrigerated or cool-stored hazardous chemicals, requiring real-time monitoring to ensure compliance with storage standards), humidity data (relative humidity of the environment surrounding the transport container, to prevent a damp environment from affecting the stability of hazardous chemicals), and vibration data (frequency and amplitude of vibration experienced by the medicine box during transport, to prevent excessive vibration from causing damage to the packaging or deterioration of the components of hazardous chemicals). All data is accompanied by a collection timestamp to ensure that environmental changes can be traced chronologically.

[0036] For example, the aforementioned transfer management module can achieve full-process information management and key data collection for hazardous chemical distribution by executing the following methods: After the hazardous chemicals are checked and loaded into the transfer box, the transferor receives the transfer box and enters the transfer box information and transferor information through the transfer management module; the macroscopic location information of the transfer vehicle is obtained in real time through the vehicle-mounted radar, and the precise location information of the transfer box itself is obtained synchronously through the positioning chip built into the transfer box. The two types of location data are integrated, and a transfer trajectory coordinate sequence is constructed based on the collected location data and its collection time, and updated to the system in real time; the environmental parameters are monitored in real time at a preset frequency by the multiple sensors built into the transfer box. Specifically, the temperature sensor collects the temperature around and inside the transfer box, the humidity sensor collects the ambient humidity of the transfer box, and the vibration sensor collects the vibration amplitude and frequency. The collected environmental data is uploaded to the transfer management module in real time. The system performs preliminary verification of the environmental data, and records the data after the verification is passed.

[0037] Because hazardous chemicals typically undergo multiple complex environmental processes during transport before reaching their destination—for example, when transport vehicles pass through tunnels or other complex areas, signal instability can cause data loss during transport, resulting in data gaps in subsequent traceability processes and preventing the formation of a complete traceability chain—the aforementioned trajectory completion unit performs data completion on the missing trajectory using the following method. Specifically, as follows... Figure 2 As shown, the method may include the following steps: In step S210, the historical transfer trajectories of the target transferor corresponding to the current missing trajectory are clustered based on trajectory similarity.

[0038] In this embodiment of the application, the aforementioned missing trajectory is the transfer trajectory collected by the vehicle radar and the positioning chip built into the transfer box during the current transfer of hazardous chemicals. Due to the presence of complex environments with unstable signals in the current transfer route (such as tunnels, densely built-up areas, etc.), and the absence of location data or environmental data in the transfer trajectory, it is necessary to complete the data in subsequent processing.

[0039] In this embodiment of the application, the target transporter is the transporter who is performing the current hazardous chemical transport process corresponding to the current missing trajectory; the historical transport trajectory of the target transporter is the transport trajectory data of the hazardous chemical transport tasks previously performed by the target transporter.

[0040] In this embodiment of the application, the aforementioned trajectory similarity is a quantitative indicator used to measure the similarity between two historical transfer trajectories of the target transferor.

[0041] For example, the trajectory completion unit can determine trajectory similarity using the following method: using a preset duration as the time unit, calculate the average value of trajectory coordinates in historical transit trajectories within each time unit, record the average value of trajectory coordinates corresponding to each time unit as a feature trajectory data, and generate a feature trajectory data set corresponding to the historical transit trajectories; for any two historical transit trajectories, determine the feature trajectory data pairs in the corresponding two sets of feature trajectory data where the Euclidean distance is less than a preset threshold, record them as similar feature trajectory data pairs, and obtain the first number of similar feature trajectory data pairs; obtain the number of feature trajectory data in any two historical transit trajectories respectively, and record the larger value as the second number; calculate the Euclidean distance between the endpoints of any two historical transit trajectories, and record it as the endpoint distance; determine the trajectory similarity between any two historical transit trajectories based on the endpoint distance, the first number, and the second number.

[0042] In one specific implementation of this application embodiment, the process of determining trajectory similarity described above can be implemented as follows: The target transporter corresponding to the currently missing trajectory is selected from the system's backend database. Assuming the target transporter is the m-th transporter, all historical transport trajectory data of the m-th transporter are retrieved. Each historical trajectory contains a complete sequence of location coordinates, a collection timestamp, and other basic information. For each historical transport trajectory of the m-th transporter, the historical transport trajectory is divided into multiple time intervals with a time unit of 1 minute. The average value of all trajectory coordinates within each time interval (each 1 minute) is calculated, and this average value is recorded as the feature trajectory data of the corresponding time interval. The set of all feature trajectory data is recorded as the feature trajectory data set of the corresponding historical transport trajectory. Assuming a certain historical transport trajectory is divided into n time intervals, the feature trajectory data set corresponding to this historical transport trajectory can be represented as {feature trajectory data 1, feature trajectory data 2, ..., feature trajectory data n}. For the target... For any two historical transfer trajectories (taking the p-th historical transfer trajectory and the q-th historical transfer trajectory as an example), iterate through all feature trajectory data in the p-th historical transfer trajectory, calculate the Euclidean distance between the current feature trajectory data and all feature trajectory data in the q-th historical transfer trajectory, and perform normalization processing. If the normalized Euclidean distance is less than 0.3 (the above preset threshold is 0.3 in this specific implementation), record the corresponding feature trajectory data pair as a similar feature trajectory data pair between the p-th and q-th historical transfer trajectories, and count the number of similar feature trajectory data pairs (i.e., the first number mentioned above); count the number of feature trajectory data in the p-th and q-th historical transfer trajectories, and record the larger value as the second number; calculate the Euclidean distance between the endpoint positions of the p-th and q-th historical transfer trajectories, and record it as the endpoint distance; calculate the trajectory similarity between the p-th and q-th historical transfer trajectories using the following formula: in, The preset distance attenuation coefficient is used to eliminate the dimensional influence of Euclidean distance. In specific implementation, considering the distance scale of urban transportation, the value range of this parameter can be set to 0.001~0.01. In this embodiment, it is preferably 0.005. As an exponential function with the natural constant as the base, this embodiment effectively eliminates the dimensional influence of Euclidean distance through the exponential function; Let p be the trajectory similarity between the p-th and q-th historical transfer trajectories of the m-th transferor; Let be the coordinates of the endpoint of the p-th historical transit trajectory; Let be the coordinates of the endpoint of the q-th historical transit trajectory; Let be the Euclidean distance between the endpoint coordinates of the p-th historical transit trajectory and the q-th historical transit trajectory. The smaller the value, the more consistent the destinations of the p-th and q-th historical transit trajectories are, and the higher the trajectory similarity. The number of similar feature trajectory data pairs between the p-th historical transit trajectory and the q-th historical transit trajectory (i.e., the first number mentioned above) is the largest value. The larger the value, the higher the degree of overlap between the corresponding paths of the p-th historical transit trajectory and the q-th historical transit trajectory, and the higher the trajectory similarity. Let be the number of feature data points in the p-th historical transit trajectory; Let q be the number of feature data points in the q-th historical transit trajectory; The second number is the larger of the number of feature trajectory data in the p-th historical transfer trajectory and the q-th historical transfer trajectory (i.e., the aforementioned second number). This second number is used to... Normalization ( ), to avoid the problem caused by a large number of features on a certain trajectory. An overestimation.

[0043] After determining the pairwise trajectory similarity between all historical transfer trajectories corresponding to the target transferor using the above method, the trajectory completion unit can, for example, cluster the historical transfer trajectories of the target transferor corresponding to the current missing trajectory based on trajectory similarity using the following method: use the K-means clustering algorithm to cluster the historical transfer trajectories based on trajectory similarity, and determine the number of clusters based on the silhouette coefficient method.

[0044] In one specific implementation of this application embodiment, the above clustering process can be implemented as follows: using trajectory similarity as the basis for dividing clusters, the optimal number of clusters is determined by the silhouette coefficient method. The implementation principle of the silhouette coefficient method is as follows: multiple possible cluster numbers are preset, k-means clustering is performed on each preset cluster number, the silhouette coefficient of all trajectories is calculated, and the cluster number corresponding to the silhouette coefficient closest to 1 is selected as the final number of clusters R; based on the k-means algorithm, the entire historical transfer trajectory of the target transferor is divided into R clusters based on trajectory similarity, and the trajectory similarity values ​​between historical transfer trajectories in the same cluster are relatively large.

[0045] In step S220, the availability of a trajectory is determined based on the number of historical transit trajectories in each cluster, the number of historical missing points in each historical transit trajectory, and the road complexity.

[0046] In this embodiment of the application, the aforementioned historical missing points refer to the locations and environmental data missing points in the target transporter's historical transport trajectory where the system could not collect data normally due to complex environments with unstable signals, such as tunnels and densely populated high-rise buildings.

[0047] In this embodiment of the application, the road complexity mentioned above is an indicator used to measure the complexity of the environment surrounding the historical missing point; the larger the value, the more complex the environment of the historical missing point is and the more unstable the environmental signal is.

[0048] In this embodiment of the application, the availability of the above-mentioned trajectory is used to measure the overall reference value of the historical transit trajectories in the corresponding cluster when data is subsequently completed for the current missing trajectory; the larger the value, the stronger the reference significance of the historical transit trajectories in the cluster when all current missing trajectories are present.

[0049] For example, the trajectory completion unit described above can determine the availability of a trajectory based on the number of historical transfer trajectories in each cluster, the number of historical missing points in each historical transfer trajectory, and road complexity using the following methods: Determine the ratio of the number of historical transfer trajectories in a cluster to the total number of historical transfer trajectories of the target transferor, denoted as the cluster reference degree; extract historical missing points from each historical transfer trajectory in the cluster, obtain the number of road types where the historical missing points are located, and the preset type complexity of each road type; calculate the average preset type complexity of each road type, denoted as the road complexity mean, and determine the road type complexity of the historical missing points based on the number of road types and the road complexity mean; determine the building density based on the distribution of buildings within the target area where the historical missing points are located, and determine the road complexity of the historical missing points based on the road type complexity and building density; determine the trajectory availability of the cluster based on the cluster reference degree and the road complexity of each historical missing point in each historical transfer trajectory.

[0050] In one specific implementation of this application embodiment, the determination of the availability of cluster trajectories can be achieved as follows: for each cluster obtained by clustering in step S220 (taking the r-th cluster out of R clusters as an example), the number of historical transit trajectories within the r-th cluster is obtained. and the total number of historical transit trajectories for the m-th transit officer (target transit officer). ,Will The cluster reference degree of the r-th cluster is denoted as the cluster reference degree. For the x-th historical transfer trajectory in the r-th cluster of the m-th transferer, the original record of the historical transfer trajectory (the original transfer trajectory before completion) is retrieved from the system database to determine the historical missing points in the historical transfer trajectory and the road basic information of the preset surrounding range of the location of each historical missing point. For example, the aforementioned preset surrounding area can be a 500-meter radius around the historical missing point. The aforementioned road basic information can include road type, preset type complexity corresponding to each road type, and building density. The aforementioned road type can include highways, tunnels, etc. The preset type complexity corresponding to the aforementioned road type is a value pre-set based on the degree of interference of the road environment to the signal, and is positively correlated with the degree of interference of the road environment to the signal. For example, tunnels or dense urban environments have a higher degree of interference to the signal, so a higher value is set for their preset type complexity, while open highways have a lower degree of interference to the signal, so a lower value is set for their preset type complexity. The aforementioned building density is used to characterize the density of building distribution within the preset surrounding area. For example, the normalized value of the weighted product of the number of surrounding buildings and their average height can be quantified as building density. The larger the number of buildings and the higher the height, the higher the corresponding building density. Taking the t-th historical missing point in the x-th historical transit trajectory as an example, the road type complexity of the t-th historical missing point is calculated using the following formula: in, For the t-th historical missing point, the maximum value of the preset type complexity corresponding to all road types included in the surrounding range is used to anchor the lower limit of the signal range of that area. The preset road switching penalty coefficient is set to 0.2 in this embodiment; Let be the road type complexity of the t-th historical missing point; Preset the number of road types included in the surrounding area of ​​the t-th historical missing point (e.g., the surrounding area of ​​the t-th historical missing point includes both open roads and tunnels). 2) The larger the value, the more frequently the road environment changes within the preset range of the t-th historical missing point; For the normalization function, specifically, this embodiment uses the max-min normalization method to map the calculation result to the interval [0,1]. To introduce a nonlinear environment variability penalty term, combined with the maximum value This reflects that the more complex the road types, the higher the peak probability of signal fluctuations and interference.

[0051] After determining the road type complexity of the t-th missing history point, the road complexity of the t-th missing history point is determined using the following formula: in, Let be the road complexity of the t-th historical missing point; Let t be the road type complexity of the t-th historical missing point, reflecting the complexity of the road itself. The larger the value, the more the transportation process passes through roads with poor signal, such as tunnels or dense branch roads. Let be the building density of the t-th historical missing point, reflecting the degree of signal obstruction and interference from buildings. The larger the value, the more high-rise buildings there are in the environment of the t-th historical missing point, and the stronger the signal obstruction. This is the normalization function.

[0052] After determining the cluster reference degree of each cluster and the road complexity of each historical missing point of all historical transit trajectories in each cluster through the above steps, the trajectory completion unit can, for example, determine the trajectory availability of a cluster based on the cluster reference degree and the road complexity of each historical missing point in each historical transit trajectory using the following method: for each historical transit trajectory in the cluster, determine the trajectory missing degree of the historical transit trajectory based on the number of historical missing points and the road complexity of each historical missing point; determine the average cluster missing degree of the cluster based on the number of historical transit trajectories in the cluster and the trajectory missing degree of each historical transit trajectory; and determine the trajectory availability based on the cluster reference degree and the average cluster missing degree of the cluster.

[0053] In one specific implementation of this application, taking the x-th historical transfer trajectory in the r-th cluster of the m-th transferor as an example, the trajectory missing degree can be determined by the following formula: in, The trajectory missingness is the trajectory of the x-th historical transit trajectory in the r-th cluster of the m-th transit operator; Let x be the number of missing historical points in the x-th historical transit trajectory; Let t be the road complexity of the t-th historical missing point of the x-th historical transfer trajectory in the r-th cluster of the m-th transferor; The above formula integrates the road complexity of multiple historical missing points by calculating the average of all historical missing points in the x-th historical transit trajectory, avoiding the excessive influence of extreme values ​​of individual road complexity. It also quantifies the severity of the missing points in the x-th historical transit trajectory by calculating the normalized value of the product of the average road complexity and the logarithmic penalty term of the total number of historical missing points. The logarithmic function is used to reasonably amplify the nonlinear impact of the number of missing points on the overall trajectory missingness. The larger the value, the more severe the data loss of the x-th historical transit trajectory in the r-th cluster of the m-th transit operator.

[0054] Furthermore, the availability of the transit trajectory in the r-th cluster for the m-th transit operator can be specifically calculated using the following formula: in, The availability of the transfer trajectory in the r-th cluster for the m-th transferor; The higher the value of the r-th cluster, the more likely the historical transit trajectory of the r-th cluster is to be the common path of the m-th transit operator. The higher the reference value of the historical transit trajectory of the r-th cluster is when the current missing trajectory is filled in with data. The trajectory missingness is the trajectory of the x-th historical transit trajectory in the r-th cluster of the m-th transit operator; By integrating the trajectory missing values ​​of multiple historical transit trajectories by calculating the average trajectory missing value of each historical transit trajectory within the r-th cluster, the excessive influence of extreme values ​​of individual trajectory missing values ​​on the results is avoided; the formula uses... The negative cluster average trajectory missingness is transformed into a positive cluster average completeness. The availability of transit trajectories in the r-th cluster is quantified by calculating the product of this cluster average completeness and the cluster reference degree. The lower the trajectory missingness, the higher the proportion of trajectories within the cluster, and the higher the final trajectory availability. The larger the value, the higher the weight assigned to the historical transit trajectories of the r-th cluster in subsequent data completion of the current missing trajectory.

[0055] In step S230, the matching trajectory point of the current missing point in the current missing trajectory is determined in the historical transfer trajectory of each cluster. The initial position value and initial environment value of the current missing point are predicted based on the position data and environmental data of the matching trajectory point. The initial position value and initial environment value are weighted based on the availability of the trajectory to obtain the position data and environmental data of the current missing point, so as to complete the current missing trajectory.

[0056] In this embodiment, the aforementioned "current missing point" refers to the missing data point in the current missing trajectory that needs to be completed; the aforementioned "matching trajectory point" refers to the data points selected from the historical transit trajectories of each cluster that are close to the current missing point in terms of time and location. For example, assuming the current missing point is a data point missing at a latitude and longitude position at 14:05, then data points in the historical transit trajectory whose collection time is within the range of 14:03-14:07 and whose location is close to the current missing point are selected.

[0057] For example, the trajectory completion unit described above can determine the matching trajectory point of the current missing point in the current missing trajectory from the historical transit trajectories of each cluster, and predict the initial position and initial environment values ​​of the current missing point based on the location data and environmental data of the matching trajectory point: determine the trajectory point that is closest to the current missing point in time and location from the historical transit trajectories of each cluster, and record it as the matching trajectory point; use the Kalman filter method to predict the initial position and initial environment values ​​of the current missing point based on the location data and environmental data of the matching trajectory point; wherein, the implementation principle of predicting the initial position and initial environmental values ​​of the current missing point using the Kalman filter method is the same as the prior art, so it will not be described again here.

[0058] After obtaining the initial value through the Kalman filter method, the trajectory completion unit can, for example, perform a weighted operation on the initial location value and the initial environment value based on the availability of the trajectory to obtain the location data and environmental data of the current missing point, so as to complete the current missing trajectory: the availability of the trajectory of the cluster in which the historical transit trajectory is located is used as the weight to perform a weighted operation on the initial location value and the initial environment value to obtain the location data and environmental data of the current missing point, so as to complete the current missing trajectory.

[0059] In this embodiment of the application, after filling the missing segments of the current missing trajectory with the final location data and environmental data of all the current missing points in the order of timestamps to form a complete transfer trajectory, the completed trajectory also needs to be synchronized to the system backend database and associated with the transfer box information, transfer personnel information and handover information in the corresponding current transfer task to provide continuous and complete data support for the subsequent traceability and query module.

[0060] The aforementioned acceptance feedback module is used to record the handover information between the transshipment personnel and the receiving personnel.

[0061] In this embodiment of the application, the aforementioned acceptance feedback module is a functional module responsible for recording key information during the handover process at the end of the hazardous chemical transfer (when the transferor and the receiving department hand over the goods). Its core function is to form a closed loop of responsibility at the end of the transfer and provide data support for the handover process for subsequent traceability.

[0062] In this embodiment of the application, the aforementioned receiver refers to the staff member of the receiving department responsible for receiving hazardous chemicals (such as the nurse of the receiving department). The receiver needs to confirm the status of the hazardous chemicals and the transfer box and complete the handover confirmation operation.

[0063] In this embodiment, the aforementioned handover information refers to the comprehensive data recorded by the acceptance feedback module during the handover process. For example, this handover information may specifically include handover time, confirmation records, and acceptance feedback information. Specifically, the handover time refers to the exact time when the transporter and the receiving department nurse complete the handover of the hazardous chemicals and transport boxes; the confirmation record refers to the confirmation document issued by the transporter and the receiving department nurse regarding the handover, proving that both parties acknowledge the handover process and result, and the confirmation can be in the form of a signed record or a QR code record; the acceptance feedback information includes the visual inspection results of the hazardous chemicals and transport boxes, as well as on-site feedback records. The visual inspection results include two states: intact or damaged. The on-site feedback records are descriptions of problems confirmed on-site by the transporter and the receiver (such as the hazardous chemical packaging box being crushed or deformed, or the transport box lock being damaged).

[0064] For example, the above-mentioned acceptance feedback module can manage the handover process by executing the following method: After the transporter arrives at the receiving department, he / she carries the transport box and initiates a hazardous chemical handover request to the receiving department. The handover time is automatically obtained and recorded and associated with the transporter's identity and name recorded by the previous transport management module. The receiving department enters the identity, name and department. Both parties form a confirmation record through electronic signature or QR code scanning. The nurse of the receiving department leads the inspection of the appearance of the hazardous chemicals and the transport box. If there is any damage, the location of the damage should be noted. If there is a problem, the problem description should be entered on the spot. If there is no problem, it should be recorded as no abnormality. After all the handover information is confirmed to be correct, the handover information is uploaded to the system backend database.

[0065] The aforementioned traceability query module is used to provide query services for hazardous chemical transfer information.

[0066] In this embodiment, the traceability query module is a functional module to improve the query service. It can integrate the full-process data of the pre-transportation management, transfer management, and acceptance feedback modules, and can output complete traceability results of hazardous chemical transfer for users.

[0067] In this embodiment of the application, the aforementioned hazardous chemical transfer information refers to all key data generated throughout the entire process of hazardous chemicals from production to acceptance. Specifically, it may include hazardous chemical demand information, hazardous chemical information; transfer container information, transferor information, transfer trajectory, and environmental data in the transfer process; and handover time, visual inspection results, and problem records in the handover process.

[0068] For example, the traceability query module described above can provide query services by performing the following methods: After logging into the system and passing the permission verification, users can enter the module interface and select query dimensions (or combinations of dimensions) such as prescription number, transport box number, transporter's identity, receiving department, and patient's identity to perform the query; The acceptance feedback module retrieves the full-process data from the backend database, automatically verifies the data integrity, and then displays it to the user.

[0069] It should be noted that the above description is only a preferred embodiment of this application and is not intended to limit this application. Any modifications, equivalent substitutions, improvements, etc., made within the principles of this application should be included within the protection scope of this application.

Claims

1. A traceability management system for the transfer of hazardous chemicals and pharmaceuticals, characterized in that, The system includes: The pre-transportation management module is used to receive hazardous chemical demand information and generate a hazardous chemical list, and record the hazardous chemical demand information, hazardous chemical information and hazardous chemical operation information. The transfer management module is used to record transfer box information and transfer personnel information, and to collect the transfer box's transfer trajectory and environmental data in real time during the delivery process; The acceptance feedback module is used to record the handover information between the transferor and the receiver; The traceability query module is used to provide query services for hazardous chemical transfer information; The transfer management module further includes a trajectory completion unit, which is used to cluster the historical transfer trajectories of the target transferor corresponding to the current missing trajectory based on trajectory similarity; determine the trajectory availability based on the number of historical transfer trajectories in each cluster, the number of historical missing points in each historical transfer trajectory, and road complexity; determine the matching trajectory point of the current missing point in the current missing trajectory in the historical transfer trajectories of each cluster; predict the initial position value and initial environment value of the current missing point based on the position data of the matching trajectory point and the environmental data; and perform a weighted calculation on the initial position value and initial environment value based on the trajectory availability to obtain the position data and environmental data of the current missing point, so as to complete the current missing trajectory.

2. The traceability management system for the transfer of hazardous chemicals and pharmaceuticals according to claim 1, characterized in that, The trajectory completion unit determines the trajectory similarity using the following methods: Using a preset duration as the time unit, calculate the average value of the trajectory coordinates in the historical transfer trajectory within each time unit, record the average value of the trajectory coordinates corresponding to each time unit as a feature trajectory data, and generate a feature trajectory data set corresponding to the historical transfer trajectory. For any two historical transit trajectories, identify the feature trajectory data pairs in the corresponding two sets of feature trajectory data sets whose Euclidean distance is less than a preset threshold, and record them as similar feature trajectory data pairs, and obtain the first number of similar feature trajectory data pairs; The number of characteristic trajectory data in any two historical transit trajectories is obtained respectively, and the larger value is recorded as the second number; Calculate the Euclidean distance between the endpoints of any two historical transit trajectories, and denot it as the endpoint distance; The trajectory similarity between any two historical transit trajectories is determined based on the destination distance, the first number, and the second number.

3. The traceability management system for the transfer of hazardous chemicals and pharmaceuticals according to claim 2, characterized in that, The trajectory completion unit implements the clustering of historical transport trajectories of the target transporter corresponding to the current missing trajectory based on trajectory similarity using the following methods: The historical transit trajectories are clustered using the K-means clustering algorithm based on trajectory similarity, and the number of clusters is determined based on the silhouette coefficient method.

4. The traceability management system for the transfer of hazardous chemicals and pharmaceuticals according to claim 1, characterized in that, The trajectory completion unit determines the usability of a trajectory based on the number of historical transit trajectories in each cluster, the number of historical missing points in each historical transit trajectory, and road complexity using the following methods: The ratio of the number of historical transfer trajectories in the cluster to the total number of historical transfer trajectories of the target transferor is determined and denoted as the cluster reference degree. Extract the historical missing points from each historical transit trajectory in the cluster, and obtain the number of road types where the historical missing points are located and the preset type complexity of each road type; Obtain the maximum value among the preset type complexities of each road type, and record it as the road complexity extreme value. Then, determine the road type complexity of the historical missing point based on the number of road types and the road complexity extreme value. The building density is determined based on the distribution of buildings within the target area where the historical missing point is located, and the road complexity of the historical missing point is determined based on the road type complexity and the building density. The availability of the trajectory of the cluster is determined based on the cluster reference degree and the road complexity of each historical missing point in each historical transit trajectory.

5. A traceability management system for the transfer of hazardous chemicals and pharmaceuticals according to claim 4, characterized in that, The trajectory completion unit determines the trajectory availability of the cluster based on the road complexity of each missing historical point in each historical transit trajectory using the following method: For each historical transit trajectory in the cluster, the trajectory missing degree of the historical transit trajectory is determined based on the number of historical missing points and the road complexity of each historical missing point; The average cluster missing degree of the cluster is determined based on the number of historical transit trajectories in the cluster and the trajectory missing degree of each historical transit trajectory. The availability of the trajectory is determined based on the cluster reference degree and the average cluster missing degree of the clusters.

6. The traceability management system for the transfer of hazardous chemicals and pharmaceuticals according to claim 1, characterized in that, The trajectory completion unit determines the matching trajectory point of the currently missing point in the historical transit trajectories of each cluster by means of the following method, and predicts the initial position value and initial environmental value of the currently missing point based on the position data of the matching trajectory point and the environmental data, including: In the historical transit trajectories of each cluster, the trajectory point that is closest to the current missing point in terms of time and location is determined and denoted as the matching trajectory point; The Kalman filter method is used to predict the initial position value and the initial environmental value of the current missing point based on the position data and the environmental data of the matched trajectory points.

7. A traceability management system for the transfer of hazardous chemicals and pharmaceuticals according to claim 6, characterized in that, The trajectory completion unit performs a weighted calculation on the initial position value and the initial environment value based on the availability of the trajectory to obtain the position data and environment data of the current missing point, so as to complete the current missing trajectory, including: Using the availability of the historical transit trajectory as a weight, the initial location value and the initial environment value are weighted and calculated to obtain the location data and environment data of the current missing point, so as to complete the current missing trajectory.

8. The traceability management system for the transfer of hazardous chemicals and pharmaceuticals according to claim 1, characterized in that, The pre-transportation management module also includes a smart barcode scanner. This module scans the barcodes of hazardous chemicals using the smart barcode scanner to verify the hazardous chemical list. After verification, it records the hazardous chemical demand information, the hazardous chemical information, and the hazardous chemical operation information. The hazardous chemical demand information includes the prescription number, prescribing department, prescribing doctor, prescription time, and patient information. The hazardous chemical information includes the hazardous chemical code, hazardous chemical name, hazardous chemical specifications, and hazardous chemical dosage. The hazardous chemical operation information includes the operator's identification, operation time, and reviewer information.

9. A traceability management system for the transfer of hazardous chemicals and pharmaceuticals according to claim 1, characterized in that, The information recorded by the transfer management module includes the transfer box number, transfer box type, associated hazardous chemical list number, transfer box status, and quantity of hazardous chemicals loaded. The environmental data is collected by multiple sensors built into the transfer box. The transfer trajectory is collected by vehicle-mounted radar and the positioning chip built into the transfer box. The vehicle-mounted radar is used to locate the overall position of the hazardous chemical transfer vehicle, and the positioning chip is used to locate the position of the transfer box.

10. A traceability management system for the transfer of hazardous chemicals and pharmaceuticals according to claim 1, characterized in that, The handover information recorded by the acceptance feedback module includes the handover time between the transferor and the receiver, confirmation records, and acceptance feedback information. The acceptance feedback information includes the appearance inspection results of the hazardous chemicals and the transfer container, as well as on-site feedback records. The confirmation records are in the form of signature records or barcode records. The appearance inspection results include two states: intact or damaged.

Images