Intelligent archiving and scheduling system for sports equipment logistics data of smart stadium

Abstract

The application belongs to the technical field of sports event operation and logistics data management, and specifically discloses an intelligent archiving and scheduling system for sports equipment logistics data of a smart stadium, which comprises the following steps: collecting equipment identification, real-time coordinates and three-axis acceleration peak values through an edge device, and adaptively fragmenting and transmitting the data to a server for reorganization according to the current bandwidth; then, the vertical projection distance of the real-time coordinates to a standard path is calculated, and the acceleration peak value is combined to determine whether the equipment is in a locked, offset or normal state; the system automatically generates a redirection or regular propulsion instruction to control a carrying terminal according to the state, and only the abnormal state data is persistently written during archiving, and the normal data is discarded after updating the position board. The application improves the transmission reliability, realizes accurate identification and scheduling of abnormal equipment, and reduces storage redundancy.

Description

Technical Field

[0001] This invention belongs to the field of sports event operation and logistics data management technology, and relates to an intelligent archiving and scheduling system for sports equipment logistics data for smart stadiums. Background Technology

[0002] In the context of smart stadiums, the logistics management of sports equipment involves a complete circulation chain from equipment outbound, inter-event transfer to post-event recovery. The equipment is diverse and has strict requirements for physical condition and path compliance. In order to ensure the efficiency of event operation and the needs of post-event auditing, it is necessary to collect, archive, and schedule data such as identity recognition, location coordinates, and sports impact generated during the equipment circulation process. This type of system falls under the category of commercial data processing in sports event operation.

[0003] In existing technologies, fixed RFID readers deployed at key logistics nodes are typically used to periodically poll equipment tags to obtain identification and time information. At the same time, independent sensors are used to collect environmental data such as acceleration. The data is then aggregated and stored in full on a central server. The planned path is compared with the actual collected coordinates by manual or simple rule comparison to determine the equipment flow status, and finally, a handling instruction is generated and sent to the handling terminal.

[0004] However, the above-mentioned technical methods have the following limitations: centralized uplink transmission is prone to data loss or delay due to network congestion during peak competition periods, while persisting all data to disk will generate a lot of storage redundancy, increasing the pressure on the server; the existing solution lacks an automatic judgment mechanism that deeply integrates the two indicators of acceleration impact and path deviation, making it difficult to distinguish between anomalies caused by physical damage and anomalies caused by path deviation, so that damaged equipment cannot be intercepted and sent for repair in time, affecting the availability of competition equipment; in addition, the judgment of path deviation usually relies on discrete node distance calculation rather than continuous vertical projection distance measurement, which is prone to misjudgment, and the generation and issuance of anomaly handling instructions have not been automatically linked with equipment status indicators, reducing scheduling efficiency. Summary of the Invention

[0005] To overcome the aforementioned deficiencies of the prior art and to achieve the above objectives, the present invention proposes the following technical solution: an intelligent archiving and scheduling system for sports equipment logistics data in smart stadiums, comprising: an edge data encapsulation module, used to acquire the identification code and real-time motion data of sports equipment, and to package the identification code, physical coordinates, timestamp, and triaxial acceleration peak extracted from the real-time motion data belonging to the same event batch into a composite data packet, which is then stored in the local cache queue of the edge gateway.

[0006] The adaptive fragmentation transmission module is used to receive input and output throughput feedback signals from the archive server. When it determines that the available bandwidth is lower than the preset throughput threshold, it segments the composite data packet according to the timestamp order and sends it asynchronously to the archive server to complete the fragmentation and reassembly, thus obtaining the reassembled composite data packet.

[0007] The trajectory deviation calculation module is used to extract the real-time physical coordinates of the same equipment in the recombined composite data packet, obtain the corresponding standard circulation path coordinate string, calculate the vertical projection distance from the real-time physical coordinates to the standard circulation path coordinate string, and generate the trajectory space deviation value.

[0008] The joint state determination module is used to analyze the peak value of the triaxial acceleration of the equipment, compare it with the physical tolerance value obtained according to the equipment type, and combine it with the trajectory space deviation value with the allowable error range set according to the functional area to generate a state label including locked state, offset state or normal state.

[0009] The dispatch instruction generation module is used to read the status identifier. When the status is locked, the coordinates of the equipment's destination are overwritten with the coordinates of the maintenance center and a redirection logistics instruction is generated. When the status is offset or normal, the original destination coordinates are maintained and a regular propulsion instruction is generated. The generated instruction is then sent to the handling terminal.

[0010] The differentiated archiving storage module is used to filter status identifiers during archiving. When the status is locked or offset, the recombined composite data packets and instructions corresponding to the equipment are converted into incremental data blocks and written to the historical archiving database. When the status is normal, the location dashboard is updated and the data is discarded.

[0011] Compared with the prior art, the beneficial effects of the present invention are as follows: (1) The present invention encapsulates the equipment identification code, physical coordinates, timestamp and triaxial acceleration peak into a composite data packet and caches it at the logistics channel through the edge gateway. Combined with the input and output throughput signals fed back by the archive server, the available bandwidth is determined. When the bandwidth is low, the composite data packet is fragmented and reassembled, which effectively avoids data loss under weak network conditions and improves the reliability of data transmission.

[0012] (2) This invention parses the real-time physical coordinates of the equipment from the recombined composite data packet and calculates the vertical projection distance of the equipment to the standard flow path coordinate string as the trajectory space deviation value. At the same time, it obtains the triaxial acceleration peak value and compares it with the equipment physical tolerance value. It generates a locked, offset or normal status identifier by combining the two dimensions of impact resistance and path compliance, thus realizing the accurate distinction between equipment damage and path deviation.

[0013] (3) The present invention automatically generates redirection logistics instructions for locked equipment based on status indicators to send it to the maintenance center, and generates regular advance instructions for deviated or normal equipment, thereby realizing automatic and rapid handling of abnormal equipment and reducing the delay of manual intervention.

[0014] (4) When writing to the archive database, the present invention filters according to the status identifier, organizes the data and instructions in the locked and offset states into incremental data blocks for persistent storage, and discards the data in the normal state directly after refreshing the position dashboard, which reduces the disk storage space occupation while ensuring that abnormal events are traceable. Attached Figure Description

[0015] To more clearly illustrate the technical solutions of the embodiments of the present invention, the accompanying drawings used in the description of the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0016] Figure 1 This is a schematic diagram of the system module connections of the present invention.

[0017] Figure 2 This is a schematic diagram illustrating the trajectory space deviation calculation of the present invention.

[0018] Figure 3 This is a spatial distribution diagram of the joint state determination of the present invention.

[0019] Figure 4 This is a comparison diagram of the track network scheduling paths for the sports field according to the present invention. Detailed Implementation

[0020] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0021] Please see Figure 1 As shown, the intelligent archiving and scheduling system for sports equipment logistics data in smart stadiums proposed in this invention includes: an edge data encapsulation module, an adaptive fragmentation transmission module, a trajectory deviation calculation module, a joint state determination module, a scheduling instruction generation module, and a differentiated archiving and storage module.

[0022] The edge data encapsulation module is used to acquire the identification code and real-time motion data of sports equipment, and package the identification code, physical coordinates, timestamp, and triaxial acceleration peak value extracted from the real-time motion data belonging to the same event batch into a composite data packet, which is then stored in the local cache queue of the edge gateway.

[0023] In a preferred embodiment, the edge data encapsulation module is specifically used to perform the following operations: read the identification code of the electronic tag on the equipment through the radio frequency identification reader deployed on the edge gateway of the logistics channel, and simultaneously receive the acceleration waveform output by the triaxial accelerometer integrated with the electronic tag; perform peak detection on the acceleration waveform within a preset time window and extract the triaxial acceleration peak value; encapsulate the identification code, the physical coordinates of the equipment when it passes through the channel, the timestamp of the identification code reading time, and the triaxial acceleration peak value into a single composite data packet; and write the single composite data packet into the local cache queue of the edge gateway in the order of encapsulation.

[0024] Specifically, RFID readers deployed at the edge gateway of the logistics channel transmit UHF RF signals in a polling manner. When sports equipment with electronic tags enters the reading area covered by the reader's antenna, the electronic tag obtains energy from the RF field and backscatters the modulated signal. This signal carries the equipment's identification code, which the reader demodulates and decodes to obtain the identification code. Simultaneously, a triaxial accelerometer integrated with the electronic tag, as part of the same sensing module, continuously pushes the real-time collected triaxial acceleration waveform data stream to the receiving module of the edge gateway through a 2.4GHz wireless channel independent of RF backscatter (e.g., based on Bluetooth Low Energy or ZigBee protocol). The data packet header contains the same sensor node number as the electronic tag. The edge gateway binds the acceleration waveform to the identification code based on this node number and takes the instantaneous system time when the reader successfully parses the identification code as a timestamp. The edge gateway then extracts a sample sequence of a preset time window length from the bound acceleration waveform buffer, centered on the timestamp. The sample sequence contains the X-axis acceleration components output by the triaxial accelerometer at a fixed sampling frequency within the preset time window. Y-axis acceleration components and Z-axis acceleration components ,in The sampling point number, Values ​​range from 1 to the total number of sampling points within the window. .

[0025] After obtaining the window sample sequence, the edge gateway performs a synthetic acceleration amplitude calculation for each sampling point, using the following formula: In the formula, For the first The X-axis acceleration components of each sampling point are expressed in meters per second squared. This represents the acceleration component along the Y-axis, expressed in meters per second squared. The acceleration component in the Z-axis direction is expressed in meters per second squared. For the first The composite acceleration amplitude at each sampling point is expressed in meters per second squared. Subsequently, the edge gateway retrieves the maximum composite acceleration amplitude within this window as the triaxial acceleration peak value. ,Right now: The unit is meters per second squared, and its dimension is the same as that of acceleration.

[0026] Preset time window duration ,in The accelerometer sampling frequency and window length were determined based on 200 sets of experimental data from various types of sports equipment, including alpine skis, bobsleighs, and rifle cases, in a standard logistics channel. The average dwell time of the equipment in the channel's sensing area was 2.2 seconds. To fully cover the potential impact acceleration spikes that may occur when equipment passes through, the preset time window length was set to 2.5 seconds, and the sampling frequency was set to 200 Hz, corresponding to the number of sample points within the window. .

[0027] After peak value extraction, the edge gateway reads the current event batch number from its local configuration storage and retrieves the pre-calibrated channel physical coordinates stored within the gateway. These physical coordinates are fixed coordinates of the RFID reader antenna installation location in the two-dimensional Cartesian coordinate system of the competition venue, in meters. Due to the small reading area of ​​the logistics channel, the edge gateway directly approximates these fixed coordinates as the real-time physical coordinates of the equipment as it passes through the channel. The edge gateway encapsulates the event batch number, identification code, X and Y components of the physical coordinates, timestamp, and triaxial acceleration peak value into a single composite data packet. The data structure of the composite data packet can be abstracted as a tuple. ,in For the event batch number, For equipment identification code, and These are the X and Y axis coordinates of the physical coordinate system. For timestamps, This represents the peak value of the three-axis acceleration. After encapsulation, the edge gateway immediately appends the composite data packet to the tail of a local cache queue maintained in memory. The local cache queue is a first-in, first-out linear list, and the composite data packets will be retrieved and processed in the order they were enqueued.

[0028] For example, in a major biathlon championship, the edge gateway is configured with the event batch number "WINTER_BIATHLON_2025_01". The fixed physical coordinates of the RFID reader antennas within the logistics channel are calibrated as follows: The coordinate unit is meters. When a rifle equipment box passes through the channel, the reader reads the identification code "RIFLE_BOX_088" from the electronic tag, and the demodulation completion timestamp is recorded as 1718500000.000 seconds. The gateway receiving module synchronously captures the acceleration waveform of the equipment's accelerometer for 2.5 seconds, from 1.25 seconds before to 1.25 seconds after the timestamp, at a sampling frequency of 200 Hz, obtaining 500 sampling points. The 237th sampling point is taken, and the original acceleration component is... meters per second squared meters per second squared Meters per square second, substituting into the synthesis formula, we get: The gateway iterates through all 500 sampling points and compares them to obtain... The maximum composite amplitude is used to determine the peak value of the triaxial acceleration. Meters per second squared, rounded to one decimal place. Based on the above data, the gateway encapsulates a composite data packet (“WINTER_BIATHLON_2025_01”, “RIFLE_BOX_088”, 15.0, 22.5, 1718500000.000, 18.8) and writes the packet to the tail of the local cache queue in chronological order of its generation, awaiting subsequent slice and fragment transmission.

[0029] The adaptive fragmentation transmission module is used to receive input / output throughput feedback signals from the archiving server, determine when the available bandwidth is lower than the preset throughput threshold, slice the composite data packet according to the timestamp order, and asynchronously send it to the archiving server to complete the fragmentation and reassembly, thereby obtaining the reassembled composite data packet.

[0030] In a preferred embodiment, the adaptive fragmentation transmission module is specifically used to perform the following operations: the edge gateway periodically obtains feedback signals containing quantized values ​​of the current input / output port busy levels from the archive server; compares the quantized values ​​in the feedback signals with the throughput threshold that ensures reliable data transmission; when the quantized values ​​are lower than the throughput threshold, the fragmentation transmission mechanism is triggered; retrieves composite data packets from the local cache queue in chronological order of timestamps, and sequentially divides each composite data packet into fragments carrying sequence number identifiers; sends the fragments to the archive server via an asynchronous transmission protocol, and the archive server combines fragments belonging to the same composite data packet into a reconstructed composite data packet based on the sequence number identifiers and preset data packet boundaries.

[0031] Specifically, a control channel maintaining a long-term connection is established between the edge gateway and the centrally dispatched archiving server. The archiving server collects real-time transmission and reception statistics of its own network interface at a fixed interval of 2 seconds. The archiving server reads the current transmission byte rate from the network card register as the current input / output throughput, and simultaneously loads the pre-calibrated maximum input / output throughput from the configuration file. This maximum input / output throughput is the limit transmission rate determined based on the archiving server's CPU concurrent processing capability, disk array sequential write rate, and network protocol stack throughput limit. The maximum steady-state throughput without packet loss during a continuous 72-hour stress test is measured to be 850 megabits per second. The archiving server calculates the current input / output port busyness quantization value for each cycle. It should be noted that in this invention, this busyness quantization value is inversely represented by the remaining available bandwidth of the port. That is, the quantization value is obtained by subtracting the current input / output throughput from the maximum input / output throughput, reflecting the remaining available processing capacity margin of the port. The smaller the value, the busier the port. The calculation formula is: In the formula, This represents the current busy level of the input / output ports (i.e., the remaining available bandwidth), in kilobits per second. This represents the maximum input / output throughput, expressed in kilobits per second. This represents the current input / output throughput, in kilobits per second. The archive server encapsulates this quantized value into an input / output throughput feedback signal, which is then sent to all online edge gateways via the control channel.

[0032] The edge gateway maintains a throughput threshold in memory to ensure reliable data transmission. This throughput threshold is a limit determined based on the archive server's disk persistent write capability, database transaction processing latency requirements, and physical link round-trip latency. Statistical analysis of 200 composite data packet upload tests in a high-altitude ski ski circulation scenario showed that when the available processing bandwidth on the archive server is less than 500 kilobits per second, the retransmission probability of a single direct transmission of a complete composite data packet increases to 17%. Therefore, this threshold is set... Kilobits per second. Each time the edge gateway receives a feedback signal, it immediately quantizes the current input / output port busy level extracted from the signal. With throughput threshold Comparison. When Upon establishment, the edge gateway determines that the archive server's current available processing bandwidth is insufficient (i.e., its workload is too high), triggering a fragmentation transmission mechanism; when At this time, the edge gateway maintains the normal transmission mode and delivers the composite data packets in the local cache queue directly to the transmission process.

[0033] After the fragmented transmission mechanism is triggered, the edge gateway retrieves composite data packets one by one from its local cache queue in ascending order of timestamps. For each composite data packet retrieved, the edge gateway serializes the event batch number, equipment identification code, X and Y components of the physical coordinates, timestamp, and triaxial acceleration peak values ​​from the composite data packet into a binary byte string with a fixed field length. The total length of the serialized byte string is denoted as […]. The unit is bytes. The edge gateway dynamically determines the fragmented payload length based on the network path maximum transmission unit and the wireless link quality. In this embodiment Set to 1024 bytes, under normal network conditions It can be set to 1024 bytes, but in weak network or congested environments that trigger the fragmentation transmission mechanism, the system will reduce the packet loss rate per transmission to lower the packet loss rate. Dynamic degradation is set to a smaller value, through the formula Calculate the total number of fragments required to divide this composite data packet. ,in This indicates a rounding up operation. The edge gateway generates a globally unique packet identifier for this composite data packet. , The device identification code and timestamp are concatenated and hashed to obtain a 4-byte digest value. Then, starting from the beginning of the byte string, the data packet is sequentially cut into segments of length [length missing]. The last fragment of the data block is insufficient. Cut to the actual length. For the first... For each data packet segment, the edge gateway adds a sequence number identifier structure to its payload header. The sequence number identifier is determined by the data packet identifier. Segment number and total number of segments Composition (e.g.) (4 bytes for header overhead, 2 bytes each for j and M unsigned integers, totaling 8 bytes for header overhead) and fragment sequence number. Increasing from 1 to Then, the fragmented data carrying sequence number identifiers is sent via asynchronous transmission protocol.

[0034] The asynchronous transport protocol implements selective acknowledgment and retransmission mechanisms on top of the User Datagram Protocol (UDP). The edge gateway pushes fragmented data as independent data packets to the protocol stack's send buffer and returns immediately, without blocking subsequent packet retrieval processes. The archive server is configured with preset packet boundary definitions, which are based on the total number of fragments in the fragment sequence number. When the value equals 1, it represents a single complete data packet; the total number of fragments is [number missing]. If the value is greater than 1, then it will continuously receive signals with the same... All fragments, up to the set of sequence numbers of the received fragments equal to 1 to... The complete integer range. The archive server uses the in-memory hash table as... Build a sharded collection list for the key, and collect each key with the same key. The fragments are divided according to the fragment number. Insert at the corresponding position, when the detection After all the fragments are collected, the fragment data is concatenated in ascending order of sequence number. The sequence number identifier at the beginning of each fragment is removed to obtain a binary sequence that is consistent with the original serialized byte string. Then, the event batch number, equipment identification code, physical coordinate X component, physical coordinate Y component, timestamp, and triaxial acceleration peak value are parsed and restored according to the fixed field length to form a recombined composite data packet that is completely equivalent to the one before the split.

[0035] For example, taking the composite data packet of a rifle equipment box from a large biathlon championship as shown in the example above, the serialized data packet occupies the following number of bytes for each field: event batch number (32 bytes), equipment identification code (32 bytes), physical coordinates X and Y components (8 bytes each, floating-point), timestamp (8 bytes, integer), and peak three-axis acceleration (4 bytes, floating-point). The total length after serialization is... Bytes. Maximum input / output throughput specified by the archive server. The current input / output throughput when a feedback signal is received via the control channel is kilobits per second. kilobits per second, according to the formula Kilobits per second. This quantization value is less than the throughput threshold. Kilobits per second trigger fragmentation transmission. To adapt to extremely low available bandwidth, the edge gateway dynamically adjusts the fragment payload length. Byte, because Bytes greater than Therefore The edge gateway generates this composite data packet. The first 4 bytes of the SHA-1 digest of "RIFLE_BOX_088_1718500000.000" are truncated, such as 0x3A2F1B9C. Then, the data is sliced: the first slice's payload of the first 64 bytes is truncated, and an 8-byte sequence number identifier (M=2 total slices, j=1 slice number) is appended to its beginning, forming a 72-byte slice data; the second slice's payload of the remaining 28 bytes is truncated, and an 8-byte sequence number identifier (M=2 total slices, j=2 slice number) is appended to its beginning, forming a 36-byte slice data. These two slices are then sent to the archive server via an asynchronous transmission protocol. Upon receiving the slices, the archive server... Store it in a hash table. When it is detected that the fragments j=1 and j=2 have been collected, it is determined that all boundaries have been collected. Concatenate them in order and remove the header sequence number to restore the reconstructed composite data packet containing the identifier RIFLE_BOX_088, physical coordinates 15.0 and 22.5, timestamp 1718500000.000, and triaxial acceleration peak value 18.8.

[0036] The trajectory deviation calculation module is used to extract the real-time physical coordinates of the same equipment in the recombined composite data packet, obtain the corresponding standard circulation path coordinate string, calculate the vertical projection distance from the real-time physical coordinates to the standard circulation path coordinate string, and generate the trajectory space deviation value.

[0037] In a preferred embodiment, the trajectory deviation calculation module is specifically used to perform the following operations: parse the identification identifier and real-time physical coordinates of the same equipment from the recombined composite data packet; based on the equipment's identification identifier and current competition stage information, query the database storing the planned paths of each piece of equipment in each competition stage to obtain a standard flow path coordinate string, which consists of multiple ordered coordinate nodes; calculate the vertical distance from the real-time physical coordinates to each line segment on the line segment sequence composed of coordinate nodes, and take the minimum value as the vertical projection distance from the real-time physical coordinates to the standard flow path coordinate string; determine the vertical projection distance as the trajectory space deviation value of the equipment.

[0038] Specifically, the scheduling system obtains the reconstructed composite data packet from the archive server, processed by the adaptive fragmentation transmission module. The reconstructed composite data packet is a complete data unit restored through the fragmentation and reassembly process, containing six fields: event batch number, equipment identification, X and Y components of real-time physical coordinates, timestamp, and peak three-axis acceleration. The scheduling system's trajectory analysis module first extracts the equipment identification and real-time physical coordinates from the reconstructed composite data packet. The equipment identification is the unique code embedded in the electronic tag, such as "RIFLE_BOX_088" for a rifle equipment box. The real-time physical coordinates are the two-dimensional coordinates recorded by the edge gateway at the logistics channel. It means that, among them The x-axis coordinate value. The values ​​are the vertical axis coordinates, all in meters.

[0039] The trajectory analysis module also retrieves information about the current stage of the competition from the competition management system. The competition management system maintains the competition progress state machine and outputs the current stage identifier based on the standard competition schedule and timers for each stage. Stage identifiers can be tags such as "equipment outbound transfer," "inter-competition group transfer," and "post-competition recovery." The module uses the equipment type associated with the equipment's identity identifier and the current stage identifier as query conditions to access a database storing the planned paths for each piece of equipment in each stage of the competition. This database pre-configures a standard transfer path coordinate string for each type of equipment in each stage of the competition. The standard transfer path coordinate string consists of multiple ordered coordinate nodes, each node being a fixed position in the Cartesian coordinate system of the competition area. The nodes are arranged in the order in which the equipment should pass through, and adjacent nodes are connected by virtual straight line segments to form a complete path. During a query, the database returns a sequentially arranged list of nodes, for example, the coordinate sequence of K nodes: The coordinate unit is meters.

