BIM-based exhibition seat arrangement information management method and system

By using a BIM-based exhibition seating information management method, which utilizes personnel status timestamps and seat occupancy timestamps, combined with a topological sorting algorithm to automatically adjust seat numbers, the method solves the problems of manual verification and disordered order in traditional seating information management, thereby improving the accuracy and efficiency of seating arrangements.

CN121787830APending Publication Date: 2026-04-03ZHONGQING BOLIAN (BEIJING) TECHNOLOGY CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2025-12-29
Publication Date
2026-04-03

AI Technical Summary

Technical Problem

Traditional exhibition seating information management relies on paper lists and manual operation, which makes it difficult to continuously reflect personnel entry and exit and status changes, resulting in difficulties in seat adjustment, easy confusion and conflict in order, and reduced accuracy and timeliness of seating arrangements.

Method used

By collecting the exhibition participants' ID numbers, role attributes, and entry/exit status, a timestamp record of the participants' status is generated. Combined with the seat occupancy timestamp in the BIM model, a topological sorting algorithm is used to calculate the seat processing order, automatically adjust the seat numbers and status, generate updated seat records, and write them into the BIM model.

Benefits of technology

It achieves stability in seating arrangements under scenarios with frequent personnel changes, reduces manual verification costs, and improves the continuity and reliability of seating information updates.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN121787830A_ABST
    Figure CN121787830A_ABST
Patent Text Reader

Abstract

The invention relates to the technical field of information management, in particular to a BIM (Building Information Modeling)-based exhibition seat arrangement information management method and system, and the method comprises the following steps: collecting the serial number role attributes and access states of exhibition participants, forming a time sequence record, comparing the state time of the personnel with the seat occupation time to judge the range of seats needing to be adjusted, and determining the position of the seats needing to be adjusted; analyzing the influence of the personnel change on the occupation sequence in combination with the adjacent relationship of the seats in the model and the rank structure, determining the seat adjustment sequence relationship through a sorting mode, identifying and correcting the personnel number and the seat state corresponding to the abnormal occupation, and generating an updated seat record; according to the seat arrangement information management method and the seat arrangement information management system, through introduction of verification of the personnel state time and the seat occupation time, unification of the seat arrangement adjustment time sequence, overall sorting in combination with the adjacent relation of the seats, correction of the abnormal occupation relation and keeping of the consistency of the personnel and the seats, the seat arrangement information management efficiency is improved, and the seat arrangement information management efficiency is improved. And the updating stability and reliability of the row seat are improved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] This invention relates to the field of information management technology, and in particular to a BIM-based exhibition seating information management method and system. Background Technology

[0002] Information management technology refers to the field of unified recording, maintenance and adjustment of personnel information, seating information, identification information and their corresponding relationships involved in the organization and operation of conferences and events. Its core matters include the compilation of the list of participants, the numbering rules of the seats, the maintenance of the mapping relationship between seats and personnel, and the updating and redistribution of information when changes occur before and during the conference. It usually revolves around the systematic management of the conference scale, spatial layout, personnel hierarchy and on-site execution process to support conference preparation and on-site order arrangement.

[0003] Traditional exhibition seating arrangement management methods and systems refer to the way seats are allocated and managed for attendees or exhibitors in various conferences or exhibitions. They typically rely on paper attendee lists, with staff manually arranging seats on-site according to a predetermined order. Table cards are then manually printed and placed to identify the corresponding personnel. When the conference is large, the list and seat numbers need to be repeatedly checked. In case of temporary absences, replacements, or venue changes, the seating arrangement is updated by readjusting the seat order and remaking the table cards. The main technical aspects are manually sorting seat numbers, manually matching personnel information, and manually changing the label content to complete the seating arrangement management.

[0004] Traditional seating arrangement management relies on paper lists and manual operation to maintain the correspondence between personnel and seats. Information records are scattered and updates depend on manual verification, making it difficult to continuously reflect personnel entry and exit and status changes. When the scale of the meeting increases or personnel changes frequently, seat adjustments need to be repeatedly rearranged and labels need to be remade. The process lacks a unified time reference, which can easily lead to confusion in personnel order and seat occupancy conflicts. At the same time, manual judgment of the order of seat adjustments makes it difficult to grasp the overall impact of the adjustments, causing local modifications to trigger a chain of errors, increasing the on-site execution burden and reducing the accuracy and timeliness of seating arrangements. Summary of the Invention

[0005] To address the technical problems existing in the prior art, this invention provides a BIM-based exhibition seating information management method, comprising the following steps: S1: Collect the exhibition participants' ID numbers, role attributes, and entry / exit status, and extract the status timestamps. Compare the current status corresponding to the participant ID with the historical status timestamps to generate a participant status timestamp record. S2: Obtain the seat components corresponding to the personnel number and the seat occupancy timestamp in the BIM model, filter the entries where the seat occupancy timestamp and the personnel status timestamp do not match, extract the seat components that need to be adjusted, and generate a seating status determination record. S3: Based on the seating status determination record, obtain the adjacency relationship and row and column order of the seating components, combine the influence of personnel status changes on the seating occupancy order, use the topological sorting algorithm to calculate the seating processing order, and construct the seating adjustment influence chain; S4: Based on the seat adjustment influence chain, obtain the current occupancy status of the seat component and the associated personnel number in sequence. If the subsequent seat occupancy timestamp is earlier than the previous seat occupancy timestamp, rewrite the abnormal seat personnel number and occupancy status, and generate the updated seat record. S5: Based on the updated seat record and the personnel status timestamp record, verify the matching order of personnel number and seat component and write it into the BIM model to generate the seating information management result.

[0006] As a further embodiment of the present invention, the personnel status timestamp record includes a personnel number index table, role attribute identifier, and entry / exit status identifier; the seating arrangement status determination record includes a seat component identifier, personnel number association item, occupancy time comparison mark, and adjustment requirement identifier; the seating adjustment influence chain includes adjacent relationship topology pairs, row and column order index, and processing priority sequence; the updated seating record includes the corrected personnel number, occupancy status flag, and update timestamp item; and the seating arrangement information management result includes a BIM component attribute mapping item, seating arrangement effective time identifier, and model consistency verification mark.

[0007] As a further aspect of the present invention, the specific steps of S1 are as follows: S101: Collect the exhibition participants' ID numbers, role attributes, and entry / exit status information; perform time-series detection on entry / exit status change points and mark the time of status occurrence; arrange multiple status marks under the same person ID and generate a personnel status timestamp sequence. S102: Based on the personnel status timestamp sequence, call the current entry / exit status value of the corresponding personnel number, compare it with the most recent status timestamp record under the number, determine whether the status has been updated, and mark the status change node to obtain the personnel status sequence comparison mark set; S103: Based on the personnel status sequence comparison mark set, number the identified personnel, integrate their current status value with the corresponding timestamp, perform status and time mapping and complete structured reorganization to generate personnel status timestamp records.

[0008] As a further aspect of the present invention, the specific steps of S2 are as follows: S201: Obtain the seat component corresponding to the personnel number and the seat occupancy timestamp in the BIM model, verify the consistency between the seat component identifier and the personnel number, organize the start and end times of seat occupancy under the same personnel number and map the time to the seat component, and generate a seat occupancy timestamp sequence. S202: Based on the seat occupancy timestamp sequence, call the personnel status timestamp record, compare the seat occupancy timestamp and the personnel entry / exit status timestamp under the same personnel number item by item, determine the overlap relationship between the occupancy interval and the status interval, record the items that do not meet the preset time consistency condition, and obtain the seat status comparison identifier set; S203: Based on the seat status comparison identifier set, perform a filtering operation on the identified seat components, integrate the comparison results of the corresponding personnel number, seat component identifier and timestamp, and generate a seat status determination record.

