Attribute mapping table construction method, device and equipment

Abstract

A kind of attribute mapping table construction method, device and medium, including the attribute table corresponding to different types of model attribute in three-dimensional design model is respectively created based on, and multiple attribute mapping relations are created, the model attribute data corresponding to three-dimensional design model obtained from different three-dimensional design software, according to multiple attribute mapping relations, model attribute data is imported into attribute table, and attribute management table is obtained.Attribute value conversion rule is constructed according to multiple different types of model attribute and model attribute data, corresponding attribute predefinition rule is constructed according to multiple different types of model attribute, and attribute mapping table is constructed based on attribute management table, attribute value conversion rule and attribute predefinition rule.It is solved that the technical problem of lower efficiency in data integration and unification of model attribute data in different three-dimensional design models.

Description

Technical Field

[0001] This invention relates to the field of data processing technology, and specifically to a method, apparatus, and device for constructing an attribute mapping table. Background Technology

[0002] The industrial software field encompasses various 3D design software, such as PDMS, Revit, and Bentley. Each 3D design software has its unique model format and attribute naming conventions. This makes it difficult to manage model design attribute data from different sources within the same system. Due to the different attribute naming conventions, data cannot be directly imported into the system and requires manual operation. Data must be organized according to the same format and attribute field naming conventions before it can be uploaded, resulting in low efficiency. Summary of the Invention

[0003] The main technical problem this invention addresses is the low efficiency of integrating and unifying model attribute data from different 3D design models.

[0004] According to the first aspect, one embodiment provides a method for constructing an attribute mapping table, including:

[0005] Obtain multiple different types of model attributes from a 3D design model; wherein the 3D design model is used in 3D design software; the different types of model attributes include equipment type attributes, pipe type attributes, and structure type attributes;

[0006] Based on the different types of model attributes, corresponding attribute tables are created, and multiple attribute mapping relationships are created; wherein, the attribute mapping relationship includes the mapping relationship between the 3D design software and the category name of the model attribute, the mapping relationship between the attribute table and the model attribute, and the mapping relationship between the 3D design software, the attribute table, and the model attribute;

[0007] The model attribute data corresponding to the 3D design model obtained from different 3D design software is imported into the attribute table according to the multiple attribute mapping relationships to obtain an attribute management table; the model attribute data includes the 3D design software name, model category, and model length;

[0008] Attribute value conversion rules are constructed based on the multiple different types of model attributes and the model attribute data; wherein, the attribute value conversion rules include unit conversion rules, numerical format conversion rules, and numerical precision conversion rules;

[0009] Attribute predefined rules are constructed based on the multiple different types of model attributes; the attribute predefined rules include attribute judgment rules and attribute aggregation rules; wherein, the attribute judgment rules are constructed based on multiple preset judgment conditions and the multiple different types of model attributes, and the attribute aggregation rules include performing aggregation operations on the attribute values ​​corresponding to the multiple different types of model attributes, and setting new attribute names for the aggregated attribute values;

[0010] An attribute mapping table is constructed based on the attribute management table, the attribute value conversion rules, and the attribute predefined rules.

[0011] In one embodiment, the model attribute data corresponding to the 3D design model obtained from different 3D design software includes:

[0012] Obtain multiple initial attribute data corresponding to the 3D design model in the different 3D design software;

[0013] The similarity between the multiple initial attribute data is calculated separately, and the multiple initial attribute data are integrated according to the similarity to obtain the model attribute data corresponding to the three-dimensional design model.

[0014] In one embodiment, calculating the similarity between the plurality of initial attribute data includes:

[0015] Construct an attribute data extension library corresponding to the plurality of initial attribute data; the attribute data extension library includes the abbreviations, extended names, derived names, and general names corresponding to the initial attribute data;

[0016] The initial attribute data corresponding to the 3D design model in the different 3D design software is compared with the content in the attribute data extension library corresponding to the initial attribute data, and the corresponding similarity is generated based on the comparison results.

[0017] In one embodiment, the attribute judgment rule is constructed based on multiple preset judgment conditions and multiple different types of model attributes, including:

[0018] Using the various model attributes of different types as judgment premises and judgment results respectively, multiple judgment statements are constructed based on the judgment premises, the judgment results, and the multiple judgment conditions, and these multiple judgment statements are used as the attribute judgment rules; or

[0019] Based on the various different types of model attributes and preset business requirements, corresponding regular expressions are constructed, and the attribute judgment rules are constructed according to the regular expressions and the various judgment conditions.