[0040] After obtaining the real-time physical coordinates and the standard flow path coordinate string, the trajectory analysis module begins to calculate the trajectory spatial deviation value. In the standard flow path coordinate string, the first line segment is formed from node 1 to node 2, the second line segment is formed from node 2 to node 3, and so on, forming a total of... A continuous line segment. The module calculates the perpendicular distance from the real-time physical coordinate to each line segment, and takes the minimum value among all perpendicular distances as the perpendicular projection distance from the real-time physical coordinate to the standard flow path coordinate string. For any given line segment... line segment Values ​​range from 1 to The starting point of this line segment is The destination is The calculation process incorporates projection scale parameters. Used to determine from point The relative position of the foot of the perpendicular on the line segment when drawing a perpendicular line to the line segment.

[0041] First, construct the direction vector. and from the starting point to the point vector The definition is as follows: Next, calculate the vector. In vector The projected scalar inner product and The ratio of the squares of lengths: In the formula, the molecule is and The dot product, the denominator is The dot product of itself, It is a dimensionless real number. According to... The value of the point perpendicular distance to the line segment The calculation is divided into three scenarios, with the unit being meters.

[0042] when At that time, the foot of the perpendicular lands outside the starting point of the line segment, and the point is... Take the point perpendicular to the line segment To the starting point of the line segment Euclidean distance: when At that time, the perpendicular foot lands outside the end point of the line segment, and the point at this time... Take the point perpendicular to the line segment To the end of the line segment Euclidean distance: when When the foot of the perpendicular is inside the line segment, point The perpendicular distance to the line segment is equal to the point The perpendicular distance to the line segment is calculated using the magnitude of the cross product of vectors and the vector... The ratio of the modulus lengths is obtained by: In the formula, the molecule is and The absolute value of the cross product represents the product of the products ... and The area of ​​the parallelogram formed by the sides is equivalent to twice the area of ​​the triangle; the denominator is the length of the line segment, and the dimension of the ratio is meters.

[0043] Traverse all After the line segments, take each The minimum value is used as the vertical projection distance from the real-time physical coordinates to the standard flow path coordinate string. : The trajectory analysis module determines the vertical projection distance as the trajectory spatial deviation value of the equipment. The trajectory spatial deviation value is a scalar in meters, representing the shortest distance by which the actual position of the equipment deviates from the geometric center line of the predetermined path. Since the real-time physical coordinates of the equipment in this invention are approximated by the antenna coordinates of the logistics channel it currently passes through, calculating the deviation value of these coordinates from the equipment's dedicated standard flow path essentially determines whether the logistics channel the equipment is currently entering belongs to the planned route it should follow, thereby achieving accurate quantification and identification of abnormal spatial flow states such as equipment misdirection and misdelivery.

[0044] The node data of the standard flow path coordinate string comes from the calibration of the laser rangefinder at the competition venue. The node spacing is usually between 3 meters and 8 meters to ensure that the line segment sequence approximates the curved path with a polyline error of less than 0.15 meters. This error limit is determined based on the positioning accuracy of the handling terminal and the requirements for path compliance judgment at the competition venue.

[0045] For example, let's take the rifle equipment box "RIFLE_BOX_088" from a major biathlon championship as an example again. In the reassembled composite data packet output by the adaptive fragmented transmission module, the equipment's identifier "RIFLE_BOX_088" and real-time physical coordinates are parsed out. The scheduling system identifies the current event stage as "pre-event outbound transfer". Using the identity identifier and event stage identifier, it queries the standard path database and returns a standard transfer path coordinate string consisting of three ordered coordinate nodes: Node 1 Node 2 Node 3 This forms two line segments.

[0046] First calculate the points. The perpendicular distance to line segment 1-2. The starting point of line segment 1-2. ,end .structure , .calculate .because If the perpendicular foot lands outside the endpoint, then the vertical distance is... rice.

[0047] Next, calculate the points. The perpendicular distance to line segment 2-3. The starting point of line segment 2-3. ,end . From the starting point to the point vector . .because The foot of the perpendicular falls inside the line segment, and the perpendicular distance is calculated using the cross product formula: absolute value of the molecule cross product. Length of denominator segment Calculated rice.

[0048] The minimum perpendicular distance between the two line segments is meters, therefore real-time physical coordinates The vertical projection distance to the coordinate string of the standard flow path is 1.118 meters, and the trajectory spatial deviation is also 1.118 meters. This deviation will be compared with the allowable error range in the subsequent processing of the joint state determination module to help determine whether the equipment is in an off-center state.

[0049] Please see Figure 2 As shown, Figure 2 This is a schematic diagram illustrating the trajectory space deviation calculation of the present invention. As shown in the figure, the trajectory deviation calculation module relies on a geometric projection algorithm and a shortest distance optimization mechanism. For the real-time physical coordinates of the equipment and the standard flow path coordinate string, it determines the relative position of the projected perpendicular foot by calculating the vector dot product, obtaining the corresponding distance from the point to the endpoint of the line segment or the internal perpendicular foot. Then, skipping the simple comparison of discrete nodes, it uses the minimum distance comparison technique to directly quantify the shortest vertical projection distance deviating from the geometric center line of the path as the trajectory space deviation value, which is ultimately provided to the backend joint state determination module for continuous path compliance verification.

[0050] The joint state determination module is used to analyze the triaxial acceleration peak value of the equipment, compare it with the physical tolerance value obtained according to the equipment type, and combine it with the trajectory space deviation value with the allowable error range set according to the functional area to generate a state identifier including locked state, offset state or normal state.

[0051] In a preferred embodiment, the joint state determination module is specifically used to perform the following operations: determine whether the peak value of the triaxial acceleration is greater than the physical tolerance value calibrated according to the structural strength of the equipment; if so, determine that the equipment has physical damage and directly set the status identifier of the equipment to the locked state; if the peak value of the triaxial acceleration does not exceed the physical tolerance value, further determine whether the trajectory space deviation value exceeds the allowable error range set according to the fault tolerance requirements of the competition path; if so, set the status identifier of the equipment to the offset state; if the peak value of the triaxial acceleration does not exceed the physical tolerance value and the trajectory space deviation value does not exceed the allowable error range, set the status identifier of the equipment to the normal state.

[0052] In a further preferred embodiment, the joint state determination module obtains the physical tolerance value, specifically including: receiving the equipment type identifier associated with the equipment file; querying the physical characteristics database using the equipment type identifier to obtain the maximum withstand impact acceleration value corresponding to the equipment type; and using the obtained maximum withstand impact acceleration value as the physical tolerance value.

[0053] In a further preferred embodiment, the joint state determination module obtains the allowable error range by: extracting the current event stage identifier and the functional area identifier to which the current position of the equipment belongs; searching the path tolerance configuration table based on the current event stage identifier and functional area identifier to obtain the maximum allowable offset distance corresponding to the stage and area; and using the retrieved maximum allowable offset distance as the allowable error range.

[0054] Specifically, the status determination module of the scheduling system parses the equipment's identification and triaxial acceleration peak value from the reassembled composite data packet of the adaptive fragmented transmission module, denoted as... The unit is meters per second squared. Simultaneously, the trajectory spatial deviation value corresponding to the equipment (i.e., the vertical projection distance calculated above) is obtained from the calculation results of the trajectory deviation calculation module. ), denoted as The unit is meters. The status determination module then executes the physical tolerance value acquisition process and the allowable error range acquisition process in parallel. The limits obtained by these two processes are... , The common input is the state comparison logic, and the final output is the status indicator of the device.

