Sample result query method, sample analyzer and storage medium

By setting up the database and cache space in the sample analyzer, generating and storing data query tasks, filtering the current query results using page refresh instructions, and displaying pre-query results in response to user page turn operations, the problem of excessive loading time in the existing technology is solved, and fast and timely data query and result display is achieved.

CN120234346APending Publication Date: 2025-07-01CHEMCLIN DIAGNOSTICS CO LTD

Patent Information

Application Number
CN202311840277.0
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2023-12-28
Publication Date
2025-07-01

AI Technical Summary

Technical Problem

In the prior art, when the number of query results is too large, the current page cannot be loaded in time, and re-query is required when switching pages, resulting in too long page loading time.

Method used

By setting up the database and cache space in the sample analyzer, data query tasks are generated and query results are stored, the page refresh instructions are used to filter the current query results, and prequery results are stored in the cache space, and prequery results are displayed in response to user page turn operations.

Benefits of technology

It realizes that when there are too many query results, the current query results are displayed in a timely manner, and the pre-query results are quickly loaded when the user turns the page, ensuring that the data query and result display are synchronized.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN120234346A_ABST
    Figure CN120234346A_ABST
Patent Text Reader

Abstract

The invention relates to a sample result query method, a sample analyzer and a storage medium, and is applied to the sample analyzer, the sample analyzer is provided with a database and a cache space, sample query information input by a user on a data query interface is obtained, the sample query information is adopted to generate a data query task, and the data query task is sent to the database. Then, screening query results matched with the data query task from the database, storing the query results in a cache space, receiving a page refreshing instruction for a data query interface, screening current query results matched with the page refreshing instruction from the query results in the cache space, and meanwhile, taking the remaining query results as pre-query results; and displaying the pre-query result to the data query interface in response to a page turning operation executed by the user on the data query interface. According to the scheme provided by the invention, the query result can be quickly displayed to the data query interface, and the function of synchronously performing data query and result display is realized.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] This application relates to the technical field of data processing, and particularly relates to a method for querying results of samples, a sample analyzer, and a storage medium. Background Art

[0002] Data query refers to extracting specified field values from a large amount of data and using the specified field values as the query results of the data query. Currently, the following two methods are generally used for data query of web pages:

[0003] The first method is to query all data in the database during the initialization of the query program, and then add all the data to the cache space. When the user queries the results, the corresponding data can be directly obtained from the cache space, and then the obtained data is paged, and the paged results are returned to the front-end interface for display to the user.

[0004] The second method is that when the user queries the results, only the data of the current page is queried in the database, and then the results of the current page are returned to the front-end interface for display to the user. When querying the results of the previous page or the next page, it is necessary to query again in the database.

[0005] When the number of query results is too large, since the first method needs to traverse all the data in the database and then return the query results, it will cause the current page to be unable to be loaded in time, and the user cannot quickly obtain the query results of the current page. Although the second method can display the current page first, when switching to the previous page or the next page, it is necessary to query the results of the previous page or the next page again, which also causes the other pages to be unable to be loaded in time. Both the first method and the second method have the problem of too long page loading time. Summary of the Invention

[0006] This application provides a method for querying results of samples, a sample analyzer, and a storage medium, which can solve or partially solve the problem that when the number of query results is too large, the result data cannot be loaded in time and quickly in the related art.

[0007] In the first aspect of this application, a method for querying results of samples is provided, which is applied to a sample analyzer. The sample analyzer is equipped with a database and a cache space. The method includes:

[0008] Obtain the sample query information input by the user on the data query interface, and generate a data query task by using the sample query information;

[0009] Send the data query task to the database, screen the query results matching the data query task from the database, and store them in the cache space;

[0010] Receive a page refresh instruction for the data query interface, filter the current query results matching the page refresh instruction from the query results in the cache space, and at the same time use the remaining query results as pre-query results;

[0011] In response to the paging operation performed by the user on the data query interface, display the pre-query results on the data query interface.

[0012] In one embodiment, the sending the data query task to the database, filtering the query results matching the data query task from the database, and storing them in the cache space includes:

[0013] Obtain the detected sample size from the database;

[0014] Split the data query task into several query subtasks by using the detected sample size and a preset data volume;

[0015] Synchronously execute the several query subtasks, filter the query results matching the data query task from the database, and store the query results in the cache space;

[0016] Wherein, the data volume of each query subtask is equal to or less than the preset data volume, and the sum of the data volumes of all the query subtasks is equal to the total data volume.

[0017] In one embodiment, the data query interface includes the number of pages displayed; the preset data volume is greater than or equal to the number of pages displayed.

[0018] In one embodiment, the synchronously executing the several query subtasks, filtering the query results matching the data query task from the database, and storing the query results in the cache space includes:

[0019] Synchronously execute the several query subtasks, filter the query results matching the data query task from the database until all the query subtasks are completed;

[0020] Sort the query results according to a preset sorting strategy to obtain the result serial numbers of all the query results;

[0021] Store the sorted query results and the result serial numbers in the cache space.

[0022] In one embodiment, the receiving a page refresh instruction for the data query interface, filtering the current query results matching the page refresh instruction from the query results in the cache space, and at the same time using the remaining query results as pre-query results includes:

[0023] Receive a page refresh instruction for the data query interface, where the page refresh instruction includes the number of pages displayed on the data query interface;

[0024] Use the number of pages displayed and the result serial number to determine the current query range, and sequentially extract query results within the current query range from the cache space;

[0025] Use the query results within the current query range as the current query results, display them on the data query interface, and use the remaining query results as the pre-query results.

[0026] In one embodiment, the step of displaying the pre-query results on the data query interface in response to the user's paging operation on the data query interface includes:

[0027] In response to the user's paging operation on the data query interface, calculate the pre-query quantity corresponding to the paging operation;

[0028] Use the pre-query quantity and the result serial number of the remaining query results to determine the pre-query range, and sequentially extract query results within the pre-query range from the cache space;

[0029] Use the query results within the pre-query range as the pre-query results and display them on the data query interface.

[0030] In one embodiment, the data query task includes a single query task, and the method further includes:

[0031] After the single query task is executed, mark the current query results and the pre-query results as historical query data;

[0032] Periodically clean the historical query data in the cache space.

[0033] In one embodiment, the data query task includes multiple query tasks, and the multiple query tasks include the current query task and the previous query task of the current query task. The method further includes:

[0034] After the current query task is executed, mark the current query results and the pre-query results of the previous query task as historical query data;

[0035] Real-time clean the historical query data in the cache space.

[0036] A second aspect of the present application provides a sample analyzer, which is equipped with a database and a cache space, including:

[0037] A query task generation module, configured to obtain sample query information input by a user on a data query interface, and generate a data query task by using the sample query information;

[0038] A query result matching module, configured to send the data query task to the database, screen query results matching the data query task from the database, and store them in the cache space;

[0039] A current query result display module, configured to receive a page refresh instruction for the data query interface, screen current query results matching the page refresh instruction from the query results in the cache space, and at the same time use the remaining query results as pre-query results;

[0040] A pre-query result display module, configured to display the pre-query results on the data query interface in response to a paging operation performed by the user on the data query interface.

[0041] A third aspect of the present application provides a computer-readable storage medium, on which executable code is stored. When the executable code is executed by a processor of an electronic device, the processor is caused to execute the method described above.

[0042] The technical solution provided by the present application may include the following beneficial effects:

[0043] In the embodiment of the present application, it is applied to a sample analyzer. The sample analyzer is equipped with a database and a cache space. It obtains sample query information input by a user on a data query interface, generates a data query task by using the sample query information, sends the data query task to the database, then screens query results matching the data query task from the database and stores them in the cache space, receives a page refresh instruction for the data query interface, screens current query results matching the page refresh instruction from the query results in the cache space, and at the same time uses the remaining query results as pre-query results, and in response to a paging operation performed by the user on the data query interface, displays the pre-query results on the data query interface. The technical solution provided by the present application can ensure that when the number of query results is too large, the current query results are preferentially screened and timely displayed, and when the user performs a paging operation, the pre-query results can be quickly displayed on the data query interface, thereby realizing the function of synchronously performing "data query" and "result display".

[0044] It should be understood that the above general description and subsequent detailed description are only exemplary and explanatory, and cannot limit the present application. Description of the Drawings

[0045] The above and other objects, features, and advantages of the present application will become more apparent by describing the exemplary embodiments of the present application in more detail with reference to the accompanying drawings, wherein, in the exemplary embodiments of the present application, the same reference numerals generally represent the same components.

