Complementation delivery data model mapping rule method based on digital twinning

Abstract

The invention provides a digital twinning-based completion delivery data model mapping rule method. Relates to the technical field of engineering data processing. The key point of the invention lies in that seamless connection and accurate tracking of equipment from a construction period to an operation and maintenance period are realized by constructing and managing an equipment unique identifier and an equipment information mapping table. And the consistency and the traceability of the equipment data are guaranteed by dynamically managing the mapping relation of the equipment ID through an incremental updating mechanism and a mapping table. In addition, the invention further provides a construction and maintenance data translation method for equipment position conversion and semantic mapping, it is ensured that equipment information in the construction period can be accurately transmitted to the operation and maintenance period, and the operation and maintenance data processing process is optimized through rule screening and entity mapping. A core point to be protected comprises a generation and management mechanism of an equipment ID, a structural design of a mapping table, a translation and screening method of equipment information and a technical scheme of attribute processing in an entity mapping process.

Description

Technical Field

[0001] The present invention relates to the technical field of engineering data processing, and in particular to a completion delivery data model mapping rule method based on digital twins. Background Art

[0002] Railway engineering construction plays an important role in my country's modernization process, and informatization plays an increasingly important role in the modernization of railway engineering construction. At present, digital twin technology plays an important role in supporting railway engineering construction and operation and maintenance, and has become an important tool for the full life cycle management of railway equipment. However, in actual applications, there are still problems such as low utilization of digital twin construction period data in the operation and maintenance stage and difficulty in information translation. Specifically, there are currently problems such as the difficulty of effectively transmitting construction period data to the operation and maintenance stage, and the complex and error-prone information translation process. In addition, the traditional manual information storage method not only has a slow update speed and is difficult to guarantee accuracy, but also cannot achieve efficient information interaction across platforms.

[0003] At present, the research on the technical fields of information translation and interactive application of railway engineering equipment in the construction and operation periods in my country is still in its early stages, and the relevant theoretical and methodological systems are still imperfect. Therefore, in-depth exploration of information translation and interactive application technology and promoting the further development of railway engineering equipment management informatization are the key to achieving the timeliness of railway engineering equipment information transmission and improving management efficiency and quality. Summary of the invention

[0004] The purpose of the present invention is to solve the above-mentioned problems and provide a completion delivery data model mapping rule method based on digital twins.

[0005] To achieve the above object, the technical solution adopted by the present invention is:

[0006] According to one aspect of the present invention, a method for mapping rules of a completion delivery data model based on digital twins is provided, comprising:

[0007] Step 1: Generate a unique device ID

[0008] In the BIM model, each device has an equipment ID attribute, the value of which is the unique identifier of the device. During the life cycle of the device, the equipment ID is always associated with the device. The equipment ID consists of multiple parts to ensure its uniqueness and validity.

[0009] Step 2: Device ID Dynamic Tracking

[0010] Dynamically track device ID mapping relationships through an incremental update mechanism, and automatically update device ID mappings through triggers and scheduled tasks;

[0011] First, the trigger automatically updates the mapping table when the device status changes;

[0012] Secondly, the scheduled task periodically checks the device status changes and updates the mapping relationship regularly;

[0013] In addition, unique constraints and version control are introduced. By adding unique constraints to the DeviceMapping table, the uniqueness of each mapping record is ensured to avoid repeated insertion of device ID mapping data. At the same time, a version number field is added to the mapping table to retain historical records when the device ID mapping relationship changes, which is convenient for tracing and backtracking.

[0014] Step 3: Build and store the mapping table

[0015] Build a mapping table named "DeviceMapping" and store it in the relational database MySQL to associate the equipment information during the construction period with the equipment information during the operation and maintenance period. Each record in the table contains the equipment ID, equipment name, IFD code, attribute information, equipment status of the equipment during the construction period and the corresponding equipment ID, equipment name, IFD code, attribute information, equipment status of the equipment during the operation and maintenance period.

[0016] Use unique constraints to ensure the uniqueness of each device identifier and ensure accurate mapping of device information. In actual operations, use SQL commands to insert, update, and query data.

[0017] Step 4: Device location conversion

