Data tracing method and system and data model generation method

Abstract

The embodiment of the invention discloses a data tracing method and system and a data model generation method. The method comprises the steps of obtaining a to-be-traced object and a plurality of data models, the to-be-traced object being an object in the plurality of data models, the plurality of data models having a preset model arrangement sequence, and the model arrangement sequence being consistent with an execution sequence of sub-processes corresponding to the plurality of data models in a preset process, the sub-processes corresponding to the plurality of data models are adjacent in pairs; from the initial data model where the to-be-traced object is located, according to the model arrangement sequence of the multiple data models, an object having a direct or indirect reverse mapping relation with the to-be-traced object is determined in the multiple data models in a reverse tracing mode so as to determine an object having a mapping relation with the to-be-traced object in a preset process, the reverse mapping relation shows that other objects can be unidirectionally mapped to the current object. According to the scheme, data traceability can be quickly performed, and the traceability process is simple and efficient.

Description

Technical Field

[0001] This invention relates to the field of data management technology, specifically to a data traceability method and system, and a data model generation method. Background Technology

[0002] In information management systems used to manage project processes (such as biochemical experimental processes, materials research and development business processes, etc.), the system can use data modeling to abstract entities in the process (such as samples, reagents, consumables, equipment, etc.) into different data models. Relationships can be established between data models, and mapping relationships can be established between objects within each of these data models to enable data traceability or lineage analysis. Typically, a complete project process contains multiple sub-processes, and data with mapping relationships is generated in different sub-processes. The same or different data models can be built for different sub-processes.

[0003] Currently, when tracing data with mapping relationships between different sub-processes of the same project, it is necessary to repeatedly jump and navigate between multiple data models. Users find it difficult to efficiently trace the data lineage scattered in different data models, making the tracing process difficult, complex, and inefficient. Summary of the Invention

[0004] This invention addresses the aforementioned problems. It provides a data tracing method and system, and a data model generation method. This approach, starting from the object to be traced, automatically searches for objects with indirect or direct inverse mapping relationships with the object to be traced, based on the reverse mapping relationships between objects, following the reverse execution order of the sub-processes. This enables rapid data tracing, and the tracing process is simple and efficient.

[0005] According to one aspect of the present invention, a data tracing method is provided for tracing objects that have a mapping relationship with an object to be traced in different sub-processes of a preset process. Each sub-process of the preset process has a corresponding data model, and the data model includes one or more objects, which represent data generated in the sub-process. The method includes: obtaining the object to be traced and multiple data models, wherein the object to be traced is an object in the multiple data models, the multiple data models have a preset model arrangement order, and the model arrangement order is consistent with the execution order of the sub-processes corresponding to each of the multiple data models in the preset process, and the sub-processes corresponding to each of the multiple data models are adjacent to each other; starting from the starting data model where the object to be traced is located, according to the model arrangement order of the multiple data models, using a reverse tracing method to determine objects that have a direct or indirect reverse mapping relationship with the object to be traced in the multiple data models, so as to determine objects that have a mapping relationship with the object to be traced in the preset process, wherein the reverse mapping relationship indicates that other objects can be unidirectionally mapped to the current object.

[0006] Optionally, according to the model arrangement order of multiple data models, the object with a direct or indirect reverse mapping relationship with the object to be traced is determined in multiple data models using a reverse tracing method, including: for each pair of data models that are adjacent according to the model arrangement order, the second target object with a direct reverse mapping relationship with the first target object is determined in the second data model based on the first target object of the first data model, the first data model is after the second data model according to the model arrangement order, the second target object of each pair of data models is the first target object of the previous pair of data models, and when the first data model is the starting data model, the first target object is the object to be traced.

[0007] Optionally, determining a second target object with a direct inverse mapping relationship to the first target object in the second data model based on the first target object of the first data model includes: when the first data model and the second data model are the same data model, determining an object with the same identification information as the object to be traced as a second target object with a direct inverse mapping relationship to the object to be traced in the second data model.

[0008] Optionally, the method further includes: upon receiving a user's forward tracing instruction, starting from the initial data model, determining, according to the model arrangement order of multiple data models, objects with direct or indirect forward mapping relationships to the object to be traced in multiple data models using a forward tracing method, so as to determine objects with mapping relationships to the object to be traced in a preset process, where a forward mapping relationship indicates that the current object can be unidirectionally mapped to other objects; and determining, starting from the initial data model where the object to be traced is located, objects with direct or indirect reverse mapping relationships to the object to be traced in multiple data models using a reverse tracing method, in accordance with the model arrangement order of multiple data models, when receiving a user's reverse tracing instruction.

[0009] Optionally, according to the model arrangement order of the multiple data models, the starting data model is the last data model among the multiple data models.

[0010] Optionally, the number of objects to be traced in the starting data model may be one or more. Starting from the starting data model where the object to be traced is located, the step of determining the objects with direct or indirect reverse mapping relationships with the objects to be traced in multiple data models by using a reverse tracing method according to the model arrangement order of multiple data models is performed for each of the one or more objects to be traced.

[0011] Optionally, the preset process is an experimental process, and the object is experimental data. The method further includes: in response to a window generation request, generating a target window for tracing experimental data, the target window including multiple interactive areas bound one-to-one with multiple data models, each interactive area representing an experimental sub-process; in response to an object configuration operation, configuring and displaying one or more workbench models of the interactive area, the one or more workbench models being used to simulate one or more workbenches used in the experimental sub-process corresponding to the interactive area, at least some operation positions of the workbench having their own associated experimental data, each workbench model displaying multiple visualization elements corresponding one-to-one with multiple operation positions of the simulated workbench, and each visualization element of the multiple visualization elements being bound to the experimental data associated with the corresponding operation position; for each object that is determined to have a mapping relationship with the object to be traced, highlighting the visualization elements bound to that object.

[0012] Optionally, after determining objects with direct or indirect reverse mapping relationships with the traceable object in multiple data models according to the model arrangement order of the starting data model where the traceable object is located, the method further includes: in response to the user's display operation, displaying a target tracing line, wherein the target tracing line is a line that sequentially connects the traceable object and each determined object with a mapping relationship with the traceable object according to the object determination order.

[0013] Optionally, after configuring and displaying one or more console models of the interactive area in response to an object configuration operation, the method further includes: adjusting the arrangement position of the interactive area relative to the other interactive areas in response to a user's drag operation on any of the at least two interactive areas.

[0014] According to another aspect of the present invention, a data traceability system is also provided for tracing objects that have a mapping relationship with the traceable object in different sub-processes of a preset process. Each sub-process of the preset process has a corresponding data model, and the data model includes one or more objects. The objects are used to represent the data generated in the sub-process. The system includes: an acquisition module for acquiring the traceable object and multiple data models, wherein the traceable object is an object in the multiple data models, the multiple data models have a preset model arrangement order, and the model arrangement order is consistent with the execution order of the sub-processes corresponding to each of the multiple data models in the preset process, and the sub-processes corresponding to each of the multiple data models are adjacent to each other; and a determination module for determining, starting from the starting data model where the traceable object is located, according to the model arrangement order of the multiple data models, using a reverse tracing method to determine the objects that have a direct or indirect reverse mapping relationship with the traceable object in the multiple data models, so as to determine the objects that have a mapping relationship with the traceable object in the preset process, wherein the reverse mapping relationship indicates that other objects can be unidirectionally mapped to the current object.

[0015] According to another aspect of the present invention, a data model generation method is also provided for creating a data model as described above. The method includes: creating a plurality of data models, each of the plurality of data models including at least one object, each object of the at least one object representing experimental data; for each of the plurality of data models, creating a preset association relationship between the data model and one or more other data models; for every two data models having a preset association relationship, creating a preset mapping relationship between each object of at least a portion of the objects of one data model and at least a portion of the objects of the other data model.

[0016] According to another aspect of the present invention, an electronic device is also provided, comprising: a processor and a memory, wherein the memory stores computer program instructions, which are executed by the processor to perform the above-described data tracing method and / or data model generation method.

[0017] According to another aspect of the present invention, a storage medium is also provided, on which program instructions are stored, which are used to execute the above-described data tracing method and / or data model generation method when the program instructions are run.

[0018] The above technical solution arranges the data model according to the execution order of each sub-process of the preset process, and determines the objects with direct or indirect reverse mapping relationship with the object to be traced by using a reverse tracing method along the model sequence. This helps to realize automatic one-way tracing of objects with mapping relationship with the object to be traced along the upstream data tracing path starting from the object to be traced, across multiple sub-processes, and can ensure the continuity of the mapping relationship between the relevant objects determined in the tracing process.

[0019] The above description is merely an overview of the technical solution of the present invention. In order to better understand the technical means of the present invention and to implement it in accordance with the contents of the specification, and in order to make the above and other objects, features and advantages of the present invention more apparent and understandable, specific embodiments of the present invention are described below. Attached Figure Description

[0020] The above and other objects, features, and advantages of the present invention will become more apparent from the more detailed description of the embodiments of the invention in conjunction with the accompanying drawings. The drawings are provided to further illustrate the embodiments of the invention and form part of the specification. They are used together with the embodiments of the invention to explain the invention and do not constitute a limitation thereof. In the drawings, the same reference numerals generally represent the same parts or steps.

[0021] Figure 1 A schematic flowchart of a data tracing method according to an embodiment of the present invention is shown;

[0022] Figure 2 A schematic diagram illustrating the relationships between data models according to an embodiment of the present invention is shown;

[0023] Figure 3 A schematic diagram of the console model in each interactive area of ​​the target window according to an embodiment of the present invention is shown;

[0024] Figure 4 A schematic diagram of a target traceability line according to an embodiment of the present invention is shown;

[0025] Figure 5 A schematic block diagram of a data traceability system according to an embodiment of the present invention is shown;

[0026] Figure 6 A schematic block diagram of an electronic device according to an embodiment of the present invention is shown. Detailed Implementation

[0027] To make the objectives, technical solutions, and advantages of the present invention more apparent, exemplary embodiments according to the present invention will be described in detail below with reference to the accompanying drawings. Obviously, the described embodiments are merely a part of the embodiments of the present invention, and not all of the embodiments of the present invention. It should be understood that the present invention is not limited to the exemplary embodiments described herein. Based on the embodiments of the present invention described herein, all other embodiments obtained by those skilled in the art without inventive effort should fall within the protection scope of the present invention.

[0028] In business or experimental processes, entities involved in sub-processes within the same process can be related. For example, in a business process, the "quotation" entity in the quotation sub-process is related to the "sales order" entity in the sales sub-process—the quotation can serve as the basis for generating a formal sales order. Similarly, in an experimental process involving crystal preparation and purification, dissolution, crystallization reaction, separation, and washing constitute three consecutive sub-processes. Sample A obtained in the dissolution stage is transformed into sample B through the crystallization reaction; therefore, samples in different sub-processes are also related.

[0029] At the data modeling level, entities can be abstracted into data models. Each data model can contain one or more objects, which are used to materialize the entity and record its specific attribute values. For example, if the data model is a sample data model, it can include multiple sample objects, each corresponding to a specific sample and recording experimental data such as its number, type, and storage location. Similarly, if the data model is an order data model, it can contain multiple order objects, each corresponding to a specific order and recording business data such as generation time, initiator, product information, and order amount. The abstraction logic of data models for other types of entities remains consistent with this.

[0030] For entities with relationships in different sub-processes, relationships can be established between their corresponding data models. Furthermore, after establishing relationships between data models, mapping operations can be performed on objects within the related data models. For example, when sample A obtained in the first sub-process is transformed into sample B in the second sub-process, sample A can be mapped to sample B. Correspondingly, a mapping relationship can be established between object a corresponding to sample A and object b corresponding to sample B.

[0031] In practical applications, the following situation may occur: object a maps to object b, object b further maps to object f, and so on, forming an object relationship chain spanning multiple data models. Each node in this relationship chain represents an object, and each node belongs to a different data model. If a user wants to trace the data back to the end node or a later node in the relationship chain, they need to repeatedly perform jump and navigation operations between multiple data models. This kind of tracing operation is cumbersome and inefficient.

[0032] To at least partially solve the above-mentioned technical problems, embodiments of the present invention provide a data traceability method and system, and a data model generation method. This solution can automatically search for objects with indirect or direct inverse mapping relationships with the object to be traced, starting from the object to be traced, based on the inverse mapping relationship between objects, in the reverse order of the execution order of the sub-processes. This enables rapid data traceability, and the traceability process is simple and efficient.

[0033] According to one aspect of the present invention, a data traceability method is provided. See also... Figure 1 The diagram shown is a schematic flowchart of a data tracing method according to an embodiment of the present invention. The data tracing method of this embodiment is used to trace objects in different sub-processes of a preset process that have a mapping relationship with the object to be traced. Each sub-process of the preset process has a corresponding data model, and the data model includes one or more objects. The objects are used to represent data generated in the sub-process. The method includes steps S110 and S120.

[0034] For example, the preset process is not limited to the business process or experimental process described above. Any process whose entities within its sub-processes can be abstracted into a data model can be traced using the data tracing method of this embodiment of the invention. It should be noted that before executing step S110, a data model of the preset process currently being traced has been pre-established, and the relationships between data models and the mapping relationships between objects have been pre-established. Those skilled in the art will understand that such relationships and mapping relationships can be defined using primary keys and foreign keys, which will not be elaborated here.

[0035] In step S110, the object to be traced and multiple data models are obtained. The object to be traced is an object in multiple data models. The multiple data models have a preset model arrangement order, and the model arrangement order is consistent with the execution order of the sub-processes corresponding to each of the multiple data models in the preset process. The sub-processes corresponding to each of the multiple data models are adjacent to each other.

[0036] For example, a preset process may include multiple consecutively executed sub-processes, each with an execution order. Correspondingly, the data models obtained by abstracting the entities of each sub-process have a model arrangement order. It can be understood that the execution order is consistent with the model arrangement order. The data model obtained in step S110 may be the data model corresponding to all sub-processes of the preset process, or it may be the data model corresponding to some sub-processes of the preset process. The sub-processes corresponding to each obtained data model are also consecutively executed sub-processes; in other words, the sub-processes corresponding to each obtained data model are adjacent to each other. For example, when the data tracing direction is from a sub-process with a later execution order to a sub-process with a earlier execution order, the object to be traced may be any one or more objects in any data model other than the first data model, arranged according to the model arrangement order. The data model to which the object to be traced belongs is the starting data model.

[0037] In step S120, starting from the initial data model where the object to be traced is located, according to the model arrangement order of multiple data models, the reverse tracing method is used to determine the objects that have a direct or indirect reverse mapping relationship with the object to be traced in multiple data models, so as to determine the objects that have a mapping relationship with the object to be traced in the preset process. The reverse mapping relationship means that other objects can be mapped unidirectionally to the current object.

[0038] For example, because each data model has a model arrangement order, each data model can be adjacent to one or two other data models. For any object, if there is a mapping relationship between the object and objects in the adjacent data models of its own data model, then this mapping relationship is a direct mapping relationship. If the mapping relationship between two objects requires a path formed by connecting multiple direct mapping relationships, then this mapping relationship is an indirect mapping relationship.

[0039] For example, the relationships between data models can be directional. For instance, for a pair of data models with a relationship, including data model A and data model B, if the direction of the relationship is from data model A to data model B, then when data model A is the current data model, data model B has a positive relationship with data model A; and when data model B is the current data model, data model A has a negative relationship with data model B. See also... Figure 2 The diagram shown illustrates the relationships between data models according to an embodiment of the present invention. Figure 2 In the illustrated embodiment, each circle represents a data model, and the direction of the arrows indicates the direction of the association. When data model B is the current data model, the data model with a positive association with data model B is data model C, and the data model with a negative association with data model B is data model A.

[0040] For example, the direction of the association between data models can define the direction of the mapping relationship between objects in the data models. Specifically, for any data model, if there is an association between this data model and another data model, and the direction of the association is from this data model to the other data model, then the direction of the mapping relationship between objects in this data model and objects in the other data model is objects in this data model pointing to objects in the other data model. If the direction of the mapping relationship between an object (denoted as object x) and another object (denoted as object y) is object x pointing to object y, when object x is the current object, objects with a positive mapping relationship with object x include object y; when object y is the current object, objects with a negative mapping relationship with object y include object x. Figure 2 In the illustrated embodiment, if an object having a reverse mapping relationship with object a in data model B includes object c in data model A, then this mapping relationship is a direct mapping relationship. If an object having a direct reverse mapping relationship with object m in data model C includes object a in data model B, then an object having an indirect reverse mapping relationship with object m includes object c.

[0041] In this embodiment of the invention, "reverse" refers to the direction from back to front along the model arrangement order. For every two adjacent data models arranged in the model order, the preceding data model can point to the following data model. Correspondingly, objects with a reverse mapping relationship with objects in the following data model can include objects in the preceding data model. In step S120, starting from the initial data model, the reverse tracing method can sequentially determine objects with a direct reverse mapping relationship with the currently traced object in the data models with a reverse association relationship with the current data model. Each determined object belongs to the category of objects with a direct or indirect reverse mapping relationship with the object to be traced, thereby determining the objects with a mapping relationship with the object to be traced in the preset process.

[0042] In a specific embodiment, the data models obtained in step S110 include data models A, B, and C arranged in model order, and the object to be traced is object z in data model C. Starting from data model C, following the model order of data models A, B, and C, a reverse tracing method can first identify objects with a direct reverse mapping relationship to object z in data model B, which has a reverse association relationship with data model C. These identified objects are denoted as object y. Then, the reverse tracing method can continue to identify objects x with a direct reverse mapping relationship to object y in data model A, which has a reverse association relationship with data model B. In this embodiment, objects with a mapping relationship to object z include object x and object y.

[0043] The above technical solution arranges the data model according to the execution order of each sub-process of the preset process, and determines the objects with direct or indirect reverse mapping relationship with the object to be traced by using a reverse tracing method along the model sequence. This helps to realize automatic one-way tracing of objects with mapping relationship with the object to be traced along the upstream data tracing path starting from the object to be traced, across multiple sub-processes, and can ensure the continuity of the mapping relationship between the relevant objects determined in the tracing process.

[0044] Optionally, according to the model arrangement order of multiple data models, the object with a direct or indirect reverse mapping relationship with the object to be traced is determined in multiple data models using a reverse tracing method, including: for each pair of data models that are adjacent according to the model arrangement order, the second target object with a direct reverse mapping relationship with the first target object is determined in the second data model based on the first target object of the first data model, the first data model is after the second data model according to the model arrangement order, the second target object of each pair of data models is the first target object of the previous pair of data models, and when the first data model is the starting data model, the first target object is the object to be traced.

[0045] For example, each pair of data models arranged sequentially according to their model order can be considered a data model pair. In each data model pair, the later data model is the first data model, and the earlier data model is the second data model. Except for the last data model pair, the second data model of each data model pair is the first data model of the preceding data model pair. The starting data model can be the first data model in any data model pair, in which case the object to be traced is the first target object in that data model pair. Each data model pair can be sorted sequentially according to the model order of its second data models. According to the order of arrangement, the second target object of the current data model pair can be determined based on the first target object of the current data model pair, and this second target object becomes the first target object of the preceding data model pair, and so on, until one or more second target objects are determined. It should be noted that the number of second target objects determined each time can be one or more.

[0046] In a specific embodiment, the data models obtained in step S110 include data model A, data model B, data model C, and data model D in model arrangement order. These data models can form three pairs of data models arranged in model arrangement order, including: (data model A, data model B), (data model B, data model C), and (data model C, data model D). In the first pair of data models, the first data model is data model B, and the second data model is data model A. In the second pair of data models, the first data model is data model C, and the second data model is data model B. In the third pair of data models, the first data model is data model D, and the second data model is data model C. It can be understood that the object to be traced can be an object of any of the data models B, C, and D. In this embodiment, the object to be traced is object i in data model D. Correspondingly, data model D is the starting data model and also the first first data model in this tracing process, data model C is the first second data model in this tracing process, and object i is the first first target object. For the third pair of data models, based on data model D, object i is determined in data model C to have a direct inverse mapping relationship with object i. Data model C is the second first data model of this tracing process, and data model B is the second second data model of this tracing process. If the second target object determined in data model C is object j, then object j can be used as the second first target object. Based on object j in data model C, a second target object with a direct inverse mapping relationship with object j can be determined in data model B. Data model B is the third first data model of this tracing process, and data model A is the third second data model of this tracing process. If the second target object determined in data model B is object k, then object k can be used as the third first target object. Based on object k in data model B, a second target object with a direct inverse mapping relationship with object k can be determined in data model A. In this embodiment, the second target object determined in data model A is object g. Objects with a direct inverse mapping relationship with object i include object j, and objects with an indirect inverse mapping relationship with object i include object k and object g.

[0047] The above technical solution can determine the objects with reverse mapping relationship with the objects to be traced one by one according to the model arrangement order consistent with the execution order of the sub-processes. This can accurately and without omission trace the objects to be traced in the downstream sub-processes to the relevant objects in the upstream sub-processes. The traced objects have a clear sequential dependency relationship. This data tracing path has strong logic.

[0048] Optionally, determining a second target object with a direct inverse mapping relationship to the first target object in the second data model based on the first target object of the first data model includes: when the first data model and the second data model are the same data model, determining an object with the same identification information as the object to be traced as a second target object with a direct inverse mapping relationship to the object to be traced in the second data model.

[0049] For example, the data models corresponding to different sub-processes may be the same or different. In this embodiment of the invention, even if the data models corresponding to two sub-processes contain the exact same objects, they are still considered as two independent data models. Specifically, there are cases where an entity in a certain sub-process is not subjected to any operation in a subsequent sub-process, or the operation in the subsequent sub-process is not performed on that entity. In such cases, the entity will not generate new data in the subsequent sub-process, resulting in the data models of the two sub-processes being completely identical in terms of object composition. For example, in a cell culture observation experiment, the first sub-process observes the sample cells 24 hours after drug treatment, and the next sub-process observes the sample cells again 48 hours later. In the second sub-process, no operation is performed on the sample cells, and the corresponding sample data is likely to remain unchanged. Therefore, the data models of these two sub-processes are completely identical. Each object in the data model can have unique identification information within the model, such as ID or name. If two data models are the same, the identification information of the objects they contain is also consistent. For any pair of data models, if the first data model is the same as the second data model, then the second target object in the pair of data models is the object in the second data model that has the same identification information as the first target object.

[0050] The above technical solution can determine the mapping relationship between two objects by comparing whether the identification information is completely identical when the first and second data models of any pair of data models are the same. This helps to ensure the accuracy of the traceability results and can greatly simplify the traceability logic of the mapping relationship.

[0051] Optionally, the method further includes: upon receiving a user's forward tracing instruction, starting from the initial data model, determining, according to the model arrangement order of multiple data models, objects with direct or indirect forward mapping relationships to the object to be traced in multiple data models using a forward tracing method, so as to determine objects with mapping relationships to the object to be traced in a preset process, where a forward mapping relationship indicates that the current object can be unidirectionally mapped to other objects; and determining, starting from the initial data model where the object to be traced is located, objects with direct or indirect reverse mapping relationships to the object to be traced in multiple data models using a reverse tracing method, in accordance with the model arrangement order of multiple data models, when receiving a user's reverse tracing instruction.

[0052] For example, the foregoing embodiments have already described the "forward mapping relationship," and will not be repeated here. In this embodiment of the invention, "forward" refers to the direction from front to back along the model arrangement order. For every two adjacent data models arranged in the model order, the preceding data model can point to the following data model; correspondingly, objects in the preceding data model can be unidirectionally mapped to objects in the following data model. For example, starting from the initial data model, the forward tracing method can sequentially determine objects with a direct forward mapping relationship to the currently traced object from among the data models with a positive association relationship to the current data model. Each determined object belongs to an object with a direct or indirect forward mapping relationship to the object to be traced, thereby determining objects with a mapping relationship to the object to be traced in the preset process. For example, the "forward tracing method" and "reverse tracing method" are selected by the user according to actual data tracing needs; only one method can be used to trace the object to be traced, or both methods can be used. It should be noted that when using a forward tracing method, the starting data model of the object to be traced is usually one of the data models other than the last one in the model arrangement order. The mapping relationship between the object and the model to be traced can include reverse mapping relationships as well as forward mapping relationships.

[0053] The above technical solution allows users to use a forward query method to locate relevant data in the downstream subprocess from the traceable object in the upstream subprocess, thereby facilitating data tracking.

[0054] Optionally, according to the model arrangement order of the multiple data models, the starting data model is the last data model among the multiple data models.

[0055] For example, among multiple data models, the last data model arranged in the order of model arrangement can be used as the starting data model. This can clearly define the starting point for tracing operations and help ensure the consistency of the tracing direction.

[0056] Optionally, the number of objects to be traced in the starting data model may be one or more. Starting from the starting data model where the object to be traced is located, the step of determining the objects with direct or indirect reverse mapping relationships with the objects to be traced in multiple data models by using a reverse tracing method according to the model arrangement order of multiple data models is performed for each of the one or more objects to be traced.

[0057] For example, the number of traceable objects obtained in step S110 can be one or more, and step S120 can be executed for each obtained traceable object. It should be noted that when there are multiple traceable objects, the starting data models for each traceable object can be the same or different. This approach allows for batch parallel tracing of multiple traceable objects, which helps improve data tracing efficiency.

[0058] Optionally, the preset process is an experimental process, and the object is experimental data. The method further includes: in response to a window generation request, generating a target window for tracing experimental data, the target window including multiple interactive areas bound one-to-one with multiple data models, each interactive area representing an experimental sub-process; in response to an object configuration operation, configuring and displaying one or more workbench models of the interactive area, the one or more workbench models being used to simulate one or more workbenches used in the experimental sub-process corresponding to the interactive area, at least some operation positions of the workbench having their own associated experimental data, each workbench model displaying multiple visualization elements corresponding one-to-one with multiple operation positions of the simulated workbench, and each visualization element of the multiple visualization elements being bound to the experimental data associated with the corresponding operation position; for each object that is determined to have a mapping relationship with the object to be traced, highlighting the visualization elements bound to that object.

[0059] For example, when abstracting entities in any experimental process into a data model, the data model may include, but is not limited to, sample data models, reagent data models, consumable data models, and experimental record data models. For any experimental process, taking the sample data model as an example, each object can represent a set of sample data in the corresponding experimental sub-process. Sample data may include, but is not limited to: sample number, sample type (e.g., hydrochloric acid, blood, bacterial strain, etc.), storage location (e.g., refrigerator number, cryopreservation box number, well number, etc.), source information (e.g., manufacturer, collection location, etc.), and sample characteristics (e.g., optical density, concentration, etc.). Taking the reagent data model as an example, each object can represent a set of reagent data in the corresponding experimental sub-process. Reagent data may include, but is not limited to: name, type (e.g., buffer solution, enzyme, culture medium, chemical reagent, etc.), supplier, batch number, purchase date, and storage location. Taking the consumable data model as an example, each object can represent a set of consumable data in the corresponding experimental sub-process. Consumable data may include, but is not limited to: consumable name, brand, item number, and usage scenario. Taking the experimental record data model as an example, each object can represent a set of experimental record data in the corresponding experimental sub-process. The experimental record data may include, but is not limited to: experimental name, experimental type (e.g., sequencing), project, sample / reagent / equipment / consumables used, experimental protocol, raw data file (e.g., image), etc.

[0060] The data tracing method of this invention can be executed by a processor. A user can send a window generation request to the processor via an interactive device connected to the processor. The processor can respond to the window generation request by generating a target window for tracing experimental data, and can control the display to show the generated target window for the user to view. For example, the target window may include at least two interactive areas, each corresponding to a different experimental sub-process within the same experimental procedure, with each interactive area representing one experimental sub-process. The interactive areas can be arranged sequentially horizontally or vertically according to their execution order.

[0061] For ease of description and understanding, the following embodiments primarily focus on sample data, but the methods of these embodiments are also applicable to other types of experimental data. Exemplarily, each interactive area can be bound to a sample data model of the corresponding experimental sub-process. For any interactive area, the bound sample data model can include one or more sample objects. Exemplarily, for each interactive area, a user can perform an object configuration operation. Specifically, in response to the object configuration operation, the processor can configure one or more workbench models for that interactive area. The workbench models can be used to simulate the workbench used in the experimental sub-process corresponding to the interactive area. Workbench models can be, for example, 48-well plates, 96-well plates, test tube racks, cryopreservation boxes, etc., and each workbench can have multiple work positions. For example, one well of a 96-well plate can be considered a work position; another example is one test tube position of a test tube rack; yet another example is one cryopreservation position of a cryopreservation box, etc. The work positions can be simulated and displayed using visual elements. In the same experimental sub-process, one or more samples can be operated sequentially at the same work position; therefore, one work position can be associated with one or more samples. Accordingly, a visualization element can be associated with a sample object of the sample that is operated on at the corresponding operation bit.

[0062] For example, each workstation can have a workstation ID, and each workstation can have a workstation ID or workstation coordinates. That is, a specific workstation can be identified based on the workstation ID and workstation ID / coordinates. Similarly, a sample at each workstation can have its own sample ID. When constructing a sample data model, its fields can include sample ID, workstation ID, and workstation ID / coordinates. When configuring the workstation model, the workstation ID of the model can be set, and workstation ID / coordinates can be set for each workstation of at least some of the workstations in the workstation model. Accordingly, the sample data bound to the corresponding workstation can be determined based on the workstation ID and workstation ID / coordinates, i.e., the object bound to the corresponding workstation can be determined. Workstations on the workstation model with associated experimental data can be highlighted using visualization elements, and each visualization element can be bound to the experimental data (e.g., a sample object) associated with the corresponding workstation.

[0063] For example, the types of workbench models configured within the same interactive area can be the same or different. For instance, a workbench model configured within an interactive area can include the workbench model corresponding to a 96-well plate, and it can also include the workbench model corresponding to a 48-well plate. The types of workbench models configured in different interactive areas can be the same or different, and can be determined based on the type of workbench actually used in the corresponding experimental sub-process. Please refer to [link / reference]. Figure 3 As shown, it is a schematic diagram of the operation console model in each interactive area of ​​the target window according to an embodiment of the present invention. Figure 3 Three interactive areas are shown (the third interactive area from left to right is not fully displayed). The operating table models for the first and third interactive areas are respectively the operating table models for the 96-well plate, and the operating table model for the second interactive area is the operating table model for the 48-well plate. Each well of the 48-well and 96-well plates is an operating position. The visualization elements in the operating table models can display partial data of the corresponding sample object (such as sample ID or colony count, etc.), which is understandable. Figure 3 The holes displaying relevant data are the visualization elements. For example, for each object that is determined to have a mapping relationship with the object to be traced, the visualization element bound to that object can be highlighted. For instance, the edge line of the visualization element to be highlighted can be thickened, or the color of the visualization element to be highlighted can be set to a color different from other visualization elements.

[0064] The above technical solution transforms the abstract data model into an intuitive visual interface corresponding to each experimental sub-process by generating interactive areas in the target window that correspond one-to-one with each experimental sub-process. This significantly improves the readability of experimental data and makes it easier for users to view. By configuring an operation model that can simulate the display of the control panel and operation position in the interactive area, and displaying visual elements on the control panel model, and highlighting the visual elements bound to each object that has a mapping relationship with the object to be traced, the position of the experimental data to be traced in each experimental sub-process can be clearly and intuitively displayed. This makes it easier to observe the location transfer path of the experimental data during the tracing operation without having to jump between different data models to search.

[0065] Optionally, after determining objects with direct or indirect reverse mapping relationships with the traceable object in multiple data models according to the model arrangement order of the starting data model where the traceable object is located, the method further includes: in response to the user's display operation, displaying a target tracing line, wherein the target tracing line is a line that sequentially connects the traceable object and each determined object with a mapping relationship with the traceable object according to the object determination order.

[0066] Please see Figure 4 As shown, this is a schematic diagram of a target traceability line according to an embodiment of the present invention. Users can perform a display operation by enabling traceability mode, in which the target traceability line can be displayed. Figure 4 In the illustrated embodiment, the object to be traced is the object bound to the visual element located at operation position A3 in the third interaction area. Using a reverse tracing method, objects with a reverse mapping relationship to the object to be traced include objects bound to the visual element at operation position A3 in the data model bound to the second interaction area, and objects bound to the visual element at operation position A3 in the data model bound to the first interaction area. Connecting the visual element corresponding to the object to be traced and the visual element corresponding to each determined object sequentially yields the target tracing line as shown below. Figure 4 The curve in the figure is shown.

[0067] The above technical solution can clearly and intuitively display the location transfer path of experimental data through the target traceability line, and display the traceability results in the form of a target traceability line, which is more readable than the text-based mapping relationship representation.

[0068] Optionally, after configuring and displaying one or more console models of the interactive area in response to an object configuration operation, the method further includes: adjusting the arrangement position of the interactive area relative to the other interactive areas in response to a user's drag operation on any of the at least two interactive areas.

[0069] For example, each interactive area can be a draggable control. Users can drag any interactive area to adjust its position relative to other interactive areas. For instance, if the interactive areas arranged horizontally from left to right in the target window are interactive area 1, interactive area 2, and interactive area 3, the user can drag interactive area 1 between interactive area 2 and interactive area 3. After adjustment, the interactive areas arranged horizontally from left to right in the target window will be interactive area 2, interactive area 1, and interactive area 3.

[0070] For example, users can bind data models to each interactive area. The data models for different interactive areas can be the same or different. During object configuration, it's necessary to associate each visual element with its corresponding object. Therefore, each interactive area requires a significant amount of configuration, including both the bound data model and the binding relationship between the object and the visual element. If, after configuring each interactive area, the user finds that the order of some interactive areas is inconsistent with the execution order of their respective experimental sub-processes, adjusting the arrangement by dragging the interactive areas can greatly reduce the workload compared to reconfiguring the corresponding interactive areas, especially when there are many visual elements configured in the interactive areas. It should be noted that if the order of the interactive areas is inconsistent with the execution order of their respective experimental sub-processes, there may be situations where traceability is impossible. For example, in an experimental project, there are experimental sub-processes 1, 2, and 3 arranged in execution order, with their corresponding data models denoted as data model A, data model B, and data model C, respectively. Sample object a of data model A can be unidirectionally mapped to sample object b of data model B, and sample object b of data model B can be unidirectionally mapped to sample object c of data model C. If, after completing the object configuration operations in each interactive area, the data models bound to the interactive areas arranged in the order of display are data model A, data model C, and data model B respectively, then in the interactive area corresponding to experimental sub-process 2, if the user performs a selection operation on the visual element bound to the sample object c of data model C (that is, the sample object c is the object to be traced), then the data model of the interactive area adjacent to this interactive area cannot determine a sample object that has a direct reverse mapping relationship with the sample object c, thus making it impossible to complete the traceability.

[0071] The above technical solution allows users to drag the entire interactive area to adjust its arrangement, which avoids the inability to display data traceability results due to user operation errors causing the data model's arrangement order to be inconsistent with the execution order of the corresponding sub-processes in the interactive area. This method has a high fault tolerance rate for user operations and helps to improve the user experience.

[0072] Please see Figure 5The diagram shown is a schematic block diagram of a data traceability system 500 according to an embodiment of the present invention. According to another aspect of the present invention, a data traceability system is also provided for tracing objects in different sub-processes of a preset process that have a mapping relationship with an object to be traced. Each sub-process of the preset process has a corresponding data model, and the data model includes one or more objects, which represent data generated in the sub-process. The system 500 includes:

[0073] The acquisition module 510 is used to acquire the object to be traced and multiple data models. The object to be traced is an object in multiple data models. The multiple data models have a preset model arrangement order, and the model arrangement order is consistent with the execution order of the sub-processes corresponding to each of the multiple data models in the preset process. The sub-processes corresponding to each of the multiple data models are adjacent to each other.

[0074] The determination module 520 is used to determine, starting from the initial data model where the object to be traced is located, the objects with direct or indirect reverse mapping relationships with the object to be traced in multiple data models according to the model arrangement order of multiple data models, so as to determine the objects with mapping relationships with the object to be traced in the preset process. The reverse mapping relationship means that other objects can be unidirectionally mapped to the current object.

[0075] According to another aspect of the present invention, a data model generation method is also provided for creating a data model as described above. The method includes: creating a plurality of data models, each of the plurality of data models including at least one object, each object of the at least one object representing experimental data; for each of the plurality of data models, creating a preset association relationship between the data model and one or more other data models; for every two data models having a preset association relationship, creating a preset mapping relationship between each object of at least a portion of the objects of one data model and at least a portion of the objects of the other data model.

[0076] For example, the data model has a predefined data structure. For instance, the data structure can be a table composed of rows and columns, each table having a table name, and each column within the table having a column name (i.e., a field). The data model can be created in response to user operations such as inserting, deleting, and updating data. For example, data models corresponding to adjacent sub-processes can establish a relationship through primary and foreign keys. For each pair of adjacent sub-processes, a specific field (e.g., sample ID) can be defined as the primary key in the latter data model. The specific value of each object in the data model corresponding to this specific field is unique within the model, and a foreign key field pointing to the primary key (e.g., related to the sample ID) is defined in the former data model. For example, for each pair of data models that have established a relationship, if it is necessary to establish a mapping relationship between the objects contained in the two data models, the foreign key field of the object in the former data model, arranged in the model order, can be filled with the primary key value (e.g., the specific value corresponding to the sample ID) of the corresponding object in the latter data model.

[0077] Please see Figure 6 As shown, it is a schematic block diagram of an electronic device 600 according to an embodiment of the present invention. According to another aspect of the present invention, an electronic device is also provided, including: a processor 610 and a memory 620, wherein the memory 620 stores computer program instructions, which are executed by the processor 610 to perform the above-described data tracing method and / or data model generation method.

[0078] According to another aspect of the present invention, a storage medium is also provided, on which program instructions are stored. When the program instructions are executed by a computer or processor, the computer or processor performs corresponding steps of the data tracing method and / or data model generation method described in the embodiments of the present invention, and is used to implement corresponding modules in the data tracing system described in the embodiments of the present invention or corresponding modules in the data tracing system described above. The storage medium may, for example, include a memory card of a smartphone, a storage component of a tablet computer, a hard disk of a personal computer, a read-only memory (ROM), an erasable programmable read-only memory (EPROM), a portable compact disc read-only memory (CD-ROM), a USB memory, or any combination of the above storage media. A computer-readable storage medium may be any combination of one or more computer-readable storage media.

[0079] According to another aspect of the present invention, a computer program product is also provided, including computer program instructions, which, when executed, are used to perform the data tracing method and / or data model generation method as described above.

[0080] Those skilled in the art can understand the specific implementation and beneficial effects of the above-described data traceability system and data model generation method by reading the detailed description of the data traceability method above, and will not be elaborated further here for the sake of brevity.

[0081] Although exemplary embodiments have been described herein with reference to the accompanying drawings, it should be understood that the above exemplary embodiments are merely illustrative and are not intended to limit the scope of the invention. Various changes and modifications can be made therein by those skilled in the art without departing from the scope and spirit of the invention. All such changes and modifications are intended to be included within the scope of the invention as claimed in the appended claims.

[0082] Those skilled in the art will recognize that the units and algorithm steps of the various examples described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are implemented in hardware or software depends on the specific application and design constraints of the technical solution. Those skilled in the art can use different methods to implement the described functions for each specific application, but such implementations should not be considered beyond the scope of this invention.

[0083] In the several embodiments provided in this application, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are merely illustrative. For instance, the division of units is only a logical functional division, and in actual implementation, there may be other division methods. For example, multiple units or components may be combined or integrated into another device, or some features may be ignored or not executed.

[0084] Numerous specific details are set forth in the specification provided herein. However, it will be understood that embodiments of the invention may be practiced without these specific details. In some instances, well-known methods, structures, and techniques have not been shown in detail so as not to obscure the understanding of this specification.

[0085] Similarly, it should be understood that, in order to streamline the invention and aid in understanding one or more of the various aspects of the invention, features of the invention are sometimes grouped together in a single embodiment, figure, or description thereof in the description of exemplary embodiments of the invention. However, this approach should not be construed as reflecting an intention that the claimed invention requires more features than are expressly recited in each claim. Rather, as reflected in the corresponding claims, its inventive point lies in solving the corresponding technical problem with fewer features than all of those in a single disclosed embodiment. Therefore, the claims following the detailed description are hereby expressly incorporated into that detailed description, wherein each claim itself is a separate embodiment of the invention.

[0086] Those skilled in the art will understand that, apart from the mutual exclusion of features, all features disclosed in this specification (including the accompanying claims, abstract, and drawings) and all processes or units of any method or apparatus so disclosed can be combined in any combination. Unless otherwise expressly stated, each feature disclosed in this specification (including the accompanying claims, abstract, and drawings) may be replaced by an alternative feature that serves the same, equivalent, or similar purpose.

[0087] Furthermore, those skilled in the art will understand that although some embodiments herein include certain features included in other embodiments but not others, combinations of features from different embodiments are intended to be within the scope of the invention and form different embodiments. For example, in the claims, any of the claimed embodiments can be used in any combination.

[0088] The various component embodiments of the present invention can be implemented in hardware, or as software modules running on one or more processors, or a combination thereof. Those skilled in the art will understand that microprocessors or digital signal processors (DSPs) can be used in practice to implement some or all of the functions of some modules for a data traceability system according to embodiments of the present invention. The present invention can also be implemented as an apparatus program (e.g., a computer program and computer program product) for performing some or all of the methods described herein. Such programs implementing the present invention can be stored on a computer-readable medium or can be in the form of one or more signals. Such signals can be downloaded from an Internet website, provided on a carrier signal, or provided in any other form.

[0089] It should be noted that the above embodiments are illustrative of the invention and not restrictive, and that those skilled in the art can devise alternative embodiments without departing from the scope of the appended claims. In the claims, any reference signs placed between parentheses should not be construed as limiting the claims. The word "comprising" does not exclude the presence of elements or steps not listed in the claims. The word "a" or "an" preceding an element does not exclude the presence of a plurality of such elements. The invention can be implemented by means of hardware comprising several different elements and by means of a suitably programmed computer. In the unit claims enumerating several means, several of these means may be embodied by the same item of hardware. The use of the words first, second, and third, etc., does not indicate any order. These words can be interpreted as names.

[0090] The above are merely specific embodiments or descriptions of the present invention, and the scope of protection of the present invention is not limited thereto. Any variations or substitutions that can be easily conceived by those skilled in the art within the technical scope disclosed in the present invention should be included within the scope of protection of the present invention. The scope of protection of the present invention should be determined by the scope of the claims.

Claims

1. A data traceability method, characterized in that, The method is used to trace objects that have a mapping relationship with the object to be traced in different sub-processes of a preset process. Each sub-process of the preset process has a corresponding data model, and the data model includes one or more objects, which are used to represent the data generated in the sub-process. The method includes: Obtain the object to be traced and multiple data models. The object to be traced is an object in the multiple data models. The multiple data models have a preset model arrangement order, and the model arrangement order is consistent with the execution order of the sub-processes corresponding to each of the multiple data models in the preset process. The sub-processes corresponding to each of the multiple data models are adjacent to each other. Starting from the initial data model where the object to be traced is located, according to the model arrangement order of the multiple data models, the reverse tracing method is used to determine the objects that have a direct or indirect reverse mapping relationship with the object to be traced in the multiple data models, so as to determine the objects that have a mapping relationship with the object to be traced in the preset process. The reverse mapping relationship means that other objects can be unidirectionally mapped to the current object.

2. The method according to claim 1, characterized in that, The step of determining, according to the model arrangement order of the multiple data models, objects with direct or indirect reverse mapping relationships to the object to be traced within the multiple data models using a reverse tracing method includes: For each pair of data models that are adjacent according to the model arrangement order, a second target object with a direct reverse mapping relationship with the first target object is determined in the second data model based on the first target object of the first data model. The first data model is after the second data model according to the model arrangement order. The second target object of each pair of data models is the first target object of the previous pair of data models. When the first data model is the starting data model, the first target object is the object to be traced.

3. The method according to claim 2, characterized in that, The determination of a second target object in the second data model that has a direct inverse mapping relationship with the first target object based on the first data model includes: When the first data model and the second data model are the same data model, in the second data model, the object with the same identification information as the object to be traced is identified as the second target object with a direct reverse mapping relationship with the object to be traced.

4. The method according to any one of claims 1-3, characterized in that, The method further includes: Upon receiving a user's forward tracing instruction, starting from the initial data model, and following the model arrangement order of the multiple data models, the forward tracing method is used to determine the objects in the multiple data models that have a direct or indirect forward mapping relationship with the object to be traced, so as to determine the objects that have a mapping relationship with the object to be traced in the preset process. The forward mapping relationship indicates that the current object can be mapped unidirectionally to other objects. The step of determining, starting from the initial data model where the object to be traced is located, and according to the model arrangement order of the multiple data models, using a reverse tracing method to determine the object with a direct or indirect reverse mapping relationship with the object to be traced in the multiple data models is executed when the user's reverse tracing instruction is received.

5. The method according to any one of claims 1-3, characterized in that, According to the model arrangement order of the plurality of data models, the starting data model is the last data model among the plurality of data models.

6. The method according to any one of claims 1-3, characterized in that, The number of traceable objects in the starting data model is one or more. The step of determining the objects with direct or indirect reverse mapping relationships with the traceable objects in the multiple data models according to the model arrangement order of the multiple data models, starting from the starting data model where the traceable object is located, is performed for each traceable object of the one or more traceable objects.

7. The method according to any one of claims 1-3, characterized in that, The preset process is an experimental process, the object is experimental data, and the method further includes: In response to a window generation request, a target window for tracing experimental data is generated. The target window includes multiple interactive areas that are bound one-to-one with the multiple data models. Each of the multiple interactive areas represents an experimental sub-process. In response to an object configuration operation, one or more console models of the interactive area are configured and displayed. The one or more console models are used to simulate one or more consoles used in the experimental sub-process corresponding to the interactive area. At least some operation positions of the console have their own associated experimental data. Each console model displays multiple visualization elements that correspond one-to-one with multiple operation positions of the simulated console, and each visualization element of the multiple visualization elements is bound to the experimental data associated with the corresponding operation position. For each object that is identified as having a mapping relationship with the object to be traced, the visual element bound to that object will be highlighted.

8. The method according to claim 7, characterized in that, After determining, starting from the initial data model where the object to be traced is located, objects with direct or indirect reverse mapping relationships to the object to be traced in the multiple data models according to the model arrangement order, using a reverse tracing method, the method further includes: In response to the user's display operation, a target tracing line is displayed, which is a line that sequentially connects the object to be traced and each object that has a mapping relationship with the object to be traced according to the object determination order.

9. The method according to claim 7, characterized in that, After configuring and displaying one or more console models of the interactive area in response to the object configuration operation, the method further includes: In response to a user's drag operation on any of the at least two interactive areas, the arrangement of that interactive area relative to the other interactive areas is adjusted.

10. A data traceability system, characterized in that, This system is used to trace objects that have a mapping relationship with the object to be traced in different sub-processes of a preset process. Each sub-process of the preset process has a corresponding data model, and the data model includes one or more objects, which are used to represent the data generated in the sub-process. The system includes: The acquisition module is used to acquire the object to be traced and multiple data models. The object to be traced is an object in the multiple data models. The multiple data models have a preset model arrangement order, and the model arrangement order is consistent with the execution order of the sub-processes corresponding to each of the multiple data models in the preset process. The sub-processes corresponding to each of the multiple data models are adjacent to each other. The determination module is used to determine, starting from the initial data model where the traceable object is located, objects with direct or indirect reverse mapping relationships with the traceable object in the multiple data models according to the model arrangement order of the multiple data models, in order to determine objects with mapping relationships with the traceable object in the preset process. The reverse mapping relationship means that other objects can be unidirectionally mapped to the current object.

11. A data model generation method, characterized in that, The method for creating a data model as described in any one of claims 1-9 includes: Create multiple data models, each of which includes at least one object, and each of the at least one object is used to represent experimental data; For each of the plurality of data models, a preset association relationship is created between that data model and one or more other data models besides that data model; For every two data models with a predefined relationship, create a predefined mapping relationship between each object of at least a portion of the objects in one data model and at least a portion of the objects in the other data model.

12. An electronic device comprising a processor and a memory, characterized in that, The memory stores computer program instructions, which, when executed by the processor, are used to perform the data tracing method as described in any one of claims 1-9 and / or the data model generation method as described in claim 11.

13. A storage medium on which program instructions are stored, characterized in that, The program instructions, when executed, are used to perform the data tracing method as described in any one of claims 1-9 and / or the data model generation method as described in claim 11.

Images