Method and system for constructing product based on database

Abstract

The invention provides a method and system for constructing a product based on a database, and the method comprises the steps: S1, constructing a database which is used for storing data of various parts required for constructing the product, an incidence relation between the parts, a standard three-dimensional model and a standard engineering drawing; s2, on the basis of the database, when a target product needs to be constructed, obtaining part of component information input by a user; s3, generating a three-dimensional model and an engineering drawing of the target product based on part of component information input by a user according to the component data stored in the database, the incidence relation among the components, the three-dimensional model of the standard drawing and the engineering drawing of the standard drawing; and S4, obtaining all component information of the target product based on the three-dimensional model of the target product.

Description

Technical Field

[0001] The present invention relates to the technical field of product management, and in particular to a method and system for building products based on a database. Background Art

[0002] In the field of industrial product design and manufacturing, traditional product construction methods rely primarily on engineers manually drawing 3D models and engineering drawings. The design of complex products, especially those containing a large number of standard components such as bridges, busbars, distribution boxes, switchgear, and their mechanical components, not only consumes a lot of time and manpower, but is also prone to errors such as component interference and size mismatches. Furthermore, the accumulated standard component data and drawings are often stored in a decentralized manner, lacking a unified management system. This makes it difficult for designers to quickly retrieve and access required resources, greatly affecting design efficiency.

[0003] While existing parametric design software can achieve a certain degree of automated modeling, it requires users to input complete product parameters and cannot quickly generate a complete design based on partial component information. While product data management systems (PDM) and enterprise resource planning systems (ERP) can manage data and production processes, they lack effective linkage between design and production, making it impossible to achieve an automated transition from product design to production planning. Therefore, a technical solution is urgently needed that can integrate product data resources and automatically generate 3D models, engineering drawings, and production plans based on partial input information to address existing problems such as low design efficiency, chaotic data management, and the disconnect between design and production.

[0004] Patent document CN109118370A (application number: 201810988127.7) discloses a model-based product construction method, device, computer equipment and storage medium. The model-based product construction method includes: obtaining a product construction request, and obtaining a sub-product preset model according to the product construction request; obtaining a model addition request, and obtaining the parameters of the sub-product preset model according to the model addition request; obtaining a product merging request, and obtaining the sub-function of the sub-product preset model according to the product merging request, and merging the sub-function according to the parameters of the sub-product preset model to obtain a construction function; obtaining a product adjustment request, and adjusting the parameters of the construction function according to the product adjustment request so that the yield of the construction function reaches the target yield, thereby obtaining a target construction product. Summary of the Invention

[0005] In view of the defects in the prior art, the purpose of the present invention is to provide a method and system for building products based on a database.

[0006] A method for building a product based on a database provided by the present invention includes:

[0007] Step S1: Building a database, wherein the database is used to store various component data required for building a product, the relationship between the components, standard three-dimensional models, and standard engineering drawings;

[0008] Step S2: When the target product needs to be built, obtain some component information input by the user;

[0009] Step S3: Based on the component data stored in the database, the association relationship between the components, the 3D model of the standard drawing, and the engineering drawing of the standard drawing, and based on the partial component information input by the user, a 3D model and engineering drawing of the target product are generated;

[0010] Step S4: Acquire all component information of the target product based on the three-dimensional model of the target product.

[0011] Preferably, the step S1 includes: obtaining various component data of the product, including the geometric shape, dimensional parameters, material properties and cost data of the components;

[0012] Obtain the relationship between components, including assembly relationship, position relationship, and matching relationship; and construct a component relationship graph using graph database or relational database foreign key constraints;

[0013] The acquired data of various components of the product and the relationship between the components are stored in the database.

[0014] Preferably, the step S3 includes: dynamically adjusting the geometric dimensions of the standard three-dimensional model corresponding to the target product based on the information of some components, thereby generating a three-dimensional model of the target product.

[0015] Preferably, step S3 includes: calling the VBE programmer of EXCEL through the API universal interface provided by the three-dimensional software; repeatedly calling and parameter instantiating the standard database using VB syntax, driving the standard three-dimensional model corresponding to the target product to generate a three-dimensional model of the target product according to actual parameters.

[0016] Preferably, the step S4 includes: writing the generated target product three-dimensional model values ​​into a project file to generate various files required for the project;

[0017] Among them, the various files required for the project include all component information of the target product.

[0018] Preferably, the method further comprises: judging whether each component is a self-made component or a purchased component based on the acquired information of all components of the target product; generating a purchased component plan based on the determined purchased components; and generating a bill of materials based on the determined self-made components;

[0019] Generate a production and delivery plan based on the preset production process timeline, the cycle of each process, the arrival time of purchased parts, and the delivery requirements of the target product.

[0020] Preferably, the method is applicable to any one or more application industries including bridge types, busbar types, distribution box types and switch cabinet types.

[0021] According to the present invention, a system for building products based on a database is provided, comprising:

[0022] Module M1: Build a database for storing various component data required for building a product, relationships between components, standard 3D models, and standard engineering drawings;

[0023] Module M2: When the target product needs to be built, it obtains some component information input by the user;

[0024] Module M3: Generates a 3D model and engineering drawings of the target product based on the component data stored in the database, the relationships between the components, the 3D model of the standard drawing, and the engineering drawings of the standard drawing, and based on the partial component information input by the user;

[0025] Module M4: Acquire all component information of the target product based on the three-dimensional model of the target product.

[0026] Preferably, the module M1 includes: obtaining various component data of the product, including the geometric shape, dimensional parameters, material properties and cost data of the components;

[0027] Obtain the relationship between components, including assembly relationship, position relationship, and matching relationship; and construct a component relationship graph using graph database or relational database foreign key constraints;

[0028] The acquired data of various components of the product and the relationship between the components are stored in the database.

[0029] Preferably, the module M3 includes: dynamically adjusting the geometric dimensions of the standard three-dimensional model corresponding to the target product based on the information of some components, thereby generating a three-dimensional model of the target product;

[0030] The module M3 includes: calling the VBE programmer of EXCEL through the API universal interface provided by the 3D software; using VB syntax to repeatedly call and instantiate parameters of the standard database, driving the standard 3D model corresponding to the target product to generate the 3D model of the target product according to the actual parameters.

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

[0032] 1. By building a database containing various component data, relationships, standard models, and drawings, the present invention allows users to automatically generate 3D models and engineering drawings based on the data in the database by simply inputting partial component information when building a target product. Compared to the traditional method of manually drawing 3D models and engineering drawings, this method significantly reduces repetitive design work, shortens the design cycle, effectively avoids errors such as component interference and dimensional conflicts caused by manual drawing, and significantly improves design accuracy.

[0033] 2. This invention dynamically adjusts the geometric dimensions of a standard three-dimensional model based on partial component information, enabling rapid customized product design without redesigning the entire product model. This meets the market demand for rapid delivery of personalized products and enhances the company's market competitiveness.

[0034] 3. The present invention uses graph database or relational database foreign key constraints to construct component association graphs, and uniformly stores and manages the data and association relationships of various product components;

[0035] 4. The present invention obtains all component information based on the three-dimensional model of the target product, and further determines whether the component is self-made or purchased, and generates a purchased parts plan, a bill of materials, and a production and delivery plan respectively, thereby realizing an automated transition from product design to production planning. Compared with the existing situation where design and production are out of touch, this method avoids problems such as procurement omissions and production scheduling conflicts that occur when manually compiling production plans, thereby improving production collaboration efficiency, shortening product delivery cycles, and reducing production costs. BRIEF DESCRIPTION OF THE DRAWINGS

[0036] Other features, objects and advantages of the present invention will become more apparent upon reading the detailed description of non-limiting embodiments with reference to the following drawings:

[0037] Figure 1 Flowchart of the method for building products based on database.

[0038] Figure 2 This is a schematic diagram of the bridge code.

[0039] Figure 3 This is a schematic diagram of the three-dimensional model of the standard drawing.

[0040] Figure 4 Schematic diagram of an engineering drawing that is a standard drawing.

[0041] Figure 5 This is a schematic diagram of a general process list. DETAILED DESCRIPTION

[0042] The present invention will be described in detail below with reference to specific embodiments. The following examples will help those skilled in the art to further understand the present invention, but are not intended to limit the present invention in any form. It should be noted that, for those skilled in the art, several changes and improvements can be made without departing from the scope of the present invention. These all fall within the scope of protection of the present invention.

