CN112651693A - Car system BOM structure data processing method for production material distribution - Google Patents

Car system BOM structure data processing method for production material distribution Download PDF

Info

Publication number
CN112651693A
CN112651693A CN202110127700.7A CN202110127700A CN112651693A CN 112651693 A CN112651693 A CN 112651693A CN 202110127700 A CN202110127700 A CN 202110127700A CN 112651693 A CN112651693 A CN 112651693A
Authority
CN
China
Prior art keywords
bom
vehicle
data
production
graph
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
Application number
CN202110127700.7A
Other languages
Chinese (zh)
Inventor
徐利新
杨丹
李红叶
张永辉
胡兴勇
贾瑞
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
QIMING INFORMATION TECHNOLOGY CO LTD
Original Assignee
QIMING INFORMATION TECHNOLOGY CO LTD
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by QIMING INFORMATION TECHNOLOGY CO LTD filed Critical QIMING INFORMATION TECHNOLOGY CO LTD
Priority to CN202110127700.7A priority Critical patent/CN112651693A/en
Publication of CN112651693A publication Critical patent/CN112651693A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087Inventory or stock management, e.g. order filling, procurement or balancing against orders
    • G06Q10/0875Itemisation or classification of parts, supplies or services, e.g. bill of materials
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Administration; Management
    • G06Q10/06Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • G06Q10/063Operations research, analysis or management
    • G06Q10/0631Resource planning, allocation, distributing or scheduling for enterprises or organisations
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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
    • G06Q50/00Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
    • G06Q50/04Manufacturing
    • YGENERAL 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
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30Computing systems specially adapted for manufacturing

Landscapes

  • Business, Economics & Management (AREA)
  • Engineering & Computer Science (AREA)
  • Human Resources & Organizations (AREA)
  • Economics (AREA)
  • Strategic Management (AREA)
  • General Business, Economics & Management (AREA)
  • Theoretical Computer Science (AREA)
  • Marketing (AREA)
  • Entrepreneurship & Innovation (AREA)
  • General Physics & Mathematics (AREA)
  • Tourism & Hospitality (AREA)
  • Physics & Mathematics (AREA)
  • Development Economics (AREA)
  • Quality & Reliability (AREA)
  • Operations Research (AREA)
  • Game Theory and Decision Science (AREA)
  • Educational Administration (AREA)
  • Primary Health Care (AREA)
  • Manufacturing & Machinery (AREA)
  • General Health & Medical Sciences (AREA)
  • Health & Medical Sciences (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • General Factory Administration (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a vehicle BOM structure data processing method for production material distribution, which comprises the steps of receiving vehicle BOM structure data of an external system through a BOM center, extracting material data and parent-child material relation data in the vehicle BOM structure data, converting the vehicle BOM structure data in a relational database into a graph database form, storing the graph database form in a graph database, finally constructing BOM tree structures of all vehicle systems by utilizing the graph database, obtaining a vehicle BOM resolving model according to the constructed BOM tree structures of all vehicle systems, putting the BOM resolving model into a distributed cache, and calling the BOM resolving model to distribute materials to the BOMs in the BOM tree structures when different production links of different vehicle systems are realized. The technical problem that data processing efficiency of BOM management of different material demands of multistage in the vehicle production process is low in the prior art is solved.

Description

Car system BOM structure data processing method for production material distribution
Technical Field
The invention relates to the technical field of data processing, in particular to a vehicle system BOM structure data processing method for production material distribution.
Background
The configuration system of vehicle production generally adopts a simple mode of brand + color + classification, cannot well respond to the change of a customized sales mode facing a client in the future in terms of management granularity, along with the aggravation of competition of manufacturing enterprises, the personalized configuration during vehicle sales is an industry trend, the future new energy vehicle type volume production can fully support a terminal client personalized menu, the target cost analysis, the vehicle trial production, the production plan, the purchase plan, the material purchase planning, the production receiving and completion warehousing of a volume production stage and the final delivery to the vehicle are required to be carried out, a closed-loop OTD (optical time domain reflectometry) mode is constructed, the fine management is realized, the super BOM center based on feature configuration is realized, and the BOM requirements in each production link are supported by analyzing the BOMs with different requirements.
Therefore, how to improve the data processing efficiency of the BOM management of the multi-stage different material requirements in the vehicle production process is a technical problem that needs to be solved urgently.
The above is only for the purpose of assisting understanding of the technical aspects of the present invention, and does not represent an admission that the above is prior art.
Disclosure of Invention
The invention mainly aims to provide a data processing method of a vehicle system BOM structure for distributing production materials, and aims to solve the technical problem that in the prior art, the data processing efficiency of BOM management of multi-stage different material requirements in the vehicle production process is low.
In order to achieve the above object, the present invention provides a vehicle system BOM structure data processing method for production material distribution, comprising the following steps:
the BOM center receives the vehicle system BOM structure data of the external system;
extracting material data and parent-child piece material relation data in the vehicle system BOM structure data;
converting the vehicle BOM structure data in the relational database into a graph database form and storing the graph database form in a graph database;
constructing BOM tree structures of all vehicle systems by using a graph database, and obtaining a BOM resolving model of the vehicle systems according to the BOM tree structures of all vehicle systems;
and (4) putting the BOM calculation model into a distributed cache, and calling the BOM calculation model to distribute materials of the BOM in the BOM tree structure when different production links of different vehicle systems are required.
Preferably, the BOM center receives the BOM structure data of the vehicle system in the whole production process through a BOM structure interface, a material interface, a characteristic interface, a material characteristic value interface, a process working hour interface, a product series interface, a work center interface and a BOM interface in a product planning stage, which are provided by an external system.
Preferably, the step of converting the vehicle BOM structure data into the graph database form comprises: and constructing a material data graph by taking the materials as points and the parent-child material relationship as edges according to the extracted material data and the parent-child material relationship data.
Preferably, building the material data graph includes initializing the material data graph: initializing a material data graph before production online.
Preferably, the building of the material data diagram further includes the initialized daily update of the material data diagram: and updating the material data graph in a fixed period after the production is on line.
Preferably, the BOM tree structure comprises a product planning stage BOM, a production-ready stage BOM, a pre-batch stage BOM and a production stage BOM; wherein:
the BOM in the product planning stage stores basic vehicle model code data and vehicle model specification number data in the product planning stage;
the BOM in the generation and preparation stage stores vehicle series data, basic vehicle model code data and vehicle model specification number data in the generation and preparation stage;
the BOM in the pre-batch stage stores the basic vehicle model code data, the vehicle model specification number data and the sales material data of a pre-batch order;
the production stage BOM stores pre-batch order train data and sales material data.
Preferably, obtaining the vehicle system BOM solution model includes initializing a BOM tree structure: and when the production is started, the organization of the tree structures of the BOMs of all the vehicle systems is completed, and all the BOMs of the vehicle systems are generated.
Preferably, the obtaining the vehicle system BOM solution model further includes changing the vehicle system BOM solution model after initialization: and in the production process, receiving the change data issued by the upstream BOM management system, and reconstructing a BOM calculation model for the train related to the change data.
According to the method, a BOM center receives vehicle BOM structure data of an external system, then material data and parent-child material relation data in the vehicle BOM structure data are extracted, the vehicle BOM structure data in a relational database are converted into a graph database form and stored in a graph database, finally, the graph database is used for building BOM tree structures of all vehicle systems, a vehicle BOM resolving model is obtained according to the built BOM tree structures of all vehicle systems, the BOM resolving model can be placed into a distributed cache, and the BOM resolving model is called to distribute materials for the BOMs in the BOM tree structures in different production links of different vehicle systems. The technical problem that data processing efficiency of BOM management of different material demands of multistage in the vehicle production process is low in the prior art is solved.
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, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the structures shown in the drawings without creative efforts.
FIG. 1 is a schematic diagram illustrating the steps of a method for processing vehicle BOM structure data for production material distribution according to the present invention.
The implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
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 technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The invention provides an embodiment, and referring to fig. 1, fig. 1 is a schematic diagram of a step principle of a production material distribution method based on vehicle system BOM tree structure analysis.
As shown in fig. 1, in the present embodiment, a production material distribution method based on vehicle BOM tree structure analysis constructs vehicle BOM structure data in the form of a graph database;
constructing BOM tree structures of all vehicle systems by using a graph database, obtaining a BOM resolving model of the vehicle systems according to the BOM tree structures of all vehicle systems, and putting the BOM resolving model into a distributed cache to be called;
calling a BOM resolving model to resolve the BOM tree structure in a corresponding production stage to obtain material information required by the production stage and all subordinate material information of the material;
and updating the structural data of the vehicle BOM according to the distribution of the production materials after the material information is obtained, and reconstructing a vehicle BOM calculation model.
In this embodiment, a specific implementation method for analyzing vehicle BOM in different stages is provided:
a: receiving BOM structure data:
the BOM center receives a BOM structure of an external system, and the BOM structure mainly comes from an FBOM system and a PD system; wherein the accept interface includes: BOM structure interface, material interface, characteristic interface, material characteristic value interface, working procedure man-hour interface, product series interface, work center interface and BOM interface in product planning stage.
B: establishing a BOM cache structure:
the BOM structure of the product is a gradually improved process, the product series is gradually refined along with the BOM, and the approximate process from the relational data to the graph database to the establishment of the cache is as follows:
(1) and converting the BOM structure data in the relational database into the shapes of points and edges and storing the shapes of the points and the edges in a graph database according to the principle that the material is a point and the parent and child material relationship is an edge. The work is divided into two parts of initialization and daily updating.
The initialization is conversion of the full amount of data, and takes a long time, but the time may be advanced before the system is on-line, so the time does not affect the solution service.
It should be noted that the daily update is performed in periodic increments, the period of which is customizable. For a whole vehicle enterprise, BOM locking is generally performed for at least one day, so that the service requirement can be met by setting the synchronization period to be an hour level.
(2) And (3) quickly constructing a BOM tree structure of the vehicle system by utilizing the professional and high-efficiency graph calculation capability of the graph database, further constructing a BOM calculation model of the vehicle system, and putting the BOM calculation model into a distributed cache. The work is divided into two parts of initialization and change refreshing.
It should be noted that, during initialization, when the system is started, all vehicle systems apply the distributed computing technology to map and call the service interface of the graph database in parallel, the organization of the tree structures of all vehicle system BOM is completed at one time and quickly, and further all vehicle system BOM solution models are formed and put into the distributed cache.
It should be noted that the change refreshing is to perform another construction of the BOM solution model on the related vehicle system based on the coverage of the change data when the BOM interface receives the BOM change data issued by the upstream BOM management system, and update the BOM solution model in the distributed cache after the construction is completed. The process is independent of BOM resolving service, so that the BOM resolving efficiency is not influenced.
In this embodiment, the product series of this step mainly has a quaternary structure composition, including: the system comprises a vehicle system, a basic vehicle type code, a vehicle type specification number and sales materials;
a: establishing BOM cache in a product planning stage:
the BOM in the product planning stage is built on the basis of the basic vehicle type code or the vehicle type specification number, so that the BOM with the basic vehicle type code or the vehicle type specification number can be analyzed, and the product planning BOM is the basis of product target cost analysis.
b: establishing a generation-oriented BOM cache:
the generation-ready BOM is a BOM structure built on the basis of a vehicle system, and the BOM in the generation-ready stage is divided into an early EBOM and a PBOM. Early EBOM uses BOM versions for management; PBOM uses time axis to manage; the standard BOM structure can analyze a basic vehicle type code BOM or a vehicle type specification number BOM; the raw standard BOM is the basis for product target cost analysis.
c: establishing a pre-batch BOM cache:
the pre-batch BOM is a BOM structure built on the basis of a vehicle system, and the BOM in the pre-batch stage can support trial production. The pre-batch BOM is managed using a timeline. In the pre-batch stage, the product series is refined to the number of the sales material, so that the BOM of the sales material can be analyzed. But the color pieces in the BOM structure still need to be refined.
When analyzing the BOM of the sales material, judging whether a color piece exists, if so, using the color piece; in the absence of a color piece, the unfolded BOM structure uses a native color piece. The component materials in the BOM line item can be managed by using the component materials and versions due to the fact that parameters such as specification and model can be adjusted in the trial-manufacture process and multiple versions can appear on the same material. The standard BOM structure can analyze basic vehicle type code BOM or vehicle type specification number BOM.
d: establishing production BOM cache
The production BOM is a BOM structure built on the basis of a vehicle system, and the BOM in the production stage can support the batch production of the whole vehicle; production BOMs are managed using a timeline. The product series in the production stage is complete, and when the BOM structure of the sales material is analyzed, all the standard matching characteristics and the matching characteristics are determined, so that the BOM structure of the sales material is completely accurate and is used for guiding production.
C: by means of a BOM analysis algorithm:
the distributed computing is implemented based on Spring Cloud microservice architecture concept. And packaging the micro-services needing distributed computation according to the principles of high cohesion and low coupling and the methodology of the AKF extension cube, and performing independent deployment. Under the environment with good network environment, the effect that the running time can be reduced by increasing resources can be achieved.
In addition, concurrent control parameters are set for each distributed computing microservice, and dynamic flexible adjustment can be performed, so that server resources are utilized to the maximum extent under the condition that server load is allowed.
In this embodiment, the BOM analysis specifically includes:
single-layer BOM deployment: according to the input material information, unfolding a BOM structure of the material directly below; the expansion logic is as follows: a. acquiring a sales material feature string and a corresponding configurable material; b. determining a train system according to the sales materials; c. and (3) unfolding the full-vehicle BOM according to the vehicle series, when the component is unfolded to a certain layer and is the configurable material, matching the variant material of the configurable material according to the characteristic string of the sales material to obtain the corresponding variant material, and continuously unfolding downwards.
And (3) multi-layer BOM expansion: and according to the input material information, gradually unfolding the BOM structure of the material until the final-stage material is unfolded.
BOM regression: and returning all sales materials using the component materials according to the component materials. When the component materials are changed, the vehicle type influenced by the current change can be inquired in an auxiliary mode.
Analyzing the order BOM: when the demand center uses the BOM, the demand center needs to return a component list used by a production line according to the specified production line. If the production line is from the solder line to the assembly line, then the entire BOM structure needs to be returned.
In the preferred implementation process, an algorithm for analyzing the vehicle BOM in different stages is provided, and the algorithm comprises the steps of establishing a product planning BOM expansion result model, a generation and standard BOM expansion result model and a pre-batch BOM/production BOM expansion result model.
Product planning BOM expansion result model
(a) BOM head table:
factory: a factory of product manufacture;
vehicle system: the system is used for dividing different brand series or different style vehicle type series, such as H5, H7, E115 and other series vehicle types; is the basis for super BOM maintenance;
vehicle type coding: subdividing the train, specific matching and matching characteristics (except for color characteristics) have been identified;
version number: the BOM in the planning stage is managed according to the version;
version date: the date corresponding to each version;
(b) BOM line item Table:
parent material: BOMs are managed in a hierarchy, and a parent material represents a root node of one hierarchy;
and (2) sub-materials: child materials represent leaf nodes of a hierarchy;
quantity: the quantity of the child materials needed to be used when manufacturing the single-quantity division parent material;
and (3) structural coding: the structure code is the foundation of the whole vehicle structure, and the whole vehicle mechanism is the foundation of target cost analysis;
function code: the first three segments of the structure code, e.g., 10.10.10.01, then the function code is 111;
position code: when a plurality of materials are distributed to the same structural code, the materials are sequenced through the position codes.
(II) generating quasi-BOM expansion result model
(a) material-BOM connection table:
BOM use: is 3 born standard BOM;
vehicle system: the system is used for dividing different brand series or different style vehicle type series, such as H5, H7, E115 and other series;
factory: a factory of product manufacture;
materials: a material having a BOM structure;
material list number: uniquely identifying a number of a BOM structure;
(b) BOM line item Table:
material list number: primary keys connected to other tables;
and (2) sub-materials: allocating the sub-material number under the current material single number;
quantity: the quantity of the child materials needed to be used when manufacturing the single-quantity division parent material;
measurement unit: measuring units of the child materials;
and (3) structural coding: the structure code is the foundation of the whole vehicle structure, and the whole vehicle mechanism is the foundation of target cost analysis;
function code: the first three segments of the structure code, e.g., 10.10.10.01, then the function code is 111;
position code: when a plurality of materials are distributed to the same structural code, sequencing the materials through the position codes;
BOM type: when the BOM type is EBOM, the BOM uses the version to manage;
when the BOM type is PBOM, the BOM uses a time axis for management;
version: version date when EBOM is managed.
(III) Pre-batch/production BOM expansion result model
(a) material-BOM connection table:
BOM use: pre-batching: 2; and (3) producing BOM: 1
Vehicle system: for dividing different brand series or different style vehicle type series, e.g. H5, H7, E115 series
Factory: plant for the manufacture of products
Materials: material with BOM structure
Material list number: number uniquely identifying a BOM structure
(b) BOM line item Table:
material list number: primary keys connected to other tables;
and (2) sub-materials: allocating the sub-material number under the current material single number;
quantity: the quantity of the child materials needed to be used when manufacturing the single-quantity division parent material;
configuring an expression: the configuration expression is the basis of BOM analysis, and the BOM expansion result is determined by matching the characteristic string of the sales material with the characteristics in the logic expression of the BOM row item;
body-in-white marking: identifying that the BOM line item is an instantiation of body-in-white material;
body-in-white dummy: marking the material number of the body-in-white virtual part corresponding to the BOM row item; the body-in-white virtual part material is provided with a super BOM, when the sales material BOM is unfolded, the corresponding body-in-white instantiation part needs to be matched according to the characteristic string of the sales material, and the body-in-white BOM structure is analyzed in the body-in-white virtual part BOM structure according to the characteristic string of the body-in-white instantiation part;
valid start date: when the BOM structure is managed by using a time axis, the effective starting time marks the effective time of the data;
effective expiration date: when the BOM structure is managed by using a time axis, the effective starting time marks the failure time of the data;
and (3) sub-part version: when the BOM is a pre-batch BOM, the sub-materials manage the change of the sub-materials through versions; when BOM is produced, if the sub-material is changed, the change is managed by changing the material number.
In the embodiment, vehicle BOM structure data in a graph database form is constructed, BOM tree structures of all vehicle systems are constructed by utilizing the graph database, a vehicle BOM resolving model is obtained according to the constructed BOM tree structures of all the vehicle systems, the BOM resolving model is placed into distributed cache to be called, the BOM resolving model is called in a corresponding production stage to resolve the BOM tree structures, material information required by the production stage and all lower-level material information of the material are obtained, and finally, the vehicle BOM structure data are updated according to production material distribution after the material information is obtained, and the vehicle BOM resolving model is reconstructed. The technical problem that BOM management of different material demands of multiple stages in the vehicle production process is not accurate and complete in the prior art is solved.
The methods, systems, and modules disclosed herein may be implemented in other ways. For example, the above-described embodiments are merely illustrative, and for example, the division of the modules may be merely a logical division, and an actual implementation may have another division, for example, a plurality of modules or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be referred to as an indirect coupling or communication connection through some interfaces, systems or modules, and may be in an electrical, mechanical or other form.
The modules described as discrete components may or may not be physically separate, and the components shown as modules may or may not be physical modules, may be located in one place, or may be distributed over a plurality of network modules. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional modules in the embodiments of the present invention may be integrated into one processing module, or each of the modules may exist alone physically, or two or more modules are integrated into one module.
The functions, if implemented in the form of software functional modules and sold or used as a stand-alone product, may be stored in a computer-readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, an optical disk, or other various media capable of storing program codes.
The foregoing is illustrative of the preferred embodiments of this invention, and it is to be understood that the invention is not limited to the precise form disclosed herein and that various other combinations, modifications, and environments may be resorted to, falling within the scope of the concept as disclosed herein, either as described above or as apparent to those skilled in the relevant art. And that modifications and variations may be effected by those skilled in the art without departing from the spirit and scope of the invention as defined by the appended claims.

Claims (8)

1. A vehicle BOM structure data processing method for production material distribution is characterized by comprising the following steps:
the BOM center receives the vehicle system BOM structure data of the external system;
extracting material data and parent-child piece material relation data in the vehicle system BOM structure data;
converting the vehicle BOM structure data in the relational database into a graph database form and storing the graph database form in a graph database;
constructing BOM tree structures of all vehicle systems by using a graph database, and obtaining a BOM resolving model of the vehicle systems according to the BOM tree structures of all vehicle systems;
and (4) putting the BOM calculation model into a distributed cache, and calling the BOM calculation model to distribute materials of the BOM in the BOM tree structure when different production links of different vehicle systems are required.
2. The method as claimed in claim 1, wherein the BOM center receives the BOM structure data of the whole production process through a BOM structure interface, a material interface, a property interface, a material property value interface, a process time interface, a product series interface, a work center interface and a BOM interface of a product planning stage provided by an external system.
3. The method for processing vehicle BOM structure data for production material distribution according to claim 1, wherein the step of converting the vehicle BOM structure data into the form of a graph database comprises the following steps: and constructing a material data graph by taking the materials as points and the parent-child material relationship as edges according to the extracted material data and the parent-child material relationship data.
4. The method of processing fleet BOM structure data for production material distribution according to claim 3, wherein said building a material data graph comprises material data graph initialization: initializing a material data graph before production online.
5. The method of processing vehicle BOM structure data for production material distribution of claim 4, wherein said building a material data graph further comprises a daily update of the initialized material data graph: and updating the material data graph in a fixed period after the production is on line.
6. The method of processing vehicle BOM structure data for production material distribution of claim 1, wherein the BOM tree structure comprises a product plan phase BOM, a production phase BOM, a pre-batch phase BOM, and a production phase BOM; wherein:
the BOM in the product planning stage stores basic vehicle model code data and vehicle model specification number data in the product planning stage;
the BOM in the generation and preparation stage stores vehicle series data, basic vehicle model code data and vehicle model specification number data in the generation and preparation stage;
the BOM in the pre-batch stage stores the basic vehicle model code data, the vehicle model specification number data and the sales material data of a pre-batch order;
the production stage BOM stores pre-batch order train data and sales material data.
7. The method of processing vehicle BOM structure data for production material distribution of claim 1, wherein the obtaining a vehicle BOM solution model comprises a BOM tree structure initialization: and when the production is started, the organization of the tree structures of the BOMs of all the vehicle systems is completed, and all the BOMs of the vehicle systems are generated.
8. The method of processing vehicle BOM structure data for production material distribution of claim 7, wherein obtaining the vehicle BOM solution model further comprises, after initialization, changing the vehicle BOM solution model: and in the production process, receiving the change data issued by the upstream BOM management system, and reconstructing a BOM calculation model for the train related to the change data.
CN202110127700.7A 2021-01-29 2021-01-29 Car system BOM structure data processing method for production material distribution Pending CN112651693A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110127700.7A CN112651693A (en) 2021-01-29 2021-01-29 Car system BOM structure data processing method for production material distribution

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110127700.7A CN112651693A (en) 2021-01-29 2021-01-29 Car system BOM structure data processing method for production material distribution

Publications (1)

Publication Number Publication Date
CN112651693A true CN112651693A (en) 2021-04-13

Family

ID=75370845

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110127700.7A Pending CN112651693A (en) 2021-01-29 2021-01-29 Car system BOM structure data processing method for production material distribution

Country Status (1)

Country Link
CN (1) CN112651693A (en)

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113408052A (en) * 2021-06-17 2021-09-17 江南造船(集团)有限责任公司 Ship production preparation method, system, medium and terminal based on three-dimensional ship model
CN113420380A (en) * 2021-06-30 2021-09-21 一汽奔腾轿车有限公司 Method for building super whole vehicle DMU data tree and analyzing single vehicle DMU data
CN113742423A (en) * 2021-08-23 2021-12-03 东风柳州汽车有限公司 Vehicle type BOM data processing method and device and storage medium
CN115034808A (en) * 2022-05-17 2022-09-09 启明信息技术股份有限公司 Target cost control method based on complete vehicle BOM structure

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101364288A (en) * 2008-09-03 2009-02-11 于万钦 Method for constructing BOM container based on SOA architecture
KR20100081444A (en) * 2009-01-06 2010-07-15 주식회사 영림원소프트랩 Method for material requirements decision using modulation bom
CN108876244A (en) * 2018-06-22 2018-11-23 珠海格力电器股份有限公司 A kind of the storage inquiry system and method for bill of materials BOM
CN110659866A (en) * 2019-04-15 2020-01-07 南京依维柯汽车有限公司 Method for releasing BOM from PDM system to ERP system

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101364288A (en) * 2008-09-03 2009-02-11 于万钦 Method for constructing BOM container based on SOA architecture
KR20100081444A (en) * 2009-01-06 2010-07-15 주식회사 영림원소프트랩 Method for material requirements decision using modulation bom
CN108876244A (en) * 2018-06-22 2018-11-23 珠海格力电器股份有限公司 A kind of the storage inquiry system and method for bill of materials BOM
CN110659866A (en) * 2019-04-15 2020-01-07 南京依维柯汽车有限公司 Method for releasing BOM from PDM system to ERP system

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
郑永前 等: "面向轿车白车身生产过程中的BOM多视图研究", 《企业信息化》, pages 15 - 16 *

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113408052A (en) * 2021-06-17 2021-09-17 江南造船(集团)有限责任公司 Ship production preparation method, system, medium and terminal based on three-dimensional ship model
CN113420380A (en) * 2021-06-30 2021-09-21 一汽奔腾轿车有限公司 Method for building super whole vehicle DMU data tree and analyzing single vehicle DMU data
CN113742423A (en) * 2021-08-23 2021-12-03 东风柳州汽车有限公司 Vehicle type BOM data processing method and device and storage medium
CN113742423B (en) * 2021-08-23 2023-09-19 东风柳州汽车有限公司 Vehicle type BOM data processing method and device and storage medium
CN115034808A (en) * 2022-05-17 2022-09-09 启明信息技术股份有限公司 Target cost control method based on complete vehicle BOM structure

Similar Documents

Publication Publication Date Title
CN112651692A (en) Production material distribution method based on vehicle BOM tree structure analysis
CN112651693A (en) Car system BOM structure data processing method for production material distribution
CN108647914B (en) Production scheduling method and device, computer equipment and storage medium
US10740773B2 (en) Systems and methods of utilizing multiple forecast models in forecasting customer demands for products at retail facilities
CN108388445A (en) One kind being based on the continuous integrating method of " platform+application " pattern
JP2002505987A (en) How computerized supply chain planning works.
CN102117306A (en) Method and system for monitoring ETL (extract-transform-load) data processing process
CN106991183A (en) A kind of business intelligence ETL method for packing and system
CN102004954A (en) Product information system and information integration method of product design system
CN105320504A (en) Visual software modeling method for constructing software view on basis of software meta view
CN111552728B (en) Data processing method, system, terminal and storage medium of block chain
CN110347056A (en) Shop-floor management platform and emulation mode
CN104850583A (en) Distributed collaborative analysis system and method of massive climate pattern model output data
CN110941251A (en) Production control method, device, equipment and medium based on digital twin body
CN110852559A (en) Resource allocation method and device, storage medium and electronic device
CN110737432B (en) Script aided design method and device based on root list
CN105824991B (en) A kind of cloud platform and resource allocation method of the design of Aviation applicating cooperation
CN101561899A (en) MBOM increasingly receiving method with integration of design, production and management
CN106056435A (en) Design model sharing system in cloud manufacturing environment
CN111401632B (en) Weather forecast method and related device
CN112700213A (en) Networking industrial design platform
CN114270282A (en) System for generating an integral digital twin
CN111191180A (en) Method and device for constructing micro-service system in invoice field and storage medium
CN109800486A (en) A kind of cloud platform implementation method of the motor industrial chain map based on manufacturing process
CN110262973B (en) Data maintenance method, device, equipment and computer storage medium

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