CN111143353B - Method for extracting BOM change data from change list - Google Patents
Method for extracting BOM change data from change list Download PDFInfo
- Publication number
- CN111143353B CN111143353B CN201911228378.6A CN201911228378A CN111143353B CN 111143353 B CN111143353 B CN 111143353B CN 201911228378 A CN201911228378 A CN 201911228378A CN 111143353 B CN111143353 B CN 111143353B
- Authority
- CN
- China
- Prior art keywords
- data
- bom
- change
- comparison
- key value
- 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
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method for extracting BOM change data from a change list, which comprises the following steps: s1: defining original data to be compared; s2: converting the data format to convert the tree structure to a comparable table structure; s3: carrying out structure comparison and attribute comparison on the table structure; s4: and (4) persisting the comparison result into a database, and finally performing data item presentation and analysis. The invention changes the content classification and clausealization, facilitates the checking of signing personnel in the signing process and the information checking of filing personnel.
Description
Technical Field
The invention relates to the technical field of data screening, in particular to a method for extracting BOM change data from a change list.
Background
By analyzing the current situation of BOM changing business of the current aviation manufacturing engineering, data structuralization is not formed on BOM changing and changing lists of most units at present, not to mention structuralization of BOM changing and changing list contents, most changing list contents are handwritten according to BOM and drawing changes, manual operation always causes inconsistency of BOM actual changing results and changing list filling contents, and once data errors occur, great influence is caused on production. Based on structuring of the change data and the change list, BOM data before and after change are automatically compared through a background program, and relevant changed data are automatically extracted and filled into the change list to be provided for relevant designers to check and modify.
Disclosure of Invention
The present invention is directed to solving, at least to some extent, one of the technical problems in the related art. Therefore, the invention aims to provide a method for extracting BOM change data from a change order, solves the problem that the BOM change result is inconsistent with the content of the change order, solves the problems that the filling rule of the change order content is inconsistent and the change data is inconsistent with the change order content, classifies and makes the change content into items, facilitates the checking of signing personnel in the signing process of the process and facilitates the information checking of filing personnel.
According to the method for extracting BOM change data from the change list, the method comprises the following steps:
s1: defining original data to be compared;
s2: converting the data format to convert the tree structure to a comparable table structure;
s3: performing structure comparison and attribute comparison on the table structure;
s4: and (4) persisting the comparison result into a database, and finally performing data item presentation and analysis.
Preferably, the original data is a pre-change base BOM and a post-change BOM.
Preferably, the S2 step includes:
s21: aiming at the modified BOM, recursively traversing the BOM structure through a depth traversal algorithm to obtain all BOM data to be compared;
s22: defining a specific operation of a set for storing data as a set, wherein the material number in the material attribute of the BOM is unique, so that the assembly relationship of materials in the BOM structure can be uniquely determined by the parent number & & the child level in the BOM structure;
s23: until the whole BOM structure is traversed, forming a data set before modification and combining the data set with the mark set A, wherein the structure information and the material information of the BOM are stored in the data set;
s24: for the modified BOM, a set of modified data may be obtained and given to the label set B, similarly with reference to S23.
Preferably, the material properties are quantity, stage and material specifications.
Preferably, the S3 step includes:
s31: traversing the set A in the S23 as a basic data set to obtain a key value of each set element, and taking the set B in the S23 as a comparison data set;
s32: judging whether the same key value exists in the set B or not;
s33: after the set A is traversed, the same elements are removed in the comparison process, and the elements left in the set B are newly added hierarchical elements in the structural change;
s34: in S32, if the key value exists in both the two sets, the information of the sub-level materials in the two sets is acquired and compared, the attributes which need to be compared are identified through the configuration file, the related attributes are compared, if the attributes are the same, the identification is not changed, otherwise, the identification attribute is changed;
s35: persisting the result of the comparison to a database.
Preferably, the step S32: the method comprises the following steps:
s321: if the key value exists, the fact that the sub-level material structure is not changed is represented, and meanwhile the related key value is removed from the set B;
s322: if the current key value does not exist in set B, then it is identified that the current structural relationship does not exist in the changed data.
Preferably, the key value is the parent number & & child.
Preferably, the S4 step includes:
s41: summarizing and classifying the data persisted into the database by the S3 through a web technology, and displaying the item words on a webpage;
s42: and extracting a BOM change data comparison result from the change list to generate a Word file which can be stored in a local computer, and automatically generating the Word file according to the data displayed by the webpage by adopting a freemarker to store and file.
The beneficial effects of the invention are as follows:
(1) The problem that the BOM changing result is inconsistent with the content of the changing list is solved.
(2) A user only needs to change the BOM structure and the related attributes according to own change requirements, and in the process of creating a change list, the system automatically extracts the information before and after the change according to the change of the BOM before and after the change, fills the information into the content of the change list, and marks the information according to the changed data.
(3) The conditions that filling rules of the changed list contents are not uniform and the changed data and the changed list contents are inconsistent are solved.
(4) And the content classification and entry are changed, so that the signing personnel can conveniently check the signing process in the process of signing, and the information can be conveniently checked by the filing personnel.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description serve to explain the principles of the invention and not to limit the invention. In the drawings:
FIG. 1 is a flow chart of a method for extracting BOM change data from a change order according to the present invention;
FIG. 2 is a diagram of the comparison result extracted in the method for extracting BOM change data from a change list according to the present invention.
Detailed Description
The present invention will now be described in further detail with reference to the accompanying drawings. These drawings are simplified schematic views illustrating only the basic structure of the present invention in a schematic manner, and thus show only the constitution related to the present invention.
Referring to fig. 1-2, a method for extracting BOM change data from a change order includes the following steps:
s1: defining original data to be compared;
s2: converting the data format to convert the tree structure to a comparable table structure;
s3: carrying out structure comparison and attribute comparison on the table structure;
s4: and (4) persisting the comparison result into a database, and finally performing data item presentation and analysis.
The original data are the base BOM before the change and the changed BOM after the change.
The step S2 comprises the following steps:
s21: aiming at the modified BOM, recursively traversing the BOM structure through a depth traversal algorithm to obtain all BOM data to be compared;
s22: defining a specific operation of a set for storing data as a set, wherein the material number in the material attribute of the BOM is unique, so that the assembly relationship of materials in the BOM structure can be uniquely determined by the parent number & & the child level in the BOM structure;
s23: forming a pre-modification data set until the traversal of the whole BOM structure is finished, and giving the pre-modification data set to the mark set A to store the structural information and the material information of the BOM;
s24: for the modified BOM, a set of modified data may be obtained and given to the label set B, similarly with reference to S23.
The material attributes are quantity, stage and material specifications.
The step S3 comprises the following steps:
s31: traversing the set A in the S23 as a basic data set to obtain a key value of each set element, and taking the set B in the S23 as a comparison data set;
s32: judging whether the same key value exists in the set B or not;
s33: after the set A is traversed, the same elements are removed in the comparison process, and the elements left in the set B are newly added hierarchical elements in the structural change;
s34: in S32, if the key value exists in both the two sets, the information of the sub-level materials in the two sets is acquired and compared, the attributes which need to be compared are identified through the configuration file, the related attributes are compared, if the attributes are the same, the identification is not changed, otherwise, the identification attribute is changed;
s35: the results of the comparison are persisted to a database.
And S32: the method comprises the following steps:
s321: if the key value exists, the fact that the sub-level material structure is not changed is represented, and meanwhile the related key value is removed from the set B;
s322: if the current key value does not exist in set B, then it is identified that the current structural relationship does not exist in the changed data.
The key value is the parent number & & child.
The step S4 comprises the following steps:
s41: summarizing and classifying the data persisted into the database by the S3 through a web technology, and displaying the item words on a webpage;
s42: and extracting BOM change data from the change list, comparing the result to generate a Word file which can be stored in a local computer, and automatically generating the Word file according to the data displayed by the webpage by adopting a freemarker to store and file.
The BOM structure is traversed from a BOM top node in a deep traversal mode before and after modification, traversal results of the number before and after modification are stored in two data sets before and after modification, a key value (data of each data set are ensured not to be repeated) is used as a parent code plus a child code, a value is used as a configurable item, a BOM object is dynamically generated according to a configuration file of a background (configuration needs to display structure attributes and material attributes in a modification list, and the configuration file comprises a middle attribute configuration file and an English attribute configuration file), and the BOM structure is converted into data with comparable attributes.
Through traversing the before-modification data set and the data comparison, if the key value of the before-modification data set does not exist in the after-modification data, the material in the after-modification data is identified to be deleted, and similarly, traversing the after-modification data set, if the after-modification data set key does not exist in the before-modification data set, the material is identified to be a newly added material after modification, so that the comparison of the before-modification and after-modification BOM structure changes is completed.
When traversing the changed data set, in order to ensure the efficiency of program execution, if the key of the data set before the change does not exist in the changed set, the key is marked as a new material, otherwise, the key represents that the key exists in both the data set before the change and the data set after the change, the change of the attribute before the change and the change of the attribute after the change are compared according to the value, and if the key is different, the attribute change (such as quantity, stage, material specification and the like) is marked, so that the comparison of the change of the BOM attribute of the same material is completed.
It should be noted that some simple rules may also be configured in the structure comparison process, and if it is required to compare whether two materials are replacement parts, it is only required to configure attributes (such as names) for identifying the replacement parts in the background, and then the program will identify the materials in the two sets as the replacement parts in the processing process according to the configuration, and if the replacement identifications are the same and the keys are different when the identifications are respectively present in the pre-change data set and the post-change data set in the structure comparison process.
After the comparison result is obtained, how to visually display the items on the webpage is automatically generated according to the configuration file, the structure of the webpage interface is changed by one material and one item, the attribute change is displayed in the same item due to the fact that the result comparison is related, and if the changed attribute values in different changed data are marked by colors.
And generating a Word file which can be stored in a local computer according to a comparison result, and automatically generating the Word file according to data displayed by a webpage by adopting a freemarker (template staticizing).
The data comparison method comprises the following steps: and data conversion, namely storing the data before and after the modification by using a set, so that the data before and after the modification is converted from a tree structure into a data set capable of being compared, wherein the BOM attributes are obtained by comparing attribute sets to be compared by the automatic analysis programs through a json (such as { [ name: number: no. \8230; ] }) system in a configuration file format read by a configuration file, and performing two comparisons to obtain a final comparison result, wherein the comparison logic is described in the above. The client can automatically read the comparison result according to the configuration file, displays the comparison result on the webpage in an itemized manner, and can automatically generate the Word file which can be stored in the computer by clicking the (printing the modification list) on the webpage, so that the system can automatically acquire the BOM modification result, the webpage displayed in an itemized manner and finally generate the Word file which can be stored.
All background codes are realized by java, and the method is cross-platform and portable.
Example 1:
defining the raw data to be compared: changing the BOM before (basic) and after (changing);
and aiming at the BOM before the BOM is changed, recursively traversing the BOM structure through a depth traversal algorithm, and acquiring all BOM data to be compared.
The method comprises the steps that a specific operation of a set of stored data is defined as a Map set, and material numbers in material attributes of BOMs are unique, so that the assembly relation of materials in one BOM structure can be uniquely determined by [ parent numbers & & child levels ] in the BOM structure, and therefore the Map set is formed into Map < [ parent numbers & & child levels ] and child level material information >;
and forming a before-change data Map set which is recorded as mapFuore until the traversal of the whole BOM structure is finished, wherein the structure information and the material information of the BOM are stored in the before-change data Map set.
For the modified BOM, a Map set which can obtain modified data by referring to the previous steps and the same principle is recorded as mapAfter.
Traversing the mapFuore as a basic data set, acquiring a key value of each set element, namely [ parent number & & child ], and taking mapAfter as a comparison data set;
judging whether the same key value exists in the mapAfter, if so, indicating that the structure of the sublevel material is not changed, and simultaneously removing the related key value from the mapAfter;
if the current key value does not exist in mapAfter, identifying that the current structural relationship does not exist in the changed data;
until the mapefore traversal is finished, the same elements are removed in the comparison process, and the elements left in mapAfter are newly added hierarchical elements in the current structural change;
if the key value exists in the two sets, the information of the sublevel materials in the two sets is obtained and compared, in the attribute comparison process, because the attributes of different BOM materials are different, the attribute of which needs to be compared can be identified through a configuration file in a universal json file format, because the information of the sublevel materials is stored in a POJO object form, the related attributes of the sublevel materials only need to be compared, if the attributes are the same, the identification is not changed, otherwise, the identification attribute is changed;
the whole comparison result is completed, and finally the comparison result is persisted into a database to provide data display and analysis for subsequent steps;
the data which are durably stored in the database in the steps are collected and classified and the item words are displayed on a webpage through a web technology, so that the change of the BOM can be seen clearly at a glance that the materials belong to new addition, the materials belong to deletion and the material attribute changes;
and extracting a BOM change data comparison result from the change list to generate a Word file which can be stored in a local computer, automatically generating the Word file according to the data displayed by the webpage by adopting a freemarker, storing and filing the Word file, and the like.
The invention changes the content classification and clausealization, facilitates the checking of signing personnel in the signing process and the information checking of filing personnel.
The above description is only for the preferred embodiment of the present invention, but the scope of the present invention is not limited thereto, and any person skilled in the art should be considered to be within the technical scope of the present invention, and the technical solutions and the inventive concepts thereof according to the present invention should be equivalent or changed within the scope of the present invention.
Claims (1)
1. A method for extracting BOM change data from a change list is characterized in that: the method comprises the following steps:
s1: defining original data to be compared;
s2: converting the data format to convert the tree structure into a comparable table structure;
s3: performing structure comparison and attribute comparison on the table structure;
s4: persisting the comparison result into a database, and finally displaying and analyzing the data items;
wherein the original data are a base BOM before modification and a modified change BOM after modification;
wherein the step S2 comprises:
s21: aiming at the modified BOM, recursively traversing the BOM structure through a depth traversal algorithm to obtain all BOM data to be compared;
s22: defining a specific operation of a set for storing data as a set, wherein the material number in the material attribute of the BOM is unique, so that the assembly relationship of materials in the BOM structure can be uniquely determined by the parent number & & the child level in the BOM structure;
s23: until the whole BOM structure is traversed, forming a data set before modification and combining the data set with the mark set A, wherein the structure information and the material information of the BOM are stored in the data set;
s24: for the modified BOM, referring to S23, a set of modified data may be obtained and given to the mark set B;
the material attributes are quantity, stage and material specification;
wherein, the S3 step comprises:
s31: traversing the set A in the S23 as a basic data set, acquiring a key value of each set element, and taking the set B in the S23 as a comparison data set;
s32: judging whether the same key value exists in the set B or not;
s33: until the set A is traversed, the same elements are removed in the comparison process, and the elements left in the set B are newly added hierarchical elements in the structural change;
s34: in S32, if the key value exists in both the two sets, the information of the sub-level materials in the two sets is acquired and compared, the attributes which need to be compared are identified through the configuration file, the related attributes are compared, if the attributes are the same, the identification is not changed, otherwise, the identification attribute is changed;
s35: persisting the result of the comparison into a database;
wherein, the S32: the method comprises the following steps:
s321: if the key value exists, the fact that the sub-level material structure is not changed is represented, and meanwhile the related key value is removed from the set B;
s322: if the current key value does not exist in the set B, identifying that the current structural relationship does not exist in the changed data;
the key value is the parent number & & child;
wherein, the step S4 comprises:
s41: the data persisted into the database in S3 are collected and classified through web technology, and the entry words are displayed on a webpage;
s42: and extracting a BOM change data comparison result from the change list to generate a Word file which can be stored in a local computer, and automatically generating the Word file according to the data displayed by the webpage by adopting a freemarker to store and file.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911228378.6A CN111143353B (en) | 2019-12-04 | 2019-12-04 | Method for extracting BOM change data from change list |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911228378.6A CN111143353B (en) | 2019-12-04 | 2019-12-04 | Method for extracting BOM change data from change list |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111143353A CN111143353A (en) | 2020-05-12 |
| CN111143353B true CN111143353B (en) | 2023-04-14 |
Family
ID=70517634
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911228378.6A Active CN111143353B (en) | 2019-12-04 | 2019-12-04 | Method for extracting BOM change data from change list |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111143353B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113743880A (en) * | 2020-05-29 | 2021-12-03 | 上海汽车集团股份有限公司 | Method and system for checking bill of materials of vehicle |
| CN113722827B (en) * | 2021-08-31 | 2024-06-11 | 奇瑞汽车股份有限公司 | CAD data creation method, device and computer storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1856783A (en) * | 2002-07-26 | 2006-11-01 | 罗恩·埃弗里特 | Data management structure associated with general data item |
| CN102426587A (en) * | 2011-10-27 | 2012-04-25 | 北京航空航天大学 | Method for customizing and inquiring heterogeneous BOM (Bill of Materiel) based on complex product |
| CN105302803A (en) * | 2014-05-28 | 2016-02-03 | 中国科学院沈阳自动化研究所 | Product BOM difference analyzing and synchronous updating method |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| TW200419388A (en) * | 2003-03-21 | 2004-10-01 | Hon Hai Prec Ind Co Ltd | System and method for automatically comparing and recoding difference between bills of material (BOM) |
-
2019
- 2019-12-04 CN CN201911228378.6A patent/CN111143353B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1856783A (en) * | 2002-07-26 | 2006-11-01 | 罗恩·埃弗里特 | Data management structure associated with general data item |
| CN102426587A (en) * | 2011-10-27 | 2012-04-25 | 北京航空航天大学 | Method for customizing and inquiring heterogeneous BOM (Bill of Materiel) based on complex product |
| CN105302803A (en) * | 2014-05-28 | 2016-02-03 | 中国科学院沈阳自动化研究所 | Product BOM difference analyzing and synchronous updating method |
Non-Patent Citations (2)
| Title |
|---|
| ERP系统中BOM的模型分析与算法实现;刘辉等;《航空电子技术》(第02期);全文 * |
| 一种基于变更流程的EBOM数据变更统计机制;郭庆军等;《新型工业化》(第08期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111143353A (en) | 2020-05-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111680025B (en) | Method and system for intelligently assimilating space-time information of multi-source heterogeneous data oriented to natural resources | |
| CN111444293B (en) | Intelligent report generation method for multi-source heterogeneous safety monitoring data | |
| US20050183002A1 (en) | Data and metadata linking form mechanism and method | |
| US20050203869A1 (en) | Hierarchical database apparatus, components selection method in hierarchical database, and components selection program | |
| US8502823B2 (en) | Method and system for lane graph visualization | |
| CN110738027B (en) | Computer-implemented method, apparatus, and storage medium for generating spreadsheet formulas | |
| CN106570232A (en) | Inspection procedure automatic generation method | |
| CN111143353B (en) | Method for extracting BOM change data from change list | |
| JP2013507712A (en) | Excel-based analysis report creation system and method | |
| US20170300531A1 (en) | Tag based searching in data analytics | |
| CN105260300A (en) | Service test method based on CAS (General Classification Standards of China Accounting Standards) application platform | |
| CN110619128B (en) | Construction method of digital factory | |
| CN114547077A (en) | Intelligent processing system and method for basic government affair form data | |
| CN115293124A (en) | Automatic generation method and device for software engineering document | |
| Loibl et al. | Procedure for the transfer of standards into machine-actionability | |
| CN115756437A (en) | Visual XML data compiling method and system based on SCHEMA file | |
| CN111190880A (en) | Database detection method and device and computer readable storage medium | |
| US20070136333A1 (en) | Method of inspection and a user interface for a business measure modeling tool | |
| EP1745390A2 (en) | Data and metadata linking form mechanism and method | |
| US20080109443A1 (en) | Information Management Method, Information Management Program And Information Management Apparatus | |
| JP2007026430A (en) | Design data management program and trace program | |
| Do et al. | Widget-based Exploration of Linked Statistical Data Spaces. | |
| JP7022472B1 (en) | Data management system, data management method and data management program | |
| JP6775740B1 (en) | Design support device, design support method and design support program | |
| CN115964533A (en) | Database system for comprehensively describing material industry |
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 | ||
| CB03 | Change of inventor or designer information |
Inventor after: Zhang Junhua Inventor after: Li Yongjian Inventor after: Ma Xiaobao Inventor after: Zheng Limin Inventor after: Gao Xiaoning Inventor before: Zhang Junhua Inventor before: Li Yongjian Inventor before: Ma Xiaobao Inventor before: Zheng Limin Inventor before: Gao Xiaoning |
|
| CB03 | Change of inventor or designer information |