[0009] As a further aspect of the present invention, the specific steps of S3 are as follows: S301: Based on the seating status determination record, extract the seat components that need to be adjusted, perform sequential comparison on adjacent seat components under the same row and column number, analyze the adjacent pointing relationship according to the numerical increment relationship of row number and column number, and form front and back association labels for each seat component to generate a set of adjacent relationships of seat components. S302: Based on the set of adjacent relationships of the seat components, call the time sequence record corresponding to the personnel status change, map the personnel entry and exit status to the associated seat components, compare the occupancy order of adjacent seat components, use the topological sorting algorithm to perform sorting calculation, and generate a seat processing order sequence. S303: Based on the seat processing sequence, sequentially connect the preceding and subsequent relationships of seat components with sequential dependencies, and construct an influence chain by combining the seat adjacency relationship to generate a seat adjustment influence chain.

[0010] As a further aspect of the present invention, the specific steps of S4 are as follows: S401: Obtain each seat component in the seat adjustment influence chain, collect the corresponding current occupancy status, associated personnel number and occupancy timestamp one by one according to the existing seat component identifier, perform unified time correction and sorting on the collected timestamps, and generate a seat component occupancy time record set; S402: Based on the seat component occupancy time record set, extract the occupancy timestamps of adjacent seat components, subtract the occupancy timestamp of the preceding seat from the occupancy timestamp of the subsequent seat to obtain the time difference algebra, and when the time difference algebra does not reach the occupancy time difference threshold, record the corresponding seat component identifier and generate a time difference threshold judgment set. S403: Based on the time difference threshold determination set, locate the seat component that meets the threshold determination condition, rewrite the personnel number and occupancy status of the corresponding seat component, map the subsequent personnel number to the current seat component and synchronously update the occupancy status identifier, and generate the updated seat record.

[0011] As a further aspect of the present invention, the occupancy time difference threshold is determined by statistically analyzing the occupancy timestamp sequence of seat components collected within the same business cycle, firstly performing numerical calculations on the occupancy time difference of adjacent seat components to form a time difference distribution set, then sorting and dividing the time difference values ​​in the set into intervals, and extracting the first quartile value located in the first 25% of the numerical sequence after sorting.

[0012] As a further aspect of the present invention, the specific steps of S5 are as follows: S501: Based on the updated seat record and the personnel status timestamp record, extract the personnel number, seat component identifier, and status timestamp fields item by item, perform timestamp sequence comparison on the seat component identifier associated with the same personnel number, and generate a personnel seat corresponding verification set; S502: Based on the personnel seat corresponding verification set, call the corresponding personnel status timestamp and seat component timestamp for each personnel number, perform time difference calculation, filter the corresponding entries whose time difference does not exceed the time difference verification threshold, and generate a threshold-constrained personnel seat mapping set. S503: Call the threshold constraint personnel seat mapping set, write the correspondence between personnel number and seat component identifier into the component attribute field of the BIM model, perform consistency verification on the written correspondence and summarize the written items to generate the seating information management result.

[0013] As a further aspect of the present invention, the time difference verification threshold is determined by statistically analyzing the time difference distribution between historical personnel status timestamp records and seat component timestamps, extracting time difference data corresponding to all personnel and seats, forming a time difference sequence and sorting it, and analyzing the statistical characteristic boundary value of the time difference sequence.

[0014] A BIM-based exhibition seating information management system includes: The personnel status module collects the exhibition participants' ID numbers, role attributes, and entry / exit status, extracts status timestamps, compares the current status corresponding to the personnel ID with the historical status timestamps, generates personnel status timestamp records, and transmits them to the seating arrangement determination module. The seating arrangement determination module obtains the seat components corresponding to the personnel number and the seat occupancy timestamp in the BIM model, filters the entries whose seat occupancy timestamps do not match the personnel status timestamps, extracts the seat components that need to be adjusted, generates a seating arrangement status determination record, and transmits it to the seating sorting module. The seat sorting module obtains the adjacency relationship and row and column order of the seat components that need to be adjusted based on the seat status determination record. Combining the impact of changes in personnel status on the seat occupancy order, it uses a topological sorting algorithm to calculate the seat processing order, constructs a seat adjustment influence chain, and transmits it to the seat correction module. The seat correction module sequentially obtains the current occupancy status and associated personnel number of the seat component based on the seat adjustment influence chain. When the occupancy timestamp of the subsequent seat is earlier than that of the preceding seat, it rewrites the personnel number and occupancy status of the abnormal seat, generates an updated seat record, and transmits it to the seating arrangement management module. The seating arrangement management module, based on the updated seat records and the personnel status timestamp records, verifies the matching order between personnel numbers and seat components and writes them into the BIM model, generating seating arrangement information management results.

[0015] Compared with the prior art, the advantages and positive effects of the present invention are as follows: In this invention, by introducing a corresponding verification between personnel status time and seat occupancy time, the synchronous determination of personnel changes and seat records is achieved, giving the seating arrangement adjustment a clear time sequence basis. Combining the adjacency relationship and row and column structure between seats, the overall ranking and correlation analysis of the adjustment impact is performed to avoid sequence conflicts caused by local modifications. By automatically correcting abnormal occupancy relationships, the consistency between personnel number and seat status is maintained, and the results are directly reflected in the spatial model. Thus, the seating arrangement relationship is maintained stably in scenarios with frequent personnel changes, reducing manual verification costs and improving the continuity and reliability of seating information updates. Attached Figure Description

[0016] To more clearly illustrate the technical solutions in the embodiments of the present invention, the accompanying drawings used in the description of the embodiments will be briefly introduced below. Obviously, the accompanying 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.

[0017] Figure 1 This is a schematic diagram of the steps of the present invention; Figure 2 This is a detailed schematic diagram of S1 of the present invention; Figure 3 This is a detailed schematic diagram of S2 of the present invention; Figure 4 This is a detailed schematic diagram of S3 of the present invention; Figure 5 This is a detailed schematic diagram of S4 of the present invention; Figure 6 This is a detailed schematic diagram of S5 of the present invention; Figure 7 This is a system module diagram of the present invention. Detailed Implementation

[0018] The technical solution of the present invention will now be described with reference to the accompanying drawings.

[0019] In embodiments of the present invention, words such as "exemplarily," "for example," etc., are used to indicate that something is an example, illustration, or description. Any embodiment or design described as "exemplary" in the present invention should not be construed as being more preferred or advantageous than other embodiments or designs. Specifically, the use of the word "exemplary" is intended to present the concept in a concrete manner. Furthermore, in embodiments of the present invention, the meaning expressed by "and / or" can be both, or either one.

[0020] In the embodiments of this invention, the terms "image" and "picture" may sometimes be used interchangeably. It should be noted that, without emphasizing the distinction between them, they convey the same meaning. Similarly, the terms "of," "corresponding (relevant)," and "corresponding" may sometimes be used interchangeably. It should be noted that, without emphasizing the distinction between them, they convey the same meaning.

[0021] In this embodiment of the invention, sometimes a subscript such as W1 may be written in a non-subscript form such as W1. When the difference is not emphasized, the meaning they express is the same.

[0022] To make the technical problems, technical solutions and advantages of the present invention clearer, a detailed description will be given below in conjunction with the accompanying drawings and specific embodiments.

[0023] Please see Figure 1 This invention provides a BIM-based exhibition seating information management method, comprising the following steps: S1: Collect the exhibition participants' ID numbers, role attributes, and entry / exit status, and extract the status timestamps. Compare the current status corresponding to the participant ID with the historical status timestamps to generate a participant status timestamp record. S2: Obtain the seat components corresponding to the personnel number and the seat occupancy timestamp in the BIM model, filter the entries where the seat occupancy timestamp and the personnel status timestamp do not match, extract the seat components that need to be adjusted, and generate a seating status determination record. S3: Based on the seating status determination record, obtain the adjacency relationship and row and column order of the seating components. Combine the impact of personnel status changes on the seating occupancy order, use the topological sorting algorithm to calculate the seating processing order, and construct the seating adjustment influence chain. S4: Based on the seat adjustment influence chain, obtain the current occupancy status and associated personnel number of the seat component in sequence. If the occupancy timestamp of the subsequent seat is earlier than that of the previous seat, rewrite the personnel number and occupancy status of the abnormal seat and generate the updated seat record. S5: Based on the updated seat records and personnel status timestamp records, verify the matching order of personnel numbers and seat components and write it into the BIM model to generate seating information management results.

[0024] Personnel status timestamp records include personnel number index table, role attribute identifier, and entry / exit status identifier. Seating status determination records include seat component identifier, personnel number association item, occupancy time comparison mark, and adjustment request identifier. Seating adjustment impact chain includes adjacent relationship topology pairs, row and column order index, and processing priority sequence. Updated seat records include corrected personnel number, occupancy status flag, and update timestamp item. Seating information management results include BIM component attribute mapping item, seating effective time identifier, and model consistency verification mark.

[0025] Please see Figure 2 The specific steps of S1 are as follows: S101: Collect the exhibition participants' ID numbers, role attributes, and entry / exit status information; perform time-series detection on entry / exit status change points and mark the time of status occurrence; arrange multiple status marks under the same person ID and generate a personnel status timestamp sequence. For the multi-channel RFID acquisition terminals deployed at the exhibition site, a data frame parsing program was initiated, locking the communication frequency band from 920MHz to 925MHz to capture the personnel tag signals passing through the security gate in real time. The EPC electronic product code field in the tag storage area was read as the personnel number, and the preset Hex code (0x01 for exhibitors, 0x02 for visitors) in the User area was extracted as the role attribute. The GPIO port level status corresponding to the gate's infrared trigger signal (high logic 1 for entry, low logic 0 for exit) was read as the entry / exit status information. The sampling frequency was set to 20Hz, i.e., the sampling period was 0.05 seconds. Taking visitor number "VID-2024-8892" as an example, data frames were continuously collected within a specified time interval. The binary value of the "entry / exit status" field was extracted frame by frame, and an XOR operation was used to compare the status bits of adjacent frames: the status value of the current frame was logically XORed with the status value of the previous frame. If the calculation result is 1, the time is determined to be a state change point; if the calculation result is 0, the state remains unchanged. For example, at 10:05:01:200, the state value is 0 (departed), and at the next sampling time of 10:05:01:250 (i.e., an increase of 0.050 seconds), the state value becomes 1 (entered). The XOR result of the two is 1, and 10:05:01:250 is marked as the state occurrence time. For the same person ID "VID-2024-8892", three state change points were captured within the detection period: 09:30:15:050 (entered), 11:45:20:100 (exited), and 13:10:05:600 (entered). Based on the timestamp values, the three marked points are sorted in ascending order using a quicksort algorithm to construct a state timestamp sequence unique to this person.

[0026] S102: Based on the personnel status timestamp sequence, call the current entry / exit status value of the corresponding personnel number, compare it with the most recent status timestamp record under the number, determine whether the status has been updated, and mark the status change node to obtain the personnel status sequence comparison mark set; Based on the generated personnel status timestamp sequence, the validity and update logic of the executed status is determined. To avoid signal jitter interference caused by personnel lingering at the turnstile, a minimum status update time interval threshold needs to be set. This threshold is set according to the following experimental procedure: In a test turnstile channel with a width of 1.2 meters, the effective sensing distance is set to 1.5 meters (including buffers before and after the sensing area). 50 test subjects were selected for passage tests. The average normal walking speed was measured to be 1.1 meters per second, and the extremely slow passage speed was 0.5 meters per second. The passage time interval is calculated as follows: 1.5 / 1.1 = 1.36 seconds; dividing 1.5 meters by 0.5 meters per second yields a slow passage time of 3.0 seconds. The weighted average of the normal and slow speeds is taken, with weighting coefficients of 0.8 and 0.2 respectively. The calculation process is 1.36*0.8 + 3.0*0.2 = 1.088 + 0.6 = 1.688 seconds. To ensure reasonable redundancy in data judgment, the final baseline threshold is set to 1.7 seconds. Read the current entry / exit status value and its corresponding timestamp from the sequence, and retrieve the most recently confirmed status timestamp record under that number. Calculate the time difference between the current timestamp and the most recently confirmed record. Set the most recently confirmed record to 11:45:20.100 (status: exit), and the currently detected candidate status to 11:45:21.500 (status: entry). Substitute the values ​​into the calculation: 11:45:21.500 minus 11:45:20.100 equals 1.400 seconds. Compare the calculated result 1.400 seconds with the threshold of 1.7 seconds. Since 1.400 is less than 1.7, this status update is determined to be an invalid jitter and is discarded. Subsequently, the timestamp of the next candidate state, 13:10:05:600, is read and compared again with the most recent confirmed record, 11:45:20:100. The difference is calculated as follows: first, the hourly difference is 2 hours (7200 seconds); the minute difference is -35 minutes (-2100 seconds); and the second difference is -14.5 seconds, for a total difference of 5085.5 seconds. Since 5085.5 is greater than 1.7, the state is determined to have undergone a substantial update. The node is marked as "valid update," and the updated state value "1" (in) and the timestamp "13:10:05:600" are confirmed as the latest baseline. Finally, a filtered set of personnel state sequence comparison tags is generated.

[0027] S103: According to the personnel status sequence comparison mark set, number the identified personnel, integrate their current status value and corresponding timestamp, perform status and time mapping and complete structured reorganization, and generate personnel status timestamp records; Based on the filtered personnel status sequence comparison tag set, for the identified personnel number "VID-2024-8892", perform standardized mapping and reorganization operations on the data fields. Establish a memory mapping table, defining a data structure containing five core fields: "Personnel Unique Identifier", "Role Type Code", "Event Type", "Precise Timestamp", and "Collection Point Number". Assuming the current collection date is December 24, 2024, first extract the personnel number "VID-2024-8892" and convert it to an internally common unique identifier format; map the role attribute "Audience" to the code "02"; map the entry / exit status value "1" to the event type "ENTRY", and "0" to "EXIT"; convert the timestamp to a Unix millisecond-level timestamp (UTC+8 time zone). For example, 13:10:05.600 is converted to the value 1735017005600. Concatenate the above fields in chronological order to form a structured JSON data packet. For the individual's complete activity trajectory throughout the day, the above mapping process was repeated, and the three valid records at 09:30:15.050 (entry), 11:45:20.100 (exit), and 13:10:05.600 (entry) were integrated into a table. As shown in Table 1, this table records in detail the status flow information of "VID-2024-8892" during the exhibition after cleaning and structuring. The results show that the visitor entered in the morning, briefly left at noon, and re-entered in the afternoon. Furthermore, the time intervals of all records were verified against the minimum status update time interval threshold, completing the conversion of unstructured sensor signals into structured business data and generating the final personnel status timestamp record.

[0028] Table 1. Structured Mapping Record of Exhibitor Status

[0029] As shown in Table 1, discrete signal capture times are transformed into structured entries with business meaning. The precise timestamp corresponds to the valid time point after being filtered by a threshold of 1.7 seconds in step S102, and the Unix timestamp value strictly corresponds to the time of December 24, 2024, ensuring the accuracy and uniqueness of the record.

