CN109656959A - A kind of data query method, apparatus, electronic equipment and storage medium - Google Patents
A kind of data query method, apparatus, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN109656959A CN109656959A CN201811583416.5A CN201811583416A CN109656959A CN 109656959 A CN109656959 A CN 109656959A CN 201811583416 A CN201811583416 A CN 201811583416A CN 109656959 A CN109656959 A CN 109656959A
- Authority
- CN
- China
- Prior art keywords
- query
- query task
- task
- inquiry instruction
- present
- 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
Links
Abstract
The present embodiments relate to data analysis field, a kind of data query method, apparatus, electronic equipment and storage medium are disclosed.In the present invention, data query method, comprising: extract query task present in application;Setting timer is periodically executed query task and caching query results;Inquiry instruction is received, includes the first query task in inquiry instruction;In response to the first query task, the corresponding query result of inquiry instruction is determined according to the first query task and buffered results, further promotes the execution speed of query task, reduces query task to the pressure of database.
Description
Technical field
The present invention relates to data analysis field, in particular to a kind of data query method, apparatus, electronic equipment and storage are situated between
Matter.
Background technique
In this current big data era, for the single report of specific transactions scene line number be even up to it is billions of
Rank, at this moment, if being often difficult to meet the requirements by the promotion of database performance merely, this just needs us slow by active
Deposit data technology improves the response speed of webpage, improves user experience, while mitigating frequent data query and causing to database
Pressure, guarantee service stability.
Inventor's discovery: it is existing to solve the above problems, using Redis caching technology, but cache after timeliness crossed, if
Do not inquire again, caching will timeliness, even if occurring identical query task again later, will with for the first time inquire when do phase
Same operation, directly inquiry database, in this case, subsequent inquiry velocity is still very slow, and can cause stress to database.
Summary of the invention
Embodiment of the present invention is designed to provide a kind of data query method, apparatus, electronic equipment and storage medium,
The execution speed for further promoting query task reduces query task to the pressure of database.
In order to solve the above technical problems, embodiments of the present invention provide a kind of data query method, comprising: extraction is answered
The query task present in;Setting timer is periodically executed the query task and caching query results;Inquiry instruction is received,
It include the first query task in the inquiry instruction;In response to first query task, according to the first query task and caching
As a result the corresponding query result of the inquiry instruction is determined.
Embodiments of the present invention additionally provide a kind of data query device, comprising: extraction module, for extracting in application
Existing query task;Setup module is periodically executed the query task and caching query results for timer to be arranged;It receives
Module includes the first query task in the inquiry instruction for receiving inquiry instruction;Determining module, in response to described
First query task determines the corresponding query result of the inquiry instruction according to the first query task and buffered results.
Embodiments of the present invention additionally provide a kind of electronic equipment, comprising: at least one processor;And with it is described
The memory of at least one processor communication connection;Wherein, the memory, which is stored with, to be held by least one described processor
Capable instruction, described instruction are executed by least one described processor, so that at least one described processor is able to carry out: being extracted
The query task present in;Setting timer is periodically executed the query task and caching query results;Inquiry is received to refer to
It enables, includes query task in the inquiry instruction;In response to the query task, institute is determined according to query task and buffered results
State the corresponding query result of inquiry instruction.
Embodiments of the present invention additionally provide a kind of non-volatile memory medium, for storing computer-readable program,
Computer-readable program is used to execute data query method as described above for computer.
In terms of existing technologies, the main distinction and its effect are embodiment of the present invention: in advance actively from application
Query task existing for middle extraction, and the query task to extract sets timer to be periodically executed, and will look into after executing every time
Ask result cache.After receiving inquiry instruction, so that it may find out knot corresponding with inquiry instruction from the query result in caching
Fruit greatly promotes the execution speed of query task, while can also reduce query task to data without searching into database
The pressure in library.
As a further improvement, query task present in the extraction application, specifically: it extracts and belongs to present in application
In query task at a slow speed;It is described in response to the inquiry instruction, inquiry instruction pair is determined according to inquiry instruction and buffered results
The query result answered, comprising: if the query task that the inquiry instruction is specified belongs at a slow speed, according to inquiry instruction and buffered results
Determine the corresponding query result of inquiry instruction.The clear query task actively extracted belongs to inquiry at a slow speed, reduces caching burden.
As a further improvement, it is described in response to the inquiry instruction, inquiry is determined according to inquiry instruction and buffered results
Instruct corresponding query result, further includes: if the query task that the inquiry instruction is specified is not belonging at a slow speed, according to the application
Corresponding database executes the task to be checked.After the task that active is extracted belongs at a slow speed, receives and be not belonging at a slow speed
Inquiry instruction executes corresponding query task from database, guarantees the accurate execution of inquiry instruction.
As a further improvement, being met in preset query task library according to the corresponding query script of the query task
Query script determines that the query task belongs at a slow speed.The task library of default query task at a slow speed, so that actively extracting task
When, it can accurately extract.
As a further improvement, being more than preset duration according to the execution time of the query task, determine that the inquiry is appointed
Business belongs at a slow speed.
As a further improvement, the setting timer is periodically executed described look into if the query task extracted has multiple
In inquiry task, comprising: multiple timers, the quantity one-to-one correspondence of the timer and the query task are set;Using described
Multiple timers are periodically executed a corresponding query task respectively.The timer setting rule that query task is specified when having multiple
Then.
As a further improvement, extracting query task present in application in the following manner: from the engineering of the application
The corresponding query script of query task is searched in code;When finding, the corresponding query script of the query task is replicated extremely
Unique file.The extracting mode for specifying query task is deposited to unique file convenient for subsequent data analysis and utilization.
As a further improvement, caching the query result: Redis, separate type cache using following technology
Ehcache is cached in Memcache or Java process.Available a variety of cache way are specified, convenient for selecting according to actual needs.
Detailed description of the invention
Fig. 1 is the flow chart of the data query method in first embodiment according to the present invention;
Fig. 2 is the flow chart of the data query method in second embodiment according to the present invention;
Fig. 3 is the schematic diagram of the data query device in third embodiment according to the present invention;
Fig. 4 is the electronic devices structure schematic diagram in the 4th embodiment according to the present invention.
Specific embodiment
In order to make the object, technical scheme and advantages of the embodiment of the invention clearer, below in conjunction with attached drawing to the present invention
Each embodiment be explained in detail.However, it will be understood by those skilled in the art that in each embodiment party of the present invention
In formula, in order to make the reader understand this application better, many technical details are proposed.But even if without these technical details
And various changes and modifications based on the following respective embodiments, the application technical solution claimed also may be implemented.
The first embodiment of the present invention is related to a kind of data query method, present embodiment can be applied in terminal side,
It such as applies in mobile phone, the electronic equipments such as tablet computer, can also apply in the server of network side.Present embodiment is to answer
It is illustrated for electronic equipment, detailed process is as shown in Figure 1, comprising:
Step 101, query task present in application is extracted.
Specifically, query task can be SQL query task.
Query task library is preset in present embodiment, when executing extraction step, from the engineering code of application (as applied A)
The corresponding query script of middle lookup query task, if identical with script in query task library using existing in the engineering code of A
Query script, then corresponding query script is extracted, so as to subsequent use.
It continues to explain, at the extraction, can specifically replicate corresponding query script to unique file, such as doc file, independence
File transfers use conducive to subsequent step.
Step 102, setting timer is periodically executed query task.
Specifically, timer is arranged in the query task to extract, and specifies the pending time of query task.More specifically
Say, when extracting multiple queries task, multiple, the quantity of timer and the quantity of query task is also accordingly arranged in timer
It corresponds.
In present embodiment, three query tasks are extracted, are correspondingly arranged three timers, each timer can correspond to
One query task allows to that the different pending time is arranged for each query task, or different inquiries is appointed
The identical pending time is arranged in business, flexible, more meets actual demand.
It continues to explain, when timer timing terminates, query task is executed, and timer starts again at timing, realizes that inquiry is appointed
Timing cycle of being engaged in executes, it can be seen that query task executes again at regular intervals, and adjacent interval when executing twice can be with
By Timer Controlling.
Step 103, caching query results.
Specifically, present embodiment can use Redis technology active cache query result.More specifically, Redis
In storage, user places data into redis technology, and data are stored in calculating by redis in the form of key-value later
In machine memory;At the time of reading, user obtains specified data, the key value that redis is provided according to user later, from memory from redis
In by series of algorithms, quickly navigate to data value, and extract and return to user.
In practical application, other caching technologies can also be utilized, such as: separate type cache Memcache or Java process
Interior caching Ehcache etc., will not enumerate herein.
It continues to explain, sets up mapping relations between the query result of caching and the query task of extraction, so that subsequent find is looked into
Ask result.
Above-mentioned steps 101 to step 103 is the preparation stage of query task, can execute in specific time, such as exist in advance
Electronic equipment executes when being switched on, and can also set daily execution, is not necessarily carried out when executing data query method every time.It can
See, because query task executes repeatedly, the query result in caching keeps effectively, making for the query task of subsequent appearance
With.
Step 104, inquiry instruction is received.
Specifically, user operates on the interface of application A when using using A, and certain operations trigger scheduled inquiry
Task issues inquiry instruction to electronic equipment using A at this time, includes query task in inquiry instruction, correspondingly, electronic equipment connects
Receive inquiry instruction.
Step 105, the corresponding query result of inquiry instruction is determined according to inquiry instruction and buffered results.
Specifically, in response to the query task received, inquiry instruction pair is determined according to inquiry instruction and buffered results
The query result answered.It continues to explain, electronic equipment parses corresponding inquiry after receiving inquiry instruction from inquiry instruction
Task then searches from caching according to the query task parsed, after finding, query result is fed back to using A.
In terms of existing technologies, the main distinction and its effect are present embodiment: actively mentioning from application in advance
Existing query task is taken, and the query task to extract sets timer to be periodically executed, and inquiry is tied after executing every time
Fruit caching.After receiving inquiry instruction, so that it may from the query result in caching find out it is corresponding with inquiry instruction as a result, and
Without searching into database, the execution speed of query task is greatly promoted, while query task can also be reduced to database
Pressure.
It, but in practical applications, can also be in addition, present embodiment is illustrated for applying in electronic equipment
Apply the server in network side.For example, the inquiry instruction of user is sent to network side server by electronic equipment, by network
Side server determines the corresponding query result of searching request, and after finding, query result is fed back to electronic equipment, supplied for electronic
Equipment uses.It will be understood by those skilled in the art that server side can provide query result for multiple electronic equipments, so by
Server side executes the data query method in present embodiment, will further decrease the pressure to database.
Second embodiment of the present invention is related to a kind of data query method, and present embodiment is in first embodiment
On the basis of be further improved, when mainly theing improvement is that query task present in extraction application, specific extract belongs to
Query task at a slow speed, it is preferential to ensure that inquiry at a slow speed is able to accelerate speed, when accelerating inquiry velocity, reduce looking into of repeating
The quantity of inquiry task reduces the pressure of caching.
The detailed process of data query method is as shown in Figure 2 in present embodiment, comprising:
Step 201, query task at a slow speed present in application is extracted.
Specifically, the query task library of the query script including query task at a slow speed can be preset, at the extraction, from answering
It is searched in engineering code, if finding the query script for belonging to the query task library, then it is assumed that belong to inquiry at a slow speed and appoint
Business, extracts.
It continues to explain, query task can be slow SQL at a slow speed in present embodiment, and technical staff can according to need setting
The slow library SQL of oneself can will execute the query task that the time is more than preset duration and be confirmed as slow SQL, will such as execute duration and surpass
The SQL for spending 3 seconds is confirmed as slow SQL.
Step 102 of the step 202 into 204 and first embodiment is to 104 similar, and details are not described herein.
Step 205, judge whether query task belongs at a slow speed;If so, thening follow the steps 206;If it is not, thening follow the steps
207。
Step 105 in step 206 and first embodiment is similar, and details are not described herein.
Step 207, task to be checked is executed according to the corresponding database of application.
Specifically, above-mentioned steps 205 to 207 judge to look into specified by inquiry instruction in advance after receiving inquiry instruction
Whether inquiry task belongs at a slow speed, if belonged at a slow speed, query result is just searched from caching, if be not belonging at a slow speed so
Query task is just executed in the database.
As it can be seen that the clear query task actively extracted of present embodiment belongs to inquiry at a slow speed, preferential ensure is inquired at a slow speed
It is able to quickening speed and reduces the quantity of the query task repeated when accelerating inquiry velocity, reduce the pressure of caching.
Third embodiment of the present invention is related to a kind of data query device, as shown in Figure 3, comprising:
Extraction module, for extracting query task present in application.
Setup module is periodically executed query task and caching query results for timer to be arranged.
Receiving module includes query task in inquiry instruction for receiving inquiry instruction.
Determining module, for determining that inquiry instruction is corresponding according to query task and buffered results in response to query task
Query result.
In terms of existing technologies, the main distinction and its effect are present embodiment: actively mentioning from application in advance
Existing query task is taken, and the query task to extract sets timer to be periodically executed, and inquiry is tied after executing every time
Fruit caching.After receiving inquiry instruction, so that it may from the query result in caching find out it is corresponding with inquiry instruction as a result, and
Without searching into database, the execution speed of query task is greatly promoted, while query task can also be reduced to database
Pressure.
It is not difficult to find that present embodiment is Installation practice corresponding with first embodiment, present embodiment can be with
First embodiment is worked in coordination implementation.The relevant technical details mentioned in first embodiment still have in the present embodiment
Effect, in order to reduce repetition, which is not described herein again.Correspondingly, the relevant technical details mentioned in present embodiment are also applicable in
In first embodiment.
In one example, extraction module specifically extracts the query task belonged to present in application at a slow speed;Determining module
It specifically includes:
It determines submodule, if belonging at a slow speed for the query task that inquiry instruction is specified, is tied according to query task and caching
Fruit determines the corresponding query result of inquiry instruction.
In one example, determining module further include:
Data base querying submodule, if being not belonging at a slow speed, be corresponded to according to application for the query task that inquiry instruction is specified
Database execute task to be checked.
In one example, determining module meets preset query task with specific reference to the corresponding query script of query task
Query script in library determines that query task belongs at a slow speed.
In one example, determining module is more than preset duration with specific reference to the execution time of query task, determines inquiry
Task belongs at a slow speed.
In one example, extraction module extracts multiple queries task, and setup module specifically includes:
Submodule is set, for multiple timers, the quantity one-to-one correspondence of timer and query task to be arranged.
Timing submodule, for being periodically executed a corresponding query task respectively using multiple timers.
In one example, extraction module specifically includes:
Submodule is searched, for searching the corresponding query script of query task from the engineering code of application.
Submodule is replicated, for when finding, replicating the corresponding query script of query task to unique file.
In one example, setup module specifically utilizes following technology caching query results: Redis, separate type high speed are slow
It deposits and caches Ehcache in Memcache or Java process.
It is noted that each module involved in present embodiment is logic module, and in practical applications, one
A logic unit can be a physical unit, be also possible to a part of a physical unit, can also be with multiple physics lists
The combination of member is realized.In addition, in order to protrude innovative part of the invention, it will not be with solution institute of the present invention in present embodiment
The technical issues of proposition, the less close unit of relationship introduced, but this does not indicate that there is no other single in present embodiment
Member.
4th embodiment of the invention is related to a kind of electronic equipment, and the electronic equipment of present embodiment can be terminal side
Equipment, such as mobile phone, tablet computer etc..
As shown in figure 4, the electronic equipment includes: at least one processor 401;And it is logical at least one processor 401
Believe the memory 402 of connection;And the communication component 403 with scanning means communication connection, communication component 403 is in processor 401
Control under send and receive data;Wherein, memory 402 is stored with the instruction that can be executed by least one processor 401, refers to
It enables and being executed by least one processor 401 to realize:
Extract query task present in application.
Setting timer is periodically executed query task and caching query results.
Inquiry instruction is received, includes query task in inquiry instruction.
In response to query task, the corresponding query result of inquiry instruction is determined according to query task and buffered results.
Specifically, which includes: one or more processors 401 and memory 402, at one in Fig. 4
For reason device 401.Processor 401, memory 402 can be connected by bus or other modes, to be connected by bus in Fig. 4
It is connected in example.Memory 402 is used as a kind of non-volatile computer readable storage medium storing program for executing, can be used for storing non-volatile software journey
Sequence, non-volatile computer executable program and module.Processor 401 is stored in non-easy in memory 402 by operation
The property lost software program, instruction and module realize above-mentioned number thereby executing the various function application and data processing of equipment
According to querying method.
Memory 402 may include storing program area and storage data area, wherein storing program area can store operation system
Application program required for system, at least one function;It storage data area can the Save option list etc..In addition, memory 402 can be with
It can also include nonvolatile memory, for example, at least disk memory, a flash memory including high-speed random access memory
Device or other non-volatile solid state memory parts.In some embodiments, it includes relative to processing that memory 402 is optional
The remotely located memory of device 401, these remote memories can pass through network connection to external equipment.The example of above-mentioned network
Including but not limited to internet, intranet, local area network, mobile radio communication and combinations thereof.
One or more module is stored in memory 402, when being executed by one or more processor 401, is held
Data query method in the above-mentioned any means embodiment of row.
The said goods can be performed the application embodiment provided by method, have the corresponding functional module of execution method and
Beneficial effect, the not technical detail of detailed description in the present embodiment, reference can be made to method provided by the application embodiment.
5th embodiment of the invention is related to a kind of non-volatile memory medium, for storing computer-readable program,
Computer-readable program is used to execute above-mentioned all or part of embodiment of the method for computer.
That is, it will be understood by those skilled in the art that implement the method for the above embodiments be can be with
Relevant hardware is instructed to complete by program, which is stored in a storage medium, including some instructions are to make
It obtains an equipment (can be single-chip microcontroller, chip etc.) or processor (processor) executes side described in each embodiment of the application
The all or part of the steps of method.And storage medium above-mentioned includes: USB flash disk, mobile hard disk, read-only memory (ROM, Read-Only
Memory), random access memory (RAM, Random Access Memory), magnetic or disk etc. are various can store journey
The medium of sequence code.
It will be understood by those skilled in the art that the respective embodiments described above are to realize specific embodiments of the present invention,
And in practical applications, can to it, various changes can be made in the form and details, without departing from the spirit and scope of the present invention.
A1. a kind of data query method, comprising:
Extract query task present in application;
Setting timer is periodically executed the query task and caching query results;
Inquiry instruction is received, includes the first query task in the inquiry instruction;
In response to first query task, determine that the inquiry instruction is corresponding according to the first query task and buffered results
Query result.
A2. data query method according to a1, query task present in extraction application, specifically: it extracts
Belong to query task at a slow speed present in;
It is described in response to first query task, the inquiry instruction is determined according to the first query task and buffered results
Corresponding query result, comprising:
If the first specified query task of the inquiry instruction belongs at a slow speed, true according to the first query task and buffered results
Determine the corresponding query result of inquiry instruction.
A3. the data query method according to A2, it is described in response to first query task, appointed according to the first inquiry
Business determines the corresponding query result of inquiry instruction with buffered results, further includes:
If the first specified query task of the inquiry instruction is not belonging at a slow speed, be held according to the corresponding database of the application
Row first query task.
A4. the data query method according to A2 meets preset according to the corresponding query script of the query task
Query script in query task library determines that the query task belongs at a slow speed.
A5. the data query method according to A2 is more than preset duration according to the execution time of the query task, really
The fixed query task belongs at a slow speed.
A6. data query method according to a1, if the query task extracted has multiple, the setting timer is fixed
Phase executes in the query task, comprising:
Multiple timers, the quantity one-to-one correspondence of the timer and the query task are set;
It is periodically executed a corresponding query task respectively using the multiple timer.
A7. data query method according to a1 extracts query task present in application in the following manner:
The corresponding query script of query task is searched from the engineering code of the application;
When finding, the corresponding query script of the query task is replicated to unique file.
A8. the data query method according to any one of A1 to A 7 caches the inquiry using following technology and ties
Fruit: Ehcache is cached in Redis, separate type cache Memcache or Java process.
B9. a kind of data query device, comprising:
Extraction module, for extracting query task present in application;
Setup module is periodically executed the query task and caching query results for timer to be arranged;
Receiving module includes the first query task in the inquiry instruction for receiving inquiry instruction;
Determining module, for determining institute according to the first query task and buffered results in response to first query task
State the corresponding query result of inquiry instruction.
C10. a kind of electronic equipment, comprising:
At least one processor;And
The memory being connect at least one described processor communication;Wherein,
The memory is stored with the instruction that can be executed by least one described processor, and described instruction is by described at least one
A processor executes, so that at least one described processor is able to carry out:
Extract query task present in application;
Setting timer is periodically executed the query task and caching query results;
Inquiry instruction is received, includes the first query task in the inquiry instruction;
In response to first query task, according to the first query task and caching as a result, determining the inquiry instruction pair
The query result answered.
C11. the electronic equipment according to C10, query task present in extraction application, specifically: extraction is answered
Belong to query task at a slow speed present in;
It is described in response to first query task, determine that inquiry instruction is corresponding according to the first query task and buffered results
Query result, comprising:
If the first specified query task of the inquiry instruction belongs at a slow speed, looked into according to inquiry instruction and buffered results determination
It askes and instructs corresponding query result.
C12. the electronic equipment according to C11, it is described in response to first query task, according to the first query task
The corresponding query result of inquiry instruction is determined with buffered results, further includes:
If the first specified query task of the inquiry instruction is not belonging at a slow speed, be held according to the corresponding database of the application
Row first query task.
C13. the electronic equipment according to C11 meets preset look into according to the corresponding query script of the query task
The query script in task library is ask, determines that the query task belongs at a slow speed.
C14. the electronic equipment according to C11 is more than preset duration according to the execution time of the query task, determines
The query task belongs at a slow speed.
C15. the electronic equipment according to C10, if the query task extracted has multiple, the setting timer is regular
It executes in the query task, comprising:
Multiple timers, the quantity one-to-one correspondence of the timer and the query task are set;
It is periodically executed a corresponding query task respectively using the multiple timer.
C16. the electronic equipment according to C10 extracts query task present in application in the following manner:
The corresponding query script of query task is searched from the engineering code of the application;
When finding, the corresponding query script of the query task is replicated to unique file.
C17. the electronic equipment according to any one of C10 to C16 caches the query result using following technology:
Ehcache is cached in Redis, separate type cache Memcache or Java process.
D18. a kind of computer readable storage medium, is stored with computer program, and the computer program is held by processor
A1 any data query method into A8 is realized when row.
Claims (10)
1. a kind of data query method characterized by comprising
Extract query task present in application;
Setting timer is periodically executed the query task and caching query results;
Inquiry instruction is received, includes the first query task in the inquiry instruction;
In response to first query task, determines that the inquiry instruction is corresponding according to the first query task and buffered results and look into
Ask result.
2. data query method according to claim 1, which is characterized in that inquiry present in the extraction application is appointed
Business, specifically: extract the query task belonged to present in application at a slow speed;
It is described in response to first query task, determine that the inquiry instruction is corresponding according to the first query task and buffered results
Query result, comprising:
If the first specified query task of the inquiry instruction belongs at a slow speed, looked into according to the first query task and buffered results determination
It askes and instructs corresponding query result.
3. data query method according to claim 2, which is characterized in that it is described in response to first query task,
The corresponding query result of inquiry instruction is determined according to the first query task and buffered results, further includes:
If the first specified query task of the inquiry instruction is not belonging at a slow speed, institute is executed according to the corresponding database of the application
State the first query task.
4. data query method according to claim 2, which is characterized in that according to the corresponding inquiry foot of the query task
Originally meet the query script in preset query task library, determine that the query task belongs at a slow speed.
5. data query method according to claim 2, which is characterized in that super according to the execution time of the query task
Preset duration is crossed, determines that the query task belongs at a slow speed.
6. data query method according to claim 1, which is characterized in that if the query task extracted has multiple, institute
Setting timer is stated to be periodically executed in the query task, comprising:
Multiple timers, the quantity one-to-one correspondence of the timer and the query task are set;
It is periodically executed a corresponding query task respectively using the multiple timer.
7. data query method according to claim 1, which is characterized in that extracted present in application in the following manner
Query task:
The corresponding query script of query task is searched from the engineering code of the application;
When finding, the corresponding query script of the query task is replicated to unique file.
8. a kind of data query device characterized by comprising
Extraction module, for extracting query task present in application;
Setup module is periodically executed the query task and caching query results for timer to be arranged;
Receiving module includes the first query task in the inquiry instruction for receiving inquiry instruction;
Determining module, for being looked into according to the first query task and buffered results determination in response to first query task
It askes and instructs corresponding query result.
9. a kind of electronic equipment characterized by comprising
At least one processor;And
The memory being connect at least one described processor communication;Wherein,
The memory is stored with the instruction that can be executed by least one described processor, and described instruction is by described at least one
Device is managed to execute, so that at least one described processor is able to carry out:
Extract query task present in application;
Setting timer is periodically executed the query task and caching query results;
Inquiry instruction is received, includes the first query task in the inquiry instruction;
In response to first query task, according to the first query task with caching as a result, determining that the inquiry instruction is corresponding
Query result.
10. a kind of computer readable storage medium, is stored with computer program, which is characterized in that the computer program is located
It manages and realizes any data query method in claim 1 to 7 when device executes.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811583416.5A CN109656959A (en) | 2018-12-24 | 2018-12-24 | A kind of data query method, apparatus, electronic equipment and storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811583416.5A CN109656959A (en) | 2018-12-24 | 2018-12-24 | A kind of data query method, apparatus, electronic equipment and storage medium |
Publications (1)
Publication Number | Publication Date |
---|---|
CN109656959A true CN109656959A (en) | 2019-04-19 |
Family
ID=66116565
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811583416.5A Pending CN109656959A (en) | 2018-12-24 | 2018-12-24 | A kind of data query method, apparatus, electronic equipment and storage medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109656959A (en) |
Citations (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20130036186A1 (en) * | 2002-07-30 | 2013-02-07 | Brocade Communications Systems, Inc. | Caching remote switch information in a fibre channel switch |
CN103150352A (en) * | 2005-06-20 | 2013-06-12 | 电子湾有限公司 | System to generate related search queries |
CN104331444A (en) * | 2014-10-27 | 2015-02-04 | 北京京东尚科信息技术有限公司 | Method and device for protecting database |
CN104834675A (en) * | 2015-04-02 | 2015-08-12 | 浪潮集团有限公司 | Query performance optimization method based on user behavior analysis |
US9460159B1 (en) * | 2013-08-14 | 2016-10-04 | Google Inc. | Detecting visibility of a content item using tasks triggered by a timer |
CN107229699A (en) * | 2017-05-24 | 2017-10-03 | 四川长虹电器股份有限公司 | The system and method for the mobile end subscriber search experience of lifting |
CN108563744A (en) * | 2018-04-12 | 2018-09-21 | 武汉斗鱼网络科技有限公司 | Slow querying method, device and terminal device based on Redis databases |
CN108920631A (en) * | 2018-06-29 | 2018-11-30 | 郑州云海信息技术有限公司 | A kind of file polling method, apparatus, equipment and readable storage medium storing program for executing |
CN109063140A (en) * | 2018-08-03 | 2018-12-21 | 福州麦辽自动化设备有限公司 | A kind of data query method, transfer server and computer readable storage medium |
-
2018
- 2018-12-24 CN CN201811583416.5A patent/CN109656959A/en active Pending
Patent Citations (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20130036186A1 (en) * | 2002-07-30 | 2013-02-07 | Brocade Communications Systems, Inc. | Caching remote switch information in a fibre channel switch |
CN103150352A (en) * | 2005-06-20 | 2013-06-12 | 电子湾有限公司 | System to generate related search queries |
US9460159B1 (en) * | 2013-08-14 | 2016-10-04 | Google Inc. | Detecting visibility of a content item using tasks triggered by a timer |
CN104331444A (en) * | 2014-10-27 | 2015-02-04 | 北京京东尚科信息技术有限公司 | Method and device for protecting database |
CN104834675A (en) * | 2015-04-02 | 2015-08-12 | 浪潮集团有限公司 | Query performance optimization method based on user behavior analysis |
CN107229699A (en) * | 2017-05-24 | 2017-10-03 | 四川长虹电器股份有限公司 | The system and method for the mobile end subscriber search experience of lifting |
CN108563744A (en) * | 2018-04-12 | 2018-09-21 | 武汉斗鱼网络科技有限公司 | Slow querying method, device and terminal device based on Redis databases |
CN108920631A (en) * | 2018-06-29 | 2018-11-30 | 郑州云海信息技术有限公司 | A kind of file polling method, apparatus, equipment and readable storage medium storing program for executing |
CN109063140A (en) * | 2018-08-03 | 2018-12-21 | 福州麦辽自动化设备有限公司 | A kind of data query method, transfer server and computer readable storage medium |
Non-Patent Citations (1)
Title |
---|
彭永勇等: "基于企业级内外网应用场景的实时缓存技术研究", 《信息与电脑(理论版)》 * |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109145020A (en) | Information query method, from server, client and computer readable storage medium | |
CN110309161B (en) | Data synchronization method and device and server | |
CN106649630A (en) | Data query method and device | |
CN109274730A (en) | The optimization method and device that Internet of things system, MQTT message are transmitted | |
CN105468707A (en) | Cache-based data processing method and device | |
CN104346345B (en) | The storage method and device of data | |
CN111221469B (en) | Method, device and system for synchronizing cache data | |
WO2018035799A1 (en) | Data query method, application and database servers, middleware, and system | |
CN102710763A (en) | Method and system for pooling, slicing and fault transfer of distributed cache | |
CN106060189B (en) | A kind of distribution domain name registration system | |
CN105718592B (en) | Data calling method and its system based on Redis | |
CN113760453A (en) | Container mirror image distribution system and container mirror image pushing, pulling and deleting method | |
CN112866339B (en) | Data transmission method and device, computer equipment and storage medium | |
CN110069565B (en) | Distributed database data batch processing method and device | |
CN112732756B (en) | Data query method, device, equipment and storage medium | |
CN113961832A (en) | Page rendering method, device, equipment, storage medium and program product | |
CN112199443B (en) | Data synchronization method and device, computer equipment and storage medium | |
CN112612816B (en) | Service result query method, device, equipment and medium of Ethernet alliance chain | |
KR20140047448A (en) | Client and database server for resumable transaction and method thereof | |
CN109063140A (en) | A kind of data query method, transfer server and computer readable storage medium | |
CN108881493A (en) | A kind of Task Progress information-pushing method, device and equipment | |
CN111046106A (en) | Cache data synchronization method, device, equipment and medium | |
CN109656959A (en) | A kind of data query method, apparatus, electronic equipment and storage medium | |
CN111294377B (en) | Dependency network request sending method, terminal device and storage medium | |
CN105447089B (en) | Search results pages display methods 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 | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190419 |
|
RJ01 | Rejection of invention patent application after publication |