[0018] According to the origin and direction of the independent coordinate system defined in the BIM model file during the construction period, the translation and rotation matrices of the independent coordinate system relative to the world coordinate system are calculated. For the independent coordinates of each point, the translation and rotation matrices are applied to convert them into coordinates in the world coordinate system. Specifically, the independent coordinates of each point can be regarded as a vector, and then the vector is multiplied by the translation and rotation matrix to obtain its coordinates in the world coordinate system, as shown in formula (1).

[0019] (1)

[0020] Among them, vector C represents the coordinates of the operation and maintenance period, vector I represents the coordinates of the construction period, and the transformation matrix M of the coordinate system can be calculated by the origin of the independent coordinates and the direction of the coordinate axis given in the BIM model file of the construction period;

[0021] The three parameters in the construction period model file are the coordinates of the origin, the direction of the z-axis, and the direction of the x-axis. The calculation method of the M matrix is ​​shown in formula (2):

[0022] (2)

[0023] Step 5: Data screening

[0024] Based on the mapping table, automatically exclude equipment that no longer needs maintenance during the operation and maintenance period;

[0025] Automatically filter device data through rule-based data filtering methods. Regular expressions match device description, status and other fields based on specific patterns.

[0026] Step 6: Entity mapping and attribute addition

[0027] Use the established mapping table to implement entity mapping in the MySQL database. The mapping relationship is divided into two cases: one-to-one mapping and one-to-many mapping;

[0028] If it is a one-to-one mapping, the construction period entity contains only one value, while the one-to-many mapping uses commas to separate multiple values. Traverse the query results and distinguish the mapping type by checking the content of the construction period entity. The one-to-one mapping can directly map the construction period entity to the operation and maintenance period entity;

[0029] For one-to-many mapping, it is necessary to split the equipment entities in the operation and maintenance period and map the entities in the construction period to each of the split entities to ensure that the entities in the construction period can be accurately mapped to the entities in the operation and maintenance period.

[0030] Furthermore, the detailed process and steps of the data screening method in step 5 are as follows:

[0031] (1) Clarify the screening target

[0032] The main concern is whether the equipment is buried underground, which affects its availability, maintainability, etc. Missing equipment refers to whether the equipment is missing or incomplete in the records, making subsequent processing impossible;

[0033] (2) Data collection

[0034] Collect and organize the data of equipment during the construction period, including: equipment name, number, installation location, equipment type, specification, installation status and other relevant data;

[0035] (3) Data cleaning

[0036] Missing device data needs to be marked or deleted to avoid affecting the accuracy of subsequent screening. At the same time, duplicate data should be removed to ensure that each device is recorded only once, thereby maintaining the uniqueness and reliability of the data. In addition, all data formats should be unified to avoid problems in screening due to inconsistent formats.

[0037] (4) Data preprocessing

[0038] After cleaning the data, data preprocessing is required to facilitate the application of subsequent screening rules. First, the text descriptions of the equipment status or location are coded, for example, "buried underground" is marked as 1, and "above-ground installation" is marked as 0; for missing data, such as records of equipment not being installed or not yet on site, it is necessary to mark them as missing items in the data so that they can be accurately identified and processed during the screening process;

[0039] (5) Define filtering rules

[0040] According to the mapping table stored in advance, the "location" field in the data is compared with the "buried underground" status based on whether the equipment is buried underground and the missing status as the screening rule, and all records with the code 1 are screened out; all equipment with the installation status of "missing" or records with missing information such as equipment number and model are screened out;

[0041] (6) Apply filtering rules

[0042] According to the defined filtering rules, the data is actually filtered. Since the data is stored in the MySQL database, SQL statements are used for filtering;

[0043] (7) Result verification and screening confirmation

[0044] Check the screening results through cross-validation method to ensure the consistency of the screening results;

[0045] Finally, the filtered data is exported to Excel format, which corresponds to the equipment data during the operation and maintenance period.

[0046] Furthermore, in the entity mapping process of step six, it is also necessary to delete the attributes not needed in the operation and maintenance period and add the required attribute information. First, connect to the MySQL database to obtain the attribute data of the construction period entity and its mapping table; then, initialize the data structure to store the operation and maintenance period entity and its attributes;

