Data consistency verification method and device, computer equipment and storage medium

Abstract

The invention relates to a data consistency verification method and device, computer equipment and a storage medium. The method comprises the steps of extracting a first type of data in a bill of material and CAD structure data associated with the bill of material, performing consistency comparison to obtain a first comparison result, extracting a second type of data in the bill of material and CAD structure data, and performing consistency comparison to obtain a second comparison result, the first type of data being first-level part data in the bill of material, and the second type of data being second-level part data in the bill of material and CAD structure data; the second type of data is data of sub-structures of parts in the first type of data, separately extracting father-son relations between structures in the second type of data of the bill of materials and in the second type of data of the CAD structure data, and performing consistency comparison to obtain a second comparison result, and according to the first comparison result and the second comparison result, determining a consistency verification result of the bill of materials and the CAD structure data. By adopting the method, the consistency checking efficiency of the bill of materials and the CAD structure data can be improved.

Description

Technical Field

[0001] The present application relates to the technical field of data processing, and particularly to a data consistency verification method, device, computer device, and storage medium. Background Art

[0002] In the fields of vehicle development and component design, with the increasingly in-depth application of CAD (Computer Aided Design) technology, advanced technologies such as context-based design and digital mock-up vehicles have emerged continuously, and the management difficulty of 3D (Three Dimensional) digital models has increased linearly. Currently, automotive OEMs mainly rely on CAD structure data to manage these 3D digital models. Engineering BOM (Bill of Materials) also runs through the entire vehicle development process. It targets the mass production stage, clarifies the usage relationships of components in the vehicle model, and provides support for various business departments such as design, cost, procurement, process, and after-sales.

[0003] CAD structure data and BOM are different forms of expression of the vehicle product status. Ensuring their consistency is crucial for unifying data sources, avoiding rework, and shortening the development cycle. However, although they are maintained by R & D engineers, inconsistencies often occur. Currently, relying on engineering data engineers to export CAD structure data and BOM and then perform manual comparison is inefficient. Summary of the Invention

[0004] Based on this, in view of the above technical problems, it is necessary to provide a data consistency verification method, device, computer device, and storage medium that can improve the verification efficiency.

[0005] In a first aspect, the present application provides a data consistency verification method, including:

[0006] Extracting first-class data in the bill of materials and CAD structure data associated with the bill of materials and performing a consistency comparison to obtain a first comparison result, where the first-class data is the first-level part data in the bill of materials;

[0007] Extracting second-class data in the bill of materials and CAD structure data, where the second-class data is the sub-structure data of the parts in the first-class data;

[0008] Respectively extracting the parent-child relationships between the structures in the second-class data of the bill of materials and the second-class data of the CAD structure and performing a consistency comparison to obtain a second comparison result;

[0009] Determining the consistency verification result of the bill of materials and the CAD structure data according to the first comparison result and the second comparison result.

[0010] In one embodiment, the CAD structure data includes at least one digital model line, and the bill of materials includes at least one part usage line. The digital model line records the line identifier associated with the part usage line. Extract the first type of data in the bill of materials and the CAD structure data associated with the bill of materials and compare them to obtain the first comparison result, including:

[0011] Extract the first type of data in the bill of materials and the CAD structure data, and compare each data line of the first type of data in the bill of materials and the CAD structure data according to the line identifier;

[0012] If the current line identifier exists in both the first type of data in the bill of materials and the first type of data in the CAD structure data, generate a first set and a second set. The first set is the set composed of the part usage lines in the bill of materials that contain the current line identifier, and the second set is the set composed of the digital model lines in the CAD structure data that contain the current line identifier;

[0013] Determine the first comparison result according to the first set and the second set.

[0014] In one embodiment, extract the second type of data in the bill of materials and the CAD structure data. The second type of data is the data of the sub-structure of the parts in the first type of data, including:

[0015] Extract the data corresponding to the parts with sub-structures from the first set to obtain the second type of data in the bill of materials;

[0016] Extract the CAD structures with sub-structures and the associated parts from the second set to obtain the second type of data in the CAD structure data.

[0017] In one embodiment, the parent-child relationship includes a parent structure identifier and the corresponding sub-structure identifier. The CAD structure data includes multiple levels. Extract the parent-child relationships between the structures in the second type of data in the bill of materials and the second type of data in the CAD structure data respectively and compare them to obtain the second comparison result, including:

[0018] Extract the parts associated with each level in the second type of data of the CAD structure data and the parts associated with the sub-levels of each level;

[0019] Combine the parts associated with each level and the parts associated with the sub-levels of each level to obtain the parent-child relationships between the structures in the second type of data of the CAD structure data;

[0020] Compare the parent-child relationships extracted from the bill of materials with the parent-child relationships extracted from the CAD structure data to obtain the second comparison result.

[0021] In one embodiment, the parent-child relationships extracted from the bill of materials further include the usage amounts of each part, and the data consistency verification method further includes:

[0022] Split the combinations of parent-child relationships with usage amounts greater than a preset threshold into multiple combinations of parent-child relationships.

[0023] Compare the parent-child relationships extracted from the bill of materials with the parent-child relationships extracted from the CAD structure data to obtain a second comparison result, including:

[0024] Compare the split parent-child relationships with the parent-child relationships extracted from the CAD structure data to obtain a second comparison result.

[0025] In one embodiment, combine the parts associated with each level and the parts associated with the sub-levels of each level to obtain the parent-child relationships between the structures in the second type of data of the CAD structure data, including:

[0026] Combine the parts associated with each level and the parts associated with the sub-levels of each level according to the Cartesian product algorithm to obtain the parent-child relationships between the structures in the second type of data of the CAD structure data.

[0027] In one embodiment, the consistency verification result of the bill of materials and the CAD structure data further includes a third comparison result, and the data consistency verification method further includes:

[0028] Extract the target structure in the bill of materials and the CAD structure data and the configuration information of the product assembled by the target structure. The target structure is a structure with different positions in products of different configuration versions, and the product is the product corresponding to the bill of materials;

[0029] Obtain the engineering configuration table of the product, where the engineering configuration table includes the configuration information corresponding to different configuration versions;

[0030] Resolve the target structure data in the bill of materials and the CAD structure data respectively according to the engineering configuration table;

[0031] Compare the resolved results to obtain a third comparison result.

[0032] In a second aspect, a data consistency verification device is provided, including:

[0033] A first comparison module, configured to extract the first type of data in the bill of materials and the CAD structure data associated with the bill of materials and perform a consistency comparison to obtain a first comparison result. The first type of data is the first-level part data in the bill of materials;

[0034] An extraction module, configured to extract the second type of data in the bill of materials and the CAD structure data, where the second type of data is the sub-structure data of the parts in the first type of data;

[0035] A second comparison module, configured to extract the parent-child relationships between the structures in the second type of data in the bill of materials and the second type of data in the CAD structure data respectively and perform a consistency comparison to obtain a second comparison result;

[0036] A determination module, configured to determine the consistency verification result of the bill of materials and the CAD structure data according to the first comparison result and the second comparison result.

[0037] In a third aspect, the present application provides a computer device, including a memory, a processor, and a computer program stored on the memory and executable on the processor. When the processor executes the computer program, it implements the steps of the data consistency verification method provided in any embodiment of the first aspect of the present application.

[0038] In a fourth aspect, the present application provides a computer-readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, it implements the steps of the data consistency verification method provided in any embodiment of the first aspect of the present application.

[0039] The above data consistency verification method, device, computer device, and storage medium divide data into two categories. Among them, the first type of data serves as a basic framework and is a key part of the overall product structure. Comparing it first can quickly determine whether the bill of materials and the CAD structure data are consistent in the main components from a macroscopic level, grasp the general direction of the overall data, and avoid major deviations. The second type of data, as the sub-structure of the first type of data, is a further refinement of the product structure. Comparing this part of the data can penetrate into the interior of the product and check whether the more detailed components match, realizing a comprehensive hierarchical data verification from the whole to the part.

[0040] This classification and comparison method divides complex data into different categories, processes and compares them respectively according to the characteristics of different categories, avoids performing an undifferentiated overall comparison on all data, reduces unnecessary calculation and comparison workload, and improves the efficiency of data comparison. For example, the first type of data is relatively small in quantity but high in importance. Comparing this part of the data first, if there are problems, they can be locked in time. If they are consistent, then compare the second type of data, which can make the verification process more targeted and efficient. Description of the Drawings

[0041] Figure 1 It is a schematic flowchart of the data consistency verification method in some embodiments;

[0042] Figure 2 It is a schematic diagram of the CAD structure data in some embodiments;

[0043] Figure 3 Schematic diagram of the data structure of the second type of data for CAD structure data in some embodiments;

[0044] Figure 4 Schematic diagram of the data structure of the second type of data for the bill of materials in some embodiments;

[0045] Figure 5 Schematic diagram of the result obtained after extracting the parent - child relationship from the second type of data of the bill of materials in some embodiments;

[0046] Figure 6 Schematic diagram of the dosage splitting process in some embodiments;

[0047] Figure 7 Schematic diagram showing the result of running the Cartesian product algorithm in some other embodiments;

[0048] Figure 8 Schematic diagram of the process of matching the parent - child relationship after calculation by the Cartesian product algorithm with the split parent - child relationship in the bill of materials in some other embodiments;

[0049] Figure 9 Schematic diagram of the principle of settling the bill of materials and CAD structure data in some other embodiments;

[0050] Figure 10 Schematic diagram of the set of part rows and the set of DR row data after solution in some other embodiments;

[0051] Figure 11 Schematic block diagram of the data consistency verification device in some embodiments;

[0052] Figure 12 Internal structure diagram of a computer device in some embodiments. Specific embodiments

[0053] In order to make the objectives, technical solutions and advantages of the present application clearer, the present application will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0054] In the first aspect, the present application provides a data consistency verification method. As Figure 1 shown, taking the application server as an example for illustration, the method includes the following steps:

[0055] Step S11: Extract the first - type data in the bill of materials and the CAD structure data associated with the bill of materials, and perform a consistency comparison to obtain a first comparison result. The first - type data is the first - level part data in the bill of materials.

[0056] Among them, the data consistency check of this application refers to the data consistency check of the bill of materials and CAD structure data.

[0057] The bill of materials (BOM) is a technical document describing the product structure, which details all the information of components, raw materials, etc. included in a product, as well as their assembly relationships and quantities. It is used to define the usage relationships of components in vehicle models during the development of a complete vehicle.

[0058] CAD structure data refers to the data created using CAD software for describing the three-dimensional structure and geometric information of a product or component. It contains detailed information such as the positions, shapes, dimensions, and assembly relationships of all components of the product in three-dimensional space, stored and presented in a structured manner. It can not only display the specific form and spatial position of a single part but also clearly show the assembly hierarchy and connection methods between parts.

[0059] The first type of data is the first-level part data of the product, that is, the data of the in-plant level structure of the product, referring to the data related to the components directly entering the factory for assembly production and other processes. These components are complete when entering the factory and can be directly used in the assembly on the production line. For example, a standard screw, an engine assembly, a single car seat, and a complete piece of glass.

[0060] The CAD structure data associated with the bill of materials means that the bill of materials and CAD structure data belong to the same product, that is, the bill of materials and CAD structure data of the same product are mutually associated. For example, the bill of materials and CAD structure data of the same vehicle are mutually associated.

[0061] Consistency comparison refers to a comprehensive check of the corresponding data in the bill of materials and CAD structure data, from content to logical relationships, to determine whether they match and whether there are differences. Specifically, the consistency comparison can include:

[0062] Data value comparison: For the basic information such as part numbers, names, specifications, etc. in the first type of data, as well as the specific parameters of the sub-structures in the second type of data, check whether the corresponding values in the bill of materials and CAD structure data are exactly the same.

[0063] Structure relationship comparison: For the connection relationships between structures in the second type of data, confirm whether the hierarchical relationships, assembly relationships, etc. described in the bill of materials and CAD structure data are consistent.

[0064] Step S12: Extract the second type of data in the bill of materials and CAD structure data. The second type of data is the data of the sub-structures of the parts in the first type of data.

[0065] The second type of data is the data of the sub-structures of the parts in the first type of data. It belongs to the data of non-incoming-factory-level structures, that is, it is not the data at the overall level that is concerned when the whole part enters the factory, but rather the data related to the more refined structures inside the part.

[0066] Exemplarily, taking an automobile as an example, the non-incoming-factory-level structures may include the internal parts of the engine, the internal parts of the transmission, and the tiny components of the chassis system, etc. Specifically, the second type of data may include the geometric data, material data, process data, and performance data of these structures, etc.

[0067] The sub-structure of a part refers to each relatively independent part that makes up the part and has a specific function or shape. For example, a complex mechanical part may be composed of multiple sub-structures with different shapes and functions. The piston cavity and cooling water channels in the engine block are different sub-structures; for an electronic circuit board, the installation areas of each electronic component and the wiring areas on it can also be regarded as the sub-structures of the circuit board part.

[0068] Furthermore, after obtaining the first type of data, this application also needs to preprocess the first type of data. Specifically, this application can filter the first type of data of the CAD structure data. For example, it can filter out the in-factory weld point data unique to the CAD structure data and 3D PMI (3D Product and Manufacturing Information).

[0069] Among them, the in-factory weld point data is the data related to the welding points used to connect the body parts (such as the various metal parts of the body frame) during the automobile production process. In the CAD structure data, these data are associated with the vehicle design scheme. When the design scheme type is "Joining", the data under this design scheme may mainly be the relevant information about the in-factory weld points, including the weld point positions, the number of weld points, and the welding process requirements, etc.

[0070] The reason for filtering is that the bill of materials mainly focuses on the material information that constitutes the product. The in-factory weld point data is the information in the production process and is not a key information for checking the consistency of the bill of materials and the CAD structure data. Moreover, the weld point data belongs to the production process data unique to the CAD structure. If it is not filtered, it will interfere with the verification of the consistency of the bill of materials and the CAD structure data.

[0071] In addition, 3D PMI is displayed in a 3D environment. For the CAD structure of an automobile, the DR (Digital Representation) line of the "Assembly 3D PMI" type in the DR contains assembly information in a 3D environment, such as the assembly sequence, assembly direction, assembly tolerance, etc. of components. These information are detailed 3D data used to guide the actual assembly process. Among them, the DR here can be understood as a CAD object in the CAD structure data, which is a one-to-one corresponding concept with the parts in the bill of materials.

[0072] The reason for filtering is that similar to the in-plant solder joint data, the bill of materials mainly focuses on the material composition of the product, and 3D PMI is mainly about the detailed information of the product assembly process, which does not directly reflect the content of the bill of materials. In order to focus on the consistency verification between the bill of materials and the CAD structure data, it is necessary to filter out these data that are not critical for the current verification purpose.

[0073] Furthermore, after filtering, the first type of data in the CAD structure data can be further merged. Specifically, the CAD structure data shows the set of 3D data positions of all components of the product in a three-dimensional space. To accurately reflect the three-dimensional positions of each part, even if the same part is used multiple times in a single product, each part is separately recorded in the CAD structure data, so the DR usage in the CAD structure data is set to 1. The role of the bill of materials is to reflect the total usage of a certain part in the entire product, and this quantity is an integer greater than or equal to 1.

[0074] Therefore, before comparing the consistency between the bill of materials and the CAD structure data, it is necessary to perform a usage merge process on the first type of data in the CAD structure data. The purpose of this process is to make the usage representation method of the CAD structure data unified with the bill of materials, which is convenient for subsequent consistency comparison.

[0075] Step S13: Extract the parent-child relationships between the structures in the second type of data of the bill of materials and the second type of data of the CAD structure data respectively, and perform a consistency comparison to obtain a second comparison result.

[0076] Among them, in the automotive component data, the parent-child relationship refers to the hierarchical relationship between a part and its sub-structures. The parent structure is the overall part or a larger component, and the sub-structure is a smaller and more detailed part that makes up the part or component. For example, the engine is the parent structure, and the piston, valve, etc. are the sub-structures, and there is a clear belonging and composition relationship between them.

[0077] Specifically, the present application can analyze fields such as part numbers, names, and specifications in the bill of materials to find records with inclusion or subordination relationships. For example, if a record is "engine assembly" and there is a record "piston assembly" below it, it can be determined that the engine assembly is the "parent" and the piston assembly is the "child". Information such as remarks and descriptions in the bill of materials can also be used to clarify the hierarchical relationships of each structure.

[0078] Furthermore, the present application can utilize the layer management function of CAD software to view the naming and inclusion relationships of different layers. Generally, the upper-layer corresponds to the parent structure and the lower-layer is the child structure. Through the assembly tree structure of the CAD model, the nested relationships between parts and sub-structures can be clearly seen, with the root node generally being the parent structure and the branch nodes being the sub-structures.

[0079] Furthermore, the parent-child relationships extracted from the bill of materials and CAD structure data are respectively organized into data models, such as a tree structure, with the parent structure as the root node and the sub-structure as the child node.

[0080] The nodes in the two data models are compared one by one to check whether the names, numbers, etc. of the parent structures are the same, and whether the corresponding sub-structures are the same, including quantity, name, and number, etc.

[0081] Furthermore, verify whether the connection relationships between the parent and child structures are consistent.

[0082] Furthermore, record the consistent and inconsistent situations. For the inconsistent parts, elaborate on the differences, such as a certain sub-structure exists in the bill of materials but not in the CAD structure data, or their names and numbers do not match, etc., so as to obtain the second comparison result.

[0083] Step S14, determine the consistency verification result of the bill of materials and CAD structure data based on the first comparison result and the second comparison result.

[0084] Among them, the present application can integrate the first comparison result and the second comparison result to obtain the consistency verification result of the bill of materials and CAD structure data.

[0085] In one embodiment, the CAD structure data includes at least one digital model line, and the bill of materials includes at least one part usage line. The digital model line records a line identifier associated with the part usage line. Extract the first type of data in the bill of materials and the CAD structure data associated with the bill of materials and compare them to obtain a first comparison result, including: Extract the first type of data in the bill of materials and the CAD structure data, and compare each data line of the first type of data in the bill of materials and the CAD structure data according to the line identifier. If the current line identifier exists in both the first type of data in the bill of materials and the first type of data in the CAD structure data, generate a first set and a second set. The first set is a set composed of part usage lines in the bill of materials that contain the current line identifier, and the second set is a set composed of digital model lines in the CAD structure data that contain the current line identifier.

[0086] Determine the first comparison result according to the first set and the second set.

[0087] Among them, the digital model line refers to a data line in the CAD structure data. Each digital model line records digital model information related to the part, which may include data related to the geometry, dimensions, position, etc. of the part, and contains a line identifier associated with the bill of materials for establishing a connection with the corresponding information in the bill of materials. Exemplarily, each digital model line in the CAD structure data records a field "BOM line identifier" to establish an association relationship between the digital model line and the data line in the bill of materials.

[0088] The part usage line refers to a data line in the bill of materials. Each part usage line records the usage situation of the part, such as information about the part name, number, usage amount, affiliated component, etc., PSS (Product Structure System), FG (function group), POS (Position), function position code (encoding of position + function), and configuration variable, representing the specific usage of the part in the product, and also carrying a BOM line identifier. Among them, the configuration variable refers to some configuration information of the part, such as pre-configuring the part for a luxury model.

[0089] Therefore, each digital model line in the CAD structure data records a field "BOM line identifier", which is equivalent to the line identifier in this application. Each part usage line in the bill of materials also records the same field "BOM line identifier", and an association relationship between the digital model line and the part usage line is established through this field.

[0090] To further illustrate the association relationship between the digital model line and the part usage line, this application can be elaborated from the creation process. Specifically, the process of creating parts and 3D digital models in this application can include:

[0091] Accept the input information for the user to create a new part. If the user selects to automatically create a 3D digital model, it will automatically trigger the creation of a 3D digital model (the code of the 3D digital model adds the prefix "CAD" to the part code), and automatically establish a one-to-one correspondence between the part and the 3D digital model, and store it in the database. This relationship can be viewed from both the part and 3D digital model perspectives. Thus, the association relationship between the part and the 3D digital model is established.

[0092] Further, the creation of the association relationship between the part usage line and the digital model line in this application may include:

[0093] The user manually inputs part vehicle usage information such as PSS, FG, and POS. The system automatically generates a BOM line identifier, creates and stores the part usage line in the database. Receive the user's CAD synchronization request, and obtain relevant information such as the vehicle model and PSS, FG, and POS. Query and match the CAD structure data according to the vehicle model, and lock the POS object node through PSS, FG, and POS. Automatically create a design plan object according to the input information, generate an ID and a name according to the rules, and attach it under the POS level. Write the ID of the newly created design plan back to the part usage line of the BOM. Realize the association between the part usage line and the digital model line through the "BOM line identifier" and the "design plan ID".

[0094] Further, the first set: is a set formed by gathering all the part usage lines containing the current line identifier from the first type of data in the bill of materials.

[0095] The second set: is a set formed by combining all the digital model lines containing the current line identifier from the first type of data in the CAD structure data.

[0096] Exemplarily, if there is a BOM line identifier of E01024432 in a certain line in the first type of data in the bill of materials, and there is also a BOM line identifier of E01024432 in a certain line in the first type of data in the CAD structure data, then this line in the first type of data in the bill of materials will be added to the first set, and this line in the first type of data in the CAD structure data will be added to the second set.

[0097] In addition, this application also generates a third set and a fourth set. Specifically, when a certain BOM line identifier exists in the first type of data in the bill of materials but does not exist in the first type of data in the CAD structure data, then these data lines in the bill of materials are gathered to generate a third set, that is, the set lacking DR.

[0098] When a certain BOM line identifier exists in the first type of data in the CAD structure data but does not exist in the first type of data in the bill of materials, then these data lines in the CAD structure data are gathered to generate a fourth set, that is, the set with redundant DR.

[0099] Determining the first comparison result based on the first set and the second set means that the above-mentioned first set, second set, third set, and fourth set together constitute the above-mentioned first comparison result.

[0100] Specifically, this application can use a Left Anti Join operation. Using the line identifier of the part usage line, i.e., the above-mentioned BOM line identifier, as the keyword, it identifies the inconsistent content between the first type of data and the second type of data and returns the first comparison result: the first set, the second set, the third set, and the fourth set.

[0101] Among them, Left Anti Join is a database join operation. In this context, a join operation is performed using the "BOM line identifier" as the key value. Briefly understood, it is to find the data rows in the first type of data that have no matching items in the second type of data. For example, assuming the first type of data is A and the second type of data is B, this operation is to find the part of A that is not in B.

[0102] Taking the above product as an automobile as an example, the beneficial effects of this embodiment are described. The first type of data, i.e., the data of the in-plant level structure, involves the basic part information of automobile production. By verifying the first type of data in the bill of materials and CAD structure data, it is possible to control the consistency of the bill of materials and CAD structure data on a large scale and ensure that the in-plant parts meet the design requirements. For example, by comparing information such as part numbers and specifications, it is possible to prevent the misdelivery and incorrect delivery of parts and avoid assembly problems caused by parts not conforming to the design.

[0103] In one of the embodiments, the second type of data in the bill of materials and CAD structure data is extracted. The second type of data is the data of the sub-structures of the parts in the first type of data, including: extracting the data corresponding to the parts with sub-structures from the first set to obtain the second type of data in the bill of materials, and extracting the CAD structures with sub-structures and associated parts from the second set to obtain the second type of data in the CAD structure data.

[0104] Among them, this application can extract all part identifiers such as part numbers from the first type of data in the bill of materials, remove duplicate values, and obtain a set of non-duplicate part numbers. Taking each part number in the part number set as the parent structure number, a query is performed in the database to determine whether each parent structure number has a corresponding sub-structure. The part numbers with sub-structures in the query results are screened out and classified into a new part number set, that is, the second type of data in the bill of materials is obtained.

[0105] Furthermore, the present application can obtain all DR IDs and the information with the attribute of "associated part number" in each row of data from the first type of data of CAD structure data. Combine the DR ID and its corresponding "associated part number", and then remove the duplicate combinations to obtain DR set 1. Further, use each DR ID in DR set 1 as the parent ID to query whether there is a corresponding sub-structure in the database. Screen out the DRs with sub-structures in the query results to obtain the second type of data in the CAD structure data. Among them, the associated parts can specifically include information such as associated part numbers or part names. Among them, DR refers to each CAD object in the CAD structure data, and a corresponding row of data, that is, a digital model row, is created for each DR in the CAD structure data.

[0106] The beneficial effect of this embodiment is as follows:

[0107] By extracting key information (such as part numbers) from the first type of data, querying the database to judge sub-structures and classify them, different levels of structure data can be clearly distinguished, which helps to deeply analyze the hierarchical relationship between data, such as the parent-child part relationship of parts and the parent-child structure relationship of DRs.

[0108] In one of the embodiments, the parent-child relationship includes a parent structure identifier and a corresponding sub-structure identifier. The CAD structure data includes multiple levels. Respectively extract the parent-child relationships between the structures in the second type of data of the bill of materials and the second type of data of the CAD structure data and compare them to obtain the second comparison result, including: extract the parts associated with each level in the second type of data of the CAD structure data and the parts associated with the sub-levels of each level, combine the parts associated with each level and the parts associated with the sub-levels of each level to obtain the parent-child relationships between the structures in the second type of data of the CAD structure data, and compare the parent-child relationships extracted from the bill of materials with the parent-child relationships extracted from the CAD structure data to obtain the second comparison result.

[0109] Among them, the parent-child relationship includes a parent structure identifier and a corresponding sub-structure identifier. Exemplarily, the parent-child relationship can be expressed as: parent structure number: 6608111110, sub-structure number: 6608000001, forming a combination of a pair of parent-child relationships.

[0110] That the CAD structure data includes multiple levels means that the CAD structure data presents a hierarchical organizational structure. For example, for the CAD model of a complex product, the top layer may be the overall product, the next level is each main component, each main component contains sub-components at the next level, and the sub-components are further broken down into smaller parts, etc. Each level represents a different granularity of the product structure decomposition. There is a parent-child relationship between the levels, with the upper level as the parent and the lower level as the child. Through this multi-level structure, the composition and mutual relationship of each part of the product are described in detail.

[0111] Please refer to Figure 2 , Figure 2 which is a schematic diagram of CAD structure data in an embodiment. In Figure 2 , a total of 5 levels are reflected, and each level describes a CAD object. In addition, each level also describes information such as the associated part number, configuration variable, and BOM line identifier.