[0046] Figure 1 is a schematic flowchart of a method for querying the results of a sample shown in an embodiment of the present application;

[0047] Figure 2 is another schematic flowchart of a method for querying the results of a sample shown in an embodiment of the present application;

[0048] Figure 3 is a schematic flowchart of a method for asynchronously querying data shown in an embodiment of the present application;

[0049] Figure 4 is a schematic structural diagram of a sample analyzer shown in an embodiment of the present application;

[0050] Figure 5 is another schematic structural diagram of a sample analyzer shown in an embodiment of the present application. Detailed Embodiments

[0051] The embodiments of the present application will be described in more detail below with reference to the accompanying drawings. Although the embodiments of the present application are shown in the drawings, it should be understood that the present application can be implemented in various forms and should not be limited by the embodiments set forth herein. On the contrary, these embodiments are provided to make the present application more thorough and complete, and to fully convey the scope of the present application to those skilled in the art.

[0052] The terms used in the present application are for the purpose of describing specific embodiments only and are not intended to limit the present application. The singular forms "a", "the", and "said" used in the present application and the appended claims are also intended to include the plural forms unless the context clearly dictates otherwise. It should also be understood that the term "and / or" as used herein refers to and includes any and all possible combinations of one or more of the associated listed items.

[0053] It should be understood that although the terms "first", "second", "third", etc. may be used in the present application to describe various information, such information should not be limited to these terms. These terms are only used to distinguish the same type of information from each other. For example, without departing from the scope of the present application, the first information may also be referred to as the second information, and similarly, the second information may also be referred to as the first information. Thus, the features defined with "first" and "second" may explicitly or implicitly include one or more of such features. In the description of the present application, "a plurality" means two or more unless otherwise specifically defined.

[0054] In current query technologies, when a large number of result data are queried at one time, since the relevant query software needs to fully load the result data before displaying it on the corresponding interface, or when the relevant query software requests to display the result data of other pages, it needs to re-query the result data of that page, resulting in the inability to load the corresponding result data in a timely and rapid manner.

[0055] In view of the above problems, an embodiment of the present application provides a method for querying results of samples, which can ensure that when the number of query results is excessive, the current query results are preferentially filtered and displayed in a timely manner, and when the user performs a paging operation, the pre-query results can be quickly displayed on the data query interface, thereby realizing the function of synchronously performing "data query" and "result display".

[0056] The technical solutions of the embodiments of the present application are described in detail below with reference to the accompanying drawings.

[0057] Figure 1 is a schematic flowchart of a method for querying results of samples shown in an embodiment of the present application. Refer to Figure 1 , which is applied to a sample analyzer. The sample analyzer is equipped with a database and a cache space. The method at least includes the following steps:

[0058] Step 101, obtain the sample query information input by the user on the data query interface, and generate a data query task by using the sample query information;

[0059] In the embodiment of the present application, the sample analyzer can obtain the sample query information input by the user on the data query interface, and then generate a corresponding data query task by using the sample query information.

[0060] Among them, the sample analyzer is equipped with a database and a cache space. In the present application, the control computer that actually performs data processing in the sample analyzer can be integrated with the sample analyzer body, or can be separated from the sample analyzer body. The database can be a local database in the sample analyzer or a remote database configured in the cloud. The cache space can be a physical cache or a virtual cache. For example, the cache of the database, the memory cache, the processor cache, etc. The present application does not limit the type of the cache space.

[0061] Optionally, the data query interface can be a function interface provided by a display screen configured in the sample analyzer. Generally, a variety of interactive controls or text input boxes are set in the data query interface.

[0062] The sample query information can be information associated with the sample input by the user on the data query interface. For example, the query conditions required for querying the results of the sample and the query order of the sample.

[0063] A data query task can be a task generated by a sample analyzer based on sample query information when it receives a query operation performed by a user on a data query interface.

[0064] Step 102: Send the data query task to the database, screen query results matching the data query task from the database, and store them in the cache space.

[0065] In an embodiment of the present application, the sample analyzer can send the data query task to the database, then screen query results matching the data query task from the database, and store the matching query results in the cache space.

[0066] Optionally, the query results can be sample detection results matching the query conditions, and the query results include at least the current query results and the pre-query results.

[0067] Among them, the current query results refer to the results currently displayed on the data query interface, such as the results on the first page, and the pre-query results can be the results on the Nth page provided on the data query interface, where N is an integer greater than 1.

[0068] As an example, the sample query information input by the user on the data query interface is: search for content containing "photoexcitation". The relevant query software can traverse all data in the database according to the sample query information, extract the content associated with "photoexcitation", and use the content associated with "photoexcitation" as the query results and store them in the cache space.

[0069] Step 103: Receive a page refresh instruction for the data query interface, screen the current query results matching the page refresh instruction from the query results in the cache space, and at the same time use the remaining query results as the pre-query results.

[0070] In an embodiment of the present application, it is possible to receive a page refresh instruction for the data query interface, screen the current query results matching the page refresh instruction from the query results in the cache space, and at the same time use the remaining query results as the pre-query results.

[0071] Optionally, when the data query interface asynchronously queries the query results of the first page, the sample analysis will immediately refresh the first page, generate a page refresh instruction, and use the page refresh instruction to instruct the sample analyzer to screen the matching current query results from the query results in the cache space, and the sample analyzer still continues to execute the query operation.

[0072] Step 104: In response to a paging operation performed by the user on the data query interface, display the pre-query results on the data query interface.

[0073] In an embodiment of the present application, the sample analyzer may also respond to the paging operation performed by the user on the data query interface, and display the pre-query result on the data query interface.

[0074] Optionally, the paging operation may be an operation where the user clicks the next page or the previous page on the data query interface.

[0075] The technical solution provided in the above embodiment of the present application can ensure that when the number of query results is too large, the current query results are preferentially screened and displayed in a timely manner, and when the user performs a paging operation, the pre-query result can be quickly displayed on the data query interface, thereby realizing the function of synchronously performing "data query" and "result display".

[0076] Figure 2 It is a schematic flowchart of a method for querying the results of a sample shown in another embodiment of the present application. Figure 2 Relatively Figure 1 The technical solution of the embodiment of the present application is described in more detail. The method may include the following steps:

[0077] Step 201, obtain the sample query information input by the user on the data query interface, and generate a data query task using the sample query information;

[0078] In an embodiment of the present application, the sample analyzer is installed with relevant query software, which has the function of asynchronous query. Asynchronous means that the requester and the requested party can use different clocks, similar to the multi-threaded processing of a computer. Therefore, asynchronous query processing can continue to execute the data query task without blocking the UI (User Interface) until all query subtasks of the data query task are completed, and the function of synchronously performing "data query" and "result display" is realized through asynchronous query processing to ensure the timely loading or display of relevant result data.

[0079] Step 202, obtain the detected sample quantity from the database;

[0080] In an embodiment of the present application, the database stores various data associated with the sample. For example, sample ID (Identity Document, encoding), detection results, and other instrument operation data.

[0081] Among them, the detection results at least include the detected sample quantity, the detection data of each sample, etc. When performing data query, the relevant query software needs to obtain the detected sample quantity from the database. For example, obtain the sample query result with a detected sample quantity of 10,000 from the database.

[0082] Step 203, split the data query task into several query subtasks using the detected sample quantity and the preset data quantity;

[0083] In an embodiment of the present application, the relevant query software may split a data query task into several query subtasks by using the detected sample quantity and a preset data quantity. Moreover, the data quantity of each query subtask is equal to or less than the preset data quantity, and the sum of the data quantities of all query subtasks is equal to the detected sample quantity.

[0084] Among them, the preset data quantity may be the query quantity corresponding to each subtask set in advance. For example, if the preset database stores 10,000 pieces of data, and then the average value of the 10,000 pieces of data is calculated to obtain five groups of data, with each group of data including 2,000 pieces of data, then 2,000 pieces of data can be used as a query subtask of the data query task, and the five groups of data correspond to five query subtasks.

[0085] In addition, the data query interface further includes the page display quantity, and the preset data quantity is greater than or equal to the page display quantity. The page display quantity may be the number of result items displayed on each page in the data query interface. Assuming the page display quantity is 20, it means that the number of result items displayed on each page is 20.

[0086] Step 204: Synchronously execute several query subtasks, screen query results matching the data query task from the database, and store the query results in the cache space;

[0087] In an embodiment of the present application, after the relevant query software splits the data query task into several query subtasks, it may synchronously execute several query subtasks, screen query results matching the data query task from the database, and store the query results in the cache space. Thus, by splitting one data query task into multiple query subtasks and synchronously executing multiple query subtasks, the data query speed can be accelerated and the query efficiency can be improved.

[0088] In an implementation manner, synchronously execute several query subtasks, screen query results matching the data query task from the database until all the several query subtasks are completed, sort the query results according to a preset sorting strategy to obtain the result numbers of each query result, and store the sorted query results and the result numbers in the cache space.

[0089] As an example, the preset sorting strategy may be a strategy set in advance for sorting and numbering each query result. For example, sort them in sequence according to the detection time of the samples or the sample IDs and number them in sequence. The present application does not limit the actual sorting and numbering methods.

[0090] As another example, the preset sorting strategy can also be a strategy for grouping each query interface, which includes a preset number range. The preset number range is a number interval set in advance by the user and can be used to determine the total number of query results displayed on the data query interface. Suppose the preset number range is [1, 2000], then the total number of query results is 2000. Each query result is numbered according to the time sequence of the query, and then grouped in ascending order of the numbers.

[0091] For example, suppose the number of pages displayed is 20 and the preset number range is [1, 1000]. After the user enters sample query information in the data query interface of the relevant query software, the relevant query software filters out 1000 query results from the database through the sample query information. Then, the query results are paged according to the standard of 20 results per page, and the number of pages corresponding to the query results is obtained as 50 pages. The 50-page result data is stored in the cache space in the query order.

[0092] Step 205: Receive a page refresh instruction for the data query interface, filter out the current query results matching the page refresh instruction from the query results in the cache space, and at the same time use the remaining query results as pre-query results.

[0093] In the embodiment of the present application, the relevant query software can receive a page refresh instruction for the data query interface, determine the current query range by using the number of pages displayed and the result serial number, sequentially extract the query results within the current query range from the cache space, use the query results within the current query range as the current query results, and display them on the data query interface. At the same time, use the remaining query results as pre-query results.

[0094] Among them, the current query range can be the result range displayed on the first page of the data query interface. For example, the current query range is [1, 20], and the query result serial numbers displayed on the first page of the data query interface are serial numbers 1 to serial number 20.

[0095] Step 206: In response to the paging operation performed by the user on the data query interface, display the pre-query results on the data query interface.

[0096] In the embodiment of the present application, by responding to the paging operation performed by the user on the data query interface, calculate the pre-query quantity corresponding to the paging operation. Then, determine the pre-query range by using the pre-query quantity and the result serial numbers of the remaining query results, sequentially extract the query results within the pre-query range from the cache space, and use the query results within the pre-query range as the pre-query results and display them on the data query interface.

[0097] Among them, the page turning operation performed by the user is often associated with the page code. For example, the data query interface displays the query results of the third page, and the user touches the "next page" control in the interface to perform the page turning operation. Then, after responding to the page turning operation, the relevant query software can obtain the page code corresponding to the page turning operation as the fourth page, read the pre-query result of the fourth page from the cache space, and return the pre-query result to the data query interface.

[0098] The pre-query range can be the result range displayed on the Nth page of the data query interface. The pre-query range is determined by the pre-query quantity corresponding to the page turning operation and the result serial numbers of the remaining query results. For example, the page code corresponding to the page turning operation is the second page, and the result serial numbers displayed on the second page are determined to be serial numbers 21 to 40. The pre-query range is determined to be [21, 40]. The query results located at [21, 40] are extracted from the cache space in sequence and displayed on the data query interface. When the user turns the page, the data can be read directly from the cache space without initiating a request again, thereby improving the query speed and response time, and significantly improving the user experience.

[0099] In one implementation, after a single query task is executed, the current query result and the pre-query result are marked as historical query data, and the historical query data in the cache space is cleaned up irregularly.

[0100] In one embodiment, a data query task includes multiple query tasks, and the multiple query tasks include a current query task and a query task previous to the current query task. After the current query task is executed, the current query result and the pre-query result of the previous query task can be marked as historical query data, and the historical query data in the preset cache space can be cleaned up in real time until the last query task is executed. For example, if three query tasks need to be executed, the first data can be cleaned up immediately when the second query task is executed, and the second data can be cleaned up immediately when the third query task is executed.

[0101] By automatically cleaning up data, you can avoid abnormal problems caused by excessive memory in terminal devices (such as computers), such as slow system operation, software crashes, file corruption, file loss, computer blue screens, and computer freezes, thereby improving system stability and reliability.

[0102] Reference Figure 3 , Figure 3 This is a schematic diagram of a process of asynchronously querying data shown in an embodiment of the present application, which may include the following steps:

[0103] S31. When a user queries a large amount of result data at one time through a relevant query software, the relevant query software can receive data query tasks for several pages, and each data query task includes multiple query subtasks.

[0104] S32. Obtain the sample query information input by the user in the data query interface, such as query conditions and query order, and then execute multiple query subtasks, extract the query results of the first page from the database, store the query results of the first page in the background cache, and return them to the data query interface for display. At this time, it indicates that the query task of the first page is completed, and the first page is immediately refreshed. The background of the relevant query software will not stop data query, and it can continue to execute query subtasks.

[0105] S33. Asynchronously query the query results of the second page, the third page... the Nth page in sequence according to the query order, and store the query results of the second page, the third page... the Nth page in the background cache until all result data that meet the sample query information are queried.

[0106] S34. If it receives that the user performs a paging operation in the data query interface and the page code associated with the paging operation is the second page, extract the query results of the second page from the background cache, display the pre-query results of the second page on the data query interface. At the same time, the relevant query software can also continue to perform data query on other pages, realizing multi-threaded work, thereby saving response time and realizing timely loading of the result data of the page. At the same time, the relevant query software can automatically clean the data in the background cache within a certain period of time after the query to ensure high utilization of the background cache.

[0107] It should be noted that the embodiments of the present invention include but are not limited to the above examples. It can be understood that under the guidance of the idea of the embodiments of the present invention, those skilled in the art can set according to the actual situation, and the present invention does not limit this.

[0108] In the embodiments provided above in this application, the current query results can be directly returned to the data query interface for display, ensuring that the current query results can be displayed in time. At this time, the query subtasks for the first page are completed, and the background can continue to execute the query subtasks for other pages, obtain the pre-query results of other pages, and store the pre-query results in the background cache to ensure that when the user clicks the previous page or the next page, the pre-query results corresponding to the previous page or the next page are directly extracted from the background cache to ensure timely loading of the pre-query results of the previous page or the next page.

[0109] Corresponding to the foregoing method embodiments for implementing application functions, this application also provides an embodiment of a sample analyzer.

[0110] Figure 4It is a schematic structural diagram of a sample analyzer shown in an embodiment of the present application. Refer to Figure 4 , the sample analyzer is equipped with a database and a cache space, and the device at least includes the following modules:

[0111] A query task generation module 401, configured to obtain sample query information input by a user on a data query interface, and generate a data query task by using the sample query information;

[0112] A query result matching module 402, configured to send the data query task to the database, screen query results matching the data query task from the database, and store them in the cache space;

[0113] A current query result display module 403, configured to receive a page refresh instruction for the data query interface, screen current query results matching the page refresh instruction from the query results in the cache space, and at the same time use the remaining query results as pre-query results;

[0114] A pre-query result display module 404, configured to display the pre-query results on the data query interface in response to a paging operation performed by the user on the data query interface.

[0115] In one embodiment, the query result matching module 402 includes:

[0116] A detected sample quantity acquisition sub-module, configured to obtain the detected sample quantity from the database;

[0117] A query sub-task splitting module, configured to split the data query task into several query sub-tasks by using the detected sample quantity and a preset data quantity;

[0118] A query sub-task execution module, configured to synchronously execute several query sub-tasks, screen query results matching the data query task from the database, and store the query results in the cache space;

[0119] Wherein, the data quantity of each query sub-task is equal to or less than the preset data quantity, and the sum of the data quantities of each query sub-task is equal to the total data quantity.

[0120] In one embodiment, the data query interface includes the number of pages displayed; the preset data quantity is greater than or equal to the number of pages displayed.

[0121] In one embodiment, the query sub-task execution module is used for:

[0122] Synchronously execute several query sub-tasks, screen query results matching the data query task from the database until several query sub-tasks are completed;

[0123] Sort the query results according to a preset sorting strategy to obtain the result numbers of each query result;

[0124] Store the sorted query results and the result sequence numbers in the cache space.

[0125] In one embodiment, the current query result display module 403 is configured to:

[0126] Receive a page refresh instruction for the data query interface, where the page refresh instruction includes the page display quantity of the data query interface;

[0127] Determine the current query range using the page display quantity and the result sequence numbers, and sequentially extract the query results within the current query range from the cache space;

[0128] Use the query results within the current query range as the current query results, and display them on the data query interface. At the same time, use the remaining query results as the pre-query results.

[0129] In one embodiment, the pre-query result display module 404 is configured to:

[0130] Respond to the paging operation performed by the user on the data query interface, and calculate the pre-query quantity corresponding to the paging operation;

[0131] Determine the pre-query range using the pre-query quantity and the result sequence numbers of the remaining query results, and sequentially extract the query results within the pre-query range from the cache space;

[0132] Use the query results within the pre-query range as the pre-query results, and display them on the data query interface.

[0133] In one embodiment, the data query task includes a single query task, and also includes:

[0134] The first data cleaning module is used to mark the current query results and the pre-query results as historical query data after the execution of the single query task;

[0135] Periodically clean the historical query data in the cache space.

[0136] In one embodiment, the data query task includes multiple query tasks. The multiple query tasks include the current query task and the previous query task of the current query task, and also include:

[0137] The second data cleaning module is used to mark the current query results and the pre-query results of the previous query task as historical query data after the execution of the current query task;

[0138] Real-time clean the historical query data in the cache space.

[0139] Regarding the sample analyzer in the above embodiments, the specific manners in which each module performs operations have been described in detail in the embodiments related to the method, and will not be elaborated herein.

[0140] Figure 5 It is another structural schematic diagram of a sample analyzer shown in the embodiments of the present application.

[0141] Refer to Figure 5 , the sample analyzer 500 includes a memory 510 and a processor 520.

[0142] The processor 520 may be a central processing unit (CPU), or may also be other general-purpose processors, digital signal processors (DSPs), application specific integrated circuits (ASICs), field-programmable gate arrays (FPGAs), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The general-purpose processor may be a microprocessor or the processor may also be any conventional processor, etc.

[0143] The memory 510 may include various types of storage units, such as system memory, read-only memory (ROM), and permanent storage devices. Among them, the ROM can store static data or instructions required by the processor 520 or other modules of the computer. The permanent storage device can be a readable and writable storage device. The permanent storage device can be a non-volatile storage device that does not lose the stored instructions and data even when the computer is powered off. In some embodiments, the permanent storage device employs a mass storage device (such as a magnetic or optical disk, flash memory) as the permanent storage device. In some other embodiments, the permanent storage device can be a removable storage device (such as a floppy disk, optical drive). The system memory can be a readable and writable storage device or a volatile readable and writable storage device, such as dynamic random access memory. The system memory can store some or all of the instructions and data required by the processor during operation. In addition, the memory 510 can include any combination of computer-readable storage media, including various types of semiconductor storage chips (such as DRAM, SRAM, SDRAM, flash memory, programmable read-only memory), and magnetic disks and / or optical disks can also be used. In some embodiments, the memory 510 can include removable storage devices that are readable and / or writable, such as compact discs (CDs), read-only digital versatile discs (such as DVD-ROM, dual-layer DVD-ROM), read-only Blu-ray discs, high-density discs, flash memory cards (such as SD cards, mini SD cards, Micro-SD cards, etc.), magnetic floppy disks, etc. Computer-readable storage media do not include carrier waves and instantaneous electronic signals transmitted wirelessly or wired.

[0144] Executable code is stored on the memory 510, and when the executable code is processed by the processor 520, it can cause the processor 520 to execute some or all of the methods described above.

[0145] In addition, the method according to the present application can also be implemented as a computer program or a computer program product, which includes computer program code instructions for executing some or all of the steps in the above method of the present application.

[0146] Alternatively, the present application can also be implemented as a computer-readable storage medium (or a non-transitory machine-readable storage medium or a machine-readable storage medium), on which executable code (or a computer program or computer instruction code) is stored. When the executable code (or the computer program or computer instruction code) is executed by a processor of an electronic device (or a server, etc.), it causes the processor to execute some or all of the steps of the above method according to the present application.

[0147] The embodiments of the present application have been described above. The above description is exemplary and not exhaustive, and is also not limited to the disclosed embodiments. Many modifications and variations are obvious to those of ordinary skill in the art without departing from the scope and spirit of the described embodiments. The choice of terms used herein is intended to best explain the principles of the embodiments, practical applications, or improvements to the technology in the market, or to enable other ordinary skill in the art to understand the embodiments disclosed herein.

Claims

1. A method for querying the result of a sample, characterized in that, Applied to a sample analyzer, the sample analyzer is equipped with a database and a cache space, and the method includes: Obtain the sample query information input by the user on the data query interface, and generate a data query task using the sample query information; Send the data query task to the database, screen the query results matching the data query task from the database, and store them in the cache space; Receive a page refresh instruction for the data query interface, screen the current query results matching the page refresh instruction from the query results in the cache space, and at the same time use the remaining query results as pre-query results; In response to the paging operation performed by the user on the data query interface, display the pre-query results on the data query interface.

2. The method according to claim 1, wherein The sending the data query task to the database, screening the query results matching the data query task from the database, and storing them in the cache space includes: Obtain the detected sample volume from the database; Split the data query task into several query subtasks using the detected sample volume and a preset data volume; Synchronously execute the several query subtasks, screen the query results matching the data query task from the database, and store the query results in the cache space; Wherein, the data volume of each query subtask is equal to or less than the preset data volume, and the sum of the data volumes of each query subtask is equal to the total data volume.

3. The method according to claim 2, characterized in that, The data query interface includes the number of pages displayed; the preset data volume is greater than or equal to the number of pages displayed.

4. The method according to claim 2, characterized in that, The synchronously executing the several query subtasks, screening the query results matching the data query task from the database, and storing the query results in the cache space includes: Synchronously execute the several query subtasks, screen the query results matching the data query task from the database until the several query subtasks are completed; Sort the query results according to a preset sorting strategy to obtain the result numbers of each query result; Store the sorted query results and the result numbers in the cache space.

5. The method according to claim 4, wherein The receiving the page refresh instruction for the data query interface, screening the current query results matching the page refresh instruction from the query results in the cache space, and at the same time using the remaining query results as pre-query results includes: Receive a page refresh instruction for the data query interface, and the page refresh instruction includes the number of pages displayed on the data query interface; Determine the current query range using the number of pages displayed and the result number, and sequentially extract the query results within the current query range from the cache space; Use the query results within the current query range as the current query results, display them on the data query interface, and at the same time use the remaining query results as the pre-query results.

6. The method according to claim 5, wherein The responding to the paging operation performed by the user on the data query interface and displaying the pre-query results on the data query interface includes: In response to the paging operation performed by the user on the data query interface, calculate the pre-query quantity corresponding to the paging operation; Determine the pre-query range using the pre-query quantity and the result serial numbers of the remaining query results, and sequentially extract the query results within the pre-query range from the cache space; Use the query results within the pre-query range as the pre-query results and display them on the data query interface.

7. The method according to claim 1, characterized in that The data query task includes a single query task, and the method further includes: After the single query task is executed, mark the current query results and the pre-query results as historical query data; Periodically clean up the historical query data in the cache space.

8. The method according to claim 1, characterized in that, The data query task includes multiple query tasks, and the multiple query tasks include the current query task and the previous query task of the current query task. The method further includes: After the current query task is executed, mark the current query results and the pre-query results of the previous query task as historical query data; Real-time clean up the historical query data in the cache space.

9. A sample analyzer, characterized in that, The sample analyzer is equipped with a database and a cache space, including: A query task generation module, configured to obtain sample query information input by the user on the data query interface, and generate a data query task using the sample query information; A query result matching module, configured to send the data query task to the database, screen the query results matching the data query task from the database, and store them in the cache space; A current query result display module, configured to receive a page refresh instruction for the data query interface, screen the current query results matching the page refresh instruction from the query results in the cache space, and at the same time use the remaining query results as pre-query results; A pre-query result display module, configured to, in response to the paging operation performed by the user on the data query interface, display the pre-query results on the data query interface.

10. A computer-readable storage medium, on which executable code is stored. When the executable code is executed by a processor of an electronic device, the processor is caused to execute the method according to any one of claims 1-8.

Citation Information

Patent Citations

  • Task splitting method and device of data exchange system

    CN110597618A

  • Database query method, device and equipment and readable storage medium

    CN115114332A

  • Database query method and device

    CN115757504A

Cited By

  • Freight rate search data analysis method, system and equipment and storage medium

    CN121542300A