WO2017133538A1

WO2017133538A1 - Method for realizing data query and server

Info

Publication number: WO2017133538A1
Application number: PCT/CN2017/072178
Authority: WO
Inventors: 景小卫
Original assignee: 中兴通讯股份有限公司
Priority date: 2016-02-05
Filing date: 2017-01-23
Publication date: 2017-08-10
Also published as: CN107045499A

Abstract

Provided are a method for realizing a data query and a server. The method comprises: after receiving a query instruction, a server generates pagination query statements according to the query instruction (100); and the server executes the generated pagination query statements, and returns, according to the respective pagination query statements, corresponding query data (101). The invention performs a pagination query by means of pagination query statements generated according to a query instruction, thereby reducing an amount of query data fed back after accessing big table data, preventing waste of resources associated with network communication and a server, and improving user experience.

Description

Method and server for realizing data query

Technical field

The present disclosure relates to data processing techniques, for example, to a method and server for implementing data queries.

Background technique

Telecom network management, power system monitoring, online stores, etc. often maintain a large amount of data, these maintained data are generally stored in the database system table; for example, telecommunications network management and power system monitoring need to maintain the system's daily performance, alarm information and other data The online store needs to maintain a large amount of commodity information data, etc., and the amount of data maintained is usually huge. The table used to store the data is called a large table; for example, a large table for storing daily performance data of the telecommunication network management, by network element, single Each test point in the board and the board generates one performance data every 15 minutes, and the daily performance data of the large-scale telecommunication network coupled with the large-scale telecommunication network for one month will reach an astonishing scale. The user queries and browses the data stored in the large table through the client to obtain the desired content (interesting, valuable content). The purpose of querying large tables is very broad and may involve a large amount of data.

At present, the data is accessed in a large table in the following manner: The first type, according to the data query, the server obtains all the data satisfying the query command according to the query command, and then sends all the data to the client; The server distributes the fixed number of fixed or fixed time query results to the client according to the query command.

When the above two methods are used to access data in a large table, a large amount of query data will be continuously sent to the client regardless of whether the user views or does not look at it, causing waste of network communication and server resources, and causing a decrease in response speed of the client. Affect the user experience.

Summary of the invention

In order to solve the above technical problem, the present disclosure provides a method and a server for implementing data query, which can avoid a large amount of feedback query data when accessing a large table.

The present disclosure provides a method of implementing data query, including:

After receiving the query instruction, the server generates a page query statement according to the query instruction;

The server executes each generated page query statement and returns corresponding query data according to each page query statement.

Optionally, generating a paged query statement includes:

Generating the paged query statement according to the fixed query size according to the query instruction; or

After generating the first paging query according to the fixed query size, generating a subsequent paging query according to the query record of the preceding paging query;

The query size is a product of the number of query windows and the amount of data displayed by the query window;

The query record includes: the number of query windows, the query duration, the transmission duration of the query data, and the insertion duration of the query data when the page break query statement is executed in one-to-one correspondence with each page query statement.

Optionally, the subsequent paged query statement generated according to the query record of the previous paged query statement includes:

Calculating a quotient of the query duration of a preceding page query statement divided by a preset response threshold as an ease factor;

If the ease factor is in the preset interval, the query size is not adjusted;

If the ease factor exceeds the preset interval, when the number of the query records is less than the preset value, the query size of the next post-page query statement is not adjusted, and the next subsequent page query statement is generated;

If the easiness factor exceeds the preset interval, when the number of the query records is greater than the preset value, the query size of the subsequent pagination query statement is adjusted according to the query record, and the next subsequent pagination query statement is generated according to the adjusted query size. .

Optionally, before the generating the subsequent paging query according to the query duration of the preceding paging query, the method further includes:

The query timing is respectively performed on each of the paging query statements to obtain the query duration of the previous paging query statement.

Optionally, the method further includes:

When the query of the page query query fails, the query failure information is fed back;

The query failure information includes a query failure reason and/or a preset query failure code.

Optionally, the method further includes:

Determining whether the returned query data is the last packet data of the last page query statement;