[0030] Please see Figure 3 The specific steps of S2 are as follows: S201: Obtain the seat component corresponding to the personnel number and the seat occupancy timestamp in the BIM model, verify the consistency between the seat component identifier and the personnel number, organize the start and end times of seat occupancy under the same personnel number and map the time to the seat component, and generate a seat occupancy timestamp sequence. First, a precise query request is initiated to the BIM operation and maintenance database to locate the ticketing information table bound to the personnel number "VID-2024-8892" and obtain the unique identifier "SEAT-A-105" for the assigned seat. The component attribute table in the BIM model is then called to verify the existence and availability of the seat identifier, and the corresponding physical component code is extracted. After verification, the data stream from the piezoresistive pressure sensor deployed at the bottom of the seat is accessed via middleware to obtain the original pressure sensing log for the day with a sampling frequency of 10 Hz. To eliminate signal jitter caused by non-subjective touch or personnel adjusting their posture, an "effective occupancy judgment weight threshold" and a "minimum continuous occupancy time threshold" need to be set. The weight threshold setting is based on the following experimental procedure: In a standard experimental environment, 100 standard seat samples were selected, and the average sensor noise floor was measured to be 0.2 kg under no-load conditions; a child weighing 20 kg (simulating the minimum effective spectator load allowed for entry into the venue) was selected for a seating test, and the stable pressure value was measured to be 19.8 kg. To ensure coverage of lightweight audiences and eliminate interference from object placement, a safe range of approximately 25% between the noise floor and the minimum load was chosen. An effective occupancy weight threshold of 5 kg was set; any signal below this value was considered a false touch. Regarding the time threshold, testers were invited to simulate "rapidly passing by a false touch" and "normal seating adjustment." The average duration of the false touch signal was measured to be 1.2 seconds, and the shortest stable duration for normal seating was 4.5 seconds. The arithmetic mean of these two values ​​was taken and rounded to the nearest integer: (1.2 + 4.5) / 2 = 2.85 seconds, rounded to 3 seconds. Based on the above thresholds, the original logs were cleaned: A record was set in the original data with a start time of 11:40:00:000 and an end time of 11:40:02:000, lasting 2.0 seconds. Since 2.0 seconds is less than 3 seconds, it was considered invalid noise and removed. After cleaning, two valid occupancy records were extracted: the first started at 09:45:10:200 and ended at 11:30:05:500; the second started at 13:20:00:000 and ended at 14:00:00:000. These two time intervals were structurally bound to the seat component code "UUID-SEAT-A-105" and arranged in chronological order to generate a unique seat occupancy timestamp sequence for that person.

[0031] S202: Based on the seat occupancy timestamp sequence, call the personnel status timestamp record, compare the seat occupancy timestamp and the personnel entry and exit status timestamp under the same personnel number item by item, determine the overlap between the occupancy interval and the status interval, record the items that do not meet the preset time consistency condition, and obtain the seat status comparison identifier set; Based on the generated seat occupancy timestamp sequence, the generated status timestamp record of person "VID-2024-8892" is retrieved to perform a spatiotemporal consistency check. First, the valid on-site time periods of the person within the venue are extracted: the first time period is from 09:30:15.050 to 11:45:20.100, and the second time period is from 13:10:05.600 to closing time. A "clock synchronization tolerance value" is set to handle clock drift between distributed devices. This value is set based on network latency stress testing: ICMP protocol PING tests are performed on 1000 terminal devices within the venue's LAN, and the average loopback latency is measured to be 120 milliseconds, with a maximum latency of 450 milliseconds. To ensure coverage of the maximum latency and to reserve a buffer, the tolerance value is set to 500 milliseconds, or 0.5 seconds. The seat occupancy time and the person's on-site time are compared item by item. For the first seat occupancy record (09:45:10.200 to 11:30:05.500), firstly, determine if the seat start time is later than the person's entry time minus the tolerance value: 09:30:15.050 minus 0.500 seconds equals 09:30:14.550 seconds. The seat start time of 09:45:10.200 seconds is later than this result, so the logic is valid. Next, determine if the seat end time is earlier than the person's departure time plus the tolerance value: 11:45:20.100 seconds plus 0.500 seconds equals 11:45:20.600 seconds. The seat end time of 11:30:05.500 seconds is earlier than this result, so the logic is valid. Therefore, this seat occupancy record is determined to "overlap" with the person's presence status and is marked as "consistent". When an abnormal seat record is detected (e.g., from 12:00:00 to 12:10:00), it is compared with the personnel status record. It is found that this period falls within the "absentee" window between the personnel's departure in the first time slot (11:45) and arrival in the second time slot (13:10), meaning the person was not in the venue when the seat was occupied. The time deviation is calculated: the seat start time of 12:00:00 is earlier than the second time slot arrival time of 13:10:05.600 and later than the first time slot departure time of 11:45:20.100, failing to match any valid presence interval. Therefore, this record is determined to be a "spatiotemporal conflict," and the conflict type is recorded as "absentee occupancy." A seat status comparison identifier set containing consistency markers and conflict types is generated.

[0032] S203: Based on the seat status comparison identifier set, perform a filtering operation on the identified seat components, integrate the corresponding personnel number, seat component identifier and timestamp comparison results, and generate a seat status determination record; Based on the output seat status comparison set, an anomaly filtering and data reorganization process is initiated. The set is traversed, and a filtering operation is performed based on the "consistency flag" field, automatically removing all abnormal records marked as "spatial-temporal conflict" or "absentee occupancy," retaining only valid seat occupancy data that passes logical verification. For the retained records, their corresponding personnel number "VID-2024-8892," seat physical component code "UUID-SEAT-A-105," and verified start and end timestamps are integrated. Calculate the "net occupied time" for each seat. Taking the first record as an example, the end time is 11:30:05:500 seconds minus the start time 09:45:10:200 seconds. The calculation process is as follows: For the seconds digit, 05:500 seconds minus 10:200 seconds requires borrowing space, calculated as 65.5 - 10.2 = 55.3 seconds; for the minutes digit, 30 minus 1 (borrowed) minus 45 equals -16, requiring borrowing space, calculated as 29 + 60 - 45 = 44 minutes; for the hours digit, 11 minus 1 (borrowed) minus 9 equals 1 hour. Therefore, the total time is 1 hour, 44 minutes, and 55.3 seconds. Converting to pure seconds: 1 * 3600 + 44 * 60 + 55.3 = 3600 + 2640 + 55.3 = 6295.3 seconds. Subsequently, the personnel ID was mapped to the "user attribute" in the BIM model, the seat component code was mapped to the "spatial location attribute," and the time information was formatted as a standard date and time string. This information was then written into the seating arrangement status determination record table, as shown in Table 2. This table details the final seat usage after BIM component association and spatiotemporal logic cleansing. The results indicate that the visitor used the seat twice during the exhibition, and all usage occurred within the legal on-site time period, eliminating interference from non-human factors or sensor false alarms during off-site periods, thus generating an accurate seating arrangement status determination record.

[0033] Table 2 Audience Seating Status Determination and Duration Statistics

[0034] As shown in Table 2, two seat usage records that have undergone rigorous logical verification were finally output. The duration of the second record was calculated as 14:00:00.000 minus 13:20:00.000, which equals 40 minutes or 2400.0 seconds. Each record contains a timestamp accurate to milliseconds and the corresponding duration statistics, realizing the transformation from raw sensor data to high-confidence business data.

[0035] Please see Figure 4 The specific steps of S3 are as follows: S301: Based on the seating status determination record, extract the seat components that need to be adjusted, perform sequential comparison on adjacent seat components under the same row and column number, analyze the adjacent pointing relationship based on the numerical increment relationship of row number and column number, and form front and back association labels for each seat component to generate a set of adjacent relationships of seat components. Based on the generated and filtered seat component "SEAT-A-105" which was deemed "valid," a procedure for constructing physical spatial adjacency relationships was executed for this target seat. First, the spatial database of the BIM operation and maintenance platform was accessed, and the spatial geometric parameters of all components in the "10th row" containing this seat were extracted. A "physical adjacency judgment distance threshold" was set, based on the national standard for venue seating arrangements: the known standard center-to-center distance between consecutive rows of seats is 0.55 meters, and the front-to-back row distance is 0.90 meters. To accurately locate adjacent seats on the left and right sides and exclude aisle spacing, the distance threshold was set to 1.2 times the standard distance, i.e., 0.55 meters multiplied by 1.2, resulting in 0.66 meters. The centroid coordinates (x-coordinate 5.50, y-coordinate 9.00) of the target seat "SEAT-A-105" were read, and the coordinate data of adjacent components in the same row were traversed. The coordinates of the right-side seat "SEAT-A-106" were detected as (x-coordinate 6.05, y-coordinate 9.00). Using the Euclidean distance algorithm, the distance between the two seats was calculated: first, the difference in x-coordinates was calculated as 6.05 - 5.50 = 0.55; the difference in y-coordinates was 0, resulting in a total distance of 0.55 meters. Since the calculated result of 0.55 meters is less than the threshold of 0.66 meters, the two seats are determined to be "physically adjacent." Similarly, the coordinates of the left-side seat "SEAT-A-104" were detected as (x-coordinate 4.95, y-coordinate 9.00), and the calculated distance was 0.55 meters, also satisfying the adjacentness determination condition. Further analysis of the directional relationship based on the increasing column numbers reveals the following: Comparing column numbers, 106 is greater than 105, establishing "SEAT-A-105 pointing to SEAT-A-106" as a "right-increasing association (inner direction)"; 104 is less than 105, establishing "SEAT-A-104 pointing to SEAT-A-105" as a "right-increasing association" (i.e., 104 points to 105, 105 being inside 104). For the front-to-back row relationship, the difference in the vertical coordinate is calculated, i.e., 9.00 - 8.10 = 0.90 meters, confirming that the seat "SEAT-A-095" in the 9th row is physically adjacent to the target seat but belongs to a different row. Finally, a set of seat component adjacency relationships containing multi-dimensional directional relationships (front-to-back, left-to-right) is generated.

[0036] S302: Based on the set of adjacent relationships of seat components, call the time sequence records corresponding to the changes in personnel status, map the personnel's entry and exit status to the associated seat components, compare the order of occupancy of adjacent seat components, use the topological sorting algorithm to perform sorting calculation, and generate a seat processing order sequence. Based on the generated set of adjacent relationships of seat components, the generated personnel status timestamp records are called to perform topological time-series analysis and conflict sorting for multiple seat occupancy. The user of the target seat "SEAT-A-105" is set as audience member A (ID VID-2024-8892), and the user of the adjacent seat "SEAT-A-106" to its right is audience member B (ID VID-2024-9900). The entry timestamps of both are extracted: audience member A's is 09:45:10.200, and audience member B's is 09:50:00.000. A "passage obstruction judgment logic" is defined, given that the venue's passage rule is a one-sided corridor (located on the 1st column side), meaning that to reach the 6th column (SEAT-A-106), one must pass through the physical space of the 5th column (SEAT-A-105). The "physical dependency depth" is determined based on the seat column number: seat A's depth value is 5, and seat B's depth value is 6. Since the depth value 5 is less than 6, seat A is determined to be on the necessary passage path of seat B. Compare the entry times of the two: Audience B's entry time of 09:50:00 is later than Audience A's entry time of 09:45:10, meaning that person B (inner side) entered later than person A (outer side). Calculate the conflict time difference: 09:50:00 minus 09:45:10 equals 290 seconds. Since the person on the outer side is already seated, the entry of the person on the inner side will inevitably trigger a "passage obstruction event," and the obstruction strength of this event is recorded as 1.0. If there is no obstruction (e.g., the person on the inner side enters first), it is marked as 0. Treat all associated seat occupancy events as nodes in a directed acyclic graph, and construct edges with "evacuation or adjustment priority" as weights. When cleaning or evacuation guidance is needed for this area, the Kahn algorithm is used to perform topological sorting of the nodes: calculate the in-degree of each seat node (i.e., the number of seats in front that block its passage). In this example, SEAT-A-105 blocks SEAT-A-106, so a dependency edge is created from 105 to 106 (indicating that it is recommended to process 105 before processing 106, or that 105 needs to be moved). Calculations generate a seat processing order sequence that conforms to physical traffic logic, with SEAT-A-105 as the first position and SEAT-A-106 as the second, ensuring that the operation order conforms to spatial constraints.

[0037] S303: Based on the seat processing sequence, connect the preceding and subsequent relationships of seat components with sequential dependencies one by one, and construct an influence chain by combining the seat adjacency relationship to generate a seat adjustment influence chain. Based on the output seat processing sequence, the adjustment influence chain is constructed and parameters are quantified. A "state propagation attenuation model" is defined to quantify the impact of a seat state change (such as "leaving for cleaning," "maintenance occupancy," or "temporary requisition") on associated seats. The calculation formula is: initial influence strength multiplied by the distance attenuation coefficient raised to the power of the distance, then multiplied by the hindrance weight coefficient. The initial influence strength is set to 100, and the distance attenuation coefficient is set to 0.8. Using "SEAT-A-105" as the core trigger point, when its state is marked as "pending adjustment," the influence propagates outwards along the physical adjacent chain. For the first-level associated seat "SEAT-A-106" (adjacent to the right, distance 1), the basic influence value is calculated as 100 * 0.8 = 80. Combining the hindrance analysis results from S302, a "hindrance weight coefficient" is introduced: due to the existence of a "passage hindrance event" (hindrance strength marked as 1.0), indicating frequent interaction between the two seats, a high-association weight is set to 1.5. The final impact strength after correction is calculated as: 80 * 1.5 = 120.0. For the left-side seat "SEAT-A-104" (adjacent to the left, distance 1), although physically adjacent, there is no obstruction to passage (the outer side is closer to the aisle), a standard weight of 1.0 is set, and the impact strength is calculated as: 100 multiplied by 0.8 to the power of 1, then multiplied by 1.0, equaling 80.0. For the front-row seat "SEAT-A-095", with a cross-row attenuation coefficient of 0.5 and no obstruction, the impact strength is calculated as: 100 * 0.5 = 50.0. All calculated related impact nodes are chained together to form a chain data structure with directionality and weight values. The entire seating arrangement is traversed, and isolated impact chains are merged, ultimately generating a seat adjustment impact chain list, as shown in Table 3. This table records in detail the ripple range and quantified impact value with the core adjusted seat as the starting node. The results show that by constructing an impact chain, it is possible to accurately identify the related seat groups that need to be monitored simultaneously due to a single seat change. In particular, it quantifies the highly interconnected impact of the obstruction relationship, providing quantitative data support for subsequent guidance, evacuation, or cleanup scheduling.

[0038] Table 3. Analysis of the Adjacent Influence Chain of Seating Adjustment

[0039] As shown in Table 3, the specific impact of the state change of SEAT-A-105 on the surrounding components was quantified. The impact intensity on SEAT-A-106 was as high as 120.0, which exceeded the initial intensity of 100. This clarifies that SEAT-A-106 is a highly sensitive node in the chain that is obstructed and needs to be treated first or simultaneously when SEAT-A-105 is adjusted.

