Query item generation method and system of query form and data model generation method

Abstract

The embodiment of the invention discloses a query item generation method and system for a query form and a data model generation method. The query item generation method of the query form comprises the following steps: determining an initial data model; in response to a query item creation operation of a user, executing the following operations: determining the initial data model as a first data model; determining a second data model in at least one associated data model having a preset association relationship with the first data model; determining the second data model as a new first data model, and returning to execute the operation of determining the second data model in the at least one associated data model having the preset association relationship with the first data model until the last second data model is determined; determining a target field of the last second data model to construct a target link; and creating a query item according to the target link. According to the scheme, layer-by-layer interaction with the user can be realized, so that the construction difficulty of the query item can be reduced.

Description

Technical Field

[0001] This invention relates to the field of information management technology, specifically to a method and system for generating query items in a query form, a method and system for generating a data model, an electronic device, and a storage medium. Background Technology

[0002] In information management systems, especially in scientific research and production fields such as biomedicine, chemical experiments, and materials development, Electronic Lab Notebooks (ELNs) or Laboratory Information Management Systems (LIMS) are commonly used to manage experimental processes and data. The core of these systems is data modeling, which abstracts entities in the experiment (such as samples, reagents, consumables, equipment, projects, and experimental operations) into different data models. Each data model can establish relationships with other data models through specific association fields (such as foreign keys) to perform data traceability or lineage analysis, i.e., to view all relevant data (such as reagents, equipment, and consumables used) for a specific object (such as an experimental sample).

[0003] Traditional data query and tracing methods suffer from high query difficulty and performance bottlenecks. Typically, when performing a query, users need to repeatedly jump and navigate between multiple data models. Even if related data is eventually found, the query results are usually scattered across different pages, making it difficult for users to intuitively and efficiently trace the data lineage relationships scattered across different data models (such as samples, reagents, equipment, projects, etc.). Summary of the Invention

[0004] This invention addresses the aforementioned problems. It provides a method and system for generating query items in a query form, a method and system for generating a data model, and a storage medium. This approach allows for hierarchical interaction with the user to determine the data model in the target link step by step, thereby reducing the difficulty of constructing the target link and its corresponding query items.

[0005] According to one aspect of the present invention, a method for generating query items in a query form is provided. The method includes: determining an initial data model among a plurality of preset data models, the initial data model being located at the starting node of a target link, each of the plurality of data models having a corresponding hierarchy, and the next level of each data model being a data model with a preset association relationship with that data model; responding to a user's query item creation operation, performing the following operations, including: determining the initial data model as a first data model; determining a second data model among at least one associated data model at the next level with a preset association relationship with the first data model, the second data model being located at the next node after the node where the first data model is located in the target link; determining the second data model as a new first data model, and returning to perform the operation of determining the second data model among at least one associated data model at the next level with a preset association relationship with the first data model, until the last second data model is determined; determining the target field of the last second data model to construct a target link, the target field of the last second data model being located at the last node of the target link; and creating query items on a query form according to the target link in response to a query item generation instruction.

[0006] Optionally, determining a second data model from at least one associated data model at the next lower level that has a preset association relationship with the first data model includes: determining a positively associated data model that has a positive association relationship with the first data model, wherein a positive association relationship indicates that the current data model can be unidirectionally mapped to other data models, and the preset association relationship includes a positive association relationship; and determining the second data model from the positively associated data models in response to the user's selection operation.

[0007] Optionally, determining a first associated data model that has a positive correlation with the initial data model includes: determining one or more positively associated data models based on one or more associated fields of the first data model, wherein the positively associated data model is a data model that includes at least some of the associated fields from one or more associated fields in a plurality of data models.

[0008] Optionally, determining a second data model from at least one associated data model at the next lower level that has a preset association relationship with the first data model includes: determining a reverse associated data model that has a reverse association relationship with the first data model, wherein the reverse association relationship indicates that it can be unidirectionally mapped from other data models to the current data model, and the preset association relationship includes the reverse association relationship; and determining the second data model from the reverse associated data model in response to the user's selection operation.

