A cable process three-data consistency verification and change linkage self-recovery method

Abstract

This invention discloses a method for consistency verification and change linkage self-healing of three data in cable manufacturing processes, relating to the field of cable management technology. The method includes: abstracting the cable product structure into a multi-layered nested tree or graph-like object, constructing a structural dependency graph and establishing a unified object model; performing process calculations for structural nodes based on a standard parameter library and formula library to obtain material usage and costs, and constructing a set of consistency constraints; generating a change dataset and locating the set of affected nodes based on dependencies; performing incremental recalculation on affected nodes, conducting consistency constraint verification, and forming a set of abnormal nodes; constructing a candidate repair operation set for abnormal nodes, transforming consistency repair into an optimization problem, defining a total repair cost function, and selecting the operation with the minimum unit cost using a greedy strategy; completing version recording after self-healing repair, and synchronizing the results to multiple systems through a linkage mechanism. This mechanism reduces manual repetitive calculations and cross-module verification operations, improving data consistency and computational reliability.

Description

Technical Field

[0001] This invention relates to the field of cable management technology, specifically to a method for verifying the consistency of three data points in cable manufacturing processes and for linking changes to achieve self-healing. Background Technology

[0002] Currently, cable manufacturers typically use the BOM and cost management modules of ERP systems, or combine them with general PLM / CAPP systems for process routing and product structure maintenance, in terms of process design and data management. While these systems can achieve basic process documentation and bill of materials management, they still have significant shortcomings in practical applications.

[0003] First, process data is stored in a scattered manner, resulting in chaotic version management. Process parameters, material quotas, and change records are often stored separately in the ERP system, independent CAPP modules, and Excel or paper documents, lacking a unified data model and centralized control mechanism. Effective version management and synchronization rules have not been established between systems, and historical changes are mostly handled through manual registration or overwrite updates, leading to unclear data sources and difficulty in tracing the change process. The root cause lies in the fact that the existing system is divided into modules according to business functions, lacking a unified structural model as a data source.

[0004] Secondly, process calculations rely on manual experience, limiting efficiency and accuracy. Key data such as material usage, electrical parameters, outer diameter dimensions, and time quotas are typically calculated manually by designers using tables or empirical formulas. For products with complex structures or numerous specifications, the calculation process is repetitive and prone to errors. While existing systems offer some calculation functions, they lack an automatic binding relationship between structural parameters and formula models, requiring manual intervention and hindering full-process automation.

[0005] Process data, BOM data, and cost data are maintained independently, lacking coordinated control. When structural parameters, material types, or prices change, the relevant BOM and cost data cannot be automatically updated, requiring separate modifications and verifications. This easily leads to inconsistencies in quotation, production scheduling, material requisition, and quality inspection data. The reason for this is that existing technology lacks cross-data domain mapping relationships and trigger-based back-calculation mechanisms, and has not established a unified data linkage model.

[0006] Therefore, constructing a linkage control mechanism centered on product structure, enabling automatic process calculation, and ensuring real-time consistency of process, BOM, and cost data has become a pressing technical problem to be solved in this field. Summary of the Invention

[0007] The purpose of this invention is to overcome the shortcomings of the prior art and provide a method for self-healing through consistency verification and change linkage of three data in cable manufacturing processes.

[0008] The objective of this invention is achieved through the following technical solution: This application discloses a method for consistency verification and change linkage self-healing of three data in cable manufacturing processes, including the following steps: S1. Abstract the cable product structure into a multi-layered nested tree or graph structure object, construct a structural dependency graph, and establish a unified object model based on the structural nodes; S2. Perform process calculations on structural nodes based on the standard parameter library and formula library to obtain material usage and cost, and construct a set of consistency constraints. S3. When the basic data, process templates, formula parameters or price library change, a set of changed data is formed, and then the set of affected nodes is obtained based on the dependency relationship. S4. Perform incremental recalculation on the affected node set, and at the same time perform consistency constraint verification during the calculation process, determine abnormal nodes and construct an abnormal node set; S5. Construct a set of candidate repair operations for abnormal nodes, transform the consistency repair problem into an optimization problem, define the total repair cost function, and use a greedy strategy to gradually select the repair operation with the minimum unit cost until the consistency constraint is satisfied. S6. After completing the self-healing repair, record the version and then synchronize the consistency results to ERP, MES, QMS and quotation system through the linkage mechanism to achieve data unification of multiple systems.