If it is the last packet data of the last paged query statement, the last packet data insertion process is performed in the query window of the browse query data: if it is not the last packet data of the last page query statement, the query data is browsed. The query window performs the insertion processing of the intermediate data.

Optionally, the method further includes:

When the query window of the browse query data is detected, it is determined whether the number of query windows of the currently remaining display query data reaches a preset trigger threshold;

If the current number of query windows displaying the query data does not reach the preset trigger threshold, the display of the query data of the current page query query is continued; if the current number of query windows for displaying the query data reaches the preset trigger threshold , then execute the next post-page query statement.

Optionally, the method further includes:

When the query window is not detected or the operation of closing the query window is received, the execution of the paging query is stopped.

Optionally, the method further includes:

Counting the display time of the previous preset number of query windows;

Determining the display duration of the remaining query windows according to the average display duration of the query window;

When the display duration of the remaining query window reaches the preset trigger threshold, the subsequent paged query statement is executed.

On the other hand, an embodiment of the present disclosure further provides a server for implementing data query, including: a generating unit and a returning unit; wherein

The generating unit is configured to generate a paging query statement according to the query instruction after receiving the query instruction;

The return unit is configured to execute each generated page query statement and return corresponding query data according to each page query statement.

Optionally, the generating unit is configured to

After receiving the query instruction,

Optionally, the generating unit is configured to

After receiving the query instruction,

If the ease factor is in the preset interval, the query size is not adjusted;

If the ease factor exceeds the preset interval, when the number of query records is greater than the preset value, the query size of the next page query query is adjusted according to the query time, and the next subsequent page query statement is generated according to the adjusted query size. .

Optionally, the server further includes a timing unit configured to generate the subsequent paging query according to the query duration of the preceding paging query.

Optionally, the server further includes a query feedback unit, configured to feed back the query failure information when the query of the page query query fails;

Optionally, the server further includes a packet processing unit configured to determine whether the returned query data is the last packet data of the last page query statement;

Optionally, the server further includes a page turning processing unit:

Optionally, the server further includes a stopping unit configured to stop executing the paging query statement when the query window is not detected to be turned over or the operation of closing the query window is received.

Optionally, the server further includes a triggering unit configured to count the display time of the previous preset number of query windows;

Embodiments of the present disclosure also provide a non-transitory computer readable storage medium storing computer executable instructions arranged to perform the above method.

An embodiment of the present disclosure further provides an electronic device, including:

At least one processor;

a memory communicatively coupled to the at least one processor; wherein

The memory stores instructions executable by the at least one processor, the instructions being executed by the at least one processor to cause the at least one processor to perform the method described above.

Compared with the related art, the technical solution of the present disclosure includes: after receiving the query instruction, the server generates a page query statement according to the query instruction; the server executes each generated page query statement, and returns corresponding query data according to each page query statement. In the method of the embodiment of the present disclosure, the paging query by the paging query generated by the query instruction reduces the feedback amount of the query data when the large table data is accessed, thereby avoiding waste of network communication and server resources, and improving the user experience.

BRIEF abstract

The drawings described herein are intended to provide an understanding of the present disclosure, and are intended to be a part of this disclosure. In the drawing:

1 is a flowchart of a method for implementing data query according to an embodiment of the present disclosure;

2 is a structural block diagram of a server for implementing data query according to an embodiment of the present disclosure;

3 is a flowchart of a method of an application example of the present disclosure;

FIG. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present disclosure.

detailed description

In order to make the technical solutions and advantages of the present disclosure more apparent, the embodiments of the present disclosure will be described in detail below with reference to the accompanying drawings. It should be noted that the embodiments in the present disclosure and the features in the embodiments may be arbitrarily combined with each other without conflict.

FIG. 1 is a flowchart of a method for implementing data query according to an embodiment of the present disclosure. As shown in FIG. 1 , the method includes:

Step 100: After receiving the query instruction, the server generates a page query statement according to the query instruction.

Optionally, generating a paged query statement includes:

Generate a paged query statement according to a query size according to a fixed query size; or,

After the first paging query statement is generated according to the fixed query size, the subsequent paging query statement is generated according to the query record of the previous paging query statement;

The query size is the product of the number of query windows and the amount of data displayed by the query window; here, the amount of data displayed by the query window can be understood as the size of the query window;

The query record includes: the number of query windows when executing each page query statement in one-to-one correspondence with each page query statement, the query duration, the transmission time of the query data, and the insertion time of the query data. Each paged query statement contains a one-to-one correspondence record.

Calculate the quotient of the previous query length of a paged query statement divided by the preset response threshold. Ease of use factor;

If the ease factor is in the preset interval, the query size is not adjusted;

It should be noted that the preset interval of the embodiment of the present disclosure may be (0.8, 1.05). The preset interval may be an empirical value of those skilled in the art, so that the browsing of the query data can be smoothly performed as a standard, and the feedback time of the slowest query data that can be accepted is used as the bottom line.

If the easiness factor exceeds the preset interval, when the number of the query records is less than the preset value, the query size of the next post-page query statement is not adjusted;

If the ease factor exceeds the preset interval, when the number of query records is greater than the preset value, the query size of the next page query query is adjusted according to the query record.

It should be noted that the application query duration can be recorded by the server; the client timer can be used to record the start time of the page query query to the time when the query data is inserted into the query window, and the start time of the page query is executed. The length of time that the query data is inserted into the query window minus the length of the query to get the query data. In addition, the query duration, the transmission duration of the query data, and the insertion duration of the query data can be stored in a queue manner.

In the embodiment of the present disclosure, if the number of query windows is w, the sum of the transmission duration of the query data and the insertion duration of the query data is T1, the first fitting function T1=a*w+b can be obtained by fitting. For the contents of the numerical query records, a and b in the first fitting function can be obtained; if the query duration is T2, the second fitting function T2=c*w+d can be obtained by fitting, and the query records are preset by a numerical value. Content, you can get c and d in the second fitting function; set the target response time, and calculate the target response time equal to (a*w+c)+(b*w+d) to get the next paged query. The value of the query window number w of the statement. If the calculated value is not an integer, it can be rounded up or down. In this application example, the target response time can be set to be the same as the preset response threshold value, or can be adjusted according to the actual query data feedback speed requirement.

Optionally, the query size of the subsequent pagination query can be calculated on the client. For example, the server sends the recorded query duration to the client, and the client combines the transmission duration of the query data recorded by the client and the insertion of the query data. The duration is calculated by using the first fitting function, the second fitting function and the target response time to obtain the query size of the subsequent pagination query statement; the query size of the subsequent pagination query statement can be calculated on the server side, for example, The client sends the recorded transmission time of the query data and the insertion time of the query data to the server, and the server combines the first fitting function, the second fitting function and the target response time to obtain the latter one. Minute The query size of the page query statement;

In the embodiment of the present disclosure, when the query size of the subsequent page query statement is adjusted according to the query record, if the query size is too large, the ease factor is theoretically larger than the maximum value of the preset interval, and the subsequent page is reduced. The number of query windows of the query statement can speed up the feedback of the query data, and the ease of use coefficient is theoretically reduced; if the query size is too small, the ease factor is theoretically smaller than the minimum value of the preset interval, by adding a subsequent page query. The number of query windows of the statement can increase the amount of data of the query data; enable the user to obtain enough information when executing a paged query statement; that is, when the ease factor is greater than the maximum value of the preset interval, the query is reduced in the next page. The number of query windows for the statement; when the ease factor is less than the maximum value of the preset interval, the number of query windows in the next paged query statement is increased. The reduction and increase of the number of query windows can be calculated by referring to the fitting function, or can be adjusted according to a preset step size or an adjustment function.

Step 101: The server executes each generated page query statement, and returns corresponding query data according to each page query statement.

The method of the embodiment of the present disclosure further includes: before the generating the subsequent paging query statement according to the query duration of the preceding paging query.

The query timing of each paging query statement is separately obtained to obtain the query duration of the previous paging query statement.

Optionally, the method of the embodiment of the disclosure further includes:

When the query of the paging query fails, the query failure information is fed back;

The query failure information includes the reason for the query failure and/or a preset query failure code.

Optionally, the method of the embodiment of the disclosure further includes:

Determine whether the returned query data is the last packetized data of the last paged query statement;

Optionally, the method of the embodiment of the disclosure further includes:

When the query window of the browse query data is detected, it is determined whether the number of query windows of the currently remaining display query data reaches the preset trigger threshold; here, the trigger threshold can be set to be fixed. The number, for example, is set to 1/3 of the number of query windows up or down;

It should be noted that, by determining whether the number of query windows of the currently remaining display query data reaches a preset triggering threshold, then determining whether to execute the next subsequent paging query statement, and performing data query of the subsequent paging query in advance , improve the feedback efficiency of query data.

Optionally, the method of the embodiment of the disclosure further includes:

Counting the display time of the previous preset number of query windows;

It should be noted that, according to the display time of the query window, it is determined whether the execution of the post-page query statement is performed in advance when the trigger threshold is satisfied, thereby improving the speed at which the user obtains the query data corresponding to the post-page query statement, thereby improving the user experience. The processing of the foregoing method in the embodiment of the present disclosure may be implemented by a central processing unit; the execution content involved in the embodiment method may be added to the central processing unit after generating a corresponding execution instruction.

In the method of the embodiment of the present disclosure, the paging query statement reduces the feedback amount of the query data when the large table data is accessed, thereby avoiding waste of network communication and server resources, and improving the user experience.

2 is a structural block diagram of a server for implementing data query according to an embodiment of the present disclosure. As shown in FIG. 2, the method includes: a generating unit and a returning unit;

Optionally, the generating unit is configured to

After receiving the query command,

The query size is the product of the number of query windows and the amount of data displayed in the query window;

The query record includes: the number of query windows when executing each page query statement in one-to-one correspondence with each page query statement, the query duration, the transmission time of the query data, and the insertion time of the query data.

Optionally, the generating unit is configured to

Calculating the quotient of the previous query duration of a paged query statement divided by the preset response threshold as an ease factor;

If the ease factor is in the preset interval, the query size is not adjusted;

Optionally, the embodiment of the present disclosure further includes a timing unit configured to generate a subsequent paging query according to a query duration of the preceding paging query.

Optionally, the server of the disclosure further includes a query feedback unit configured to feed back the query failure information when the query of the page query query fails.

Optionally, the embodiment of the present disclosure further includes a packet processing unit configured to determine whether the returned query data is the last packet data of the last page query statement;

If it is the last subcontracted data of the last pagination query, look up the query data. The inquiry window performs the insertion processing of the last packet data: if it is not the last packet data of the last page query statement, the interpolation processing of the intermediate data is performed in the query window of the browse query data.

Optionally, the server of the disclosure further includes a page turning processing unit:

Optionally, the embodiment of the present disclosure further includes a stopping unit configured to stop executing the paging query statement when the query window is not detected to be turned over or the operation of closing the query window is received.

Optionally, the server of the disclosed embodiment further includes a triggering unit configured to count a display time of the previous preset number of query windows;

The method of the embodiments of the present disclosure is described in detail below by way of application examples, and the application examples are only used to illustrate the disclosure, and are not intended to limit the scope of the disclosure.

Application example

The application example system includes a client and a server, and the client is deployed in a data access interface of the application system. FIG. 3 is a flowchart of a method for applying the example of the present disclosure. As shown in FIG. 3, the method includes:

Step 300: The server starts a query thread for data access;

It should be noted that the application data query thread of the present disclosure may also be established when the user opens the browsing window, which is a conventional technical means by those skilled in the art, and details are not described herein again. Here the query thread refers to the query thread that accesses the large table data.

Step 301: The client receives a user instruction to determine a data range of the access data, and sends a query instruction to the server.

This step triggers the client to enter the data browsing process, and may include the following processing: by determining the data range, the client enters the query state, that is, the client query end state is false; sending the query command to Server, the server enters the query state. The query instruction sent by the application example to the server may include: a conditional query statement, a browse window page size, and a query window number; wherein, the initial value of the query window number may adopt a preset value, for example, the preset value may be set to be determined by statistical analysis. The average number of access pages, for example, the initial value of the number of query windows is 5.

Step 302: After receiving the query instruction, the server generates a page query statement according to the query instruction.

In this step, generating a paged query statement includes:

Optionally, when the paging query statement is generated according to the query instruction according to the fixed query size, the query size of each generated paging query statement may be the same; for example, the number of query windows in the query size is set to a fixed value of 5-7. Value, at this time, according to the query instruction, all the paged query statements that meet the requirements are generated. When the application example of the present disclosure uses a fixed query size to generate a paged query statement, the query size can be saved as a fixed parameter.

The subsequent paged query statement generated according to the query record of the previous paged query statement includes:

Calculating the ease of use after the query duration of the previous paged query is divided by the preset response threshold;

It should be noted that the response threshold may be determined based on industry standards, customer requirements, or technician design indicators. The response threshold mainly refers to the response duration of the paged query statement; in general, when the large table data is queried, the small operation response time is in the second level, for example, 3 to 5 seconds, the response threshold can be set to 3 to 5 seconds. If the response threshold is set too large, the user will be affected by the data query experience if the preset interval is unchanged.

If the ease factor is in the preset interval, the query size is not adjusted; the preset interval of this application example may be (0.8, 1.05). The preset interval may be an empirical value of those skilled in the art, so that the browsing of the query data can be smoothly performed as a standard, and the feedback time of the slowest query data that can be accepted is used as the bottom line.

If the easiness factor exceeds the preset interval, when the number of the query records is less than the preset value, the query size is not adjusted; here, the query size is not adjusted: the post query statement is generated according to the query size of the previous pagination query; The preset value can be set to an integer greater than or equal to 2.

The query record includes: the number of query windows and the query response time in one-to-one correspondence with each page query statement when executing each page query statement; wherein the query response time includes: the query duration, the transmission time of the query data, and the insertion time of the query data. ;

This application example query duration is recorded by the server; this application example can also record the start time of executing the paged query statement through the client timer to the time when the query data is inserted into the query window, and the start time of the paged query statement to the query data insertion. The length of the query window is subtracted from the query window time to get the length of the query data.

It should be noted that the adjustment record can be processed in the server by means of a queue.

If the ease factor exceeds the preset interval, when the number of query records is greater than the preset value, the query size of the subsequent page query statement is adjusted according to the query record.

In this application example, assuming that the number of query windows is w, the sum of the transmission duration of the query data and the insertion duration of the query data is T1, the first fitting function T1=a*w+b can be obtained by fitting, and the preset value is obtained. For the contents of the query record, a and b in the first fitting function can be obtained; if the query duration is T2, the second fitting function T2=c*w+d can be obtained by fitting, and the record is recorded by a preset value. Content, can obtain c and d in the second fitting function; set the target response time, and calculate the target response time equal to (a*w+c)+(b*w+d) to obtain a subsequent paged query statement. The value of the number of query windows w, if the value obtained by the calculation is not an integer, it can be rounded up or down. In this application example, the target response time can be set to be the same as the preset response threshold value, or can be adjusted according to the actual query data feedback speed requirement.

In this application example, the query size of the next paged query statement can be calculated on the client side. For example, the server sends the recorded query duration to the client, and the client combines the record length of the query data recorded by the client and the query data. The insertion duration is calculated by using the first fitting function, the second fitting function and the target response time to obtain the query size of the subsequent pagination query statement; the query size of the subsequent pagination query statement can be calculated on the server side, for example, The client sends the record transmission time of the query data and the insertion time of the query data to the server, and the server combines the first fitting function, the second fitting function and the target response time to obtain the subsequent query time. The query size of a paged query statement;