[0009] Optionally, the method further includes: controlling the display window to output and display the identification information of the first data model in the target link, the identification information of at least one associated data model, and at least some fields of the last second data model in a hierarchical menu, wherein in the hierarchical menu, the identification information of the first data model in the target link is a parent menu of the identification information of the at least one associated data model, and the identification information of the last second data model is a parent menu of at least some fields of the last second data model; determining the second data model in at least one associated data model at the next level that has a preset association relationship with the first data model, including: in response to a model selection operation for at least one associated data model, determining the second data model in at least one associated data model, wherein the model selection operation is an operation of selecting a menu in the hierarchical menu; determining the target field of the last second data model, including: in response to a field selection operation for at least some fields of the last second data model, determining the target field in at least some fields of the last second data model, wherein the field selection operation is an operation of selecting a menu in the hierarchical menu.

[0010] Optionally, the identification information of at least one associated data model is a second-level submenu of the identification information of the first data model. The first-level submenu of the identification information of the first data model includes selection information for forward association and / or selection information for reverse association. The first-level submenu of the selection information for forward association includes data models that the first data model can be unidirectionally mapped to, and the first-level submenu of the selection information for reverse association includes data models that can be unidirectionally mapped to the first data model.

[0011] Optionally, there may be multiple intermediate data models located at intermediate nodes of the target link, where intermediate nodes are nodes located between the start node and the last node of the target link.

[0012] Optionally, the multiple data models include one or more objects that represent experimental data. After creating a query item on the query form in response to a query item generation instruction, the method further includes: determining the initial query object of the initial data model; and determining the field value of the target object corresponding to the target field using the query item and the object mapping relationship between the object in each data model on the target link and the object in the adjacent data model. The target object is the object in the last data model on the target link that has an object mapping relationship with the initial query object.

[0013] According to another aspect of the present invention, a query item generation system for a query form is also provided. The system includes: a determining module, configured to determine an initial data model among a plurality of preset data models, the initial data model being located at the starting node of a target link, each of the plurality of data models having a corresponding hierarchy, and the next level of each data model being a data model with a preset association relationship with that data model; and a creating module, configured to, in response to a user's query item creation operation, perform the following operations: determining the initial data model as a first data model; determining a second data model among at least one associated data model at the next level with a preset association relationship with the first data model, the second data model being located at the next node after the node where the first data model is located in the target link; determining the second data model as a new first data model, and returning to perform the operation of determining the second data model among at least one associated data model at the next level with a preset association relationship with the first data model, until the last second data model is determined; determining the target field of the last second data model to construct a target link, the target field of the last second data model being located at the last node of the target link; and, in response to a query item generation instruction, creating a query item on the query form according to the target link.

[0014] 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 an object 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, wherein the data models in the target link are at least a portion of the plurality of data models.

[0015] According to another aspect of the present invention, a data model generation system is also provided for creating data models as described above. The system includes: a first creation module for creating multiple data models, each of the multiple data models including at least one object, each object of the at least one object representing experimental data; a second creation module for creating a preset association relationship between each of the multiple data models and one or more other data models; and a third creation module for creating an object 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 for every two data models having a preset association relationship, wherein the data models in the target link are at least a portion of the multiple data models.

[0016] According to another aspect of the present invention, a storage medium is also provided, on which program instructions are stored, which, when executed, are used to perform the query item generation method and / or data model generation method of the query form described above.

[0017] The above technical solution determines the associated data model through hierarchical interaction with the user, which can decompose the complex process of building a query link across multiple data models into a simple single-step selection operation, thus reducing the difficulty for users to build complex target links. By providing users with optional associated data models at the next level based on preset association relationships, it helps users to correctly build a complete target link from the initial data model to the target data model, which helps ensure that a valid query item is generated in the end.

[0018] 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 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

[0019] 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.

[0020] Figure 1 A schematic flowchart of a query item generation method for a query form according to an embodiment of the present invention is shown;

[0021] Figure 2 A schematic diagram of a hierarchical menu according to an embodiment of the present invention is shown;

[0022] Figure 3 A schematic diagram of a menu for selecting a target field in a hierarchical menu according to an embodiment of the present invention is shown;

[0023] Figure 4 A schematic block diagram of a query item generation system for a query form according to an embodiment of the present invention is shown;

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

[0025] 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.