[0020] In one embodiment, the unit conversion rule in the attribute value conversion rule includes:

[0021] Obtain predefined standard units, unit conversion factors, and unit conversion formulas;

[0022] The units of the data to be converted are converted to standard units based on the unit conversion factor and the unit conversion formula.

[0023] In one embodiment, before obtaining multiple different types of model attributes in the 3D design model, the method further includes:

[0024] Obtain the model attribute information corresponding to any 3D design model, compare and verify the model attribute information with a preset attribute information standard, and obtain the verification result corresponding to the 3D design model; the verification result includes the location data of missing attribute fields or attribute values ​​that are missing in the model attribute information.

[0025] When the verification result meets the preset filtering requirements, the model attribute in the verification result that meets the filtering requirements will be used as the reference attribute.

[0026] The reference attributes are classified based on a pre-trained attribute classification model to obtain multiple different types of model attributes in the 3D design model.

[0027] In one embodiment, the attribute aggregation rule includes:

[0028] Aggregation operations are performed on the attribute values ​​corresponding to the multiple different types of model attributes to obtain aggregated attribute values; the aggregation operations include summation, averaging, maximization, and minimization.

[0029] The aggregated attribute values ​​are renamed to obtain new attribute names, and the new attribute names and the aggregated attribute values ​​are stored in a preset database.

[0030] In one embodiment, the numerical format conversion rule in the attribute value conversion rule includes:

[0031] Obtain the data to be converted and the target data format, and identify the corresponding format conversion configuration file based on the data to be converted and the target data format;

[0032] The data to be converted is converted into the target data format according to the format conversion configuration file.

[0033] According to the second aspect, one embodiment provides a method for unifying attributes based on a multi-source 3D model, comprising:

[0034] Obtain model attribute data from different 3D design models, perform data filtering on the model attribute data, and obtain filtered attribute data.

[0035] The unified attribute data is obtained based on the filtered attribute data and the attribute mapping table; wherein, the attribute mapping table is constructed using the attribute mapping table construction method.

[0036] The attribute mapping table construction method, apparatus, and device according to the above embodiments include creating corresponding attribute tables based on different types of model attributes, and creating multiple attribute mapping relationships. These multiple attribute mapping relationships demonstrate a one-to-one correspondence between different categories. Model attribute data is imported into the attribute tables according to these multiple attribute mapping relationships to obtain an attribute management table. Attribute value conversion rules and attribute predefined rules are constructed. The attribute value conversion rules include unit conversion rules, numerical format conversion rules, and numerical precision conversion rules, improving the accuracy of data processing from the perspectives of units, numerical formats, and numerical precision. The attribute predefined rules include attribute judgment rules and attribute aggregation rules. By predefining judgment and aggregation rules between different attributes, the efficiency of solving more complex data integration problems in different scenarios can be improved. Based on the attribute management table, attribute value conversion rules, and attribute predefined rules, an attribute mapping table is constructed. This attribute mapping table can serve as the data foundation for attribute unification in multi-source 3D models, improving the efficiency and accuracy of data unification. Attached Figure Description

[0037] Figure 1 Flowchart for constructing the attribute mapping table in this application embodiment;

[0038] Figure 2 A flowchart for constructing an attribute mapping table in one embodiment;

[0039] Figure 3 Flowchart for constructing an attribute mapping table for another embodiment;

[0040] Figure 4 Flowchart for constructing an attribute mapping table for another embodiment;

[0041] Figure 5 This is an example diagram of an attribute management table in one embodiment;

[0042] Figure 6 Flowchart for constructing an attribute mapping table for another embodiment;

[0043] Figure 7 Flowchart for constructing an attribute mapping table for another embodiment;

[0044] Figure 8 Flowchart for constructing an attribute mapping table for another embodiment;

[0045] Figure 9 Flowchart for constructing an attribute mapping table for another embodiment;

[0046] Figure 10 A flowchart for unifying attributes based on multi-source 3D models;

[0047] Figure 11 A flowchart for constructing an attribute mapping table for another embodiment. Detailed Implementation

