Multi-table-based part data generation method and device, equipment and storage medium

Abstract

The embodiment of the invention provides a multi-table-based part data generation method and device, equipment and a storage medium, and belongs to the technical field of 3D models. The method comprises the following steps: acquiring a main attribute table of a part, wherein the main attribute table comprises attribute information and product technical parameters of the part; if the product technical parameters of the parts have the pairing constraint relation, a pairing attribute table of the parts is obtained, and the pairing attribute table comprises the pairing constraint relation of the product technical parameters of the parts; and generating a model parameter table of the part based on the main attribute table and the pairing attribute table. According to the multi-table-based part data generation method provided by the embodiment of the invention, the pairing constraint relationship before the product technical parameters of the parts is accurately set, so that the original very tedious data construction work is greatly simplified, and a solid foundation is laid for establishing an efficient and accurate engineering database.

Description

Technical Field

[0001] The present application relates to the field of 3D model technology, and in particular to a method and device, equipment and storage medium for generating component data based on multiple tables. Background Art

[0002] With the continuous development of science and technology, manufacturing is also gradually developing. Under market demand, manufacturing enterprises are gradually moving towards standardization and localization. Many industrial basic resource libraries have emerged. The construction workload of industrial basic resource libraries is very large, involving a large number of types of mechanical parts. There are many types of mechanical parts, and each type has its own unique structure, function and use. In addition, each component contains multiple key technical parameters. The key technical parameters do not exist in isolation, but are interrelated and influence each other. This attribute relationship increases the difficulty of data processing. Faced with such a large amount of data and complex parameter relationships, how to efficiently build and manage engineering databases to ensure the accuracy and consistency of data is an important challenge facing manufacturing companies. Summary of the invention

[0003] The main purpose of the embodiments of the present application is to propose a method and device, equipment and storage medium for generating component data based on multiple tables, aiming to greatly simplify the originally cumbersome data construction work by systematically organizing and standardizing the large number of complex technical parameters involved in mechanical components.

[0004] To achieve the above-mentioned purpose, a first aspect of an embodiment of the present application proposes a method for generating component data based on multiple tables, the method comprising:

[0005] Obtaining a main attribute table of a component, wherein the main attribute table includes attribute information and product technical parameters of the component;

[0006] If there is a pairing constraint relationship between the product technical parameters of the component, obtaining a pairing attribute table of the component, wherein the pairing attribute table includes the pairing constraint relationship between the product technical parameters of the component;

[0007] Based on the main attribute table and the pairing attribute table, a model parameter table of the component is generated.

[0008] In some embodiments, the step of obtaining the main attribute table of the component specifically includes:

[0009] Collect product names, product models, manufacturers and 3D models of parts;

[0010] Collecting several product technical parameters of the components;

[0011] A main attribute table is generated based on the product name, product model, manufacturer, 3D model and several product technical parameters of the component.

[0012] In some embodiments, the step of generating the model parameter table of the component based on the main attribute table and the pairing attribute table specifically includes:

[0013] Based on the product technical parameters of the main attribute table and the plurality of pairing constraint relationships of the pairing attribute table, a plurality of matching model parameters of the component are generated;

[0014] The attribute information of the main attribute table is set as the table header, and the model parameters are filled into the table to generate the model parameter table of the component.

[0015] In some embodiments, the step of generating a plurality of matching model parameters of the component based on the product technical parameters of the main attribute table and a plurality of pairing constraint relationships of the pairing attribute table specifically includes:

[0016] Based on the product technical parameters of the main attribute table and the plurality of pairing constraint relationships of the pairing attribute table, generating a plurality of compatible model parameters of the component;

[0017] The compatible model parameters are deduplicated to obtain a plurality of matching model parameters.

[0018] In some embodiments, the method further comprises:

[0019] Obtaining a 3D model generation instruction, and displaying optional model parameters based on the model parameter table;

[0020] The selected model parameters are collected, and based on the selected model parameters and the basic models of the components, 3D models corresponding to the selected model parameters are generated in batches.

[0021] In some embodiments, the step of obtaining the main attribute table of the component specifically includes:

[0022] Collecting attribute information and product technical parameters of the components;

[0023] It is determined that the attribute information of the component is not empty and the product technical parameters are within a set range, and a main attribute table is generated based on the attribute information and the product technical parameters.