[0009] Further, step S1 specifically includes: constructing a structural dependency graph as follows: ,in, Represents a set of structural nodes. This represents the dependency relationship between nodes, for the structural nodes in the set of structural nodes. Bind its corresponding process parameters Material collection and cost This forms a unified object model that includes structural nodes, process parameters, material items, and costs; among which, the material set... From process parameters Driven generation, i.e. ,in, Represents the generating function, cost From process parameters and material collection Joint decision, that is ,in, This represents the cost calculation function.

[0010] Preferably, step S2 specifically includes: based on the standard parameter library and formula library Process calculations are performed on structural nodes to obtain material usage and costs, including costs. satisfy ,in Indicates the quantity of materials. Represent the unit price of the material; construct a set of consistency constraints based on this. The construction of the consistency constraint set Including parameter range constraints Structural matching constraints and three-data consistency constraints ,in, Indicates the consistency threshold. This represents the cost value derived from the BOM. Indicate process parameters The lower bound constraint, Indicate process parameters Upper bound constraints; and through the consistency constraint set Establish a consistency control model.

[0011] Preferably, step S3 specifically includes: the formed change data set is Using structural dependency graphs Based on the change of data set Initialize the set of affected nodes and along the dependency relationship To spread, among which For any node in the set of structure nodes V, let all nodes satisfying the condition be represented by V. The node is added to the set of affected nodes. until the set of affected nodes. Convergence, i.e. , This represents the set of affected nodes updated after the (t+1)th iteration of dependency propagation. This represents the set of affected nodes updated after the t-th iteration of dependency propagation.

[0012] Preferably, step S4 specifically includes: targeting the set of affected nodes. Perform incremental recalculation using the formula library. Update the material set and cost, i.e. , ,in This represents the updated set of materials. Indicates the updated cost. This represents the k-th computational function in the formula library F, and simultaneously performs consistency constraint checks during the computation process, that is, for any constraint... If it exists , If the Boolean decision result indicates that the constraint is not satisfied, then the node is determined to be abnormal, and a set of abnormal nodes is constructed. This enables the automatic detection and location of data conflicts and process errors.

[0013] Preferably, step S5 specifically includes: targeting the set of abnormal nodes. Construct a set of candidate repair operations The set of candidate repair operations This includes parameter adjustment, material replacement, process switching, and cost recalculation; the total repair cost function is... ,in, Indicates the number of entries modified. The weighting coefficient represents the number of modified entries. Indicates the degree of impact on existing orders. Weighting coefficients representing the degree of impact on orders in production. Indicates the cost of cross-system synchronization. The weighting coefficient represents the cost of cross-system synchronization.

[0014] Preferably, the greedy strategy described in step S5 includes dividing the overall repair problem into multiple consecutive local decision steps during the consistency repair process, and prioritizing the repair operation with the lowest current cost in each step, thereby gradually achieving overall consistency restoration.

[0015] Preferably, step S6 specifically includes: after completing the self-healing repair, generating a set of changes. Set of affected nodes The version record of the repair operation set, and the data before the repair are also recorded. and repaired data The differences were then addressed; subsequently, the consistency results were synchronized to the ERP, MES, QMS, and quotation systems through a linkage mechanism. If an anomaly or rollback requirement was detected, a rollback operation was performed based on the version record to restore the system to a previous version.

[0016] The beneficial effects of this invention are: 1) This invention uses a unified structural dependency graph as the sole computational basis for the three types of data, constructing a deterministic mapping relationship between structural nodes and process parameters, material items, and cost items. A formula-driven mechanism is used to achieve the unified generation and evolution of process data, BOM data, and cost data. Since the three types of data originate from the same structural object and are calculated and verified under the combined influence of parameter constraints, structural constraints, and consistency constraints, automatic back-calculation and synchronous updates can be performed within the model when structural parameters or basic data change. This mechanism reduces manual repetitive calculations and cross-module verification operations, lowers human error, and improves data consistency and computational reliability.

[0017] 2) During change processing, this invention constructs an impact propagation mechanism based on structural dependencies, automatically identifies the set of affected nodes, and performs incremental calculations and consistency checks only on the relevant nodes, avoiding redundant calculations and system resource consumption caused by traditional full recalculation. This incremental propagation mechanism effectively reduces the calculation scope, lowers database access pressure, and improves system response efficiency and concurrent processing capabilities, making it particularly suitable for multi-layered nested structures and complex process scenarios.

[0018] 3) This invention transforms data conflict handling into a cost function-based optimization process through a consistency constraint model and self-healing optimization mechanism. It automatically selects the minimum-cost repair strategy, achieving coordinated repair and consistency restoration of three types of data. This reduces manual investigation and repeated adjustments, lowering the risk of misoperation during the change process. Through versioned recording and a multi-system synchronization mechanism, it enables traceable management and rollback control of the data change process, ensuring consistent data sources and unified status across business systems, thereby improving the stability of the overall data chain and the reliability of system operation. Attached Figure Description

[0019] Figure 1 This is a schematic diagram illustrating the steps of a cable manufacturing process three-data consistency verification and change linkage self-healing method according to an embodiment of the present invention. Detailed Implementation

[0020] The technical solution of the present invention will be clearly and completely described below with reference to the embodiments. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0021] This application discloses a method for consistency verification and change-linked self-healing of three types of data in cable manufacturing processes. Taking product structure as the core, it constructs a unified mapping relationship between process data, BOM data, and cost data. Through dependency propagation, incremental calculation, consistency verification, and minimum-cost optimization repair, it achieves automatic consistency maintenance and controllable evolution of the three types of data during the change process. A schematic diagram of the method's steps is shown below. Figure 1 As shown, the specific steps include: S1. Abstract the cable product structure into a multi-layered nested tree or graph structure object, construct a structural dependency graph, and establish a unified object model based on the structural nodes; S2. Perform process calculations on structural nodes based on the standard parameter library and formula library to obtain material usage and cost, and construct a set of consistency constraints. S3. When the basic data, process templates, formula parameters or price library change, a set of changed data is formed, and then the set of affected nodes is obtained based on the dependency relationship. S4. Perform incremental recalculation on the affected node set, and at the same time perform consistency constraint verification during the calculation process, determine abnormal nodes and construct an abnormal node set; S5. Construct a candidate repair operation set for abnormal nodes, transforming the consistency repair problem into an optimization problem. Define a total repair cost function, and with the objective of minimizing the total repair cost, use a greedy strategy to progressively select the repair operation with the minimum unit cost until the consistency constraint is satisfied. This step realizes the three data (process parameters) Material collection and cost Automatic repair and consistency restoration; S6. After completing the self-healing repair, record the version and then synchronize the consistency results to ERP, MES, QMS and quotation system through the linkage mechanism to achieve data unification of multiple systems.