[0048] The present invention will now be described in further detail with reference to specific embodiments and accompanying drawings. Similar elements in different embodiments are referred to by associated similar element reference numerals. In the following embodiments, many details are described to facilitate a better understanding of this application. However, those skilled in the art will readily recognize that some features may be omitted in different situations, or may be replaced by other elements, materials, or methods. In some cases, certain operations related to this application are not shown or described in the specification. This is to avoid obscuring the core parts of this application with excessive description. For those skilled in the art, detailed description of these related operations is not necessary; they can fully understand the related operations based on the description in the specification and general technical knowledge in the art.

[0049] Furthermore, the features, operations, or characteristics described in the specification can be combined in any suitable manner to form various embodiments. At the same time, the steps or actions in the method description can be rearranged or adjusted in a manner obvious to those skilled in the art. Therefore, the various orders in the specification and drawings are only for the clear description of a particular embodiment and do not imply a necessary order, unless otherwise stated that a particular order must be followed.

[0050] The serial numbers assigned to components in this document, such as "first" and "second," are used only to distinguish the described objects and have no sequential or technical meaning. The terms "connection" and "linkage" used in this application, unless otherwise specified, include both direct and indirect connections (linkages).

[0051] In some embodiments, corresponding attribute tables are created based on different types of model attributes, and multiple attribute mapping relationships are established. These multiple attribute mapping relationships demonstrate a one-to-one correspondence between different categories. Model attribute data is imported into the attribute tables according to these multiple attribute mapping relationships, resulting in an attribute management table. Attribute value conversion rules and attribute predefined rules are then constructed. The attribute value conversion rules include unit conversion rules, numerical format conversion rules, and numerical precision conversion rules, improving the accuracy of data processing from the perspectives of units, numerical formats, and numerical precision. The attribute predefined rules include attribute judgment rules and attribute aggregation rules. By predefining judgment and aggregation rules between different attributes, the efficiency of solving more complex data integration problems in different scenarios can be improved. Based on the attribute management table, attribute value conversion rules, and attribute predefined rules, an attribute mapping table is constructed. This attribute mapping table can serve as the data foundation for attribute unification in multi-source 3D models, improving the efficiency and accuracy of data unification.

[0052] Please refer to Figure 1 Some embodiments of the present invention provide a method for constructing an attribute mapping table, including steps S10 to S60, which are described in detail below.

[0053] Step S10: Obtain multiple different types of model attributes from the 3D design model; the 3D design model is used in 3D design software; the different types of model attributes include equipment type attributes, pipe type attributes, and structure type attributes.

[0054] In some embodiments, the 3D design model is applied in 3D design software, including but not limited to PDMS, Revit, Bentley, and other design software. The model attributes in the 3D design model have various different types, such as equipment type attributes, pipe type attributes, and structural type attributes. The names and number of fields contained in different types of model attributes are different. For example, model attributes under the pipe type attribute include fields such as "length" and "pipe diameter," while fields such as "length" and "pipe diameter" are not present in the equipment type attribute.

[0055] Please refer to Figure 2 In some embodiments, before step S10 obtains multiple different types of model attributes in the 3D design model, steps S11 to S13 are also included, which will be described in detail below.

[0056] Step S11: Obtain the model attribute information corresponding to any 3D design model, compare and verify the model attribute information with the preset attribute information standard, and obtain the verification result corresponding to the 3D design model; the verification result includes the location data of missing attribute fields or no attribute values ​​in the model attribute information.

[0057] In some embodiments, the model attribute information corresponding to any 3D design model obtained directly may not be complete, that is, there may be missing attribute fields or no attribute values. Therefore, it is necessary to compare and verify the model attribute information with the preset attribute information standard to filter out data that does not meet the requirements and ensure the accuracy of the model attributes.

[0058] Step S12: When the verification result meets the preset filtering requirements, the model attribute in the verification result that meets the filtering requirements is used as the reference attribute.

[0059] Step S13: Based on the pre-trained attribute classification model, perform attribute classification processing on the reference attribute to obtain multiple different types of model attributes in the 3D design model.

[0060] In some embodiments, the pre-trained attribute classification model can be a logistic regression model, a decision tree model, or a random forest model.

[0061] Step S20: Create corresponding attribute tables based on different types of model attributes, and create multiple attribute mapping relationships; among which, the attribute mapping relationships include the mapping relationship between the 3D design software and the category name of the model attribute, the mapping relationship between the attribute table and the model attribute, and the mapping relationship between the 3D design software, the attribute table, and the model attribute.

[0062] In some embodiments, since the field names and numbers contained in different types of model attributes are different, it is necessary to create attribute tables corresponding to different types of model attributes. Attributes in different 3D design software can be entered into their corresponding attribute tables through multiple pre-created attribute mapping relationships.