[0024] In some embodiments, the method further comprises:

[0025] A first technical parameter is obtained, and an optional component model is output according to the first technical parameter and the model parameter table.

[0026] To achieve the above-mentioned purpose, a second aspect of an embodiment of the present application proposes a component data generation device based on multiple tables, the device comprising:

[0027] The attribute acquisition module is used to acquire the main attribute table of the component, wherein the main attribute table includes the attribute information and product technical parameters of the component;

[0028] A constraint acquisition module, configured to acquire a pairing attribute table of the component if there is a pairing constraint relationship between the product technical parameters of the component, wherein the pairing attribute table includes the pairing constraint relationship between the product technical parameters of the component;

[0029] A data generation module is used to generate a model parameter table of the component based on the main attribute table and the pairing attribute table.

[0030] To achieve the above-mentioned purpose, the third aspect of an embodiment of the present application proposes an electronic device, which includes a memory and a processor, the memory stores a computer program, and the processor implements the above-mentioned multi-table-based component data generation method when executing the computer program.

[0031] To achieve the above-mentioned purpose, the fourth aspect of an embodiment of the present application proposes a computer-readable storage medium, which stores a computer program. When the computer program is executed by a processor, it implements the above-mentioned multi-table-based component data generation method.

[0032] The present application proposes a multi-table-based component data generation method, device, equipment and storage medium, which obtains the component attribute information and product technical parameters and generates a component model parameter table based on the existing pairing constraint relationship between the product technical parameters. Through this method, manufacturing companies can manage component data more efficiently, reduce duplication of work, and improve production efficiency and product quality. BRIEF DESCRIPTION OF THE DRAWINGS

[0033] Figure 1 is a flowchart of a method for generating component data based on multiple tables provided in an embodiment of the present application;

[0034] Figure 2 yes Figure 1 Flow chart of step S101 in FIG.

[0035] Figure 3 It is a structural schematic diagram of a component data generation device based on multiple tables provided in an embodiment of the present application;

[0036] Figure 4 It is a schematic diagram of the hardware structure of the electronic device provided in the embodiment of the present application. DETAILED DESCRIPTION

[0037] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with 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.

[0038] It should be noted that, although the functional modules are divided in the device schematic diagram and the logical order is shown in the flowchart, in some cases, the steps shown or described may be performed in a different order than the module division in the device or the order in the flowchart. The terms "first", "second", etc. in the specification, claims and the above drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence.

[0039] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as those commonly understood by those skilled in the art to which this application belongs. The terms used herein are only for the purpose of describing the embodiments of this application and are not intended to limit this application.

[0040] First, some nouns involved in this application are analyzed:

[0041] 3D model: A 3D model is a model with 3D data that is constructed in a virtual 3D space using 3D software. It is usually used in 3D printing, computer graphics, movies, television, video games, and virtual reality. These models define the shape, size, position, and surface characteristics of objects in a 3D coordinate system through a series of geometric elements such as points, lines, and surfaces. 3D models can represent objects or scenes in the real world in great detail, including their shape, texture, color, light and shadow effects, etc. They can be created using various 3D modeling software, such as Blender, 3ds Max, Maya, Cinema4D, SketchUp, etc. The process of creating a 3D model usually involves steps such as design, modeling, texture mapping, lighting, and rendering.

[0042] Cloud Server: A cloud server is a virtual server based on cloud computing technology that users can access and use through the Internet. Through virtualization technology, cloud servers divide the resources of physical servers (such as CPU, memory, storage, etc.) and allocate them to users on demand. This technology enables users to use computing resources flexibly and efficiently without having to worry about the maintenance and management of physical servers.

[0043] In the context of rapid development of today's society, the manufacturing field is undergoing profound changes. With the increasing diversification and personalization of market demand, manufacturing enterprises are gradually moving towards standardization and localization in order to enhance their competitiveness. In this process, the construction of the industrial basic resource library is particularly important. It is not only an important carrier for the accumulation and inheritance of enterprise knowledge, but also a key infrastructure for promoting product innovation and technological progress. However, the construction of the industrial basic resource library is not easy, and its workload is beyond imagination. Many parts play a vital role in the same product. Their key technical parameters are not only numerous, but also have complex attribute relationships with each other. These relationships may involve multiple disciplines such as mechanics, thermodynamics, and electromagnetism, and various factors need to be considered comprehensively to be accurately described. Therefore, in the process of data construction, a scientific classification system and standardized data models must be established to clearly express these relationships and facilitate subsequent data analysis and application. There may be thousands of models for a product. Although their 3D models are similar in appearance, they often only differ in size parameters. However, since many manufacturers have not yet adopted parametric modeling technology, each time the size is modified, the model needs to be recreated or adjusted, which greatly increases the workload of engineering database construction.

[0044] Based on this, the embodiments of the present application provide a method and apparatus, device and storage medium for generating component data based on multiple tables, aiming to realize automatic generation of component model data by means of multiple tables. The method and apparatus, device and storage medium for generating component data based on multiple tables provided in the embodiments of the present application are specifically described through the following embodiments. First, the method for generating component data based on multiple tables in the embodiments of the present application is described.

[0045] The multi-table based component data generation method provided in the embodiment of the present application relates to the field of 3D model technology. The multi-table based component data generation method provided in the embodiment of the present application can be applied to a terminal, can also be applied to a server side, and can also be software running in a terminal or a server side. In some embodiments, the terminal can be a smart phone, a tablet computer, a laptop computer, a desktop computer, etc.; the server side can be configured as an independent physical server, or a server cluster or a distributed system composed of multiple physical servers, or a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, CDN, and big data and artificial intelligence platforms; the software can realize the application of the multi-table based component data generation method, etc., but is not limited to the above forms.

[0046] The present application can be used in many general or special computer system environments or configurations. For example: personal computers, server computers, handheld or portable devices, tablet devices, multiprocessor systems, microprocessor-based systems, set-top boxes, programmable consumer electronics, network PCs, minicomputers, mainframe computers, distributed computing environments including any of the above systems or devices, etc. The present application can be described in the general context of computer-executable instructions executed by a computer, such as program modules. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform specific tasks or implement specific abstract data types. The present application can also be practiced in distributed computing environments, in which tasks are performed by remote processing devices connected through a communication network. In a distributed computing environment, program modules can be located in local and remote computer storage media including storage devices.

[0047] It should be noted that in each specific implementation of the present application, when it is necessary to perform relevant processing based on data related to user identity or characteristics such as user information, user behavior data, user historical data, and user location information, the user's permission or consent will be obtained first, and the collection, use, and processing of these data will comply with relevant laws, regulations, and standards. In addition, when the embodiment of the present application needs to obtain the user's sensitive personal information, the user's separate permission or consent will be obtained through a pop-up window or by jumping to a confirmation page. After clearly obtaining the user's separate permission or consent, the necessary user-related data for the normal operation of the embodiment of the present application will be obtained.

[0048] Figure 1 is an optional flowchart of a method for generating component data based on multiple tables provided in an embodiment of the present application. Figure 1 The method may include but is not limited to steps S101 to S103.

[0049] Step S101, obtaining a main attribute table of a component, wherein the main attribute table includes attribute information and product technical parameters of the component;

[0050] Step S102, if there is a pairing constraint relationship between the product technical parameters of the component, then obtain a pairing attribute table of the component, the pairing attribute table including the pairing constraint relationship between the product technical parameters of the component;

[0051] Step S103: generating a model parameter table of the component based on the main attribute table and the pairing attribute table.

[0052] Steps S101 to S103 shown in the embodiment of the present application store basic information of components through the main attribute table of components, store pairing constraints of product technical parameters of components through the pairing attribute table of components, and finally generate a model parameter table including multiple component model parameters based on the basic information of components and the pairing constraints of product technical parameters.

[0053] Specifically, you first need to obtain the main attribute table of the parts. The main attribute table is the basis of the parts data and contains the basic attribute information of the parts and product technical parameters. If there is a pairing constraint relationship between the product technical parameters of the parts, you need to further obtain the pairing attribute table. The pairing attribute table describes in detail the pairing constraint relationship between the technical parameters and is the key to ensuring that the performance and function of the parts meet the requirements. Then, using the data in the main attribute table and the pairing attribute table, through certain algorithms and logical processing, generate the model parameter table of the parts. The model parameter table not only contains the basic attribute information and product technical parameters of the parts, but also reflects the pairing constraint relationship between these technical parameters. It is the final result of the part data generation.

