Method and device for checking component data
By performing uniqueness and format verification on the attribute information table of component data, constructing and storing pairing relationships, the problems of low efficiency and low accuracy of component data verification are solved, and efficient and accurate data integration and storage are achieved.
Patent Information
- Application Number
- CN202411451051.6
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-10-17
- Publication Date
- 2025-11-11
- Estimated Expiration
- 2044-10-17
AI Technical Summary
In existing technologies, the verification efficiency and accuracy of component data are low, manual processing is prone to errors, and the data is incomplete and inconsistent in format.
By obtaining the attribute information table created by the user, performing uniqueness and format validation, constructing the pairing relationship between attribute item information and parameter attribute information, and storing it in a tree-like relationship.
It improves the efficiency and accuracy of component data verification, ensures data integrity and format consistency, and facilitates subsequent retrieval.
Smart Images

Figure CN119474080B_ABST
Abstract
Description
Technical Field
[0001] This invention belongs to the field of data verification technology, specifically relating to a method and apparatus for verifying component data. Background Technology
[0002] With the development of industrial technology, simple paper selection manuals or simple PDF manuals can no longer meet the selection needs of engineers. In the process of industrial product design and mechanical design, engineers need to use more and more component model data. The model data includes the following elements: product manual, product specification parameter table, product appearance thumbnail, product dimension annotation diagram, product 3D model, etc. However, these elements are often scattered in different places, requiring a lot of time to find and integrate, which greatly reduces the efficiency of engineers' selection. Therefore, it is necessary to integrate the data into a component resource library for easy access when needed.
[0003] The existing technology relies on manual data processing for each element and storage in a resource library. However, due to the large amount of data and the high repetitiveness of the processing work, manual processing is prone to errors. Often, the processed tables are not standardized, the styles are inconsistent, the names on the parameter tables do not correspond to the 3D models, and when errors occur, it is difficult to find the specific problems. In addition, the manually processed data is often incomplete and lacks specification parameters. Summary of the Invention
[0004] To overcome the shortcomings of the prior art, the present invention provides a method and apparatus for verifying component data, so as to solve the problems of low verification efficiency and low verification accuracy of component data in the prior art.
[0005] One embodiment of the present invention provides a method for verifying component data, comprising the following steps:
[0006] Obtain the attribute information table created by the user, wherein the attribute information table is a single-master table or a multi-master table;
[0007] Obtain the attribute item information and parameter attribute information from the attribute information table;
[0008] The attribute information table is validated for uniqueness based on the attribute item information, and the format is validated based on the parameter attribute information.
[0009] When both the uniqueness check and the format check pass, a pairing relationship is constructed between the attribute item information and the parameter attribute information, and the pairing relationship is generated into a tree structure in a preset storage system and stored.
[0010] In this embodiment, the present invention only verifies the attribute item information and parameter attribute information in the main table, thereby ensuring the efficiency and accuracy of the component data inspection process, and can store the component data in a tree-like relationship after the verification is passed.
[0011] In one embodiment, the attribute item information includes product name, product model, configuration model, 3D model name and manufacturer name, and the parameter attribute information is the parameter information corresponding to the attribute item information.
[0012] In one embodiment, the uniqueness check of the attribute information table based on the attribute item information includes:
[0013] Determine if at least two identical product names exist under the same manufacturer name;
[0014] If so, the uniqueness check fails, and the location and error type of the at least two identical product names are output to the user;
[0015] If not, then determine whether there are at least two identical configuration models under the same manufacturer name;
[0016] If so, the uniqueness check fails, and the location and error type of the at least two identical configuration models are output to the user;
[0017] If not, then the uniqueness check of the attribute information table passes.
[0018] In one embodiment, the format validation based on the parameter attribute information includes:
[0019] Identify the text format and formula in the parameter attribute information, and determine whether the text format and formula are correct;
[0020] If the text format and formula are correct, the format validation of the parameter attribute information passes.
[0021] In one embodiment, the method further includes:
[0022] The numerical value range and step size in the parameter attribute information are verified based on a preset engineering database.
[0023] If the verification fails, the error type and error location will be returned.
[0024] In one embodiment, constructing a pairing relationship between attribute item information and the parameter attribute information, and generating and storing the pairing relationship in a tree structure in a preset storage system includes:
[0025] Under the same configuration model, establish a first pairing relationship between the attribute item information and the parameter attribute information;
[0026] Under the same configuration model, construct a second pairing relationship between the attributes in the attribute item information;
[0027] Under the same configuration model, a third pairing relationship is constructed between the attributes in the parameter attribute information;
[0028] The first pairing relationship, the second pairing relationship, and the third pairing relationship are stored in a preset storage system in a tree-like manner.
[0029] In one embodiment, the method further includes:
[0030] Determine the primary association information between parameters of the parameter attribute information in different configuration models under the same product name;
[0031] Based on the first association information, determine the number of series, specifications, and 3D models of the same product name.
[0032] One embodiment of the present invention also provides a component data verification device, comprising:
[0033] The table acquisition module is used to acquire attribute information tables created by the user, wherein the attribute information tables are single-master tables or multiple-master tables;
[0034] The information acquisition module is used to acquire attribute item information and parameter attribute information from the attribute information table;
[0035] The verification module is used to perform uniqueness verification on the attribute information table based on the attribute item information, and to perform format verification based on the parameter attribute information;
[0036] The storage module is used to construct a pairing relationship between the attribute item information and the parameter attribute information when both the uniqueness check and the format check pass, and to generate a tree-like relationship of the pairing relationship in a preset storage system and store it.
[0037] In this embodiment, the advantages and beneficial effects of the component data verification method have been described above and will not be repeated here. Furthermore, since the component data verification device uses the component data verification method, the component data verification device also has the same advantages and beneficial effects.
[0038] One embodiment of the present invention also provides a readable storage medium storing a computer program, the computer program including program instructions, which, when executed by a processor of an electronic device, cause the processor to perform the steps of any of the component data verification methods described above.
[0039] One embodiment of the present invention also provides an electronic device, including: a processor and a memory, the memory being used to store computer program code, the computer program code including computer instructions, and when the processor executes the computer instructions, the electronic device performs the steps of any of the component data verification methods described above. Attached Figure Description
[0040] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on the structures shown in these drawings without creative effort.
[0041] Figure 1 A flowchart illustrating a method for verifying component data according to one embodiment of the present invention;
[0042] Figure 2 This is a schematic diagram of an attribute information table provided in one embodiment of the present invention;
[0043] Figure 3 This is a schematic diagram illustrating the working principle of an electronic device provided in one embodiment of the present invention. Detailed Implementation
[0044] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative effort are within the scope of protection of the present invention.
[0045] It should be noted that if the embodiments of the present invention involve directional indications (such as up, down, left, right, front, back, etc.), the directional indications are only used to explain the relative positional relationship and movement of the components in a specific posture. If the specific posture changes, the directional indications will also change accordingly.
[0046] Furthermore, if the embodiments of this invention involve descriptions such as "first" or "second," these descriptions are for descriptive purposes only and should not be construed as indicating or implying their relative importance or implicitly specifying the number of technical features indicated. Thus, a feature defined with "first" or "second" may explicitly or implicitly include at least one of those features. Additionally, the use of "and / or" or "and / or" throughout the text includes three parallel solutions. For example, "A and / or B" includes solution A, solution B, or a solution where both A and B are satisfied simultaneously. Furthermore, the technical solutions of the various embodiments can be combined with each other, but this must be based on the ability of those skilled in the art to implement them. When the combination of technical solutions is contradictory or impossible to implement, it should be considered that such a combination of technical solutions does not exist and is not within the scope of protection claimed by this invention.
[0047] Please see Figures 1-3 One embodiment of the present invention provides a method for verifying component data, comprising the following steps:
[0048] S100. Obtain the attribute information table created by the user, wherein the attribute information table is a single master table or a multi-master table.
[0049] In this embodiment, as Figure 2 The image shows the specific format of the attribute information table. This table is created and uploaded by the user. After the user uploads the attribute information table to the verification system, the system verifies the table in response to the user's verification command. The attribute information table can be a single-master table or a multi-master table. It should be noted that, for example... Figure 2 The attribute information table shown is only an example. Therefore, in specific application scenarios, users can create attribute information tables that include more information or delete information as needed.
[0050] S200. Obtain the attribute item information and parameter attribute information from the attribute information table.
[0051] In one embodiment, the attribute item information includes product name, product model, configuration model, 3D model name and manufacturer name, and the parameter attribute information is the parameter information corresponding to the attribute item information.
[0052] In this embodiment, as Figure 2As shown, the attribute information includes at least the product name, product model, configuration model, 3D model name, and manufacturer name. Attribute information is mandatory in the main table. Therefore, during the validation process, relevant keywords in the main table's attribute information can be identified first. If any item is not identified, such as the product name, the user needs to modify the attribute information table and re-upload it to ensure that the attribute information covers the necessary information in the component data. Parameter attribute information refers to the parameter information corresponding to the attribute information, indicating the specific parameters of that attribute information. For example... Figure 2 The dimensions and stroke of the product are all parameter attributes. These attribute information is user-defined; therefore, it's understandable that in specific applications, parameter attributes can be flexibly added or deleted according to actual needs. For example, if Company 1 produces Product 1, and the customer or company only focuses on the product's dimensions and weight, then other parameter attributes can be deleted. Figure 2 Includes the stroke, mounting holes, etc.
[0053] S300, perform uniqueness verification on the attribute information table based on the attribute item information, and perform format verification based on the parameter attribute information.
[0054] In this embodiment, the uniqueness of attribute item information is the primary consideration. Since pairing relationships need to be established later, problems with uniqueness can lead to confusion when storing component data in association, and also hinder engineers from accessing component data later. Therefore, it is necessary to perform uniqueness verification on the main table through attribute item information to ensure the uniqueness of each attribute item information. Uniqueness refers to whether each attribute in the attribute item information is unique and there is no duplication between attributes. For parameter attribute information, the main consideration is the format to avoid errors in the description of attribute item information. Therefore, format verification is required to ensure that the format of parameter attribute information is accurate.
[0055] In one embodiment, the uniqueness check of the attribute information table based on the attribute item information includes:
[0056] Determine if at least two identical product names exist under the same manufacturer name;
[0057] If so, the uniqueness check fails, and the location and error type of the at least two identical product names are output to the user;
[0058] If not, then determine whether there are at least two identical configuration models under the same manufacturer name;
[0059] If so, the uniqueness check fails, and the location and error type of the at least two identical configuration models are output to the user;
[0060] If not, then the uniqueness check of the attribute information table passes.
[0061] In this embodiment, multiple products under the same manufacturer's name are checked to determine if two products have the same name. For example, if products A and B are both manufactured by manufacturer C, but use the same name, the uniqueness check fails. The location of the error (i.e., the location of products A and B) and the error type are returned to the user to prompt them to make corrections. If no error is found, it means the product name description is correct. Further checks are needed to determine if the same configuration model is used to name multiple models. If so, a uniqueness issue also exists, and the check fails. Therefore, the uniqueness check is a check for the uniqueness of product names and configuration models under the same manufacturer's name. Furthermore, to ensure the accuracy of attribute information, a uniqueness check can be performed on each attribute in the attribute information. Only when all attributes pass the uniqueness check is the attribute information considered to have passed the uniqueness check.
[0062] In one embodiment, the format validation based on the parameter attribute information includes:
[0063] Identify the text format and formula in the parameter attribute information, and determine whether the text format and formula are correct;
[0064] If the text format and formula are correct, the format validation of the parameter attribute information passes.
[0065] In this embodiment, since the parameter attribute information is mainly numbers, technical text, or formulas, for example... Figure 2 The parameter attribute information in the body size is 51X54, which is in the form of numbers and letters, while the parameter attribute information of the mounting hole is threaded hole, which is in the form of text. Therefore, the main focus is on whether the text format and formula are correct. The text format includes both text and units. For the verification of text format and formula, a comparison can be made according to the preset standard format. For example, if the mounting hole does not contain numbers in the preset standard format, but the parameter attribute information in the main table contains numbers, then the parameter attribute information corresponding to the mounting hole is incorrect. The corresponding format verification result can be obtained according to the above method.
[0066] In one embodiment, the method further includes:
[0067] The numerical value range and step size in the parameter attribute information are verified based on a preset engineering database.
[0068] If the verification fails, the error type and error location will be returned.
[0069] In this embodiment, considering that the value of a certain parameter has a certain range, if it exceeds the range, it indicates that the parameter in the table is abnormal. Therefore, it is also necessary to verify the value range and step size of the parameter attribute information to ensure the correctness of the parameter attribute information. The verification method is to judge by the data recorded in the preset engineering database.
[0070] S400. When both the uniqueness check and the format check pass, construct a pairing relationship between the attribute item information and the parameter attribute information, and generate a tree-like relationship for the pairing relationship in a preset storage system and store it.
[0071] In this embodiment, a pairing relationship is constructed between attribute item information and parameter attribute information, and stored in a preset storage system in a tree structure. Since the uniqueness or format of the attribute item information and parameter attribute information will affect the correctness of the constructed tree structure, the pairing relationship in the main table can only be stored as a tree result after passing the uniqueness and format verification. Specifically, the attribute information of the same product name and the same model can be stored in a tree result to facilitate subsequent calls by engineers.
[0072] In one embodiment, constructing a pairing relationship between attribute item information and the parameter attribute information, and generating and storing the pairing relationship in a tree structure in a preset storage system includes:
[0073] Under the same configuration model, establish a first pairing relationship between the attribute item information and the parameter attribute information;
[0074] Under the same configuration model, construct a second pairing relationship between the attributes in the attribute item information;
[0075] Under the same configuration model, a third pairing relationship is constructed between the attributes in the parameter attribute information;
[0076] The first pairing relationship, the second pairing relationship, and the third pairing relationship are stored in a preset storage system in a tree-like manner.
[0077] In this embodiment, under the same configuration model, there are relationships between attribute item information and parameter attribute information, relationships within attribute item information, and relationships within parameter attribute information. Therefore, the relationship between attribute item information and parameter attribute information is determined first to obtain the first pairing relationship. Then, the relationship between each part within the attribute item information is determined to obtain the second pairing relationship. Finally, the relationship within the parameter attribute information is determined to obtain the third pairing relationship. Thus, the first, second, and third pairing relationships need to be determined separately. Based on the above pairing relationships, the relationships between the parameters of the same configuration model can be associated, ensuring that when the information of the configuration model needs to be called, the parameter information and item information can be directly called.
[0078] In one embodiment, the method further includes:
[0079] Determine the primary association information between parameters of the parameter attribute information in different configuration models under the same product name;
[0080] Based on the first association information, determine the number of series, specifications, and 3D models of the same product name.
[0081] In this embodiment, the number of series, specifications, and 3D models of the same product name can be calculated to determine the number of tree relationships stored in the preset storage system, and the data situation inside the product can also be determined, ensuring that the data of each configuration model under the product name has been verified and stored.
[0082] In summary, this solution accurately identifies the correctness of the format, the specific content of each attribute parameter, and the pairing constraints between attributes by verifying a single master table or multiple master tables. The identified specific attribute parameters and their pairing relationships are then generated in the system according to a tree structure, making data construction simpler, easier to learn, more efficient, and producing better data quality while saving labor costs.
[0083] This specification provides a method and apparatus for verifying component data. The method includes: acquiring an attribute information table created by a user, wherein the attribute information table is a single-master table or a multi-master table; acquiring attribute item information and parameter attribute information in the attribute information table; performing uniqueness verification on the attribute information table based on the attribute item information, and performing format verification based on the parameter attribute information; when both the uniqueness verification and the format verification pass, constructing a pairing relationship between the attribute item information and the parameter attribute information, and generating a tree-like relationship for the pairing relationship in a preset storage system and storing it, thereby improving the verification efficiency and accuracy of component data, and facilitating subsequent retrieval of component data by storing the pairing relationship.
[0084] One embodiment of the present invention also provides a component data verification device, comprising:
[0085] The parameter table acquisition module is used to acquire the parameter table corresponding to the input 3D lightweight model, and to acquire the material information and surface treatment information in the parameter table;
[0086] The first identification module is used to output a first identification result based on the material information and surface treatment information;
[0087] The second recognition module is used to match the corresponding RGB information in a preset color matching library based on the first recognition result, and output the second recognition result according to the matching result of the RGB information;
[0088] An automatic rendering module is used to automatically render the material and surface treatment properties of the 3D lightweight model based on the second recognition result.
[0089] One embodiment of the present invention also provides a readable storage medium storing a computer program, the computer program including program instructions, which, when executed by a processor of an electronic device, cause the processor to perform the steps of any of the component data verification methods described above.
[0090] One embodiment of the present invention also provides an electronic device, including: a processor and a memory, the memory being used to store computer program code, the computer program code including computer instructions, and when the processor executes the computer instructions, the electronic device performs the steps of any of the component data verification methods described above.
[0091] Please see Figure 3 , Figure 3 This is a schematic diagram of the hardware structure of an electronic device provided in an embodiment of the present invention.
[0092] The electronic device 2 includes a processor 21, a memory 22, an input device 23, and an output device 24. The processor 21, memory 22, input device 23, and output device 24 are coupled together via connectors, which may include various interfaces, transmission lines, or buses, etc., and are not limited in this embodiment of the invention. It should be understood that in various embodiments of the invention, coupling refers to mutual connection through a specific method, including direct connection or indirect connection through other devices, such as through various interfaces, transmission lines, buses, etc.
[0093] Processor 21 can be one or more graphics processing units (GPUs). If processor 21 is a GPU, the GPU can be a single-core GPU or a multi-core GPU. Optionally, processor 21 can be a processor group composed of multiple GPUs, with the multiple processors coupled to each other via one or more buses. Optionally, the processor can also be other types of processors, etc., and this embodiment of the invention is not limited thereto.
[0094] The memory 22 can be used to store computer program instructions, as well as various types of computer program code, including program code for executing the present invention. Optionally, the memory includes, but is not limited to, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM), or compact disc read-only memory (CD-ROM), which is used for related instructions and data.
[0095] Input device 23 is used to input data and / or signals, and output device 24 is used to output data and / or signals. Output device 23 and input device 24 can be independent devices or an integrated device.
[0096] It is understood that in this embodiment of the invention, the memory 22 can be used not only to store related instructions, but also the specific data stored in the memory is not limited.
[0097] Understandable, Figure 3 This is merely a simplified design of an electronic device. In practical applications, the electronic device may also include other necessary components, including, but not limited to, any number of input / output devices, processors, memory, etc., and all video analysis devices that can implement embodiments of the present invention are within the protection scope of the present invention.
[0098] Those skilled in the art will recognize that the units and algorithm steps of the various examples described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are implemented in hardware or software depends on the specific application and design constraints of the technical solution. Those skilled in the art can use different methods to implement the described functions for each specific application, but such implementations should not be considered beyond the scope of this invention.
[0099] Those skilled in the art will readily understand that, for the sake of convenience and brevity, the specific working processes of the systems, devices, and units described above can be referred to the corresponding processes in the foregoing method embodiments, and will not be repeated here. Those skilled in the art will also readily understand that the various embodiments of the present invention have different focuses, and for the sake of convenience and brevity, the same or similar parts may not be repeated in different embodiments. Therefore, parts not described or not described in detail in one embodiment can be referred to in other embodiments.
[0100] In the embodiments provided by this invention, it should be understood that the disclosed systems, apparatuses, and methods can be implemented in other ways. For example, the apparatus embodiments described above are merely illustrative; for instance, the division of units is only a logical functional division, and in actual implementation, there may be other division methods. For example, multiple units or components may be combined or integrated into another system, or some features may be ignored or not executed. Furthermore, the coupling or direct coupling or communication connection shown or discussed may be through some interfaces; the indirect coupling or communication connection between devices or units may be electrical, mechanical, or other forms.
[0101] The units described as separate components may or may not be physically separate. The components shown as units may or may not be physical units; that is, they may be located in one place or distributed across multiple network units. Some or all of the units can be selected to achieve the purpose of this embodiment according to actual needs.
[0102] In addition, the functional units in the various embodiments of the present invention can be integrated into one processing unit, or each unit can exist physically separately, or two or more units can be integrated into one unit.
[0103] In the above embodiments, implementation can be achieved entirely or partially through software, hardware, firmware, or any combination thereof. When implemented using software, it can be implemented entirely or partially as a computer program to be sealed. The computer program to be sealed includes one or more computer instructions. When the computer program instructions are loaded and executed on a computer, all or part of the process or function described in the embodiments of the present invention is generated. The computer can be a general-purpose computer, a special-purpose computer, a computer network, or other programmable device. The computer instructions can be stored in a computer-readable storage medium or transmitted through the computer-readable storage medium. The computer instructions can be transmitted from one website, computer, server, or data center to another website, computer, server, or data center via wired (e.g., coaxial cable, fiber optic, digital subscriber line (DSL)) or wireless (e.g., infrared, wireless, microwave, etc.) means. The computer-readable storage medium can be any available medium that a computer can access or a data storage device such as a server or data center that integrates one or more available media. The available media may be magnetic media (e.g., floppy disks, hard disks, magnetic tapes), optical media (e.g., digital versatile discs (DVDs)), or semiconductor media (e.g., solid-state disks (SSDs)).
[0104] Those skilled in the art will understand that all or part of the processes in the methods of the above embodiments can be implemented by a computer program instructing related hardware. This program can be stored in a computer-readable storage medium, and when executed, it can include the processes described in the above method embodiments. The aforementioned storage medium includes various media capable of storing program code, such as read-only memory (ROM), random access memory (RAM), magnetic disks, or optical disks.
[0105] The above description is merely a preferred embodiment of the present invention and does not limit the patent scope of the present invention. Any equivalent structural transformations made using the contents of the present invention's specification and drawings under the inventive concept of the present invention, or direct / indirect applications in other related technical fields, are included within the patent protection scope of the present invention.
Claims
1. A method for verifying component data, characterized in that, Includes the following steps: Obtain the attribute information table created by the user, wherein the attribute information table is a single-master table or a multi-master table; Obtain the attribute item information and parameter attribute information from the attribute information table. The attribute item information includes product name, product model, configuration model, 3D model name and manufacturer name. The parameter attribute information is the parameter information corresponding to the attribute item information. The attribute information table is validated for uniqueness based on the attribute item information, and the format is validated based on the parameter attribute information. When both the uniqueness check and the format check pass, a pairing relationship is constructed between the attribute item information and the parameter attribute information, and the pairing relationship is generated into a tree structure and stored in a preset storage system. This includes: under the same configuration model, constructing a first pairing relationship between the attribute item information and the parameter attribute information; under the same configuration model, constructing a second pairing relationship between each attribute in the attribute item information; under the same configuration model, constructing a third pairing relationship between each attribute in the parameter attribute information; and storing the first pairing relationship, the second pairing relationship, and the third pairing relationship in a tree structure in the preset storage system. Determine the primary association information between parameters of the parameter attribute information in different configuration models under the same product name; Based on the first association information, determine the number of series, specifications, and 3D models of the same product name.
2. The method for verifying component data as described in claim 1, characterized in that, The uniqueness verification of the attribute information table based on the attribute item information includes: Determine if at least two identical product names exist under the same manufacturer name; If so, the uniqueness check fails, and the location and error type of the at least two identical product names are output to the user; If not, then determine whether there are at least two identical configuration models under the same manufacturer name; If so, the uniqueness check fails, and the location and error type of the at least two identical configuration models are output to the user; If not, then the uniqueness check of the attribute information table passes.
3. The method for verifying component data as described in claim 1, characterized in that, The format validation based on the parameter attribute information includes: Identify the text format and formula in the parameter attribute information, and determine whether the text format and formula are correct; If the text format and formula are correct, the format validation of the parameter attribute information passes.
4. The method for verifying component data as described in claim 3, characterized in that, The method further includes: The numerical value range and step size in the parameter attribute information are verified based on a preset engineering database. If the verification fails, the error type and error location will be returned.
5. A device for verifying component data, characterized in that, include: The table acquisition module is used to acquire attribute information tables created by the user, wherein the attribute information tables are single-master tables or multiple-master tables; The information acquisition module is used to acquire attribute item information and parameter attribute information from the attribute information table. The attribute item information includes product name, product model, configuration model, 3D model name and manufacturer name. The parameter attribute information is the parameter information corresponding to the attribute item information. The verification module is used to perform uniqueness verification on the attribute information table based on the attribute item information, and to perform format verification based on the parameter attribute information; A storage module is configured to, when both the uniqueness check and the format check pass, construct a pairing relationship between attribute item information and parameter attribute information, and generate and store the pairing relationship in a tree structure in a preset storage system. This includes: constructing a first pairing relationship between the attribute item information and the parameter attribute information under the same configuration model; constructing a second pairing relationship between each attribute in the attribute item information under the same configuration model; constructing a third pairing relationship between each attribute in the parameter attribute information under the same configuration model; and storing the first, second, and third pairing relationships in a tree structure in the preset storage system. The verification module is also used to determine the first association information between the parameters of the parameter attribute information in different configuration models under the same product name, and to determine the number of series, number of specifications and number of 3D models of the same product name based on the first association information.
6. An electronic device, comprising: A processor and a memory, characterized in that the memory is used to store computer program code, the computer program code including computer instructions, wherein when the processor executes the computer instructions, the electronic device performs the steps of the component data verification method as described in any one of claims 1-4.
7. A readable storage medium storing a computer program, characterized in that, A computer program includes program instructions that, when executed by a processor of an electronic device, cause the processor to perform the steps of the component data verification method as described in any one of claims 1-4.
Citation Information
Patent Citations
Basic database subsystem of integration system for Internet of Things of drilling machine parts
CN104598594A
Data association and inspection method and device, electronic equipment and storage medium
CN112445875A