[0063] In some embodiments, multiple attribute mapping relationships are created. These include mappings between 3D design software and model attribute category names, mappings between attribute tables and model attributes, and mappings between 3D design software, attribute tables, and model attributes. The mapping between 3D design software and model attribute category names records the field name in the 3D design software that represents the category name of the attribute data. The category value corresponding to the attribute data can be obtained through the field name. The mapping between attribute tables and model attributes records the relationship between the attribute types of attribute tables and model attributes. The information of which attribute type it belongs to can be obtained through the field value corresponding to the attribute type, and which attribute table it should be entered into. The mapping between 3D design software, attribute tables, and model attributes records the relationship between fields in attribute tables and model attributes in different 3D design software programs. Attribute data from different 3D design software programs can be imported into the attribute tables through these mapping relationships.

[0064] Step S30: Obtain the model attribute data corresponding to the 3D design model from different 3D design software, and import the model attribute data into the attribute table according to multiple attribute mapping relationships to obtain the attribute management table; the model attribute data includes the 3D design software name, model category, and model length.

[0065] Please refer to Figure 3 In some embodiments, step S30 obtains model attribute data corresponding to the 3D design model from different 3D design software, including steps S31 to S32, which are described in detail below.

[0066] Step S31: Obtain multiple initial attribute data corresponding to the 3D design model in different 3D design software.

[0067] In some embodiments, the initial attribute data corresponding to the 3D design model includes attribute data of different types, as well as different naming conventions for attribute data of the same type. For example, the field length of the pipe type attribute may be named "len" and "length" in 3D design software PDMS and Bentley, respectively.

[0068] Step S32: Calculate the similarity between multiple initial attribute data respectively, and integrate the multiple initial attribute data according to the similarity to obtain the model attribute data corresponding to the 3D design model.

[0069] Please refer to Figure 4 In some embodiments, step S32 calculates the similarity between multiple initial attribute data, including steps S321 to S322, which are described in detail below.

[0070] Step S321: Construct an attribute data extension library corresponding to multiple initial attribute data; the attribute data extension library includes the abbreviations, extended names, derived names, and general names corresponding to the initial attribute data.

[0071] In some embodiments, the attribute data extension library includes abbreviations, extended names, derived names, and generalized names corresponding to the initial attribute data. For example, for the field "length" corresponding to the initial attribute data length, its abbreviation is "len". The extended name corresponding to the initial attribute data can be the full name corresponding to the initial attribute data when it is represented in abbreviation form. The derived name corresponding to the initial attribute data can be its corresponding name in other forms, and the generalized name corresponding to the initial attribute data can be a custom generalized field.

[0072] Step S322: Compare the initial attribute data corresponding to the 3D design model in different 3D design software with the contents of the attribute data extension library corresponding to the initial attribute data, and generate the corresponding similarity based on the comparison results.

[0073] In some embodiments, the corresponding similarity can be generated by calculating Euclidean distance, cosine similarity, or other similarity calculation methods.

[0074] Please refer to Figure 5 In some embodiments, the attribute management table may include information such as the corresponding name between different software, the corresponding type, and the length.

[0075] Step S40: Construct attribute value conversion rules based on multiple different types of model attributes and model attribute data; among which, attribute value conversion rules include unit conversion rules, numerical format conversion rules, and numerical precision conversion rules.

[0076] Please refer to Figure 6 In some embodiments, the unit conversion rules in the attribute value conversion rules in step S40 include steps S41 to S42, which will be described in detail below.

[0077] Step S41: Obtain the predefined standard units, unit conversion factors, and unit conversion formulas.

[0078] Step S42: Convert the units of the data to be converted to standard units based on the unit conversion factor and unit conversion formula.

[0079] Please refer to Figure 7 In some embodiments, the numerical format conversion rules in the attribute value conversion rules in step S40 include steps S43 to S44, which will be described in detail below.

[0080] Step S43: Obtain the data to be converted and the target data format, and identify the corresponding format conversion configuration file based on the data to be converted and the target data format.

[0081] Step S44: Convert the data to be converted into the target data format according to the format conversion configuration file.

[0082] In some embodiments, attribute value conversion rules constructed through unit conversion rules, numerical format conversion rules, and numerical precision conversion rules can eliminate differences in numerical precision such as units, formats, and decimal places in different data sources, ensuring data consistency between different source data.