[0022] For example, step S1 specifically includes: constructing a structural dependency graph as follows: ,in, Represents a set of structural nodes. This represents the dependency relationship between nodes, for the structural nodes in the set of structural nodes. Bind its corresponding process parameters Material collection and cost This forms a unified object model including structural nodes, process parameters, material items, and costs; and establishes a generation mechanism for three types of data through function mapping relationships, including material sets. From process parameters Driven generation, i.e. ,in, This represents the material generation function, used to generate materials based on structural nodes. process parameters Calculate the corresponding material set It is used to describe the mapping relationship between process parameters (such as size, number of layers, material type, etc.) and material usage, cost. From process parameters and material collection Joint decision, that is This enables a unified representation of design BOM, quotation BOM, manufacturing BOM, and cost data. This represents a cost calculation function used to calculate costs based on materials. and process parameters Calculate structural nodes Cost This function takes into account material usage, material unit price, and relevant process parameters to generate the corresponding cost results.

[0023] For example, step S2 specifically includes: based on the standard parameter library and formula library Process calculations are performed on structural nodes to obtain material usage and costs, including costs. satisfy ,in Indicates the quantity of materials. Represent the unit price of the material; construct a set of consistency constraints based on this. The construction of the consistency constraint set Including parameter range constraints Structural matching constraints (compatibility of processes, equipment, and materials between adjacent nodes) and three-data consistency constraints ,in, Indicates the consistency threshold. This represents the cost value derived from the BOM. Indicate process parameters The lower bound constraint represents the minimum range of values ​​allowed in the current process specification or standard parameter library. Indicate process parameters The upper bound constraint represents the maximum allowed range of values ​​within the current process specification or standard parameter library; and is expressed through a set of consistency constraints. Establish a consistency control model.

[0024] For example, step S3 specifically includes: the formed change data set is Using structural dependency graphs Based on the change of data set Initialize the set of affected nodes and along the dependency relationship Propagation (dependency) Represents a node The calculation of process parameters, material sets, or cost values ​​depends on nodes. The data results, that is, when the node When process parameters, materials, or costs change, it will directly or indirectly affect the node. The calculation results), where For any node in the set of structure nodes V, let all nodes satisfying the condition be represented by V. The node is added to the set of affected nodes. until the set of affected nodes. Convergence, i.e. , This represents the set of affected nodes updated after the (t+1)th iteration of dependency propagation. Let represent the set of affected nodes updated after the t-th round of dependency propagation iteration, when When the propagation process reaches a stable state, there are no more newly affected nodes; this process enables automatic identification of the impact range on process routes, BOM level nodes, and cost items.

[0025] For example, step S4 specifically includes: targeting the set of affected nodes Perform incremental recalculation using the formula library. Update the material set and cost, i.e. , ,in This represents the updated set of materials. Indicates the updated cost; This represents the k-th computational function in the formula library F, and simultaneously performs consistency constraint checks during the computation process, that is, for any constraint... If it exists , If the Boolean decision result indicates that the constraint is not met (used to identify cases where the node has data conflicts, inconsistencies, or violates process rules), then the node is determined to be abnormal, and a set of abnormal nodes is constructed. This enables the automatic detection and location of data conflicts and process errors.

[0026] For example, step S5 specifically includes: targeting the set of abnormal nodes Construct a set of candidate repair operations The set of candidate repair operations This includes operations such as parameter adjustment, material replacement, process switching, and cost recalculation; the total repair cost function is... ,in, Indicates the number of entries modified. The weighting coefficient represents the number of modified entries. Indicates the degree of impact on existing orders. Weighting coefficients representing the degree of impact on orders in production. Indicates the cost of cross-system synchronization. The weighting coefficient represents the cost of cross-system synchronization.

[0027] For example, the greedy strategy described in step S5 includes dividing the overall repair problem into multiple consecutive local decision steps during the consistency repair process, prioritizing the repair operation with the lowest current cost in each step, thereby gradually achieving overall consistency restoration; specifically, it includes the following process: (1) generating a set of candidate repair operations for the set of abnormal nodes, with each repair operation corresponding to the adjustment method of process parameters, material items, or cost data; (2) evaluating each candidate repair operation according to a pre-set cost function, calculating its comprehensive cost to the modification scale, business impact, and system synchronization cost; (3) selecting the operation with the lowest current cost from the candidate repair operations and executing it, updating the relevant node data; (4) after executing the repair operation, re-verifying the consistency constraints and updating the set of abnormal nodes; (5) repeating the above process until all consistency constraints are satisfied or there are no feasible repair operations. Through the above strategy, prioritizing the locally optimal repair scheme in each step, the overall consistency problem is gradually repaired while ensuring the controllability of the calculation process.

[0028] For example, step S6 specifically includes: after completing the self-healing repair, generating a set of changes. Set of affected nodes The version record of the repair operation set, and the data before the repair are also recorded. and repaired data The differences are then addressed; subsequently, the consistency results are synchronized to the ERP, MES, QMS and quotation systems through a linkage mechanism. If an anomaly or rollback requirement is detected, a rollback operation is performed based on the version record to restore to the historical version, thereby achieving full-process traceability and controllable evolution.

[0029] In summary, this invention addresses the problems of fragmented maintenance of process data, BOM data, and cost data in existing cable CAPP systems, reliance on manual synchronization for changes, and difficulty in ensuring data consistency. It uses a product structure dependency graph as the sole data carrier, constructing a unified object model of "structural nodes—process parameters—material items—costs." Through formula-driven deterministic mapping relationships between process parameters and materials and costs, the three types of data are generated and updated uniformly under the same model. Under this mechanism, material usage and costs are calculated using a formula library and parameter system. A unified constraint model is constructed by combining parameter range constraints, structural matching constraints, and three-data consistency constraints, ensuring data consistency during generation and shifting from post-event verification to process control. When basic data or process parameters change, impact propagation is performed based on structural dependencies, automatically identifying the affected node set and performing incremental calculations and consistency checks to avoid full recalculation, improve system response efficiency, and ensure synchronized data updates. When consistency conflicts are detected, a candidate repair operation set is constructed and a cost function is introduced, transforming data repair into a minimum-cost optimization problem. The optimal repair strategy is automatically selected, achieving interconnected self-healing and consistency restoration of the three data sets. Furthermore, by employing versioned records and multi-system synchronization mechanisms, the data change process is made traceable and rollback-capable. Thus, this invention constructs an integrated automatic consistency control method based on structural models, constraint calculations, and optimization decisions, significantly improving data consistency, change controllability, and system stability.

[0030] The above description is merely a preferred embodiment of the present invention. It should be understood that the present invention is not limited to the forms disclosed herein and should not be construed as excluding other embodiments. It can be used in various other combinations, modifications, and environments, and can be altered within the scope of the concept described herein through the above teachings or related technologies or knowledge. Modifications and variations made by those skilled in the art that do not depart from the spirit and scope of the present invention should be within the protection scope of the appended claims.

Claims

1. A cable process three-data consistency check and change linkage self-recovery method, characterized in that, Includes the following steps: S1. Abstract the cable product structure into a multi-layered nested tree or graph structure object, construct a structural dependency graph, and establish a unified object model based on the structural nodes; S2. Perform process calculations on structural nodes based on the standard parameter library and formula library to obtain material usage and cost, and construct a set of consistency constraints. S3. When the basic data, process templates, formula parameters or price library change, a set of changed data is formed, and then the set of affected nodes is obtained based on the dependency relationship. S4. Perform incremental recalculation on the affected node set, and at the same time perform consistency constraint verification during the calculation process, determine abnormal nodes and construct an abnormal node set; S5. Construct a set of candidate repair operations for abnormal nodes, transform the consistency repair problem into an optimization problem, define the total repair cost function, and use a greedy strategy to gradually select the repair operation with the minimum unit cost until the consistency constraint is satisfied. S6. After completing the self-healing repair, record the version and then synchronize the consistency results to ERP, MES, QMS and quotation system through the linkage mechanism to achieve data unification of multiple systems.