[0054] More specifically, when the product technical parameters of parts and components do not require other attribute association confirmation, the master table is used. The master attribute table is divided into two parts: key attribute information of required items and manufacturer-defined attribute information. The required items include common attributes such as product name, product model, manufacturer information, 3D model, etc., while the manufacturer-defined attributes include the key technical parameters under the product model. When there is a complex pairing relationship between the product technical parameters of parts and components, the multi-master table method is used, that is, the master attribute table is combined with other pairing attribute tables. The structure of the master attribute table is the same as that of the single master table, and the pairing attribute table is used to establish the constraint relationship between the key technical parameters in the master attribute table.

[0055] In step S101 of some embodiments, referring to Figure 2 , specifically including:

[0056] S1011. Collect product names, product models, manufacturers and 3D models of parts;

[0057] S1012, collecting several product technical parameters of the components;

[0058] S1013. Generate a main attribute table based on the product name, product model, manufacturer, 3D model and several product technical parameters of the component.

[0059] Specifically, in the process of constructing the main attribute table of parts, it is necessary to collect the basic information of the parts, including product name, product model, manufacturer and 3D model. Among them, the product name is the common or proprietary name of the part, which is used to uniquely identify the part in the data system; the product model is the unique identification code or number assigned by the manufacturer to a specific part, which usually contains information about the specifications, performance or use of the part; the manufacturer is the name of the company or manufacturer that produces or supplies the part; the 3D model is a three-dimensional digital representation of the part, which is used for visualization, analysis and simulation, and can be a CAD file, STL file or other three-dimensional data format. At the same time, it is also necessary to collect multiple product technical parameters of the parts, and generate a main attribute table by integrating the basic information and technical parameters of the parts collected previously into a main attribute table.

[0060] In some embodiments, step S103 specifically includes:

[0061] Based on the product technical parameters of the main attribute table and the plurality of pairing constraint relationships of the pairing attribute table, a plurality of matching model parameters of the component are generated;

[0062] The attribute information of the main attribute table is set as the table header, and the model parameters are filled into the table to generate the model parameter table of the component.

[0063] Specifically, in the process of generating the model parameter table, the pairing constraint relationship defines the interdependence and restrictions between the technical parameters in the main attribute table. For example, a certain size parameter may be constrained by another size parameter or material parameter, or some performance parameters must vary within a specific range to maintain the overall performance of the component. According to these constraints, the system will generate matching model parameters by calculating or selecting qualified values. These parameters may include different sizes, powers, speeds, capacities, etc. to meet the needs of different customers or application scenarios. After the matching model parameters are generated, the next step is to organize this information into a structured table, namely the model parameter table, which will be used as one of the final results of the component data construction for subsequent design, production, procurement and other links. The header of the model parameter table will contain the key attribute information in the main attribute table, such as product name, product model, manufacturer, 3D model, etc. Below the header, the system will fill in the corresponding data according to the generated matching model parameters. Each model or specification will correspond to a row of data, which contains all the key parameters and attribute values ​​of the model or specification. Through these two steps, the system can generate the model parameter table of parts based on the main attribute table and the pairing attribute table, providing accurate and reliable data support for all links of the manufacturing industry.

[0064] In some embodiments, the step of generating a plurality of matching model parameters of the component based on the product technical parameters of the main attribute table and a plurality of pairing constraint relationships of the pairing attribute table specifically includes:

[0065] Based on the product technical parameters of the main attribute table and the plurality of pairing constraint relationships of the pairing attribute table, generating a plurality of compatible model parameters of the component;

[0066] The compatible model parameters are deduplicated to obtain a plurality of matching model parameters.

[0067] Specifically, in the process of generating matching model parameters, all potential model parameters that meet the requirements of these parameters will be screened out first according to the technical parameters in the main attribute table. Then, the system will further verify these potential model parameters according to the pairing constraint relationship in the pairing attribute table. Only model parameters that meet both the technical parameters and the pairing constraint relationship will be considered as compatible model parameters. After the compatible model parameters are generated, it may be found that there are repeated or similar model parameters. In order to avoid data redundancy and confusion, the system needs to perform deduplication processing on these compatible model parameters. The logic of deduplication processing can be defined according to specific application scenarios and requirements. Generally speaking, the system will compare the various fields of different model parameters. If the values ​​of two or more model parameters on all key fields are the same or very close, they will be regarded as duplicates and one of them will be retained as a representative. After deduplication processing, the system will obtain a set of non-repetitive and accurate matching model parameters, which will be used as an important part of the component data for subsequent design, production, procurement and other links.