[0055] The process of obtaining physical tolerance values ​​begins with the equipment management database. The scheduling system uses the equipment's identification identifier as an index to retrieve the equipment type identifier associated with the equipment at the time of manufacture from the equipment file table. This equipment type identifier is a code assigned by the equipment manufacturer according to the international classification standards for sports equipment. For example, the type identifier for a rifle case is "WINTER_BIATHLON_RIFLE_CASE," and the type identifier for snowboards is "ALPINE_SKI_01." After obtaining the equipment type identifier, the status determination module accesses the physical characteristics database. This database stores the maximum withstandable impact acceleration values, in meters per second squared, that different equipment types can withstand under standard test conditions without plastic deformation. The values ​​in the physical characteristics database are set based on product mechanical test reports provided by equipment manufacturers and destructive impact tests conducted by a third-party testing agency commissioned by the event organizing committee on 120 samples of 20 common event equipment. During the tests, the accelerometer readings were recorded by gradually increasing the drop height of the hammer, and the lower limit of the 95% confidence interval of the peak acceleration in the undamaged state of the sample was taken as the value to be entered into the database. The query operation matches the equipment type identifier with the index key in the database and returns the corresponding maximum withstand acceleration value. The status determination module assigns this value to the physical tolerance value, which characterizes the equipment's ability to withstand physical impact, and denotes it as... .

[0056] The process for obtaining the allowable error range requires two input parameters: the current event stage identifier and the functional area identifier of the equipment's current location. The current event stage identifier is provided in real-time by the event management system. This identifier can be an enumerated string such as "pre-race outbound transfer," "inter-race group transfer," or "post-race recovery," reflecting the current logistics flow stage of the equipment. The functional area identifier is determined as follows: the scheduling system maintains a venue vector partition map, which divides the venue plane into several polygonal areas and assigns a unique functional area identifier to each area, such as "main logistics channel area," "equipment buffer zone," and "competition preparation area." The status determination module uses the real-time physical coordinates from the reconstructed composite data packet... As a point, the ray casting method is used to detect the polygonal region it falls into. Specifically, a ray is emitted from the coordinate point in any direction, and the number of intersections between the ray and the boundaries of each polygon is counted. If the number of intersections with a polygon is odd, the point is determined to fall inside that polygon, and the corresponding functional area identifier is extracted. The current event stage identifier and the functional area identifier are used as a joint query key, and the status determination module searches the path fault tolerance configuration table. The path fault tolerance configuration table is a two-dimensional mapping table, with the event stage identifier at the top of each row and the functional area identifier at the top of each column. The cells in the table store the maximum allowable offset distance in meters. The data settings in this configuration table are based on the competition route compliance design specifications: In the main logistics channel area, during the outbound transfer phase, due to the physical width of the channel being 4.0 meters and the width of the automated guided vehicle (AGV) being 1.0 meter, the maximum permissible offset distance is set at 1.5 meters to prevent equipment from scraping against the channel walls; in the equipment buffer zone, during the inter-competition group transfer phase, due to the open space but dense equipment, the maximum permissible offset distance is set at 2.0 meters; in the competition preparation area, which requires extremely high positional accuracy, the maximum permissible offset distance is set at 0.5 meters. The values ​​of the retrieved cells are assigned to the allowable error range representing the route compliance scope, denoted as... .

[0057] The status determination module obtains , , and Then, the status indicator is determined according to hierarchical logic. The first step is to compare the peak triaxial acceleration with the physical tolerance value, with the determination condition being... If the inequality holds, it can be deduced that the equipment suffered a physical impact exceeding its structural strength during logistics, posing a risk of internal damage. The status determination module immediately sets the equipment's status flag to a locked state, stored as the string constant "LOCKED". Subsequent processing will no longer perform path deviation checks. This means the impact did not exceed the equipment's tolerance limit, and we proceed to the second step of the assessment. The second step involves comparing the trajectory space deviation value with the allowable error range; the judgment condition is... If the inequality holds, the equipment, though physically undamaged, has significantly deviated from its intended path, posing a risk of misdelivery or delay. The status determination module will set the equipment's status flag to the offset state, storing it as the string constant "DEVIATED". The equipment meets the requirements in terms of both physical safety and route compliance. The status determination module sets the equipment's status identifier to normal and stores it as the string constant "NORMAL". The generated status identifier and the equipment's identity identifier form a key-value pair, which is written to the scheduling system's in-memory database for the scheduling instruction generation module to read and use.

[0058] For example, the process data of the rifle equipment box "RIFLE_BOX_088" in a major biathlon championship is continued. The status determination module parses the triaxial acceleration peak from the reconstructed composite data packet. Meters per square second, the trajectory spatial deviation value is obtained from the trajectory deviation calculation module. Meters. Simultaneously, the module initiates the physical tolerance value acquisition process, retrieving the equipment file table using the identifier "RIFLE_BOX_088" to obtain the equipment type identifier "WINTER_BIATHLON_RIFLE_CASE". A query in the physical characteristics database using "WINTER_BIATHLON_RIFLE_CASE" as the key finds the maximum withstand impact acceleration value of 30.0 m / s². This value originates from a drop impact test report from a third-party testing agency for rifle equipment boxes. None of the 10 samples exhibited jamming deformation or handguard cracking when subjected to an impact of 30.0 m / s², therefore, the physical tolerance value is set. Meters per square second. The allowable error range acquisition process is performed simultaneously. The current event stage is identified as "pre-event outbound transport" by the event management system, along with real-time physical coordinates. In the venue vector zoning map, locate the functional area "Logistics Main Channel Area". Query the intersection cell of the row index "Pre-match Outbound Transfer" and the column index "Logistics Main Channel Area" in the path fault tolerance configuration table to obtain the maximum permissible offset distance of 1.5 meters, which is the allowable error range. rice.

[0059] Entering the state comparison logic, the first step is comparison. and 18.8 ≤ 30.0, inequality This condition is not met, so we will not enter the locked state branch. We will continue with the second step of the comparison. and 1.118 ≤ 1.5, inequality This also does not hold true. Therefore, the status of the equipment is determined to be normal, and the key-value pair "RIFLE_BOX_088":"NORMAL" is stored in the memory database. The subsequent scheduling process will use this to plan a normal advancement path for the equipment.

[0060] Please see Figure 3 As shown, Figure 3This is a spatial distribution diagram of the joint state determination of the present invention. As shown in the figure, the joint state determination module is implemented based on two-dimensional limit space division and short-circuit determination logic. For the parsed triaxial acceleration peak value and trajectory space deviation value, it obtains the corresponding physical tolerance value and allowable error range by reading the physical characteristic database and path fault tolerance configuration table; then, abandoning the single-dimensional determination rule, it uses the high-priority short-circuit logic of physical limit priority filtering to map the data that integrates impact tolerance and path compliance into the area slots of normal, off-center or locked states, and finally provides the scheduling instruction generation module with differentiated emergency or regular instructions.

[0061] The scheduling instruction generation module is used to read the status identifier. When the status is locked, the coordinates of the equipment endpoint are overwritten with the coordinates of the maintenance center and a redirection logistics instruction is generated. When the status is offset or normal, the original endpoint coordinates are maintained and a regular propulsion instruction is generated. The generated instruction is then sent to the handling terminal.