[0043] Example 1

[0044] According to a method for building a product based on a database provided by the present invention, Figure 1 Shown, including:

[0045] Step S1: Building a database, wherein the database is used to store various component data required for building a product, the relationship between the components, standard three-dimensional models, and standard engineering drawings;

[0046] Specifically, the step S1 includes: obtaining various component data of the product, including the geometric shape, dimensional parameters, material properties and cost data of the components;

[0047] Obtain the relationship between components, including assembly relationship, position relationship, and matching relationship; and construct a component relationship graph using graph database or relational database foreign key constraints;

[0048] The acquired data of various components of the product and the relationship between the components are stored in the database.

[0049] Step S2: Based on the database, when a target product needs to be built, obtaining partial component information input by the user;

[0050] Step S3: Based on the component data stored in the database, the association relationship between the components, the 3D model of the standard drawing, and the engineering drawing of the standard drawing, and based on the partial component information input by the user, a 3D model and engineering drawing of the target product are generated;

[0051] Specifically, the geometric dimensions of the standard three-dimensional model corresponding to the target product are dynamically adjusted based on the information of some components, thereby generating a three-dimensional model of the target product.

[0052] More specifically, the 3D software uses the API provided by the software to call the Excel Visual Basic (VBE) programmer. Using VB syntax, the standard database is repeatedly called and parameterized, driving the original standard 3D model to generate the target model based on actual parameters. The target model values ​​are then written to the project file, generating the various files required for the project.

[0053] Step S4: Acquire all component information of the target product based on the three-dimensional model of the target product.

[0054] This embodiment can automatically generate three-dimensional models, engineering drawings, and standard drawings by selecting and filling in basic information such as type, specification, and quantity in an EXCEL table.

[0055] The method further includes: step S5: based on the acquired information of all components of the target product, determining whether each component is a self-made component or a purchased component; generating a purchased component plan based on the determined purchased components; and generating a blanking list based on the determined self-made components;

[0056] Step S6: Generate a production and delivery plan based on the preset production process timeline, the cycle of each process, the arrival time of purchased parts, and the delivery requirements of the target product.

[0057] This embodiment obtains all component information based on the three-dimensional model of the target product, and further determines whether the component is self-made or purchased, and generates a purchased parts plan, a bill of materials, and a production and delivery plan respectively, thereby realizing an automated transition from product design to production planning. Compared with the existing situation where design and production are out of touch, this avoids problems such as procurement omissions and production scheduling conflicts that occur when manually compiling production plans, improves production collaboration efficiency, shortens product delivery cycle, and reduces production costs.

[0058] The present invention also provides a system for building products based on a database. The system for building products based on a database can be implemented by executing the process steps of the method for building products based on a database. That is, those skilled in the art can understand the method for building products based on a database as a preferred implementation of the system for building products based on a database.

[0059] The method and system for building products based on a database are applicable to industries including, but not limited to, bridges, busbars, distribution boxes, and switch cabinets.

[0060] Example 2

[0061] Example 2 is a preferred example of Example 1

[0062] According to the present invention, a method for building a product based on a database includes: a one-key design method for a bridge;

[0063] Step 1: Establish bridge code and standardize drawings, such as Figure 2 As shown;

[0064] Step 2: Create a 3D model of the standard drawing, such as Figure 3 As shown;

[0065] Step 3: Create engineering drawings of standard drawings, such as Figure 4 As shown;

[0066] Step 4: Build a database based on the bridge code, the relationship between components, the 3D model of the standard drawing, and the engineering drawings of the standard drawing;

[0067] Step 5: Get a general process list, such as Figure 5 As shown;

[0068] Step 6: Fill in basic information such as type, specification, quantity, etc. based on the Excel spreadsheet, and automatically generate a 3D model based on the database.

[0069] Those skilled in the art will appreciate that, in addition to implementing the system, device, and various modules provided by the present invention in purely computer-readable program code, it is entirely possible to implement the same program in the form of logic gates, switches, application-specific integrated circuits, programmable logic controllers, embedded microcontrollers, and the like by logically programming the method steps. Therefore, the system, device, and various modules provided by the present invention can be considered a hardware component, and the modules included therein for implementing various programs can also be considered structures within the hardware component; the modules for implementing various functions can also be considered both software programs for implementing the method and structures within the hardware component.

[0070] The above describes specific embodiments of the present invention. It should be understood that the present invention is not limited to the specific embodiments described above, and those skilled in the art may make various changes or modifications within the scope of the claims, which do not affect the essence of the present invention. The embodiments of this application and the features in the embodiments may be combined with each other in any manner unless there is a conflict.

Claims

1. A method for building a product based on a database, characterized in that: include: Step S1: Building a database, wherein the database is used to store various component data required for building a product, the relationship between the components, standard three-dimensional models, and standard engineering drawings; Step S2: When the target product needs to be built, obtain some component information input by the user; Step S3: Based on the component data stored in the database, the association relationship between the components, the 3D model of the standard drawing, and the engineering drawing of the standard drawing, and based on the partial component information input by the user, a 3D model and engineering drawing of the target product are generated; Step S4: Acquire all component information of the target product based on the three-dimensional model of the target product.

2. The method for building a product based on a database according to claim 1, characterized in that: The step S1 includes: obtaining various component data of the product, including the geometric shape, dimensional parameters, material properties and cost data of the components; Obtain the relationship between components, including assembly relationship, position relationship, and matching relationship; and construct a component relationship graph using graph database or relational database foreign key constraints; The acquired data of various components of the product and the relationship between the components are stored in the database.

3. The method for building a product based on a database according to claim 1, characterized in that: The step S3 includes: dynamically adjusting the geometric dimensions of the standard three-dimensional model corresponding to the target product based on the information of some components, thereby generating a three-dimensional model of the target product.

4. The method for building a product based on a database according to claim 1, characterized in that: The step S3 includes: calling the VBE programmer of EXCEL through the API universal interface provided by the 3D software; repeatedly calling and instantiating the parameters of the standard database using VB syntax, driving the standard 3D model corresponding to the target product to generate the 3D model of the target product according to the actual parameters.

5. The method for building a product based on a database according to claim 1, characterized in that: The step S4 includes: writing the generated target product three-dimensional model value into the project file to generate various files required for the project; Among them, the various files required for the project include all component information of the target product.

6. The method for building a product based on a database according to claim 1, characterized in that: The method further includes: determining whether each component is a self-made component or a purchased component based on the acquired information of all components of the target product; generating a purchased component plan based on the determined purchased components; and generating a blanking list based on the determined self-made components. Generate a production and delivery plan based on the preset production process timeline, the cycle of each process, the arrival time of purchased parts, and the delivery requirements of the target product.

7. The method for building a product based on a database according to claim 1, characterized in that: The method is applicable to any one or more application industries including bridge types, busbar types, distribution box types and switch cabinet types.

8. A system for building products based on a database, characterized in that: include: Module M1: Build a database for storing various component data required for building a product, relationships between components, standard 3D models, and standard engineering drawings; Module M2: When the target product needs to be built, it obtains some component information input by the user; Module M3: Generates a 3D model and engineering drawings of the target product based on the component data stored in the database, the relationships between the components, the 3D model of the standard drawing, and the engineering drawings of the standard drawing, and based on the partial component information input by the user; Module M4: Acquire all component information of the target product based on the 3D model of the target product.

9. The system for building products based on a database according to claim 8, characterized in that: The module M1 includes: obtaining various component data of the product, including the component's geometric shape, dimensional parameters, material properties and cost data; Obtain the relationship between components, including assembly relationship, position relationship, and matching relationship; and construct a component relationship graph using graph database or relational database foreign key constraints; The acquired data of various components of the product and the relationship between the components are stored in the database.

10. The system for building products based on a database according to claim 8, characterized in that: The module M3 includes: dynamically adjusting the geometric dimensions of the standard three-dimensional model corresponding to the target product based on the information of some components, thereby generating a three-dimensional model of the target product; The module M3 includes: calling the VBE programmer of EXCEL through the API universal interface provided by the 3D software; using VB syntax to repeatedly call and instantiate parameters of the standard database, driving the standard 3D model corresponding to the target product to generate the 3D model of the target product according to the actual parameters.

Images