[0026] To at least partially solve the aforementioned technical problems, this invention provides a method and system for generating query items in a query form, a method and system for generating a data model, and a storage medium. This approach allows for hierarchical interaction with the user to determine the data model in the target link step by step, thereby reducing the difficulty of constructing the target link and its corresponding query items.

[0027] Please see Figure 1 The diagram shown is a schematic flowchart of a query item generation method for a query form according to an embodiment of the present invention. According to one aspect of the present invention, a query item generation method for a query form is provided, the method comprising: steps S110 and S120.

[0028] In step S110, an initial data model is determined among a plurality of preset data models. The initial data model is located at the starting node of the target link. Each of the plurality of data models has a corresponding level. The next level of each data model is a data model that has a preset association relationship with that data model.

[0029] For example, before executing step S110, multiple data models have been constructed, and preset relationships between the data models have been established. Those skilled in the art will understand that these preset relationships can be constructed by setting primary and foreign keys for the data models. For any given data model, there can be one or more data models with preset relationships to it; that is, when the data model is the current level, its next-level data models can be one or more. The initial data model can be any of the multiple data models, and the target link is a link created for the initial data model that may include multiple sequentially connected nodes, with the initial data model located at the starting node (i.e., the first node) of the target link.

[0030] In step S120, in response to the user's query item creation operation, the following operations are performed, including: determining the initial data model as the first data model; determining the second data model among at least one associated data model at the next level that has a preset association relationship with the first data model, wherein the second data model is located at the next node after the node where the first data model is located in the target link; determining the second data model as the new first data model, and returning to perform the operation of determining the second data model among at least one associated data model at the next level that has a preset association relationship with the first data model, until the last second data model is determined; determining the target field of the last second data model to construct the target link, wherein the target field of the last second data model is located at the last node of the target link; and creating a query item on the query form according to the target link in response to the query item generation instruction.

[0031] For example, a user can create query items based on the target link by selecting the target fields of the data models located at each node of the target link and the data model located at the last node through the query item creation operation. Specifically, when the user performs the query item creation operation, the initial data model is the first data model. The display device can output the next level of the first data model to the user, and the user can select a data model from the next level of the first data model. As mentioned above, the next level of the first data model is the data model that has a preset association relationship with the first data model, denoted as the associated data model. Based on the data model selected by the user in the associated data model, the second data model can be determined. The second data model determined in this case is located at the second node of the target link. If the user determines the second data model determined in this case as the last data model, the user can select the target fields of the second data model to construct the target link. If the user does not designate the second data model as the last data model, it can be designated as the new first data model. The display device can then show the user the next level of this first data model, allowing the user to select a new second data model within that level. This newly designated second data model is then located at the third node of the target link. It can be understood that each determined second data model can serve as the last second data model, or it can serve as a new first data model to continue determining new second data models, until the last second data model is determined. In the final constructed target link, except for the last node, there is a pre-defined association between the data models of every two adjacent nodes.

[0032] For example, each data model can have one or more fields, which can define data attributes. For instance, fields may include "Entity ID," "Creation Time," "Colony Count," etc. Each data model can include one or more objects, which are used to represent data. For example, in a device data model, each object can represent relevant data for the corresponding device. Specifically, objects can have field values ​​corresponding to fields. For example, in a device data model, the field value corresponding to the "Device Model" field of a certain object is the device model of the corresponding device. For each data model, there is at least one specific field among its fields. The field value corresponding to the specific field for each object in the data model is unique within the data model. Therefore, the field value corresponding to the specific field for each object in the data model can indicate the corresponding object. Specific fields can be, for example, ID, name, code, etc. The query term is used to output the field value corresponding to the target field of the target object in the last second data model based on the input query object. Since the target link has a preset association between the data models of every two adjacent nodes, there can be an object mapping relationship between the objects in these two data models. The target object is the object passed from the object to be traced through the object mapping relationship between the objects of the two adjacent data models to the last second data model. The target field is the field selected by the user from the fields of the last second data model according to the actual query requirements. For example, the query form can use query items to perform structured queries on the information entered by the user. It can have elements such as input boxes, drop-down menus, and buttons (for insert, reset, query, etc.). This embodiment of the invention does not make specific limitations on the structure and style of the query form.

[0033] The above technical solution determines the associated data model through hierarchical interaction with the user, which can decompose the complex process of building a query link across multiple data models into a simple single-step selection operation, thus reducing the difficulty for users to build complex target links. By providing users with optional associated data models at the next level based on preset association relationships, it helps users to correctly build a complete target link from the initial data model to the target data model, which helps ensure that a valid query item is generated in the end.

[0034] Optionally, determining a second data model from at least one associated data model at the next lower level that has a preset association relationship with the first data model includes: determining a positively associated data model that has a positive association relationship with the first data model, wherein a positive association relationship indicates that the current data model can be unidirectionally mapped to other data models, and the preset association relationship includes a positive association relationship; and determining the second data model from the positively associated data models in response to the user's selection operation.

[0035] For example, the preset association relationship can be directional. The associated data models with a preset association relationship to the first data model can include data models that can be unidirectionally mapped from the first data model, i.e., forward-linked data models. Users can select the second data model only from the forward-linked data models of the first data model by performing a selection operation. The association logic of the target link constructed by this scheme is a forward-linked logic, which helps users trace from source data to downstream data, and the queried data has strong interpretability.

[0036] Optionally, determining a first associated data model that has a positive correlation with the initial data model includes: determining one or more positively associated data models based on one or more associated fields of the first data model, wherein the positively associated data model is a data model that includes at least some of the associated fields from one or more associated fields in a plurality of data models.

[0037] For example, the first data model can be a data model holding a foreign key, where the foreign key is a field that can point to the primary key (i.e., a related field) of one or more other data models. For instance, the sample data model can have a "Device ID" field, which can point to a device data model that has "Device ID" as its primary key. After establishing a positive association between the device data model and the sample data model using the primary key and foreign key, for a pair of device objects and sample objects that need to have an object mapping relationship established, the field value corresponding to the "Device ID" field of the sample object can be set to the field value corresponding to the "Device ID" field of the device object. It should be noted that for each positively associated data model, the related field (i.e., the primary key) of the positively associated data model must satisfy the following: the field value corresponding to the related field of each object in the positively associated data model is unique within the model. It can be understood that since the first data model can have one or more positively associated data models, the first data model can have one or more related fields. Each positively associated data model of the first data model typically has one related field. This approach can quickly and accurately identify data models that have a positive correlation with the first data model along the foreign key direction.

[0038] Optionally, determining a second data model from at least one associated data model at the next lower level that has a preset association relationship with the first data model includes: determining a reverse associated data model that has a reverse association relationship with the first data model, wherein the reverse association relationship indicates that it can be unidirectionally mapped from other data models to the current data model, and the preset association relationship includes the reverse association relationship; and determining the second data model from the reverse associated data model in response to the user's selection operation.

[0039] For example, the first data model can hold a primary key, and foreign keys in other data models can also point to the primary key of the first data model. For an explanation of primary keys and foreign keys, please refer to the relevant descriptions in the foregoing embodiments; they will not be repeated here. The data model whose foreign key points to the primary key of the first data model is the reverse-association data model that has a reverse association relationship with the first data model. Users can select the second data model only from the reverse-association data models of the first data model by performing a selection operation. The association logic of the target link constructed by this scheme can combine forward association logic and reverse association logic, allowing users to flexibly construct the target link according to their data query direction requirements.

[0040] Optionally, the method further includes: controlling the display window to output and display the identification information of the first data model in the target link, the identification information of at least one associated data model, and at least some fields of the last second data model in a hierarchical menu, wherein in the hierarchical menu, the identification information of the first data model in the target link is a parent menu of the identification information of the at least one associated data model, and the identification information of the last second data model is a parent menu of at least some fields of the last second data model; determining the second data model in at least one associated data model at the next level that has a preset association relationship with the first data model, including: in response to a model selection operation for at least one associated data model, determining the second data model in at least one associated data model, wherein the model selection operation is an operation of selecting a menu in the hierarchical menu; determining the target field of the last second data model, including: in response to a field selection operation for at least some fields of the last second data model, determining the target field in at least some fields of the last second data model, wherein the field selection operation is an operation of selecting a menu in the hierarchical menu.

[0041] For example, each data model has unique identification information, such as the data model's name, ID, or code. This identification information indicates the corresponding data model. For each first data model, the hierarchical menu can display its identification information, as well as the identification information of at least one associated data model with a pre-defined relationship, and at least some fields of the last second data model. The hierarchical menu has a parent-child hierarchy. When the identification information of the first data model is the parent menu (i.e., the supervising menu), the identification information of the associated data models with a pre-defined relationship can be used as sub-menus. When the identification information of the last target model is the parent menu, at least some fields of the last target model can be used as sub-menus. For example, the hierarchical menu can be displayed in a display window for the user to view and perform related operations. For each first data model, the user can perform a model selection operation on at least one associated data model within the sub-menu of the first data model's identification information. Specifically, a user can determine a second data model by selecting the identifier information of one of the associated data models. The user can sequentially determine the data models located at each node of the target link by performing one or more model selection operations. For example, after determining the last second data model through model selection operations, the user can perform field selection operations on at least some fields of the last second data model from a submenu of the identifier information of that last second data model. Specifically, the user can determine the target field by selecting one of the fields.

[0042] This approach can present the relationships between abstract data models to users through a visual hierarchical structure. Users can quickly select the next target model by simply selecting the identification information of the data models presented in the menu. This can reduce the user's operational threshold and intuitively reflect the hierarchical relationships between data models.

[0043] Optionally, the identification information of at least one associated data model is a second-level submenu of the identification information of the first data model. The first-level submenu of the identification information of the first data model includes selection information for forward association and / or selection information for reverse association. The first-level submenu of the selection information for forward association includes data models that the first data model can be unidirectionally mapped to, and the first-level submenu of the selection information for reverse association includes data models that can be unidirectionally mapped to the first data model.

[0044] Please see Figure 2 As shown, it is a schematic diagram of a hierarchical menu according to an embodiment of the present invention. Figure 2In the illustrated embodiment, the initial data model is identified as "GeneStructure". The first-level submenu of the "GeneStructure" identifier includes a "Forward Query" option (i.e., selection information for forward associations) and a "Reverse Query" option (i.e., selection information for reverse associations). Clicking "Forward Query" displays the identifiers of the data models that the initial data model can be unidirectionally mapped to. Figure 2 In the illustrated embodiment, the initial data model can be unidirectionally mapped to data models including those identified as "Related samples," "Related device," "Related labware," "Related reagent," and "sample," etc. Since the initial data model can be unidirectionally mapped to a large number of data models, a drop-down slider displays the selection information for the reverse association identified as "GeneStructure." Figure 2 As can be seen, the identifier information of the data models that the initial data model can be unidirectionally mapped to is a first-level submenu of the "Forward Query" option of the identifier information "GeneStructure," which is also a second-level submenu of the initial data model identifier information "GeneStructure." Similarly, when the user clicks "Reverse Query," the identifier information of the data models that can be unidirectionally mapped to the initial data model will be displayed. The identifier information of the data models that can be unidirectionally mapped to the initial data model is a first-level submenu of the "Reverse Query" option of the identifier information "GeneStructure," which is also a second-level submenu of the initial data model identifier information "GeneStructure." Figure 2 In the illustrated embodiment, the data model selected by the user at the second node of the target chain is the data model with the identification information "Related samples". Figure 2 The first-level submenu of the identification information "Related samples" is displayed.

[0045] Please see Figure 3 As shown, this is a schematic diagram of a menu for selecting a target field in a hierarchical menu according to an embodiment of the present invention. Figure 3 The data models located at each node of the target chain are, in order: the data model identified as "GeneStructure", the data model identified as "Related samples", the data model identified as "GeneStucture3D", and the data model identified as "Related samples". It should be noted that... Figure 3In the illustrated embodiment, since the data model with a positive correlation to the data model identified as "Related samples" includes the data model identified as "GeneStructure3D", the data model with a negative correlation to the data model identified as "GeneStructure3D" includes the data model identified as "Related samples". After clicking the forward query option under the identifier "Related samples", the identifier "GeneStructure3D" can be selected under that forward query option. After clicking the reverse query option under the identifier "GeneStructure3D", the identifier "Related samples" can be selected under that reverse query option. Therefore, the data model at the third node of the target chain is the data model identified as "GeneStructure3D", and the data model at the fourth node of the target chain is the data model identified as "Related samples". The data model identified as "Related samples" is the last second data model, which is... Figure 3 As can be seen, its fields include "Entity ID," "Bond length," "Bond angle," "Bond type," "Molecular size," and "Related samples." Users can select the target field from these fields. It should be noted that the value of the "Entity ID" field indicates the corresponding object, but does not represent the actual data of the object; it only serves as identification information. Figure 3 The “data volume” shown in the text does not belong to the fields inherent in the data model itself. It refers to the field category that can represent the actual data. The field values ​​of each field belonging to this field category can represent the actual data of the object. Fields belonging to the “data volume” field category can include, for example, “Bond length”, “Bond angle”, “Bond type”, “Molecular size”, “Related samples”, etc.

[0046] The above technical solution uses the association direction as a first-level submenu of the first data model and the identification information of the associated data model as a second-level submenu of the first data model. This can intuitively distinguish between forward and reverse associations, allowing users to accurately locate associated data models according to the association direction, thereby simplifying the model selection operation. In addition, by using the association direction as a first-level submenu of the first data model and the identification information of the associated data model as a second-level submenu of the first data model, the association logic of the data models can be clearly displayed, which helps to reduce invalid operations and helps users quickly filter the data models with the required association direction, thereby improving the accuracy of interaction and query efficiency.

[0047] Optionally, there may be multiple intermediate data models located at intermediate nodes of the target link, where intermediate nodes are nodes located between the start node and the last node of the target link.

[0048] For example, the target chain has four or more nodes, including at least three nodes corresponding one-to-one with at least three data models and a node corresponding to the target field of the last second data model. This enables data queries across multiple data models, especially when the target chain constructed by the user is complex, eliminating the need to repeatedly jump between the pages containing each data model when querying using the target chain.

[0049] Optionally, the multiple data models include one or more objects that represent experimental data. After creating a query item on the query form in response to a query item generation instruction, the method further includes: determining the initial query object of the initial data model; and determining the field value of the target object corresponding to the target field using the query item and the object mapping relationship between the object in each data model on the target link and the object in the adjacent data model. The target object is the object in the last data model on the target link that has an object mapping relationship with the initial query object.

[0050] For example, the initial query object is one or more objects selected by the user in the initial data model according to the query requirements. For each pair of adjacent data models on the target chain, objects in one data model can have a pre-built object mapping relationship with objects in the other data model. After determining the initial query object, objects in the data model of the second node on the target chain that have an object mapping relationship with the initial query object can be determined. If the data model of the second node is not the last data model, objects in the data model of the third node that have an object mapping relationship with the objects determined in the data model of the second node can be determined, and so on, until the target object in the data model of the last node is determined, thereby determining the field value corresponding to the target field of the target object. The objects in this embodiment of the invention can represent experimental data, which may include, but is not limited to, sample data, reagent data, consumable data, equipment data, project data, experimental record data, catalog data, etc. This embodiment of the invention does not specifically limit the type of experimental data; any experimental data that can be represented by objects in the data model is acceptable.

[0051] The above technical solution utilizes the object mapping relationship between objects in adjacent data models on the target link of the query item to determine the query result for the initial query object. It can automatically and efficiently determine the data that the user wants to query. Especially when there are multiple data models on the target link, this solution can automatically search for target objects with object mapping relationships with the initial query object across multiple data models along the target link, and can automatically determine the field values ​​corresponding to the target fields of the target objects. This can greatly simplify the user's query operation and eliminate the need for the user to jump between multiple data models to search.

[0052] Please see Figure 4 The diagram shown is a schematic block diagram of a query item generation system 400 for a query form according to an embodiment of the present invention. According to another aspect of the present invention, a query item generation system for a query form is also provided, the system 400 comprising:

[0053] The determination module 410 is used to determine the initial data model among a plurality of preset data models. The initial data model is located at the starting node of the target link. Each data model of the plurality of data models has a corresponding level. The next level of each data model is a data model that has a preset association relationship with that data model.

[0054] Create module 420 to respond to user query item creation operations and perform the following operations:

[0055] The initial data model is determined as the first data model;

[0056] A second data model is determined from at least one associated data model at the next level that has a preset association relationship with the first data model. The second data model is located in the next node after the node where the first data model is located in the target link.

[0057] The second data model is determined as the new first data model. The operation of determining the second data model is then performed in at least one associated data model at the next level that has a preset relationship with the first data model, until the last second data model is determined.

[0058] Determine the target field of the last second data model to construct the target link, where the target field of the last second data model is located at the last node of the target link;

[0059] In response to the query item generation instruction, a query item is created on the query form based on the target link.

[0060] 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 an object 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, wherein the data models in the target link are at least a portion of the plurality of data models.

[0061] For example, the data model has a predefined data structure. For instance, the data structure can be a table consisting of rows and columns, each table having a name, and each column having fields. By responding to user operations such as inserting, deleting, and updating data, a data model containing one or more objects can be created. For example, predefined relationships between data models can be established using primary and foreign keys. For data models requiring predefined relationships, a specific field (e.g., sample ID) can be defined as the primary key in one data model, and a foreign key pointing to the primary key (usually a field consistent with the aforementioned specific field) can be added in another data model. For example, for every two data models with established predefined relationships, if it is necessary to establish an object mapping relationship between the objects contained in each of the two data models, the foreign key field corresponding to the object requiring the object mapping relationship can be filled into the field value corresponding to the primary key of the corresponding object in the other data model in the data model with the foreign key.

[0062] According to another aspect of the present invention, a data model generation system is also provided for creating a data model as described above, the system comprising:

[0063] The first creation module is used to create multiple data models. Each data model includes at least one object, and each object of the at least one object is used to represent experimental data.

[0064] The second creation module is used to create a preset association relationship between each data model and one or more other data models for each of the multiple data models.

[0065] The third creation module is used to create an object 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 for every two data models with a preset association relationship, wherein the data models in the target link are at least a portion of the multiple data models.

[0066] Please see Figure 5 As shown, it is a schematic block diagram of an electronic device 500 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 510 and a memory 520, wherein the memory 520 stores computer program instructions, which are executed by the processor 510 to perform the query item generation method and / or data model generation method of the above-mentioned query form.

[0067] 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 query item generation method and / or data model generation method of the query form described in the embodiments of the present invention, and is used to implement corresponding modules in the query item generation system and / or data model generation system of the query form according to the embodiments of the present invention, or corresponding modules in the query item generation system and / or data model generation system for the query form. 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.

[0068] 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 a query item generation method and / or a data model generation method for a query form as described above.

[0069] Those skilled in the art can understand the specific implementation and beneficial effects of the query item generation system, data model generation method and system, electronic device, storage medium, and computer program product by reading the above detailed description of the query form generation method. For the sake of brevity, these will not be elaborated further here.

[0070] 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 thereto. 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.

[0071] 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.

[0072] 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.

[0073] 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.

[0074] 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.

[0075] 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.

[0076] 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.

[0077] 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 in the query item generation system and / or data model generation system for query forms 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 part 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.

[0078] 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.

[0079] 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 scope of the technology 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 method for generating query items in a query form, characterized in that, The method includes: An initial data model is determined from a set of multiple preset data models. The initial data model is located at the starting node of the target link. Each of the multiple data models has a corresponding level, and the next level of each data model is a data model with a preset association relationship with that data model. In response to the user's query item creation action, perform the following operations: The initial data model is determined as the first data model; A second data model is determined from at least one associated data model at the next level that has a preset association relationship with the first data model. The second data model is located in the target link at the node below the node where the first data model is located. The second data model is determined as the new first data model. Then, the operation of determining the second data model from at least one associated data model with a preset relationship with the first data model at the next level is performed until the last second data model is determined. The target field of the last second data model is determined to construct the target link, wherein the target field of the last second data model is located at the last node of the target link; In response to the query item generation instruction, a query item is created on the query form based on the target link.

2. The method according to claim 1, characterized in that, The step of determining the second data model from at least one associated data model at the next lower level that has a preset association relationship with the first data model includes: Determine positively correlated data models that have a positive correlation with the first data model. The positive correlation indicates that the current data model can be mapped unidirectionally to other data models. The preset correlation includes the positive correlation. In response to the user's selection action, the second data model is determined in the positive correlation data model.

3. The method according to claim 2, characterized in that, The first associated data model that has a positive correlation with the initial data model includes: One or more positively correlated data models are determined based on one or more correlated fields of the first data model, wherein the positively correlated data model is a data model that includes at least some of the correlated fields of the one or more correlated fields in the plurality of data models.

4. The method according to claim 1, characterized in that, The step of determining the second data model from at least one associated data model at the next lower level that has a preset association relationship with the first data model includes: Determine a reverse-related data model that has a reverse association relationship with the first data model. The reverse association relationship indicates that it can be unidirectionally mapped from other data models to the current data model. The preset association relationship includes the reverse association relationship. In response to the user's selection action, the second data model is determined in the reverse correlation data model.

5. The method according to any one of claims 1-4, characterized in that, The method further includes: The control display window displays the identification information of the first data model in the target link, the identification information of the at least one associated data model, and at least some fields of the last second data model in a hierarchical menu. In the hierarchical menu, the identification information of the first data model in the target link is the parent menu of the identification information of the at least one associated data model, and the identification information of the last second data model is the parent menu of at least some fields of the last second data model. The step of determining the second data model from at least one associated data model at the next lower level that has a preset association relationship with the first data model includes: In response to a model selection operation for the at least one associated data model, a second data model is determined among the at least one associated data model, wherein the model selection operation is an operation of selecting a menu item from the hierarchical menu; Determining the target field of the last second data model includes: In response to a field selection operation for at least some fields of the last second data model, the target field is determined among at least some fields of the last second data model, the field selection operation being an operation of selecting a menu item from the hierarchical menu.

6. The method according to claim 5, which refers to any one of claims 2-4, characterized in that, The identification information of the at least one associated data model is a second-level submenu of the identification information of the first data model. The first-level submenu of the identification information of the first data model includes selection information for forward association and / or selection information for reverse association. The first-level submenu of the selection information for forward association includes data models that the first data model can be unidirectionally mapped to, and the first-level submenu of the selection information for reverse association includes data models that can be unidirectionally mapped to the first data model.

7. The method according to any one of claims 1-4, characterized in that, There are multiple intermediate data models located at intermediate nodes in the target link, and the intermediate nodes are nodes located between the starting node and the last node of the target link.

8. The method according to any one of claims 1-4, characterized in that, The plurality of data models include one or more objects for representing experimental data. After creating a query item on the query form according to the target link in response to the query item generation instruction, the method further includes: Determine the initial query object for the initial data model; Using the query item and the object mapping relationship between objects in each data model on the target link and objects in adjacent data models, the field value corresponding to the target field of the target object is determined. The target object is the object in the last data model on the target link that has an object mapping relationship with the initial query object.

9. A query item generation system for a query form, characterized in that, The system includes: The determination module is used to determine the initial data model among a plurality of preset data models. The initial data model is located at the starting node of the target link. Each of the plurality of data models has a corresponding level, and the next level of each data model is a data model with a preset association relationship with that data model. The creation module, used in response to user query item creation operations, performs the following operations: The initial data model is determined as the first data model; A second data model is determined from at least one associated data model at the next level that has a preset association relationship with the first data model. The second data model is located in the target link at the node below the node where the first data model is located. The second data model is determined as the new first data model. Then, the operation of determining the second data model from at least one associated data model with a preset relationship with the first data model at the next level is performed until the last second data model is determined. The target field of the last second data model is determined to construct the target link, wherein the target field of the last second data model is located at the last node of the target link; In response to the query item generation instruction, a query item is created on the query form based on the target link.

10. A data model generation method, characterized in that, The method for creating a data model as described in any one of claims 1-8 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 preset association, an object mapping relationship is created 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, wherein the data models in the target link are at least a portion of the multiple data models.

11. A data model generation system, characterized in that, The system for creating a data model as described in any one of claims 1-8 includes: The first creation module is used to 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. The second creation module is used to create a preset association relationship between each of the multiple data models and one or more other data models besides that data model; The third creation module is used to create an object 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 for every two data models with a preset association relationship, wherein the data models in the target link are at least a portion of the multiple data models.

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 query item generation method of the query form as described in any one of claims 1-8 and / or the data model generation method as described in claim 10.

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

Images