[0047] When traversing each construction period entity, find the corresponding operation period entity according to the mapping table, check and remove all attributes that are not in the attribute list required for the operation period, and add the missing attributes to ensure that each operation period entity has the required attributes. If missing, assign default values ​​to it or obtain values ​​from other data sources; finally, the updated operation period entity attribute data is saved or returned for subsequent processing;

[0048] The specific steps to add attributes are as follows:

[0049] (1) Connect to the database and obtain data: Connect to the MySQL database to obtain the mapping table and attribute data of the construction period entity;

[0050] (2) Initialize the data structure: Create an Excel file to store the operation and maintenance period entities and their attributes;

[0051] (3) Traversing the construction period entity data: For each construction period entity, find the corresponding operation and maintenance period entity according to the mapping table;

[0052] (4) Attribute deletion: Check the attributes of the entity during the construction period and delete the attribute information of the equipment in the list that is not needed during the operation and maintenance period;

[0053] (5) Attribute addition: For each construction period entity, add the attribute information that is missing during the operation and maintenance period, and assign default values ​​to these attributes or obtain values ​​from other data sources;

[0054] (6) Save or return results: Save the updated file to the database.

[0055] Compared with the prior art, the present invention has the following beneficial effects:

[0056] The technical solution of the present invention realizes seamless connection and accurate tracking of equipment from the construction period to the operation and maintenance period by constructing an equipment ID management mechanism and an equipment information mapping table. The uniqueness and phased management of the equipment ID ensure the accuracy and effectiveness of equipment information throughout the life cycle, reduce human intervention, and improve data reliability. Through the incremental update mechanism and rule-based data screening method, equipment information can be dynamically tracked and updated, while accurately eliminating equipment data that is no longer needed, providing a reliable basis for operation and maintenance decisions. The conversion and semantic mapping of equipment locations enable efficient transmission and utilization of equipment information between different management stages, effectively supporting the refined management and operation and maintenance optimization of equipment. DETAILED DESCRIPTION

[0057] In order to make the technical means, creative features, objectives and effects achieved by the present invention easy to understand, the present invention is further explained below in conjunction with specific implementation methods.

[0058] The present invention proposes a method for mapping rules of completion delivery data model based on digital twin, which includes the following key steps:

[0059] Step 1: Generate a unique device ID

[0060] In the BIM model, each device has an equipment ID attribute, the value of which is the unique identifier of the device. The equipment ID is always associated with the device during its life cycle. The equipment ID consists of multiple parts to ensure its uniqueness and validity.

[0061] The equipment ID is generated in the format of "project number-equipment type-serial number-equipment location", where the project number identifies the specific engineering project to which the equipment belongs, making it easier to distinguish and trace in a cross-project environment. The equipment type specifies the type or category of the equipment, which helps to quickly identify the functional characteristics and technical specifications of the equipment. The serial number can be used to provide sequence distinction between equipment of the same type and in the same location, ensuring accurate identification even in highly similar or repeated equipment configurations. The equipment location records the specific installation location of the equipment in detail, facilitating spatial layout management and maintenance work positioning. For example, if the IDF code of a signal is 53-14 40 10, the equipment ID "S1-53-14-40-10-K150+200" can be generated for it based on its relevant attribute information, where S1 represents the project engineering number; 53-14-40-10 is the model and serial number of the signal, helping to quickly identify the basic information of the signal; and K150+200 identifies the specific location of the signal.

[0062] In order to ensure the consistency and accuracy of the equipment ID throughout its life cycle, its management process needs to follow strict phase division and operating specifications. First, in the allocation phase, the equipment ID should be allocated at the beginning of the formal inclusion of the equipment in the project management. This step is the starting point for entering and tracking equipment information. Secondly, in the change phase, when the equipment is replaced or the key information of the equipment (such as type, location) changes, the equipment ID needs to be updated in a timely manner to reflect the latest status of the equipment and maintain the timeliness and accuracy of the information. Finally, in the deletion phase, the corresponding equipment ID should be removed from the system after the equipment is scrapped to avoid confusion and accumulation of invalid data. Through these standardized management steps, the accuracy and consistency of the equipment ID throughout its life cycle are ensured.

[0063] Step 2: Device ID Dynamic Tracking

[0064] In the present invention, the device ID mapping relationship is dynamically tracked through an incremental update mechanism, thereby ensuring that the device ID mapping information from the construction period to the operation and maintenance period is always kept up to date and accurate. The mechanism mainly uses triggers and schedulers to automatically update device ID mappings.

[0065] First, the trigger automatically updates the mapping table when the device status changes. For example, when the device enters the operation and maintenance period from the construction period, the trigger can monitor the changes in the device status table (such as DeviceStatus). If the device status changes from "construction period" to "operation and maintenance period", a new ID mapping record is automatically inserted into the DeviceMapping table. The trigger can ensure that whenever the device status changes, the relevant device ID mapping relationship can be updated in real time, avoiding manual intervention.

[0066] Secondly, the scheduled task periodically checks the device status changes and updates the mapping relationship regularly. For example, you can set a scheduled task to check the device status changes every hour and automatically map all device IDs in the "operation and maintenance period" state to the DeviceMapping table. This ensures that the system can synchronize the device ID mapping information in time when the device status changes.

[0067] In addition, to prevent mapping conflicts and maintain the integrity of historical data, unique constraints and version control can be introduced. By adding a unique constraint to the DeviceMapping table, the uniqueness of each mapping record is ensured to avoid repeated insertion of device ID mapping data. At the same time, adding a version number field to the mapping table can retain historical records when the device ID mapping relationship changes, which is convenient for tracing and backtracking.

[0068] Step 3: Build and store the mapping table

[0069] Equipment information mapping is a key link in the management of the entire life cycle of equipment, especially when the equipment enters the operation and maintenance period from the construction period. Due to different management methods and functional requirements, there are large differences in basic data classification, grading, granularity, and attribute information. Therefore, it is necessary to establish a corresponding mapping relationship to ensure the consistency and traceability of equipment information from the construction period to the operation and maintenance period.

[0070] In the present invention, by constructing a mapping table named "DeviceMapping" and storing it in the relational database MySQL, the equipment information of the construction period is associated with the equipment information of the operation and maintenance period. Each record in the table contains the equipment ID, equipment name, IFD code, attribute information, equipment status of the construction period equipment and the corresponding operation and maintenance period equipment and the corresponding operation and maintenance period equipment identifier, equipment name, IFD code, attribute information, equipment status. The mapping table ensures seamless connection and accurate tracking of equipment information. The structure of the mapping table is designed as follows:

[0071]

[0072] Use the unique constraint (UNIQUE) to ensure the uniqueness of each device identifier and ensure accurate mapping of device information. In actual operation, use SQL commands to insert, update, and query data. For example, use the insert command to associate the device IDs during the construction period and the operation and maintenance period.

[0073] INSERT INTO DeviceMapping (construction_id, operation_id)

[0074] VALUES ('construction_id_example_1', 'operation_id_example_1');

[0075] Step 4: Device location conversion

[0076] During the construction period, the equipment location is usually accurately marked with an independent coordinate system using relative coordinates, such as "line number-kilometer mark-specific location description", while during the operation and maintenance period, standardized three-dimensional coordinates are usually used to determine the location of the equipment using degrees of latitude and longitude.

[0077] According to the origin and direction of the independent coordinate system defined in the construction period BIM model file, the translation and rotation matrix of the independent coordinate system relative to the world coordinate system is calculated. For each point's independent coordinate, the translation and rotation matrix is ​​applied to convert it into the coordinate in the world coordinate system. Specifically, the independent coordinate of each point can be regarded as a vector, and then this

[0078] Multiplying a vector by the translation and rotation matrices gives its coordinates in the world coordinate system, as shown in formula (1).

[0079] (1)

[0080] Among them, vector C represents the coordinates of the operation and maintenance period, vector I represents the coordinates of the construction period, and the transformation matrix M of the coordinate system can be calculated by the origin of the independent coordinates and the direction of the coordinate axis given in the BIM model file of the construction period. The three parameters in the model file of the construction period are the coordinates of the origin, the direction of the z-axis, and the direction of the x-axis. The calculation method of the M matrix is ​​shown in formula (2).

[0081] (2)

[0082] Step 5: Data screening

[0083] In the operation and maintenance management stage of railway engineering equipment, in order to ensure the scientificity and reliability of equipment status analysis, maintenance decision-making and resource allocation, it is necessary to automatically screen out equipment information that meets the use conditions during the operation and maintenance period. Since some equipment during the construction period is buried underground or used as a temporary support structure, the information of these equipment may no longer be needed during the operation and maintenance period. Therefore, the present invention proposes a rule-based data screening method, which automatically excludes equipment that no longer needs to be repaired during the operation and maintenance period based on a mapping table.

[0084] Automatically filter device data through rule-based data filtering methods. Regular expressions match device descriptions, status and other fields based on specific patterns (such as device status or keywords), thereby accurately identifying and excluding device information that does not meet expectations, ensuring the efficiency and accuracy of the screening results, and providing a reliable data foundation for subsequent analysis and decision-making.

[0085] Taking the data of a station during construction as an example, the detailed process and steps of the data screening method are as follows:

[0086] (1) Clarify the screening target

[0087] The main concern is whether the equipment is buried underground, which affects its availability, maintainability, etc. Missing equipment refers to whether the equipment is missing or incomplete in the records, making subsequent processing impossible.

[0088] (2) Data collection

[0089] Collect and organize the data of equipment during the construction period, including: equipment name, number, installation location (whether underground), equipment type, specification, installation status (whether installed, whether missing), and other relevant data (such as equipment health status, maintenance records, etc.)

[0090] (3) Data cleaning

[0091] Missing device data needs to be marked or deleted to avoid affecting the accuracy of subsequent screening; at the same time, duplicate data should be removed to ensure that each device is recorded only once, thereby maintaining the uniqueness and reliability of the data. In addition, all data formats should be unified to avoid problems in screening due to inconsistent formats.

[0092] (4) Data preprocessing

[0093] After cleaning the data, data preprocessing is required to facilitate the application of subsequent screening rules. First, the text descriptions such as the equipment status or location are coded, for example, "buried underground" is marked as 1, and "above ground installation" is marked as 0. For missing data, such as records that the equipment has not been installed or has not yet entered the site, it is necessary to mark it as missing in the data so that it can be accurately identified and processed during the screening process.

[0094] (5) Define filtering rules

[0095] According to the mapping table stored in advance, the "location" field in the data is compared with the "buried underground" status based on whether the equipment is buried underground and the missing status, and all records with the code 1 are screened out. All equipment with an installation status of "missing" or records with missing information such as equipment number and model are screened out.

[0096] (6) Apply filtering rules

[0097] According to the defined filtering rules, the data is actually filtered. Since the data is stored in the MySQL database, SQL statements are used for filtering. For example:

[0098] SELECT * FROM equipment WHERE status = '0' AND missing = 0;

[0099] (7) Result verification and screening confirmation

[0100] Through the cross-validation method, the screening results were checked to ensure that the screening results were consistent.

[0101] Finally, the filtered data is exported to Excel format, which corresponds to the equipment data during the operation and maintenance period.

[0102] Step 6: Entity mapping and attribute addition

[0103] The entity is the carrier of information exchange from the construction period to the operation and maintenance period. In the present invention, the established mapping table is used to realize the mapping of the entity in the MySQL database. The mapping relationship is divided into two cases: one-to-one mapping and one-to-many mapping. Use a suitable database to connect to the MySQL database and execute a query to extract the data in the mapping table. If it is a one-to-one mapping, the construction period entity contains only one value, while the one-to-many mapping uses commas to separate multiple values. Traverse the query results and distinguish the mapping type by checking the content of the construction period entity. One-to-one mapping can directly map the construction period entity to the operation and maintenance period entity. For one-to-many mapping, the operation and maintenance period equipment entity needs to be split, and the construction period entity is mapped to each split entity. Ensure that the construction period entity can be accurately mapped to the operation and maintenance period entity.

[0104] In the entity mapping process, it is also necessary to deal with the differences in the attributes of the construction period and the operation and maintenance period entities, that is, to delete the attributes not required in the operation and maintenance period and add the required attribute information. First, connect to the MySQL database to obtain the attribute data of the construction period entity and its mapping table. Then, initialize the data structure to store the operation and maintenance period entities and their attributes.