[0040] Please see Figure 5 The specific steps of S4 are as follows: S401: Obtain each seat component in the seat adjustment influence chain, collect the corresponding current occupancy status, associated personnel number and occupancy timestamp one by one according to the existing seat component identifier, perform unified time correction and sorting on the collected timestamps, and generate a set of seat component occupancy time records; Retrieve each seat component listed in the generated seat adjustment impact chain, including the core trigger seat "SEAT-A-105" and its associated affected seat "SEAT-A-106". Based on the component's unique identifier, initiate a parallel data acquisition request to the IoT edge gateway to read the real-time status register stored in the local controller. The acquired content includes the current occupancy status bit, the bound associated personnel number, and the original hardware timestamp triggered by the status change. To eliminate timing drift caused by crystal oscillator frequency deviation between different seat controllers, a unified "Network Time Protocol correction" must be performed on the acquired original timestamps. Select the data center atomic clock server as the Level 0 reference source and send clock synchronization probe packets to each target seat controller. Taking the controller of seat "SEAT-A-106" as an example, record four key moments in the probe process: the client sends the request at 1000 milliseconds, the server receives it at 1050 milliseconds, the server sends the response at 1060 milliseconds, and the client receives the response at 1120 milliseconds. Calculate the network round-trip latency: First, calculate the time difference between receiving the response and sending the request, i.e., 1120 - 1000 = 120 milliseconds; second, calculate the server's internal processing time, i.e., 1060 - 1050 = 10 milliseconds; finally, subtract the two, 120 - 10 = 110 milliseconds. Calculate the local clock's time offset relative to the reference source: First, calculate the difference between the server's receiving time and the client's sending time, i.e., 1050 - 1000 = 50 milliseconds; second, calculate the difference between the server's response sending time and the client's response receiving time, i.e., 1060 - 1120 = -60 milliseconds; add these two differences to get -10 milliseconds, (-60 + 50) / 2 = -5 milliseconds. This result shows that the local clock is 5 milliseconds ahead of the reference time. The original entry timestamp of the seat, 09:50:00.005, is read. The offset correction formula is applied: the original time is added to the offset. The corrected standard time is calculated as 09:50:00.005 plus -0.005 seconds, resulting in 09:50:00.000. This correction process is then performed on all components in the linked list, unifying the scattered hardware times onto a standard UTC timeline. The cleaned data is then structured and stored, generating a set of seat component occupancy time records containing precise time sequences.

[0041] S402: Based on the seat component occupancy time record set, extract the occupancy timestamps of adjacent seat components, subtract the occupancy timestamp of the preceding seat from the occupancy timestamp of the subsequent seat to obtain the time difference algebra, and when the time difference algebra does not reach the occupancy time difference threshold, record the corresponding seat component identifier and generate a time difference threshold judgment set. Based on the generated set of seat component occupancy time records, and according to the determined topology processing order (i.e., from SEAT-A-105 to SEAT-A-106), the corrected occupancy timestamps of adjacent seat components are extracted. The "preceding seat" is defined as the earlier node in the processing sequence (SEAT-A-105), and the "following seat" is defined as the later node (SEAT-A-106). The entry time of the preceding seat is extracted as 09:45:10.200, and the entry time of the following seat is extracted as 09:50:00.000. The time difference is calculated using the formula: subsequent time minus preceding time. The specific calculation process is as follows: Subtracting 10.200 from 00.000 in the seconds place (requiring borrowing), the result is 60.000 - 10.200 = 49.800 seconds; subtracting 1 (the borrowed portion) from 50 in the minutes place, and then subtracting 45, equals 4 minutes; the total time difference is 4 * 60 + 49.8 = 289.8 seconds. A "time difference threshold" is set to determine whether the occupancy behavior of two seats exhibits "strong correlation" characteristics (such as traveling together or continuous influence). Regarding the setting of this threshold, based on historical audience behavior database analysis: 500 groups of audience members confirmed to have entered together were randomly selected, and their seating time intervals were statistically analyzed. The calculated average interval time was 180 seconds, with a standard deviation of 40 seconds. Based on the three-standard-deviation principle of normal distribution, this threshold covers 99.7% of the data. The upper limit of the sample is the threshold, which is the mean plus three standard deviations, calculated as 180 + 3 * 40 = 300 seconds. The calculated time difference is compared to the threshold: 289.8 seconds is less than 300 seconds. The judgment logic is valid, indicating that the occupancy behavior of SEAT-A-106 is closely related to SEAT-A-105 in the time dimension, belonging to the same influencing event window. The identifier "UUID-SEAT-A-106" of the subsequent seat component that meets the conditions and its calculated time difference index are recorded, generating a time difference threshold judgment set that includes correlation strength verification.

[0042] S403: Based on the time difference threshold judgment set, locate the seat component that meets the threshold judgment condition, rewrite the personnel number and occupancy status of the corresponding seat component, map the subsequent personnel number to the current seat component and synchronously update the occupancy status identifier, and generate the updated seat record. Based on the output time difference threshold judgment set, the target seat component "SEAT-A-106" that meets the threshold judgment condition is located. The personnel information and status identifier of this component are rewritten to explicitly establish its linkage logic with the preceding component. First, the personnel number "VID-2024-9900" and the original status "Occupied" in the current temporary cache of this seat are retrieved. Since the time difference threshold judgment is passed, it is identified that the occupancy behavior is affected by the preceding seat, and the single "occupancy" status needs to be upgraded to a "linked occupancy" status with sequence information. The database update interface is called to remap the personnel number "VID-2024-9900" to the "Executor" field of the current seat component, and the original status identifier is forcibly overwritten. The status update rule is defined: the new status is equal to the string "Occupied-Linked-" plus the preceding component ID suffix. Specifically, the status is updated to "Occupied-Linked-105", and the calculated time difference of 289.8 seconds is written to the "Association Delay" attribute field. The seat metadata in the electronic map is updated synchronously, and a new record row is generated in the seating control table. All components in the decision set are traversed to complete the rewrite operation. As shown in Table 4, the updated record clarifies the final binding relationship between personnel and seats, as well as the status attributes derived based on time logic. This result demonstrates that the simple spatial adjacency relationship has been successfully transformed into business-related data with temporal logic. SEAT-A-106 is no longer an independent occupancy node, but rather a subsequent linked node marked as the occupancy event of SEAT-A-105, providing a validated data foundation for subsequent accurate billing or collaborative services.

[0043] Table 4. Updated Seat Component Association Status Record Table

[0044] As shown in Table 4, the data reconstruction of SEAT-A-106 was completed, the binding relationship between the person "VID-2024-9900" and the seat component was solidified, and the status label "Occupied-Linked-105" was added to clarify the subordinate position of the seat in the adjustment sequence.

