CN111368148A - Super BOM generation method and device - Google Patents
Super BOM generation method and device Download PDFInfo
- Publication number
- CN111368148A CN111368148A CN202010136898.0A CN202010136898A CN111368148A CN 111368148 A CN111368148 A CN 111368148A CN 202010136898 A CN202010136898 A CN 202010136898A CN 111368148 A CN111368148 A CN 111368148A
- Authority
- CN
- China
- Prior art keywords
- bom
- sub
- product
- super
- target product
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/901—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/901—Indexing; Data structures therefor; Storage structures
- G06F16/9024—Graphs; Linked lists
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/901—Indexing; Data structures therefor; Storage structures
- G06F16/9027—Trees
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Economics (AREA)
- Finance (AREA)
- Development Economics (AREA)
- Accounting & Taxation (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- General Factory Administration (AREA)
Abstract
The invention relates to the technical field of data management, and discloses a super BOM generation method and a super BOM generation device, which comprise the following steps: indexing product component list information of the target product from a product database according to information of the target product, wherein the product component information comprises material numbers of various components forming the target product; acquiring a sub BOM structure for representing a production sub-component according to the product component list information; associating the sub BOM structures according to a preset association rule; and outputting a super BOM structure for representing the target product production list. The sub BOM structure is associated according to a preset association rule, so that the super BOM can be generated quickly, and the requirement of a client for customizing the BOM is met.
Description
Technical Field
The invention relates to the technical field of data management, in particular to a super BOM generation method and device.
Background
BOM (Bill of materials) is a bill of materials or a component list. The product BOM is a component list of the product, i.e., various component components included in the product. The BOM keeps track of all the lower-order materials and related attributes used for an item, i.e., the dependencies, unit usage and other attributes of the parent and all children.
In the prior art, part of enterprises construct a product super BOM by combing and integrating existing products, so as to realize product type spectrum management. However, the data volume of the BOM is too large, and the maintenance is complex, so that it is inconvenient to generate the product configuration BOM quickly, and it is difficult to meet the requirement of customizing the BOM by the customer.
Therefore, how to generate super BOMs quickly becomes a technical problem to be solved urgently.
Disclosure of Invention
The technical problem to be solved by the invention is how to generate the super BOM quickly.
Therefore, according to a first aspect, an embodiment of the present invention discloses a super BOM generation method, including: indexing product component list information of the target product from a product database according to information of the target product, wherein the product component information comprises material numbers of various components forming the target product; acquiring a sub BOM structure for representing a production sub-component according to the product component list information; associating the sub BOM structures according to a preset association rule; and outputting a super BOM structure for representing the target product production list.
Optionally, after obtaining the sub BOM structure for characterizing the production sub component according to the product component manifest information, the method further includes: marking interchangeable parts in the target product according to the sub BOM structure.
Optionally, the super BOM includes various part features for generating the target product and material numbers for characterizing the various parts.
Optionally, the super BOM structure may be characterized by a form, or a tree structure based on a graph block.
According to a second aspect, an embodiment of the present invention discloses a super BOM generation apparatus, including: the index module is used for indexing the product component list information of the target product from product data production according to the information of the target product; the acquisition module is used for acquiring a sub BOM structure for representing a production sub-component according to the product component list information; the association module is used for associating the sub BOM structure according to a preset association rule; and the output module is used for outputting the super BOM structure used for representing the target product production list.
Optionally, the method further comprises: and the marking module is used for marking the interchangeable parts in the target product according to the sub BOM structure.
According to a third aspect, an embodiment of the present invention discloses a computer apparatus, which includes a processor, and the processor is configured to execute a computer program stored in a memory to implement the super BOM generation method of any one of the above first aspects.
According to a fourth aspect, an embodiment of the present invention discloses a computer-readable storage medium, on which a computer program is stored, where a processor is configured to execute the computer program stored in the storage medium to implement the super BOM generation method of any one of the above first aspects.
The invention has the following beneficial effects: the embodiment discloses a super BOM generation method, which comprises the steps of indexing product component list information of a target product from a product database according to information of the target product; acquiring a sub BOM structure for representing a production sub-component according to the product component list information; associating the sub BOM structures according to a preset association rule; and outputting a super BOM structure for representing the target product production list. Compared with the scheme in the prior art, the sub BOM structure is associated according to the preset association rule, so that the super BOM can be generated quickly, and the requirement of a client for customizing the BOM is met.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and other drawings can be obtained by those skilled in the art without creative efforts.
FIG. 1 is a flowchart illustrating a super BOM generation method disclosed in this embodiment;
fig. 2 is a schematic structural diagram of a super BOM generation apparatus disclosed in this embodiment;
fig. 3 is a schematic structural diagram of a super BOM structure disclosed in this embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
The embodiment of the invention discloses a super BOM generation method, as shown in FIG. 1, comprising the following steps:
step S10, product component list information of the target product is indexed from a product database according to the information of the target product, and the product component information comprises material numbers of various components forming the target product;
step S20, acquiring a sub BOM structure for representing the production sub-component according to the product component list information;
step S30, the sub BOM structure is associated according to the preset association rule;
and step S40, outputting a super BOM structure for representing the target product production list.
It should be noted that, the embodiment discloses a super BOM generation method, which indexes product component list information of a target product from a product database according to information of the target product; acquiring a sub BOM structure for representing a production sub-component according to the product component list information; the sub BOM structure is associated according to a preset association rule; and outputting a super BOM structure for representing the target product production list. Compared with the scheme in the prior art, the sub BOM structure is associated according to the preset association rule, so that the super BOM can be generated quickly, and the requirement of a client for customizing the BOM is met.
In an alternative embodiment, after obtaining the sub-BOM structure for characterizing the production sub-component according to the product component manifest information, the method further comprises: and marking interchangeable parts in the target product according to the sub BOM structure.
In the present embodiment, the super BOM includes various part features for generating the target product and material numbers for characterizing the various parts.
In this embodiment, the super BOM structure may be characterized by a form, or a tree structure based on a graphic block.
The embodiment of the invention discloses a super BOM generating device, as shown in FIG. 2, comprising: an indexing module 501, an obtaining module 502, an associating module 503 and an outputting module 504, wherein: the indexing module 501 is configured to index product component list information of a target product from product data production according to information of the target product; the obtaining module 502 is configured to obtain a sub BOM structure for representing a production sub component according to the product component list information; the association module 503 is configured to associate the sub BOM structures according to a preset association rule; the output module 504 is configured to output a super BOM structure for characterizing the target product production list.
Optionally, the method further comprises: and the marking module 505 is used for marking the interchangeable parts in the target product according to the sub BOM structure.
Fig. 3 is a schematic structural diagram of a super BOM structure disclosed in this embodiment, and as shown in fig. 3, in a specific implementation process, a super BOM structure can be quickly generated by the super BOM generation method disclosed in this embodiment.
In addition, an embodiment of the present invention further provides a computer apparatus, where a processor executes computer instructions, so as to implement the following method:
indexing product component list information of the target product from a product database according to the information of the target product, wherein the product component information comprises material numbers of various components forming the target product; acquiring a sub BOM structure for representing a production sub-component according to the product component list information; the sub BOM structure is associated according to a preset association rule; and outputting a super BOM structure for representing the target product production list.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program, which can be stored in a computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. The storage medium may be a magnetic disk, an optical disk, a read-only memory (ROM), a Random Access Memory (RAM), or the like. The computer processor is used to execute a computer program stored in a storage medium to implement the following method:
indexing product component list information of the target product from a product database according to the information of the target product, wherein the product component information comprises material numbers of various components forming the target product; acquiring a sub BOM structure for representing a production sub-component according to the product component list information; the sub BOM structure is associated according to a preset association rule; and outputting a super BOM structure for representing the target product production list.
It should be understood that the above examples are only for clarity of illustration and are not intended to limit the embodiments. Other variations and modifications will be apparent to persons skilled in the art in light of the above description. These should also be construed as the scope of the present invention, and they should not be construed as affecting the effectiveness of the practice of the present invention or the applicability of the patent. And are neither required nor exhaustive of all embodiments. The scope of the claims of the present application shall be determined by the contents of the claims, and the description of the embodiments and the like in the specification shall be used to explain the contents of the claims. And obvious variations or modifications therefrom are within the scope of the invention.
Claims (8)
1. A super BOM generation method is characterized by comprising the following steps:
indexing product component list information of the target product from a product database according to information of the target product, wherein the product component information comprises material numbers of various components forming the target product;
acquiring a sub BOM structure for representing a production sub-component according to the product component list information;
associating the sub BOM structures according to a preset association rule;
and outputting a super BOM structure for representing the target product production list.
2. The super BOM generation method of claim 1, wherein after obtaining the sub BOM structure for characterizing the production sub-component according to the product component manifest information, further comprising:
marking interchangeable parts in the target product according to the sub BOM structure.
3. The super BOM generation method of claim 1, wherein the super BOM comprises part features for generating target products and material numbers for characterizing the part features.
4. The super BOM generation method of claim 1, wherein the super BOM structure can be characterized by a form or a tree structure based on a graphic block.
5. A super BOM generation apparatus, comprising:
the index module is used for indexing the product component list information of the target product from product data production according to the information of the target product;
the acquisition module is used for acquiring a sub BOM structure for representing a production sub-component according to the product component list information;
the association module is used for associating the sub BOM structure according to a preset association rule;
and the output module is used for outputting the super BOM structure used for representing the target product production list.
6. The super BOM generating apparatus according to claim 5, further comprising:
and the marking module is used for marking the interchangeable parts in the target product according to the sub BOM structure.
7. A computer arrangement comprising a processor for executing a computer program stored in a memory to implement the super BOM generation method of any one of claims 1 to 4.
8. A computer-readable storage medium having a computer program stored thereon, wherein a processor is configured to execute the computer program stored in the storage medium to implement the super BOM generation method according to any one of claims 1-4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010136898.0A CN111368148B (en) | 2020-03-02 | 2020-03-02 | Super BOM generation method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010136898.0A CN111368148B (en) | 2020-03-02 | 2020-03-02 | Super BOM generation method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111368148A true CN111368148A (en) | 2020-07-03 |
| CN111368148B CN111368148B (en) | 2023-05-02 |
Family
ID=71208347
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010136898.0A Active CN111368148B (en) | 2020-03-02 | 2020-03-02 | Super BOM generation method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111368148B (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101877080A (en) * | 2009-04-30 | 2010-11-03 | 厦门敏讯信息技术股份有限公司 | Method for automatically generating configuration of bill of material (BOM) |
| CN102279944A (en) * | 2010-06-11 | 2011-12-14 | 上海汽车集团股份有限公司 | Interactive checking and approving system for integrity of configurable bill of material (BOM) |
| EP3115947A1 (en) * | 2015-07-09 | 2017-01-11 | Siemens Product Lifecycle Management Software Inc. | Fast branch-based hybrid bom system and method |
| CN107886265A (en) * | 2017-09-26 | 2018-04-06 | 深圳百胜扬工业电子商务平台发展有限公司 | The scheme of super BOM data management is realized in a kind of product data management system |
| CN108711035A (en) * | 2018-05-21 | 2018-10-26 | 广东科达洁能股份有限公司 | A kind of implementation method of configurable super BOM |
| CN109784818A (en) * | 2019-01-30 | 2019-05-21 | 美林数据技术股份有限公司 | Product data processing method, device, equipment and storage medium based on BOM |
-
2020
- 2020-03-02 CN CN202010136898.0A patent/CN111368148B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101877080A (en) * | 2009-04-30 | 2010-11-03 | 厦门敏讯信息技术股份有限公司 | Method for automatically generating configuration of bill of material (BOM) |
| CN102279944A (en) * | 2010-06-11 | 2011-12-14 | 上海汽车集团股份有限公司 | Interactive checking and approving system for integrity of configurable bill of material (BOM) |
| EP3115947A1 (en) * | 2015-07-09 | 2017-01-11 | Siemens Product Lifecycle Management Software Inc. | Fast branch-based hybrid bom system and method |
| CN107886265A (en) * | 2017-09-26 | 2018-04-06 | 深圳百胜扬工业电子商务平台发展有限公司 | The scheme of super BOM data management is realized in a kind of product data management system |
| CN108711035A (en) * | 2018-05-21 | 2018-10-26 | 广东科达洁能股份有限公司 | A kind of implementation method of configurable super BOM |
| CN109784818A (en) * | 2019-01-30 | 2019-05-21 | 美林数据技术股份有限公司 | Product data processing method, device, equipment and storage medium based on BOM |
Non-Patent Citations (1)
| Title |
|---|
| 魏映婷;倪静;: "基于云计算的超级BOM设计与实现" * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111368148B (en) | 2023-05-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11847574B2 (en) | Systems and methods for enriching modeling tools and infrastructure with semantics | |
| US10354002B2 (en) | Interaction relationship building and explorer for dashboard | |
| US10929173B2 (en) | Design-time information based on run-time artifacts in a distributed computing cluster | |
| US8380588B2 (en) | Side-by-side comparison of associations for multi-level bills of material | |
| US8782597B2 (en) | Ontology updating apparatus, method and system | |
| CN111369190A (en) | Super BOM (bill of material) matching number selecting method and device | |
| CN113934820A (en) | Visual processing system, method, storage medium and terminal for unstructured data | |
| US20070162409A1 (en) | Creation and maintenance of ontologies | |
| CN111612428A (en) | Project progress visualization method and system based on work structure decomposition | |
| CN111061733B (en) | Data processing method, device, electronic equipment and computer readable storage medium | |
| Panahy et al. | A framework to construct data quality dimensions relationships | |
| CN106250110B (en) | Method and device for establishing model | |
| US8862637B2 (en) | Generating data access operations based on a data model using a data services model | |
| Kovács et al. | Benchmarking graph database backends—What works well with wikidata? | |
| Pietsch et al. | Incrementally slicing editable submodels | |
| CN111368148A (en) | Super BOM generation method and device | |
| US20130097096A1 (en) | Process entity graphs | |
| CN105824976A (en) | Method and device for optimizing word segmentation banks | |
| WO2020018223A1 (en) | Binding query scope to directory attributes | |
| CN111125087A (en) | Data storage method and device | |
| EP3086244B1 (en) | Database system and method of operation thereof | |
| Colombo et al. | Developing DA applications in SMEs industrial context | |
| US7571078B2 (en) | Time dependent process parameters for integrated process and product engineering | |
| JP5706248B2 (en) | Product handling standard creation system and method | |
| Becker et al. | Semantic business process management |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |