CN111143416A - Data cache-based query method, terminal and storage medium - Google Patents
Data cache-based query method, terminal and storage medium Download PDFInfo
- Publication number
- CN111143416A CN111143416A CN201911370778.0A CN201911370778A CN111143416A CN 111143416 A CN111143416 A CN 111143416A CN 201911370778 A CN201911370778 A CN 201911370778A CN 111143416 A CN111143416 A CN 111143416A
- Authority
- CN
- China
- Prior art keywords
- query
- result set
- query result
- cache
- terminal
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 43
- 238000012163 sequencing technique Methods 0.000 claims description 6
- 238000004891 communication Methods 0.000 description 6
- 238000010586 diagram Methods 0.000 description 2
- 230000001174 ascending effect Effects 0.000 description 1
- 238000004883 computer application Methods 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 238000003745 diagnosis Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
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/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/248—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a query method based on data cache, which comprises the following steps: when receiving a query request sent by a query terminal, acquiring characteristic parameters of the query request; judging whether a query result set associated with the characteristic parameters is stored in a cache database; when a query result set associated with the characteristic parameters exists, returning the query result set to the query terminal; when the query result set associated with the characteristic parameters does not exist, calling a preset query tool to query in a preset database according to the characteristic parameters to obtain the query result set; returning the query result set to the query terminal; and caching the query result set obtained by query to the cache database, and associating the query result set with the characteristic parameters. The invention also discloses a terminal and a computer readable storage medium.
Description
Technical Field
The present invention relates to the field of computer applications. And more particularly, to a data cache-based query method, a terminal, and a computer-readable storage medium.
Background
A data warehouse is a theme-oriented, integrated, relatively stable data collection that reflects historical changes used to support administrative decisions. For external query of a large amount of data of the current data warehouse, a presto distributed query tool can be used for query through a hive-based external query mode. The distributed query is based on the memory, and the query speed is high. However, the existing distributed query is a direct query of the data warehouse, which results in a large amount of data or a complex query service.
The above is only for the purpose of assisting understanding of the technical aspects of the present invention, and does not represent an admission that the above is prior art.
Disclosure of Invention
The invention mainly aims to provide a query method based on data caching, a terminal and a computer readable storage medium, and aims to solve the technical problem that complex service time is consumed when the query is large in data volume.
In order to achieve the above object, the present invention provides a data cache-based query method, which includes the following steps:
when receiving a query request sent by a query terminal, acquiring characteristic parameters of the query request;
judging whether a query result set associated with the characteristic parameters is stored in a cache database;
when a query result set associated with the characteristic parameters exists, returning the query result set to the query terminal;
when the query result set associated with the characteristic parameters does not exist, calling a preset query tool to query in a preset database according to the characteristic parameters to obtain the query result set;
returning the query result set to the query terminal;
and caching the query result set obtained by query to the cache database, and associating the query result set with the characteristic parameters.
Optionally, after the step of caching the query result set obtained by the query in the cache database and associating the query result set with the feature parameter, the data cache-based query method further includes:
obtaining the cache duration of the query result set in the cache database;
and deleting the query result set with the cache duration reaching the preset duration when the cache duration reaches the preset duration.
Optionally, while associating the query result set with the feature parameters, performing the steps of:
and associating the storage time point of the query result set with the query result set, wherein the cache duration of the query result set is obtained according to the storage time point.
Optionally, the step of returning the query result set to the query terminal includes:
obtaining paging parameters;
dividing the query result set into at least one query result subset according to the paging parameters;
and returning the query result subsets to the query terminal for the query terminal to display according to the query result subsets, wherein each query result subset is displayed on one page.
Optionally, the paging the query result set according to the paging parameter includes:
sorting the query results in the query result set;
and dividing the sorted query results into at least one query result subset according to the paging parameters, wherein the paging parameters comprise the number of the query results.
Optionally, the step of calling a preset query tool to perform query in a preset database according to the characteristic parameters to obtain the query result set includes:
calling a preset query tool to query in a preset database according to the characteristic parameters to obtain a query result;
sequencing the query results;
and generating the query result set according to the sorted query results.
Optionally, the step of ranking the query results includes:
obtaining the matching degree of each query result and the characteristic parameters;
and sequencing the query results according to the matching degree.
In order to achieve the above object, the present invention further provides a terminal device, where the terminal device includes a memory, a processor, and a data cache-based query program stored on the memory and executable on the processor, and when the data cache-based query program of the terminal device is executed by the processor, the steps of the data cache-based query method of the terminal device are implemented.
In addition, the present invention also provides a computer readable storage medium, where the computer readable storage medium stores a data cache-based query program of a terminal device, and when the data cache-based query program of the terminal device is executed by a processor, the steps of the data cache-based query method of the terminal device are implemented as described above.
The embodiment of the invention provides a query method, a terminal and a computer readable storage medium based on data cache, wherein the method comprises the following steps: when receiving a query request sent by a query terminal, acquiring characteristic parameters of the query request; judging whether a query result set associated with the characteristic parameters is stored in a cache database; when a query result set associated with the characteristic parameters exists, returning the query result set to the query terminal; when the query result set associated with the characteristic parameters does not exist, calling a preset query tool to query in a preset database according to the characteristic parameters to obtain the query result set; returning the query result set to the query terminal; and caching the query result set obtained by query to the cache database, and associating the query result set with the characteristic parameters. When the characteristic parameters are acquired, whether the corresponding query result set is stored in the cache database or not is firstly queried, if the corresponding query result set is stored, the query result set is directly returned to the query terminal, if the corresponding query result set is not stored, the preset query database is called to query the preset database, the queried query result set is returned to the query terminal, and the query result set is stored in the cache database, so that the query result set can be quickly returned when the same content is queried within the validity period next time, and the query speed and the operation efficiency are improved.
Drawings
Fig. 1 is a schematic terminal structure diagram of a hardware operating environment according to an embodiment of the present invention;
FIG. 2 is a schematic flow chart of a first embodiment of a data cache-based query method according to the present invention;
FIG. 3 is a flowchart illustrating a second embodiment of a data cache-based query method according to the present invention;
FIG. 4 is a flowchart illustrating a third embodiment of a data cache-based query method according to the present invention;
FIG. 5 is a schematic flow chart of a fourth embodiment of a data cache-based query method according to the present invention;
fig. 6 is a schematic flowchart of a fifth embodiment of a query method based on data caching according to the present invention.
The implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
The main solution of the embodiment of the invention is as follows: when receiving a query request sent by a query terminal, acquiring characteristic parameters of the query request; judging whether a query result set associated with the characteristic parameters is stored in a cache database; when a query result set associated with the characteristic parameters exists, returning the query result set to the query terminal; when the query result set associated with the characteristic parameters does not exist, calling a preset query tool to query in a preset database according to the characteristic parameters to obtain the query result set; returning the query result set to the query terminal; and caching the query result set obtained by query to the cache database, and associating the query result set with the characteristic parameters.
As shown in fig. 1, fig. 1 is a schematic terminal structure diagram of a hardware operating environment according to an embodiment of the present invention.
The terminal of the embodiment of the invention can be a PC, and can also be terminal equipment of a smart phone, a tablet computer, a portable computer and the like.
As shown in fig. 1, the terminal may include: a processor 1001, such as a CPU, a network interface 1004, a user interface 1003, a memory 1005, a communication bus 1002. Wherein a communication bus 1002 is used to enable connective communication between these components. The user interface 1003 may include a Display screen (Display), an input unit such as a Keyboard (Keyboard), and the optional user interface 1003 may also include a standard wired interface, a wireless interface. The network interface 1004 may optionally include a standard wired interface, a wireless interface (e.g., WI-FI interface). The memory 1005 may be a high-speed RAM memory or a non-volatile memory (e.g., a magnetic disk memory). The memory 1005 may alternatively be a storage device separate from the processor 1001.
Those skilled in the art will appreciate that the terminal architecture shown in fig. 1 does not constitute a limitation of data cache-based query terminals and may include more or fewer components than shown, or some components in combination, or a different arrangement of components.
Referring to fig. 1, a memory 1005, which is a computer storage medium, may include an operating system, a network communication module, a user interface module, and a data cache-based query program.
In the terminal shown in fig. 1, the network interface 1004 is mainly used for connecting to a backend server and performing data communication with the backend server; the user interface 1003 is mainly used for connecting a client (user side) and performing data communication with the client; and the processor 1001 may be configured to call a data cache-based query program stored in the memory 1005 and perform the following operations:
when receiving a query request sent by a query terminal, acquiring characteristic parameters of the query request;
judging whether a query result set associated with the characteristic parameters is stored in a cache database;
when a query result set associated with the characteristic parameters exists, returning the query result set to the query terminal;
when the query result set associated with the characteristic parameters does not exist, calling a preset query tool to query in a preset database according to the characteristic parameters to obtain the query result set;
returning the query result set to the query terminal;
and caching the query result set obtained by query to the cache database, and associating the query result set with the characteristic parameters.
Further, the processor 1001 may call a data cache-based query program stored in the memory 1005, and further perform the following operations:
obtaining the cache duration of the query result set in the cache database;
and deleting the query result set with the cache duration reaching the preset duration when the cache duration reaches the preset duration.
Further, the processor 1001 may call a data cache-based query program stored in the memory 1005, and further perform the following operations:
and associating the storage time point of the query result set with the query result set, wherein the cache duration of the query result set is obtained according to the storage time point.
Further, the processor 1001 may call a data cache-based query program stored in the memory 1005, and further perform the following operations:
obtaining paging parameters;
dividing the query result set into at least one query result subset according to the paging parameters;
and returning the query result subsets to the query terminal for the query terminal to display according to the query result subsets, wherein each query result subset is displayed on one page.
Further, the processor 1001 may call a data cache-based query program stored in the memory 1005, and further perform the following operations:
sorting the query results in the query result set;
and dividing the sorted query results into at least one query result subset according to the paging parameters, wherein the paging parameters comprise the number of the query results.
Further, the processor 1001 may call a data cache-based query program stored in the memory 1005, and further perform the following operations:
calling a preset query tool to query in a preset database according to the characteristic parameters to obtain a query result;
sequencing the query results;
and generating the query result set according to the sorted query results.
Further, the processor 1001 may call a data cache-based query program stored in the memory 1005, and further perform the following operations:
obtaining the matching degree of each query result and the characteristic parameters;
and sequencing the query results according to the matching degree.
Referring to fig. 2, the present invention provides a first embodiment of a data cache-based query method, which includes the following steps:
step S10, when receiving a query request sent by a query terminal, obtaining characteristic parameters of the query request;
step S20, judging whether the cache database stores the query result set associated with the characteristic parameters;
step S30, when there is no query result set associated with the characteristic parameter, a preset query tool is called to query in a preset database according to the characteristic parameter to obtain the query result set, and the query result set is returned to the query terminal;
step S40, when there is a query result set associated with the characteristic parameter, returning the query result set to the query terminal;
step S50, cache the query result set obtained by the query to the cache database, and associate the query result set with the feature parameter.
The execution terminal of this embodiment may be a mobile terminal, a computer, a tablet computer, or a data warehouse query terminal device, and the like, and the execution terminal of this embodiment can perform data warehouse query through presto and can cache a query result. In the following, an execution terminal is taken as a data warehouse query terminal device for example.
The data warehouse query terminal device of the embodiment is provided with a query program based on data cache, the cache is queried preferentially in query, if the query result does not exist in the cache, the queried result is cached by using presto as a query engine, and result set paging is realized in the query cache, so that query result paging and quick query of complex conditions are realized.
The received query request can be obtained by a user by using a query terminal to send query parameters or a query instruction to a data warehouse query terminal device, the characteristic parameters of the query request comprise a query sql statement and a hash value corresponding to the query sql statement, and the characteristic parameters are obtained by analyzing the query parameters or the query instruction. Optionally, the query parameter or the query instruction may include a plurality of query sql statements, and the query parameter or the query instruction is analyzed to obtain the plurality of query sql statements included in the query sql statements and hash values corresponding to the plurality of query sql statements.
The cache database stores a query result set, the query result set corresponds to a unique characteristic parameter, and specifically, the characteristic parameter refers to a hash value corresponding to a query sql statement. The query result set stored in the cache database is a history record of the query terminal for the data warehouse, that is, the query result set queried by the query terminal before is stored in the cache database, and when the query terminal sends the same special diagnosis parameter again, the cache database of the mobile terminal stores the query result set corresponding to the characteristic parameter, so that the query is not required to be sent to the data warehouse again, and the quick query is realized. Therefore, after the characteristic parameters are obtained, whether the query result set associated with the characteristic parameters is stored in the cache database is judged.
It can be understood that, when the feature parameter sent by the query terminal has an associated query result set, the data warehouse query terminal device returns the associated query result set to the query terminal from the cache database. And when the characteristic parameters sent by the query terminal do not have the associated query result set, querying in a preset database by using a preset query tool according to the characteristic parameters to obtain the query result set. Specifically, the preset query tool is a presto query mode, the preset database is a data warehouse, and a query result set corresponding to the characteristic parameters in the preset database is queried through presto. And finally, returning the inquired inquiry result set to the inquiry terminal.
It can be understood that the query result set queried by the query terminal each time is stored in the cache database, and therefore, after the query result set corresponding to the characteristic parameter is obtained, the query result set obtained by querying is cached in the cache database, and the query result set is associated with the characteristic parameter. Specifically, the query result set is associated with the corresponding hash value, and whether the corresponding query result set exists in the cache database can be queried by querying the hash value.
Optionally, while associating the query result set with the feature parameter, associating a storage time point of the query result set with the query result set, where the storage time point of the query result set is a date and time of the query. It can be understood that, when the query result set of the cache database is used, the timeliness of the stored query result set can be judged according to the storage time point, so that the stored query result set data is prevented from being not up-to-date.
In this embodiment, when receiving a query request sent by a query terminal, a data warehouse query terminal device first obtains a feature parameter of the query request, determines whether a query result set associated with the feature parameter is stored in a cache database, if the query result set associated with the feature parameter exists, returns the query result set to the query terminal, and if the query result set associated with the feature parameter does not exist, invokes a preset query tool to query in a preset database according to the feature parameter to obtain the query result set, returns the query result set to the query terminal, and finally caches the query result set obtained by the query in the cache database and associates the query result set with the feature parameter. The query result set which is whether the characteristic parameters are related is firstly queried and stored in the cache database, and then the query is carried out in the preset database, so that the quick query of the data warehouse and the cache of the query result set are realized, and the query speed is improved.
Further, referring to fig. 3, the present invention provides a second embodiment of a query method based on a data cache, where based on the embodiment shown in fig. 2, after the step of caching the query result set obtained by the query in the cache database and associating the query result set with the feature parameter, the query method based on the data cache further includes:
step S60, obtaining the cache duration of the query result set in the cache database;
and step S70, deleting the query result set with the cache duration reaching the preset duration when the cache duration reaches the preset duration.
And when caching the query result set obtained by query to the cache database, caching the cache time of the query result set together, wherein the cache time length is the time length when the query result set is stored in the cache database. It is understood that the caching duration of the query result set may be obtained according to the caching time and the current query time, for example: and obtaining the cache time of the query result set, and subtracting the cache time from the current query time to obtain the cache duration of the query result set.
It can be understood that, when the caching duration reaches the preset duration, it indicates that the stored query result set is out of date, and the stored query result set is deleted. Optionally, the new query result set is updated to the cache database and the feature parameters are re-associated.
In this embodiment, the cache duration of the query result set in the cache database is first obtained, and when the cache duration reaches the preset duration, the query result set whose cache duration reaches the preset duration is deleted, so that the query result set can be updated in time, and the timeliness of the query result set is improved.
Further, referring to fig. 4, the present invention provides a third embodiment of a query method based on a data cache, and based on the embodiment shown in fig. 2, the step of returning the query result set to the query terminal includes:
step S41, obtaining paging parameters;
step S42, dividing the query result set into at least one query result subset according to the paging parameters;
step S43, returning the query result subset to the query terminal, so that the query terminal displays the query result subset according to the query result subset.
When the query result set is returned to the query terminal, a paging parameter is obtained first, where the paging parameter may be the number of results per page, and it can be understood that the query result set may be divided into at least one page of result subsets according to the number of results per page, for example: pagination records 10 query results, then if there are 97 query result sets, the query result set is divided into 10 query result subsets, each result subset storing up to 10 query results.
After the query result set is divided into at least one query result subset, returning the query result subset to the query terminal, and displaying according to the query result subset, it can be understood that each query result subset is displayed on one page.
In this embodiment, when the query result set is returned to the query terminal, the paging parameters are obtained first, the query result set is divided into at least one query result subset according to the paging parameters, and finally the query result subset is returned to the query terminal so that the query terminal can display the query result subset according to the query result subset, so that the operation of paging the query result set in a cache is realized, and the operation is simple, convenient and quick.
Further, referring to fig. 5, the present invention provides a fourth embodiment of a query method based on a data cache, and based on the embodiment shown in fig. 4, the paging the query result set according to the paging parameter includes:
step S421, sorting the query results in the query result set;
step S422, the sorted query results are divided into at least one query result subset according to the paging parameters, where the paging parameters include the number of the query results.
When obtaining the paging parameter and paging the query result set according to the paging parameter, the query results in the query result set may be sorted first, where the sorting may be performed in an ascending order or a descending order according to the correlation with the characteristic parameter, or according to the occurrence time of the query results, and the like.
It is to be understood that after sorting the query result set, the sorted query result set is divided into at least one subset according to the paging parameter, i.e. the number of pieces that can store the most query results per page.
In this embodiment, when the query result set is paged according to the paging parameter, the query results in the query result set are sorted first, and then the sorted query results are divided into at least one query result subset according to the paging parameter, where the paging parameter includes the number of the query results, so as to realize sorting of the query results.
Further, referring to fig. 6, the fifth embodiment of the query method based on the data cache according to the present invention provides that, based on the embodiment shown in fig. 2, the step of invoking a preset query tool to perform a query in a preset database according to the feature parameter to obtain the query result set includes:
step S30, calling a preset query tool to query in a preset database according to the characteristic parameters to obtain a query result;
step S31, obtaining the matching degree of each query result and the characteristic parameters;
step S32, sorting the query results according to the matching degree;
and step S33, generating the query result set according to the sorted query results.
Optionally, after the query result set is obtained, a matching degree between each query result and the feature parameter is obtained, where the matching degree is a correlation between the query result and the feature parameter, that is, a matching degree is high when a correlation between the query result and the feature parameter is high.
It can be understood that, after the matching degree is obtained, the query results are ranked from high to low or from low to high according to the matching degree, and the ranked query results are generated into the query result set.
In this embodiment, after a preset query tool is called to perform query in a preset database according to the characteristic parameters to obtain query results, the matching degrees of the query results and the characteristic parameters are obtained, the query results are sorted according to the matching degrees, and the query result set is generated according to the sorted query results, so that after the query results are obtained, the query results are sorted according to the matching degrees and the query result set is generated.
The invention also provides a terminal, the terminal device comprises a memory, a processor and a query program based on data cache, the query program is stored on the memory and can be operated on the processor, and the query program based on data cache of the terminal device realizes the steps of the query method based on data cache of the terminal device when being executed by the processor.
In addition, an embodiment of the present invention further provides a computer-readable storage medium, where a data cache-based query program of a terminal device is stored on the computer-readable storage medium, and when executed by a processor, the data cache-based query program of the terminal device implements the steps of the data cache-based query method of the terminal device as described above.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or system that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or system. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or system that comprises the element.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium (e.g., ROM/RAM, magnetic disk, optical disk) as described above and includes instructions for enabling a terminal device (e.g., a mobile phone, a computer, a server, or a network device) to execute the method according to the embodiments of the present invention.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (9)
1. A query method based on data cache is characterized by comprising the following steps:
when receiving a query request sent by a query terminal, acquiring characteristic parameters of the query request;
judging whether a query result set associated with the characteristic parameters is stored in a cache database;
when a query result set associated with the characteristic parameters exists, returning the query result set to the query terminal;
when the query result set associated with the characteristic parameters does not exist, calling a preset query tool to query in a preset database according to the characteristic parameters to obtain the query result set;
returning the query result set to the query terminal;
and caching the query result set obtained by query to the cache database, and associating the query result set with the characteristic parameters.
2. The data cache-based query method of claim 1, wherein after the step of caching the query result set obtained by the query in the cache database and associating the query result set with the feature parameter, the data cache-based query method further comprises:
obtaining the cache duration of the query result set in the cache database;
and deleting the query result set with the cache duration reaching the preset duration when the cache duration reaches the preset duration.
3. The data cache-based query method of claim 2, wherein the step of associating the query result set with the feature parameters is performed:
and associating the storage time point of the query result set with the query result set, wherein the cache duration of the query result set is obtained according to the storage time point.
4. The data cache-based query method of claim 1, wherein the step of returning the query result set to the query terminal comprises:
obtaining paging parameters;
dividing the query result set into at least one query result subset according to the paging parameters;
and returning the query result subsets to the query terminal for the query terminal to display according to the query result subsets, wherein each query result subset is displayed on one page.
5. The data cache-based query method of claim 4, wherein the paging the query result set according to the paging parameter comprises:
sorting the query results in the query result set;
and dividing the sorted query results into at least one query result subset according to the paging parameters, wherein the paging parameters comprise the number of the query results.
6. The data cache-based query method according to claim 1, wherein the step of invoking a preset query tool to perform a query in a preset database according to the characteristic parameter to obtain the query result set comprises:
calling a preset query tool to query in a preset database according to the characteristic parameters to obtain a query result;
sequencing the query results;
and generating the query result set according to the sorted query results.
7. The data cache-based query method of claim 6, wherein the step of ranking the query results comprises:
obtaining the matching degree of each query result and the characteristic parameters;
and sequencing the query results according to the matching degree.
8. A terminal device, characterized in that the terminal device comprises a memory, a processor and a data cache based query program stored on the memory and operable on the processor, and when executed by the processor, the data cache based query program of the terminal device implements the steps of the data cache based query method of the terminal device according to any one of claims 1 to 7.
9. A computer-readable storage medium, characterized in that the computer-readable storage medium has stored thereon a data cache based query program of a terminal device, which when executed by a processor implements the steps of the data cache based query method of the terminal device according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911370778.0A CN111143416B (en) | 2019-12-25 | 2019-12-25 | Query method, terminal and storage medium based on data cache |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911370778.0A CN111143416B (en) | 2019-12-25 | 2019-12-25 | Query method, terminal and storage medium based on data cache |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111143416A true CN111143416A (en) | 2020-05-12 |
| CN111143416B CN111143416B (en) | 2024-01-30 |
Family
ID=70520574
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911370778.0A Active CN111143416B (en) | 2019-12-25 | 2019-12-25 | Query method, terminal and storage medium based on data cache |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111143416B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112316416A (en) * | 2020-11-13 | 2021-02-05 | 网易（杭州）网络有限公司 | Data searching method and device, computer equipment and storage medium |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080167973A1 (en) * | 2007-01-05 | 2008-07-10 | De Marcken Carl | Providing travel information using cached query answers |
| US20140181134A1 (en) * | 2012-12-21 | 2014-06-26 | Marcel Hermanns | Push-down of authority check within query engine |
| CN107590275A (en) * | 2017-09-27 | 2018-01-16 | 北京奇虎科技有限公司 | A kind of data query method and apparatus |
| WO2018035799A1 (en) * | 2016-08-25 | 2018-03-01 | 阿里巴巴集团控股有限公司 | Data query method, application and database servers, middleware, and system |
| CN109284309A (en) * | 2018-10-16 | 2019-01-29 | 翟红鹰 | Database caches method, terminal and computer readable storage medium |
| CN109857760A (en) * | 2018-12-22 | 2019-06-07 | 中国平安人寿保险股份有限公司 | Quick response search method and device, computer installation and storage medium |
| CN110134705A (en) * | 2018-02-09 | 2019-08-16 | ***通信集团有限公司 | A kind of data query method, cache server and terminal |
| WO2019223390A1 (en) * | 2018-05-21 | 2019-11-28 | 阿里巴巴集团控股有限公司 | Authorization guidance data processing method, apparatus, device and system |
-
2019
- 2019-12-25 CN CN201911370778.0A patent/CN111143416B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080167973A1 (en) * | 2007-01-05 | 2008-07-10 | De Marcken Carl | Providing travel information using cached query answers |
| US20140181134A1 (en) * | 2012-12-21 | 2014-06-26 | Marcel Hermanns | Push-down of authority check within query engine |
| WO2018035799A1 (en) * | 2016-08-25 | 2018-03-01 | 阿里巴巴集团控股有限公司 | Data query method, application and database servers, middleware, and system |
| CN107590275A (en) * | 2017-09-27 | 2018-01-16 | 北京奇虎科技有限公司 | A kind of data query method and apparatus |
| CN110134705A (en) * | 2018-02-09 | 2019-08-16 | ***通信集团有限公司 | A kind of data query method, cache server and terminal |
| WO2019223390A1 (en) * | 2018-05-21 | 2019-11-28 | 阿里巴巴集团控股有限公司 | Authorization guidance data processing method, apparatus, device and system |
| CN109284309A (en) * | 2018-10-16 | 2019-01-29 | 翟红鹰 | Database caches method, terminal and computer readable storage medium |
| CN109857760A (en) * | 2018-12-22 | 2019-06-07 | 中国平安人寿保险股份有限公司 | Quick response search method and device, computer installation and storage medium |
Non-Patent Citations (2)
| Title |
|---|
| 王彦士;王伟;刘朝辉;魏峻;黄涛;: "支持透明集成的数据缓存机制", no. 04 * |
| 阳颖灿;***;李晖;: "一种负载敏感的OLAP查询结果缓存管理技术", 微型机与应用, no. 03 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112316416A (en) * | 2020-11-13 | 2021-02-05 | 网易（杭州）网络有限公司 | Data searching method and device, computer equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111143416B (en) | 2024-01-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110457363B (en) | Query method, device and storage medium based on distributed database | |
| CN112328925B (en) | Page data loading method, device, equipment and storage medium | |
| US8620946B2 (en) | Storage and searching of temporal entity information | |
| US8856676B1 (en) | Pre-filling input fields using heuristic data | |
| CN110737674A (en) | Visual chart query method, device and equipment and computer storage medium | |
| EP2866158A1 (en) | Method for reader to provide service, reader, terminal and computer storage medium | |
| CN109710571B (en) | File analysis method, device and storage medium | |
| CN107329976B (en) | Webpage paging method and device, computer equipment and computer readable storage medium | |
| CN108415748B (en) | Information display method and system, computer storage medium and device | |
| WO2019041500A1 (en) | Pagination realization method and device, computer equipment and storage medium | |
| CN111400578B (en) | Cargo data query method, cargo data query device, computer equipment and storage medium | |
| CN111143416A (en) | Data cache-based query method, terminal and storage medium | |
| CN108255898B (en) | Page display method and device | |
| CN106649806B (en) | Method for maintaining brand information | |
| CN111026669B (en) | Test log management method, test log management device and storage medium | |
| KR20160032653A (en) | Method and apparatus for ranking candiate character and method and device for inputting character | |
| CN110059243B (en) | Data engine optimization method, device, equipment and computer readable storage medium | |
| CN108052521B (en) | Coordinated data display method, application server and storage medium | |
| CN115168390A (en) | Multi-dimensional asset retrieval analysis method, system, terminal and storage medium | |
| CN110704523B (en) | Data export method, device, equipment and computer readable storage medium | |
| CN112182054A (en) | Vehicle competitive product data processing method, system, equipment and storage medium | |
| CN113779362A (en) | Data searching method and device | |
| JP2008242681A (en) | Search service system, search server, search service method, and program for search service | |
| CN113256253A (en) | Data processing method, device, equipment, computer readable storage medium and product | |
| CN111125205A (en) | Signboard data display method, terminal and storage medium |
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 | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: 518000 1402, building 1, Chongwen Park, Nanshan wisdom Park, 3370 Liuxian Avenue, Fuguang community, Taoyuan Street, Nanshan District, Shenzhen, Guangdong Province Applicant after: Shenzhen Guanglian Saixun Co.,Ltd. Address before: Room 701, unit 3, building C, Kexing Science Park, No. 15, Keyuan Road, high tech park, Nanshan District, Shenzhen City, Guangdong Province Applicant before: SHENZHEN AUTONET Co.,Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |