CN114066376B - BOM difference analysis method, storage medium, equipment and device - Google Patents

BOM difference analysis method, storage medium, equipment and device Download PDF

Info

Publication number
CN114066376B
CN114066376B CN202210047561.1A CN202210047561A CN114066376B CN 114066376 B CN114066376 B CN 114066376B CN 202210047561 A CN202210047561 A CN 202210047561A CN 114066376 B CN114066376 B CN 114066376B
Authority
CN
China
Prior art keywords
difference
dbom
ebom
analyzed
attributes
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.)
Active
Application number
CN202210047561.1A
Other languages
Chinese (zh)
Other versions
CN114066376A (en
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.)
Lantu Automobile Technology Co Ltd
Original Assignee
Lantu Automobile 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 Lantu Automobile Technology Co Ltd filed Critical Lantu Automobile Technology Co Ltd
Priority to CN202210047561.1A priority Critical patent/CN114066376B/en
Publication of CN114066376A publication Critical patent/CN114066376A/en
Application granted granted Critical
Publication of CN114066376B publication Critical patent/CN114066376B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

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—Information and communication technology [ICT] specially adapted for implementation of business processes of 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

Landscapes

  • Business, Economics & Management (AREA)
  • Engineering & Computer Science (AREA)
  • Economics (AREA)
  • Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Human Resources & Organizations (AREA)
  • Marketing (AREA)
  • General Business, Economics & Management (AREA)
  • Strategic Management (AREA)
  • Tourism & Hospitality (AREA)
  • General Health & Medical Sciences (AREA)
  • Primary Health Care (AREA)
  • Health & Medical Sciences (AREA)
  • Manufacturing & Machinery (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Development Economics (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

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

BOM difference analysis method, storage medium, equipment and device
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, including 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;
identifying part numbers and father part numbers in the EBOM and the DBOM based on different hierarchical structure identification fields, and obtaining structure difference data for recording part structure relationship difference between the EBOM and the DBOM;
identifying unique part numbers in the EBOM and the DBOM based on the different part numbers, and obtaining part difference information recording part differences between the EBOM and the DBOM;
based on different hierarchical structure identification fields and different to-be-analyzed difference attributes, traversing the EBOM and the DBOM, identifying the difference between parts which belong to the EBOM and the DBOM respectively and have the same parent part number and part number on the corresponding to-be-analyzed difference attributes, and obtaining difference data or coexistence data;
based on different coexisting data, combining different hierarchical structure identification fields and different differential attributes to be analyzed later, performing multiple differential analyses, identifying parts which belong to the EBOM and the DBOM respectively, and acquiring the differential data after two different differential attributes to be analyzed are combined according to the difference of the differential attributes to be analyzed later on the premise that the parameters of the corresponding differential attributes to be analyzed before are the same between parts with the same parent part number and part number;
establishing a difference data table taking the hierarchical structure identification field as a sorting basis on the basis of the structure difference data, the part difference information and each difference data; wherein the content of the first and second substances,
the differential attributes to be analyzed are quantity or configuration variables, and the identification fields of the hierarchical structure are part numbers and corresponding parent-level part numbers;
the difference data comprises a plurality of parts with the same part number in the EBOM and the DBOM and the corresponding parent-level part number, and the corresponding attribute parameters of the difference attributes to be analyzed have differences;
the coexistence data comprises a plurality of parts which have the same part number in the EBOM and the DBOM and the corresponding parent-level part number and have the same attribute parameters of the differential attributes to be analyzed.
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.
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 identifying part numbers and parent part numbers in the EBOM and the DBOM based on different hierarchical structure identification fields and obtaining structural difference data for recording the part structural relationship difference between the EBOM and the DBOM;
the difference identification module is further used for identifying unique part numbers in the EBOM and the DBOM based on different part numbers and obtaining part difference information for recording part differences between the EBOM and the DBOM;
the difference identification module is also used for traversing the EBOM and the DBOM based on different hierarchical structure identification fields and different to-be-analyzed difference attributes, identifying the difference between parts which belong to the EBOM and the DBOM respectively and have the same parent part number and part number on the corresponding to-be-analyzed difference attributes, and obtaining difference data or coexisting data;
the difference identification module is further configured to perform multiple difference analyses by combining different hierarchical structure identification fields and different to-be-analyzed difference attributes based on the different coexisting data, identify parts which belong to the EBOM and the DBOM respectively, and have the same parent part number and the same part number, and obtain the difference data obtained by combining the two different to-be-analyzed difference attributes on the premise that the parameters of the corresponding to-be-analyzed difference attributes are the same;
a table statistics module, configured to establish a difference data table using the hierarchical structure identification field as a sorting criterion based on the structure difference data, the part difference information, and each difference data; wherein the content of the first and second substances,
the differential attributes to be analyzed are quantity or configuration variables, and the identification fields of the hierarchical structure are part numbers and corresponding parent-level part numbers;
the difference data comprises a plurality of parts with the same part number in the EBOM and the DBOM and the corresponding parent-level part number, and the corresponding attribute parameters of the difference attributes to be analyzed have differences;
the coexistence data comprises a plurality of parts which have the same part number in the EBOM and the DBOM and the corresponding parent-level part number and have the same attribute parameters of the differential attributes to be analyzed.
The technical scheme who provides this application brings beneficial effect 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 effect, 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 first and the second end of the pipe are connected with each other,
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 eleven, storing the analysis results obtained in the step six to the step eleven in the EBOM set A and the DBOM set B respectively.
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 (6)

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;
identifying part numbers and parent part numbers in the EBOM and the DBOM based on different hierarchical structure identification fields, and obtaining structural difference data for recording the difference of part structural relationship between the EBOM and the DBOM;
identifying unique part numbers in the EBOM and the DBOM based on the different part numbers, and obtaining part difference information recording part differences between the EBOM and the DBOM;
based on different hierarchical structure identification fields and different to-be-analyzed difference attributes, traversing the EBOM and the DBOM, identifying the difference between parts which belong to the EBOM and the DBOM respectively and have the same parent part number and part number on the corresponding to-be-analyzed difference attributes, and obtaining difference data or coexistence data;
based on different coexisting data, combining different hierarchical structure identification fields and different differential attributes to be analyzed later, performing multiple differential analyses, identifying parts which belong to the EBOM and the DBOM respectively, and acquiring the differential data after two different differential attributes to be analyzed are combined according to the difference of the differential attributes to be analyzed later on the premise that the parameters of the corresponding differential attributes to be analyzed before are the same between parts with the same parent part number and part number;
establishing a difference data table taking the hierarchical structure identification field as a sequencing basis on the basis of the structure difference data, the part difference information and each difference data;
the attribute of the difference to be analyzed is quantity or configuration variable, and the identification field of the hierarchical structure is a part number and a corresponding parent-level part number;
the difference data comprises a plurality of parts with the same part number in the EBOM and the DBOM and the corresponding parent-level part number, and the corresponding attribute parameters of the difference attributes to be analyzed have differences;
the coexistence data comprises a plurality of parts which have the same part number in the EBOM and the DBOM and the corresponding parent-level part number and have the same attribute parameters of the differential attributes to be analyzed.
2. The BOM difference analysis method of claim 1, 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.
3. 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.
4. 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 the preceding claims 1 to 3.
5. 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 3.
6. 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 consistency processing module is used for carrying out initial consistency processing on the EBOM and the DBOM, so that the parts included in the EBOM and the DBOM are of the same type;
the difference identification module is used for identifying part numbers and parent part numbers in the EBOM and the DBOM based on different hierarchical structure identification fields and obtaining structural difference data for recording the part structural relationship difference between the EBOM and the DBOM;
the difference identification module is further used for identifying unique part numbers in the EBOM and the DBOM based on different part numbers and obtaining part difference information for recording part differences between the EBOM and the DBOM;
the difference identification module is further used for traversing the EBOM and the DBOM based on different hierarchical structure identification fields and different to-be-analyzed difference attributes, identifying the difference between parts which belong to the EBOM and the DBOM respectively and have the same parent part number and part number on the corresponding to-be-analyzed difference attributes, and obtaining difference data or coexistence data;
the difference identification module is further configured to perform multiple difference analyses by combining different hierarchical structure identification fields and different to-be-analyzed difference attributes based on the different coexisting data, identify parts which belong to the EBOM and the DBOM respectively, and have the same parent part number and the same part number, and obtain the difference data obtained by combining the two different to-be-analyzed difference attributes on the premise that the parameters of the corresponding to-be-analyzed difference attributes are the same;
a table statistics module, configured to establish a difference data table using the hierarchical structure identification field as a sorting criterion based on the structure difference data, the part difference information, and each difference data; wherein the content of the first and second substances,
the differential attributes to be analyzed are quantity or configuration variables, and the identification fields of the hierarchical structure are part numbers and corresponding parent-level part numbers;
the difference data comprises a plurality of parts with the same part number in the EBOM and the DBOM and the corresponding parent-level part number, and the corresponding attribute parameters of the difference attributes to be analyzed have differences;
the coexistence data comprises a plurality of parts which have the same part number in the EBOM and the DBOM and the corresponding parent-level part number and have the same attribute parameters of the differential attributes to be analyzed.
CN202210047561.1A 2022-01-17 2022-01-17 BOM difference analysis method, storage medium, equipment and device Active CN114066376B (en)

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 CN114066376A (en) 2022-02-18
CN114066376B true 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)

* Cited by examiner, † Cited by third party
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

Patent Citations (8)

* Cited by examiner, † Cited by third party
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
CN114066376A (en) 2022-02-18

Similar Documents

Publication Publication Date Title
CN106033436B (en) Database merging method
JP4904878B2 (en) System development support program, system development support device, and system development support method
Shri et al. Prediction of reusability of object oriented software systems using clustering approach
Sahraoui et al. Applying concept formation methods to object identification in procedural code
CN107463548A (en) Short phrase picking method and device
US7113951B2 (en) Method and system for detecting tables to be modified
US9158599B2 (en) Programming framework for applications
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
Ryu et al. Occupancy‐based utility pattern mining in dynamic environments of intelligent systems
CN114066376B (en) BOM difference analysis method, storage medium, equipment and device
CN111177311B (en) Data analysis model and analysis method of event processing result
CN110765100B (en) Label generation method and device, computer readable storage medium and server
CN111858366A (en) Test case generation method, device, equipment and storage medium
CN105573984A (en) Socio-economic indicator identification method and device
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
CN112100242A (en) Informationized product association rule mining method based on Apriori algorithm
CN111352824B (en) Test method and device and computer equipment
US8359329B2 (en) Method, computer apparatus and computer program for identifying unusual combinations of values in data
CN111553789A (en) Method and device for distributing joint credit and debit amount of multi-entity company
Akinshin et al. Automate Well Logging Data Interpretation with Digital Assistant
CN117972115B (en) Method, equipment and medium for constructing process automation rule base
CN113177828A (en) Article recommendation method, device, equipment and storage medium
EP4235460A1 (en) Method for filtering a graph

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