[0083] Step S50: Construct corresponding attribute predefined rules based on multiple different types of model attributes; the attribute predefined rules include attribute judgment rules and attribute aggregation rules; wherein, the attribute judgment rules are constructed based on multiple preset judgment conditions and multiple different types of model attributes, and the attribute aggregation rules include performing aggregation operations on the attribute values ​​corresponding to multiple different types of model attributes, and setting new attribute names for the aggregated attribute values.

[0084] Please refer to Figure 8 In some embodiments, the attribute judgment rules in step S50 are constructed based on multiple preset judgment conditions and multiple different types of model attributes, including steps S51 to S52, which are described in detail below.

[0085] Step S51: Using multiple different types of model attributes as judgment premises and judgment results respectively, construct multiple judgment statements based on the judgment premises, judgment results and multiple judgment conditions, and use the multiple judgment statements as attribute judgment rules; or.

[0086] In some embodiments, the attribute judgment rule includes "If attribute A equals X, then map attribute A to attribute B; otherwise, map attribute A to attribute C." "Equal to" is one type of judgment condition. Other judgment conditions include greater than, less than, greater than or equal to, and less than or equal to. The judgment premise is "If attribute A equals X," and the judgment result is either "map attribute A to attribute B" or "map attribute A to attribute C." The judgment premise, judgment result, and multiple judgment conditions can be expressed in different statements, thus resolving complex relationships between various attributes.

[0087] Step S52: Construct corresponding regular expressions based on multiple different types of model attributes and preset business requirements, and construct attribute judgment rules based on the regular expressions and multiple judgment conditions.

[0088] Please refer to Figure 9 In some embodiments, the attribute aggregation rules in step S50 include steps S53 to S54, which will be described in detail below.

[0089] Step S53: Perform aggregation operations on the attribute values ​​corresponding to multiple different types of model attributes to obtain aggregated attribute values; aggregation operations include summation, average, maximum and minimum operations;

[0090] Step S54: Rename the aggregated attribute values ​​to obtain new attribute names, and store the new attribute names and aggregated attribute values ​​in the preset database.

[0091] Step S60: Construct an attribute mapping table based on the attribute management table, attribute value conversion rules, and attribute predefined rules.

[0092] In some embodiments, step S60, before constructing the attribute mapping table based on the attribute management table, attribute value conversion rules, and attribute predefined rules, further includes:

[0093] Construct corresponding reference attribute mapping relationships based on preset model attributes, and modify the reference attribute mapping relationships according to the received user requirements.

[0094] In some embodiments, a set of reference attribute mapping relationships can be pre-configured for some commonly used software attributes. During the user implementation process, the relevant configuration can be integrated by selecting the corresponding reference attribute mapping relationship. If the reference attribute mapping relationship does not meet the user's needs, the user's needs can be used as the modification standard to modify the reference attribute mapping relationship, thereby simplifying the overall work and improving efficiency.

[0095] Please refer to Figure 10 Some embodiments of the present invention provide a method for unifying attributes based on a multi-source 3D model, including steps S70 to S80, which are described in detail below.

[0096] Step S70: Obtain model attribute data from different 3D design models, perform data filtering on the model attribute data, and obtain filtered attribute data.

[0097] In some embodiments, data filtering is performed on the model attribute data to obtain filtered attribute data, which can ensure data quality and reduce potential data problems in the future.

[0098] Step S80: Obtain unified attribute data based on the filtered attribute data and the attribute mapping table; wherein, the attribute mapping table is constructed using the attribute mapping table construction method.

[0099] In some embodiments, the attribute mapping table construction method includes:

[0100] This involves acquiring multiple different types of model attributes from a 3D design model, which is used in 3D design software. These different types of model attributes include equipment type attributes, pipe type attributes, and structure type attributes.

[0101] Attribute tables are created for different types of model attributes, and multiple attribute mapping relationships are created. Among them, the attribute mapping relationships include the mapping relationship between the 3D design software and the category name of the model attribute, the mapping relationship between the attribute table and the model attribute, and the mapping relationship between the 3D design software, the attribute table, and the model attribute.

[0102] The model attribute data corresponding to the 3D design model obtained from different 3D design software is imported into the attribute table according to multiple attribute mapping relationships to obtain the attribute management table; the model attribute data includes the 3D design software name, model category, and model length;

[0103] Attribute value conversion rules are constructed based on multiple different types of model attributes and model attribute data; among them, attribute value conversion rules include unit conversion rules, numerical format conversion rules, and numerical precision conversion rules;

[0104] Attribute predefined rules are constructed based on multiple different types of model attributes. The attribute predefined rules include attribute judgment rules and attribute aggregation rules. The attribute judgment rules are constructed based on multiple preset judgment conditions and multiple different types of model attributes. The attribute aggregation rules include performing aggregation operations on the attribute values ​​corresponding to multiple different types of model attributes and setting new attribute names for the aggregated attribute values.

[0105] An attribute mapping table is constructed based on the attribute management table, attribute value conversion rules, and attribute predefined rules.

[0106] In some embodiments, by constructing an attribute mapping table, not only are model attribute data from different 3D design software programs mapped to a unified table, but attribute value conversion rules and attribute predefined rules are also involved. This allows for corresponding data processing in different situations, improving data accuracy. The constructed attribute mapping table ensures semantic consistency and uniformity of data, avoiding data confusion caused by naming differences. Furthermore, because it establishes attribute mapping relationships between different 3D design software programs, it can also adapt to the requirements of different software.

[0107] In some embodiments, corresponding attribute tables are created based on different types of model attributes, and multiple attribute mapping relationships are established. These multiple attribute mapping relationships demonstrate a one-to-one correspondence between different categories. Model attribute data is imported into the attribute tables according to these multiple attribute mapping relationships, resulting in an attribute management table. Attribute value conversion rules and attribute predefined rules are then constructed. The attribute value conversion rules include unit conversion rules, numerical format conversion rules, and numerical precision conversion rules, improving the accuracy of data processing from the perspectives of units, numerical formats, and numerical precision. The attribute predefined rules include attribute judgment rules and attribute aggregation rules. By predefining judgment and aggregation rules between different attributes, the efficiency of solving more complex data integration problems in different scenarios can be improved. Based on the attribute management table, attribute value conversion rules, and attribute predefined rules, an attribute mapping table is constructed. This attribute mapping table can serve as the data foundation for attribute unification in multi-source 3D models, improving the efficiency and accuracy of data unification.

[0108] Please refer to Figure 11 In some embodiments, the construction of the attribute mapping table can also be achieved by obtaining the attribute category name based solely on the software name in the software-category name relationship table, obtaining the corresponding attribute management table based on the category value in the attribute management table-category value relationship table, and obtaining the mapping relationship based on the software name and the attribute management table. This can refer to the attribute management table-first software name attribute mapping, the attribute management table-second software name attribute mapping, and the attribute management table-third software name attribute mapping, where the first software name is PMDS, the second software name is Revit, and the third software name is Bentley. Data is then integrated based on the attribute fields and the attribute management table and imported into the attribute management table. This attribute management table can serve as an intermediate bridge for subsequent data processing.

[0109] Those skilled in the art will understand that all or part of the functions of the various methods in the above embodiments can be implemented by hardware or by computer programs. When all or part of the functions in the above embodiments are implemented by computer programs, the program can be stored in a computer-readable storage medium, which may include: read-only memory, random access memory, disk, optical disk, hard disk, etc., and the program is executed by a computer to achieve the above functions. For example, the program can be stored in the memory of a device, and when the program in the memory is executed by the processor, all or part of the above functions can be achieved. In addition, when all or part of the functions in the above embodiments are implemented by computer programs, the program can also be stored in a server, another computer, disk, optical disk, flash drive, or external hard drive, etc., and can be downloaded or copied to the memory of a local device, or the system of the local device can be updated. When the program in the memory is executed by the processor, all or part of the functions in the above embodiments can be achieved.

[0110] The above examples illustrate the present invention only to aid in understanding it and are not intended to limit the scope of the invention. Those skilled in the art can make various simple deductions, modifications, or substitutions based on the principles of this invention.

Claims

1. A method for constructing an attribute mapping table, characterized in that, include: Obtain multiple different types of model attributes from a 3D design model; wherein the 3D design model is used in 3D design software; the different types of model attributes include equipment type attributes, pipe type attributes, and structure type attributes; Based on the different types of model attributes, corresponding attribute tables are created, and multiple attribute mapping relationships are created; wherein, the attribute mapping relationship includes the mapping relationship between the 3D design software and the category name of the model attribute, the mapping relationship between the attribute table and the model attribute, and the mapping relationship between the 3D design software, the attribute table, and the model attribute; The model attribute data corresponding to the 3D design model obtained from different 3D design software is imported into the attribute table according to the multiple attribute mapping relationships to obtain an attribute management table; the model attribute data includes the 3D design software name, model category, and model length; Attribute value conversion rules are constructed based on the multiple different types of model attributes and the model attribute data; wherein, the attribute value conversion rules include unit conversion rules, numerical format conversion rules, and numerical precision conversion rules; Attribute predefined rules are constructed based on the multiple different types of model attributes; the attribute predefined rules include attribute judgment rules and attribute aggregation rules; wherein, the attribute judgment rules are constructed based on multiple preset judgment conditions and the multiple different types of model attributes, and the attribute aggregation rules include performing aggregation operations on the attribute values ​​corresponding to the multiple different types of model attributes, and setting new attribute names for the aggregated attribute values; An attribute mapping table is constructed based on the attribute management table, the attribute value conversion rules, and the attribute predefined rules.

2. The method as described in claim 1, characterized in that, The model attribute data corresponding to the 3D design model obtained from different 3D design software includes: Obtain multiple initial attribute data corresponding to the 3D design model in the different 3D design software; The similarity between the multiple initial attribute data is calculated separately, and the multiple initial attribute data are integrated according to the similarity to obtain the model attribute data corresponding to the three-dimensional design model.

3. The method as described in claim 2, characterized in that, The step of calculating the similarity between the multiple initial attribute data includes: Construct an attribute data extension library corresponding to the plurality of initial attribute data; the attribute data extension library includes the abbreviations, extended names, derived names, and general names corresponding to the initial attribute data; The initial attribute data corresponding to the 3D design model in the different 3D design software is compared with the content in the attribute data extension library corresponding to the initial attribute data, and the corresponding similarity is generated based on the comparison results.

4. The method as described in claim 1, characterized in that, The attribute judgment rules are constructed based on multiple preset judgment conditions and multiple different types of model attributes, including: Using the various model attributes of different types as judgment premises and judgment results respectively, multiple judgment statements are constructed based on the judgment premises, the judgment results, and the multiple judgment conditions, and these multiple judgment statements are used as the attribute judgment rules; or Based on the various different types of model attributes and preset business requirements, corresponding regular expressions are constructed, and the attribute judgment rules are constructed according to the regular expressions and the various judgment conditions.

5. The method as described in claim 1, characterized in that, The unit conversion rules in the attribute value conversion rules include: Obtain predefined standard units, unit conversion factors, and unit conversion formulas; The units of the data to be converted are converted to standard units based on the unit conversion factor and the unit conversion formula.

6. The method as described in claim 1, characterized in that, Before obtaining multiple different types of model attributes in the 3D design model, the method further includes: Obtain the model attribute information corresponding to any 3D design model, compare and verify the model attribute information with a preset attribute information standard, and obtain the verification result corresponding to the 3D design model; the verification result includes the location data of missing attribute fields or attribute values ​​that are missing in the model attribute information. When the verification result meets the preset filtering requirements, the model attribute in the verification result that meets the filtering requirements will be used as the reference attribute. The reference attributes are classified based on a pre-trained attribute classification model to obtain multiple different types of model attributes in the 3D design model.

7. The method as described in claim 1, characterized in that, The attribute aggregation rules include: Aggregation operations are performed on the attribute values ​​corresponding to the multiple different types of model attributes to obtain aggregated attribute values; the aggregation operations include summation, averaging, maximization, and minimization. The aggregated attribute values ​​are renamed to obtain new attribute names, and the new attribute names and the aggregated attribute values ​​are stored in a preset database.

8. The method as described in claim 1, characterized in that, The numerical format conversion rules in the attribute value conversion rules include: Obtain the data to be converted and the target data format, and identify the corresponding format conversion configuration file based on the data to be converted and the target data format; The data to be converted is converted into the target data format according to the format conversion configuration file.

9. A method for unifying attributes based on multi-source 3D models, characterized in that, include: Obtain model attribute data from different 3D design models, perform data filtering on the model attribute data, and obtain filtered attribute data. The unified attribute data is obtained based on the filtered attribute data and the attribute mapping table; wherein the attribute mapping table is constructed by the construction method as described in any one of claims 1 to 8.

10. A computer-readable storage medium, characterized in that, The medium stores a program that can be executed by a processor to implement the method as described in any one of claims 1-8.

Images