[0112] It should be noted here that for Figure 2 such CAD structure data, when obtaining the first type of data, specifically obtain the data rows with a level greater than or equal to 5. This is because the part with a level less than 5 is a virtual module division, which means that the data at these levels may be more used for conceptual or overall architecture division and is not directly closely related to the key information for verifying the consistency of the bill of materials and CAD structure data. The data at levels greater than or equal to 5 may more specifically involve the actual association, configuration, etc. of specific parts and design solutions, which are the core contents for verifying consistency, such as the specific usage of parts and the corresponding relationship with the design solution.

[0113] In addition, when obtaining the first type of data, specifically, the level, functional location code, design solution ID, associated part number, usage, configuration variable, parent object ID, and design solution type, etc. can be obtained. Among them, when obtaining the associated part number, for the DR row with a level of 5, obtain it through the "associated part number" attribute of the row attribute, and for the DR row with a level greater than 5, obtain it from the "associated parts" folder of the DR object. Multiple part numbers may be obtained, and after removing duplicates, they are separated by semicolons. For the acquisition of the parent object ID, for the DR row at the 5th level, the attribute value is the design solution ID at the 4th level, and for the DR row with a level n greater than 5, the attribute value is the ID of its parent node (n - 1) row DR.

[0114] Please further refer to Figure 3 , Figure 3 which is a schematic diagram of the data structure of the second type of data of CAD structure data in an embodiment. In Figure 3shows the corresponding data of one of the DRs. Specifically, taking the two levels in the dashed box as an example, the part numbers corresponding to the upper level include: 6608000004 and 6608444444, and the part numbers corresponding to the lower level include: 6608000005 and 6608555555. Further, the part numbers corresponding to the upper level are combined with the part numbers corresponding to the next level, and the combination results include: 6608000004 and 6608000005, 6608000004 and 6608555555, 6608444444 and 6608000005, 6608444444 and 6608555555.

[0115] And so on, process the parent-child relationships between other levels to obtain the parent-child relationships between the structures in the second type of data of the CAD structure data.

[0116] Please further refer to Figure 4 , Figure 4 which is a schematic diagram of the data structure of the second type of data in the bill of materials in an embodiment. In Figure 4 it shows the corresponding data of one of the assembly parts. In Figure 4 it specifically shows the usage amounts of the assembly part and its sub-structures. Exemplarily, the part number of the parent structure is 6608111110, and the part number of one of its sub-structures is 6608000001, with the corresponding usage amount being 2.

[0117] Please further refer to Figure 5 , Figure 5 which is a schematic diagram of the result obtained after extracting the parent-child relationships from the second type of data in the bill of materials in an embodiment. In Figure 5 after extracting the parent-child relationships, it shows the combinations of various parent-child relationships and the usage amounts of the corresponding sub-structures. Among them, Figure 5 the child parts in it represent sub-structures, and the parent parts represent parent structures.

[0118] Further, assume the parent-child relationships extracted from the second type of data in the bill of materials as set M and the parent-child relationships extracted from the second type of data in the CAD structure data as set N, and perform a consistency comparison.

[0119] Specifically, you can sequentially use the "parent part number + child part number" in set M as the key value to find whether there is a matching parent-child part number combination in set N. If there is, mark it as already matched. After one parent-child combination in a group is successfully matched, the entire group is marked as already matched. Those marked as already matched do not participate in the matching of the next group of "parent part number + child part number".

[0120] If the parent-child relationship that exists in set M does not exist in set N, the second comparison result is output as "extra part structure". If the parent-child relationship that does not exist in set M exists in set N, the second comparison result is output as "extra DR part structure". If a certain combination of parent-child relationships exists in both set M and set N, it is output that the match is successful.

[0121] The beneficial effects of this embodiment are as follows:

[0122] Deep data verification is realized. Specifically, the present application extracts detailed parent-child relationships for the multi-level characteristics of CAD structure data, not only paying attention to the direct parent-child levels, but also involving the combined analysis of the parts associated with each level and sub-levels, realizing the deep verification of complex structure data and improving the accuracy of data verification.

[0123] Ensure data consistency. Specifically, by separately extracting the parent-child relationships of the second type of data in the bill of materials and CAD structure data and comparing them, the similarities and differences in the structural relationships between the two can be effectively found, ensuring the consistency of the product design (CAD structure data) and material configuration (bill of materials) at the structural level, and avoiding production mistakes caused by data differences.

[0124] In one of the embodiments, the parent-child relationships extracted from the bill of materials also include the usage amounts of each part. The data consistency verification method further includes: splitting the combinations of parent-child relationships with usage amounts greater than a preset threshold into multiple combinations of parent-child relationships, and comparing the parent-child relationships extracted from the bill of materials with the parent-child relationships extracted from the CAD structure data to obtain a second comparison result, including: comparing the split parent-child relationships with the parent-child relationships extracted from the CAD structure data to obtain a second comparison result.

[0125] Specifically, the present application can split the combinations of parent-child relationships with usage amounts greater than 1 into multiple combinations of parent-child relationships with usage amounts of 1.

[0126] Please refer to Figure 6 , in Figure 6 , the data before usage amount splitting and the data after usage amount splitting are illustrated. As can be seen from Figure 6 , the combination of parent-child relationships with a sub-part usage amount of 2 is split into 2 combinations of parent-child relationships. In each of the split groups of parent-child relationships, the usage amount of the sub-part is 1.

[0127] The beneficial effects of this embodiment are as follows:

[0128] Refined data comparison unit: Split the parent-child relationship combinations with usage greater than the preset threshold (e.g., greater than 1), so that the comparison unit is refined from multi-usage combinations to single-usage combinations. This helps to perform more accurate and detailed matching when comparing with CAD structure data, because CAD structure data is generally constructed based on the structural relationships of individual parts. After such adjustment, it can better correspond to the CAD data and improve the comparison accuracy.

[0129] Improve the accuracy of data consistency judgment: Different part usages in the bill of materials may lead to more complex structural relationships in actual applications. By splitting, the parent-child relationships under each single usage can be clearly presented, avoiding the masking of structural differences by multi-usage combinations, and making the judgment of data consistency more accurate when comparing with CAD structure data.

[0130] In one of the embodiments, combining the parts associated with each level and the parts associated with the sub-levels of each level to obtain the parent-child relationships between the structures in the second type of data of the CAD structure data may include: Combining the parts associated with each level and the parts associated with the sub-levels of each level according to the Cartesian product algorithm to obtain the parent-child relationships between the structures in the second type of data of the CAD structure data.

