Data calculation method and system applicable to biopharmaceutical production process

Abstract

The present invention provides a data calculation method and system applicable to the biopharmaceutical production process, which relates to the field of data processing. The method includes: establishing a configuration component library based on the biopharmaceutical production process data, where the configuration component library is used to store calculation unit components; establishing a formula library based on the biopharmaceutical production process data; generating an electronic record template based on the configuration component library and the formula library; obtaining a user operation instruction through the electronic record template; obtaining a target formula from the formula library based on the user operation instruction, and binding a calculation unit component to the variable in the target formula; parsing the dependency relationship between the target formulas through a calculation formula configurator to generate a calculation chain path diagram, and performing integrity and execution feasibility verification on the calculation chain path diagram; after the integrity and execution feasibility verification pass, completing the calculation based on the calculation chain path diagram and outputting the calculation result, which has the advantages of improving the efficiency and accuracy of data calculation in the biopharmaceutical production process.

Description

Technical Field

[0001] The present invention relates to the field of data processing, and particularly to a data calculation method and system applicable to the production process of biopharmaceuticals. Background Art

[0002] In the production process of pharmaceuticals, there are various types of calculations. For example, in the calculation of the culture medium formula, it is necessary to precisely adjust the concentration of each component according to different cell lines and culture conditions to ensure cell growth and product synthesis. Another example is that when calculating the material balance, it is often necessary to first count the total output and total consumption, and then calculate the overall material balance. These calculations have various forms and are interrelated, providing reliable data calculations for production process control and quality inspection data reporting, with the remarkable characteristics of time correlation, logical complexity, and repeated reference. Providing various calculations during the production process is a very important core function of the Manufacturing Execution System (MES), and its precise and efficient operation is a necessary guarantee for realizing precise control of the entire production process and ensuring production quality.

[0003] In the relevant calculation designs of existing MES software, most adopt relatively fixed and rigid designs, that is: corresponding formulas are introduced / configured and algorithm implementations are carried out in the required calculation links or the data to be filled in. There are at least the following three problems:

[0004] 1. The workload of calculation design is large, and there are situations where the same formula algorithms are repeatedly referenced;

[0005] 2. The verification workload of algorithm calculation is large, and debugging and modification are troublesome;

[0006] 3. Since a biopharmaceutical enterprise has complex multiple production control lines, in a complex formula configuration calculation, there will be more than 1000 reference formulas, and there may be circular references, which will cause the inability to calculate effective results and even errors. For example, when configuring formula (1): A = B + C, and then configuring formula (2): B = A + D; when applying formula (1) to calculate A, substituting formula (2) into formula (1) will result in a circular reference to A and the inability to calculate the result.

[0007] Therefore, it is necessary to provide a data calculation method and system applicable to the production process of biopharmaceuticals to improve the efficiency and accuracy of data calculation in the production process of biopharmaceuticals. Summary of the Invention

[0008] The present invention provides a data calculation method applicable to the biopharmaceutical production process, aiming to solve the problems of complex formula configuration, low execution efficiency, and inconvenient result management in the existing calculation process, including: establishing a configuration component library based on the biopharmaceutical production process data, wherein the configuration component library is used to store calculation unit components; establishing a formula library based on the biopharmaceutical production process data, wherein the formula library is used to store multiple formulas; generating an electronic record template based on the configuration component library and the formula library; obtaining a user operation instruction through the electronic record template; obtaining a target formula from the formula library based on the user operation instruction, and binding a calculation unit component to the variable in the target formula; parsing the dependency relationship between target formulas through a calculation formula configurator, generating a calculation chain path diagram, and performing integrity and execution feasibility verification on the calculation chain path diagram; after the integrity and execution feasibility verification pass, completing the calculation based on the calculation chain path diagram and outputting the calculation result.

[0009] Further, the calculation unit component has a unique identifier, a parameter type, a data source, and a calculation logic.

[0010] Further, parsing the dependency relationship between target formulas through a calculation formula configurator and generating a calculation chain path diagram includes: S11, constructing a topological sequence diagram for storing the identifier of the calculation unit component or formula and its index in the dependency relationship diagram; S12, constructing a dependency relationship diagram for recording the dependent calculation unit components of the calculation unit component or formula; S13, constructing a reverse reference mapping table for recording the reverse reference relationship corresponding to each calculation unit component; S14, inputting the current target formula or target calculation unit component; S15, updating the topological sequence diagram and the dependency relationship diagram based on the current target formula or target calculation unit component; S16, detecting whether the dependency chain of the current target formula or target calculation unit component forms a loop. If so, generating an exception prompt message and ending the execution. If not, updating the reverse reference mapping table and executing S17; S17, determining whether all target formulas or target calculation unit components have been input. If so, generating a calculation chain path diagram and ending the execution. If not, executing S18; S18, obtaining the next target formula or target calculation unit component as the current target formula or target calculation unit component and executing S14.

[0011] Further, updating the topological sequence diagram and the dependency relationship diagram based on the current target formula or target calculation unit component includes: updating the topological sequence diagram with the unique identifier of the current target formula or target calculation unit component as the key and its index in the dependency relationship diagram as the value; updating the dependency relationship diagram based on the list of unique identifiers of the dependent calculation unit components of the current target formula or target calculation unit component.

[0012] Further, update the reverse reference mapping table, including: constructing a bidirectional mapping tool according to the topological sequence diagram; traversing each node and its dependent nodes in the dependency graph to generate the reverse reference relationship of the nodes, where a node represents a computing unit component or a formula, and based on the bidirectional mapping tool, construct the reference mapping corresponding to each dependent node of the node and record it in the reverse reference mapping table.

[0013] Further, detect whether the dependency chain of the current target formula or target computing unit component forms a loop, including: detecting whether the dependency chain of the current target formula or target computing unit component forms a loop through a depth-first search algorithm.

[0014] Further, detecting whether the dependency chain of the current target formula or target computing unit component forms a loop through a depth-first search algorithm includes: establishing an access status array and a path status array, where the access status array is used to mark whether a node has been fully accessed, and the path status array is used to mark the nodes in the current recursive path; starting from the node of the current target formula or target computing unit component, update the path status array, and for each adjacent node, if the adjacent node is not in the current recursive path, recursively call the depth-first search, and if the adjacent node is in the current recursive path, determine that the dependency chain of the current target formula or target computing unit component forms a loop.

[0015] Further, generate a calculation chain path diagram, including: generating a calculation chain path diagram based on topological sorting.

[0016] Further, generating a calculation chain path diagram based on topological sorting includes: S21. For each node, calculate the in-degree of the node, where the in-degree is used to represent the number of parameters of the target formula or target computing unit component; S22. Add all nodes with an in-degree of 0 to the queue as the starting point of the calculation; S23. Take out a node from the queue, and according to the reverse reference mapping table, subtract 1 from the in-degree of the node that references the node with an in-degree of 0. If the in-degree of the node that references the node with an in-degree of 0 becomes 0 after subtracting 1, add this node that references the node with an in-degree of 0 to the queue; S24. Determine whether the queue is empty. If it is, generate a calculation chain path diagram. If not, execute S23.

[0017] The present invention provides a data calculation system applicable to the biopharmaceutical production process, aiming to solve the problems of complex formula configuration, low execution efficiency, and inconvenient result management in the existing calculation process. The data calculation method applicable to the biopharmaceutical production process is applied, including: configuring a component library for storing calculation unit components, wherein each of the calculation unit components has a unique identifier, a parameter type, a data source, and a calculation logic, and the calculation unit components are generated based on the biopharmaceutical production process data; a formula library for storing a plurality of formulas, and the plurality of formulas are generated based on the biopharmaceutical production process data; an instruction acquirer for generating an electronic record template based on the configuration component library and the formula library, and obtaining a user operation instruction through the electronic record template; a calculation formula configurator for obtaining a target formula from the formula library based on the user operation instruction, binding a calculation unit component to a variable in the target formula, parsing the dependency relationship between the target formulas, generating a calculation chain path diagram, and performing integrity and execution feasibility verification on the calculation chain path diagram; and an automatic calculator for completing the calculation based on the calculation chain path diagram and outputting a calculation result after the integrity and execution feasibility verification of the calculation chain path diagram pass.

[0018] Compared with the prior art, the data calculation method and system applicable to the biopharmaceutical production process provided by the present invention have at least the following beneficial effects:

[0019] 1. All calculations are composed of calculation unit components in combination, which facilitates the completion of complex calculation processes through simple combination; this combination is realized by the method of generating a chain calculation path. When there are multiple calculation paths, it is beneficial to simplify and optimize the calculation path, thereby improving the calculation efficiency; and it can be quickly verified to check for the situation of repeatedly referencing formulas.

[0020] 2. It supports checking for loops at any time during the dynamic construction process of the calculation chain path diagram, and is applicable to the incremental configuration and modification of calculation unit components. When a loop is detected, the operation is immediately terminated and a clear error message is provided, reducing the subsequent troubleshooting difficulty. Ensure that the dependency chain of each calculation unit component is legal and avoid the problem of infinite loop in the calculation link caused by the loop.

[0021] 3. It can dynamically add calculation unit components and check for loops during the addition to ensure the correctness of the dependency chain. Dependency parsing and link generation: By constructing a reverse reference mapping table and calculating the in-degree, the dependency relationship between components is clearly parsed to generate a calculation chain path diagram. Using topological sorting to parse the link in sequence and complete the calculation tasks in order, supporting dynamic update and real-time execution. Description of the Drawings

[0022] This specification will be further described by way of exemplary embodiments, which will be described in detail with reference to the accompanying drawings. These embodiments are not restrictive. In these embodiments, the same numbers represent the same structures, where:

[0023] Figure 1 is a schematic flow chart of a data calculation method applicable to the biopharmaceutical production process shown in some embodiments of this specification;

[0024] Figure 2 is a schematic diagram of a newly added formula shown in some embodiments of this specification;

[0025] Figure 3 is a schematic diagram of an electronic record template shown in some embodiments of this specification;

[0026] Figure 4 is a schematic diagram of the modules of a data calculation system applicable to the biopharmaceutical production process shown in some embodiments of this specification;

[0027] Figure 5 is a schematic diagram of a calculation chain path diagram shown in some embodiments of this specification. Detailed implementation manners

[0028] To more clearly illustrate the technical solutions of the embodiments of this specification, the accompanying drawings required for the description of the embodiments will be briefly introduced below. Obviously, the accompanying drawings in the following description are only some examples or embodiments of this specification. For those of ordinary skill in the art, without creative efforts, this specification can also be applied to other similar scenarios based on these drawings. Unless obvious from the language context or otherwise stated, the same reference numerals in the figures represent the same structures or operations.

[0029] The data calculation method and system applicable to the biopharmaceutical production process described in this specification are not limited to the data calculation in the biopharmaceutical production process, but can also be applied to other scenarios that require data calculation. For example, chemical engineering, food processing scenarios, etc.

[0030] Figure 1 is a schematic flow chart of a data calculation method applicable to the biopharmaceutical production process shown in some embodiments of this specification. As Figure 1 shown, the data calculation method applicable to the biopharmaceutical production process may include the following steps.

[0031] Step 110, based on the biopharmaceutical production process data, establish a configuration component library.

[0032] The configuration component library is used to store calculation unit components. A calculation unit component has a unique identifier, parameter type (e.g., numeric value, text, etc.), data source (e.g., manual entry, automatic collection, etc.), and calculation logic. A calculation unit component can reference other calculation unit components to form a recursive relationship. For example, the value of a calculation unit component can be calculated by the summation formula of multiple calculation unit components.

[0033] Users can dynamically create new computing unit components based on biopharmaceutical production process data and incorporate them into component library management.

[0034] The configuration component library supports the real-time input, modification and historical record query of calculation unit components. As a basic module, the configuration component library provides parameter support for the generation of formula libraries, electronic record templates and calculation links.

[0035] Step 120, establishing a formula library based on biopharmaceutical production process data.

[0036] The formula library is used to store multiple formulas. Multiple formulas can be a set of verified formulas required for the calculation of biopharmaceutical production process data, containing information such as formula name, formula parameters, and formula calculation results. For example, the geometric mean formula: describes the concentration of drugs at different time points, which can more accurately reflect the overall trend of these concentrations and avoid the influence of extreme values. Another example is the material balance formula: a key indicator to measure whether the production process complies with the predetermined input and output rules.

[0037] Each formula describes a specific calculation logic, supports user-defined formulas and verifies their correctness, and is referenced by electronic record template configuration components.

[0038] Figure 2 is a schematic diagram of a newly added formula shown in some embodiments of this specification, such as Figure 2 As shown, the formula library supports user-defined formula structures and associates specific calculation unit components as parameters. For example, in formula C=A / B, the unique identifier of the associated calculation unit component A is 93, and the unique identifier of the associated calculation unit component B is 94.

[0039] The formula library has the ability to verify the mathematical logic and variable dependencies of the formula to ensure correctness. The defined formula can be stored in the formula library for direct call by other templates or components. The formula library supports advanced calculation logic (such as conditional branching, iterative calculation, etc.) and parameterized formula design.

[0040] Step 130, generating an electronic record template based on the configuration component library and the formula library.

[0041] An electronic record template is a framework for carrying computing unit components and formulas, supporting flexible configuration and customization. Each electronic record template can be regarded as a virtual worksheet, containing specific computing unit components and their associated formula logics.

[0042] Step 140, obtain a user operation instruction through the electronic record template.

[0043] Step 150, obtain a target formula from the formula library based on the user operation instruction, and bind computing unit components to the variables in the target formula.

[0044] The target formula can be a formula selected by the user.

[0045] The user can freely layout computing unit components on the electronic record template and associate relevant formulas. Adding, deleting, or modifying computing unit components in the template is supported, and the calculation relationship is updated in real time.

[0046] The electronic record template provides a graphical interface where the user can drag and drop computing unit components and set their positions, associations, and calculation logics.

[0047] Different electronic record templates can be deployed and presented according to the actual usage scenarios of the user. For example, Figure 3 is a schematic diagram of an electronic record template shown in some embodiments of this specification. As Figure 3 shown, in the material balance calculation template, the user can design an electronic record template containing actual values, theoretical values, and their difference values, and embed computing unit components (such as numbers 93, 92, etc.).

[0048] Step 160, parse the dependency relationships between target formulas through a calculation formula configurator, generate a calculation chain path diagram, and perform integrity and execution feasibility checks on the calculation chain path diagram.

[0049] In some embodiments, parsing the dependency relationships between target formulas through a calculation formula configurator to generate a calculation chain path diagram includes:

[0050] S11. Construct a topological sequence diagram for storing the identifiers of computing unit components or formulas and their indices in the dependency relationship diagram;

[0051] S12. Construct a dependency relationship diagram for recording the dependent computing unit components of computing unit components or formulas;

[0052] S13. Construct a reverse reference mapping table for recording the reverse reference relationships corresponding to each computing unit component;

[0053] S14. Input the current target formula or target computing unit component, where the target computing unit component can be a computing unit component associated with the target formula;

[0054] S15. Update the topological sequence graph and the dependency graph based on the current target formula or target calculation unit component;

[0055] S16. Detect whether the dependency chain of the current target formula or target calculation unit component forms a loop. If so, generate an exception prompt message and end the execution. If not, update the reverse reference mapping table and execute S17;

[0056] S17. Determine whether all target formulas or target calculation unit components have completed input. If so, generate a calculation chain path graph and end the execution. If not, execute S18;

[0057] S18. Obtain the next target formula or target calculation unit component as the current target formula or target calculation unit component, and execute S14.

[0058] Specifically, constructing a calculation chain path graph is to express and display the dependency relationships between calculation unit components, providing reliable storage and parsing for reference calculations.

[0059] The topological sequence graph (map) is used to store the identifiers of calculation unit components or formulas and their indexes in the dependency graph. The Key represents the unique identifier of the calculation unit component or formula, and the Value is the index of this calculation unit component or formula in the dependency graph (graph). Through the topological sequence graph (map), the relevant information of a certain node (calculation unit component or formula) can be quickly located.

[0060] The reverse reference mapping table (valueMap) records the reverse reference relationships corresponding to each calculation unit component for subsequent calculation of in-degree and generation of dependency chains. The Key represents a certain calculation unit component, and the Value is the list of components that reference this calculation unit component (reverse reference).

[0061] As an example, two formulas are added successively:

[0062] A = B + C

[0063] B = D + E

[0064] In the topological sequence graph (map), there is data {A = 0, B = 1}, indicating that the data referenced by A in the dependency graph (graph) is the 0th element of the array, and the data referenced by B is the 1st element of the array.

[0065] In the dependency graph (graph), there is data [[B, C], [D, E]].

[0066] There is data in the reverse reference mapping table (valueMap) {B = [A], C = [A], D = [B], E = [B]}, indicating that B is referenced by A, C is referenced by A, D is referenced by B, and E is referenced by B.

[0067] In some embodiments, based on the current target formula or target calculation unit component, update the topological sequence diagram and the dependency graph, including:

[0068] Update the topological sequence diagram with the unique identifier of the current target formula or target calculation unit component as the key and the index in the dependency graph as the value;

[0069] Update the dependency graph based on the list of unique identifiers of the dependent calculation unit components of the current target formula or target calculation unit component.

[0070] In some embodiments, update the reverse reference mapping table, including:

[0071] Construct a two-way mapping tool according to the topological sequence diagram;

[0072] Traverse each node and its dependent nodes in the dependency graph to generate the reverse reference relationship of the nodes. Among them, a node represents a calculation unit component or formula. Based on the two-way mapping tool, construct the reference mapping corresponding to each dependent node of the node and record it in the reverse reference mapping table.

[0073] In some embodiments, detect whether the dependency chain of the current target formula or target calculation unit component forms a loop, including:

[0074] Detect whether the dependency chain of the current target formula or target calculation unit component forms a loop through the depth-first search algorithm, which can efficiently detect loops in the calculation chain path diagram and ensure the legality of the dependency relationship. Through the loop check, check whether there are circular dependencies during the construction of the calculation chain path diagram to avoid running errors caused by illegal calculation links.

[0075] In some embodiments, detect whether the dependency chain of the current target formula or target calculation unit component forms a loop through the depth-first search algorithm, including:

[0076] Establish an access status array and a path status array. Among them, the access status array is used to mark whether a node has been fully accessed, and the path status array is used to mark the nodes in the current recursive path;

[0077] Starting from the current target formula or the node of the target calculation unit component, update the path status array. For each adjacent node, if the adjacent node is not in the current recursive path, recursively call depth - first search, and check for cycles each time during recursion and mark the detection result in a timely manner. If the adjacent node is in the current recursive path, it is determined that the dependency chain of the current target formula or target calculation unit component forms a cycle, set the global flag hasCycle = true and terminate the recursion.

[0078] Specifically, access the status array visited[], which marks whether a certain node has been fully visited. visited[node]= true: indicates that the node and all its adjacent nodes have been fully visited.

[0079] The path status array onPath[] marks the nodes in the current recursive path. onPath[node]= true: indicates that the node is in the current recursive path and has not exited yet. The key to detecting a cycle lies in checking whether the current node already exists in the path status array. During the depth - first search process, by checking whether the status of the onPath[] array is repeated, it is determined whether there is a cycle. After the current node traversal is completed, remove it from the path status array (onPath[node]=false), and at the same time mark the current node as visited (visited[node]= true).

[0080] In some embodiments, generating a computational chain path graph includes:

[0081] Generating a computational chain path graph based on topological sorting.

[0082] In some embodiments, generating a computational chain path graph based on topological sorting includes:

[0083] S21. For each node, calculate the in - degree of the node, where the in - degree is used to characterize the number of parameters of the target formula or target calculation unit component. For example, for the formula A = B + C, it can be known that the in - degree of node A is 2;

[0084] S22. Add all nodes with an in - degree of 0 to the queue as the starting point of the calculation, where an in - degree of 0 means that the node has no dependency relationship or its dependency relationship has been processed;

[0085] S23. According to the reverse reference mapping table, take out a node from the queue, subtract 1 from the in - degree of the node that references the node with an in - degree of 0. If the in - degree of the node that references the node with an in - degree of 0 becomes 0 after subtracting 1, it means that all its parameters have been determined, and add this new node with an in - degree of 0 to the queue;

[0086] S24. Update the queue;

[0087] S25. Determine whether the queue is empty. If it is, when the queue is empty, all nodes have completed calculations, the parsing of the calculation chain path diagram is completed, and the calculation chain path diagram is generated. If not, execute S23.

[0088] For example, Figure 5 is a schematic diagram of the calculation chain path diagram shown in some embodiments of this specification. Figure 5 It can represent the calculation path diagram of the formulas a = b + c, c = d + e, and d = e + b.

[0089] Step 170. After passing the integrity and execution feasibility checks, perform calculations based on the calculation chain path diagram and output the calculation results.

[0090] For example, taking Figure 5 the calculation path diagram of the formulas a = b + c, c = d + e, and d = e + b shown as an example, perform calculations based on the calculation chain path diagram and output the calculation results, specifically including:

[0091] S31. The in-degree of the e and b calculation unit components is 0, and they are added to the queue.

[0092] S32. Take out a calculation unit component such as e from the queue, process the calculation unit components c and d that reference e. The in-degree of the calculation unit component c is decreased by 1 to 1, and the in-degree of the calculation unit component d is decreased by 1 to 1.

[0093] S33. Take out the remaining calculation unit component b in the queue, process the unit components d and a of the calculation unit component b. The in-degree of a is decreased by 1 to 1, and the in-degree of d is decreased by 1 to 0. It is found that the in-degree of d is 0, calculate d, obtain the value of d, and add d to the queue.

[0094] S34. Take out d, process the calculation unit component c that references d. The in-degree of the calculation unit component c is decreased by 1 to 0, perform the calculation, obtain the value of c, and add c to the queue.

[0095] S35. Take out c, process the calculation unit component a that references c. The in-degree is decreased by 1 to 0, calculate a, obtain the value of a, and add a to the queue.

[0096] S36. Take out a, there is no reference to process, the queue is empty, and the calculation ends.

[0097] The user inputs the initial parameters required for the calculation (such as component values or external data) through the interface. Automatically check the integrity and legality of the input parameters.

[0098] After passing the integrity and legality checks of the input parameters, according to the dependency relationship in the calculation chain path diagram, starting from the most basic calculation unit components, gradually calculate the intermediate results and the final result.

[0099] For independent link branches, multi-threaded parallel computing is supported to improve execution efficiency.

[0100] When the input parameters or intermediate results change, it triggers the recalculation of relevant link nodes.

[0101] After the calculation is completed, the values of all result components are displayed, and visual output in the form of charts or tables is provided.

[0102] All inputs, links, and output results of the calculation process are saved to support traceability and analysis.

[0103] Figure 4 It is a schematic diagram of the modules of a data calculation system applicable to the biopharmaceutical production process shown in some embodiments of this specification, as Figure 4 shown, a data calculation system applicable to the biopharmaceutical production process may include a configuration component library, a formula library, an instruction acquirer, a calculation formula configurator, and an automatic calculator.

[0104] The configuration component library is used to store calculation unit components. Each calculation unit component has a unique identifier, a parameter type, a data source, and a calculation logic. The calculation unit components are generated based on biopharmaceutical production process data;

[0105] The formula library is used to store multiple formulas, and the multiple formulas are generated based on biopharmaceutical production process data;

[0106] The instruction acquirer is used to generate an electronic record template based on the configuration component library and the formula library, and obtain user operation instructions through the electronic record template;

[0107] The calculation formula configurator is used to obtain a target formula from the formula library based on the user operation instructions, bind calculation unit components to the variables in the target formula, parse the dependency relationships between the target formulas, generate a calculation chain path diagram, and perform integrity and execution feasibility checks on the calculation chain path diagram;

[0108] The automatic calculator is used to complete the calculation based on the calculation chain path diagram and output the calculation result after the integrity and execution feasibility checks of the calculation chain path diagram pass.

[0109] A data calculation system applicable to the biopharmaceutical production process can be used to execute a data calculation method applicable to the biopharmaceutical production process, which will not be elaborated here.

[0110] Finally, it should be understood that the embodiments described in this specification are only used to illustrate the principles of the embodiments of this specification. Other variations may also fall within the scope of this specification. Therefore, by way of example and not limitation, alternative configurations of the embodiments of this specification may be regarded as consistent with the teachings of this specification. Accordingly, the embodiments of this specification are not limited to the embodiments explicitly presented and described in this specification.

Claims

1. A data calculation method suitable for a biopharmaceutical production process, characterized in that: include: Based on the biopharmaceutical production process data, a configuration component library is established, wherein the configuration component library is used to store computing unit components; Based on the biopharmaceutical production process data, a formula library is established, wherein the formula library is used to store a plurality of formulas; Generate electronic record templates based on configuration component library and formula library; Obtain user operation instructions through electronic record templates; Acquire a target formula from the formula library based on a user operation instruction, and bind a calculation unit component to a variable in the target formula; The calculation formula configurator analyzes the dependencies between target formulas, generates a calculation chain path diagram, and verifies the integrity and feasibility of the calculation chain path diagram; After the integrity and execution feasibility checks are passed, the calculation is completed based on the calculation chain path diagram and the calculation results are output; The calculation formula configurator analyzes the dependencies between target formulas and generates a calculation chain path diagram, including: S11, constructing a topology sequence graph for storing identifiers of computing unit components or formulas and indexes in the dependency graph; S12, constructing a dependency graph to record dependent computational unit components of computational unit components or formulas; S13, constructing a reverse reference mapping table to record the reverse reference relationship corresponding to each computing unit component; S14, input the current target formula or target calculation unit component; S15. Based on the current target formula or target computing unit component, update the topology sequence diagram and the dependency diagram; S16, detecting whether the dependency chain of the current target formula or target calculation unit component forms a loop, if so, generating an exception prompt message and terminating the execution, if not, updating the reverse reference mapping table and executing S17; S17, determine whether all target formulas or target calculation unit components have been input, if so, generate a calculation chain path diagram and end the execution, if not, execute S18; S18, obtaining the next target formula or target calculation unit component as the current target formula or target calculation unit component, and executing S14; Generate a calculation chain path diagram, including: Generate a computational chain path graph based on topological sorting; Based on topological sorting, a computational chain path graph is generated, including: S21. For each node, calculate the in-degree of the node, where the in-degree is used to characterize the number of parameters of the target formula or the target computing unit component; S22, add all nodes with in-degree 0 to the queue as the starting point of calculation; S23, taking a node from the queue, and according to the reverse reference mapping table, reducing the in-degree of the node that references the node with in-degree 0 by 1, if the in-degree of the node with in-degree 0 is 0 after reducing the in-degree by 1, adding the node that references the node with in-degree 0 to the queue; S24, determine whether the queue is empty, if so, generate a calculation chain path diagram, if not, execute S23.

2. The data calculation method applicable to the biopharmaceutical production process according to claim 1, characterized in that: The computing unit component has a unique identifier, parameter type, data source, and computing logic.

3. The data calculation method applicable to the biopharmaceutical production process according to claim 1, characterized in that: Based on the current target formula or target calculation unit component, update the topology sequence diagram and dependency diagram, including: Update the topology sequence graph using the unique identifier of the current target formula or target calculation unit component as a key and the index in the dependency graph as a value; Based on the current target formula or the unique identifier list of the dependent computational unit components of the target computational unit component, the dependency graph is updated.

4. The data calculation method applicable to the biopharmaceutical production process according to claim 3, characterized in that: Update the reverse reference map, including: According to the topological sequence diagram, a bidirectional mapping tool is constructed; Traverse each node and its dependent nodes in the dependency graph to generate the reverse reference relationship of the nodes, where a node represents a calculation unit component or formula. Based on the bidirectional mapping tool, construct the reference mapping corresponding to each dependent node of the node and record it in the reverse reference mapping table.

5. The data calculation method applicable to the biopharmaceutical production process according to claim 4, characterized in that: Check whether the dependency chain of the current target formula or target calculation unit component forms a loop, including: Through the depth-first search algorithm, detect whether the dependency chain of the current target formula or target calculation unit component forms a loop.

6. The data calculation method applicable to the biopharmaceutical production process according to claim 5, characterized in that: Through the depth-first search algorithm, detect whether the dependency chain of the current target formula or target calculation unit component forms a loop, including: Establishing an access status array and a path status array, wherein the access status array is used to mark whether a node has been fully visited, and the path status array is used to mark nodes in the current recursive path; Starting with the node of the current target formula or target calculation unit component, update the path state array. For each adjacent node, if the adjacent node is not in the current recursive path, recursively call the depth-first search. If the adjacent node is in the current recursive path, determine whether the dependency chain of the current target formula or target calculation unit component forms a loop.

7. A data computing system suitable for a biopharmaceutical production process, characterized in that: The data calculation method applicable to the biopharmaceutical production process according to any one of claims 1 to 6 comprises: A configuration component library is used to store computing unit components, wherein each computing unit component has a unique identifier, a parameter type, a data source, and a computing logic, and the computing unit component is generated based on biopharmaceutical production process data; A formula library, used to store a plurality of formulas, wherein the plurality of formulas are generated based on biopharmaceutical production process data; An instruction acquirer, used to generate an electronic record template based on the configuration component library and the formula library, and acquire user operation instructions through the electronic record template; A calculation formula configurator is used to obtain a target formula from the formula library based on a user operation instruction, bind calculation unit components to variables in the target formula, parse dependencies between target formulas, generate a calculation chain path diagram, and perform integrity and execution feasibility verification on the calculation chain path diagram; The automatic calculator is used to complete the calculation based on the calculation chain path diagram and output the calculation result after the integrity and execution feasibility of the calculation chain path diagram are checked and passed.

Images