Here, the ease factor exceeds the preset interval, where the value of the ease factor is less than the minimum value of the preset interval and the value of the ease factor is greater than the maximum value of the preset interval; the value of the ease factor is less than the minimum of the preset interval When the value is used, the application example obtains the first fitting function and the second fitting function according to the query record fitting, and the number of query windows of the next post-page query statement can be calculated by setting the target response time to be larger than the previous pagination query. The number of query windows of the statement; when the value of the easy-to-use coefficient is greater than the maximum value of the preset interval, the application example obtains the first fitting function and the second fitting function according to the query record fitting, and can be calculated by setting the target response time. The number of query windows for obtaining the next post-page query statement is smaller than the number of query windows for the previous page query statement; by adjusting, the query data fed back by each page query statement is integrated in the data amount and the feedback rate, thereby improving the user in the large table. The experience of using data queries.

It should be noted that, according to the query duration of the previous paging query, the default paging value may be used as the query size of the first paging query, and the query size is equal to the number of query windows. The client window displays the product of the amount of data; the initial value of the general query window can be 5 to 7, and the value can be adjusted according to the query data return speed and the user experience when the page query statement is executed.

The example method of the present disclosure further includes: performing query timing on each page query statement to obtain a query duration of the previous page query statement.

It should be noted that the application query timing of the present disclosure can be performed by a timer, and the query duration can be obtained by recording the query start time and end time of each page query query. If it is a continuous query, the end of the previous page query statement The time is the starting time of the current paging query statement; if the paging query statement is a non-contiguous query, the query duration can be obtained by reading the system time from the beginning to the end of the paging query.

Step 303: The server executes each generated page query statement, and returns corresponding query data according to each page query statement.

When a paging query is queried, the general starting time and the query size are pushed into the query stack. When the execution of the paging query is completed, the paging query in the query stack is cleared.

It should be noted that the execution of the query instruction according to the existing connection access needs to access the database or the large table, for example, through the database large table access interface to establish a connection with the database; access to the database or the contents of the large table in the database is a person skilled in the art The usual technical means will not be repeated here.

The application examples of the disclosure also include:

Optionally, the query failure information may be a query failure reason, and/or a preset query failure code.

The application example of the present disclosure further includes determining whether the returned query data is the last packetized data of the last paged query statement:

If it is the last packetized data of the last paged query statement, the last packetized data insertion process is performed in the query window of the browse query data: optional,

For each piece of data of the extracted sub-package data, determine whether it is the query data of the page-by-page query statement. If it is the query data of the page-by-page query statement, the extracted data is inserted into the client access window for display until the packet data is paginated. When the last data of the query data of the query is queried, the data insertion is completed;

It should be noted that when the insertion process is performed, the insertion state is true; when the insertion is stopped, the insertion state is false, the query end is true, and the page query statement ends.

If it is not the last packet data of the last paged query statement, the interpolation process of the intermediate data is performed in the query window of the browse query data.

It should be noted that, when inserting the intermediate data, each piece of data of the extracted packet data may be inserted into the client access window one by one; when the data is inserted, the out-of-boundary insertion state is false; the application example of the present application queries the paged query statement. When the duration is timed, in the insertion process of the intermediate data, when the last piece of data completes the insertion of the client access port, the query duration of the paged query statement is cut off.

The application example method further includes: when detecting the page of the query window for browsing the query data, determining whether the number of the query windows of the currently remaining display query data reaches a preset triggering threshold;

This application example method also includes:

When the page turning is not detected or the operation of closing the query window is received, the execution of the page query statement is stopped.

The application examples of the disclosure also include:

Counting the display time of the previous preset number of query windows;

It should be noted that the preset number is set according to the actual usage, for example, two or three. The larger the query size, the larger the preset number.

Step 304: End the data query according to the query instruction end information; here, when the query is ended, the query size, the query duration timer, etc. will be cleared, disconnected or kept connected with the database, ended or retained, and the query thread is set according to the actual situation.

Embodiments of the present disclosure also provide a non-transitory computer readable storage medium storing computer executable instructions arranged to perform the method of any of the above embodiments.

The embodiment of the present disclosure further provides a schematic structural diagram of an electronic device. Referring to FIG. 4, the electronic device includes:

At least one processor 40, which is exemplified by a processor 40 in FIG. 4; and a memory 41, may further include a communication interface 42 and a bus 43. The processor 40, the communication interface 42, and the memory 41 can complete communication with each other through the bus 43. Communication interface 42 can be used for information transmission. Processor 40 may invoke logic instructions in memory 41 to perform the methods of the above-described embodiments.

In addition, the logic instructions in the memory 41 described above may be implemented in the form of a software functional unit and sold or used as a stand-alone product, and may be stored in a computer readable storage medium.

The memory 41 is used as a computer readable storage medium for storing software programs, computer executable programs, and program instructions/modules corresponding to the methods in the embodiments of the present disclosure. The processor 40 executes the function application and the data processing by executing the software program, the instruction and the module stored in the memory 41, that is, the method for implementing the data query in the above method embodiment.

The memory 41 may include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application required for at least one function; and the storage data area may be stored according to the use of the terminal device The data created, etc. Further, the memory 41 may include a high speed random access memory, and may also include a nonvolatile memory.

The technical solution of the embodiments of the present disclosure may be embodied in the form of a software product stored in a storage medium, including one or more instructions for causing a computer device (which may be a personal computer, a server, or a network) The device or the like) performs all or part of the steps of the method described in the embodiments of the present disclosure. The foregoing storage medium may be a non-transitory storage medium, including: a USB flash drive, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk, and the like. A medium that can store program code, or a transitory storage medium.

The embodiments disclosed in the present disclosure are as described above, but are merely used to facilitate the understanding of the present disclosure, and are not intended to limit the present disclosure. Any modification or variation in the form and details of the embodiments may be made by those skilled in the art without departing from the scope of the embodiments disclosed herein. The scope defined by the appended claims shall prevail.

Industrial applicability

The method and server for implementing data query provided by the present disclosure reduce the feedback amount of query data when performing large table data access, avoiding waste of network communication and server resources, and improving the user experience.

Claims

A method of implementing data query, comprising:

After receiving the query instruction, the server generates a page query statement according to the query instruction;

The server executes each generated page query statement and returns corresponding query data according to each page query statement.
The method of claim 1 wherein said generating a paged query statement comprises:

Generating the paged query statement according to the fixed query size according to the query instruction; or

After generating the first paging query according to the fixed query size, generating a subsequent paging query according to the query record of the preceding paging query;

The query size is a product of the number of query windows and the amount of data displayed by the query window;

The query record includes: the number of query windows, the query duration, the transmission duration of the query data, and the insertion duration of the query data when the page break query statement is executed in one-to-one correspondence with each page query statement.
The method of claim 2, wherein the generating the subsequent paged query statement according to the query record of the preceding paged query statement comprises:

Calculating a quotient of the query duration of a preceding page query statement divided by a preset response threshold as an ease factor;

If the ease factor is in the preset interval, the query size is not adjusted;

If the ease factor exceeds the preset interval, when the number of the query records is less than the preset value, the query size of the next post-page query statement is not adjusted, and the next subsequent page query statement is generated;

If the easiness factor exceeds the preset interval, when the number of the query records is greater than the preset value, the query size of the subsequent pagination query statement is adjusted according to the query record, and the next subsequent pagination query statement is generated according to the adjusted query size. .
The method according to claim 2 or 3, wherein said prior paging query The query duration is generated before the subsequent paged query statement. The method also includes:

The query timing is respectively performed on each of the paging query statements to obtain the query duration of the previous paging query statement.
The method according to any one of claims 1 to 3, further comprising:

When the query of the page query query fails, the query failure information is fed back;

The query failure information includes a query failure reason and/or a preset query failure code.
The method according to any one of claims 1 to 3, further comprising:

Determining whether the returned query data is the last packet data of the last page query statement;

If it is the last packet data of the last paged query statement, the last packet data insertion process is performed in the query window of the browse query data: if it is not the last packet data of the last page query statement, the query data is browsed. The query window performs the insertion processing of the intermediate data.
The method according to any one of claims 1 to 3, further comprising:

When the query window of the browse query data is detected, it is determined whether the number of query windows of the currently remaining display query data reaches a preset trigger threshold;

If the current number of query windows displaying the query data does not reach the preset trigger threshold, the display of the query data of the current page query query is continued; if the current number of query windows for displaying the query data reaches the preset trigger threshold , then execute the next post-page query statement.
The method according to any one of claims 1 to 3, further comprising:

When the query window is not detected or the operation of closing the query window is received, the execution of the paging query is stopped.
The method according to any one of claims 1 to 3, further comprising:

Counting the display time of the previous preset number of query windows;

Determining the display duration of the remaining query windows according to the average display duration of the query window;

When the display duration of the remaining query window reaches the preset trigger threshold, the subsequent paged query statement is executed.
A server for implementing data query, comprising: a generating unit and a return unit; wherein

The generating unit is configured to generate a paging query statement according to the query instruction after receiving the query instruction;

The return unit is configured to execute each generated page query statement and return corresponding query data according to each page query statement.
The server according to claim 10, wherein said generating unit is configured to

After receiving the query instruction,

Generating the paged query statement according to the fixed query size according to the query instruction; or

After generating the first paging query according to the fixed query size, generating a subsequent paging query according to the query record of the preceding paging query;

The query size is a product of the number of query windows and the amount of data displayed by the query window;

The query record includes: the number of query windows, the query duration, the transmission duration of the query data, and the insertion duration of the query data when the page break query statement is executed in one-to-one correspondence with each page query statement.
The server according to claim 10, wherein said generating unit is configured to

After receiving the query instruction,

Generating the paged query statement according to the fixed query size according to the query instruction; or

Calculating a quotient of the query duration of a preceding page query statement divided by a preset response threshold as an ease factor;

If the ease factor is in the preset interval, the query size is not adjusted;

If the ease factor exceeds the preset interval, when the number of the query records is less than the preset value, the query size of the next post-page query statement is not adjusted, and the next subsequent page query statement is generated;

If the ease factor exceeds the preset interval, when the number of query records is greater than the preset value, the query size of the next page query query is adjusted according to the query time, and the next subsequent page query statement is generated according to the adjusted query size. .
The server according to claim 11 or 12, further comprising a timing unit configured to generate the subsequent paging query statement according to the query duration of the preceding paging query statement,

The query timing is respectively performed on each of the paging query statements to obtain the query duration of the previous paging query statement.
The server according to any one of claims 10 to 12, further comprising a query feedback unit configured to feed back the query failure information when the page query query fails to be queried;

The query failure information includes a query failure reason and/or a preset query failure code.
The server according to any one of claims 10 to 12, further comprising a packet processing unit configured to determine whether the returned query data is the last packet data of the last page query statement;

If it is the last packet data of the last paged query statement, the last packet data insertion process is performed in the query window of the browse query data: if it is not the last packet data of the last page query statement, the query data is browsed. The query window performs the insertion processing of the intermediate data.
The server according to any one of claims 10 to 12, further comprising a page turning processing unit:

When the query window of the browse query data is detected, it is determined whether the number of query windows of the currently remaining display query data reaches a preset trigger threshold;

If the current number of query windows displaying the query data does not reach the preset trigger threshold, the display of the query data of the current page query query is continued; if the current number of query windows for displaying the query data reaches the preset trigger threshold , then execute the next post-page query statement.
A server according to any one of claims 10 to 12, further comprising a stop unit configured Stop paging execution query when the page is not detected by the query window or when the operation of closing the query window is received.
The server according to any one of claims 10 to 12, further comprising a triggering unit configured to count the display time of the previous preset number of query windows;

Determining the display duration of the remaining query windows according to the average display duration of the query window;

When the display duration of the remaining query window reaches the preset trigger threshold, the subsequent paged query statement is executed.
A non-transitory computer readable storage medium storing computer executable instructions arranged to perform the method of any of claims 1-9.