CN114020767A - Data query method and device and terminal equipment - Google Patents

Data query method and device and terminal equipment Download PDF

Info

Publication number
CN114020767A
CN114020767A CN202111107750.5A CN202111107750A CN114020767A CN 114020767 A CN114020767 A CN 114020767A CN 202111107750 A CN202111107750 A CN 202111107750A CN 114020767 A CN114020767 A CN 114020767A
Authority
CN
China
Prior art keywords
query
data
user
data query
database server
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202111107750.5A
Other languages
Chinese (zh)
Inventor
吴又奎
乔保保
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Zhongke Hengyun Co ltd
Original Assignee
Zhongke Hengyun Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Zhongke Hengyun Co ltd filed Critical Zhongke Hengyun Co ltd
Priority to CN202111107750.5A priority Critical patent/CN114020767A/en
Publication of CN114020767A publication Critical patent/CN114020767A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/242—Query formulation
    • G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/2453—Query optimisation
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/2455—Query execution
    • G06F16/24552—Database cache management
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/2455—Query execution
    • G06F16/24553—Query execution of query operations
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00—Arrangements for program control, e.g. control units
    • G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/46—Multiprogramming arrangements
    • G06F9/50—Allocation of resources, e.g. of the central processing unit [CPU]
    • G06F9/5005—Allocation of resources, e.g. of the central processing unit [CPU] to service a request
    • G06F9/5027—Allocation of resources, e.g. of the central processing unit [CPU] to service a request the resource being a machine, e.g. CPUs, Servers, Terminals
    • G06F9/505—Allocation of resources, e.g. of the central processing unit [CPU] to service a request the resource being a machine, e.g. CPUs, Servers, Terminals considering the load

Abstract

The invention provides a data query method, a device and a terminal device, and belongs to the technical field of data query, wherein the method comprises the following steps: receiving a load state of a database server, and updating a user query interface according to the load state; displaying the user query interface, and receiving a data query request input by a user based on the user query interface; judging whether source data corresponding to the data query request is in a preset cache unit or not based on the data query request; and if the source data corresponding to the data query request are in a preset cache unit, sending the source data stored in the preset cache unit to the user query interface for displaying. The data query method, the data query device and the terminal equipment can improve the data query efficiency in a large-batch data query scene.

Description

Data query method and device and terminal equipment
Technical Field
The invention belongs to the technical field of data query, and particularly relates to a data query method, a data query device and terminal equipment.
Background
With the continuous development of social science and technology, various data gradually enter the electronic storage era, so that a large amount of storage data is generated, and correspondingly, a large amount of data to be inquired is also generated. With the continuous expansion of the data application range, the data query demand is continuously increased, and on this basis, a database server storing a large amount of data will undoubtedly spend a large amount of time and cost when facing a large amount of data query requests, thereby reducing the query efficiency. Therefore, how to improve the data query efficiency in a large-batch data query scenario becomes an urgent problem to be solved by those skilled in the art.
Disclosure of Invention
The invention aims to provide a data query method, a data query device and terminal equipment, so as to improve the data query efficiency in a large-batch data query scene.
In a first aspect of the embodiments of the present invention, a data query method is provided, including:
receiving a load state of a database server, and updating a user query interface according to the load state;
displaying the user query interface, and receiving a data query request input by a user based on the user query interface;
judging whether source data corresponding to the data query request is in a preset cache unit or not based on the data query request; and if the source data corresponding to the data query request are in a preset cache unit, sending the source data stored in the preset cache unit to the user query interface for displaying.
In a possible implementation manner, the data query method further includes:
if the source data corresponding to the data query request are not in a preset cache unit, sending the data query request to a database server so that the database server returns the source data corresponding to the data query request;
and receiving source data corresponding to the data query request returned by the database server, and sending the source data to the user query interface for displaying.
In a possible implementation manner, the preset cache unit stores a data query log; after the source data are sent to the user query interface to be displayed, the data query method further comprises the following steps:
and updating the data query log according to the data query request, wherein the data query log is used for updating the cache content of a preset cache unit.
In a possible implementation manner, the data query method further includes:
detecting the updating state of the data query log according to a preset time interval;
and after detecting that the data query log is updated, updating the cache data of the preset cache unit according to the updated data query log.
In a possible implementation manner, the updating the cache data of the preset cache unit according to the updated data query log includes:
determining the query frequency of each item of source data according to the updated query log;
and updating the cache data of the preset cache unit according to the query frequency of each item of source data.
In one possible implementation, the user query interface includes a query condition and a filter condition for user input; the updating the user query interface according to the load state comprises:
and updating the query condition or the filter condition in the user query interface according to the load state.
In one possible implementation manner, the query condition includes a fill-necessary query condition and a fill-selected query condition, and the filter condition includes a fill-necessary filter condition and a fill-selected filter condition; the updating of the query condition or the filter condition in the user query interface according to the load status includes:
if the load state shows that the load rate of the database server rises, increasing the bound filling query condition in the user query interface according to the load rate rising amount of the database server, or increasing the bound filling filter condition in the user query interface according to the load rate rising amount of the database server;
if the load state shows that the load rate of the database server is reduced, reducing the indispensable query condition in the user query interface according to the reduction of the load rate of the database server, or reducing the indispensable filter condition in the user query interface according to the reduction of the load rate of the database server.
In a second aspect of the embodiments of the present invention, there is provided a data query apparatus, including:
the interface updating module is used for receiving the load state of the database server and updating the user query interface according to the load state;
the data acquisition module is used for displaying the user query interface and receiving a data query request input by a user based on the user query interface;
the data query module is used for judging whether source data corresponding to the data query request is in a preset cache unit or not based on the data query request; and if the source data corresponding to the data query request are in a preset cache unit, sending the source data stored in the preset cache unit to the user query interface for displaying.
In a third aspect of the embodiments of the present invention, a terminal device is provided, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, where the processor implements the steps of the data query method when executing the computer program.
In a fourth aspect of the embodiments of the present invention, a computer-readable storage medium is provided, where a computer program is stored, and the computer program, when executed by a processor, implements the steps of the data query method described above.
The data query method, the data query device and the terminal equipment have the advantages that:
different from the prior art, the method and the system update the query interface of the user through the load state of the database server, so that the input of the user can be controlled by controlling the query interface of the user, and the query efficiency of the user is improved by controlling the data query request of the user. On the basis, the invention also presets the cache unit, and can directly acquire data from the cache unit when the data query request is matched with the source data in the cache unit, thereby saving the time for requesting the database server and further improving the query efficiency. That is, through the two methods, even if the database server faces a large-batch data query scene, the query efficiency of the user can be ensured.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed for the embodiments or the prior art descriptions will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings without creative efforts.
Fig. 1 is a schematic flow chart of a data query method according to an embodiment of the present invention;
fig. 2 is a block diagram of a data query apparatus according to an embodiment of the present invention;
fig. 3 is a schematic block diagram of a terminal device according to an embodiment of the present invention.
Detailed Description
In the following description, for purposes of explanation and not limitation, specific details are set forth, such as particular system structures, techniques, etc. in order to provide a thorough understanding of the embodiments of the invention. It will be apparent, however, to one skilled in the art that the present invention may be practiced in other embodiments that depart from these specific details. In other instances, detailed descriptions of well-known systems, devices, circuits, and methods are omitted so as not to obscure the description of the present invention with unnecessary detail.
In order to make the objects, technical solutions and advantages of the present invention more apparent, the following description is made by way of specific embodiments with reference to the accompanying drawings.
Referring to fig. 1, fig. 1 is a schematic flow chart of a data query method according to an embodiment of the present invention, where the method includes:
s101: and receiving the load state of the database server, and updating the user query interface according to the load state.
In this embodiment, the load status of the database server includes, but is not limited to, a load rate of the database server, an estimated load corresponding to the query request received by the database server, and the like.
In this embodiment, the preset query interface of the user may be updated according to the load status of the database server, so as to control the input of the user according to the load status of the database server, so that the user inputs a query instruction more conveniently processed by the database server.
S102: and displaying a user query interface, and receiving a data query request input by a user based on the user query interface.
In this embodiment, the user query interface is used for a user to input a data query request, and to display a data query result for the user, that is, to display source data corresponding to the data query request input by the user to the user.
S103: and judging whether the source data corresponding to the data query request is in a preset cache unit or not based on the data query request. And if the source data corresponding to the data query request is in the preset cache unit, sending the source data stored in the preset cache unit to a user query interface for displaying.
In this embodiment, the preset cache unit is pre-loaded with data of the database server, and if the source data corresponding to the data query request is pre-stored in the cache unit, the source data in the cache unit may be directly returned to the user without accessing the database server.
From the above, it can be seen that, unlike the prior art, the embodiment of the present invention updates the query interface of the user through the load state of the database server, so that the input of the user can be controlled by controlling the query interface of the user, and the query efficiency of the user is improved by controlling the data query request of the user. On this basis, the embodiment of the present invention further presets a cache unit, and when the data query request matches the source data in the cache unit, the data can be directly obtained from the cache unit, so that the time for requesting the database server is saved, and the query efficiency is further improved. That is, through the two methods, even if the database server faces a large-batch data query scene, the query efficiency of the user can be ensured.
In a possible implementation manner, the data query method further includes:
and if the source data corresponding to the data query request is not in the preset cache unit, sending the data query request to the database server so that the database server returns the source data corresponding to the data query request.
And receiving source data corresponding to the data query request returned by the database server, and sending the source data to a user query interface for displaying.
In this embodiment, if the source data corresponding to the data query request is not in the preset cache unit, the data request needs to be sent to the database server, and in particular, in terms of implementation, the data query request may be forwarded to the database server through communication between a preset routing node and the database server, so that the database server returns the source data corresponding to the data query request.
In a possible implementation manner, the preset cache unit stores a data query log. After the source data are sent to the user query interface to be displayed, the data query method further comprises the following steps:
and updating the data query log according to the data query request, wherein the data query log is used for updating the cache content of the preset cache unit.
In this embodiment, different from the scheme of "adding source data corresponding to a data query request to a cache unit as long as the cache unit does not have the source data corresponding to the data query request" in the prior art, the data query log is arranged in the cache unit, and only the data query log is updated, so that the cache content in the preset cache unit is periodically updated through the data query log.
In a possible implementation manner, the data query method further includes:
and detecting the updating state of the data query log according to a preset time interval.
And after detecting that the data query log is updated, updating the cache data of the preset cache unit according to the updated data query log.
In this embodiment, the preset cache unit also requests data from the database server periodically at certain time intervals to update the same source data (to provide the latest data to the user).
In a possible implementation manner, updating the cache data of the preset cache unit according to the updated data query log includes:
and determining the query frequency of each item of source data according to the updated query log.
And updating the cache data of the preset cache unit according to the query frequency of each item of source data.
In this embodiment, the source data with the query frequency greater than the preset frequency may be directly preloaded into the preset cache unit, or N source data with the highest query frequency in the current time period may be selected according to the current time period and the change relationship between the query frequency of each source data and time, and preloaded into the preset cache unit, where N is an integer.
In one possible implementation, the user query interface contains query terms and filter terms for user input. Updating the user query interface according to the load status, comprising:
and updating the query condition or the filter condition in the user query interface according to the load state.
In this embodiment, the input of the user can be influenced by adjusting the query condition or the filter condition displayed on the user query interface, so that the user can input a data query request which is more convenient for the database server to query, and the data query efficiency is further improved.
In one possible implementation, the query condition includes a fill-necessary query condition and a fill-selected query condition, and the filter condition includes a fill-necessary filter condition and a fill-selected filter condition. Updating the query condition or the filter condition in the user query interface according to the load state, comprising:
and if the load state shows that the load rate of the database server rises, increasing the bound filling query condition in the user query interface according to the load rate rising amount of the database server, or increasing the bound filling filter condition in the user query interface according to the load rate rising amount of the database server.
And if the load state shows that the load rate of the database server is reduced, reducing the indispensable query condition in the user query interface according to the reduction of the load rate of the database server, or reducing the indispensable filter condition in the user query interface according to the reduction of the load rate of the database server.
In this embodiment, adding the fill-necessary query condition in the user query interface may be expressed in terms of specific operations as follows: updating the filling query condition into a filling query condition; accordingly, reducing the fill-necessary query conditions in the user query interface may be expressed in terms of specific operations as: the filling-necessary query condition is updated to the filling-selection query condition, and the filtering conditions are similar, which will not be described herein again.
That is, when the load rate of the database server becomes high, the user can input more query conditions or filter conditions by adjusting the necessary items in the user query interface, so as to improve the data query efficiency. As the load rate of the database server becomes lower, it may be more human-based, allowing the user to enter fewer query terms or filter terms.
Fig. 2 is a block diagram of a data query apparatus according to an embodiment of the present invention, which corresponds to the data query method according to the above embodiment. For convenience of explanation, only portions related to the embodiments of the present invention are shown. Referring to fig. 2, the data query apparatus 20 includes: the system comprises an interface updating module 21, a data acquisition module 22 and a data query module 23.
The interface updating module 21 is configured to receive a load state of the database server, and update the user query interface according to the load state.
And the data acquisition module 22 is configured to display a user query interface, and receive a data query request input by a user based on the user query interface.
The data query module 23 is configured to determine, based on the data query request, whether source data corresponding to the data query request is in a preset cache unit. And if the source data corresponding to the data query request is in the preset cache unit, sending the source data stored in the preset cache unit to a user query interface for displaying.
In one possible implementation, the data query module 23 is further configured to:
and when the source data corresponding to the data query request is not in the preset cache unit, sending the data query request to the database server so that the database server returns the source data corresponding to the data query request.
And receiving source data corresponding to the data query request returned by the database server, and sending the source data to a user query interface for displaying.
In a possible implementation manner, the preset cache unit stores a data query log. After sending the source data to the user query interface for display, the data query apparatus further includes:
and a log updating module 24, configured to update a data query log according to the data query request, where the data query log is used to update the cache content of the preset cache unit.
In a possible implementation manner, the log update module 24 is specifically configured to:
and detecting the updating state of the data query log according to a preset time interval.
And after detecting that the data query log is updated, updating the cache data of the preset cache unit according to the updated data query log.
In a possible implementation manner, the log update module 24 is specifically configured to:
and determining the query frequency of each item of source data according to the updated query log.
And updating the cache data of the preset cache unit according to the query frequency of each item of source data.
In one possible implementation, the user query interface contains query terms and filter terms for user input. The interface update module 21 is specifically configured to:
and updating the query condition or the filter condition in the user query interface according to the load state.
In one possible implementation, the query condition includes a fill-necessary query condition and a fill-selected query condition, and the filter condition includes a fill-necessary filter condition and a fill-selected filter condition. The interface update module 21 is specifically configured to:
and when the load state shows that the load rate of the database server rises, increasing the bound filling query condition in the user query interface according to the load rate rising amount of the database server, or increasing the bound filling filter condition in the user query interface according to the load rate rising amount of the database server.
And when the load state shows that the load rate of the database server is reduced, reducing the indispensable query condition in the user query interface according to the reduction of the load rate of the database server, or reducing the indispensable filter condition in the user query interface according to the reduction of the load rate of the database server.
Referring to fig. 3, fig. 3 is a schematic block diagram of a terminal device according to an embodiment of the present invention. The terminal 300 in the present embodiment as shown in fig. 3 may include: one or more processors 301, one or more input devices 302, one or more output devices 303, and one or more memories 304. The processor 301, the input device 302, the output device 303, and the memory 304 are in communication with each other via a communication bus 305. The memory 304 is used to store a computer program comprising program instructions. Processor 301 is operative to execute program instructions stored in memory 304. Wherein the processor 301 is configured to call program instructions to perform the following functions for operating the modules/units in the above-described device embodiments, such as the functions of the modules 21 to 24 shown in fig. 2.
It should be understood that, in the embodiment of the present invention, the Processor 301 may be a Central Processing Unit (CPU), and the Processor may also be other general-purpose processors, Digital Signal Processors (DSPs), Application Specific Integrated Circuits (ASICs), Field Programmable Gate Arrays (FPGAs) or other Programmable logic devices, discrete Gate or transistor logic devices, discrete hardware components, and the like. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
The input device 302 may include a touch pad, a fingerprint sensor (for collecting fingerprint information of a user and direction information of the fingerprint), a microphone, etc., and the output device 303 may include a display (LCD, etc.), a speaker, etc.
The memory 304 may include a read-only memory and a random access memory, and provides instructions and data to the processor 301. A portion of the memory 304 may also include non-volatile random access memory. For example, the memory 304 may also store device type information.
In a specific implementation, the processor 301, the input device 302, and the output device 303 described in this embodiment of the present invention may execute the implementation manners described in the first embodiment and the second embodiment of the data query method provided in this embodiment of the present invention, and may also execute the implementation manner of the terminal described in this embodiment of the present invention, which is not described herein again.
In another embodiment of the present invention, a computer-readable storage medium is provided, in which a computer program is stored, where the computer program includes program instructions, and the program instructions, when executed by a processor, implement all or part of the processes in the method of the above embodiments, and may also be implemented by a computer program instructing associated hardware, and the computer program may be stored in a computer-readable storage medium, and the computer program, when executed by a processor, may implement the steps of the above methods embodiments. Wherein the computer program comprises computer program code, which may be in the form of source code, object code, an executable file or some intermediate form, etc. The computer readable medium may include: any entity or device capable of carrying computer program code, recording medium, U.S. disk, removable hard disk, magnetic disk, optical disk, computer Memory, Read-Only Memory (ROM), Random Access Memory (RAM), electrical carrier wave signals, telecommunications signals, software distribution media, and the like. It should be noted that the computer readable medium may include any suitable increase or decrease as required by legislation and patent practice in the jurisdiction, for example, in some jurisdictions, computer readable media may not include electrical carrier signals and telecommunications signals in accordance with legislation and patent practice.
The computer readable storage medium may be an internal storage unit of the terminal of any of the foregoing embodiments, for example, a hard disk or a memory of the terminal. The computer readable storage medium may also be an external storage device of the terminal, such as a plug-in hard disk provided on the terminal, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), and the like. Further, the computer-readable storage medium may also include both an internal storage unit and an external storage device of the terminal. The computer-readable storage medium is used for storing a computer program and other programs and data required by the terminal. The computer-readable storage medium may also be used to temporarily store data that has been output or is to be output.
Those of ordinary skill in the art will appreciate that the elements and algorithm steps of the examples described in connection with the embodiments disclosed herein may be embodied in electronic hardware, computer software, or combinations of both, and that the components and steps of the examples have been described in a functional general in the foregoing description for the purpose of illustrating clearly the interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.
It can be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working processes of the terminal and the unit described above may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the several embodiments provided in the present application, it should be understood that the disclosed terminal and method can be implemented in other manners. For example, the above-described apparatus embodiments are merely illustrative, and for example, a division of a unit is merely a logical division, and an actual implementation may have another division, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces or units, and may also be an electrical, mechanical or other form of connection.
Units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment of the present invention.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
While the invention has been described with reference to specific embodiments, it will be understood by those skilled in the art that various changes in form and details may be made therein without departing from the spirit and scope of the invention as defined by the appended claims. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.

Claims (10)

1. A method for querying data, comprising:
receiving a load state of a database server, and updating a user query interface according to the load state;
displaying the user query interface, and receiving a data query request input by a user based on the user query interface;
judging whether source data corresponding to the data query request is in a preset cache unit or not based on the data query request; and if the source data corresponding to the data query request are in a preset cache unit, sending the source data stored in the preset cache unit to the user query interface for displaying.
2. The data query method of claim 1, wherein the data query method further comprises:
if the source data corresponding to the data query request are not in a preset cache unit, sending the data query request to a database server so that the database server returns the source data corresponding to the data query request;
and receiving source data corresponding to the data query request returned by the database server, and sending the source data to the user query interface for displaying.
3. The data query method according to any one of claims 1 to 2, wherein the preset cache unit stores a data query log; after the source data are sent to the user query interface to be displayed, the data query method further comprises the following steps:
and updating the data query log according to the data query request, wherein the data query log is used for updating the cache content of a preset cache unit.
4. The data query method of claim 3, wherein the data query method further comprises:
detecting the updating state of the data query log according to a preset time interval;
and after detecting that the data query log is updated, updating the cache data of the preset cache unit according to the updated data query log.
5. The data query method of claim 4, wherein the updating the cache data of the preset cache unit according to the updated data query log comprises:
determining the query frequency of each item of source data according to the updated query log;
and updating the cache data of the preset cache unit according to the query frequency of each item of source data.
6. The data query method of claim 1, wherein the user query interface contains query conditions and filter conditions for user input; the updating the user query interface according to the load state comprises:
and updating the query condition or the filter condition in the user query interface according to the load state.
7. The data query method of claim 6, wherein the query condition comprises a must-fill query condition and a choose-fill query condition, and the filter condition comprises a must-fill filter condition and a choose-fill filter condition; the updating of the query condition or the filter condition in the user query interface according to the load status includes:
if the load state shows that the load rate of the database server rises, increasing the bound filling query condition in the user query interface according to the load rate rising amount of the database server, or increasing the bound filling filter condition in the user query interface according to the load rate rising amount of the database server;
if the load state shows that the load rate of the database server is reduced, reducing the indispensable query condition in the user query interface according to the reduction of the load rate of the database server, or reducing the indispensable filter condition in the user query interface according to the reduction of the load rate of the database server.
8. A data query apparatus, comprising:
the interface updating module is used for receiving the load state of the database server and updating the user query interface according to the load state;
the data acquisition module is used for displaying the user query interface and receiving a data query request input by a user based on the user query interface;
the data query module is used for judging whether source data corresponding to the data query request is in a preset cache unit or not based on the data query request; and if the source data corresponding to the data query request are in a preset cache unit, sending the source data stored in the preset cache unit to the user query interface for displaying.
9. A terminal device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that the processor implements the steps of the method according to any of claims 1 to 7 when executing the computer program.
10. A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, carries out the steps of the method according to any one of claims 1 to 7.
CN202111107750.5A 2021-09-22 2021-09-22 Data query method and device and terminal equipment Pending CN114020767A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202111107750.5A CN114020767A (en) 2021-09-22 2021-09-22 Data query method and device and terminal equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202111107750.5A CN114020767A (en) 2021-09-22 2021-09-22 Data query method and device and terminal equipment

Publications (1)

Publication Number Publication Date
CN114020767A true CN114020767A (en) 2022-02-08

Family

ID=80054465

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202111107750.5A Pending CN114020767A (en) 2021-09-22 2021-09-22 Data query method and device and terminal equipment

Country Status (1)

Country Link
CN (1) CN114020767A (en)

Similar Documents

Publication Publication Date Title
CN109313642B (en) Bill information caching method, bill information query method and terminal equipment
CN109766362B (en) Data processing method and device
CN113886336A (en) Flow detection method, device, equipment and medium
CN109656592B (en) Card management method, device, terminal and computer readable storage medium
CN111984047B (en) Multi-module system current sharing control method and device and terminal equipment
CN113489653A (en) Message sending method and device and computer equipment
CN111694703A (en) Cache region management method and device and computer equipment
CN114020766A (en) Data query method and device and terminal equipment
CN108536773A (en) A kind of auto alarm information integrating method, device, equipment and medium
CN114020767A (en) Data query method and device and terminal equipment
CN112799763A (en) Function management method, management device, terminal equipment and readable storage medium
CN111400091A (en) Factory setting restoring method, factory setting restoring device and mobile terminal
CN108762856B (en) Method for adjusting display mode of intelligent watch function, intelligent watch and terminal
CN113873003B (en) Data transmission control method and system between storage end and communication end in Internet of things
CN111352868B (en) Serial port access method, device, terminal equipment and storage medium
CN108896068B (en) Step counting method, server, mobile terminal and storage medium
CN106462845B (en) Configuration method of non-contact front end and terminal
CN113542022A (en) Networking management method and device of networking system, terminal equipment and storage medium
CN113708938B (en) Token obtaining method, token obtaining device and terminal equipment
CN114303131A (en) File processing method, file processing device and terminal equipment
CN111309559A (en) Alarm linkage method and device and terminal equipment
CN113055876B (en) Method and device for downloading standby cloud card and terminal equipment
CN110858201A (en) Data processing method and system, processor and storage medium
CN114385583A (en) Data migration method and device for marital registration system and terminal equipment
CN117743206B (en) Data storage method and device

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination