CN114490719A - Data query method and device, electronic equipment and storage medium - Google Patents

Abstract

The embodiments of the present application disclose a data query method, device, electronic device, and storage medium, which are applied in the field of computer technology. The method may include: receiving a first query request sent by a first client, where the first query request carries query scope information of the requested query; if the query scope information satisfies a target condition, determining a first query logic, where the first query logic is used to indicate Information about the interception conditions of K dimensions, K is a positive integer; obtain the first data queried by the first query request that satisfies the interception conditions of K dimensions at the same time; if the data volume of the first data is greater than or equal to the target data volume, The first target data of the target data amount is selected from the first data, and the first target data is returned to the first client. The method embodiment can help reduce the response time of data query. The embodiments of the present application can also be applied in the field of blockchain technology, such as obtaining data from the blockchain according to query logic.

Description

A data query method, device, electronic device and storage medium

technical field

The present application relates to the field of computer technology, and in particular, to a data query method, apparatus, electronic device, and storage medium.

Background technique

With the rapid development of computer technology, in some application scenarios, users usually need to query a large amount of data, such as managers querying the information of subordinate employees and so on. At present, when processing a data query request, the entire data volume corresponding to the query request is usually queried at one time according to the query request, and returned to the corresponding client for display. If the data volume to be queried is large, the Data requires more time, and may even cause server blockage or memory overflow, which in turn leads to longer data query response time and lower query performance.

SUMMARY OF THE INVENTION

The embodiments of the present application provide a data query method, apparatus, electronic device, and storage medium, which help to reduce the response time of data query.

On the one hand, the embodiment of the present application discloses a data query method, the method includes:

receiving a first query request sent by a first client, where the first query request carries the query scope information of the requested query;

If the query range information satisfies the target condition, determine the first query logic, where the first query logic is used to indicate the information of the interception conditions of K dimensions, where K is a positive integer;

obtaining the first data queried by the first query request that simultaneously satisfies the interception conditions of the K dimensions;

If the data volume of the first data is greater than or equal to the target data volume, select the first target data of the target data volume from the first data, and return the first target data to the first client end.

On the other hand, an embodiment of the present application discloses a data query device, and the device includes:

a receiving unit, configured to receive a first query request sent by a first client, where the first query request carries query range information of the requested query;

a processing unit, configured to determine a first query logic if the query range information satisfies the target condition, where the first query logic is used to indicate the information of the interception conditions of K dimensions, where K is a positive integer;

an obtaining unit, configured to obtain the first data queried by the first query request that simultaneously satisfies the interception conditions of the K dimensions;

The processing unit is further configured to select the first target data of the target data volume from the first data if the data volume of the first data is greater than or equal to the target data volume, and convert the first target data to the target data volume. Data is returned to the first client.

In another aspect, an embodiment of the present application provides an electronic device, the electronic device includes a processor and a memory, wherein the memory is used to store a computer program, the computer program includes program instructions, and the processor is configured to Perform the following steps:

receiving a first query request sent by a first client, where the first query request carries the query scope information of the requested query;

If the query range information satisfies the target condition, determine the first query logic, where the first query logic is used to indicate the information of the interception conditions of K dimensions, where K is a positive integer;

obtaining the first data queried by the first query request that simultaneously satisfies the interception conditions of the K dimensions;

If the data volume of the first data is greater than or equal to the target data volume, select the first target data of the target data volume from the first data, and return the first target data to the first client end.

In another aspect, an embodiment of the present application provides a computer-readable storage medium, where computer program instructions are stored in the computer-readable storage medium, and when the computer program instructions are executed by a processor, are used to perform the following steps:

receiving a first query request sent by a first client, where the first query request carries the query scope information of the requested query;

If the query range information satisfies the target condition, determine the first query logic, where the first query logic is used to indicate the information of the interception conditions of K dimensions, where K is a positive integer;

obtaining the first data queried by the first query request that simultaneously satisfies the interception conditions of the K dimensions;

If the data volume of the first data is greater than or equal to the target data volume, select the first target data of the target data volume from the first data, and return the first target data to the first client end.

In another aspect, the embodiments of the present application disclose a computer program product or computer program, where the computer program product or computer program includes computer instructions, and the computer instructions are stored in a computer-readable storage medium. The processor of the computer device reads the computer instructions from the computer-readable storage medium, and the processor executes the computer instructions, so that the computer device executes the above data query method.

In the embodiment of the present application, when it is detected that the query range information in the query request satisfies the target condition, the corresponding query logic is determined to intercept the first data that simultaneously satisfies the interception conditions of the K dimensions, so that only the information in the query request can be obtained. Indicate part of the data in the queried data, and then return the data of the target data amount from the first data to the corresponding client. Since the time required to acquire part of the data is less than the time required to acquire all the data queried indicated by the query request, the response time of the data query can be reduced.

Description of drawings

In order to explain the technical solutions of the embodiments of the present application more clearly, the following briefly introduces the accompanying drawings used in the description of the embodiments. For those of ordinary skill, other drawings can also be obtained from these drawings without any creative effort.

1 is a schematic structural diagram of a data query system provided by an embodiment of the present application;

2 is a schematic flowchart of a data query method provided by an embodiment of the present application;

3 is a schematic flowchart of a data query method provided by an embodiment of the present application;

4 is a schematic flowchart of a data query method provided by an embodiment of the present application;

5 is a schematic structural diagram of a data query apparatus provided by an embodiment of the present application;

FIG. 6 is a schematic structural diagram of an electronic device provided by an embodiment of the present application.

Detailed ways

The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present application. Obviously, the described embodiments are part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of the present application.

The present application provides a data query solution, which can determine the corresponding query logic to intercept the first data that simultaneously satisfies the interception conditions of the K dimensions when it is detected that the query range information in the query request satisfies the target condition. Only a part of the data in the data queried indicated by the query request is acquired, and then the data of the target data amount determined from the first data is returned to the corresponding client. Since the time required to acquire part of the data is less than the time required to acquire all the data queried indicated by the query request, the response time of the data query can be reduced.

In a possible implementation, the embodiments of the present application may be applied to a data query system. Please refer to FIG. 1. FIG. 1 is a schematic structural diagram of a data query system provided by an embodiment of the present application. The data query system may include a client and a data query server. The data query server may be configured with the above data query scheme. The data query server may receive at least one query request from each client. The query request is a request for querying data. For query requests with the same query purpose, the data processing server can determine the query logic used in processing the next query request according to the query response time corresponding to each query request. If the query response time is greater than the response time threshold, it can Adjust the query logic corresponding to the query logic used in processing the next query request; if the query response time is less than or equal to the response time threshold, the query logic corresponding to the query logic used in processing the next query request may not be processed make adjustments. The above query purpose is used to indicate what kind of data the query request is used to query. For example, the query purpose may be querying personnel information, querying transaction records, querying file directories, querying documents containing target keywords, etc. limit. The query response time is used to indicate the time difference between the time when the query request is received and the time when the data is returned to the client. In this way, the query logic of the next query request can be adjusted according to the query logic of each query request to find the query logic that can make the query response time less than the response time threshold, which is equivalent to determining a better query logic, and then follow-up The query request can be processed according to this excellent query logic, so as to ensure the query performance of the query request, so that the data query server can return the queried data to the client in less query response time.

The client can be used to send a query request to the above-mentioned data query server, and the client can obtain the corresponding query result through the query request. In a possible scenario, when a user needs to query data, they can click a control on the client to instruct to query certain data, for example, an enterprise manager clicks on a control for querying subordinate employee information; or, on the client After entering the range of data to be queried, click the control used to indicate the start of the query. For example, when the user is querying the transaction records of the personnel, he enters the personnel to be queried (such as all personnel in a group) and the time range (such as the past 3 months). ), then the user clicks the Query control. Further, the client sends a query request to the above-mentioned data query server to obtain the corresponding query result when detecting that the control for instructing to query certain data or the control for instructing to start the query is clicked.

When the client displays the query result corresponding to the query request, it can be displayed in pages, and each page displays the data of the target data volume. The target data amount is used to indicate the amount of data that can be displayed on a page in the client. The amount of data is used to indicate the amount of data, that is, the number of pieces of data. For example, if the query purpose of the query request is to query transaction records, the data volume indicates how many transaction records there are; for another example, if the query purpose of the query request is to query personnel information, the data volume indicates how many pieces of personnel information there are, that is, how many personnel there are. Information. Therefore, after the data query server of this solution obtains data once according to the query logic, if the obtained data is larger than the target data volume, it needs to select the target data volume from the queried data and return it to the client, so that the client can just Display a page of data. For example, each page in the client can display 20 pieces of data, and the data query server obtains 25 pieces of data according to the query logic corresponding to the query request, then 20 pieces of data can be selected from the 25 pieces of data and returned to the client, so as to facilitate the client Displays the first page of data.

It should be noted that, unless otherwise specified, in the specific implementation of this application, data related to personnel information, user information, etc. are involved. When the embodiments of this application are applied to specific products or technologies, it is necessary to obtain User permission or consent, and the collection, use and processing of relevant data need to comply with relevant laws, regulations and standards of relevant countries and regions.

The technical solution of the present application can be applied to an electronic device, and the electronic device can be a terminal, a server, or other devices used for data query, which is not limited in this application. optional. The server can be an independent physical server, or a server cluster or distributed system composed of multiple physical servers, or it can provide cloud services, cloud databases, cloud computing, cloud storage, network services, middleware services, and big data. Cloud servers for basic cloud computing services such as artificial intelligence platforms. The terminal may be a smart phone, a tablet computer, a notebook computer, a desktop computer, etc., but is not limited thereto.

Based on the above description, an embodiment of the present application proposes a data query method. Please refer to FIG. 2, which is a schematic flowchart of a data query method provided by an embodiment of the present application. The method may be performed by the electronic device mentioned above. The data query method may include the following steps.

S201. Receive a first query request sent by a first client.

Wherein, the first query request is any request for querying data, and the first query request carries query scope information of the requested query. The query scope information may be the scope of the data to be queried indicated by the query request. For example, when querying the transaction details data of a person, the query scope information may indicate the scope of the personnel to be queried (such as all personnel of a certain group, a certain person), and the time range to be queried (such as the last 3 months, the last month, etc. etc.), or other information that limits the scope of the query, which is not limited here. In a possible implementation manner, the query range information may be determined according to the range of data to be queried input by the user at the client, or may be determined according to the control clicked by the user for instructing to query certain data, the control It is determined by the default query scope, which is not limited here.

S202. If the query scope information satisfies the target condition, determine the first query logic.

Wherein, the target condition may be a condition for triggering the determination of the first query logic. The target condition may be the condition of the query range for various dimensions. For example, the target condition may include that the number of personnel indicated by the personnel scope is greater than the preset value of personnel, may also include that the time scope is greater than the preset time value, and may also include other conditions for limiting the query scope, and so on. For example, when querying the transaction detail data of a person, the target condition may be that the number of people indicated by the personnel range is greater than or equal to 20, and the time range is greater than or equal to 3 months.

If the query range information does not meet the target condition, the first query logic may not be determined, but all the data queried by the first query request may be directly obtained. It can be understood that if the query scope information does not meet the target condition, it means that the data amount of the data queried indicated by the first query request is small, and the data may not be obtained according to the first query logic, that is, it is not necessary to pass the first query. Logic to reduce the query response time, and it will not take too much time to directly obtain all the data queried by the query request. Therefore, it can be determined whether to determine the first query logic in a targeted manner, avoiding the need for a small amount of data to be queried. The query request also intercepts the data, which causes the query response time to increase.

The first query logic is used to indicate the information of the interception conditions of K dimensions, where K is a positive integer. The interception conditions of the K dimensions are used to indicate which data the data query server needs to intercept when acquiring data. The K dimensions are used to indicate the dimensions for which the truncation condition is directed. For example, if the first query request is used to indicate the transaction details of the query personnel, the K dimensions may include the dimension of the number of personnel indicated for the scope of personnel, and the corresponding interception condition may be the number of personnel = 3, then the query is limited The transaction details data of 3 people can be intercepted in the range; the K dimensions can also include the dimension of time range. If the corresponding interception condition can be time range=3 days, the transaction details of 3 days can be intercepted in the limited query range. data; or, the K dimensions may also include other dimensions, which are not limited here.

S203: Obtain the first data queried by the first query request that simultaneously satisfies the interception conditions of K dimensions.

The first data may be data that satisfies the interception conditions of K dimensions while being queried as indicated by the first query request. For example, when querying the transaction details data of a person, the first query request indicates that the query range is 20 people and the time range is 3 months. The interception conditions of the K dimensions include: the number of people=3 and the time range= 3 days, you can first obtain the transaction details data of 3 personnel within 3 days as the above-mentioned first data. In a possible implementation manner, when acquiring data satisfying the interception conditions of K dimensions, the data satisfying the interception conditions may be determined according to a certain order of corresponding dimensions or randomly. For example, when obtaining the detailed transaction data of 3 personnel within 3 days above, the transaction detailed data of any 3 personnel within any 3 days can be obtained randomly as the first data; or, it can also be sorted according to the personnel code and time of the personnel. The distance from the current time is used to determine the transaction record data of the three days with the closest (or farthest) distance between the time and the current time for the three personnel in the top ranking of the personnel code as the first data.

S204. If the data volume of the first data is greater than or equal to the target data volume, select first target data of the target data volume from the first data, and return the first target data to the first client.

Wherein, as described above, the target data amount is used to indicate the amount of data that can be displayed on one page of the first client, and details are not described here. The first target data is the data corresponding to the first query request that needs to be returned to the first client and displayed in the same page of data. For example, when the data volume of the first data is 25 and the target data volume is 20, then 20 pieces of data can be selected from the first data as the first target data to return the first target data to the first client. In a possible implementation manner, when the first target data of the target data volume is selected from the first data, it may be randomly selected from the first data, or may be selected from the first data in a certain order. For example, if the first data is the transaction record data of 3 people within 3 days, the data of the target data volume can be selected according to the personnel code sorting of the personnel and the time corresponding to the data and the current time. For the transaction details data of the same person, the transaction details data with the transaction occurrence time closest to the current time are preferentially selected, thereby obtaining the first target transaction data.

In the embodiment of the present application, when it is detected that the query range information in the query request satisfies the target condition, the corresponding query logic is determined to intercept the first data that simultaneously satisfies the interception conditions of the K dimensions, so that only the information in the query request can be obtained. Indicate part of the data in the queried data, and then return the data of the target data amount from the first data to the corresponding client. Since the time required to acquire part of the data is less than the time required to acquire all the data queried indicated by the query request, the response time of the data query can be reduced.

Please refer to FIG. 3. FIG. 3 is a schematic flowchart of a data query method provided by an embodiment of the present application, and the method may be executed by the aforementioned electronic device. The data query method may include the following steps.

S301. Receive a first query request sent by a first client.

S302. If the query range information satisfies the target condition, determine the first query logic.

In a possible implementation manner, as described above, the data processing server may determine the query logic used in processing the next query request according to the query response time corresponding to processing each query request, and then determine the query logic of the first query logic. The method may be the determination according to the query request that completed the query last time before the first query request and satisfies the target condition. The query completion is used to indicate that the data query server is returning data to the corresponding client.

In a possible implementation manner, before determining the first query logic, the following steps may be included: ① Receive a second query request sent by the second client, and determine the second query logic. Wherein, the second query request is a query request that has completed the last query before the first query request and satisfies the target condition, and the second query logic is used to indicate the information of the interception conditions of N dimensions, where N is a positive integer. It can be understood that, if N is less than or equal to K, the second query request has the same query purpose as the first query request, but the amount of data queried can be different. For example, the first query request is used to query 20 people within 3 months. The transaction details data within the second query request can be used to query the transaction details data of 25 individuals within one month. ② Determine the corresponding second target data according to the second query logic, and return the second target data to the second client. Wherein, step ② here can refer to the relevant descriptions of steps S203-S204, that is, obtain the fourth data queried by the second query request that satisfies the interception conditions of the N dimensions at the same time; if the data of the fourth data If the amount is greater than or equal to the target data amount, second target data of the target data amount is selected from the fourth data, and the second target data is returned to the first client. Wherein, the fourth data is the data that meets the interception conditions of N dimensions while being queried by the second query request, and the second target data is the data corresponding to the second query request that needs to be returned to the first client. Data displayed on the same page of data. ③ Record the query response time corresponding to the second query request. The query response time is used to indicate the time difference between the time when the second query request is received and the time when the second target data is returned to the second client. For example, if the time when the data query server receives the second query request is t1, and the time when it returns the second target data to the second client is t2, the query response time of the second query request may be t2-t1. Therefore, the query response time can be used as the judgment criterion for the query performance of the query request. If the query response time is shorter, the query performance is better. If the query response time is longer, the query performance is worse. The response time can be used to determine whether the query performance meets the preset conditions.

Furthermore, the manner of determining the first query logic may be: determining the first query logic according to the query response time corresponding to the second query request and the second query logic.

Specifically, if the query response time corresponding to the second query request is greater than the response time threshold, the second query logic is determined as the first query logic. The response time threshold is used to indicate that the second query logic is determined as the maximum value of the first query logic. If the query response time of the second query request is greater than the response time threshold, it means that the next query request (that is, the first query The query logic of the request) is not adjusted, that is to say, the adjustment of the second query logic satisfies the required query performance, and the query request is subsequently processed according to the query logic.

If the query response time corresponding to the second query request is less than or equal to the response time threshold, the interception range corresponding to the interception conditions of N dimensions indicated by the second query logic is narrowed according to the narrowing rule; The query logic is determined as the first query logic. The interception range is used to indicate the range limited by the interception condition. It can be understood that the interception conditions of the above N dimensions may have corresponding interception ranges, and the interception conditions of each of the N dimensions also have corresponding interception conditions. The narrowing rule is used to indicate a rule for narrowing the clipping range corresponding to the clipping conditions of N dimensions. For example, if the interception condition A is the number of personnel = 4, the corresponding interception range A indicates the range limited by the number of personnel = 4; for another example, if the interception condition B is the number of personnel = 3, the corresponding interception range B indicates the number of personnel = 3 For another example, the interception condition C includes: the number of persons=3 and the time range=4 days, then the corresponding interception range C represents the range limited by the number of persons=3 and the time range=4 days; The range limited by number=4 is greater than the range limited by number of personnel=3, then the interception range A is greater than the interception range B, then when the query logic changes from A to B, the interception range becomes smaller, that is, the interception range is reduced; Since the interception range B only includes the interception range defined by the interception condition of the dimension of the number of persons, and the interception range C includes the interception conditions of the two dimensions of the number of persons and the time range, then the interception range B is greater than the interception range C, then in the query When the logic changes from B to C, the interception range becomes smaller, that is, the interception range is reduced. It can be understood that this step means that when the second query logic does not meet the required query performance, the interception scope of the query logic of the next query request (ie, the first query request) is narrowed, so that the data can be realized. In the process of continuously processing the query request, the processing server continuously optimizes the query logic for processing the query request, so that the query logic can meet the required query performance.

Specifically, narrowing down the interception range corresponding to the interception conditions of N dimensions indicated by the second query logic according to the narrowing rule may include the following methods: ① According to the narrowing interval corresponding to each dimension, reduce the N dimensions indicated by the second query logic The interception range corresponding to the interception conditions of one or more dimensions in the interception conditions of the dimension is reduced. Wherein, the reduction interval is used to indicate how much the range is reduced each time when reducing the interception range of the corresponding dimension, and each dimension is associated with a corresponding reduction interval. For example, the dimension corresponding to the reduction interval 1 may be the number of personnel, and the size of the reduction interval 1 is 2. If the interception condition of the dimension of the number of personnel indicated by the second query logic is the number of personnel = 5, the reduction interval 1 will be reduced After the interception range corresponding to the interception condition, the interception condition of this dimension becomes the number of persons=3. ②Or, the interception conditions of N dimensions indicated by the second query logic are added to the interception conditions of N+M dimensions, where M is a positive integer. Among them, the interception conditions of N dimensions are increased to the interception conditions of N+M dimensions, that is, the restriction of more dimensions is added to the second query logic to narrow the interception range corresponding to the N interception conditions of the second query logic. For example, the interception condition of N dimensions indicated by the second query logic is: number of persons = 3. When narrowing the interception range, the interception condition of the time range dimension can be increased (for example, time range=3 days), thus The interception conditions of two dimensions (namely, the number of personnel and the time range) can be obtained, which is equivalent to increasing the limitation on the dimension of time range and narrowing the interception range.

In a possible implementation manner, when determining the first query logic to narrow the interception range, it may be determined according to the time difference between the query response time of the second query request and the response time threshold. Specifically, the following steps may be included: determining the response time difference between the query response time of the second query request and the query response time threshold, and if the response time difference is less than or equal to the preset time difference value, the second The interception range corresponding to the interception conditions of one or more dimensions among the interception conditions of the N dimensions indicated by the query logic is reduced; if the response time difference is greater than the preset time difference value, the N dimensions indicated by the second query logic may be used. The interception condition is increased to an interception condition of N+M dimensions, where M is a positive integer. The response time difference may be the time difference between the query response time of the second query request and the response time threshold. For example, if the query response time of the second query request is 10s and the time threshold is 6s, the response time difference is 10-6= 4s. Wherein, the preset time difference value may be a preset boundary value used for determining how to narrow the interception range. It can be understood that when the response time difference is less than or equal to the preset time difference value, it means that the second query logic can basically meet the query performance, and it is only necessary to slightly adjust the interception range according to the reduction interval to avoid excessive reduction. The interception range needs to spend extra time to expand the interception range in the subsequent process of querying data according to the query logic. Conversely, when the response time difference is greater than the preset time difference value, it means that the second query logic is still far from satisfying the query performance, and it is only necessary to adjust the interception range by increasing the dimension to quickly make the query The logic can satisfy the query performance.

It can be understood that in the actual application scenario, when determining the query logic corresponding to each request, it can be determined according to the query logic corresponding to the query request that completed the query last time before the query request and satisfies the target condition, thus This enables the data query server to continuously optimize the query logic in the process of processing each query request, so as to find the query logic that satisfies the response time threshold for subsequent use. In a possible implementation, from the perspective of the continuous processing process of each query request by the data query server, each time the interception range is narrowed by adding dimensions, the added M dimensions may be determined in a certain order of dimensions. For example, the order of dimensions is dimension 1, dimension 2, dimension 3, etc., and each time M=1 dimension is added, when the interception range is narrowed by increasing the dimension for the first time, the interception condition corresponding to dimension 1 is added, and the second time When reducing the interception range by increasing the dimension, add the interception condition corresponding to dimension 2, and so on.

S303: Acquire the first data queried by the first query request that simultaneously satisfies the interception conditions of K dimensions.

For the related description of step S303, reference may be made to step S203, which will not be repeated here.

S304. If the data amount of the first data is less than the target data amount, expand the interception range of the interception conditions of K dimensions according to the expansion rule.

Wherein, the expansion rule is used to indicate a rule for expanding the interception range corresponding to the interception conditions of K dimensions. It can be understood that, if the data volume of the first data is less than the target data volume, it means that the obtained data is not enough for the first client to display one page of data, and it is necessary to obtain more data by expanding the interception range, so as to obtain more data. The data can be more than the amount of data displayed on one page by the first client, so that the data of the target data amount is selected from the acquired data and returned to the first client for display.

In a possible implementation manner, the method of expanding the interception range of the interception conditions of K dimensions according to the expansion rule may include: (1) intercepting the K dimensions indicated by the first query logic according to the expansion interval corresponding to each dimension The interception range corresponding to the interception condition of one or more dimensions in the condition is expanded. Wherein, the expansion interval is used to indicate how much the range is expanded each time when expanding the intercepted range of the corresponding dimension, and each dimension is associated with a corresponding expansion interval. For example, the dimension corresponding to the expansion interval 1 can be the number of personnel, and the size of the expansion interval 1 is 2. If the interception condition of the dimension of the number of personnel indicated by the first query logic is the number of personnel = 5, the expansion interval 1 is expanded After the interception range corresponding to the interception condition, the interception condition of this dimension becomes the number of persons=7. ②Or, the interception conditions of K dimensions indicated by the first query logic are reduced to interception conditions of K-L dimensions, where L is a positive integer. Among them, the interception conditions of K dimensions are reduced to the interception conditions of K-L dimensions, that is, the restriction of more dimensions is reduced for the first query logic, so as to expand the interception range corresponding to the N interception conditions of the first query logic. For example, the interception conditions of the K dimensions indicated by the first query logic are: number of persons = 3 and time range = 3 days. When the interception range is expanded, the interception condition of the time range dimension can be reduced, thereby obtaining The interception condition of one dimension (that is, the number of personnel = 3) is equivalent to reducing the limitation on the dimension of time range and expanding the interception range.

S305: Acquire the second data queried by the first query request that simultaneously satisfies the interception conditions of the K dimensions after the expanded interception range.

Wherein, the second data may be data that satisfies the interception conditions of K dimensions after the expanded interception range while being queried by the first query request. It can be understood that, the interception conditions of K dimensions after expanding the interception range here may be the interception conditions of K or K-L dimensions.

For the relevant description of step S305, reference may be made to the relevant description of step S203, except that the corresponding interception conditions are different when acquiring data.

S306. If the data volume of the second data is greater than or equal to the target data volume, select third target data of the target data volume from the second data, and return the third target data to the first client.

The third target data may be data corresponding to the first query request that needs to be returned to the first client and displayed on the same page of data. The related description of step S306 may refer to the related description of step S204, except that the first target data obtained from the first data is converted into the third target data of which the target data amount is selected from the second data.

For example, for example, the first query request is used to query transaction detail data, and the interception conditions of the K dimensions are: number of persons = 2 and time range = 3 days, then it is possible to obtain the number of persons 1 and 2 that is the closest to the current time. The data of day 1, day 2, and day 3 are used as the first data. When it is detected that the data volume of the first data is less than the target data volume, the interception range can be expanded. For example, the interception condition can be changed to: number of personnel = 2 , the data of Person 1 and Person 2 within the query time range indicated by the first query request can be obtained as the second data, and then the third target data of the target data volume is selected from the second data and returned to the first client .

In a possible implementation manner, if the data volume of the second data is less than the target data volume, step S304 may be performed again, that is, the interception range of the interception conditions of K dimensions may be expanded according to the expansion rule, so that more data can be obtained , until the data volume of the obtained data is greater than or equal to the target data volume, or until all the data queried indicated by the first query request is obtained, the data of the target data volume can be selected from the obtained data and returned to the first client ; Or, if the data volume of the obtained data indicated by the first query request is still smaller than the target data volume, the data is directly returned to the first client. Generally speaking, it takes some time to continuously expand the interception range to obtain the corresponding data, which may lead to less improvement in query performance, and in some extreme cases, it may even exceed the time it takes to directly obtain all the data. However, in terms of the processing of each query request by the data processing server, the above-mentioned increase in query response time is rare, and if the expansion interval is set reasonably, this situation can be alleviated. Query logic reduces query response time and improves query performance.

In a possible implementation manner, if the data volume of the first data is less than the target data volume, the following step may be further included: acquiring the fifth data queried by the second query request that satisfies the interception conditions of K dimensions at the same time, the The fifth data is the data other than the first data queried by the second query request; if the sum of the data volume of the first data and the fifth data is greater than or equal to the target data volume, from the first data and the fifth data The fifth target data of the target data volume is selected, and the fifth target data is returned to the first client. That is to say, when the data amount of the first data does not satisfy the data displayed on one page of the first client, one round of data (ie, fifth data) can be obtained again to satisfy the data displayed on one page of the first client, and then the From the first data and the fifth data, the data of the data amount of one page is returned to the first client for display. For example, the first query data is used to query transaction detail data, and the interception conditions of K dimensions are: number of persons = 2 and time range = 3 days, then the first day closest to the current time for Person 1 and Person 2 can be obtained , The data of the 2nd and 3rd days are used as the first data. If the data volume of the first data is less than the target data volume, the data can be obtained again according to the interception conditions of K dimensions, such as obtaining personnel 3 and personnel 4. The data of the 1st, 2nd, and 3rd days closest to the time is used as the fifth data, or, the data of the 4th, 5th, and 6th days closest to the current time of Person 1 and Person 2 are obtained as the 5th data. Five data, so that when it is detected that the data volume of the first data and the fifth data is greater than or equal to the target data volume, the data of the selected target data volume of the first data and the fifth data is returned to the first client.

In the embodiment of the present application, when it is detected that the query range information in the query request satisfies the target condition, the corresponding query logic is determined to intercept the first data that simultaneously satisfies the interception conditions of the K dimensions, so that only the information in the query request can be obtained. Indicate part of the data in the queried data, and then return the data of the target data amount from the first data to the corresponding client. Since the time required to acquire part of the data is less than the time required to acquire all the data queried indicated by the query request, the response time of the data query can be reduced.

Referring to FIG. 4 , FIG. 4 is a schematic flowchart of a data query method provided by an embodiment of the present application, and the method may be executed by the above-mentioned electronic device. The data query method may include the following steps.

S401. Receive a first query request sent by a first client.

S402. If the query range information satisfies the target condition, determine the first query logic.

S403: Obtain the first data queried by the first query request that simultaneously satisfies the interception conditions of K dimensions.

S404. If the data volume of the first data is greater than or equal to the target data volume, select first target data of the target data volume from the first data, and return the first target data to the first client.

Wherein, for steps S401-S404, reference may be made to the relevant descriptions of steps S201-S204, which will not be repeated here.

S405. When receiving the remaining data query instruction for the first query request, determine the data volume of the remaining data after removing the target data volume from the first data.

The remaining data query instruction is used to instruct to query the remaining data in the data queried by the first query request, and the remaining data is the data excluding the first target data returned to the first client. In a possible implementation manner, when the first client detects that the user clicks on the control for instructing to query the remaining data, the first client may send a remaining data query instruction for the first query request to the data query server. For example, when the user clicks on the "next page" control in the first client terminal, the first client terminal is triggered to send the remaining data query instruction to the data query server.

For example, the first data is the data of Person 1 and Person 2 on the 1st, 2nd, and 3rd days closest to the current time, the data volume of the first data is 25, and the target data volume is 20, then The data volume of the remaining data after excluding the data of the target data volume in one piece of data is 25-20=5 pieces.

It can be understood that S406 and S407 do not have a sequence of steps, and S406 or S407 can be selected to be executed according to the data amount of the remaining data.

S406. If the data volume of the remaining data is greater than or equal to the target data volume, determine the target data volume from the remaining data and send the data to the first client.

Wherein, the method of determining the data of the target data volume from the remaining data can refer to the method of selecting the first target data of the target data volume from the first data in step S204, that is, it can be randomly selected from the remaining data, or can be selected according to Select from the remaining data in a certain order, which will not be repeated here. In this way, the data of the target data volume can be quickly determined from the remaining data, and there is no need to obtain the data again, which improves the efficiency of data query.

S407. If the data volume of the remaining data is less than the target data volume, obtain third data other than the first data and satisfy the interception conditions of K dimensions according to the first query logic, and determine the target according to the remaining data and the third data The amount of data is sent to the first client.

Wherein, for the method for obtaining third data other than the first data and satisfying the interception conditions of K dimensions according to the first query logic, reference may be made to the relevant description of step S203, which will not be repeated here. The data of the target data volume is determined according to the remaining data and the third data, and the method for selecting the first target data of the target data volume from the first data in step S204 can be referred to, that is, it can be randomly selected from the remaining data and the third data, It can also be selected from the remaining data and the third data in a certain order, which will not be repeated here. In a possible implementation manner, the data of the data amount of the difference between the target data amount and the data amount of the remaining data can also be selected from the third data, and the data selected from the third data can be compared with the remaining data By returning to the first client, the remaining data can be returned to the client first, so as to avoid that the remaining data with stronger correlation with the first data cannot be returned to the first client in time.

In the embodiment of the present application, when it is detected that the query range information in the query request satisfies the target condition, the corresponding query logic is determined to intercept the first data that simultaneously satisfies the interception conditions of the K dimensions, so that only the information in the query request can be obtained. Indicate part of the data in the queried data, and then return the data of the target data amount from the first data to the corresponding client. Since the time required to acquire part of the data is less than the time required to acquire all the data queried indicated by the query request, the response time of the data query can be reduced.

Please refer to FIG. 5 , which is a schematic structural diagram of a data query apparatus provided by an embodiment of the present application. Optionally, the data query device may be set in the above electronic device. As shown in FIG. 5 , the data query apparatus described in this embodiment may include:

A receiving unit 501, configured to receive a first query request sent by a first client, where the first query request carries query range information requested to be queried;

A processing unit 502, configured to determine a first query logic if the query range information satisfies the target condition, where the first query logic is used to indicate the information of the interception conditions of K dimensions, where K is a positive integer;

an obtaining unit 503, configured to obtain the first data queried by the first query request that simultaneously satisfies the interception conditions of the K dimensions;

The processing unit 502 is further configured to select the first target data of the target data volume from the first data if the data volume of the first data is greater than or equal to the target data volume, and convert the first data volume to the target data volume. Target data is returned to the first client.

In an implementation manner, the processing unit 502 is further configured to:

Receive the second query request sent by the second client, and determine the second query logic; the second query request is the query request that completed the last query before the first query request and satisfies the target condition, and the second query request The query logic is used to indicate the information of the interception conditions of N dimensions, where N is a positive integer;

Determine the corresponding second target data according to the second query logic, and return the second target data to the second client;

Record the query response time corresponding to the second query request, where the query response time is used to indicate the difference between the time when the second query request is received and the time when the second target data is returned to the second client. time difference between

The determining the first query logic includes:

The first query logic is determined according to the query response time corresponding to the second query request and the second query logic.

In an implementation manner, the processing unit 502 is specifically configured to:

If the query response time corresponding to the second query request is greater than the response time threshold, the second query logic is determined as the first query logic.

In an implementation manner, the processing unit 502 is specifically configured to:

If the query response time corresponding to the second query request is less than or equal to the response time threshold, reducing the interception range corresponding to the interception conditions of the N dimensions indicated by the second query logic according to the narrowing rule;

The second query logic after narrowing the interception range is determined as the first query logic.

In an implementation manner, the processing unit 502 is specifically configured to:

reducing the interception range corresponding to the interception conditions of one or more dimensions among the interception conditions of the N dimensions indicated by the second query logic according to the reduction interval corresponding to each dimension;

Alternatively, the interception conditions of the N dimensions indicated by the second query logic are added to the interception conditions of N+M dimensions, where M is a positive integer.

In an implementation manner, the processing unit 502 is further configured to:

If the data volume of the first data is less than the target data volume, expand the interception range of the interception conditions of the K dimensions according to the expansion rule;

acquiring the second data queried by the first query request that simultaneously satisfies the interception conditions of the K dimensions after the expanded interception range;

If the data volume of the second data is greater than or equal to the target data volume, select third target data of the target data volume from the second data, and return the third target data to the first client end.

In an implementation manner, the processing unit 502 is further configured to:

When receiving the remaining data query instruction for the first query request, determine the data volume of the remaining data after removing the data of the target data volume from the first data;

If the data volume of the remaining data is greater than or equal to the target data volume, the data of the target data volume determined from the remaining data is sent to the first client;

If the data volume of the remaining data is less than the target data volume, obtain third data other than the first data and satisfy the interception conditions of the K dimensions according to the first query logic, and obtain the third data according to the first query logic. The target data amount determined by the remaining data and the third data is sent to the first client.

Please refer to FIG. 6 , which is a schematic structural diagram of an electronic device provided by an embodiment of the present application. The electronic device described in this embodiment includes: a processor 601 and a memory 602 . Optionally, the electronic device may further include structures such as a network interface or a power supply module. Data can be exchanged between the above-mentioned processor 601 and memory 602 .

The aforementioned processor 601 may be a central processing unit (Central Processing Unit, CPU), and the processor may also be other general-purpose processors, digital signal processors (Digital Signal Processor, DSP), application specific integrated circuits (Application Specific Integrated Circuit, ASIC) ), off-the-shelf programmable gate array (Field-Programmable Gate Array, FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, and the like. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.

The above-mentioned network interface may include an input device and/or an output device, for example, the input device may be a control panel, a microphone, a receiver, etc., and the output device may be a display screen, a transmitter, etc., which are not listed here one by one. For example, in application embodiments, the network interface may include a receiver and a transmitter.

The above-mentioned memory 602 may include read-only memory and random access memory, and provides program instructions and data to the processor 601 . A portion of memory 602 may also include non-volatile random access memory. Wherein, when the processor 601 calls the program instructions, it is used to execute:

receiving a first query request sent by a first client, where the first query request carries the query scope information of the requested query;

If the query range information satisfies the target condition, determine the first query logic, where the first query logic is used to indicate the information of the interception conditions of K dimensions, where K is a positive integer;

obtaining the first data queried by the first query request that simultaneously satisfies the interception conditions of the K dimensions;

If the data volume of the first data is greater than or equal to the target data volume, select the first target data of the target data volume from the first data, and return the first target data to the first client end.

In an implementation manner, the processor 601 is further configured to:

Receive the second query request sent by the second client, and determine the second query logic; the second query request is the query request that completed the last query before the first query request and satisfies the target condition, and the second query request The query logic is used to indicate the information of the interception conditions of N dimensions, where N is a positive integer;

Determine the corresponding second target data according to the second query logic, and return the second target data to the second client;

Record the query response time corresponding to the second query request, where the query response time is used to indicate the difference between the time when the second query request is received and the time when the second target data is returned to the second client. time difference between

The determining the first query logic includes:

The first query logic is determined according to the query response time corresponding to the second query request and the second query logic.

In an implementation manner, the processor 601 is specifically configured to:

If the query response time corresponding to the second query request is greater than the response time threshold, the second query logic is determined as the first query logic.

In an implementation manner, the processor 601 is specifically configured to:

If the query response time corresponding to the second query request is less than or equal to the response time threshold, reducing the interception range corresponding to the interception conditions of the N dimensions indicated by the second query logic according to the narrowing rule;

The second query logic after narrowing the interception range is determined as the first query logic.

In an implementation manner, the processor 601 is specifically configured to:

reducing the interception range corresponding to the interception conditions of one or more dimensions among the interception conditions of the N dimensions indicated by the second query logic according to the reduction interval corresponding to each dimension;

Alternatively, the interception conditions of the N dimensions indicated by the second query logic are added to the interception conditions of N+M dimensions, where M is a positive integer.

In an implementation manner, the processor 601 is further configured to:

If the data volume of the first data is less than the target data volume, expand the interception range of the interception conditions of the K dimensions according to the expansion rule;

acquiring the second data queried by the first query request that simultaneously satisfies the interception conditions of the K dimensions after the expanded interception range;

If the data volume of the second data is greater than or equal to the target data volume, select third target data of the target data volume from the second data, and return the third target data to the first client end.

In an implementation manner, the processor 601 is further configured to:

When receiving the remaining data query instruction for the first query request, determine the data volume of the remaining data after removing the data of the target data volume from the first data;

If the data volume of the remaining data is greater than or equal to the target data volume, the data of the target data volume determined from the remaining data is sent to the first client;

If the data volume of the remaining data is less than the target data volume, obtain third data other than the first data and satisfy the interception conditions of the K dimensions according to the first query logic, and obtain the third data according to the first query logic. The target data amount determined by the remaining data and the third data is sent to the first client.

Optionally, when the program instructions are executed by the processor, other steps of the methods in the foregoing embodiments may also be implemented, which will not be repeated here.

The present application also provides a computer-readable storage medium, where the computer-readable storage medium stores a computer program, and the computer program includes program instructions, the program instructions, when executed by a processor, cause the processor to execute the above-mentioned The method, such as executing the method executed by the above-mentioned electronic device, will not be described in detail here.

Optionally, the storage medium involved in this application, such as a computer-readable storage medium, may be non-volatile or volatile.

Optionally, the computer-readable storage medium may mainly include a stored program area and a stored data area, wherein the stored program area may store an operating system, an application program required by at least one function, and the like; The data created by the use of the node, etc. Among them, the blockchain referred to in this application is a new application mode of computer technology such as distributed data storage, point-to-point transmission, consensus mechanism, and encryption algorithm. Blockchain, essentially a decentralized database, is a series of data blocks associated with cryptographic methods. Each data block contains a batch of network transaction information to verify its Validity of information (anti-counterfeiting) and generation of the next block. The blockchain can include the underlying platform of the blockchain, the platform product service layer, and the application service layer.

It should be noted that, for the sake of simple description, the foregoing method embodiments are all expressed as a series of action combinations, but those skilled in the art should know that the present application is not limited by the described action sequence. Because in accordance with the present application, certain steps may be performed in other orders or simultaneously. Secondly, those skilled in the art should also know that the embodiments described in the specification are all preferred embodiments, and the actions and modules involved are not necessarily required by the present application.

Those of ordinary skill in the art can understand that all or part of the steps in the various methods of the above embodiments can be completed by instructing relevant hardware through a program, and the program can be stored in a computer-readable storage medium, and the storage medium can include: Flash disk, read-only memory (Read-Only Memory, ROM), random access device (Random Access Memory, RAM), magnetic disk or optical disk, etc.

Embodiments of the present application also provide a computer program product or computer program, where the computer program product or computer program includes computer instructions, and the computer instructions are stored in a computer-readable storage medium. The processor of the computer device reads the computer instructions from the computer-readable storage medium, and the processor executes the computer instructions, so that the computer device performs the steps performed in the embodiments of the above methods. For example, the computer device may be a terminal, or it may be a server.

A data query method, device, electronic device, and storage medium provided by the embodiments of the present application have been described in detail above. The principles and implementations of the present application are described with specific examples. The descriptions of the above embodiments are only It is used to help understand the method and the core idea of the present application; meanwhile, for those skilled in the art, according to the idea of the present application, there will be changes in the specific embodiments and application scope. The contents of the description should not be construed as limiting the application.

Claims (10)

1. A method for data query, the method comprising:

receiving a first query request sent by a first client, wherein the first query request carries query range information requested to be queried;

if the query range information meets the target condition, determining a first query logic, wherein the first query logic is used for indicating the information of the interception conditions of K dimensions, and K is a positive integer;

acquiring first data which meets the interception conditions of the K dimensions and is inquired by the first inquiry request;

and if the data volume of the first data is larger than or equal to the target data volume, selecting the first target data of the target data volume from the first data, and returning the first target data to the first client.

2. The method of claim 1, wherein before receiving the first query request sent by the first client, the method further comprises:

receiving a second query request sent by a second client, and determining a second query logic; the second query request is a query request which completes the query last time before the first query request and meets the target condition, the second query logic is used for indicating the information of the interception conditions of N dimensions, and N is a positive integer;

determining corresponding second target data according to the second query logic, and returning the second target data to the second client;

recording query response time corresponding to the second query request, wherein the query response time is used for indicating a time difference between the time of receiving the second query request and the time of returning the second target data to the second client;

the determining a first query logic, comprising:

and determining the first query logic according to the query response time corresponding to the second query request and the second query logic.

3. The method of claim 2, wherein determining the first query logic according to the query response time corresponding to the second query request and the second query logic comprises:

and if the query response time corresponding to the second query request is greater than a response time threshold, determining the second query logic as the first query logic.

4. The method of claim 2, wherein determining the first query logic according to the query response time corresponding to the second query request and the second query logic comprises:

if the query response time corresponding to the second query request is smaller than or equal to a response time threshold, narrowing down interception ranges corresponding to the interception conditions of the N dimensions indicated by the second query logic according to a narrowing-down rule;

and determining the second query logic with the reduced interception range as the first query logic.

5. The method according to claim 4, wherein the narrowing down the truncation range corresponding to the truncation conditions of the N dimensions indicated by the second query logic according to the narrowing-down rule includes:

narrowing down the interception range corresponding to one or more dimensionalities of the interception conditions of the N dimensionalities indicated by the second inquiry logic according to the narrowing-down interval corresponding to each dimensionality;

or, the N-dimensional truncation conditions indicated by the second query logic are increased to N + M-dimensional truncation conditions, where M is a positive integer.

6. The method of claim 1, further comprising:

if the data volume of the first data is smaller than the target data volume, enlarging the interception range of the interception conditions of the K dimensions according to an enlargement rule;

acquiring second data which meets the interception conditions of K dimensions after the interception range is expanded and is inquired by the first inquiry request;

and if the data volume of the second data is larger than or equal to the target data volume, selecting third target data of the target data volume from the second data, and returning the third target data to the first client.

7. The method of claim 1, wherein after returning the first target data to the first client, further comprising:

when a residual data query instruction aiming at the first query request is received, determining the data volume of the residual data after the data with the target data volume is removed from the first data;

if the data volume of the residual data is larger than or equal to the target data volume, determining data of the target data volume from the residual data and sending the data of the target data volume to the first client;

and if the data volume of the residual data is smaller than the target data volume, acquiring third data which meets the interception conditions of the K dimensions except the first data according to the first query logic, and determining data of the target data volume according to the residual data and the third data and sending the data to the first client.

8. A data query apparatus, comprising:

the device comprises a receiving unit, a query processing unit and a query processing unit, wherein the receiving unit is used for receiving a first query request sent by a first client, and the first query request carries query range information requested to be queried;

the processing unit is used for determining a first query logic if the query range information meets a target condition, wherein the first query logic is used for indicating information of interception conditions of K dimensions, and K is a positive integer;

an obtaining unit, configured to obtain first data of a query indicated by the first query request that simultaneously satisfies the interception conditions of the K dimensions;

the processing unit is further configured to select first target data of the target data size from the first data and return the first target data to the first client if the data size of the first data is greater than or equal to the target data size.

9. An electronic device comprising a processor, a memory, wherein the memory is configured to store a computer program comprising program instructions, and wherein the processor is configured to invoke the program instructions to perform the method of any of claims 1-7.

10. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a computer program comprising program instructions that, when executed by a processor, cause the processor to carry out the method according to any one of claims 1-7.

Images