Search

CN-121998561-A - Multi-view BOM conversion method and system based on single data source

CN121998561ACN 121998561 ACN121998561 ACN 121998561ACN-121998561-A

Abstract

The invention provides a multi-view BOM conversion method and system based on a single data source, which takes EBOM, PBOM and MBOM original data of a ship design manufacturing system as input, stores and builds a full life cycle xBOM unified model by adopting a JSON format, enables each BOM node to have static attribute, dynamically selects mapping rules by a hybrid mapping rule engine to finish EBOM-PBOM-MBOM conversion, detects data consistency in conversion, adopts multiple strategies to resolve various conflicts and record the whole course, combines an incremental updating technology to optimize efficiency, and finally supports interactive integration and generates manufacturing instructions by a Web interface and an API interface.

Inventors

  • FAN SHIDONG
  • Hou Yinjue
  • LIU AIHUA

Assignees

  • 武汉理工大学

Dates

Publication Date
20260508
Application Date
20260109

Claims (12)

  1. 1. The multi-view BOM conversion method based on the single data source is characterized by comprising the following steps of: Step a, inputting EBOM, PBOM and MBOM original data of a ship design manufacturing system, storing the data in a JSON format, and establishing a full life cycle xBOM unified model to display a BOM structure, wherein each BOM node has static properties of the data through packaging the data and behaviors; Step b, loading a hybrid mapping rule engine, executing the task of converting from EBOM to PBOM and from PBOM to MBOM, and dynamically selecting a mapping rule according to the difference of the node type and the application scene by adopting a rule-based driving mechanism; Step c, data consistency detection is carried out in the data conversion process, when data conflict is detected, the conflict is identified and classified, and one or more corresponding resolution strategies are selected according to the specific type of the conflict to solve the actual conflict problem; Step d, based on the premise of improving efficiency in the data conversion process, incremental updating is realized on an algorithm, and meanwhile, a cache mechanism is introduced into the system to reduce the load of a database, and the memory use is optimized by parallel processing of independent subtrees and lazy loading technology; And e, supporting user interaction and system integration through a Web interface and an API interface, and generating a manufacturing instruction after the system is subjected to data analysis processing.
  2. 2. The single data source based multiview BOM conversion method of claim 1, wherein the static properties of the BOM node in step a include the following: node ID is used as an identifier to ensure that each node can be accurately identified and referenced in a complex product structure; The node name is a name with descriptive properties, reflects the functions, positions or other key information of the nodes, provides visual identification for each node, and is convenient for engineers and technicians to understand and communicate; Node types, including assembly, parts, virtual, external, craft, resource types, to distinguish nodes of different nature, to achieve finer control and optimization in design, manufacturing, and supply chain management; an attribute dictionary, which is to provide additional information for each node, including size, material, cost and supplier, and to provide data support for the whole life cycle management of the product; and the child node list is used for referring to child nodes, embodying the layering property and recursion property of the BOM structure, and displaying the assembly relation and the hierarchical structure of the product through the child node list, thereby providing a foundation for the production plan and the material demand plan.
  3. 3. The single data source based multi-view BOM conversion method of claim 2, wherein said EBOM-to-PBOM conversion in step b follows the following mapping rules: Virtual piece deletion rules: Once the trigger condition is met, the system will perform a delete operation, remove the virtual node, and lift all its child nodes to the parent node level of the original virtual node; external collaboration piece folding rules: when the node type is identified as outsource, indicating that the node represents an export, the system will perform a folding operation, merge the export nodes into a single node, and add necessary supply chain attributes in the process, such as key information of vendor codes, purchase batches, etc.; professional equipment process planning rules When the node types are the corresponding equipment, system or component types of each specialty, the nodes generally represent equipment or components thereof in a specific specialty area, and on the nodes, the system adds specific process parameters required by the specialty area, including but not limited to installation methods, precision requirements and fastening standards, so as to ensure the correct installation and function implementation of the specialty equipment; security specification integration rules: when the node has electrical characteristics, adding safety attributes of explosion-proof requirements and insulation grades; the mapping rule followed for PBOM to MBOM conversion is as follows: rule of dividing electrical assembly units: When the node type is process, the process unit is miniaturized into a manufacturing unit; The special equipment resource binding rule is as follows: When the node needs special equipment, binding customized resources; Electric operation guidance refinement rules: When the node relates to electric installation, detailed operation guidance is formulated, including wiring sequence and terminal crimping parameters.
  4. 4. A single data source based multiview BOM conversion method as claimed in claim 3 wherein said resolving data conflicts in step c comprises the following specific contents: Step c 1 , adopting an attribute priority strategy to give priority to manufacturing view parameters, then process view parameters and finally design view parameters when processing data, so as to ensure that parameters which are closer to actual production requirements are preferentially processed; Step c 2 , recording the modification time of each parameter by using a time stamp strategy, and giving higher priority to the latest modified parameter when data conflict occurs, so that the real-time property and accuracy of the data are ensured, and the latest data can be timely reflected in a conversion result; Step c 3 , aiming at a specific industry, a special rule based on an industry specification is built in through a business rule strategy, so that parameters meeting the industry specification and safety standard are ensured to be processed preferentially in data conversion.
  5. 5. The single data source based multi-view BOM conversion method of claim 4, wherein said data conflict types include attribute conflicts, structural conflicts, and semantic conflicts, and said resolution strategies include manual intervention, automated merging, and rule-based solutions.
  6. 6. The single data source based multiview BOM conversion method of claim 4 or 5, wherein the delta update in step d comprises the following: Step d 1 , monitoring data change in real time by means of a trigger mechanism, and accurately capturing new adding, deleting and modifying operations to provide accurate change input for subsequent processing; d 2 , carrying out depth influence analysis on the captured change, carding the node range influenced by the change, constructing an influence sub-tree, and determining the changed propagation path and the related range; Step d 3 , implementing a local update strategy based on the influence subtree, and only adjusting the data of the affected part, so as to avoid the performance overhead caused by full update and improve the data processing efficiency; And d 4 , maintaining the data version history through the version management module, completely recording the detailed information of each change, supporting data rollback to cope with misoperation, and simultaneously providing a reliable basis for audit trails.
  7. 7. The single data source based multiview BOM conversion method of claim 6, wherein the depth influencing analysis in step d 2 comprises the following steps: The depth-first search is adopted to traverse the affected subtrees, the time complexity is O (n), n is the number of affected nodes, and the change processing is realized through the closed loop design of capturing, analyzing, updating and tracing.
  8. 8. The single data source based multiview BOM conversion method of claim 1 or 7, wherein the generating the manufacturing instructions in step e is automatically extracting design information, process separation, structural decomposition into manufacturable units, assembly sequence planning and dynamic adjustment of manufacturing resource allocation.
  9. 9. The single data source based multiview BOM conversion method of claim 5 or 7, wherein the whole process of resolving the conflict in the process of resolving the data conflict is recorded, including the adopted strategy, the executed steps and the final result.
  10. 10. The system adopting the single data source-based multi-view BOM conversion method as claimed in claim 7, wherein the system comprises a data layer, a rule layer, an engine layer and an execution layer, and the specific functions of each layer are as follows: The data layer is used for constructing a main data set based on a single data source and storing the EBOM, PBOM and MBOM data of the ship design and manufacturing system, and is used for establishing a unified model of a full life cycle xBOM by adopting a distributed database so as to support multi-user concurrent access and data version control; The rule layer comprises a mixed mapping rule base, a conflict resolution rule base and a ship design special rule base, and the rule layer stores rules in an XML format and supports dynamic loading and updating.
  11. 11. The engine layer comprises a mapping engine, a conflict resolution engine and an incremental updating engine, and adopts a micro-service architecture to support high concurrency processing.
  12. 12. The execution layer is used for providing a Web interface and an API interface by the conversion execution layer, supporting user interaction and system integration, and comprises an EBOM analysis module, a PBOM generation module and an MBOM optimization module, so that automatic extraction of design information, process separation, structural decomposition into manufacturable units, assembly sequence planning and dynamic adjustment of manufacturing resource allocation are realized.

Description

Multi-view BOM conversion method and system based on single data source Technical Field The invention belongs to the technical field of data management of complex products of ships, and particularly relates to a multi-view BOM conversion method and system based on a single data source. Background In the context of intelligent manufacturing and 4.0 advanced industry, ships are typically complex products, and the accuracy and efficiency of bill of materials (BOM) structure calculation have become a core bottleneck restricting the intelligent shipbuilding process. The ship is used as a typical representation with a high complexity of a structure, the number of single-ship material items exceeds 10 ten thousand, various views such as design, process, manufacture, maintenance and the like are more than 50, the whole life cycle span can reach more than 20 years, the component relevance is strong and is reflected in a multi-level nested assembly relation, each level of components from raw materials to a final product form an organic whole through tight level relevance, meanwhile, the ship BOM has obvious dynamic evolution characteristics of data, and dynamic events such as design change, process adjustment, manufacturing abnormality, operation and maintenance feedback and the like frequently trigger the real-time updating requirement of BOM data. However, the conventional BOM management mode faces multiple challenges when dealing with the characteristics, namely low design-manufacturing coordination efficiency is particularly shown as that the conversion process from the design BOM (EBOM) to the Manufacturing BOM (MBOM) is delayed, so that the design and manufacturing links are disjointed, a transmission chain is changed to break, engineering changes are difficult to synchronize to a manufacturing view in time, repeated adjustment of subsequent production links is caused, the problem of multi-source data island is prominent, and data standards among systems such as CAD (computer aided design), ERP (enterprise resource planning), maintenance and operation MRO (MRO) are not uniform and semantically inconsistent, so that information barriers are formed, and the problems directly lead to the prolongation of the ship building period and the waste of materials. In the current industrial intelligent wave, the shipbuilding industry is experiencing an unprecedented revolution. To accommodate this revolution, BOM management of ships must become more accurate and efficient. The complexity of a ship is not only in terms of its large number of items, but also in terms of the complexity of its design and manufacturing process. The design and manufacturing process of a ship involves numerous views including, but not limited to, design views, process views, manufacturing views, and operational views. The full life cycle span of a ship can reach over 20 years, which requires BOM management to be able to handle long-term data evolution. There is a close hierarchical relationship between the components of the vessel, which relationship extends from the raw materials to the final product, forming a multi-level nested assembly relationship such that each stage of components becomes an organic integral part of the overall product. Dynamic evolution characteristics of the BOM are remarkable, and dynamic events such as design change, process adjustment, manufacturing abnormality, operation and maintenance feedback and the like frequently trigger the real-time updating requirement of the BOM data. To effectively address these challenges and meet these needs, BOM management techniques must be continually innovated and improved to accommodate the ever-increasing and changing specifications. Within this particular area of marine manufacturing, the collaborative work of a variety of specialized views, including but not limited to the core views of EBOM, PBOM, and MBOM, is becoming increasingly critical. To ensure a smooth and efficient overall manufacturing process, seamless, efficient linkage between these different views is required to ensure accurate transfer and timely updating of information. These key requirements drive the continual iteration and upgrade of the BOM algorithm in terms of efficiency and accuracy in the hope of achieving a higher level of intelligence. Disclosure of Invention The technical problem to be solved by the invention is to provide a multi-view BOM conversion method and system based on a single data source, and the problems of inconsistent view data, disjointed process parameters and manufacturing resources and the like in the traditional method are solved by constructing a dynamic conflict resolution mechanism and a multi-view conversion method to realize the lossless conversion and data communication of EBOM, PBOM, MBOM. Embodiments of the present application are implemented as follows: the embodiment of the application provides a multi-view BOM conversion method based on a single data source, which is characte