CN112749190B - Data query method and device, computing equipment and computer storage medium - Google Patents

Abstract

The embodiment of the present invention relates to the field of communication technology, and discloses a data query method, device, computing device, and computer storage medium. The method includes: obtaining a query request from a user terminal; determining query data in a user data table according to the query request; When the data volume of the query data is greater than the preset threshold, filter the query data according to preset filter conditions to obtain target query data; store the query data in a target file; store the target query The data and the address of the target file are sent to the client as query results. Through the above method, the embodiment of the present invention realizes a quick response to the user in the case of obtaining the full amount of data of the user.

Description

Data query method, device, computing device and computer storage medium

technical field

The embodiments of the present invention relate to the technical field of communications, and in particular to a data query method, device, computing device, and computer storage medium.

Background technique

With the development of mobile Internet services, the user's GPRS list grows rapidly, accounting for more than 70% of the total storage capacity of the list. When a user performs a GPRS list query, a large number of results need to be processed to obtain the list data queried by the user. The current data query methods include full query and index query. The full query method obtains all query results, and then performs paging processing on the client side. The index query method generally uses the page number index for query, and the data within the specified page number range is queried each time.

In the process of implementing the embodiments of the present invention, the inventors found that: the existing full query method will cause the query time to be too long, and the network data transmission volume is too large, resulting in a query response time that is too long, and the user needs to wait for a long time to obtain to the query results. The index query method cannot obtain statistical results and full data.

Contents of the invention

In view of the above problems, embodiments of the present invention provide a data query method, device computing equipment, and computer storage media, which overcome the above problems or at least partially solve the above problems.

According to an aspect of an embodiment of the present invention, a data insertion method is provided, the method comprising:

Obtain the query request from the client;

determining query data in the user data table according to the query request;

When the data amount of the query data is greater than a preset threshold, filter the query data according to a preset filter condition to obtain target query data;

storing the query data into a target file;

sending the target query data and the address of the target file to the client as a query result.

Optionally, the user data table includes a statistical data table and a list data table, and the querying the user data table according to the query request to determine the query data includes:

Querying the statistical data table according to the query request to obtain the data volume of the query data;

Querying the list data table according to the query request to obtain a query data list;

The data amount of the query data and the query data list are used as the query data.

Optionally, when the data volume of the query data is greater than a preset threshold, the query data is filtered according to a preset filter condition to obtain target query data, including:

When the data volume of the query data is greater than a preset threshold, filter the list of query data according to a preset filter condition to obtain target query data;

Optionally, the storing the query data into the target file includes:

The query data list is stored in an object file.

Optionally, when the amount of the query data is less than or equal to a preset threshold, the query data is sent to the client as a query result.

Optionally, the method also includes:

Build a list data table according to the business details obtained from the client;

Merge the target business bills in the statistical data table according to the user identification, business type identifier and business bill date of the business bills to obtain the merged business bills;

The statistical data table is updated according to the combined business detailed list and the statistics of the combined business detailed list.

Optionally, the updating the statistical data table according to the combined business detailed list and the statistics of the combined business detailed list includes:

Delete invalid data in the statistical data table, where the invalid data is the business detailed bills in the statistical data table whose date of business detailed bill is before a preset date.

According to another aspect of the embodiments of the present invention, a data query device is provided, including:

An acquisition module, configured to acquire a query request from the client;

A determination module, configured to determine query data in the user data table according to the query request;

A filtering module, configured to filter the query data according to preset filter conditions to obtain target query data when the data volume of the query data is greater than a preset threshold;

a storage module, configured to store the query data into a target file;

A sending module, configured to send the target query data and the address of the target file to the client as a query result.

According to another aspect of the embodiments of the present invention, a computing device is provided, including: a processor, a memory, a communication interface, and a communication bus, and the processor, the memory, and the communication interface complete the mutual communication via the communication bus. communication between

The memory is used to store at least one executable instruction, and the executable instruction causes the processor to execute the above-mentioned data query method.

According to yet another aspect of the embodiments of the present invention, a computer storage medium is provided, wherein at least one executable instruction is stored in the storage medium, and the executable instruction causes the processor to execute the above-mentioned data query method.

The embodiment of the present invention determines the data volume of the query data according to the query request. When the data volume of the query data is greater than the preset threshold, the target query data and the target file address for storing the query data are returned to the client. Compared with returning all query data to the user data, the embodiment of the present invention can realize a quick response to the user's query request on the basis of ensuring that the main query information is returned; in addition, when the data volume of the query data is greater than the preset threshold, the business details corresponding to the query data Stored in the target file, and return the address of the target file to the user, so that the user can download and view the service detailed list. Compared with returning the service detailed list to the client, the embodiment of the present invention reduces the Resource consumption of the data server.

The above description is only an overview of the technical solutions of the embodiments of the present invention. In order to better understand the technical means of the embodiments of the present invention, it can be implemented according to the contents of the description, and in order to make the above and other purposes, features and The advantages can be more obvious and understandable, and the specific embodiments of the present invention are enumerated below.

Description of drawings

Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiment. The drawings are only for the purpose of illustrating a preferred embodiment and are not to be considered as limiting the invention. Also throughout the drawings, the same reference numerals are used to designate the same components. In the attached picture:

Fig. 1 shows a flow chart of a data query method provided by the first embodiment of the present invention;

Fig. 2 shows a flow chart of a data query method provided by the second embodiment of the present invention;

Fig. 3 shows a functional block diagram of a data query device provided by a third embodiment of the present invention;

FIG. 4 shows a schematic structural diagram of a computing device provided by a fourth embodiment of the present invention.

Detailed ways

Exemplary embodiments of the present invention will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present invention are shown in the drawings, it should be understood that the invention may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present invention and to fully convey the scope of the present invention to those skilled in the art.

The application scenario of the embodiment of the present invention is user terminal network data query, wherein the network data includes but not limited to GPRS list, call charge list and so on. The user terminal selects the type of network data to be queried and the time period required for the query, and the data server receives the query request from the user, and queries the network data stored on the data server side according to the query request. The data server first determines the total amount of network data that the user needs to query according to the query request. If the amount is large, the simplified query mode is started, that is, the main query information is returned, and the list data is stored in a preset target file , when the query result is returned to the user, the main query information and the address of the preset target file are returned, so that the user can quickly obtain the query result, and can choose to download the list data in the target file according to the demand. If the total amount of network data to be queried by the user is small, a full query is started, that is, the list data is returned, so that the user can obtain the query result. Through the solution of the embodiment of the present invention, the query result can be quickly obtained, the data query server can quickly respond to the user, and at the same time, the user's demand for the query content can be guaranteed. Various specific embodiments of the present invention will be described below through various specific implementation modes.

Fig. 1 shows the flowchart of a kind of data inquiry method of the first embodiment of the present invention, as shown in Fig. 1, this method comprises the following steps:

Step 110: Obtain a query request from the client.

Wherein, the query request of the client is the query information input by the user on the query platform. The query platform can be a query webpage provided by the operator, on which a query menu is set, for example, the query menu includes but not limited to the number to be queried, the data to be queried, the start time, the end time, etc. Wherein, the number to be inquired is equivalent to an identification information of the user end, and is used to represent the data of inquiring about a specific telephone number. The data to be queried is set in the drop-down options, including but not limited to call bill query and GPRS list query. The starting time can be set as a drop-down calendar option, and the user can select the starting year, month, and day for querying data. Similarly, a drop-down calendar option can be set for the end time, and the user can select the end year, month, and day of the data to be queried. It is understandable that the time of the end year, month, and day relative to the start year, month, and day should be closer to the time of the query day , or the time of the end year, month, and day relative to the start year, month, and day should be the same day.

After entering the query information on the client side, click the query button set on the client side to perform data query. After the user clicks the query button, the data server can obtain the user's query request. Among them, the data server includes a query program and a database, wherein the query program is used to access the database according to the query request of the user to obtain the query result; The generated information, for example, the GPRS information consumed when the user accesses the network, the call information when the user calls, etc. In one embodiment, the data server is an Hbase server, the query program is a query program on the Hbase server side, and the database is an Hbase database. The embodiment of the present invention does not limit the way that the data server obtains the query request of the client. For example, the client and the data server can communicate through a preset protocol, or set a third party for data conversion, and convert the query request of the client into Data that the data server can handle, etc.

Step 120: Determine query data in the user data table according to the query request.

Wherein, the user data table is stored in a database in the data server. In the user data table, the business details of a large number of users are recorded, and the business details include but not limited to user identification, that is, telephone number, business type, relevant date and other information. Match the query data in the user data table according to the number to be queried, the data to be queried, and the query time period contained in the query request.

In some embodiments, after receiving the query request, the data server generates a request message according to the query request, and the request message is a message generated by the data server according to the protocol with the client server. The message stores the query request according to the format preset by the protocol, so that the data server can perform data query according to the request message. The request message carries the query data identifier, and the query data identifier matches the data to be queried in the query request. In an implementation manner, the request message specifically includes the information shown in Table 1.

Table 1

Among them, the serial number 1 represents the query request input by the user, 1.1 to 1.4 are the key fields extracted from the query request, and the parent element name is the field in the request message, including the mobile phone number, query template number, start time and end time . Wherein, the query template number is a query data identifier, which is used to represent the data to be queried. In one embodiment, there are 56 types of query template numbers according to different data to be queried, and each query template number represents a kind of data to be queried, for example, 602 represents GPRS list query.

Step 130: When the data volume of the query data is greater than the preset threshold, filter the query data according to preset filtering conditions to obtain target query data.

Wherein, according to the data volume of the query data matching the query request in the user data table, the query data refers to the business detailed bills matching the query request in the user data table, and the data volume of the query data refers to the number of business detailed bills. If the number of the business details is greater than the preset threshold, it will take a lot of time to return all the business details to the user as the query result, resulting in a long waiting time for the user query and a decrease in user satisfaction; in addition, too long query time may It will cause the query to fail due to timeout, and the query result cannot be returned. Therefore, when the data volume of the query data is greater than a preset threshold, a streamlined query will be performed, that is, only the main information related to the query request will be returned to the user. The determination of the main information is obtained by filtering through preset filter conditions. The preset filter conditions are artificially set according to the data to be queried in the query request, and a corresponding relationship is established between the filter conditions and the data to be queried in the query request. , and solidify the corresponding relationship in the data server, so as to filter the queried business details according to the corresponding relationship when a simplified query is required. The embodiments of the present invention are not limited to the specific content of the preset filter condition. For example, when the query data is a GPRS detailed list, the preset filter condition can be that the GPRS consumption fee is 0, that is, no fee is generated when the GPRS is consumed. The business bills are filtered out, and only the GPRS bills that generate fees are kept.

When the data volume of the query data is less than or equal to the preset threshold, the query data is sent to the client as the query result, that is, the business details matching the query request are returned to the user.

Step 140: Store the query data into the target file.

Among them, in order to facilitate the user to understand the business details corresponding to the data to be queried, while executing step 130, a full query is started on the background of the data server, that is, all business details matching the query request are obtained, and all business details are stored. in a specified object file. In one embodiment, the target file is located in a download server, and the download server is a server that can be accessed and downloaded by a client terminal. The download server can establish communication with the data server, so that the data server can store the business details in the target file in the download server. For example, the url address of the target file in the download server is stored in the data server, and the data server only needs to store the queried service details in the target file corresponding to the url address.

Step 150: Send the target query data and the address of the target file to the client as a query result.

Wherein, the target query data is data including main query information obtained after being filtered by preset filter conditions. The address of the target file is the url address of the target file.

In some embodiments, after the data server determines the target query data and the address of the target file, the target query data and the target file address are used as query results and stored as a response message in a preset format. The response message is a message generated by the data server according to the agreement with the client server after confirming the query result. text to determine the query results. In an implementation manner, the response message includes the following information as shown in Table 2.

Table 2

serial number parent element name element name constraint length describe 1 CHEERBOSS DATA 1 1.1 DATA RESULT 1 20 Result set splicing string 1.2 DATA url 1 14 Target file address

Among them, the information corresponding to the serial number 1 is the query result, including the target query result and the target file address, wherein the target file address is a url address, and the user can click the url address to obtain the business details stored in the target file.

It is worth noting that when the amount of query data is greater than the preset threshold, the business details are stored in the response message as the query result, and the corresponding target file is empty.

The embodiment of the present invention determines the data volume of the query data according to the query request. When the data volume of the query data is greater than the preset threshold, the target query data and the target file address for storing the query data are returned to the client. Compared with returning all query data to the user data, the embodiment of the present invention can realize a quick response to the user's query request on the basis of ensuring that the main query information is returned; in addition, when the data volume of the query data is greater than the preset threshold, the business details corresponding to the query data Stored in the target file, and return the address of the target file to the user, so that the user can download and view the service detailed list. Compared with returning the service detailed list to the client, the embodiment of the present invention reduces the Resource consumption of the data server.

Fig. 2 shows a flow chart of a data query method in the second embodiment of the present invention. In the embodiment of the present invention, the user data table includes a statistical data table and a list data table. As shown in Fig. 2, the embodiment of the present invention Include the following steps:

Step 210: Construct an inventory data table according to the obtained detailed service list of the client.

Wherein, the header of the list data table is pre-built, that is, the fields contained in the list data table are pre-set, and the relevant fields are extracted from the obtained business detailed list of the client, and stored in the corresponding table. Each row of the list data table represents a detailed business list, and each column corresponds to the same information. In one embodiment, the user list data table includes phone number, service date, service type and bill details. After obtaining a bill, the corresponding information is extracted from the bill for storage, and a large amount of bill information is stored to form a list data table.

Step 220: Merge the target business bills in the statistical data table according to the user ID, business type ID, and business bill date of the business bills to obtain a merged business bill.

Wherein, the obtained business detailed bill will be stored in the statistical data table, and related fields are preset in the statistical data table, and the field includes user ID, business type ID, business detailed bill date and statistics. The user ID includes but not limited to the mobile phone number, and the service type ID indicates the service corresponding to the service list, for example, GPRS list, call charge list, etc. The business detailed bill date is the date when the business corresponding to the business detailed bill occurs. The data volume of each business detailed list obtained before merging is 1.

Merge the same type of business performed by the same user on the same day. After the merger, there is only one of the same type of business performed by the same user on the same day. The number of merged business detailed bills is used as the data volume of the merged business detailed bill. The statistical data table includes the business detailed list and the data volume of the business detailed list. In one embodiment, the statistical data table also includes a statistical identifier of the detailed business bill, which is used to indicate whether the detailed business bill can be merged. The first statistical identifier indicates that the merge is possible, and the second statistical identifier indicates that the merged bill cannot be performed. That is, it is already a consolidated business detail list. The statistical identifier of each obtained business detailed list before merging is the first statistical identifier.

Step 230: Update the statistical data table according to the merged detailed business bill and the statistics of the merged business detailed bill.

In this step, the statistic of the merged business detailed bills is the total quantity of all merged business detailed bills. Use this quantity as the statistical quantity of the consolidated business detailed list. In one embodiment, the business detailed list and its related fields in the statistical data table before merging are deleted, and only the combined business detailed list and related fields are retained, so as to facilitate subsequent acquisition of the data volume of query data.

In some embodiments, the statistical data table is maintained, and invalid data in the statistical data table is deleted, so as to reduce the storage capacity of the statistical data table. Expiration data is the business detailed list whose date of business detailed list in the statistical data table is before the preset date. Considering that the query time of the client is generally within one year, the preset date is generally 1 year from the maintenance date of the statistical data table.

Step 240: Obtain a query request from the client.

Step 250: Query the statistical data table and the list data table respectively according to the query request to obtain the data volume of the query data and the query data list.

In this step, match the statistics corresponding to the merged business details in the statistical data table according to the query request, and use the statistics as the data volume of the query data. The list data table is queried according to the query request to obtain the query data list.

Step 260: When the amount of query data is greater than a preset threshold, filter the list of query data according to preset filtering conditions to obtain target query data.

Step 270: Store the query data list into the target file.

Step 280: Send the target query data and the address of the target file to the client as a query result.

For descriptions of steps 260 to 280, please refer to steps 130 to 150 in the first embodiment, and details will not be repeated here.

In the embodiment of the present invention, by setting the statistical data table for the statistics of the detailed business bill, and by setting the list data table for determining the list of the detailed business bill, it is convenient to determine whether the data volume of the query data is greater than Preset the threshold, so as to determine the query result according to the comparison result between the data volume of the query data and the preset threshold.

Fig. 3 shows a schematic structural diagram of an embodiment of a data query device according to the third embodiment of the present invention. As shown in FIG. 3 , the device includes: an acquisition module 410 , a determination module 420 , a filter module 430 , a storage module 440 and a sending module 450 .

The acquisition module 410 is configured to acquire the query request of the client. A determining module 420, configured to determine query data in the user data table according to the query request. The filtering module 430 is configured to filter the query data according to a preset filter condition to obtain target query data when the data amount of the query data is greater than a preset threshold. A storage module 440, configured to store the query data into a target file. A sending module 450, configured to send the target query data and the address of the target file to the client as a query result.

Optionally, the device further includes a first sending module 460, configured to send the query data to the client as a query result when the amount of the query data is less than or equal to a preset threshold.

Optionally, the user data table includes a statistical data table and a list data table, and the determining module 420 is further used to:

Querying the statistical data table according to the query request to obtain the data volume of the query data;

Query the list data table according to the query request to obtain a query data list; the filtering module 430 is further configured to: when the data volume of the query data is greater than a preset threshold, filter the query data according to a preset filter condition The list is filtered to obtain target query data; the storage module 440 is further configured to: store the list of query data into a target file.

Optionally, the device further includes: a building module 470 , a merging module 480 and an updating module 490 . Wherein, the construction module 470 is used for constructing the list data table according to the obtained detailed service list of the client. The merging module 480 is configured to combine the target business bills in the statistical data table according to the user ID, business type ID, and business bill date of the business bills to obtain a merged business bill. The updating module 490 is configured to update the statistical data table according to the combined business detailed bill and the statistics of the combined business detailed bill.

Optionally, the update module 490 is further configured to delete invalid data in the statistical data table, where the invalid data is the business detailed bills in the statistical data table whose date of business detailed bill is before a preset date.

In the embodiment of the present invention, the data volume of the query data is determined through the query request. When the data volume of the query data is greater than the preset threshold, the target query data and the target file address for storing the query data are returned to the client. Compared with returning all query data to the user data, the embodiment of the present invention can realize a quick response to the user's query request on the basis of ensuring that the main query information is returned; in addition, when the data volume of the query data is greater than the preset threshold, the business details corresponding to the query data Stored in the target file, and return the address of the target file to the user, so that the user can download and view the service detailed list. Compared with returning the service detailed list to the client, the embodiment of the present invention reduces the Resource consumption of the data server.

An embodiment of the present invention provides a non-volatile computer storage medium, the computer storage medium stores at least one executable instruction, and the computer executable instruction can execute a data query method in any of the above method embodiments.

FIG. 4 shows a schematic structural diagram of a computing device according to a fourth embodiment of the present invention. The specific embodiment of the present invention does not limit the specific implementation of the computing device.

As shown in FIG. 4 , the computing device may include: a processor (processor) 502, a communication interface (Communications Interface) 504, a memory (memory) 506, and a communication bus 508.

Wherein: the processor 502 , the communication interface 504 , and the memory 506 communicate with each other through the communication bus 508 . The communication interface 504 is configured to communicate with network elements of other devices such as clients or other servers. The processor 502 is configured to execute the program 510, specifically, may execute the above-mentioned relevant steps in the embodiment of the data query method.

Specifically, the program 510 may include program codes including computer operation instructions.

The processor 502 may be a central processing unit CPU, or an ASIC (Application Specific Integrated Circuit), or one or more integrated circuits configured to implement the embodiments of the present invention. The one or more processors included in the computing device may be of the same type, such as one or more CPUs, or may be different types of processors, such as one or more CPUs and one or more ASICs.

The memory 506 is used for storing the program 510 . The memory 506 may include a high-speed RAM memory, and may also include a non-volatile memory (non-volatile memory), such as at least one disk memory.

The program 510 may specifically be used to enable the processor 502 to execute steps 110 to 150 in FIG. 1 , steps 210 to 280 in FIG. 2 and realize the functions of modules 410 to 490 in FIG. 3 .

The algorithms or displays presented herein are not inherently related to any particular computer, virtual system, or other device. Various generic systems can also be used with the teachings based on this. The structure required to construct such a system is apparent from the above description. Furthermore, embodiments of the present invention are not directed to any particular programming language. It should be understood that various programming languages can be used to implement the content of the present invention described herein, and the above description of specific languages is for disclosing the best mode of the present invention.

In the description provided herein, numerous specific details are set forth. However, it is understood that embodiments of the invention may be practiced without these specific details. In some instances, well-known methods, structures and techniques have not been shown in detail in order not to obscure the understanding of this description.

Similarly, it should be appreciated that in the foregoing description of exemplary embodiments of the invention, in order to streamline the present disclosure and to facilitate an understanding of one or more of the various inventive aspects, various features of the embodiments of the invention are sometimes grouped together into a single implementation examples, figures, or descriptions thereof. This method of disclosure, however, is not to be interpreted as reflecting an intention that the claimed invention requires more features than are expressly recited in each claim. Rather, as the following claims reflect, inventive aspects lie in less than all features of a single foregoing disclosed embodiment. Thus, the claims following the Detailed Description are hereby expressly incorporated into this Detailed Description, with each claim standing on its own as a separate embodiment of this invention.

Those skilled in the art can understand that the modules in the device in the embodiment can be adaptively changed and arranged in one or more devices different from the embodiment. Modules or units or components in the embodiments may be combined into one module or unit or component, and furthermore may be divided into a plurality of sub-modules or sub-units or sub-assemblies. All features disclosed in this specification (including accompanying claims, abstract and drawings) and any method or method so disclosed may be used in any combination, except that at least some of such features and/or processes or units are mutually exclusive. All processes or units of equipment are combined. Each feature disclosed in this specification (including accompanying claims, abstract and drawings) may be replaced by alternative features serving the same, equivalent or similar purpose, unless expressly stated otherwise.

Furthermore, those skilled in the art will understand that although some embodiments herein include some features included in other embodiments but not others, combinations of features from different embodiments are meant to be within the scope of the invention. And form different embodiments. For example, in the following claims, any of the claimed embodiments may be used in any combination. It should be noted that the above-mentioned embodiments illustrate rather than limit the invention, and that those skilled in the art will be able to design alternative embodiments without departing from the scope of the appended claims. In the claims, any reference signs placed between parentheses shall not be construed as limiting the claim. The word "comprising" does not exclude the presence of elements or steps not listed in a claim. The word "a" or "an" preceding an element does not exclude the presence of a plurality of such elements. The invention can be implemented by means of hardware comprising several distinct elements, and by means of a suitably programmed computer. In a unit claim enumerating several means, several of these means can be embodied by one and the same item of hardware. The use of the words first, second, and third, etc. does not indicate any order. These words can be interpreted as names. The steps in the above embodiments, unless otherwise specified, should not be construed as limiting the execution order.

Claims (9)

1. A data query method, characterized in that the method comprises: Obtain the query request from the client; Querying the statistical data table according to the query request to obtain the data volume of the query data; Querying the list data table according to the query request to obtain the query data list; Using the data volume of the query data and the list of query data as query data; When the data amount of the query data is greater than a preset threshold, filter the query data according to a preset filter condition to obtain target query data; storing the query data into a target file; sending the target query data and the address of the target file to the client as a query result. 2. The method according to claim 1, wherein when the amount of the query data is greater than a preset threshold, the query data is filtered according to a preset filter condition to obtain the target query data ,include: When the data volume of the query data is greater than a preset threshold, the query data list is filtered according to a preset filter condition to obtain target query data. 3. The method according to claim 1 or 2, wherein the storing the query data in the target file comprises: The query data list is stored in an object file. 4. method according to claim 1 or 2, is characterized in that, described method also comprises: Build a list data table according to the business details obtained from the client; Merge the target business bills in the statistical data table according to the user identification, business type identifier and business bill date of the business bills to obtain the merged business bills; The statistical data table is updated according to the combined business detailed list and the statistics of the combined business detailed list. 5. The method according to claim 4, characterized in that, updating the statistical data table according to the combined business detailed list and the statistics of the combined business detailed list includes: Delete invalid data in the statistical data table, where the invalid data is the business detailed bills in the statistical data table whose date of business detailed bill is before a preset date. 6. The method according to claim 1, wherein, when the data volume of the query data is less than or equal to a preset threshold, the method further comprises: sending the query data to the client as a query result. 7. A data query device, characterized in that the device comprises: An acquisition module, configured to acquire a query request from the client; A determination module, configured to query the statistical data table according to the query request, to obtain the data volume of the query data; The determining module is further configured to query the list data table according to the query request to obtain the query data list; The determining module is further configured to use the data volume of the query data and the list of query data as query data; A filtering module, configured to filter the query data according to preset filter conditions to obtain target query data when the data volume of the query data is greater than a preset threshold; a storage module, configured to store the query data into a target file; A sending module, configured to send the target query data and the address of the target file to the client as a query result. 8. A computing device, comprising: a processor, a memory, a communication interface, and a communication bus, wherein the processor, the memory, and the communication interface complete mutual communication through the communication bus; The memory is used to store at least one executable instruction, and the executable instruction causes the processor to execute a data query method according to any one of claims 1-6. 9. A computer storage medium, characterized in that at least one executable instruction is stored in the storage medium, and the executable instruction causes the processor to execute a data query according to any one of claims 1-6 method.

Images