[0062] In a preferred embodiment, the scheduling instruction generation module is specifically used to perform the following operations: the scheduling system accesses the memory database to read the status identifier of the equipment identification index; when the status identifier is equal to the locked state, the original endpoint coordinates of the equipment in the scheduling plan are extracted, the original endpoint coordinates are replaced with the preset maintenance center node coordinates, and the redirection path is calculated based on the maintenance center node coordinates and the current position coordinates of the equipment, generating a redirection logistics instruction containing the redirection path; when the status identifier is equal to the offset state or the normal state, the original endpoint coordinates are kept unchanged, the regular advancement path is calculated based on the original endpoint coordinates and the current position coordinates of the equipment, generating a regular advancement instruction containing the regular advancement path; the redirection logistics instruction or the regular advancement instruction is sent to the corresponding automated guided transport terminal via a wireless network.

[0063] Specifically, the instruction generation module of the scheduling system is responsible for converting the status identifiers generated by the joint status determination module into executable logistics instructions. The scheduling system accesses the in-memory database, which is a fast access cache composed of key-value pairs. The key is the equipment's identification identifier, and the value is the status identifier string generated by the joint status determination module. The read operation uses the equipment's identification identifier parsed from the reconstructed composite data packet as the index key to retrieve the status identifier corresponding to that equipment. The status identifier can only take one of three values: "LOCKED", "DEVIATED", or "NORMAL", corresponding to the locked state, offset state, and normal state, respectively.

[0064] The instruction generation module initiates the branch processing flow based on the status flag. When the status flag equals the locked state, the module executes the redirection scheduling logic. The module first accesses the scheduling plan database, which stores the logistics flow plan table automatically generated by the event scheduling system for each piece of equipment before the start of the event. Each plan record includes the equipment's identification, start coordinates, finish coordinates, and planned flow time window. The module retrieves the table using the equipment's identification, extracts the equipment's original finish coordinates in the scheduling plan, and denotes them as follows: The unit is meters. Subsequently, the module reads the preset maintenance center node coordinates from the system configuration file, denoted as... The coordinates of the maintenance center node are marked and written into the configuration by the venue operations team during the event preparation phase. These coordinates represent the fixed position of the maintenance center entrance in the venue's coordinate system. An example coordinate value is... The module performs an endpoint overwrite operation, changing the endpoint field of the equipment in the scheduling plan from... Replace with After completing the endpoint replacement, the module calculates the redirection path based on the coordinates of the maintenance center node and the current location coordinates of the equipment. The current location coordinates of the equipment are taken from the real-time physical coordinates in the reassembled composite data packet, denoted as... The redirection path planning uses a piecewise linear interpolation method. The module loads the passable road network from the stadium topology map. The road network consists of a set of nodes and a set of arcs connecting the nodes, with the travel direction and arc length marked on the arcs. The path calculation process calls A. Graph search algorithms, with For the starting node, For the target node, search the road network for the node sequence with the minimum sum of arc lengths. The length of each arc is calculated using the Euclidean distance formula. For the slave node... To the node The arc segment, length for: In the formula, These are the x and y coordinates of the nodes at both ends of the arc segment, in meters; The unit is meters. The ordered sequence of nodes returned by the algorithm is the redirection path. The module encapsulates this sequence along with the target node coordinates into a redirection logistics instruction. The data structure of the redirection logistics instruction includes the instruction type field "REROUTE", the equipment identification, the list of redirection path nodes, and the coordinates of the repair center node.

[0065] When the status flag equals the offset state or the normal state, the module executes the normal propagation logic. The module retains the original endpoint coordinates unchanged. The module directly reads the equipment's identification from the scheduling plan database, representing the equipment's destination location for this stage of the competition, such as the coordinates of the buffer area at the competition venue entrance during the pre-competition outbound transport phase. The module then uses the original finish line coordinates and the equipment's current location coordinates. The calculation method for the regular advance path is the same as that for the redirection path, using A. Graph search algorithms, on the same traversable road network, Starting point The module searches for the shortest path to the destination, generating an ordered sequence of nodes as the regular advancement path. This sequence is encapsulated into a regular advancement command, with the data structure containing the command type field "NORMAL_PUSH", the equipment's identifier, and a list of nodes for the regular advancement path. It's important to note that while both the offset and normal states generate regular advancement commands, they differ significantly in technical terms: in the normal state, the equipment is on the originally planned route, and the result of Algorithm A is essentially a smooth continuation of the original path; however, in the offset state, the equipment has deviated from the original trajectory, and the current deviation position is used as the basis for the advancement command. Call A as the starting point The algorithm essentially triggers an anomaly correction and rerouting mechanism to ensure that the deviating equipment can replan a safe path to the original destination from its current position, thus giving the deviation status determination the necessary technical significance.

[0066] After the instruction generation module completes encapsulation, it sends redirection logistics instructions or regular propulsion instructions to the corresponding automated guided transport terminal via the wireless network between the scheduling system and the transport terminal. This wireless network is an industrial-grade wireless LAN based on the IEEE 802.11ax standard. The instruction message body sent by the scheduling system to the terminal via the message queue telemetry transmission protocol includes an equipment identification field. The transport terminal determines the instruction's origin based on this field. When the equipment identification in the instruction matches the equipment identification of the terminal currently executing a task, it accepts and parses the instruction content. The automated guided transport terminal is an electric vehicle with autonomous navigation capabilities, such as the AGV-T800 used in competitions. Equipped with lidar and inertial measurement units, it receives a list of path nodes and invokes an onboard local path planner to track and execute the transport task node by node.

[0067] For example, the processing of two status flag branches is illustrated using a scheduling scenario from a large-scale biathlon championship. In the normal state branch, the rifle equipment box "RIFLE_BOX_088" is still the object. The joint status determination module determines that the status flag of this equipment is normal, and the key-value pair in the memory database is "RIFLE_BOX_088":"NORMAL". After reading this status flag, the scheduling system proceeds to the regular advancement branch and queries the scheduling plan database to obtain the original finish line coordinates of the equipment. This corresponds to the entrance position of the starting buffer area of ​​the competition venue. The real-time physical coordinates are obtained from the reassembled composite data packets output by the adaptive fragmentation transmission module. .by Starting point As the destination, execute A on the passable road network. Search and return the sequence of nodes along the normal advancement path. The arc lengths between adjacent nodes are as follows: distance from node 1 to node 2 meters, distance from node 2 to node 3 meters, distance from node 3 to node 4 meters, distance from node 4 to node 5 The total path length is 162.5 meters. This node sequence is encapsulated as a regular propulsion command and sent to the AGV-T800 transport terminal via wireless LAN. The terminal then sequentially passes through each point to transport the equipment to the starting buffer area.

[0068] In the locked state branch, taking the alpine ski equipment "ALPINE_SKI_012" as an example, when the edge data encapsulation module processes the data, it detects a peak triaxial acceleration of 52.3 m / s². The joint state determination module queries the physical characteristic database and obtains the ski's maximum impact acceleration value as 45.0 m / s². Since 52.3 is greater than 45.0, the state flag is determined to be locked, and the memory database stores "ALPINE_SKI_012":"LOCKED". After reading this locked state flag, the scheduling system proceeds to the redirection branch, extracting the original endpoint coordinates. This refers to the starting platform for alpine skiing. The module reads the coordinates of the maintenance center node from the configuration file. The endpoint is overwritten with this coordinate. Real-time physical coordinates are taken from the reassembled composite data packet. On the passable road network Starting point Execute A for the endpoint Search and return the sequence of redirected path nodes. The lengths of each arc segment are 80.0 meters, 70.0 meters, 50.0 meters, and 230.0 meters respectively, for a total length of 430.0 meters. This sequence is encapsulated as a redirection logistics instruction and sent to the corresponding handling terminal via wireless LAN. The handling terminal changes the original route and directly sends the damaged skis to the repair center for technical assessment and repair.

