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

Abstract

The embodiment of the invention discloses a query item generation method and system for a query form and an information model generation method. The method comprises the following steps: determining an initial information model in a plurality of preset information models; determining a first associated information model having a preset association relationship with the initial information model, and displaying identification information of the first associated information model, the first associated information model including an information model having a forward association relationship with the initial information model; determining a first target information model in the first associated information model in response to a selection operation of the user for the identification information of the first associated information model, and determining a target query chain based on the initial information model and the first target information model; and in response to a query item generation instruction, generating a query item on the query form based on the target query chain. According to the scheme, the direction of the incidence relation between the user information models can be prompted, the user is guided to gradually construct the target query chain, and the operation difficulty is low.

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 information models, an electronic device, and a storage medium. Background Technology

[0002] In information management systems, especially in 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 experimental objects (such as samples, reagents, consumables, equipment, projects, and experimental operations) into different information models. Each information model can establish relationships with other information 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, tracing requires repeated jumping and navigation between multiple information models. Even if relevant 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 scattered across different information 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 information models, an electronic device, and a storage medium. This solution can indicate the direction of relationships between information models to the user and guide them step-by-step in constructing the target query chain. It is easy to operate and can generate query items that can be used for data retrieval within the same form.

[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 information model from a plurality of preset information models; determining a first associated information model having a preset association relationship with the initial information model, and displaying the identifier information of the first associated information model, wherein the first associated information model includes information models having a positive association relationship with the initial information model determined through a forward query, the positive association relationship indicating that the current information model can be unidirectionally mapped to other information models, and the preset association relationship includes positive association relationships; responding to a user's selection operation on the identifier information of the first associated information model, determining a first target information model from the first associated information model, and determining a target query chain based on the initial information model and the first target information model, wherein the target query chain includes a target field of the last target information model of the first target information model connected sequentially, the first target information model including the first target information model, and each two adjacent information models in the target query chain having a preset association relationship; and generating query items on a query form based on the target query chain in response to a query item generation instruction.

[0006] Optionally, the method further includes: controlling the display window to output and display the identifier information of the initial information model and the identifier information of the first associated information model in a hierarchical menu; in the hierarchical menu, the identifier information of the initial information model is the parent menu of the identifier information of the first associated information model; the selection operation is an operation of selecting a menu in the hierarchical menu.

[0007] Optionally, determining a first associated information model that has a preset association relationship with the initial information model includes: determining one or more first associated information models based on one or more associated fields of the initial information model, wherein the first associated information model is an information model that includes at least some of the associated fields of one or more associated fields in a plurality of information models; and displaying the identification information of the first associated information model in the target directory at the level corresponding to the first associated information model in the hierarchical menu, wherein the target directory is the associated fields contained in the first associated information model.

[0008] Optionally, after determining the initial information model among a plurality of preset information models, the method further includes: receiving a query form generation instruction, the query form generation instruction being used to instruct the generation of a query form for the initial information model; and in response to the query form generation instruction, generating a query form according to a preset query form framework.

[0009] Optionally, the method further includes: when the first target information model is not the last information model in the target query chain, determining the target query chain based on the initial information model and the first target information model, including: taking the first target information model as the current target information model, and performing the following model determination operation: determining one or more second associated information models that have a preset association relationship with the current target information model based on the current target information model, and displaying the identification information of each of the one or more second associated information models; responding to the user's selection operation on the identification information of the one or more second associated information models, determining the second target information model among the one or more second associated information models; taking the second target information model as the new current target information model, and returning to perform the model determination operation until the last information model in the target query chain is determined.

[0010] Optionally, the preset association relationship also includes a reverse association relationship. The first association information model also includes an information model that has a reverse association relationship with the initial information model, which is determined by a reverse query method. The reverse association relationship means that other information models can be mapped unidirectionally to the current information model.

[0011] Optionally, the multiple information models include one or more objects that represent experimental data. After generating query items on the query form based on the target query chain in response to the query item generation instruction, the method further includes: determining the object to be queried in the initial information model; and determining the field value corresponding to the target field of the target object by utilizing the query items and the object mapping relationship between the object in each information model on the target query chain and the object in the adjacent information model. The target object is the object in the last information model on the target query chain that has a mapping relationship with the object to be queried.

[0012] According to another aspect of the present invention, a query item generation system for a query form is also provided. The system includes: a first determining module, configured to determine an initial information model among a plurality of preset information models; a display module, configured to determine a first associated information model having a preset association relationship with the initial information model, and display the identification information of the first associated information model, wherein the first associated information model includes information models having a positive association relationship with the initial information model determined by a forward query method, the positive association relationship indicating that the current information model can be unidirectionally mapped to other information models, and the preset association relationship includes the positive association relationship; a second determining module, configured to, in response to a user's selection operation on the identification information of the first associated information model, determine a first target information model in the first associated information model, and determine a target query chain based on the initial information model and the first target information model, wherein the target query chain includes the initial information model, at least one target information model, and the target field of the last target information model of the at least one target information model connected in sequence, wherein the at least one target information model includes the first target information model, and there is a preset association relationship between every two adjacent information models in the target query chain; and a generation module, configured to, in response to a query item generation instruction, generate query items on the query form based on the target query chain.

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

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

[0015] 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, when executed by the processor, are used to perform the query item generation method and / or information model generation method of the above-mentioned query form.

[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 information model generation method of the query form described above.

[0017] The aforementioned technical solution identifies and displays information models associated with the initial information model through a forward query approach. This intuitively shows users all information models that have a positive correlation with the initial information model. The forward query can indicate the direction of the correlation between information models, guiding users to find the required information model and construct the target query chain according to the positive correlation. The construction process of the target query chain is relatively clear and controllable. Furthermore, by constructing the target query chain based on the user's selection operation of the first associated information model, this interactive method is simple and easy to understand, significantly reducing the difficulty of user operation. Moreover, users can use the query items generated based on the target query chain to perform data queries without having to repeatedly navigate between multiple information models, saving time and increasing efficiency.

[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 the input interface for a query form generation instruction according to an embodiment of the present invention is shown;

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

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

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

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

[0027] To at least partially solve the aforementioned technical problems, embodiments of the present invention provide a method and system for generating query items in a query form, a method and system for generating an information model, an electronic device, and a storage medium. This solution can indicate the direction of the relationships between information models to the user and guide the user to gradually construct the target query chain. It is easy to operate and can obtain query items that can be used for data querying within the same form.

[0028] 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 to S140.

[0029] In step S110, an initial information model is determined from a set of preset information models.

[0030] For example, prior to step S110, multiple information models have been pre-constructed, and the initial information model can be any of the multiple information models.

[0031] In step S120, a first associated information model with a preset association relationship with the initial information model is determined, and the identification information of the first associated information model is displayed. The first associated information model includes information models with a positive association relationship with the initial information model determined by a positive query method. A positive association relationship means that the current information model can be mapped unidirectionally to other information models. The preset association relationship includes positive association relationships.

[0032] For example, prior to step S120, a pre-defined association relationship between information models has been established. Those skilled in the art will understand that this pre-defined association relationship can be constructed by setting primary keys and foreign keys for the information models. For any given information model, there can be one or more information models with a pre-defined association relationship. An information model with a pre-defined association relationship with the initial information model may include a first associated information model, which is an information model with a positive association relationship with the initial information model. For any given information model, a forward query can be used to determine the information model with a positive association relationship. The pre-defined association relationship has direction; for any given information model, if it can be unidirectionally mapped to another information model, then that other information model is an information model with a positive association relationship with the given information model. For example, each information model may have corresponding identification information, which is used to indicate the corresponding information model. The identification information may be, for example, a model name, model ID, model code, etc. The identification information of the first associated information model can be output and displayed by a display device for user viewing.

[0033] In step S130, in response to the user's selection operation of the identifier information of the first associated information model, a first target information model is determined in the first associated information model, and a target query chain is determined based on the initial information model and the first target information model. The target query chain includes the initial information model, at least one target information model, and the target field of the last target information model of the at least one target information model connected in sequence. The at least one target information model includes the first target information model. There is a preset association relationship between every two adjacent information models in the target query chain.

[0034] For example, a user can perform a selection operation on the identifier information of the first associated information model through an interactive device (such as a mouse, keyboard, etc.). The information model indicated by the identifier information of the selection operation is the first target information model. The initial information model and the first target information model belong to the first two information models on the target query chain. The user can also optionally perform a selection operation on the identifier information of an information model that has a preset association relationship with the first target information model to select the next target information model on the target query chain. For each target information model, the user can perform a selection operation on an information model that has a preset association relationship with that target information model to select the next target information model on the target query chain until the last target information model is determined. Therefore, there is a preset association relationship between every two adjacent information models on the target query chain. It can be understood that the target query chain can include at least the initial information model and the first target information model, and can also optionally include other information models besides the initial information model and the first target information model. For example, each information model can have one or more fields, and the fields can represent data attributes. Specifically, each information model can include one or more objects, and each object can have field values ​​corresponding to each field. For example, a sample information model can include fields such as sample ID, creation time, and OD value. If the field value corresponding to the creation time field for a sample object is T0, it indicates that the creation time of the sample corresponding to that sample object is T0. It can be understood that the field values ​​corresponding to different fields for each object can represent different data attributes of that object. The target field can be any field in the last target information model; it can be a default field or a user-specified field.

[0035] In step S140, in response to the query item generation instruction, query items are generated on the query form based on the target query chain.

[0036] For example, a query form can perform structured queries based on user-inputted information using query items. The query form may have elements such as input boxes, drop-down menus, and buttons (for operations like insert, reset, and query). This embodiment of the invention does not specifically limit the structure and style of the query form. In some embodiments, a general query form can be generated in response to user actions before executing step S110. In this case, the query form may have a functional area for specifying an initial information model. The user can specify the initial information model in the functional area. After determining the initial information model, the query form can be updated to a form for querying related data based on the initial information model. In other embodiments, after executing step S110, a query form for the initial information model can be directly generated in response to user instructions. This approach will be described in detail below and will not be repeated here. For example, the number of query item generation instructions can be one or more, and correspondingly, the number of query items created can be one or more. Each query item generation instruction is used to encapsulate the corresponding target query chain into an interactive control on the query form. The query item is used to query information related to the input information along the corresponding target query chain, thereby outputting the corresponding query result.

[0037] The aforementioned technical solution identifies and displays information models associated with the initial information model through a forward query approach. This intuitively shows users all information models that have a positive correlation with the initial information model. The forward query can indicate the direction of the correlation between information models, guiding users to find the required information model and construct the target query chain according to the positive correlation. The construction process of the target query chain is relatively clear and controllable. Furthermore, by constructing the target query chain based on the user's selection operation of the first associated information model, this interactive method is simple and easy to understand, significantly reducing the difficulty of user operation. Moreover, users can use the query items generated based on the target query chain to perform data queries without having to repeatedly navigate between multiple information models, saving time and increasing efficiency.

[0038] Optionally, the method further includes: controlling the display window to output and display the identifier information of the initial information model and the identifier information of the first associated information model in a hierarchical menu; in the hierarchical menu, the identifier information of the initial information model is the parent menu of the identifier information of the first associated information model; the selection operation is an operation of selecting a menu in the hierarchical menu.

[0039] For example, each information model has unique identification information, such as the model name, model ID, or model code. This identification information indicates the corresponding information model. The hierarchical menu is a parent-child structure; the initial information model's identification information can be the parent menu, and the first associated information model's identification information can be the child menu. The parent menu is the parent menu of the child menu. Please refer to [link / reference]. Figure 2 The diagram shown is a schematic representation of a hierarchical menu according to an embodiment of the present invention. Figure 2 In the illustrated embodiment, the identifier of the initial information model is "GeneStructure". Users can enter a forward query command by clicking the "Forward Query" option. The forward query command instructs the determination of the first associated information model through a forward query. In this embodiment, the initial information model has six first associated information models, each with identifiers of "Related samples", "Related device", "Related labware", "Related reagent", "samplec", and "samplecc". These six first associated information model identifiers are sub-menus of the initial information model identifier "GeneStructure" in the hierarchical menu.

[0040] This approach can present the relationships between abstract information models to users through a visual hierarchical structure. This can intuitively demonstrate the hierarchical relationships between information models and help users distinguish between the initial information model and the first related information model to be selected.

[0041] Optionally, determining a first associated information model that has a preset association relationship with the initial information model includes: determining one or more first associated information models based on one or more associated fields of the initial information model, wherein the first associated information model is an information model that includes at least some of the associated fields of one or more associated fields in a plurality of information models; and displaying the identification information of the first associated information model in the target directory at the level corresponding to the first associated information model in the hierarchical menu, wherein the target directory is the associated fields contained in the first associated information model.

[0042] For example, the initial information model can be an information model holding a foreign key, where the foreign key is a field that can point to the primary key of one or more other information models. These one or more information models constitute the first associated information model, and the foreign key is the associated field. For instance, the sample information model can have a "Device ID" field, which can point to a device information model that uses "Device ID" as its primary key. After establishing a positive association between the device information model and the sample information 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 first associated information model, the associated field (i.e., the primary key) must satisfy the following: the field value corresponding to the associated field of each object in the first associated information model is unique within the model. It can be understood that since the initial information model can have one or more first associated information models, the associated fields of the initial information model can also be one or more. There exists a situation where two or more first-level associated information models can share a single associated field. For example, two first-level associated information models may both belong to the sample class and both have a "sample ID" field. In this case, the field values ​​corresponding to the sample ID for all sample objects in the two first-level associated information models will be different. The hierarchy menu corresponding to the first-level associated information model can display a target directory, which can include all associated fields contained in all first-level associated information models. The identification information of the first-level associated information model can be displayed under the corresponding associated field. Users can select an associated field in the target directory and then select the first target information model from the first-level associated information models under that associated field.

[0043] In the above technical solution, by displaying the identifier information of the first associated information model under the corresponding associated fields, the associated path is more intuitive and predictable when the user constructs the target query chain. Since the forward query can determine the first associated information model of the defined associated fields from the initial information model that defines the associated fields, the user can directly start from the associated fields of the initial information model. The user can predict the associated information model by seeing the associated fields. This greatly reduces the difficulty for users to understand the relationship between information models.

[0044] Optionally, there may be multiple associated fields, and these associated fields may be different from each other.

[0045] For example, the initial information model can hold multiple different associated fields, each of which can point to one or more first associated information models. When there are many first associated information models, it is more efficient and convenient for users to find the first target information model by following the target directory compared to traversing the first target information models.

[0046] Optionally, after determining the initial information model among a plurality of preset information models, the method further includes: receiving a query form generation instruction, the query form generation instruction being used to instruct the generation of a query form for the initial information model; and in response to the query form generation instruction, generating a query form according to a preset query form framework.

[0047] For example, a user can input query form generation instructions via an interactive device. The query form generation instructions may include insertion instructions for inserting a query form onto a display interface based on a selected initial information model. See also... Figure 3 The diagram shown is a schematic representation of the input interface for a query form generation instruction according to an embodiment of the present invention. Figure 3 In the illustrated embodiment, the information model can be categorized, including sample information models, reagent information models, consumable information models, equipment information models, project information models, experimental record information models, and catalog information models. Users can first select the category of the information model they wish to query, and then select a specific information model within that category as the initial information model. Figure 3 In the illustrated embodiment, the currently selected information model is a sample-type information model. Correspondingly, the names of each information model categorized as a sample-type information model are selected so that the user can determine the initial information model from among these models. When the user clicks the "Insert" button, the processor receives a query form generation instruction. See also... Figure 4 As shown, it is a schematic diagram of a query form according to an embodiment of the present invention. Figure 4 In the illustrated embodiment, the initial information model selected by the user is named "sample_test_one". This approach can quickly generate a corresponding query form based on the user's query requirements to retrieve relevant data from objects in the initial information model using a query form.

[0048] Optionally, the method further includes: when the first target information model is not the last information model in the target query chain, determining the target query chain based on the initial information model and the first target information model, including: taking the first target information model as the current target information model, and performing the following model determination operation: determining one or more second associated information models that have a preset association relationship with the current target information model based on the current target information model, and displaying the identification information of each of the one or more second associated information models; responding to the user's selection operation on the identification information of the one or more second associated information models, determining the second target information model among the one or more second associated information models; taking the second target information model as the new current target information model, and returning to perform the model determination operation until the last information model in the target query chain is determined.

[0049] For example, after determining the target information model on the target query chain each time, the user can select the next target information model on the target query chain according to the query requirements. Specifically, after determining the first target information model, the first target information model can be used as the current target information model. The preset multiple information models can include one or more second associated information models that have a preset association relationship with the current target information model. Based on the current target information model, the second associated information models of the current target information model can be determined, and the identification information of each determined second associated information model can be output and displayed. The user can select an identification information from the identification information of the second associated information models of the current target information model. The information model indicated by the identification information is the second target information model. The determined second target information model can be used as the new current information model, and the user can continue to perform model determination operations for the new current information model until the last information model of the target query chain is determined. The target query chain can include an initial information model, a first target information model, and at least one second target information model connected in sequence.

[0050] The above technical solution determines the target information model through hierarchical interaction with the user, which can decompose the complex target query chain construction process across multiple information models into a simple single-step selection operation, thus reducing the difficulty for users to construct complex target query chains. By providing users with optional related information models at the next level based on preset relationships, it helps users to correctly construct a complete target query chain from the initial information model to the last target information model, which helps ensure that valid query items are generated in the end.

[0051] Optionally, the preset association relationship also includes a reverse association relationship. The first association information model also includes an information model that has a reverse association relationship with the initial information model, which is determined by a reverse query method. The reverse association relationship means that other information models can be mapped unidirectionally to the current information model.

[0052] For example, the initial information model can hold a primary key, and foreign keys in other information models can also point to the primary key of the initial information model. For an explanation of primary and foreign keys, please refer to the relevant descriptions in the foregoing embodiments; they will not be repeated here. Using a reverse query approach, information models whose foreign keys point to the primary key of the initial information model can be identified; that is, information models with a reverse association relationship with the initial information model. The association logic of the target query chain constructed by this scheme can combine forward and reverse association logic, allowing users to flexibly construct the target query chain according to their data query direction requirements.

[0053] Optionally, the multiple information models include one or more objects that represent experimental data. After generating query items on the query form based on the target query chain in response to the query item generation instruction, the method further includes: determining the object to be queried in the initial information model; and determining the field value corresponding to the target field of the target object by utilizing the query items and the object mapping relationship between the object in each information model on the target query chain and the object in the adjacent information model. The target object is the object in the last information model on the target query chain that has a mapping relationship with the object to be queried.

[0054] For example, the object to be queried is one or more objects selected by the user in the initial information model according to the query requirements. For each pair of adjacent information models on the target query chain, an object in one information model can have a pre-built object mapping relationship with an object in the other information model. After determining the object to be queried, objects in the first target information model on the target query chain that have an object mapping relationship with the object to be queried can be determined. If the first target information model is not the last information model, objects in the next target information model after the first target information model that have an object mapping relationship with the objects determined in the first target information model can be determined, and so on, until the target object in the last target information model 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 are 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 information model is acceptable.

[0055] The above technical solution utilizes the object mapping relationship between objects in adjacent information models on the target query chain to determine the query results for the object to be queried. It can automatically and efficiently determine the data that the user wants to query. Especially when there are multiple information models on the target query chain, this solution can automatically search for target objects with object mapping relationships with the object to be queried across multiple information models along the target query chain, 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, so that the user does not have to jump between multiple information models to search.

[0056] Please see Figure 3 The diagram shown is a schematic block diagram of a query item generation system 500 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 500 comprising:

[0057] The first determining module 510 is used to determine the initial information model from a set of preset information models;

[0058] Display module 520 is used to determine a first associated information model that has a preset association relationship with the initial information model, and to display the identification information of the first associated information model. The first associated information model includes information models that have a positive association relationship with the initial information model, which are determined by a positive query method. A positive association relationship means that the current information model can be mapped unidirectionally to other information models. The preset association relationship includes positive association relationships.

[0059] The second determining module 530 is used to respond to the user's selection operation on the identification information of the first associated information model, determine the first target information model in the first associated information model, and determine the target query chain based on the initial information model and the first target information model. The target query chain includes the initial information model, at least one target information model and the target field of the last target information model of the at least one target information model connected in sequence. The at least one target information model includes the first target information model. There is a preset association relationship between each two adjacent information models in the target query chain.

[0060] The generation module 540 is used to generate query items on the query form based on the target query chain in response to the query item generation instruction.

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

[0062] For example, the information 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, an information model containing one or more objects can be created. For example, predefined relationships between information models can be established using primary and foreign keys. For information models requiring predefined relationships, a specific field (e.g., sample ID) can be defined as the primary key in one information model, and a foreign key (usually a field consistent with the aforementioned specific field) pointing to the primary key can be set in another information model. For example, for every two information models with established predefined relationships, if it is necessary to establish an object mapping relationship between the objects contained in each of the two information 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 information model in the information model with the foreign key.

[0063] According to another aspect of the present invention, an information model generation system is also provided for creating information models as described above, the system comprising:

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

[0065] The second creation module is used to create a preset association relationship between each information model and one or more other information models, for each of the multiple information models;

[0066] The third creation module is used to create an object mapping relationship between each object of at least a portion of the objects of one information model and at least a portion of the objects of the other information model for every two information models with a preset association relationship, wherein the information models in the target query chain are at least a portion of the multiple information models.

[0067] 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 query item generation method and / or information model generation method of the above-mentioned query form.

[0068] 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 information 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 information 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 information model generation system of 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.

[0069] 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 an information model generation method for a query form as described above.

[0070] Those skilled in the art can understand the specific implementation and beneficial effects of the query item generation system, information 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, it will not be elaborated further here.

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

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

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

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

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

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

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

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

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

[0080] 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: Determine the initial information model from among several pre-defined information models; A first associated information model with a preset association relationship with the initial information model is determined, and the identification information of the first associated information model is displayed. The first associated information model includes information models with a positive association relationship with the initial information model determined by a positive query method. The positive association relationship indicates that the current information model can be mapped unidirectionally to other information models. The preset association relationship includes the positive association relationship. In response to a user's selection operation on the identifier information of the first associated information model, a first target information model is determined in the first associated information model, and a target query chain is determined based on the initial information model and the first target information model. The target query chain includes the initial information model, at least one target information model, and the target field of the last target information model of the at least one target information model connected in sequence. The at least one target information model includes the first target information model. There is a preset association relationship between every two adjacent information models in the target query chain. In response to the query item generation instruction, a query item is generated on the query form based on the target query chain.

2. The method according to claim 1, characterized in that, The method further includes: The control display window displays the identification information of the initial information model and the identification information of the first associated information model through a hierarchical menu. In the hierarchical menu, the identification information of the initial information model is the parent menu of the identification information of the first associated information model; The selection operation refers to the operation of selecting a menu item from the hierarchical menu.

3. The method according to claim 2, characterized in that, The first associated information model, which has a preset association relationship with the initial information model, includes: One or more first associated information models are determined based on one or more associated fields of the initial information model, wherein the first associated information model is an information model that includes at least some of the associated fields of the one or more associated fields in the plurality of information models; In the hierarchy menu corresponding to the first associated information model, the identification information of the first associated information model is displayed in the target directory, where the target directory is the associated fields contained in the first associated information model.

4. The method according to claim 1, characterized in that, After determining the initial information model from among the preset multiple information models, the method further includes: Receive a query form generation instruction, the query form generation instruction being used to instruct the generation of a query form for the initial information model; In response to the query form generation instruction, a query form is generated according to a preset query form framework.

5. The method according to any one of claims 1-4, characterized in that, The method further includes: when the first target information model is not the last information model of the target query chain, determining the target query chain based on the initial information model and the first target information model includes: Using the first target information model as the current target information model, perform the following model determination operation: Based on the current target information model, determine one or more second associated information models that have a preset association relationship with the current target information model, and display the identification information of each of the one or more second associated information models; In response to a user's selection operation on the identification information of one or more second associated information models, a second target information model is determined from the one or more second associated information models; The second target information model is used as the new current target information model, and the model determination operation is performed again until the last information model of the target query chain is determined.

6. The method according to any one of claims 1-4, characterized in that, The preset association relationship also includes a reverse association relationship. The first association information model also includes an information model that has a reverse association relationship with the initial information model, which is determined by a reverse query method. The reverse association relationship indicates that other information models can be mapped unidirectionally to the current information model.

7. The method according to any one of claims 1-4, characterized in that, The multiple information models include one or more objects representing experimental data. After generating query items on the query form based on the target query chain in response to the query item generation instruction, the method further includes: Determine the query object of the initial information model; By utilizing the query item and the object mapping relationship between objects in each information model on the target query chain and objects in adjacent information models, the field value corresponding to the target field of the target object is determined. The target object is the object in the last information model on the target query chain that has a mapping relationship with the object to be queried.

8. A query item generation system for a query form, characterized in that, The system includes: The first determining module is used to determine the initial information model from a set of preset information models; The display module is used to determine a first associated information model that has a preset association relationship with the initial information model, and to display the identification information of the first associated information model. The first associated information model includes information models that have a positive association relationship with the initial information model, determined by a positive query method. The positive association relationship indicates that the current information model can be mapped unidirectionally to other information models. The preset association relationship includes the positive association relationship. The second determining module is used to respond to the user's selection operation on the identification information of the first associated information model, determine the first target information model in the first associated information model, and determine the target query chain based on the initial information model and the first target information model. The target query chain includes the initial information model, at least one target information model, and the target field of the last target information model of the at least one target information model connected in sequence. The at least one target information model includes the first target information model. There is a preset association relationship between each two adjacent information models in the target query chain. The generation module is used to generate query items on the query form based on the target query chain in response to the query item generation instruction.

9. A method for generating an information model, characterized in that, The method for creating an information model as described in any one of claims 1-7 includes: Multiple information models are created, each of the multiple information models including at least one object, and each of the at least one object is used to represent experimental data; For each of the plurality of information models, a preset association relationship is created between that information model and one or more other information models besides that information model; For every two information models with a preset association, an object mapping relationship is created between each object of at least a portion of the objects in one information model and at least a portion of the objects in the other information model, wherein the information models in the target query chain are at least a portion of the multiple information models.

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

11. 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-7 and / or the information model generation method as described in claim 9.

12. 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-7 and / or the information model generation method as described in claim 9.

Images