CN114066376A - BOM difference analysis method, storage medium, equipment and device - Google Patents
BOM difference analysis method, storage medium, equipment and device Download PDFInfo
- Publication number
- CN114066376A CN114066376A CN202210047561.1A CN202210047561A CN114066376A CN 114066376 A CN114066376 A CN 114066376A CN 202210047561 A CN202210047561 A CN 202210047561A CN 114066376 A CN114066376 A CN 114066376A
- Authority
- CN
- China
- Prior art keywords
- difference
- dbom
- ebom
- analyzed
- bom
- 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
- 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
-
- 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
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/04—Manufacturing
-
- 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
Abstract
The application relates to a BOM difference analysis method, a storage medium, equipment and a device, which relate to the technical field of finished automobile manufacturing, and the method comprises the following steps: downloading the EBOM and the DBOM corresponding to the target vehicle type; in the EBOM and the DBOM respectively, aiming at the parts which are repeatedly used, the original multi-line display mode is replaced by a quantity statistical mode; performing initial consistent processing on the EBOM and the DBOM to enable the types of parts included in the EBOM and the DBOM to be the same; and traversing the EBOM and the DBOM based on the preset hierarchical structure identification field and the difference attribute to be analyzed, and identifying to obtain difference data. According to the method and the device, the EBOM and the DBOM are traversed on the basis of the to-be-analyzed difference attributes set by matching of the part hierarchical structure, the difference situation of the EBOM and the DBOM in different difference analysis angles is mastered, and the working efficiency is greatly improved on the premise that the difference analysis is guaranteed to be comprehensive and reliable as much as possible.
Description
Technical Field
The application relates to the technical field of vehicle manufacturing, in particular to a BOM difference analysis method, a storage medium, a device and an apparatus.
Background
In manufacturing industry, especially whole vehicle manufacturing industry, the BOM is an important output in the product development process, generally, the product development will form DBOM and EBOM, and will be continuously updated iteratively in the development process, and the BOM data is referred by many departments and systems, so the accuracy of the BOM data itself, and the consistency between DBOM and EBOM is very important.
Meanwhile, due to the fact that the whole vehicle is complex in structure and large in number of parts, the difference of ten thousand rows of the whole vehicle is analyzed through manual comparison, meanwhile, a plurality of attribute differences of corresponding parts need to be compared, a great deal of energy is consumed, efficiency is low, and accuracy cannot be completely guaranteed.
Therefore, in order to meet the above requirements, a new BOM variance analysis technique is now provided to solve the above problems.
Disclosure of Invention
The application provides a BOM difference analysis method, a storage medium, a device and a device, which are used for traversing EBOM and DBOM based on the difference attributes to be analyzed set by matching a part hierarchical structure, mastering the difference conditions of the EBOM and the DBOM in different difference analysis angles and greatly improving the working efficiency on the premise of ensuring that the difference analysis is as comprehensive and reliable as possible.
In a first aspect, the present application provides a BOM difference analysis method, comprising the steps of:
downloading the EBOM and the DBOM corresponding to the target vehicle type;
in the EBOM and the DBOM respectively, aiming at the repeatedly used parts, replacing the original multi-line display mode by using a quantity statistical mode;
performing initial consistent processing on the EBOM and the DBOM, so that the EBOM and the DBOM comprise the same part types;
traversing the EBOM and the DBOM based on a preset hierarchical structure identification field and a difference attribute to be analyzed, and identifying to obtain difference data; wherein the content of the first and second substances,
the hierarchical structure identification field is a part number and a corresponding parent-level part number;
the difference data comprises a plurality of parts which exist in the EBOM and the DBOM, have the same part numbers and the corresponding parent-level part numbers and have different attribute parameters of the different attributes to be analyzed.
Specifically, the step of traversing the EBOM and the DBOM based on the preset hierarchical structure identification field and the to-be-analyzed difference attribute and obtaining the difference data based on the identification includes the following steps:
traversing the EBOM and the DBOM based on a preset hierarchical structure identification field and different to-be-analyzed difference attributes, and identifying to obtain difference data and coexistence data corresponding to the to-be-analyzed difference attributes;
and performing multiple difference analyses by combining a preset hierarchical structure identification field and different to-be-analyzed difference attributes based on the different coexisting data to obtain the difference data combined according to the different to-be-analyzed difference attributes.
Further, the method comprises the following steps:
and performing cross traversal on the EBOM and the DBOM based on the part numbers in the EBOM and the DBOM to obtain part difference data between the EBOM and the DBOM.
Further, the method comprises the following steps:
and performing cross traversal on the EBOM and the DBOM based on a hierarchical structure identification field to obtain structure difference data between the EBOM and the DBOM.
Further, after obtaining the structural difference data between the EBOM and the DBOM, the method further comprises the following steps:
and analyzing and obtaining the unique EBOM structure or the unique DBOM structure based on the structural difference data between the EBOM and the DBOM.
Further, the method comprises the following steps:
traversing the EBOM and the DBOM based on a preset hierarchical structure identification field and a first to-be-analyzed difference attribute, and identifying and obtaining difference data corresponding to the first to-be-analyzed difference attribute;
and traversing the difference data corresponding to the first to-be-analyzed difference attribute based on the second to-be-analyzed difference attribute, and analyzing the difference condition corresponding to each part in the difference data corresponding to the first to-be-analyzed difference attribute.
Further, the method comprises the following steps:
and constructing a corresponding difference data table based on the difference data.
In a second aspect, the present application provides a storage medium having stored thereon a computer program which, when executed by a processor, implements the steps of the BOM difference analysis method mentioned in the first aspect above.
In a third aspect, the present application provides an apparatus, which includes a memory, a processor, and a computer program stored in the memory and running on the processor, and the processor implements the steps of the BOM difference analysis method mentioned in the first aspect when executing the computer program.
In a fourth aspect, the present application provides a BOM variance analysis apparatus, comprising:
the BOM downloading module is used for downloading the EBOM and the DBOM corresponding to the target vehicle type;
the BOM preprocessing module is used for replacing the original multi-line display mode by using a quantity statistical mode aiming at the repeatedly used parts in the EBOM and the DBOM respectively;
the BIM consistent processing module is used for carrying out initial consistent processing on the EBOM and the DBOM, so that the EBOM and the DBOM comprise the same part type;
the difference identification module is used for traversing the EBOM and the DBOM based on a preset hierarchical structure identification field and a difference attribute to be analyzed, and identifying and obtaining difference data; wherein the content of the first and second substances,
the hierarchical structure identification field is a part number and a corresponding parent-level part number;
the difference data comprises a plurality of parts which exist in the EBOM and the DBOM, have the same part numbers and the corresponding parent-level part numbers and have different attribute parameters of the different attributes to be analyzed.
The beneficial effect that technical scheme that this application provided brought includes:
according to the method and the device, the EBOM and the DBOM are preprocessed firstly to avoid interference of formats and special part types on difference analysis, and then the EBOM and the DBOM are traversed based on the to-be-analyzed difference attributes set by matching of the part hierarchical structures, so that the difference conditions of the EBOM and the DBOM in different difference analysis angles are mastered, and the working efficiency is greatly improved on the premise that the difference analysis is guaranteed to be comprehensive and reliable as much as possible.
Drawings
Interpretation of terms:
BOM: bill of Materials, Bill of Materials;
EBOM: engineering Bill of Materials, Engineering Bill of Materials;
DBOM: designing Bill of Materials, and designing a material list;
PDM: product Data Management, Product Data Management.
In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings needed to be used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present application, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
FIG. 1 is a flow chart of the steps of a BOM difference analysis method provided in the embodiments of the present application;
FIG. 2 is a schematic flow chart of a BOM difference analysis method provided in an embodiment of the present application;
FIG. 3 is a schematic diagram of difference identifiers in a BOM difference analysis method provided in the embodiments of the present application;
FIG. 4 is a schematic diagram of positioning of difference points in a difference data table in the BOM difference analysis method provided in the embodiment of the present application;
fig. 5 is a block diagram of a structure of a BOM difference analysis device provided in the embodiment of the present application.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are some embodiments of the present application, but not all 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 application.
Embodiments of the present application will be described in further detail below with reference to the accompanying drawings.
The embodiment of the application provides a BOM difference analysis method, a storage medium, a device and a device, which are used for traversing EBOM and DBOM based on the difference attributes to be analyzed set by matching a part hierarchical structure, mastering the difference conditions of the EBOM and the DBOM in different difference analysis angles, and greatly improving the working efficiency on the premise of ensuring that the difference analysis is as comprehensive and reliable as possible.
In order to achieve the technical effects, the general idea of the application is as follows:
a BOM difference analysis method comprises the following steps:
s1, downloading the EBOM and the DBOM corresponding to the target vehicle type;
s2, replacing the original multi-line display mode by a quantity statistical mode aiming at the parts which are repeatedly used in the EBOM and the DBOM respectively;
s3, performing initial consistency processing on the EBOM and the DBOM to enable the types of parts included in the EBOM and the DBOM to be the same;
s4, traversing the EBOM and the DBOM based on the preset hierarchical structure identification field and the difference attribute to be analyzed, and identifying to obtain difference data; wherein the content of the first and second substances,
the hierarchical structure identification field is a part number and a corresponding parent-level part number;
the difference data comprises a plurality of parts which exist in both the EBOM and the DBOM, have the same part number and the corresponding parent-level part number and have different attribute parameters of the to-be-analyzed difference attributes.
Embodiments of the present application will be described in further detail below with reference to the accompanying drawings.
In a first aspect, referring to fig. 1 to 4, an embodiment of the present application provides a BOM difference analysis method, including the following steps:
s1, downloading the EBOM and the DBOM corresponding to the target vehicle type;
s2, replacing the original multi-line display mode by a quantity statistical mode aiming at the parts which are repeatedly used in the EBOM and the DBOM respectively;
s3, performing initial consistency processing on the EBOM and the DBOM to enable the types of parts included in the EBOM and the DBOM to be the same;
s4, traversing the EBOM and the DBOM based on the preset hierarchical structure identification field and the difference attribute to be analyzed, and identifying to obtain difference data; wherein the content of the first and second substances,
the hierarchical structure identification field is a part number and a corresponding parent-level part number;
the difference data comprises a plurality of parts which exist in both the EBOM and the DBOM, have the same part number and the corresponding parent-level part number and have different attribute parameters of the to-be-analyzed difference attributes.
In step S2, since the general PDM system has multiple rows of reusable parts displaying manners for the original EBOM and/or DBOM, the number of actually used parts of the BOM needs to be accumulated so as to compare the difference of the number of used parts quickly;
in step S3, since the original EBOM usually contains color elements but the original DBOM does not, and the original DBOM contains deformation elements but the original EBOM does not, the BOM data is subjected to a consistency process, and the differences should not belong to the difference range, so that an initial consistency process is required.
In the embodiment of the application, the EBOM and the DBOM are preprocessed to avoid interference of formats and specific part types on difference analysis, and then the EBOM and the DBOM are traversed based on the to-be-analyzed difference attributes set by matching of the part hierarchical structure, so that the difference conditions of the EBOM and the DBOM in different difference analysis angles are mastered, and the working efficiency is greatly improved on the premise of ensuring that the difference analysis is as comprehensive and reliable as possible.
Specifically, the step of traversing the EBOM and the DBOM based on the preset hierarchical structure identification field and the to-be-analyzed difference attribute and obtaining the difference data based on the identification includes the following steps:
traversing the EBOM and the DBOM based on a preset hierarchical structure identification field and different to-be-analyzed difference attributes, and identifying to obtain difference data and coexistence data corresponding to the to-be-analyzed difference attributes;
and performing multiple difference analyses by combining a preset hierarchical structure identification field and different to-be-analyzed difference attributes based on the different coexisting data to obtain the difference data combined according to the different to-be-analyzed difference attributes.
It should be noted that, when the operation is specifically implemented, a hierarchical Structure identification field "Structure", namely "part + parent part" id, may be specifically established based on the "minimum binary Structure", and all structural differences may be identified through comprehensive traversal, comparing attribute differences corresponding to parts whose ids are the same for the part and the parent part;
and (3) identifying id and the attribute of the difference to be analyzed by combining the minimum binary structure, assuming that the difference between the number and the configuration variable needs to be analyzed, establishing a difference identification field IDX, and identifying all existing difference points by the IDX.
Further, the BOM difference analysis method further comprises the following steps:
and performing cross traversal on the EBOM and the DBOM based on the part numbers in the EBOM and the DBOM to obtain part difference data between the EBOM and the DBOM.
Further, the BOM difference analysis method further comprises the following steps:
based on a hierarchical structure identification field, performing cross traversal on the EBOM and the DBOM to obtain structure difference data between the EBOM and the DBOM;
through cross traversal, the structural difference data between the EBOM and the DBOM can be comprehensively mastered.
Further, after obtaining the structural difference data between the EBOM and the DBOM, the BOM difference analysis method further includes the following steps:
and analyzing and obtaining the unique EBOM structure or the unique DBOM structure based on the structural difference data between the EBOM and the DBOM.
Further, the BOM difference analysis method further comprises the following steps:
traversing the EBOM and the DBOM based on a preset hierarchical structure identification field and a first to-be-analyzed difference attribute, and identifying and obtaining difference data corresponding to the first to-be-analyzed difference attribute;
and traversing the difference data corresponding to the first to-be-analyzed difference attribute based on the second to-be-analyzed difference attribute, and analyzing the difference condition corresponding to each part in the difference data corresponding to the first to-be-analyzed difference attribute.
Through the operation, different differential attributes can be identified layer by layer, after differential data corresponding to the first to-be-analyzed differential attribute is identified and obtained, differential identification is performed by traversing the differential data corresponding to the first to-be-analyzed differential attribute based on the second to-be-analyzed differential attribute, and whether a difference still exists for the second to-be-analyzed differential attribute can be known on the basis that the first to-be-analyzed differential attribute has a difference;
by analogy, different to-be-analyzed difference attributes can be selected for traversal, and corresponding difference identification is carried out.
Further, the BOM difference analysis method further comprises the following steps:
and constructing a corresponding difference data table based on the difference data.
According to the technical scheme of the embodiment of the application, the method comprises the following operation flows in specific implementation:
the invention is realized by the following steps: a method for analyzing BOM difference in high performance comprises the following steps:
the method comprises the steps of firstly, simultaneously downloading an EBOM and a DBOM which a vehicle type belongs to;
it should be noted that the attributes of the fields to be analyzed in the EBOM and DBOM are consistent.
Secondly, performing structure integration, and replacing an original multi-line display mode by using a quantity statistical mode aiming at the repeatedly used parts in the EBOM and the DBOM respectively;
since the general PDM system has a plurality of lines of display modes for the reused parts of the original EBOM and/or DBOM, the actual use quantity of the reused parts of the BOM is accumulated so as to quickly compare the difference of the use quantity of the parts.
Thirdly, performing initial consistent processing on the EBOM and the DBOM to enable the types of parts included in the EBOM and the DBOM to be the same;
specifically, one copy of data information corresponding to the unique part type in the EBOM is copied in the DBOM, and similarly, one copy of data information corresponding to the unique part type in the DBOM is copied in the EBOM, so that the unique part types of the EBOM and the DBOM exist in both the EBOM and the DBOM;
since the original EBOM usually contains color elements and the original DBOM does not contain color elements, and the original DBOM contains deformation elements and the original EBOM does not contain deformation elements, the consistency processing is performed on the BOM data only existing in the EBOM or the DBOM, and since the data does not belong to the difference range, the processing can avoid influencing the result of the difference analysis.
And fourthly, establishing a hierarchical Structure identification field Structure based on the minimum binary Structure, namely a part and a parent part id, and identifying all structural differences through comprehensive traversal, wherein the attribute differences corresponding to the parts with the same id corresponding to the comparison part and the parent part are compared.
And fifthly, identifying id and the attribute of the difference to be analyzed by combining the minimum binary structure, assuming that the difference between the number and the configuration variable needs to be analyzed, establishing a difference identification field IDX, and identifying all the existing difference points through the IDX.
Sixthly, reading the EBOM data and the DBOM data into a memory, recording the EBOM data as a set A, and recording the DBOM data as a set B;
generating a difference identification field 'C-IDX' by using an 'IDX' field through cross traversal operation; wherein the content of the first and second substances,
1 represents no difference in the analysis result, and subsequent analysis is not carried out;
the analysis result is 0 representing the difference, and the difference point analysis is continued.
Seventhly, performing cross traversal operation on the part number to identify a newly added/deleted part and generate a difference identification field 'C-PN';
wherein, the analysis result is 1, which represents no difference and does not need to be analyzed subsequently;
the analysis result is 0 representing the difference, and the difference is 'addition/deletion', and is directly marked as the result, and the analysis based on the difference point is not continued.
Eighthly, performing cross traversal operation by using the hierarchical Structure identification field 'Structure', identifying the structural difference of 'part + parent part', generating a difference identification field 'C-Structure',
the analysis result is 1, which represents no difference, and subsequent analysis is not performed any more;
the analysis result is 0 representing the difference, and the difference is 'EBOM unique structure/DBOM unique structure', the result is directly marked, and the difference point analysis is not continued.
Ninthly, combining the attributes except the attributes to be analyzed with the Structure identification field Structure according to the attributes to be analyzed, for example, if the attributes to be analyzed are the number, excluding the attributes, and combining the other attributes (for example, configuration variables) to be analyzed with the Structure identification field Structure;
by the technical scheme, whether only the number difference of the attributes to be analyzed is determined, and a difference identification field C-Qty is generated; wherein the content of the first and second substances,
the analysis result is represented as 1 without difference, and subsequent analysis is not carried out;
the analysis result represents a difference with 0, the difference result is marked as Diff Qty, and the subsequent difference analysis is continued.
Tenth, then, removing the 'configuration variables' of the attributes to be analyzed, combining the other attributes to be analyzed with the Structure identification field 'Structure', and generating a difference identification field 'C-Variant'; also, in the same manner as above,
the analysis result is represented as 1 without difference, and subsequent analysis is not carried out;
the analysis result represented a difference of 0, and the difference result "Diff Var" was added "
And step ten, respectively storing the analysis results obtained in the steps six to tenth in an EBOM set A and a DBOM set B.
And step ten, merging the difference data independently stored in the set A and the set B into an independent table, recording the table as a difference data table, sorting the table according to a Structure identification field 'Structure', and then adding a positioning algorithm with the same value of the 'Structure' field so as to quickly position the difference points.
Therefore, according to the technical scheme of the embodiment of the application, BOM analysis is carried out based on a minimum binary structure, a unique identification id is established for an object in the BOM, difference comparison between the EBOM and the DBOM is carried out, an EBOM/DBOM difference list of the whole vehicle level is output, a difference point visualization rapid positioning technology is provided, and BOM difference analysis performance and convenience are obviously improved;
in addition, the technical scheme has strong expansibility and low coupling with the data to be analyzed, and can be applied to BOM data analysis of various types of enterprises through small-degree adaptive adjustment.
In a second aspect, an embodiment of the present application provides a storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the steps of the BOM difference analysis method mentioned in the first aspect above.
In a third aspect, an embodiment of the present application provides an apparatus, where the apparatus includes a memory, a processor, and a computer program stored on the memory and running on the processor, and the processor, when executing the computer program, implements the steps of the BOM difference analysis method mentioned in the first aspect above.
In a fourth aspect, referring to fig. 5, an embodiment of the present application provides a BOM difference analysis device, including:
the BOM downloading module is used for downloading the EBOM and the DBOM corresponding to the target vehicle type;
the BOM preprocessing module is used for replacing the original multi-line display mode by using a quantity statistical mode aiming at the repeatedly used parts in the EBOM and the DBOM respectively;
the BIM consistent processing module is used for carrying out initial consistent processing on the EBOM and the DBOM, so that the EBOM and the DBOM comprise the same part type;
the difference identification module is used for traversing the EBOM and the DBOM based on a preset hierarchical structure identification field and a difference attribute to be analyzed, and identifying and obtaining difference data; wherein the content of the first and second substances,
the hierarchical structure identification field is a part number and a corresponding parent-level part number;
the difference data comprises a plurality of parts which exist in the EBOM and the DBOM, have the same part numbers and the corresponding parent-level part numbers and have different attribute parameters of the different attributes to be analyzed.
It should be noted that, because the general PDM system has multiple rows of display modes for the reusable parts of the original EBOM and/or DBOM, the number of the reusable parts of the BOM needs to be accumulated, so as to compare the difference of the number of the reusable parts quickly;
since the original EBOM usually contains color elements but not the original DBOM, and the original DBOM contains deformation elements but not the original EBOM, the consistency processing is performed on such BOM data, and such differences should not belong to the difference range, so the initial consistency processing is required.
In the embodiment of the application, the EBOM and the DBOM are preprocessed to avoid interference of formats and specific part types on difference analysis, and then the EBOM and the DBOM are traversed based on the to-be-analyzed difference attributes set by matching of the part hierarchical structure, so that the difference conditions of the EBOM and the DBOM in different difference analysis angles are mastered, and the working efficiency is greatly improved on the premise of ensuring that the difference analysis is as comprehensive and reliable as possible.
Further, the difference identification module is further configured to traverse the EBOM and the DBOM based on a preset hierarchical structure identification field and different to-be-analyzed difference attributes, and identify and obtain difference data and coexistence data corresponding to the to-be-analyzed difference attributes;
the difference identification module is further used for performing multiple difference analyses by combining a preset hierarchical structure identification field and different to-be-analyzed difference attributes based on the different coexisting data to obtain the difference data combined according to the different to-be-analyzed difference attributes.
Further, the difference identification module is also used for performing cross traversal on the EBOM and the DBOM based on the part numbers in the EBOM and the DBOM to obtain part difference data between the EBOM and the DBOM.
Further, the difference identification module is further configured to perform cross traversal on the EBOM and the DBOM based on a hierarchical structure identification field to obtain the structural difference data between the EBOM and the DBOM.
Further, the difference identification module is further configured to, after obtaining the structural difference data between the EBOM and the DBOM, analyze and obtain the EBOM unique structure or the DBOM unique structure based on the structural difference data between the EBOM and the DBOM.
Further, the difference identification module is further configured to traverse the EBOM and the DBOM based on a preset hierarchical structure identification field and a first to-be-analyzed difference attribute, and identify and obtain difference data corresponding to the first to-be-analyzed difference attribute;
and traversing the difference data corresponding to the first to-be-analyzed difference attribute based on the second to-be-analyzed difference attribute, and analyzing the difference condition corresponding to each part in the difference data corresponding to the first to-be-analyzed difference attribute.
Further, the apparatus includes a table statistics module for constructing a corresponding table of difference data based on the difference data.
It is noted that, in the present application, relational terms such as "first" and "second", and the like, are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
The foregoing are merely exemplary embodiments of the present application and are presented to enable those skilled in the art to understand and practice the present application. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the application. Thus, the present application is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims (10)
1. A BOM difference analysis method is characterized by comprising the following steps:
downloading the EBOM and the DBOM corresponding to the target vehicle type;
in the EBOM and the DBOM respectively, aiming at the repeatedly used parts, replacing the original multi-line display mode by using a quantity statistical mode;
performing initial consistent processing on the EBOM and the DBOM, so that the EBOM and the DBOM comprise the same part types;
traversing the EBOM and the DBOM based on a preset hierarchical structure identification field and a difference attribute to be analyzed, and identifying to obtain difference data; wherein the content of the first and second substances,
the hierarchical structure identification field is a part number and a corresponding parent-level part number;
the difference data comprises a plurality of parts which exist in the EBOM and the DBOM, have the same part numbers and the corresponding parent-level part numbers and have different attribute parameters of the different attributes to be analyzed.
2. The BOM difference analysis method according to claim 1, wherein the step of traversing the EBOM and the DBOM based on the preset hierarchical structure identification field and the difference attribute to be analyzed and obtaining the difference data based on the identification comprises the following steps:
traversing the EBOM and the DBOM based on a preset hierarchical structure identification field and different to-be-analyzed difference attributes, and identifying to obtain difference data and coexistence data corresponding to the to-be-analyzed difference attributes;
and performing multiple difference analyses by combining a preset hierarchical structure identification field and different to-be-analyzed difference attributes based on the different coexisting data to obtain the difference data combined according to the different to-be-analyzed difference attributes.
3. The BOM difference analysis method of claim 1, further comprising the steps of:
and performing cross traversal on the EBOM and the DBOM based on the part numbers in the EBOM and the DBOM to obtain part difference data between the EBOM and the DBOM.
4. The BOM difference analysis method of claim 1, further comprising the steps of:
and performing cross traversal on the EBOM and the DBOM based on a hierarchical structure identification field to obtain structure difference data between the EBOM and the DBOM.
5. The BOM difference analysis method of claim 4, wherein after the obtaining of the structural difference data between the EBOM and the DBOM, the method further comprises the steps of:
and analyzing and obtaining the unique EBOM structure or the unique DBOM structure based on the structural difference data between the EBOM and the DBOM.
6. The BOM difference analysis method of claim 1, further comprising the steps of:
traversing the EBOM and the DBOM based on a preset hierarchical structure identification field and a first to-be-analyzed difference attribute, and identifying and obtaining difference data corresponding to the first to-be-analyzed difference attribute;
and traversing the difference data corresponding to the first to-be-analyzed difference attribute based on the second to-be-analyzed difference attribute, and analyzing the difference condition corresponding to each part in the difference data corresponding to the first to-be-analyzed difference attribute.
7. The BOM difference analysis method of claim 1, further comprising the steps of:
and constructing a corresponding difference data table based on the difference data.
8. A storage medium having a computer program stored thereon, characterized in that: the computer program when executed by a processor implements the steps of the method of any of claims 1 to 7 above.
9. An apparatus comprising a memory, a processor, and a computer program stored on the memory and executed on the processor, wherein: the processor, when executing the computer program, realizes the steps of the method of any of the preceding claims 1 to 7.
10. A BOM variance analysis apparatus, comprising:
the BOM downloading module is used for downloading the EBOM and the DBOM corresponding to the target vehicle type;
the BOM preprocessing module is used for replacing the original multi-line display mode by using a quantity statistical mode aiming at the repeatedly used parts in the EBOM and the DBOM respectively;
the BIM consistent processing module is used for carrying out initial consistent processing on the EBOM and the DBOM, so that the EBOM and the DBOM comprise the same part type;
the difference identification module is used for traversing the EBOM and the DBOM based on a preset hierarchical structure identification field and a difference attribute to be analyzed, and identifying and obtaining difference data; wherein the content of the first and second substances,
the hierarchical structure identification field is a part number and a corresponding parent-level part number;
the difference data comprises a plurality of parts which exist in the EBOM and the DBOM, have the same part numbers and the corresponding parent-level part numbers and have different attribute parameters of the different attributes to be analyzed.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210047561.1A CN114066376B (en) | 2022-01-17 | 2022-01-17 | BOM difference analysis method, storage medium, equipment and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210047561.1A CN114066376B (en) | 2022-01-17 | 2022-01-17 | BOM difference analysis method, storage medium, equipment and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114066376A true CN114066376A (en) | 2022-02-18 |
| CN114066376B CN114066376B (en) | 2022-05-17 |
Family
ID=80231161
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210047561.1A Active CN114066376B (en) | 2022-01-17 | 2022-01-17 | BOM difference analysis method, storage medium, equipment and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114066376B (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5630070A (en) * | 1993-08-16 | 1997-05-13 | International Business Machines Corporation | Optimization of manufacturing resource planning |
| CN101515308A (en) * | 2009-03-31 | 2009-08-26 | 上海同济同捷科技股份有限公司 | Data management system for vehicle products and collaborative design method thereof |
| CN101937526A (en) * | 2010-04-28 | 2011-01-05 | 重庆迈特科技有限责任公司 | Method for configuring product multi-BOM tree based on base products |
| CN110276573A (en) * | 2018-03-16 | 2019-09-24 | 凯柏精密机械(嘉兴)有限公司 | Order generation system for BOM table management |
| CN111144089A (en) * | 2019-12-17 | 2020-05-12 | 东风商用车有限公司 | Method and equipment for checking difference between part list and model file of design software |
| CN112712415A (en) * | 2021-01-19 | 2021-04-27 | 青岛檬豆网络科技有限公司 | Form preprocessing method based on purchase BOM (bill of material) price checking of electronic components |
| CN113191457A (en) * | 2021-05-26 | 2021-07-30 | 重庆高新技术产业研究院有限责任公司 | Production data and BOM automatic classification gathering method applied to manufacturing enterprises |
| CN113592378A (en) * | 2021-06-17 | 2021-11-02 | 南通美之兰通讯科技有限公司 | BOM construction method and management system of large complex equipment |
-
2022
- 2022-01-17 CN CN202210047561.1A patent/CN114066376B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5630070A (en) * | 1993-08-16 | 1997-05-13 | International Business Machines Corporation | Optimization of manufacturing resource planning |
| CN101515308A (en) * | 2009-03-31 | 2009-08-26 | 上海同济同捷科技股份有限公司 | Data management system for vehicle products and collaborative design method thereof |
| CN101937526A (en) * | 2010-04-28 | 2011-01-05 | 重庆迈特科技有限责任公司 | Method for configuring product multi-BOM tree based on base products |
| CN110276573A (en) * | 2018-03-16 | 2019-09-24 | 凯柏精密机械(嘉兴)有限公司 | Order generation system for BOM table management |
| CN111144089A (en) * | 2019-12-17 | 2020-05-12 | 东风商用车有限公司 | Method and equipment for checking difference between part list and model file of design software |
| CN112712415A (en) * | 2021-01-19 | 2021-04-27 | 青岛檬豆网络科技有限公司 | Form preprocessing method based on purchase BOM (bill of material) price checking of electronic components |
| CN113191457A (en) * | 2021-05-26 | 2021-07-30 | 重庆高新技术产业研究院有限责任公司 | Production data and BOM automatic classification gathering method applied to manufacturing enterprises |
| CN113592378A (en) * | 2021-06-17 | 2021-11-02 | 南通美之兰通讯科技有限公司 | BOM construction method and management system of large complex equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114066376B (en) | 2022-05-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9501275B2 (en) | Compositing deltas when merging artifacts in a version control system | |
| CN110443552B (en) | Method and device for automatically transmitting product main data information | |
| CN106033436B (en) | Database merging method | |
| US20070005619A1 (en) | Method and system for detecting tables to be modified | |
| Shri et al. | Prediction of reusability of object oriented software systems using clustering approach | |
| CN107463548A (en) | Short phrase picking method and device | |
| US9158599B2 (en) | Programming framework for applications | |
| CN109063178A (en) | A kind of method and device of the self-service analytical statement extended automatically | |
| CN105260300A (en) | Service test method based on CAS (General Classification Standards of China Accounting Standards) application platform | |
| CN113538154A (en) | Risk object identification method and device, storage medium and electronic equipment | |
| CN110851663B (en) | Method and device for managing metadata | |
| CN114066376B (en) | BOM difference analysis method, storage medium, equipment and device | |
| CN112800371A (en) | Method and device for processing spreadsheet data in web page | |
| CN111858366A (en) | Test case generation method, device, equipment and storage medium | |
| Breuker et al. | Graph theory and model collection management: conceptual framework and runtime analysis of selected graph algorithms | |
| CN106844218B (en) | Evolution influence set prediction method based on evolution slices | |
| US8359329B2 (en) | Method, computer apparatus and computer program for identifying unusual combinations of values in data | |
| Bartova et al. | Data Mining Methods Used for Quality Management–a Bibliometric Analysis | |
| CN111553789A (en) | Method and device for distributing joint credit and debit amount of multi-entity company | |
| CN113268412B (en) | Control analysis method, device, equipment and medium for Web system test case recording | |
| CN113177828A (en) | Article recommendation method, device, equipment and storage medium | |
| CN110765100B (en) | Label generation method and device, computer readable storage medium and server | |
| Seidl | LIProMa: Label-Independent Process Matching | |
| Türkakın | A Scientometric Analysis and a Review on Current Literature of Computer Vision Applications | |
| CN112100242A (en) | Informationized product association rule mining method based on Apriori algorithm |
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 |