[0131] Among them, the principle of the Cartesian product algorithm is: In mathematics, the Cartesian product of two sets A and B, denoted as A×B, is the set of all possible ordered pairs (a, b), where a ∈ A and b ∈ B. For example, if set A = {1, 2} and set B = {3, 4}, then the Cartesian product A×B of A and B = {(1, 3), (1, 4), (2, 3), (2, 4)}. In a broader sense, for the case of multiple sets, it is to take one element from each set to form a multi-tuple, and the set composed of all possible multi-tuples is the Cartesian product of these sets.

[0132] Specifically, in this application, the set of parts associated with each level in the CAD structure data can be regarded as a set, and the sets of parts associated with the sub-levels of each level are also regarded as different sets respectively. Suppose the set of parts associated with level 1 is A = {a1, a2, a3}, the set of parts associated with the sub-level of level 1 is B = {b1, b2}, the set of parts associated with level 2 is C = {c1, c2}, the set of parts associated with the sub-level of level 2 is D = {d1, d2, d3}, etc.

[0133] Further, execute the Cartesian product algorithm to perform the Cartesian product operation on these sets. For example, first calculate the combinations of level 1 and its sub-levels to obtain {(a1,b1),(a1,b2),(a2,b1),(a2,b2),(a3,b1),(a3,b2)}. Then continue to perform the Cartesian product operation with level 2 and its sub-levels, etc., gradually constructing the combinations of all hierarchical associated parts and sub-level associated parts.

[0134] Further, summarize the ordered pair combinations obtained by the Cartesian product algorithm for each level, and the parent-child relationships between the various structures in the second type of data of the CAD structure data can be obtained.

[0135] To further illustrate the process of executing the Cartesian product algorithm, please refer to Figure 7 , Figure 7 For a schematic diagram showing the result of running the Cartesian product algorithm in an embodiment. In Figure 7 , for the first row and the second row, execute the Cartesian product algorithm, that is, perform the operation on 6608111110 and 6608000001. The result is only one: the parent part number is 6608111110, and the child part number is 6608000001. When the first row and the second row are operated, the result also shows that the parent part number is 6608111110 and the child part number is 6608000001. When the first row and the third row are operated, that is, 6608111110 is operated with 6608000002 and 6608222222, the results are two groups: the parent part number is 6608111110 and the child part number is 6608000002, and the parent part number is 6608111110 and the child part number is 6608222222. And so on, calculate the other rows.

[0136] For further reference, please refer to Figure 8 , Figure 8 In an embodiment, match the parent-child relationships calculated by the Cartesian product algorithm with the parent-child relationships after splitting in the bill of materials. When comparing, match each combination of the parent-child relationships on the right with each one on the left. If the parent part number on the right is the same as the parent part number on the left, and the child part number on the right is the same as the child part number on the left, then the matching is successful.

[0137] The beneficial effect of this embodiment is that:

[0138] By adopting the Cartesian product algorithm, it is possible to ensure that all possible combination methods between all hierarchical associated parts and sub - hierarchical associated parts are comprehensively considered. This makes the generated parent - child relationship complete, without missing any potential structural relationships, providing accurate CAD structure data parent - child relationships for comparison with bill of materials data. The bill of materials usually also records the parent - child relationship in a structured form, and the relationship generated by the Cartesian product matches it in form and granularity, enabling one - to - one accurate comparison and improving the accuracy of judging data consistency.

[0139] In addition, in complex CAD structure data, there are numerous levels and parts, and it is difficult for humans to enumerate all parent - child relationship combinations. The Cartesian product algorithm automatically generates all combinations through mathematical operations, ensuring the comprehensiveness of the analysis and avoiding the missing of relationships caused by subjective judgment or human negligence.

[0140] In one of the embodiments, the consistency check result between the bill of materials and the CAD structure data further includes a third comparison result. The data consistency check method may further include: extracting the target structure in the bill of materials and the CAD structure data and the configuration information of the product assembled by the target structure, where the target structure is a structure with different positions in products of different configuration versions, the product is the product corresponding to the bill of materials, obtaining the engineering configuration table of the product, which includes the configuration information corresponding to different configuration versions, respectively resolving the target structure data in the bill of materials and the CAD structure data according to the engineering configuration table, and comparing the resolved results to obtain the third comparison result.

[0141] Among them, the engineering configuration table is a tabular document used to record the relevant configuration information of a product under different configuration versions. It uses specific fields (such as vehicle model code) as indexes and details the specific parameters, characteristics, assembly requirements, etc. of each structure, component, etc. of the product under different configuration conditions, which is a systematic sorting and recording of the product configuration situation.

[0142] The role of adopting the engineering configuration table in this application is to provide a unified configuration information reference standard for the bill of materials, CAD structure data, etc., ensuring that data from different sources can be accurately corresponded and understood at the configuration level, and realizing a unified data standard. In addition, it can also serve as an intermediate bridge to facilitate the resolution and comparison of configuration - related data in the bill of materials and CAD structure data, and discover data differences and problems.

[0143] In this application, there are some special structures, namely the target structures in this application. These target structures are structures with different positions in products of different versions. Taking the trailer hitch of a car as an example, in all versions of cars, the trailer hitch is a common part and only one is needed for each vehicle. Therefore, in the bill of materials, the trailer hitch is only recorded as one line. However, in the CAD structure data, due to the different numbers of seats in products of different versions, the installation position of the trailer hitch on the whole vehicle will change. To accurately reflect these position differences, the CAD data needs to split the trailer hitch-related information into multiple lines according to different installation positions and distinguish them through configuration information.

[0144] To determine the consistency of these target structures, first, the dotting information (which may be used to mark position and other information) in the CAD structure data needs to be converted into a form similar to the single-vehicle usage in the bill of materials. After the conversion, data comparison is carried out to determine whether the two sets of data are consistent.

[0145] Specifically, this application can find the target structures and the configuration information of the products assembled by the target structures from the bill of materials and the CAD structure data, and determine the key identification information such as the "model code" and "data version" of the product. According to the model code and data version and other information, the corresponding engineering configuration table is obtained, where the data version refers to the version information of the bill of materials and the CAD structure data.

[0146] Furthermore, according to the configuration information in the engineering configuration table, the target structure data in the bill of materials and the CAD structure data are respectively resolved, and the data is converted into a comparable form. The target structure data of the resolved bill of materials and CAD structure data are compared to obtain the third comparison result, and determine whether the data is consistent and the existing differences.

[0147] In a possible design, the specific resolution steps may include:

[0148] Find the configuration items related to the target structure of the bill of materials in the engineering configuration table. For example, match the corresponding configuration conditions according to the name, number, etc. of the target structure, such as a specific model under the model code.

[0149] According to the matched configuration items, extract the corresponding configuration parameters from the engineering configuration table, which may include information such as the quantity, specification, and special requirements of the target structure.

[0150] If there are situations where the usage amounts are different under different versions, according to the configuration information in the engineering configuration table and the preset calculation rules, adjust and calculate the data such as the single-vehicle usage of the target structure in the bill of materials. For example, if the engineering configuration table stipulates that an additional spare part is required for a certain part under a certain version, the single-vehicle usage in the bill of materials is modified accordingly.

[0151] Sort out the extracted and calculated data according to unified standards and formats to make it consistent with the CAD structure data in terms of data types, units, etc., facilitating subsequent comparison.

[0152] According to the configuration information in the engineering configuration table, find the configuration differentiation identifiers corresponding to the target structure in the CAD structure data, such as specific configuration variables, marks, etc., and determine the specific data records of the target structure under different configuration versions.

[0153] For geometric information such as the installation position related to the target structure in the CAD structure, perform coordinate system unification, unit conversion, etc. according to the requirements in the engineering configuration table and relevant standards.

[0154] According to the configuration conditions in the engineering configuration table, screen and extract the target structure data in the CAD structure data. For example, only retain the data of the target structure and its sub-structures that meet the requirements of specific version configurations.

[0155] Convert the processed CAD structure data into a form comparable to the bill of materials data. For example, convert the position information in CAD into a form that can correspond to the data such as usage in the bill of materials. It may be encoding the position information as specific codes or numerical values to facilitate comparison with the bill of materials data.

[0156] To further illustrate the solution process, please refer to Figure 9 , Figure 9 In an embodiment, it is a schematic diagram of the principle for settling the bill of materials and CAD structure data. Among them, S in the figure represents configured, O represents optional, "-" represents unconfigured, and version 1, version 2, version 3, and version 4 represent different versions of the same vehicle, such as luxury version, ordinary version, etc. The bill of materials and CAD structure data before settlement include the selected target structures such as part 001, part 002, part 003, and part 004 in the figure, and also include the corresponding configuration information of these parts. For example, part 001 is configured on the panoramic sunroof version, part 002 is configured on the ordinary sunroof version, etc. The settlement process is to replace these specific information before configuration with S, O, and "-" in the engineering configuration table to obtain the engineering bill of materials with configuration markings.

[0157] Furthermore, please refer to Figure 10 , Figure 10 It is the set of part lines and the set of DR line data after settlement. In the set of part lines after settlement, it includes part line numbers, usage amounts, BOM line identifiers, and configuration situations on products of each version. In the set of DR line data after settlement, it includes DR line numbers, usage amounts, BOM line identifiers, and configuration situations on products of each version.

[0158] Further, replace the value of S usage amount in the solved part line set and the solved DR line data set, and replace "-" with the number 0, to obtain the solved part line set with usage amount and the solved DR line data set with usage amount respectively.

[0159] Further, verify the solved part line set with usage amount and the solved DR line data set with usage amount. If the usage amounts are inconsistent, return the inspection result "Usage amounts are inconsistent". Integrate this inspection result into the consistency verification result of the bill of materials and CAD structure data.

[0160] The beneficial effect of this embodiment is that:

[0161] By performing data calculation and comparison based on the engineering configuration table, it is ensured that the bill of materials and CAD structure data under different configuration versions are consistent in configuration information, and errors and inconsistencies in the bill of materials and CAD structure data can be effectively discovered and corrected.

[0162] In a second aspect, the present application provides a data consistency verification device, as Figure 11 shown. The data consistency verification device includes: a first comparison module 111, an extraction module 112, a second comparison module 113, and a determination module 114, where:

[0163] The first comparison module 111 is used to extract the first type of data in the bill of materials and the CAD structure data associated with the bill of materials and perform consistency comparison to obtain a first comparison result. The first type of data is the first-level part data in the bill of materials;

[0164] The extraction module 112 is used to extract the second type of data in the bill of materials and the CAD structure data. The second type of data is the data of the sub-structure of the parts in the first type of data;

[0165] The second comparison module 113 is used to respectively extract the parent-child relationships between the structures in the second type of data of the bill of materials and the second type of data of the CAD structure data and perform consistency comparison to obtain a second comparison result;

[0166] The determination module 114 is used to determine the consistency verification result of the bill of materials and the CAD structure data according to the first comparison result and the second comparison result.

[0167] In one embodiment, the CAD structure data includes at least one digital model line, and the bill of materials includes at least one part usage line. The digital model line records the line identifier associated with the part usage line. The first comparison module 111 can extract the first type of data in the bill of materials and the CAD structure data associated with the bill of materials, and compare each data line of the first type of data in the bill of materials and the CAD structure data according to the line identifier. If the current line identifier exists in both the first type of data in the bill of materials and the first type of data in the CAD structure data, a first set and a second set are generated. The first set is the set composed of the part usage lines in the bill of materials that contain the current line identifier, and the second set is the set composed of the digital model lines in the CAD structure data that contain the current line identifier. The first comparison result is determined according to the first set and the second set.

[0168] In one embodiment, the extraction module 112 can extract the data corresponding to the parts with sub-structures from the first set to obtain the second type of data in the bill of materials, and extract the CAD structure with sub-structures and the associated parts from the second set to obtain the second type of data in the CAD structure data.

[0169] In one embodiment, the parent-child relationship includes a parent structure identifier and the corresponding sub-structure identifier. The CAD structure data includes multiple levels. The second comparison module 113 can extract the parts associated with each level and the parts associated with the sub-levels of each level in the second type of data of the CAD structure data, combine the parts associated with each level and the parts associated with the sub-levels of each level, obtain the parent-child relationships between the structures in the second type of data of the CAD structure data, and compare the parent-child relationships extracted from the bill of materials with the parent-child relationships extracted from the CAD structure data to obtain the second comparison result.

[0170] In one embodiment, the parent-child relationships extracted from the bill of materials further include the usage amounts of each part. The second comparison module 113 can also split the combinations of the parent-child relationships with usage amounts greater than the preset threshold into multiple combinations of parent-child relationships, and compare the split parent-child relationships with the parent-child relationships extracted from the CAD structure data to obtain the second comparison result.

[0171] In one embodiment, the second comparison module 113 can combine the parts associated with each level and the parts associated with the sub-levels of each level according to the Cartesian product algorithm to obtain the parent-child relationships between the structures in the second type of data of the CAD structure data.

[0172] In one embodiment, the consistency check result of the bill of materials and the CAD structure data further includes a third comparison result. The determination module 114 can also extract the target structures in the bill of materials and the CAD structure data, as well as the configuration information of the products assembled by the target structures. The target structure is a structure with different positions in products of different configuration versions, and the product is the product corresponding to the bill of materials. Obtain the engineering configuration table of the product, where the engineering configuration table includes the configuration information corresponding to different configuration versions. Resolve the target structure data in the bill of materials and the CAD structure data respectively according to the engineering configuration table, and compare the resolved results to obtain the third comparison result.