[0045] Please see Figure 6 The specific steps of S5 are as follows: S501: Based on the updated seat records and personnel status timestamp records, extract the personnel number, seat component identifier, and status timestamp fields item by item, perform timestamp sequence comparison on the seat component identifiers associated with the same personnel number, and generate a personnel seat corresponding verification set; Based on the generated "updated seat records" and the pre-stored "personnel status timestamp records" (i.e., entry gate access logs), precise matching and time-series logic verification are performed across tables. First, the updated seat records are traversed to extract core data items: seat component identifier "UUID-SEAT-A-106", mapped personnel number "VID-2024-9900", and the NTP-corrected seat occupancy timestamp 09:50:00.000. Then, using personnel number "VID-2024-9900" as the index key, the personnel status timestamp records are used to retrieve the personnel's entry gate access time. The query returns the personnel's access timestamp at Gate A, 09:42:10.500. A "time-series causality verification logic" is defined: in the physical world, personnel must pass through the gate before occupying a seat; therefore, the gate access time must be earlier than the seat occupancy time. A comparison operation is performed: the two sets of times are converted to millisecond-level integers starting from midnight of the current day for comparison. The gate time corresponds to a millisecond value of 34,930,500 milliseconds (i.e., the total number of milliseconds for 9 hours, 42 minutes, and 10.5 seconds), and the seat time corresponds to a millisecond value of 35,400,000 milliseconds (i.e., the total number of milliseconds for 9 hours, 50 minutes, and 00 seconds). Comparison: The value 34,930,500 is less than 35,400,000, indicating that the logical order of "enter first, then sit" is correct. If the gate time is greater than or equal to the seat time, the record will be marked as a "timing anomaly," and an exception handling subroutine will be triggered. In this example, the verification passes, the associated triplet data is encapsulated, and a preliminary timing-cleaned "personnel seat correspondence verification set" is generated to ensure that subsequent calculations are based on a data foundation consistent with physical logic.

[0046] S502: Based on the personnel seat corresponding verification set, call the corresponding personnel status timestamp and seat component timestamp for each personnel number, perform time difference value calculation, filter the corresponding entries whose time difference does not exceed the time difference verification threshold, and generate a threshold-constrained personnel seat mapping set. Based on the output personnel seat corresponding verification set, a reasonableness verification based on physical movement path is performed for each entry. The gate passage time (09:42:10.500 seconds) and seat occupancy time (09:50:00.000 seconds) corresponding to each personnel number are retrieved, and the time difference is calculated. The calculation process is as follows: First, the second difference is calculated: 0.000 seconds minus 10.500 seconds (requiring borrowing space) results in 60.000 - 10.500 = 49.500 seconds. Second, the minute difference is calculated: 50 minutes becomes 49 minutes after borrowing space, minus 42 minutes equals 7 minutes. Finally, the total time difference is calculated: 7 minutes is converted to seconds (420 seconds), and the second difference of 49.5 seconds is added, resulting in a total passage time of 469.5 seconds. A "time difference verification threshold" is set, based on path analysis in the BIM model: the shortest navigation path distance from the A area ticket gate to the 10th row seat is calculated to be 320 meters. Based on ergonomic standards, the average walking speed was set at 1.2 meters per second. Considering random factors such as crowd congestion, seat searching, and restroom stops, an "action redundancy coefficient" was introduced. Based on historical large-scale event crowd monitoring data, a coefficient of 2.0 was selected with a 95% confidence interval. The threshold was calculated by dividing the path distance by the walking speed and then multiplying by the redundancy coefficient. Specifically, 320 / 1.2 = 266.67 seconds, multiplied by 2.0, yielding a verification threshold of 533.3 seconds. Numerical filtering was performed: the calculated actual travel time of 469.5 seconds was compared with the verification threshold of 533.3 seconds. The result showed that 469.5 was less than 533.3, indicating that the time difference was within a reasonable range and confirmed as valid seating behavior, rather than accidental touches or data drift. All abnormal entries exceeding the threshold were removed, and records conforming to physical constraints were retained, generating a "threshold-constrained personnel seating mapping set."

[0047] S503: Call the threshold constraint personnel seat mapping set, write the correspondence between personnel number and seat component identifier into the component attribute field of the BIM model, perform consistency verification on the written correspondence and summarize the written items to generate the seating information management result; The generated threshold-constrained personnel seating mapping set is invoked to perform the final writing and consistency closed-loop verification of the BIM model data. Using the IFC standard interface, the virtual component object identified as "UUID-SEAT-A-106" in the BIM database is located. The personnel number "VID-2024-9900" is written to the component's "ActorID" custom attribute field, the determined status identifier "Occupied-Linked-105" is written to the "Status" attribute field, and the verified actual seating time "09:50:00" is written to the "LastUpdate" field. Immediately after the writing operation is complete, the "readback verification" procedure is executed: the component's attribute values ​​are reread, and the hash values ​​of the written data and the readback data are calculated. The MD5 hash value of the written data is set to H-write, and the hash value of the readback data is set to H-read. The two are compared: if the two hash values ​​are completely equal, the data persistence is confirmed to be successful and there are no transmission errors. All records in the mapping set are traversed to complete the attribute update of all components. Subsequently, all verified records were compiled to generate a visualized "Seating Information Management Result," as shown in Table 5. This table reflects the final seating arrangement status after multiple logical cleansing and physical constraint verifications. The results demonstrate that dynamic personnel behavior data and static building model data were successfully integrated. Each seating information underwent triple verification for temporal causality, path time rationality, and data write consistency, ensuring a high degree of physical and logical consistency between the seating arrangement displayed on the operation and maintenance management platform and the actual site conditions.

[0048] Table 5 Summary of Seating Information Management Results

[0049] As shown in Table 5, it was finally confirmed that personnel VID-2024-9900 legally occupied seat SEAT-A-106 after a reasonable passage time of 469.5 seconds, and this "linked occupancy" status was solidified into BIM operation and maintenance, completing the entire process from physical perception to digital twin mapping.

[0050] Please see Figure 7 A BIM-based exhibition seating information management system includes: The personnel status module collects the exhibition participants' ID numbers, role attributes, and entry / exit status, extracts status timestamps, compares the current status corresponding to the personnel ID with the historical status timestamps, generates personnel status timestamp records, and transmits them to the seating arrangement determination module. The seating arrangement determination module obtains the seat components corresponding to the personnel number and the seat occupancy timestamp in the BIM model, filters the items whose seat occupancy timestamps do not match the personnel status timestamps, extracts the seat components that need to be adjusted, generates a seating arrangement status determination record, and passes it to the seating sorting module. The seat sorting module obtains the adjacency relationship and row and column order of the seat components that need to be adjusted based on the seat status determination record. Combining the impact of changes in personnel status on the seat occupancy order, it uses a topological sorting algorithm to calculate the seat processing order, constructs a seat adjustment influence chain, and passes it to the seat correction module. The seat correction module sequentially obtains the current occupancy status and associated personnel number of seat components based on the seat adjustment influence chain. When the occupancy timestamp of a subsequent seat is earlier than that of a previous seat, the personnel number and occupancy status of the abnormal seat are rewritten, an updated seat record is generated, and the record is transmitted to the seating arrangement management module. The seating arrangement management module, based on the updated seat records and personnel status timestamp records, verifies the matching order of personnel numbers and seat components and writes them into the BIM model, generating seating arrangement information management results.

[0051] The above are merely specific embodiments of the present invention, but the scope of protection of the present invention is not limited thereto. Any variations or substitutions that can be easily conceived by those skilled in the art within the technical scope disclosed in the present invention should be included within the scope of protection of the present invention. Therefore, the scope of protection of the present invention should be determined by the scope of protection of the described technical solutions.

Claims

1. A BIM-based exhibition seating information management method, characterized in that, Includes the following steps: S1: Collect the exhibition participants' ID numbers, role attributes, and entry / exit status, and extract the status timestamps. Compare the current status corresponding to the participant ID with the historical status timestamps to generate a participant status timestamp record. S2: Obtain the seat components corresponding to the personnel number and the seat occupancy timestamp in the BIM model, filter the entries whose seat occupancy timestamps do not match the personnel status timestamps, extract the seat components that need to be adjusted, and generate a seating arrangement status determination record. S3: Based on the seating status determination record, obtain the adjacency relationship and row and column order of the seat components that need to be adjusted, combine the influence of personnel status changes on seat occupancy order, use the topological sorting algorithm to calculate the seat processing order, and construct the seat adjustment influence chain; S4: Based on the seat adjustment influence chain, obtain the current occupancy status of the seat component and the associated personnel number in sequence. If the subsequent seat occupancy timestamp is earlier than the previous seat occupancy timestamp, rewrite the abnormal seat personnel number and occupancy status, and generate the updated seat record. S5: Based on the updated seat record and the personnel status timestamp record, verify the matching order of personnel number and seat component and write it into the BIM model to generate the seating information management result.

2. The BIM-based exhibition seating information management method according to claim 1, characterized in that, The personnel status timestamp record includes a personnel number index table, role attribute identifier, and entry / exit status identifier. The seating status determination record includes a seat component identifier, personnel number association item, occupancy time comparison mark, and adjustment request identifier. The seating adjustment influence chain includes adjacent relationship topology pairs, row and column order index, and processing priority sequence. The updated seating record includes the corrected personnel number, occupancy status flag, and update timestamp item. The seating information management result includes BIM component attribute mapping item, seating effective time identifier, and model consistency verification mark.

3. The exhibition seating arrangement information management method based on BIM according to claim 1, characterized in that, The specific steps of S1 are as follows: S101: Collect the exhibition participants’ IDs, role attributes and entry / exit status information, perform time-series detection on the entry / exit status change points and mark the time of the status occurrence, arrange the multiple status marks under the same person ID, and generate a personnel status timestamp sequence. S102: Based on the personnel status timestamp sequence, call the current entry / exit status value of the corresponding personnel number, compare it with the most recent status timestamp record under the number, determine whether the status has been updated, and mark the status change node to obtain the personnel status sequence comparison mark set; S103: Based on the personnel status sequence comparison mark set, number the identified personnel, integrate their current status value with the corresponding timestamp, perform status and time mapping and complete structured reorganization to generate personnel status timestamp records.

4. The BIM-based exhibition seating information management method according to claim 1, characterized in that, The specific steps of S2 are as follows: S201: Obtain the seat component corresponding to the personnel number and the seat occupancy timestamp in the BIM model, verify the consistency between the seat component identifier and the personnel number, organize the start and end times of seat occupancy under the same personnel number and map the time to the seat component, and generate a seat occupancy timestamp sequence. S202: Based on the seat occupancy timestamp sequence, call the personnel status timestamp record, compare the seat occupancy timestamp and the personnel entry / exit status timestamp under the same personnel number item by item, determine the overlap relationship between the occupancy interval and the status interval, record the items that do not meet the preset time consistency condition, and obtain the seat status comparison identifier set; S203: Based on the seat status comparison identifier set, perform a filtering operation on the identified seat components, integrate the comparison results of the corresponding personnel number, seat component identifier and timestamp, and generate a seat status determination record.

5. The BIM-based exhibition seating information management method according to claim 1, characterized in that, The specific steps for S3 are as follows: S301: Based on the seating status determination record, extract the seat components that need to be adjusted, perform sequential comparison on adjacent seat components under the same row and column number, analyze the adjacent pointing relationship according to the numerical increment relationship of row number and column number, and form front and back association labels for each seat component to generate a set of adjacent relationships of seat components. S302: Based on the set of adjacent relationships of the seat components, call the time sequence record corresponding to the personnel status change, map the personnel entry and exit status to the associated seat components, compare the occupancy order of adjacent seat components, use the topological sorting algorithm to perform sorting calculation, and generate a seat processing order sequence. S303: Based on the seat processing sequence, sequentially connect the preceding and subsequent relationships of seat components with sequential dependencies, and construct an influence chain by combining the seat adjacency relationship to generate a seat adjustment influence chain.

6. The BIM-based exhibition seating information management method according to claim 1, characterized in that, The specific steps of S4 are as follows: S401: Obtain each seat component in the seat adjustment influence chain, collect the corresponding current occupancy status, associated personnel number and occupancy timestamp one by one according to the existing seat component identifier, perform unified time correction and sorting on the collected timestamps, and generate a seat component occupancy time record set; S402: Based on the seat component occupancy time record set, extract the occupancy timestamps of adjacent seat components, subtract the occupancy timestamp of the preceding seat from the occupancy timestamp of the subsequent seat to obtain the time difference algebra, and when the time difference algebra does not reach the occupancy time difference threshold, record the corresponding seat component identifier and generate a time difference threshold judgment set. S403: Based on the time difference threshold determination set, locate the seat component that meets the threshold determination condition, rewrite the personnel number and occupancy status of the corresponding seat component, map the subsequent personnel number to the current seat component and synchronously update the occupancy status identifier, and generate the updated seat record.

7. A BIM-based exhibition seating information management method according to claim 6, characterized in that, The occupancy time difference threshold is determined by statistically analyzing the occupancy timestamp sequence of seat components collected within the same business cycle. First, the occupancy time difference of adjacent seat components is numerically calculated to form a time difference distribution set. Then, the time difference values ​​in the set are sorted and divided into intervals. The first quartile value located in the first 25% of the numerical sequence after sorting is extracted and determined.

8. The BIM-based exhibition seating information management method according to claim 1, characterized in that, The specific steps of S5 are as follows: S501: Based on the updated seat record and the personnel status timestamp record, extract the personnel number, seat component identifier, and status timestamp fields item by item, perform timestamp sequence comparison on the seat component identifier associated with the same personnel number, and generate a personnel seat corresponding verification set; S502: Based on the personnel seat corresponding verification set, call the corresponding personnel status timestamp and seat component timestamp for each personnel number, perform time difference calculation, filter the corresponding entries whose time difference does not exceed the time difference verification threshold, and generate a threshold-constrained personnel seat mapping set. S503: Call the threshold constraint personnel seat mapping set, write the correspondence between personnel number and seat component identifier into the component attribute field of the BIM model, perform consistency verification on the written correspondence and summarize the written items to generate the seating information management result.

9. A BIM-based exhibition seating information management method according to claim 8, characterized in that, The time difference verification threshold is determined by statistically analyzing the time difference distribution between historical personnel status timestamp records and seat component timestamps, extracting time difference data corresponding to all personnel and seats, forming a time difference sequence, sorting it, and analyzing the statistical characteristic boundary value of the time difference sequence.

10. A BIM-based exhibition seating information management system, characterized in that, The system is used to implement the BIM-based exhibition seating information management method according to any one of claims 1-9, and the system includes: The personnel status module collects the exhibition participants' ID numbers, role attributes, and entry / exit status, extracts status timestamps, compares the current status corresponding to the personnel ID with the historical status timestamps, generates personnel status timestamp records, and transmits them to the seating arrangement determination module. The seating arrangement determination module obtains the seat components corresponding to the personnel number and the seat occupancy timestamp in the BIM model, filters the entries whose seat occupancy timestamps do not match the personnel status timestamps, extracts the seat components that need to be adjusted, generates a seating arrangement status determination record, and transmits it to the seating sorting module. The seat sorting module obtains the adjacency relationship and row and column order of the seat components that need to be adjusted based on the seat status determination record. Combining the impact of changes in personnel status on the seat occupancy order, it uses a topological sorting algorithm to calculate the seat processing order, constructs a seat adjustment influence chain, and transmits it to the seat correction module. The seat correction module sequentially obtains the current occupancy status and associated personnel number of the seat component based on the seat adjustment influence chain. When the occupancy timestamp of the subsequent seat is earlier than that of the preceding seat, it rewrites the personnel number and occupancy status of the abnormal seat, generates an updated seat record, and transmits it to the seating arrangement management module. The seating arrangement management module, based on the updated seat records and the personnel status timestamp records, verifies the matching order between personnel numbers and seat components and writes them into the BIM model, generating seating arrangement information management results.