CN111143416B - Query method, terminal and storage medium based on data cache - Google Patents
Query method, terminal and storage medium based on data cache Download PDFInfo
- Publication number
- CN111143416B CN111143416B CN201911370778.0A CN201911370778A CN111143416B CN 111143416 B CN111143416 B CN 111143416B CN 201911370778 A CN201911370778 A CN 201911370778A CN 111143416 B CN111143416 B CN 111143416B
- Authority
- CN
- China
- Prior art keywords
- query
- result set
- query result
- terminal
- cache
- 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.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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 OR CALCULATING; 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 caching, which comprises the following steps: when a query request sent by a query terminal is received, acquiring characteristic parameters of the query request; judging whether a query result set associated with the characteristic parameters is stored in a cache database or not; 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 is not available, a preset query tool is called to query in a preset database according to the characteristic parameters so as to obtain the query result set; returning the query result set to the query terminal; and caching the query result set obtained by the 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 topic-oriented, integrated, relatively stable, data collection that reflects historical changes for supporting management decisions. For external queries of large amounts of data in current data warehouses, prest distributed query tools can be used for queries by hive-based external query means. The distributed query is based on the memory, and the query speed is high. However, the existing distributed queries are all direct queries to the data warehouse, resulting in large data volume or complex query traffic that is still time consuming.
The foregoing is provided merely for the purpose of facilitating understanding of the technical solutions of the present invention and is not intended to represent an admission that the foregoing is prior art.
Disclosure of Invention
The invention mainly aims to provide a query method, a terminal and a computer-readable storage medium based on data caching, and aims to solve the technical problem of time consumption of a complex service with large 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 a query request sent by a query terminal is received, acquiring characteristic parameters of the query request;
judging whether a query result set associated with the characteristic parameters is stored in a cache database or not;
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 is not available, a preset query tool is called to query in a preset database according to the characteristic parameters so as to obtain the query result set;
returning the query result set to the query terminal;
and caching the query result set obtained by the 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:
acquiring the cache time length of the query result set in the cache database;
and deleting the query result set with the buffer time reaching the preset time when the buffer time reaches the preset time.
Optionally, the step of associating the query result set with the feature parameter is performed simultaneously with:
and associating the storage time point of the query result set with the query result set, wherein the cache time of the query result set is acquired 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 parameter;
and returning the query result subsets to the query terminal so that the query terminal can display the query result subsets according to the query result subsets, wherein each query result subset is displayed on one page.
Optionally, the step of paging the query result set according to the paging parameter includes:
ordering the query results in the query result set;
dividing the ordered 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 query in a preset database according to the feature parameter 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;
ordering the query results;
and generating the query result set according to the ordered query results.
Optionally, the step of ordering 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 also provides a terminal device including a memory, a processor, and a data cache-based query program stored on the memory and executable on the processor, the data cache-based query program of the terminal device implementing the steps of the data cache-based query method of the terminal device as described above when executed by the processor.
The present invention also provides a computer readable storage medium, on which a data cache based query program of a terminal device is stored, which when executed by a processor implements the steps of the data cache based query method of a terminal device as described above.
The embodiment of the invention provides a query method, a terminal and a computer-readable storage medium based on data caching, wherein the method comprises the following steps: when a query request sent by a query terminal is received, acquiring characteristic parameters of the query request; judging whether a query result set associated with the characteristic parameters is stored in a cache database or not; 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 is not available, a preset query tool is called to query in a preset database according to the characteristic parameters so as to obtain the query result set; returning the query result set to the query terminal; and caching the query result set obtained by the query to the cache database, and associating the query result set with the characteristic parameters. When the characteristic parameters are acquired, the method and the device firstly inquire whether the corresponding inquiry result set is stored in the cache database, if yes, the inquiry result set is directly returned to the inquiry terminal, if no, the preset inquiry mode is called to inquire the preset database, the inquired inquiry result set is returned to the inquiry terminal, and the inquiry result set is stored in the cache database, so that the inquiry result set can be quickly returned when the same content is inquired in the effective period next time, and the inquiry speed and the operation efficiency are improved.
Drawings
FIG. 1 is a schematic diagram of a terminal structure of a hardware operating environment according to an embodiment of the present invention;
FIG. 2 is a flowchart illustrating 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 flowchart illustrating a fourth embodiment of a query method based on data buffering according to the present invention;
fig. 6 is a flowchart illustrating a fifth embodiment of a query method based on data buffering according to the present invention.
The achievement of the objects, functional features and advantages of the present invention will be further described with reference to the accompanying drawings, in conjunction with the embodiments.
Detailed Description
It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the invention.
The main solutions of the embodiments of the present invention are: when a query request sent by a query terminal is received, acquiring characteristic parameters of the query request; judging whether a query result set associated with the characteristic parameters is stored in a cache database or not; 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 is not available, a preset query tool is called to query in a preset database according to the characteristic parameters so as to obtain the query result set; returning the query result set to the query terminal; and caching the query result set obtained by the 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 diagram of a terminal structure of a hardware running environment according to an embodiment of the present invention.
The terminal of the embodiment of the invention can be a PC, or terminal equipment such as a smart phone, a tablet personal 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 the communication bus 1002 is used to enable connected communication between these components. The user interface 1003 may include a Display, an input unit such as a Keyboard (Keyboard), and the optional user interface 1003 may further 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 stable memory (non-volatile memory), such as a disk memory. The memory 1005 may also optionally be a storage device separate from the processor 1001 described above.
It will be appreciated by those skilled in the art that the terminal structure shown in fig. 1 does not constitute a limitation of a data cache based query terminal, and may include more or fewer components than shown, or may combine certain components, or may have 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 background server and performing data communication with the background 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 a query request sent by a query terminal is received, acquiring characteristic parameters of the query request;
judging whether a query result set associated with the characteristic parameters is stored in a cache database or not;
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 is not available, a preset query tool is called to query in a preset database according to the characteristic parameters so as to obtain the query result set;
returning the query result set to the query terminal;
and caching the query result set obtained by the 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:
acquiring the cache time length of the query result set in the cache database;
and deleting the query result set with the buffer time reaching the preset time when the buffer time reaches the preset time.
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 time of the query result set is acquired 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 parameter;
and returning the query result subsets to the query terminal so that the query terminal can display the query result subsets 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:
ordering the query results in the query result set;
dividing the ordered 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;
ordering the query results;
and generating the query result set according to the ordered 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 a query request sent by a query terminal is received, acquiring characteristic parameters of the query request;
step S20, judging whether a query result set associated with the characteristic parameters is stored in a cache database;
step S30, when the query result set associated with the characteristic parameters is not available, a preset query tool is called to query in a preset database according to the characteristic parameters so as to obtain the query result set, and the query result set is returned to the query terminal;
step S40, returning the query result set to the query terminal when the query result set associated with the characteristic parameters exists;
and step S50, caching the query result set obtained by the query into the cache database, and associating the query result set with the characteristic parameters.
The execution terminal of the embodiment may be a mobile terminal, a computer, a tablet computer, or a data warehouse query terminal device, etc., and the execution terminal of the embodiment may perform data warehouse query through presto and may cache the query result. The following illustrates an execution terminal as a data warehouse query terminal device.
The data warehouse query terminal equipment of the embodiment is provided with a query program based on data cache, the query cache is preferentially queried in the query, if no query result exists in the cache, the queried result is cached by using presto as a query engine, and the result set paging is realized in the query cache, so that the rapid query of the query result paging and the complex condition is realized.
The received query request can be obtained by sending a query parameter or a query instruction to the data warehouse query terminal equipment by using the query terminal, wherein the characteristic parameter of the query request comprises a query sql statement and a hash value corresponding to the query sql statement, the characteristic parameter is obtained by analyzing the query parameter or the query instruction, and it can be understood that different query sql statements correspond to different hash values, so that the query result of the query sql statement can be obtained by the hash value by associating the hash value with the query result of the query sql statement. Optionally, the query parameter or the query instruction may include a plurality of query sql statements, and the plurality of query sql statements included therein and the hash values corresponding to the plurality of query sql statements are obtained by parsing the query parameter or the query instruction.
The cache database stores a query result set, where the query result set corresponds to a unique feature parameter, and specifically, the feature parameter herein 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 querying the data warehouse, that is, the query result set queried by the query terminal before is stored in the cache database, when the query terminal sends the same special diagnosis parameters again, the cache database of the mobile terminal stores the query result set corresponding to the feature parameters, and the query to the data warehouse is not needed, so that the quick query is realized. Therefore, after the characteristic parameters are acquired, 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 characteristic parameters sent by the query terminal have 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, using a preset query tool to query in a preset database according to the characteristic parameters so as to obtain the query result set. Specifically, the preset query tool is a presto query mode, the preset database is a data warehouse, and the 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 obtained by each query of the query terminal is stored in the cache database, so that after the query result set corresponding to the feature parameter is obtained, the query result set obtained by the query is cached in the cache database, and the query result set is associated with the feature parameter. Specifically, the query result set is associated with a corresponding hash value, and whether the corresponding query result set exists in the cache database or not can be queried through querying the hash value.
Optionally, the storage time point of the query result set is associated with the query result set while the query result set is associated with the characteristic parameter, and the storage time point of the query result set is the date and time of the query. It can be appreciated 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 obtains a feature parameter of the query request first, determines whether a query result set associated with the feature parameter is stored in a cache database, if so, returns the query result set to the query terminal, and if not, 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 to the cache database, and associates the query result set with the feature parameter. By firstly inquiring whether the characteristic parameters have the associated inquiry result set stored in the cache database and then inquiring in the preset database, the quick inquiry of the data warehouse and the caching of the inquiry result set are realized, and the inquiry speed is improved.
Further, referring to fig. 3, the present invention provides a second embodiment of a query method based on data caching, 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 data caching further includes:
step S60, obtaining the cache time length of the query result set in the cache database;
step S70, deleting the query result set with the buffer time reaching the preset time when the buffer time reaches the preset time.
And when the query result set obtained by the query is cached to the cache database, caching the cache time of the query result set together, wherein the cache time is the time length when the query result set is stored in the cache database. It may be appreciated that the cache duration of the query result set may be obtained according to the cache time and the current query time, for example: and obtaining the caching time of the query result set, and subtracting the caching time from the current query time to obtain the caching time of the query result set.
It can be appreciated that when the cache 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 buffer time length of the query result set in the buffer database is obtained first, and when the buffer time length reaches the preset time length, the query result set with the buffer time length reaching the preset time length 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 data caching, 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 parameter;
and step S43, returning the query result subset to the query terminal for the query terminal to display according to the query result subset.
When the query result set is returned to the query terminal, a paging parameter is acquired first, where the paging parameter may be the number of results of each page, and it may be understood that, according to the number of results of each page, the query result set may be divided into at least one result subset of one page, for example: the paging records 10 query results, if there are 97 query result sets, the query result sets are divided into 10 query result subsets, each of which stores a maximum of 10 query results.
After dividing the query result set into at least one query result subset, returning the query result subset to the query terminal and displaying according to the query result subset, wherein it is 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 parameter is obtained first, then the query result set is divided into at least one query result subset according to the paging parameter, and finally the query result subset is returned to the query terminal for the query terminal to display according to the query result subset, so that the operation of paging the query result set in the 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 data caching, based on the embodiment shown in fig. 4, the step of paging the query result set according to the paging parameter includes:
step S421, sorting the query results in the query result set;
step S422, dividing the sorted query results into at least one query result subset according to the paging parameter, where the paging parameter includes the number of query results.
When the paging parameters are obtained and the query result set is paged according to the paging parameters, the query results in the query result set may be ordered first, where the ordering may be in ascending order or descending order according to the correlation with the feature parameters, or according to the occurrence time of the query results, etc.
It will be appreciated that after the query result set is ranked, the ranked query result set is divided into at least one subset according to the paging parameter, i.e., the number of pages that can store the most query results.
In this embodiment, when the query result set is paged according to the paging parameter, the query results in the query result set are ordered first, and then the ordered 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 implement the ordering of the query results.
Further, referring to fig. 6, the present invention provides a fifth embodiment of a query method based on data caching, based on the embodiment shown in fig. 2, the step of calling a preset query tool to query in a preset database according to the feature parameters 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 ordered query results.
Optionally, after the query result set is obtained, a matching degree of each query result and the characteristic parameter is obtained, where the matching degree is a correlation between the query result and the characteristic parameter, that is, a high matching degree is obtained when the query result and the characteristic parameter have a high correlation.
It may be appreciated that after the matching degree is obtained, the query results are ranked according to the matching degree from high to low or from low to high, and the ranked query results are generated into the query result set.
In this embodiment, after a preset query tool is called to perform a query in a preset database according to the feature parameters to obtain query results, the matching degree of each query result and the feature parameters is obtained, the query results are ordered according to the matching degree, and the query result set is generated according to the ordered query results, so that after the query results are obtained, the query results are ordered according to the matching degree and a query result set is generated.
The invention also provides a terminal, the terminal equipment comprises a memory, a processor and a query program based on data cache, wherein the query program based on the data cache is stored in the memory and can run on the processor, and the query program based on the data cache of the terminal equipment realizes the steps of the query method based on the data cache of the terminal equipment when being executed by the processor.
In addition, the embodiment of the invention also provides a computer readable storage medium, wherein the computer readable storage medium stores a query program based on data cache of the terminal equipment, and the query program based on the data cache of the terminal equipment realizes the steps of the query method based on the data cache of the terminal equipment when being executed by a processor.
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 one … …" does not exclude the presence of other like elements in a process, method, article, or system that comprises the element.
The foregoing embodiment numbers of the present invention are merely for the purpose of description, and do not represent the advantages or disadvantages of the embodiments.
From the above description of the embodiments, it will be clear to those skilled in the art that the above-described embodiment method may be implemented by means of software plus a necessary general hardware platform, but of course may also be implemented by means of hardware, but in many cases the former is a preferred embodiment. Based on such understanding, the technical solution of the present invention may be embodied essentially or in a part contributing to the prior art in the form of a software product stored in a storage medium (e.g. ROM/RAM, magnetic disk, optical disk) as described above, comprising instructions for causing a terminal device (which may be a mobile phone, a computer, a server, or a network device, etc.) to perform the method according to the embodiments of the present invention.
The foregoing description is only of the preferred embodiments of the present invention, and is not intended to limit the scope of the invention, but rather is intended to cover any equivalents of the structures or equivalent processes disclosed herein or in the alternative, which may be employed directly or indirectly in other related arts.
Claims (3)
1. The query method based on the data cache is characterized by comprising the following steps of:
when a query request sent by a query terminal is received, acquiring characteristic parameters of the query request, wherein the characteristic parameters comprise a query sql statement and a hash value corresponding to the query sql statement;
judging whether a query result set associated with the hash value is stored in a cache database;
when the query result set associated with the hash value exists, returning the query result set to the query terminal;
when the query result set associated with the hash value does not exist, calling presto query in a data warehouse according to the query sql statement to obtain a query result;
obtaining the matching degree of each query result and the characteristic parameter, wherein the matching degree is the correlation between the query result and the characteristic parameter;
sorting the query results according to the matching degree;
generating the query result set according to the ordered query results;
obtaining paging parameters, wherein the paging parameters are the number of result strips of each page;
ranking the query results in the query result set according to the relevance with the characteristic parameters;
dividing the ordered query results into at least one query result subset according to the paging parameters;
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 a page;
caching the query result set obtained by query to the cache database, and associating the query result set with the hash value, wherein the storage time point of the query result set is the date and time of the query;
obtaining the cache time length of the query result set according to the storage time point and the current query time, wherein the cache time length is the time length of the query result set stored in the cache database;
and deleting the query result set with the buffer time reaching the preset time when the buffer time reaches the preset time.
2. A terminal device comprising a memory, a processor and a data cache based query program stored on the memory and executable on the processor, the data cache based query program of the terminal device, when executed by the processor, implementing the steps of the data cache based query method of the terminal device of any of claims 1.
3. 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 a terminal device according to any of claims 1.
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 CN111143416A (en) | 2020-05-12 |
| CN111143416B true 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) |
Families Citing this family (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112316416B (en) * | 2020-11-13 | 2024-07-23 | 网易（杭州）网络有限公司 | Data searching method, device, computer equipment and storage medium |
| CN114547095A (en) * | 2022-02-10 | 2022-05-27 | 深圳市翼海云峰科技有限公司 | A method, device, electronic device and storage medium for fast data query |
| CN115203261B (en) * | 2022-07-21 | 2026-01-06 | 中国平安人寿保险股份有限公司 | Data query methods, data query devices, equipment and storage media |
| CN115952208A (en) * | 2023-01-04 | 2023-04-11 | 北京奇艺世纪科技有限公司 | A method, device and electronic equipment for calculating the degree of association between features and tags |
| CN116795876A (en) * | 2023-06-15 | 2023-09-22 | 平安科技（深圳）有限公司 | Data storage methods and related equipment based on artificial intelligence |
| CN116860806A (en) * | 2023-07-25 | 2023-10-10 | 中国工商银行股份有限公司 | Data query method, device, electronic equipment and computer storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7711587B2 (en) * | 2007-01-05 | 2010-05-04 | Ita Software, Inc. | 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 |
-
2019
- 2019-12-25 CN CN201911370778.0A patent/CN111143416B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
|---|
| 一种负载敏感的OLAP查询结果缓存管理技术;阳颖灿;张小平;李晖;;微型机与应用(03);全文 * |
| 王彦士 ; 王伟 ; 刘朝辉 ; 魏峻 ; 黄涛 ; .支持透明集成的数据缓存机制.计算机研究与发展.2015,(04),全文. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111143416A (en) | 2020-05-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111143416B (en) | Query method, terminal and storage medium based on data cache | |
| CN110457363B (en) | Query method, device and storage medium based on distributed database | |
| US7657839B2 (en) | System for replying to related messages | |
| CN107679077B (en) | Paging implementation method and device, computer equipment and storage medium | |
| US7412437B2 (en) | System and method for searching and retrieving related messages | |
| CN110309334B (en) | Query method, system, computer device and readable storage medium for graph database | |
| CN110069763B (en) | Contract text customization method, device, equipment and readable storage medium | |
| CN111221742B (en) | Test case updating method and device, storage medium and server | |
| CN113468441A (en) | Search sorting method, device, equipment and storage medium based on weight adjustment | |
| CN108416030B (en) | Position recommendation method and device and computer readable storage medium | |
| CN110502692B (en) | Information retrieval method, device, equipment and storage medium based on search engine | |
| CN111400578A (en) | Goods data query method and device, computer equipment and storage medium | |
| CN110955646A (en) | Data storage and query method, device, equipment and medium | |
| CN112613271A (en) | Data paging method and device, computer equipment and storage medium | |
| US8805933B2 (en) | System and method for building interest profiles from related messages | |
| US7818680B2 (en) | Method for deleting related messages | |
| CN108012558B (en) | Phone number normalization and information discoverability | |
| CN112699147B (en) | Paging query method, device, equipment and storage medium | |
| CN114020946B (en) | A target judgment processing method and system based on multi-image retrieval data fusion | |
| CN113268487B (en) | Data statistical method, device and computer readable storage medium | |
| CN1869977A (en) | Retrieval system and method | |
| US20080306753A1 (en) | System and method for providing quick links | |
| CN114118941A (en) | Vehicle type research and development task architecture diagram generation method, device, equipment and storage medium | |
| CN113849838A (en) | Management method, device, electronic device and storage medium for rights data | |
| CN109727144B (en) | Insurance occurrence rate calculation method, apparatus, device and computer readable 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 |