[0173] In a third aspect, the present application provides a computer device. The computer device includes a memory, a processor, and a computer program stored on the memory and executable on the processor. When the processor executes the computer program, it implements the steps of the data consistency check method provided in any embodiment of the first aspect of the present application.

[0174] In one embodiment, the computer device may be a server, and its internal structure diagram may be as Figure 12 shown. The computer device includes a processor, a memory, and a network interface connected through a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The network interface of the computer device is used to communicate with external terminals through a network connection. When the computer program is executed by the processor, it implements the data consistency check method.

[0175] In a fourth aspect, the present application provides a computer-readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, it implements the steps of the data consistency check method provided in any embodiment of the first aspect of the present application.

[0176] The computer-readable storage medium may be the Figure 12 computer-readable storage medium in the computer device shown.

[0177] Those of ordinary skill in the art can understand that all or part of the processes in the methods of the above embodiments can be completed by instructing relevant hardware through a computer program. The above computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above various methods. Among them, any reference to a memory, storage, database, or other medium used in the various embodiments provided in the present application can include non-volatile and / or volatile memories. Non-volatile memory can include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM), or flash memory. Volatile memory can include random access memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in many forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDR SDRAM), enhanced SDRAM (ESDRAM), synchronous link DRAM (SLDRAM), Rambus direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and Rambus dynamic RAM (RDRAM), etc.

[0178] The technical features of the above embodiments can be combined arbitrarily. For the sake of brevity of description, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, it should be considered as the scope recorded in this specification.

[0179] The above embodiments only represent several implementation manners of the present application. The description is relatively specific and detailed, but it cannot be understood as a limitation on the scope of the invention patent. It should be noted that for those of ordinary skill in the art, without departing from the concept of the present application, several modifications and improvements can still be made, and these all belong to the protection scope of the present application. Therefore, the protection scope of the patent of the present application should be subject to the appended claims.

Claims

1. A data consistency verification method, characterized in that, The method includes: extracting the first type of data from the bill of materials and the CAD structure data associated with the bill of materials and performing a consistency comparison to obtain a first comparison result, where the first type of data is the first-level part data in the bill of materials; extracting the second type of data from the bill of materials and the CAD structure data, where the second type of data is the data of the sub-structures of the parts in the first type of data; respectively extracting the parent-child relationships between the structures in the second type of data of the bill of materials and the second type of data of the CAD structure data and performing a consistency comparison to obtain a second comparison result; determining the consistency verification result of the bill of materials and the CAD structure data according to the first comparison result and the second comparison result.

2. The method according to claim 1, wherein The CAD structure data includes at least one digital model line, and the bill of materials includes at least one part usage line. The digital model line records the line identifier associated with the part usage line. Extracting the first type of data from the bill of materials and the CAD structure data associated with the bill of materials and comparing them to obtain a first comparison result includes: extracting the first type of data from the bill of materials and the CAD structure data, and comparing each data line of the first type of data in the bill of materials and the CAD structure data according to the line identifier; if the current line identifier exists in both the first type of data in the bill of materials and the first type of data in the CAD structure data, generating a first set and a second set, where the first set is the set of part usage lines in the bill of materials that contain the current line identifier, and the second set is the set of digital model lines in the CAD structure data that contain the current line identifier; determining the first comparison result according to the first set and the second set.

3. The method according to claim 2, wherein The extracting the second type of data from the bill of materials and the CAD structure data, where the second type of data is the data of the sub-structures of the parts in the first type of data, includes: extracting the data corresponding to the parts with sub-structures from the first set to obtain the second type of data in the bill of materials; extracting the CAD structures with sub-structures and the associated parts from the second set to obtain the second type of data in the CAD structure data.

4. The method according to claim 1, characterized in that, The parent-child relationship includes a parent structure identifier and a corresponding sub-structure identifier. The CAD structure data includes multiple levels. The respectively extracting the parent-child relationships between the structures in the second type of data of the bill of materials and the second type of data of the CAD structure data and performing a comparison to obtain a second comparison result includes: extracting the parts associated with each level in the second type of data of the CAD structure data and the parts associated with the sub-levels of each level; combining the parts associated with each level and the parts associated with the sub-levels of each level to obtain the parent-child relationships between the structures in the second type of data of the CAD structure data; comparing the parent-child relationships extracted from the bill of materials with the parent-child relationships extracted from the CAD structure data to obtain the second comparison result.

5. The method according to claim 4, wherein The parent-child relationships extracted from the bill of materials also include the usage amounts of each part, and the method further includes: Splitting the combinations of parent-child relationships with usage amounts greater than a preset threshold into multiple combinations of parent-child relationships; The comparing the parent-child relationships extracted from the bill of materials with the parent-child relationships extracted from the CAD structure data to obtain the second comparison result includes: Comparing the split parent-child relationships with the parent-child relationships extracted from the CAD structure data to obtain the second comparison result.

6. The method according to claim 4, characterized in that The combining the parts associated with each level and the parts associated with the sub-levels of each level to obtain the parent-child relationships between the structures in the second type of data of the CAD structure data includes: Combining the parts associated with each level and the parts associated with the sub-levels of each level according to the Cartesian product algorithm to obtain the parent-child relationships between the structures in the second type of data of the CAD structure data.

7. The method according to claim 1, characterized in that, The consistency verification result of the bill of materials and the CAD structure data further includes a third comparison result, and the method further includes: Extracting the target structures in the bill of materials and the CAD structure data and the configuration information of the products assembled by the target structures, where the target structures are the structures with different positions in products of different configuration versions, and the products are the products corresponding to the bill of materials; Obtaining the engineering configuration table of the product, where the engineering configuration table includes the configuration information corresponding to different configuration versions; Resolving the target structure data in the bill of materials and the CAD structure data respectively according to the engineering configuration table; Comparing the resolved results to obtain the third comparison result.

8. A data consistency verification device, characterized in that, The device includes: A first comparison module, configured to extract the first type of data in the bill of materials and the CAD structure data associated with the bill of materials and perform a consistency comparison to obtain a first comparison result, where the first type of data is the first-level part data in the bill of materials; An extraction module, configured to extract the second type of data in the bill of materials and the CAD structure data, where the second type of data is the data of the sub-structures of the parts in the first type of data; A second comparison module, configured to extract the parent-child relationships between the structures in the second type of data of the bill of materials and the second type of data of the CAD structure data respectively and perform a consistency comparison to obtain a second comparison result; A determination module, configured to determine the consistency verification result of the bill of materials and the CAD structure data according to the first comparison result and the second comparison result.

9. A computer device, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, characterized in that, When the processor executes the computer program, it implements the steps of the method according to any one of claims 1 to 7.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by the processor, it implements the steps of the method according to any one of claims 1 to 7.

Images