CN109784818A - Product data processing method, device, equipment and storage medium based on BOM - Google Patents
Product data processing method, device, equipment and storage medium based on BOM Download PDFInfo
- Publication number
- CN109784818A CN109784818A CN201910089851.0A CN201910089851A CN109784818A CN 109784818 A CN109784818 A CN 109784818A CN 201910089851 A CN201910089851 A CN 201910089851A CN 109784818 A CN109784818 A CN 109784818A
- Authority
- CN
- China
- Prior art keywords
- product
- bom
- data
- target product
- tables
- 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.)
- Pending
Links
Classifications
-
- 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
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The problem of disclosure provides a kind of product data processing method, device, equipment and storage medium based on BOM, is related to data processing field, is able to solve each phase data dispersion of product, and lookup takes time and effort.The specific technical proposal is: obtaining the engineering BOM of target product；According to the engineering BOM of target product, the incidence relation of each material and each tables of data in pre-set tables of data set in target product is configured；Obtain the bill of materials in kind of target product；According to the bill of materials in kind and incidence relation of target product, target product is obtained from tables of data set in the product data of product lifecycle.The present invention is for collecting and showing to product lifecycle data according to BOM structure in kind.
Description
Technical field
This disclosure relates to data processing field, more particularly to the product data processing method based on BOM, device, equipment and
Storage medium.
Background technique
In processing manufacturing industry, product, again to the business of the links such as inspection, test, test, quality, has from research and development, production
Operation system undertakes, these operation systems include PDM (Product Data Management, product data management), CAPP
(computer aided process planning, Condition of Computer Aided Process Planning), MES (Manufacturing
Execution System, manufacturing execution system), ERP (Enterprise Resource Planning, corporate resources meter
Draw), TDM (Test Data Management, test data management system), quality control system etc., result in product in this way
Related data be distributed in each operation system.So, when product when something goes wrong, business personnel usually requires to be existed according to product
Data in each operation system carry out problem investigation and positioning；When research staff needs to optimize product, also need
It to be optimized according to data are led to the problem of during production processing test etc..Positioning problems are either carried out still to produce
Product optimization causes the lookup of Various types of data to be returned with synthesis since data relevant to the product are dispersed in each operation system
Collection takes time and effort, and consults low efficiency.
Summary of the invention
The embodiment of the present disclosure provides a kind of product data processing method, device, equipment and storage medium based on BOM, energy
It enough solves the problem of that each phase data dispersion of product is searched to take time and effort.The technical solution is as follows:
According to the first aspect of the embodiments of the present disclosure, a kind of product data processing method based on BOM, this method packet are provided
It includes:
The engineering BOM BOM of target product is obtained, designing BOM includes the material name of each material in target product
Title, COM code, at least two in material quantity；
According to the designing BOM of target product, configure in target product in each material and pre-set tables of data set
The incidence relation of each tables of data, tables of data set include the tables of data in each stage in product lifecycle, each data
Table includes at least one of the attribute information of each material；
The BOM in kind of target product is obtained, BOM in kind includes the information in kind of each material in target product；
According to the BOM and incidence relation in kind of target product, target product is obtained from tables of data set and is given birth to entirely in product
Order the product data in period.
Designing BOM based on product constructs material object BOM, the product of tissue products Life cycle in the form of BOM in kind
The problem of data are able to solve each phase data dispersion of product, and lookup takes time and effort, facilitates user to carry out unification to product data
Analysis and development other application, can effectively assist product problem retrospect and research staff's design optimization.
In one embodiment, before the designing BOM for obtaining target product, method further include:
The data list structure in each stage in product lifecycle is constructed, data list structure includes tables of data table name and word
Segment information；
According to data list structure, the product data that will be dispersed in different business systems are collected, and obtain tables of data set.
In one embodiment, the BOM in kind for obtaining target product includes:
Obtain the assembly inventory of target product；
According to the assembly inventory of the designing BOM of target product and target product, the BOM in kind of target product is determined.
In one embodiment, this method further include: the query information that receiving terminal apparatus is sent, query information is for referring to
Show inquiry target product in the product data of product lifecycle；
The product data of target product are sent into terminal device according to query information.
According to the second aspect of an embodiment of the present disclosure, a kind of product data processing unit based on BOM is provided, comprising:
First obtains module, and for obtaining the engineering BOM BOM of target product, designing BOM includes in target product
The name of material of each material, COM code, at least two in material quantity；
Configuration module, for the designing BOM according to target product, configure in target product each material with it is pre-set
The incidence relation of each tables of data in tables of data set, tables of data set include the data in each stage in product lifecycle
Table, each tables of data include at least one of the attribute information of each material；
Second obtains module, and for obtaining the BOM in kind of target product, BOM in kind includes each material in target product
Information in kind；
Third obtains module and obtains mesh from tables of data set for the BOM and incidence relation in kind according to target product
Product is marked in the product data of product lifecycle.
In one embodiment, it is somebody's turn to do the product data processing unit based on BOM further include: construct module and collect module；
Module is constructed, for constructing the data list structure in each stage in product lifecycle, data list structure includes
Tables of data table name and field information；
Module is collected, for according to data list structure, the product data that will be dispersed in different business systems to be collected, obtained
To tables of data set.
In one embodiment, the second acquisition module includes: acquisition submodule and determining submodule；
Acquisition submodule, for obtaining the assembly inventory of target product；
Submodule is determined, for determining target product according to the designing BOM of target product and the assembly inventory of target product
BOM in kind.
In one embodiment, it is somebody's turn to do the product data processing unit based on BOM further include: receiving module and sending module；
Receiving module, for the query information that receiving terminal apparatus is sent, query information is used to indicate inquiry target product
In the product data of product lifecycle；
Sending module, for the product data of target product to be sent terminal device according to query information.
According to the third aspect of an embodiment of the present disclosure, a kind of product data processing equipment based on BOM, including processing are provided
Device and memory, at least one computer instruction is stored in memory, and instruction is loaded by processor and executed to realize first
Performed step in product data processing method based on BOM described in any embodiment of aspect and first aspect.
According to a fourth aspect of embodiments of the present disclosure, a kind of computer readable storage medium is provided, is stored in storage medium
There is at least one computer instruction, instruction is loaded by processor and executed any reality to realize first aspect and first aspect
Apply step performed in the product data processing method based on BOM described in example.
It should be understood that above general description and following detailed description be only it is exemplary and explanatory, not
The disclosure can be limited.
Detailed description of the invention
The drawings herein are incorporated into the specification and forms part of this specification, and shows the implementation for meeting the disclosure
Example, and together with specification for explaining the principles of this disclosure.
Fig. 1 is a kind of flow chart for product data processing method based on BOM that the embodiment of the present disclosure provides；
Fig. 2 is a kind of designing BOM structural schematic diagram for target product that the embodiment of the present disclosure provides；
Fig. 3 is a kind of schematic diagram for associated configuration that the embodiment of the present disclosure provides；
Fig. 4 is a kind of schematic diagram for associated configuration that the embodiment of the present disclosure provides；
Fig. 5 is a kind of BOM structural schematic diagram in kind for target product that the embodiment of the present disclosure provides；
Fig. 6 is a kind of schematic diagram that product data are obtained according to incidence relation that the embodiment of the present disclosure provides；
Fig. 7 is a kind of schematic diagram that product data are obtained according to incidence relation that the embodiment of the present disclosure provides；
Fig. 8 is a kind of structure chart for product data processing unit based on BOM that the embodiment of the present disclosure provides；
Fig. 9 is a kind of structure chart for product data processing unit based on BOM that the embodiment of the present disclosure provides；
Figure 10 is a kind of structure chart for product data processing unit based on BOM that the embodiment of the present disclosure provides；
Figure 11 is a kind of structure chart for product data processing unit based on BOM that the embodiment of the present disclosure provides；
Figure 12 is a kind of structure chart for product data processing equipment based on BOM that the embodiment of the present disclosure provides.
Specific embodiment
Example embodiments are described in detail here, and the example is illustrated in the accompanying drawings.Following description is related to
When attached drawing, unless otherwise indicated, the same numbers in different drawings indicate the same or similar elements.Following exemplary embodiment
Described in embodiment do not represent all implementations consistent with this disclosure.On the contrary, they be only with it is such as appended
The example of the consistent device and method of some aspects be described in detail in claims, the disclosure.
The embodiment of the present disclosure provides a kind of product data processing method based on product-based bom flow, as shown in Figure 1, the base
In product-based bom flow product data processing method the following steps are included:
101, the designing BOM of target product is obtained.
The engineering BOM (BOM, Bill of Material) of target product includes each material in target product
Name of material, COM code, at least two in material quantity.Illustratively, it is needed in the designing BOM of target product comprising each
The name of material and material quantity of material, alternatively, needing the COM code and object comprising each material in the designing BOM of target product
Quantity is expected, alternatively, needing COM code, COM code and the material quantity comprising each material in the designing BOM of target product.Ginseng
The designing BOM structural schematic diagram that Fig. 2 show product A is examined, product A has 2 part Bs and 1 component C to constitute, and component C there are 2
Part D and 1 part E are constituted.It should be noted that target product refers to any one product, the disclosure is only to target
It indicates to be illustrated in the product data of product lifecycle to obtaining any one product for product, target does not represent
Any limitation.
102, according to the designing BOM of target product, each material and pre-set tables of data collection in target product are configured
The incidence relation of each tables of data in conjunction.
Before step 102 is specifically described, pre-set tables of data set is illustrated first.Tables of data
Set includes the tables of data in each stage in product lifecycle, and tables of data set is in the designing BOM for obtaining target product
Before pre-set, specifically, constructing the data list structure in each stage in product lifecycle, data list structure includes
Tables of data table name and field information；It is collected, is obtained according to the product data that data list structure will be dispersed in different business systems
To tables of data set.Wherein, field information includes field name, field type, field attribute etc..
Product lifecycle includes the stages such as research and development, production, inspection, test, test, quality, therefore, each phase data
Research and development data, process data, production testing data, product quality data, test data including product etc..Therefore, it is necessary to right
Product each stage needs the tables of data for collecting and showing to be combed, and the definition of complete paired data table structure, each tables of data
Field information in include each material at least one of attribute information.It can root for the title of the attribute information of material
Adaptive change is carried out according to the demand of user, attribute information may include product coding, product figure number, affiliated model, batch, production
Product in kind number, also may include COM code, name of material, product type, product figure number, production batch, product material object
Number.
Reference table 1 show research and development of products phase data table and its table structure exemplary diagram, tables of data, that is, data in table 1
, three tables of data in research and development of products stage: charter, design report and reliability assurance program are enumerated herein.
Table 1
Wherein, the table name of data item 1 is charter, and the field that the table structure of the charter includes has: name of product, product
Coding, product figure number, affiliated model, charter title, coder, proofreader, auditor；The table name of data item 2 is design report
It accuses, the field that the table structure of the design report includes has: name of product, product coding, product figure number, affiliated model, design report
Accuse title；The table name of data item 3 is reliability assurance program, and the field that the table structure of the reliability assurance program includes has: being produced
The name of an article claims, product coding, product figure number, affiliated model, outline title, coder, proofreader, auditor.
Reference table 2 show product quality detection-phase tables of data and its table structure exemplary diagram, and the tables of data in table 2 counts
According to item, three tables of data of product quality detection-phase are enumerated herein: querying single, exception clearance application form and product qualification statistics
Table.
Table 2
In building product lifecycle after the data list structure in each stage, it will be dispersed in different business systems
Product data are collected, that is to say, that will be dispersed in the operation systems such as PDM, CAPP, MES, ERP, TDM, quality control system
Product data, pass through Webservice mode, ETL (Extract-Transform-Load, data warehouse technology) extraction side
Formula etc., the product data that will be dispersed in each operation system, which are collected, carries out summarizing according to data list structure, obtains tables of data collection
It closes.In turn, according to the attribute information of material each in target product, each material and pre-set number in target product are configured
According to the incidence relation of each tables of data in table set.That is, according to the designing BOM structure of target product, in BOM structure
Each material attribute information and tables of data set in field name in each tables of data carried out according to practical business situation
Association.
Refering to what is shown in Fig. 3, by taking two data item of the charter in research and development of products stage and design report as an example, by the category of material
Property information and the literary name sections of two data item be associated configuration respectively.The attribute of each material in the designing BOM of target product
Information, i.e. the material attribute of BOM includes: COM code, name of material, product type, product figure number, production batch in Fig. 3
It is secondary, product in kind number, it is as shown on the left side of figure 3, the COM code of material is associated with the product number of charter, by material
Product type is associated with the affiliated model of charter, as shown in the right side Fig. 3, by the production of the COM code of material and design report
Product coding is associated, and the product type of material is associated with the affiliated model of design report.
Refering to what is shown in Fig. 4, by taking the query list in product quality inspection stage and exception two data item of clearance application form as an example,
The literary name section of the attribute information of material and two data item is associated to configuration respectively.It is each in the designing BOM of target product
The attribute information of material, i.e. in Fig. 4 the material attribute of BOM include: COM code, name of material, product type, product figure number,
It is production batch, product in kind number, as shown in the left side Fig. 4, the COM code of material is related to single product number is queried
Connection, the product type of material is associated with single affiliated model is queried, by the production batch of material and query single batch
Secondary number associated, associated with single product number is queried by the product of material in kind number；Shown on the right side of Fig. 4, by material
COM code is associated with the exception product coding of clearance application form, by the institute of the product type of material and exception clearance application form
Genotype number is associated, and the production batch of material is associated with the exception batch number of clearance application form, by the product of material
In kind number associated with the exception product number of clearance application form.
It should be noted that each data item in product each stage is both needed to the category with material in actual production manufacture
Property information is associated configuration, and specific associate field is determined by actual business scenario, and Fig. 3 and Fig. 4 are merely illustrative.
103, the BOM in kind of target product is obtained.
BOM in kind includes the information in kind of each material in target product, and information in kind, which is used to indicate, to be manufactured
The information such as the material object number of each material, piece number, quality certification number in journey.In the embodiments of the present disclosure, the material object of target product is obtained
BOM includes: the assembly inventory for obtaining target product；According to the assembly inventory of the designing BOM of target product and target product, building
The BOM in kind of target product.Specifically, producing after the assembly is completed in target product, the reality of the product can be obtained from assembly inventory
Object information completes building for material object BOM, forms product by increasing the information such as batch, material object number in the structure of designing BOM
The in kind and one-to-one relationship of material object BOM.
Refering to what is shown in Fig. 5, if the 2018th batch produces 3 product A, according to the designing BOM knot of assembly inventory and product A
Structure forms 3 material object BOM.By taking first material object BOM as an example, the 2018-01-001 after product A is in kind number of product A, portion
2018-01-002 after part B is in kind number of product B, and the 201801-005 after part D is in kind number of part D, with such
It pushes away.It also may include the material volume of material in BOM in kind it should be noted that only illustrated in kind number herein
Code, name of material, product type, product figure number, production batch.
104, according to the BOM and incidence relation in kind of target product, target product is obtained from tables of data set in product
Product data in Life cycle.
According to the incidence relation of the material attribute information of configuration and each tables of data, Related product number on each BOM node is realized
According to the Auto-matching of item, thus being associated with the specific product data in each stage collected and corresponding material object BOM node, automatically
Form the product lifecycle view based on BOM in kind.
Refering to what is shown in Fig. 6, by taking product A_2018-01-001 as an example, ProductName in the material determinant attribute information of product A
In kind number of title, product coding, product figure number, affiliated model, batch, product is successively are as follows: product A, TH-01, TH-01, p-type number,
2018 batches, 2018-01-001 pass through " product coding ", " type according to the incidence relation of the attribute information of product A and charter
Number " the two key messages find charter data 2 first closed with product A_2018-01-001 material object, such as dotted line frame in Fig. 6
Shown part；Referring to shown in Fig. 7, by taking part D_2018-01-005 as an example, ProductName in the material determinant attribute information of part D
In kind number of title, product coding, product figure number, affiliated model, batch, product is successively are as follows: product D, TH-07, TH-07, p-type number,
2018 batches, 2018-01-005, according to the incidence relation of the attribute information of part D and exception clearance application form, by the way that " product is compiled
Code ", " model ", " batch ", " product coding " this four key messages are found appoints with what part D_2018-01-005 material object first closed
Business book data 1, the part as shown in dotted line frame in Fig. 7.Shown in referring to figure 6 and figure 7, product A_2018-01-001 section is completed
The Auto-matching association of relevant " charter " data of point, part D_2018-01-005 node are relevant, and " exception, which is let pass, applies
The Auto-matching of table " data is associated with, and each data item of remaining each node will also carry out data correlation or lookup by this way.This
Sample, each phase data for realizing the product that will be dispersed in each operation system carry out tissue and exhibition according to the form of BOM in kind
It is existing, it is able to solve each phase data dispersion of product, the problem of taking time and effort is searched, improves and consult efficiency.
After step 104, this method further include: obtain the query information that terminal device is sent, query information is for referring to
Show inquiry target product in the product data of product lifecycle；The product data of target product are sent according to query information
To terminal device.In this way, user can carry out checking and applying for product lifecycle data by BOM view in kind,
It improves and consults efficiency.
The product data processing method based on BOM that the embodiment of the present disclosure provides, obtains the designing BOM of target product；Root
According to the designing BOM of target product, each material and each tables of data in pre-set tables of data set in target product are configured
Incidence relation；The BOM in kind of target product is obtained, BOM in kind includes the information in kind of each material in target product；According to
The BOM and incidence relation in kind of target product obtain target product in the product of product lifecycle from tables of data set
Data.The technical program constructs material object BOM, the tissue products Life cycle in the form of BOM in kind based on the designing BOM of product
Product data, be able to solve product each phase data dispersion, the problem of lookup takes time and effort, facilitate user to product data into
Row united analysis and development other application, can effectively assist product problem retrospect and research staff's design optimization.
Based on the product data processing method described in the corresponding embodiment of above-mentioned Fig. 1 based on BOM, following is this public affairs
Opening apparatus embodiment can be used for executing embodiments of the present disclosure.
The embodiment of the present disclosure provides a kind of product data processing unit based on BOM, as shown in figure 8, should the production based on BOM
Product data processing equipment 80 includes: the first acquisition module 801, configuration module 802, second obtains module 803 and third obtains mould
Block 804；
First obtains module 801, and for obtaining the engineering BOM BOM of target product, designing BOM includes target product
In the name of material of each material, COM code, at least two in material quantity；
Configuration module 802 configures in target product each material and sets in advance for the designing BOM according to target product
The incidence relation of each tables of data in the tables of data set set, tables of data set include each stage in product lifecycle
Tables of data, each tables of data include at least one of the attribute information of each material；
Second obtains module 803, and for obtaining the BOM in kind of target product, BOM in kind includes each object in target product
The information in kind of material；
Third obtains module 804 and obtains from tables of data set for the BOM and incidence relation in kind according to target product
Take target product in the product data of product lifecycle.
In one embodiment, as shown in figure 9, being somebody's turn to do the product data processing unit 80 based on BOM further include: building module
805 and collect module 806；
Module 805 is constructed, for constructing the data list structure in each stage in product lifecycle, data list structure packet
Include tables of data table name and field information；
Module 806 is collected, for according to data list structure, the product data that will be dispersed in different business systems to be returned
Collection, obtains tables of data set.
In one embodiment, as shown in Figure 10, the second acquisition module 803 includes: acquisition submodule 8031 and determines sub
Module 8032；
Acquisition submodule 8031, for obtaining the assembly inventory of target product；
Submodule 8032 is determined, for determining target according to the designing BOM of target product and the assembly inventory of target product
The BOM in kind of product.
In one embodiment, as shown in figure 11, it is somebody's turn to do the product data processing unit 80 based on BOM further include: receive mould
Block 807 and sending module 808；
Receiving module 807, for the query information that receiving terminal apparatus is sent, query information is used to indicate inquiry target and produces
Product data of the product in product lifecycle；
Sending module 808, for the product data of target product to be sent terminal device according to query information.
The product data processing unit based on BOM that the embodiment of the present disclosure provides, obtains the designing BOM of target product；Root
According to the designing BOM of target product, each material and each tables of data in pre-set tables of data set in target product are configured
Incidence relation；The BOM in kind of target product is obtained, BOM in kind includes the information in kind of each material in target product；According to
The BOM and incidence relation in kind of target product obtain target product in the product of product lifecycle from tables of data set
Data.The technical program constructs material object BOM, the tissue products Life cycle in the form of BOM in kind based on the designing BOM of product
Product data, be able to solve product each phase data dispersion, the problem of lookup takes time and effort, facilitate user to product data into
Row united analysis and development other application, can effectively assist product problem retrospect and research staff's design optimization.
With reference to shown in Figure 12, the embodiment of the present disclosure additionally provides a kind of product data processing equipment based on BOM, this is based on
The product data processing equipment of BOM includes receiver 1201, transmitter 1202, memory 1203 and processor 1204, the transmitting
Device 1202 and memory 1203 are connect with processor 1204 respectively, and at least one computer instruction is stored in memory 1203,
Processor 1204 is for loading and executing at least one computer instruction, to realize described in the corresponding embodiment of above-mentioned Fig. 1
The product data processing method based on BOM.
Based on the product data processing method described in the corresponding embodiment of above-mentioned Fig. 1 based on BOM, the disclosure is implemented
Example also provides a kind of computer readable storage medium, for example, non-transitorycomputer readable storage medium can be read-only storage
Device (English: Read Only Memory, ROM), random access memory (English: Random Access Memory, RAM),
CD-ROM, tape, floppy disk and optical data storage devices etc..It is stored with computer instruction on the storage medium, it is above-mentioned for executing
Product data processing method described in the corresponding embodiment of Fig. 1 based on BOM, details are not described herein again.
Those skilled in the art will readily occur to its of the disclosure after considering specification and practicing disclosure disclosed herein
Its embodiment.This application is intended to cover any variations, uses, or adaptations of the disclosure, these modifications, purposes or
Person's adaptive change follows the general principles of this disclosure and including the undocumented common knowledge in the art of the disclosure
Or conventional techniques.The description and examples are only to be considered as illustrative, and the true scope and spirit of the disclosure are by following
Claim is pointed out.
Claims (10)
1. a kind of product data processing method based on BOM, which is characterized in that the described method includes:
The engineering BOM BOM of target product is obtained, the designing BOM includes the material of each material in the target product
Title, COM code, at least two in material quantity；
According to the designing BOM of the target product, each material and pre-set tables of data collection in the target product are configured
The incidence relation of each tables of data in conjunction, the tables of data set include the tables of data in each stage in product lifecycle,
Each tables of data includes at least one of the attribute information of each material；
The BOM in kind of the target product is obtained, the material object BOM includes the letter in kind of each material in the target product
Breath；
According to the BOM in kind and the incidence relation of the target product, the target is obtained from the tables of data set and is produced
Product data of the product in the product lifecycle.
2. the method according to claim 1, wherein it is described obtain target product designing BOM before, the side
Method further include:
The data list structure in each stage in the product lifecycle is constructed, the data list structure includes tables of data table name
And field information；
It is collected according to the product data that the data list structure will be dispersed in different business systems, obtains the tables of data collection
It closes.
3. the method according to claim 1, wherein the BOM in kind for obtaining the target product includes:
Obtain the assembly inventory of the target product；
According to the assembly inventory of the designing BOM of the target product and the target product, the material object of the target product is determined
BOM。
4. the method according to claim 1, wherein the method also includes:
The query information that receiving terminal apparatus is sent, the query information are used to indicate the inquiry target product in the product
The product data of Life cycle；
The product data of the target product are sent into the terminal device according to the query information.
5. a kind of product data processing unit based on BOM characterized by comprising
First obtains module, and for obtaining the engineering BOM BOM of target product, the designing BOM includes that the target produces
The name of material of each material in product, COM code, at least two in material quantity；
Configuration module configures in the target product each material and sets in advance for the designing BOM according to the target product
The incidence relation of each tables of data in the tables of data set set, the tables of data set include each rank in product lifecycle
The tables of data of section, each tables of data includes at least one of the attribute information of each material；
Second obtains module, and for obtaining the BOM in kind of the target product, the material object BOM includes in the target product
The information in kind of each material；
Third obtains module, for the BOM in kind and the incidence relation according to the target product, from the tables of data set
It is middle to obtain the target product in the product data of the product lifecycle.
6. device according to claim 5, which is characterized in that the product data processing unit based on BOM further include:
It constructs module and collects module；
The building module, for constructing the data list structure in each stage in the product lifecycle, the tables of data
Structure includes tables of data table name and field information；
Described to collect module, the product data for will be dispersed in different business systems according to the data list structure are returned
Collection, obtains the tables of data set.
7. device according to claim 5, which is characterized in that it is described second acquisition module include: acquisition submodule and really
Stator modules；
The acquisition submodule, for obtaining the assembly inventory of the target product；
The determining submodule, for determining according to the designing BOM of the target product and the assembly inventory of the target product
The BOM in kind of the target product.
8. device according to claim 5, which is characterized in that the product data processing unit based on BOM further include:
Receiving module and sending module；
The receiving module, for the query information that receiving terminal apparatus is sent, the query information is used to indicate described in inquiry
Product data of the target product in the product lifecycle；
The sending module is set for the product data of the target product to be sent the terminal according to the query information
It is standby.
9. a kind of product data processing equipment based on BOM, which is characterized in that the product data processing equipment based on BOM
Including processor and memory, at least one computer instruction is stored in the memory, described instruction is by the processor
It loads and executes to realize claim 1 institute into the described in any item product data processing methods based on BOM of claim 4
The step of execution.
10. a kind of computer readable storage medium, which is characterized in that be stored at least one computer in the storage medium and refer to
It enables, described instruction is loaded by processor and executed to realize that claim 1 is described in any item based on BOM's to claim 4
Performed step in product data processing method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910089851.0A CN109784818A (en) | 2019-01-30 | 2019-01-30 | Product data processing method, device, equipment and storage medium based on BOM |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910089851.0A CN109784818A (en) | 2019-01-30 | 2019-01-30 | Product data processing method, device, equipment and storage medium based on BOM |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109784818A true CN109784818A (en) | 2019-05-21 |
Family
ID=66503731
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910089851.0A Pending CN109784818A (en) | 2019-01-30 | 2019-01-30 | Product data processing method, device, equipment and storage medium based on BOM |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109784818A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110262973A (en) * | 2019-06-14 | 2019-09-20 | 深圳前海微众银行股份有限公司 | Data form maintaining method, device, equipment and computer storage medium |
| CN111368148A (en) * | 2020-03-02 | 2020-07-03 | 深圳百胜扬工业电子商务平台发展有限公司 | Super BOM generation method and device |
| CN112465418A (en) * | 2020-10-29 | 2021-03-09 | 苏州浪潮智能科技有限公司 | Material loading method and device based on product life cycle management |
| CN114548885A (en) * | 2022-04-27 | 2022-05-27 | 广州粤芯半导体技术有限公司 | Recipe data collection method and device for wafer manufacturing |
| CN115357671A (en) * | 2022-10-19 | 2022-11-18 | 成都飞机工业（集团）有限责任公司 | Method, device, equipment and medium for constructing aircraft assembly data |
| WO2024020738A1 (en) * | 2022-07-25 | 2024-02-01 | 西门子股份公司 | Data retrieval method, and electronic device, medium and program product |
| CN118171890A (en) * | 2024-05-10 | 2024-06-11 | 常州星宇车灯股份有限公司 | Using method of material configuration system of car lamp production line |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101789094A (en) * | 2009-05-22 | 2010-07-28 | 重庆迈特科技有限责任公司 | Product family configurator based on single-layer variant material library and implementation method thereof |
| CN101937526A (en) * | 2010-04-28 | 2011-01-05 | 重庆迈特科技有限责任公司 | Method for configuring product multi-BOM tree based on base products |
| CN102004943A (en) * | 2010-04-28 | 2011-04-06 | 重庆迈特科技有限责任公司 | Product multiple-BOM (bill of material) tree configurator based on unified material store |
| CN102651102A (en) * | 2012-04-09 | 2012-08-29 | 北京航空航天大学 | Product information modeling method in collaborative environment based on product entire life cycle |
| CN105184542A (en) * | 2015-10-20 | 2015-12-23 | 韩继东 | Enterprise resource plan real time management method and system based on material stock state |
| CN106503811A (en) * | 2016-10-26 | 2017-03-15 | 北京达美盛软件股份有限公司 | A kind of infrastructure full life cycle management method based on big data |
| CN106777510A (en) * | 2016-11-21 | 2017-05-31 | 中国航天科工集团第四研究院第四总体设计部 | A kind of automatic generation method of guided missile production schedule |
| CN108614891A (en) * | 2018-05-09 | 2018-10-02 | 上海航天精密机械研究所 | Space product data packet is built and consistency desired result method |
| CN108876244A (en) * | 2018-06-22 | 2018-11-23 | 珠海格力电器股份有限公司 | Storage query system and method for bill of material (BOM) |
| CN108984895A (en) * | 2018-07-10 | 2018-12-11 | 徐工集团工程机械有限公司 | A kind of model automatic identifying method based on XML heterogeneous platform |
-
2019
- 2019-01-30 CN CN201910089851.0A patent/CN109784818A/en active Pending
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101789094A (en) * | 2009-05-22 | 2010-07-28 | 重庆迈特科技有限责任公司 | Product family configurator based on single-layer variant material library and implementation method thereof |
| CN101937526A (en) * | 2010-04-28 | 2011-01-05 | 重庆迈特科技有限责任公司 | Method for configuring product multi-BOM tree based on base products |
| CN102004943A (en) * | 2010-04-28 | 2011-04-06 | 重庆迈特科技有限责任公司 | Product multiple-BOM (bill of material) tree configurator based on unified material store |
| CN102651102A (en) * | 2012-04-09 | 2012-08-29 | 北京航空航天大学 | Product information modeling method in collaborative environment based on product entire life cycle |
| CN105184542A (en) * | 2015-10-20 | 2015-12-23 | 韩继东 | Enterprise resource plan real time management method and system based on material stock state |
| CN106503811A (en) * | 2016-10-26 | 2017-03-15 | 北京达美盛软件股份有限公司 | A kind of infrastructure full life cycle management method based on big data |
| CN106777510A (en) * | 2016-11-21 | 2017-05-31 | 中国航天科工集团第四研究院第四总体设计部 | A kind of automatic generation method of guided missile production schedule |
| CN108614891A (en) * | 2018-05-09 | 2018-10-02 | 上海航天精密机械研究所 | Space product data packet is built and consistency desired result method |
| CN108876244A (en) * | 2018-06-22 | 2018-11-23 | 珠海格力电器股份有限公司 | Storage query system and method for bill of material (BOM) |
| CN108984895A (en) * | 2018-07-10 | 2018-12-11 | 徐工集团工程机械有限公司 | A kind of model automatic identifying method based on XML heterogeneous platform |
Non-Patent Citations (1)
| Title |
|---|
| 蒋剑: ""敏捷制造***BOM数据生成及管理研究"", 《中国优秀硕士学位论文全文数据库 工程科技II辑》 * |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110262973A (en) * | 2019-06-14 | 2019-09-20 | 深圳前海微众银行股份有限公司 | Data form maintaining method, device, equipment and computer storage medium |
| CN110262973B (en) * | 2019-06-14 | 2024-03-22 | 深圳前海微众银行股份有限公司 | Data maintenance method, device, equipment and computer storage medium |
| CN111368148A (en) * | 2020-03-02 | 2020-07-03 | 深圳百胜扬工业电子商务平台发展有限公司 | Super BOM generation method and device |
| CN111368148B (en) * | 2020-03-02 | 2023-05-02 | 深圳百胜扬工业电子商务平台发展有限公司 | Super BOM generation method and device |
| CN112465418A (en) * | 2020-10-29 | 2021-03-09 | 苏州浪潮智能科技有限公司 | Material loading method and device based on product life cycle management |
| CN112465418B (en) * | 2020-10-29 | 2022-06-03 | 苏州浪潮智能科技有限公司 | Material loading method and device based on product life cycle management |
| CN114548885A (en) * | 2022-04-27 | 2022-05-27 | 广州粤芯半导体技术有限公司 | Recipe data collection method and device for wafer manufacturing |
| WO2024020738A1 (en) * | 2022-07-25 | 2024-02-01 | 西门子股份公司 | Data retrieval method, and electronic device, medium and program product |
| CN115357671A (en) * | 2022-10-19 | 2022-11-18 | 成都飞机工业（集团）有限责任公司 | Method, device, equipment and medium for constructing aircraft assembly data |
| CN115357671B (en) * | 2022-10-19 | 2023-01-10 | 成都飞机工业（集团）有限责任公司 | Method, device, equipment and medium for constructing aircraft assembly data |
| CN118171890A (en) * | 2024-05-10 | 2024-06-11 | 常州星宇车灯股份有限公司 | Using method of material configuration system of car lamp production line |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109784818A (en) | Product data processing method, device, equipment and storage medium based on BOM | |
| CN102122265B (en) | System and method for verifying computer software test results | |
| CN109033471B (en) | Information asset identification method and device | |
| KR101808702B1 (en) | Enterprise Diagnostic Method Using Enterprise Diagnosis And Evaluation Integration System | |
| CN107329890A (en) | Test method and device based on Mock and server | |
| CN105786695B (en) | Data test method and system | |
| US20080255997A1 (en) | Enterprise integrated business process schema | |
| US20110161132A1 (en) | Method and system for extracting process sequences | |
| CN103678446B (en) | Improved mode map based on Data View and database table | |
| US20140365827A1 (en) | Architecture for end-to-end testing of long-running, multi-stage asynchronous data processing services | |
| CN105868311A (en) | Data analyzing method and device | |
| CN109002391A (en) | The method of automatic detection embedded software interface testing data | |
| CN110503408B (en) | Business process management system based on custom configuration | |
| US20160371805A1 (en) | Higher education data model systems and networks, and methods of organizing and operating the same | |
| KR101425868B1 (en) | System and Method for processing of large scale data based rule set | |
| Zhang et al. | A survey on quality assurance techniques for big data applications | |
| CN109978495A (en) | A kind of nuclear power station debugging test Report workout method and system | |
| CN111106899A (en) | Data verification method and device in Internet of things, computer equipment and storage medium | |
| CN106294128A (en) | A kind of automated testing method deriving report data and device | |
| CN106599216A (en) | Computer based training courseware publishing system | |
| US20090313230A1 (en) | Computing job information managing device, terminal, and computing job information managing system | |
| CN105373473B (en) | CDR accuracys method of testing and test system based on original signaling decoding | |
| CN104268680A (en) | Case detection process real-time synchronizing system | |
| US20140324918A1 (en) | Database Generation System, Method For Generating A Database, Product Line Management System And Non-Transitory Data Carrier | |
| Agushinta et al. | Business process reengineering on customer service and procurement units in clinical laboratory |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190521 |