[0068] In some embodiments, the method further comprises:

[0069] Obtaining a 3D model generation instruction, and displaying optional model parameters based on the model parameter table;

[0070] The selected model parameters are collected, and based on the selected model parameters and the basic models of the components, 3D models corresponding to the selected model parameters are generated in batches.

[0071] Specifically, when receiving a 3D model generation instruction, the system will dynamically display a set of optional model parameters based on the previously generated model parameter table. These optional model parameters represent different models or specifications of parts, and users can choose from them according to their needs. After the optional model parameters are displayed, the user can select one or more model parameters from them. The system will collect these selected model parameters and batch generate corresponding 3D models based on them and the basic model of the parts. The basic model is a basic 3D representation of the parts. It contains the main structure and shape of the parts, but may not contain specific dimensions, details or configurations. This model is the basis for the subsequent generation of specific model models. At the same time, the system will use parametric modeling technology to adjust and optimize the basic model accordingly according to the specific values ​​in the selected model parameters, so that each generated 3D model will accurately reflect the characteristics and requirements of the corresponding model parameters. Since the user may select multiple model parameters for generation, the system needs to support batch processing, which means that the system can automatically perform the above modeling process for each selected model parameter and output the corresponding 3D model file.

[0072] In some embodiments, the step of obtaining the main attribute table of the component specifically includes:

[0073] Collecting attribute information and product technical parameters of the components;

[0074] It is determined that the attribute information of the component is not empty and the product technical parameters are within a set range, and a main attribute table is generated based on the attribute information and the product technical parameters.

[0075] Specifically, in the process of obtaining the main attribute table of parts, the system collects the attribute information and product technical parameters of the parts. The attribute information usually includes the basic information of the parts, such as product name, product model, manufacturer, etc. This information is used to identify and describe the parts, while the product technical parameters describe the key characteristics of the parts, such as performance, size, material, weight, etc. in more detail. After collecting the data, the system needs to perform a series of data verification and inspection to ensure the integrity and validity of the data. Specifically, the system needs to confirm that the attribute information of the parts, such as product name, product model, etc., is not empty; at the same time, the system also needs to check whether the product technical parameters are within the set valid range. The range of technical parameters is determined according to industry standards, design requirements or experience values ​​to ensure that the performance and specifications of the parts meet specific requirements. After confirming that the data is valid, the system will generate the main attribute table based on the attribute information and product technical parameters. The main attribute table is a structured data table that contains all the key attribute information and technical parameters of the parts. Through this step, the system can ensure that the data in the main attribute table obtained is complete, accurate and valid, thereby improving the reliability and efficiency of the entire data processing process.

[0076] In some embodiments, the method further comprises:

[0077] A first technical parameter is obtained, and an optional component model is output according to the first technical parameter and the model parameter table.

[0078] Specifically, after obtaining the model parameter table of the part, the system can output the model and parameters of the corresponding part that meet the user's requirements according to the user's definition of the product technical parameters. The system needs to obtain the first technical parameters provided by the user or other systems. These technical parameters can be any indicators related to the performance of the parts, such as size, weight, power, speed, material properties, etc. The user may provide these technical parameters as screening conditions according to their own needs or application scenarios. After obtaining the first technical parameter, the system will match it with the model parameter table. The model parameter table is a data table containing multiple component models and their corresponding technical parameters. The system will search for all component models that meet the technical parameter requirements in the model parameter table according to the value of the first technical parameter. After the matching is completed, the system will output all component models that meet the first technical parameter requirements as optional models. These optional models can be arranged in a certain order so that users can select and further operate. In actual use, it is not limited to only one technical parameter. Users can select multiple technical parameters according to their own needs to filter out component models that meet their own needs. Through this step, users can quickly filter out models that meet their needs from a large number of component models, improving the efficiency and accuracy of selection. At the same time, this also provides strong support for subsequent procurement, design or production links.

[0079] See also Figure 3 The embodiment of the present application also provides a component data generation device based on multiple tables, the device comprising:

[0080] The attribute acquisition module 101 is used to acquire a main attribute table of a component, wherein the main attribute table includes attribute information and product technical parameters of the component;

[0081] The constraint acquisition module 102 is used to acquire a pairing attribute table of the component if there is a pairing constraint relationship between the product technical parameters of the component, wherein the pairing attribute table includes the pairing constraint relationship between the product technical parameters of the component;

[0082] The data generation module 103 is used to generate a model parameter table of the component based on the main attribute table and the pairing attribute table.

[0083] The specific implementation of the multi-table-based component data generation device is basically the same as the specific implementation of the multi-table-based component data generation method described above, and will not be repeated here.

[0084] See also Figure 4 , Figure 4 The hardware structure of an electronic device of another embodiment is illustrated, and the electronic device includes:

[0085] The processor 401 may be implemented by a general-purpose CPU (Central Processing Unit), a microprocessor, an application-specific integrated circuit (Application Specific Integrated Circuit, ASIC), or one or more integrated circuits, and is used to execute relevant programs to implement the technical solutions provided in the embodiments of the present application;

[0086] The memory 402 can be implemented in the form of a read-only memory (ROM), a static storage device, a dynamic storage device, or a random access memory (RAM). The memory 402 can store an operating system and other application programs. When the technical solution provided in the embodiment of this specification is implemented by software or firmware, the relevant program code is stored in the memory 402, and the processor 401 calls and executes the component data generation method based on multiple tables in the embodiment of this application;

[0087] Input / output interface 403, used to implement information input and output;

[0088] Communication interface 404, used to realize communication interaction between the device and other devices, which can be realized by wired mode (such as USB, network cable, etc.) or wireless mode (such as mobile network, WIFI, Bluetooth, etc.);

[0089] Bus 405 , which transmits information between various components of the device (e.g., processor 401 , memory 402 , input / output interface 403 , and communication interface 404 );

[0090] The processor 401 , the memory 402 , the input / output interface 403 and the communication interface 404 are connected to each other in communication within the device via the bus 405 .

[0091] An embodiment of the present application also provides a computer-readable storage medium, which stores a computer program. When the computer program is executed by a processor, the above-mentioned multi-table-based component data generation method is implemented.

[0092] The memory, as a non-transient computer-readable storage medium, can be used to store non-transient software programs and non-transient computer executable programs. In addition, the memory may include a high-speed random access memory, and may also include a non-transient memory, such as at least one disk storage device, a flash memory device, or other non-transient solid-state storage device. In some embodiments, the memory may optionally include a memory remotely disposed relative to the processor, and these remote memories may be connected to the processor via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0093] The embodiments of the present application provide a multi-table based component data generation method, a multi-table based component data generation device, an electronic device and a storage medium, which store basic information of components through a main attribute table of components, store pairing constraint relationships of product technical parameters of components through a pairing attribute table of components, and finally generate a model parameter table including multiple component model parameters based on the basic information of components and the pairing constraint relationships of product technical parameters, thereby managing component data more efficiently, reducing duplication of work, and improving production efficiency and product quality.

[0094] The description of the embodiments of the present application is intended to more clearly illustrate the technical solutions of the embodiments of the present application and does not constitute a limitation on the technical solutions provided by the embodiments of the present application. Those skilled in the art will appreciate that with the evolution of technology and the emergence of new application scenarios, the technical solutions provided by the embodiments of the present application are also applicable to similar technical problems.

[0095] Those skilled in the art will appreciate that the technical solutions shown in the figures do not constitute a limitation on the embodiments of the present application, and may include more or fewer steps than shown in the figures, or a combination of certain steps, or different steps.

[0096] Those skilled in the art will appreciate that all or some of the steps in the methods disclosed above, and the functional modules / units in the systems and devices may be implemented as software, firmware, hardware, or a suitable combination thereof.

[0097] The terms "first", "second", "third", "fourth", etc. (if any) in the specification of the present application and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchangeable where appropriate, so that the embodiments of the present application described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any of their variations are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device comprising a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0098] It should be understood that in the present application, "at least one (item)" means one or more, and "plurality" means two or more. "And / or" is used to describe the association relationship of associated objects, indicating that three relationships may exist. For example, "A and / or B" can mean: only A exists, only B exists, and A and B exist at the same time, where A and B can be singular or plural. The character " / " generally indicates that the objects associated before and after are in an "or" relationship. "At least one of the following" or similar expressions refers to any combination of these items, including any combination of single or plural items. For example, at least one of a, b or c can mean: a, b, c, "a and b", "a and c", "b and c", or "a and b and c", where a, b, c can be single or multiple.

[0099] In the several embodiments provided in the present application, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic. For example, the division of the above units is only a logical function division. There may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.

[0100] In addition, each functional unit in each embodiment of the present application may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.

[0101] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application, or the part that contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including multiple instructions to enable a computer device (which can be a personal computer, server, or network device, etc.) to execute all or part of the steps of the methods of various embodiments of the present application. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (Read-Only Memory, referred to as ROM), random access memory (Random Access Memory, referred to as RAM), disk or optical disk and other media that can store programs.

[0102] The preferred embodiments of the present application are described above with reference to the accompanying drawings, but the scope of the rights of the present application is not limited thereto. Any modification, equivalent substitution and improvement made by those skilled in the art without departing from the scope and essence of the present application should be within the scope of the rights of the present application.

Claims

1. A method for generating component data based on multiple tables, characterized in that: The method comprises: Obtaining a main attribute table of a component, wherein the main attribute table includes attribute information and product technical parameters of the component; If there is a pairing constraint relationship between the product technical parameters of the component, obtaining a pairing attribute table of the component, wherein the pairing attribute table includes the pairing constraint relationship between the product technical parameters of the component; Based on the main attribute table and the pairing attribute table, a model parameter table of the component is generated.

2. The method for generating component data based on multiple tables according to claim 1, characterized in that: The step of obtaining the main attribute table of the component specifically includes: Collect product names, product models, manufacturers and 3D models of parts; Collecting several product technical parameters of the components; A main attribute table is generated based on the product name, product model, manufacturer, 3D model and several product technical parameters of the component.

3. The method for generating component data based on multiple tables according to claim 1, characterized in that: The step of generating the model parameter table of the component based on the main attribute table and the pairing attribute table specifically includes: Based on the product technical parameters of the main attribute table and the plurality of pairing constraint relationships of the pairing attribute table, a plurality of matching model parameters of the component are generated; The attribute information of the main attribute table is set as the table header, and the model parameters are filled into the table to generate the model parameter table of the component.

4. The method for generating component data based on multiple tables according to claim 3, characterized in that: The step of generating a plurality of matching model parameters of the component based on the product technical parameters of the main attribute table and a plurality of pairing constraint relationships in the pairing attribute table specifically includes: Based on the product technical parameters of the main attribute table and the plurality of pairing constraint relationships of the pairing attribute table, generating a plurality of compatible model parameters of the component; The compatible model parameters are deduplicated to obtain a plurality of matching model parameters.

5. The method for generating component data based on multiple tables according to claim 1, characterized in that: The method further comprises: Obtaining a 3D model generation instruction, and displaying optional model parameters based on the model parameter table; The selected model parameters are collected, and based on the selected model parameters and the basic models of the components, 3D models corresponding to the selected model parameters are generated in batches.

6. The method for generating component data based on multiple tables according to claim 1, characterized in that: The step of obtaining the main attribute table of the component specifically includes: Collecting attribute information and product technical parameters of the components; It is determined that the attribute information of the component is not empty and the product technical parameters are within a set range, and a main attribute table is generated based on the attribute information and the product technical parameters.

7. The method for generating component data based on multiple tables according to claim 1, characterized in that: The method further comprises: A first technical parameter is obtained, and an optional component model is output according to the first technical parameter and the model parameter table.

8. A component data generation device based on multiple tables, characterized in that: The device comprises: The attribute acquisition module is used to acquire the main attribute table of the component, wherein the main attribute table includes the attribute information and product technical parameters of the component; A constraint acquisition module, configured to acquire a pairing attribute table of the component if there is a pairing constraint relationship between the product technical parameters of the component, wherein the pairing attribute table includes the pairing constraint relationship between the product technical parameters of the component; A data generation module is used to generate a model parameter table of the component based on the main attribute table and the pairing attribute table.

9. An electronic device, characterized in that: The electronic device includes a memory and a processor, the memory stores a computer program, and the processor implements the multi-table based component data generation method described in any one of claims 1 to 7 when executing the computer program.

10. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the method for generating component data based on multiple tables according to any one of claims 1 to 7 is implemented.

Images