2. The cable manufacturing process three-data consistency verification and change linkage self-healing method according to claim 1, characterized in that, Step S1 specifically includes: constructing the structural dependency graph as follows ,in, Represents a set of structural nodes. This represents the dependency relationship between nodes, for the structural nodes in the set of structural nodes. Bind its corresponding process parameters Material collection and cost This forms a unified object model that includes structural nodes, process parameters, material items, and costs; among which, the material set... From process parameters Driven generation, i.e. ,in, Represents the generating function, cost From process parameters and material collection Joint decision, that is ,in, This represents the cost calculation function.

3. The cable manufacturing process three-data consistency verification and change linkage self-healing method according to claim 2, characterized in that, Step S2 specifically includes: based on the standard parameter library and formula library Process calculations are performed on structural nodes to obtain material usage and costs, including costs. satisfy ,in Indicates the quantity of materials. Represent the unit price of the material; construct a set of consistency constraints based on this. The construction of the consistency constraint set Including parameter range constraints Structural matching constraints and three-data consistency constraints ,in, Indicates the consistency threshold. This represents the cost value derived from the BOM. Indicate process parameters The lower bound constraint, Indicate process parameters Upper bound constraints; and through a set of consistency constraints Establish a consistency control model.

4. The cable manufacturing process three-data consistency verification and change linkage self-healing method according to claim 3, characterized in that, Step S3 specifically includes: the resulting set of changed data is Using structural dependency graphs Based on the change of data set Initialize the set of affected nodes and along the dependency relationship To spread, among which For any node in the set of structure nodes V, let all nodes satisfying the condition be represented by V. The node is added to the set of affected nodes. until the set of affected nodes. Convergence, i.e. , This represents the set of affected nodes updated after the (t+1)th iteration of dependency propagation. This represents the set of affected nodes updated after the t-th iteration of dependency propagation.

5. The cable manufacturing process three-data consistency verification and change linkage self-healing method according to claim 4, characterized in that, Step S4 specifically includes: targeting the set of affected nodes Perform incremental recalculation using the formula library. Update the material set and cost, i.e. , ,in This represents the updated set of materials. Indicates the updated cost. This represents the k-th computational function in the formula library F, and simultaneously performs consistency constraint checks during the computation process, that is, for any constraint... If it exists , If the Boolean decision result indicates that the constraint is not satisfied, then the node is determined to be abnormal, and a set of abnormal nodes is constructed. This enables the automatic detection and location of data conflicts and process errors.

6. The cable manufacturing process three-data consistency verification and change linkage self-healing method according to claim 5, characterized in that, Step S5 specifically includes: targeting the set of abnormal nodes Construct a set of candidate repair operations The candidate repair operation set This includes parameter adjustment, material replacement, process switching, and cost recalculation; the total repair cost function is... ,in, Indicates the number of entries modified. The weighting coefficient represents the number of modified entries. Indicates the degree of impact on existing orders. Weighting coefficients representing the degree of impact on orders in production. Indicates the cost of cross-system synchronization. The weighting coefficient represents the cost of cross-system synchronization.

7. The cable manufacturing process three-data consistency verification and change linkage self-healing method according to claim 6, characterized in that: The greedy strategy described in step S5 involves dividing the overall repair problem into multiple consecutive local decision steps during the consistency repair process. In each step, the repair operation with the lowest current cost is selected first, thereby gradually achieving overall consistency restoration.

8. The cable manufacturing process three-data consistency verification and change linkage self-healing method according to claim 7, characterized in that, Step S6 specifically includes: after completing the self-healing repair, generating a set of changes. Set of affected nodes The version record of the repair operation set, and the data before the repair are also recorded. and repaired data The differences were then addressed; subsequently, the consistency results were synchronized to the ERP, MES, QMS, and quotation systems through a linkage mechanism. If an anomaly or rollback requirement was detected, a rollback operation was performed based on the version record to restore the system to a previous version.

Images