[0069] Please see Figure 4 As shown, Figure 4 This is a comparison diagram of the track network scheduling path in this invention. As shown in the figure, the scheduling instruction generation module relies on the track network topology and A... The graph search algorithm is implemented. For equipment with different status indicators, the target node of the regular buffer area or maintenance center is obtained by reading the original endpoint or triggering the endpoint overwrite mechanism. Then, it skips the rigid scheduling of the preset fixed route, uses the current coordinates of the equipment as the dynamic starting point, and performs arc length accumulation search on the road network. The planned shortest spatial node sequence is encapsulated into a control message, which is finally used by the automatic guidance and handling terminal to perform precise redirection correction or regular propulsion actions.

[0070] The differentiated archiving storage module is used to filter status identifiers during archiving. When the status is locked or offset, the recombined composite data packet and instructions corresponding to the equipment are converted into incremental data blocks and written to the historical archiving database. When the status is normal, the location dashboard is updated and the data is discarded.

[0071] In a preferred embodiment, the differentiated archiving storage module is specifically used to perform the following operations: the archiving server obtains data objects to be persistently stored, the data objects including reconstructed composite data packets and issued instructions corresponding to the reconstructed composite data packets; extracts the status identifier of the equipment in the data objects; if the status identifier indicates a locked state or an offset state, the disk writing process is initiated, the data objects are organized into structured incremental data blocks, and a database insertion operation is performed to write them to the historical archive database; if the status identifier indicates a normal state, the disk writing process is skipped, and the location dashboard in memory is refreshed only using the physical coordinates in the reconstructed composite data packets, and the memory space occupied by the reconstructed composite data packets and their associated instructions is released after the refresh.

[0072] Specifically, while the dispatch instruction generation module sends the generated instructions to the automated guided transport terminal, the dispatch system constructs a data object to be persistently stored and pushes this data object to the archive server. The persistent data object is a structure containing three members: a reconstructed composite data packet, the corresponding issued instructions, and the equipment's status identifier extracted from the dispatch system's memory database. The reconstructed composite data packet is the complete data unit obtained after fragmentation and reassembly by the adaptive fragmentation transmission module. Its internal fields include the event batch number, equipment identification, real-time physical coordinates (X and Y components), timestamp, and triaxial acceleration peak value. The issued instructions are the content of the instructions generated by the dispatch instruction generation module and sent to the transport terminal. Redirect logistics instructions of type "REROUTE" include the equipment identification, a list of redirection path nodes, and the coordinates of the maintenance center node. Regular expedited instructions of type "NORMAL_PUSH" include the equipment identification and a list of regular expedited path nodes. The status identifier field takes values ​​of "LOCKED," "DEVIATED," or "NORMAL," corresponding to locked, offset, and normal states, respectively.

[0073] The archiving server internally maintains a persistent write thread, which retrieves data objects to be persistently stored one by one from the receive queue and processes them. The archiving server first parses the header of the data object to extract the equipment's status identifier. The extracted status identifier determines the subsequent persistence strategy.

[0074] When the status indicator is locked or offset, the archive server initiates the disk write process. The archive server organizes data objects into structured incremental data blocks. These incremental data blocks are binary row records that conform to the historical archive database table structure. The historical archive database table schema defines the following fields: event batch number (variable-length string), equipment identification (variable-length string), timestamp (64-bit integer), triaxial acceleration peak value (32-bit floating-point number), real-time physical coordinates X and Y (32-bit floating-point numbers each), status identifier (enumerated string), instruction type (enumerated string), and path node list (variable-length binary large object). The archive server sequentially extracts the values ​​of each field from the reconstructed composite data packet and issued instructions, encoding them into a continuous byte sequence according to preset field delimiters and length prefixes. The total length of the incremental data block is obtained by summing the serialized lengths of each field. Subsequently, the archive server calls the database's append write interface to insert this incremental data block as an immutable record in the log structure merging tree engine into the historical archive database's disk storage file. The write operation adopts a synchronous write-through strategy. After the data is written to disk, the archive server releases the network card buffer and heap memory pages occupied by the data object.

[0075] When the status indicator shows a normal state, the archiving server skips the disk write process and executes memory refresh and discard logic. The archiving server extracts the X and Y components of the real-time physical coordinates from the reconstructed composite data packet and writes them to the corresponding pixel offsets on the location dashboard maintained in memory. The location dashboard is a two-dimensional vector map of the venue logistics monitoring terminal. Each piece of equipment in transit is represented by an icon on the map, and the icon's displayed position is mapped one-to-one with the equipment's real-time physical coordinates. The refresh process is completed by directly rewriting the geometric transformation matrix of the icon object in the display list. After the location dashboard screen is refreshed, the archiving server calls the memory manager's reclamation primitive to return the memory space occupied by the reconstructed composite data packet and its associated instructions to the available memory pool, without performing any disk write operations.

[0076] For example, consider a scheduling scenario from a major biathlon championship. Taking the rifle equipment box "RIFLE_BOX_088" with a normal status as an example, the scheduling system issues a standard advance instruction to the handling terminal in the scheduling instruction generation module, and then sends the equipment's data object to the archiving server. The data object content is: a reconstructed composite data packet containing the event batch number "WINTER_BIATHLON_2025_01", the identifier "RIFLE_BOX_088", and physical coordinates. Timestamp 1718500000.000; peak three-axis acceleration 18.8; issued command is a regular propulsion command, command type "NORMAL_PUSH", path node sequence. The status flag is "NORMAL". The archive server retrieves the status flag for judgment. "NORMAL" indicates neither a locked nor an offset state, so it directly enters the memory refresh process to extract the physical coordinates from the reassembled composite data packet. Move the equipment icon corresponding to "RIFLE_BOX_088" on the location board to the coordinates. Once the screen update is complete, memory reclamation is invoked immediately, releasing all memory occupied by data objects and preventing any new records from being generated in the historical archive database.

[0077] Taking the alpine ski equipment "ALPINE_SKI_012" with a locked status as an example, this equipment is determined to be in a locked state in the joint status determination module, and the scheduling instruction generation module generates a redirection logistics instruction and sends it to the handling terminal. The data object constructed by the scheduling system includes: the event batch number "WINTER_BIATHLON_2025_01", the identifier code "ALPINE_SKI_012" in the recombined composite data packet, and the physical coordinates. Timestamp 1718500001.500; peak triaxial acceleration 52.3; issued instruction is a redirection logistics instruction, instruction type "REROUTE", path node sequence. Maintenance center node coordinates The status is "LOCKED". The archive server retrieves the status "LOCKED" and triggers the disk write process. The archive server serializes each field into incremental data blocks. The serialization results of the incremental data blocks are as follows: the event batch number field occupies 32 bytes, the equipment identification field is 16 bytes long plus the content "ALPINE_SKI_012", the timestamp field is 8 bytes long storing 0x000000006651B1BC, the triaxial acceleration peak field is 4 bytes long storing the floating point 0x42513333 (52.3 IEEE 754 single precision representation), the physical coordinates X and Y are each 4 bytes long storing 0x41F00000 (30.0) and 0x42200000 (40.0), the status identification field is 7 bytes long plus the content "LOCKED", the instruction type field is 8 bytes long plus the content "REROUTE", and the path node list field is 40 bytes long storing five coordinate points for a total of 40 bytes. The total length of the incremental data block is 32+16+8+4+4+4+7+8+40=123 bytes. The archive server writes the incremental data block as a complete record to the historical archive database. After the data is persisted to the disk, the memory is released.

[0078] Each of the modules can be implemented in whole or in part through software, hardware, or a combination thereof. It supports hardware embedded in or independent of the processor in the computer device, and also supports software stored in the memory of the computer device, so that the processor can call and execute the operations corresponding to each of the above modules.

[0079] The above embodiments are only used to illustrate the technical solutions of the present invention, and are not intended to limit it. Although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some of the technical features. Such modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present invention, and should all be included within the protection scope of the present invention.

Claims

1. An intelligent archiving and scheduling system for sports equipment logistics data in smart stadiums, characterized in that, include: The edge data encapsulation module is used to obtain the identification code and real-time motion data of sports equipment. It packages the identification code, physical coordinates, timestamp, and triaxial acceleration peak extracted from the real-time motion data belonging to the same event batch into a composite data packet and stores it in the local cache queue of the edge gateway. The adaptive fragmentation transmission module is used to receive input and output throughput feedback signals from the archive server. When it determines that the available bandwidth is lower than the preset throughput threshold, it segments the composite data packet according to the timestamp order and sends it asynchronously to the archive server to complete the fragmentation and reassembly, thus obtaining the reassembled composite data packet. The trajectory deviation calculation module is used to extract the real-time physical coordinates of the same equipment in the recombined composite data package, obtain the corresponding standard circulation path coordinate string, calculate the vertical projection distance from the real-time physical coordinates to the standard circulation path coordinate string, and generate the trajectory space deviation value. The joint state determination module is used to analyze the peak value of the triaxial acceleration of the equipment, compare it with the physical tolerance value obtained according to the equipment type, and combine it with the trajectory space deviation value with the allowable error range set according to the functional area to generate a state label including locked state, offset state or normal state. The dispatch instruction generation module is used to read the status identifier. When the status is locked, the equipment endpoint coordinates are overwritten with the maintenance center coordinates and a redirection logistics instruction is generated. When the status is offset or normal, the original endpoint coordinates are maintained and a regular propulsion instruction is generated. The generated instruction is then sent to the handling terminal. The differentiated archiving storage module is used to filter status identifiers during archiving. When the status is locked or offset, the recombined composite data packets and instructions corresponding to the equipment are converted into incremental data blocks and written to the historical archiving database. When the status is normal, the location dashboard is updated and the data is discarded.

2. The intelligent archiving and scheduling system for sports equipment logistics data in smart stadiums according to claim 1, characterized in that, The edge data encapsulation module is specifically used to perform the following operations: The identification code of the electronic tag on the equipment is read by the radio frequency identification reader deployed at the edge gateway of the logistics channel, and the acceleration waveform output by the triaxial accelerometer integrated with the electronic tag is received simultaneously. Peak values ​​of the acceleration waveform are detected within a preset time window, and the triaxial acceleration peak values ​​are extracted. The identification code, the physical coordinates of the equipment when it passes through the channel, the timestamp of the identification code reading time, and the peak value of the three-axis acceleration are encapsulated into a single composite data packet; Single composite data packets are written into the local cache queue of the edge gateway in the order of encapsulation.

3. The intelligent archiving and scheduling system for sports equipment logistics data in smart stadiums according to claim 1, characterized in that, The adaptive fragmentation transmission module is specifically used to perform the following operations: The edge gateway periodically obtains feedback signals from the archive server, which include quantified values ​​of the current busy levels of the input and output ports; The quantization value in the feedback signal is compared with the throughput threshold that ensures reliable data transmission. When the quantization value is lower than the throughput threshold, the fragmentation transmission mechanism is triggered. Retrieve composite data packets from the local cache queue in chronological order of timestamps from earliest to latest, and then sequentially divide each composite data packet into fragments carrying sequence number identifiers. The fragmented data is sent to the archive server via an asynchronous transmission protocol. The archive server then combines fragmented data belonging to the same composite data packet into a reconstructed composite data packet based on the sequence number identifier and the preset data packet boundary.

4. The intelligent archiving and scheduling system for sports equipment logistics data in smart stadiums according to claim 1, characterized in that, The trajectory deviation calculation module is specifically used to perform the following operations: Extract the identification and real-time physical coordinates of the same equipment from the reconstructed composite data packet; Based on the equipment's identification and the current stage of the competition, the standard circulation path coordinate string is obtained from the database that stores the planned paths of each piece of equipment in each stage of the competition. The standard circulation path coordinate string consists of multiple ordered coordinate nodes. On the line segment sequence composed of coordinate nodes, calculate the vertical distance from the real-time physical coordinates to each line segment, and take the minimum value as the vertical projection distance from the real-time physical coordinates to the standard flow path coordinate string. The vertical projection distance is determined as the trajectory space deviation value of the equipment.

5. The intelligent archiving and scheduling system for sports equipment logistics data in smart stadiums according to claim 1, characterized in that, The joint state determination module is specifically used to perform the following operations: Determine whether the peak value of the triaxial acceleration is greater than the physical tolerance value calibrated according to the structural strength of the equipment. If so, it is determined that the equipment has physical damage, and the status flag of the equipment is directly set to the locked state. If the peak value of the three-axis acceleration does not exceed the physical tolerance value, then it is further determined whether the trajectory space deviation value exceeds the allowable error range set according to the fault tolerance requirements of the competition path. If it does, the status flag of the equipment is set to the offset state. If the peak value of the triaxial acceleration does not exceed the physical tolerance value and the trajectory space deviation value does not exceed the allowable error range, then the status indicator of the equipment is set to normal.

6. The intelligent archiving and scheduling system for sports equipment logistics data in smart stadiums according to claim 5, characterized in that, The joint state determination module obtains the physical tolerance value, specifically including: Receive the equipment type identifier associated with the equipment file; The maximum withstand impact acceleration value corresponding to the equipment type can be obtained by querying the physical property database using the equipment type identifier. The maximum withstand impact acceleration value obtained from the query is used as the physical tolerance value.

7. The intelligent archiving and scheduling system for sports equipment logistics data in smart stadiums according to claim 5, characterized in that, The joint state determination module obtains the allowable error range, specifically including: Extract the current event stage identifier and the functional area identifier of the current equipment location; Based on the current event stage identifier and functional area identifier, the maximum allowable offset distance corresponding to the current stage and area is obtained by searching the path fault tolerance configuration table. The maximum permissible offset distance obtained from the retrieval is taken as the allowable error range.

8. The intelligent archiving and scheduling system for sports equipment logistics data in smart stadiums according to claim 1, characterized in that, The scheduling instruction generation module is specifically used to perform the following operations: The scheduling system accesses the memory database to read the status identifier from the equipment identification index; When the status flag is equal to the locked state, the original destination coordinates of the equipment in the scheduling plan are extracted, the original destination coordinates are replaced with the preset maintenance center node coordinates, and the redirection path is calculated based on the maintenance center node coordinates and the current location coordinates of the equipment, and a redirection logistics instruction containing the redirection path is generated. When the status flag is equal to the offset state or the normal state, the original endpoint coordinates are kept unchanged. The normal propulsion path is calculated based on the original endpoint coordinates and the current position coordinates of the equipment, and a normal propulsion command containing the normal propulsion path is generated. Redirect logistics instructions or regular progress instructions are sent to the corresponding automated guided transport terminals via wireless network.

9. The intelligent archiving and scheduling system for sports equipment logistics data in smart stadiums according to claim 1, characterized in that, The differentiated archive storage module is specifically used to perform the following operations: The archive server obtains the data object to be persistently stored. The data object includes the reassembled composite data packet and the issued instructions corresponding to the reassembled composite data packet. Extract the status identifier of the equipment in the data object. If the status identifier indicates a locked or offset state, start the disk write process, organize the data object into structured incremental data blocks, and perform a database insert operation to write to the historical archive database. If the status indicator indicates a normal state, the disk write process is skipped, and the location dashboard in memory is refreshed using only the physical coordinates in the reassembled composite data packet. After refreshing, the memory space occupied by the reassembled composite data packet and its associated instructions is released.

Images