[0105] When traversing each construction period entity, find the corresponding operation period entity according to the mapping table, check and remove all attributes that are not in the attribute list required for the operation period. Add the missing attributes to ensure that each operation period entity has the required attributes. If missing, assign default values ​​or obtain values ​​from other data sources. Finally, the updated operation period entity attribute data is saved or returned for subsequent processing. Ensure the accuracy and completeness of entity attributes at different stages.

[0106] The specific steps to add attributes are as follows:

[0107] (1) Connect to the database and obtain data: Connect to the MySQL database to obtain the mapping table and attribute data of the construction period entity.

[0108] (2) Initialize the data structure: Create an Excel file to store the operation and maintenance period entities and their attributes.

[0109] (3) Traversing the construction period entity data: For each construction period entity, find the corresponding operation and maintenance period entity according to the mapping table.

[0110] (4) Attribute deletion: Check the attributes of the entity during the construction period and delete the attribute information in the list that is not needed for the device during the operation and maintenance period.

[0111] (5) Attribute addition: For each construction period entity, add the attribute information that is missing during the operation and maintenance period, and assign default values ​​to these attributes or obtain values ​​from other data sources.

[0112] (6) Save or return results: Save the updated file to the database.

[0113] It will be apparent to those skilled in the art that the present invention is not limited to the details of the exemplary embodiments described above and that the present invention can be implemented in other specific forms without departing from the spirit or essential features of the present invention. Therefore, the embodiments should be considered exemplary and non-restrictive in all respects, and the scope of the present invention is defined by the appended claims rather than the above description, and it is intended that all changes falling within the meaning and scope of the equivalent elements of the claims be included in the present invention.

[0114] In addition, it should be understood that although the present specification is described according to implementation modes, not every implementation mode contains only one independent technical solution. This description of the specification is only for the sake of clarity. Those skilled in the art should regard the specification as a whole. The technical solutions in each embodiment may also be appropriately combined to form other implementation modes that can be understood by those skilled in the art.

Claims

1. A method for mapping rules of completion delivery data model based on digital twin, characterized by: include Step 1: Generate a unique device ID In the BIM model, each device has an equipment ID attribute, the value of which is the unique identifier of the device. During the life cycle of the device, the equipment ID is always associated with the device. The equipment ID consists of multiple parts to ensure its uniqueness and validity. Step 2: Device ID Dynamic Tracking Dynamically track device ID mapping relationships through an incremental update mechanism, and automatically update device ID mappings through triggers and scheduled tasks; First, the trigger automatically updates the mapping table when the device status changes; Secondly, the scheduled task periodically checks the device status changes and updates the mapping relationship regularly; In addition, unique constraints and version control are introduced. By adding unique constraints to the DeviceMapping table, the uniqueness of each mapping record is ensured to avoid repeated insertion of device ID mapping data. At the same time, a version number field is added to the mapping table to retain historical records when the device ID mapping relationship changes, which is convenient for tracing and backtracking. Step 3: Build and store the mapping table Build a mapping table named "DeviceMapping" and store it in the relational database MySQL to associate the equipment information during the construction period with the equipment information during the operation and maintenance period. Each record in the table contains the equipment ID, equipment name, IFD code, attribute information, equipment status of the equipment during the construction period and the corresponding equipment ID, equipment name, IFD code, attribute information, equipment status of the equipment during the operation and maintenance period. Use unique constraints to ensure the uniqueness of each device identifier and ensure accurate mapping of device information. In actual operations, use SQL commands to insert, update, and query data. Step 4: Device location conversion According to the origin and direction of the independent coordinate system defined in the BIM model file during the construction period, the translation and rotation matrices of the independent coordinate system relative to the world coordinate system are calculated. For the independent coordinates of each point, the translation and rotation matrices are applied to convert them into coordinates in the world coordinate system. Specifically, the independent coordinates of each point can be regarded as a vector, and then the vector is multiplied by the translation and rotation matrix to obtain its coordinates in the world coordinate system, as shown in formula (1). (1) Among them, vector C represents the coordinates of the operation and maintenance period, vector I represents the coordinates of the construction period, and the transformation matrix M of the coordinate system can be calculated by the origin of the independent coordinates and the direction of the coordinate axis given in the BIM model file of the construction period; The three parameters in the construction period model file are the coordinates of the origin, the direction of the z-axis, and the direction of the x-axis. The calculation method of the M matrix is ​​shown in formula (2): (2) Step 5: Data screening Based on the mapping table, automatically exclude equipment that no longer needs maintenance during the operation and maintenance period; Automatically filter device data through rule-based data filtering methods. Regular expressions match device description, status and other fields based on specific patterns. Step 6: Entity mapping and attribute addition Use the established mapping table to implement entity mapping in the MySQL database. The mapping relationship is divided into two cases: one-to-one mapping and one-to-many mapping; If it is a one-to-one mapping, the construction period entity contains only one value, while the one-to-many mapping uses commas to separate multiple values. Traverse the query results and distinguish the mapping type by checking the content of the construction period entity. The one-to-one mapping can directly map the construction period entity to the operation and maintenance period entity; For one-to-many mapping, it is necessary to split the equipment entities in the operation and maintenance period and map the entities in the construction period to each of the split entities to ensure that the entities in the construction period can be accurately mapped to the entities in the operation and maintenance period.

2. According to the method for mapping rules of completion delivery data model based on digital twins according to claim 1, it is characterized by: The detailed process and steps of the data screening method in step 5 are as follows: (1) Clarify the screening target The main focus is on whether the equipment is buried underground, which affects its availability, maintainability, etc.; missing equipment refers to whether the equipment is missing or incomplete in the records, making subsequent processing impossible; (2) Data collection Collect and organize the data of equipment during the construction period, including: equipment name, number, installation location, equipment type, specification, installation status and other relevant data; (3) Data cleaning Missing device data needs to be marked or deleted to avoid affecting the accuracy of subsequent screening. At the same time, duplicate data should be removed to ensure that each device is recorded only once, thereby maintaining the uniqueness and reliability of the data. In addition, all data formats should be unified to avoid problems in screening due to inconsistent formats. (4) Data preprocessing After cleaning the data, data preprocessing is required to facilitate the application of subsequent screening rules. First, the text descriptions such as the equipment status or location are coded, for example, "buried underground" is marked as 1, and "above ground installation" is marked as 0; for missing data, such as records that the equipment has not been installed or has not yet entered the site, it is necessary to mark it as missing in the data so that it can be accurately identified and processed during the screening process; (5) Define filtering rules According to the mapping table stored in advance, the "location" field in the data is compared with the "buried underground" status based on whether the equipment is buried underground and the missing status as the screening rules, and all records with the code 1 are screened out; all equipment with the installation status of "missing" or records with missing information such as equipment number and model are screened out; (6) Apply filtering rules According to the defined filtering rules, the data is actually filtered. Since the data is stored in the MySQL database, SQL statements are used for filtering; (7) Result verification and screening confirmation Check the screening results through cross-validation method to ensure the consistency of the screening results; Finally, the filtered data is exported to Excel format, which corresponds to the equipment data during the operation and maintenance period.

3. According to a digital twin-based completion delivery data model mapping rule method according to claim 1, it is characterized by: In the entity mapping process of step 6, it is also necessary to delete the attributes not needed in the operation and maintenance period and add the required attribute information. First, connect to the MySQL database to obtain the attribute data of the construction period entity and its mapping table; then, initialize the data structure to store the operation and maintenance period entity and its attributes; When traversing each construction period entity, find the corresponding operation period entity according to the mapping table, check and remove all attributes that are not in the attribute list required for the operation period, and add the missing attributes to ensure that each operation period entity has the required attributes. If missing, assign default values ​​to it or obtain values ​​from other data sources; finally, the updated operation period entity attribute data is saved or returned for subsequent processing; The specific steps to add attributes are as follows: (1) Connect to the database and obtain data: Connect to the MySQL database to obtain the mapping table and attribute data of the construction period entity; (2) Initialize the data structure: Create an Excel file to store the operation and maintenance period entities and their attributes; (3) Traversing the construction period entity data: For each construction period entity, find the corresponding operation and maintenance period entity according to the mapping table; (4) Attribute deletion: Check the attributes of the entity during the construction period and delete the attribute information of the equipment in the list that is not needed during the operation and maintenance period; (5) Attribute addition: For each construction period entity, add the attribute information that is missing during the operation and maintenance period, and assign default values ​​to these attributes or obtain values ​​from other data sources; (6) Save or return results: Save the updated file to the database.

Images