CN106156061A - A kind of method and device improving efficiency data query - Google Patents
A kind of method and device improving efficiency data query Download PDFInfo
- Publication number
- CN106156061A CN106156061A CN201510144447.0A CN201510144447A CN106156061A CN 106156061 A CN106156061 A CN 106156061A CN 201510144447 A CN201510144447 A CN 201510144447A CN 106156061 A CN106156061 A CN 106156061A
- Authority
- CN
- China
- Prior art keywords
- data
- checked
- key word
- relevant
- keyword
- 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
Landscapes
- Information Transfer Between Computers (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of method and device improving efficiency data query, the method includes: receiving the data inquiry request that user selects, data inquiry request includes keyword or the key word of the query categories relevant to data to be checked;Keyword in query categories or key word are spliced into character string according to preset rules, in buffer storage, the data message relevant to data to be checked is inquired about by character string, wherein, buffer storage is cached with in data base and meets the data message inquired about of preset buffer memory condition;Data message is showed the client of the data inquiry request that user selects.Keyword or the key word of the query categories relevant to data to be checked in the inquiry request that user is selected by the method are spliced into character string, in buffer storage, the data message relevant to data to be checked is inquired about by character string, and it not be used in data base inquiry, substantially increase the efficiency of data query, reduce user and inquire about the waiting time, improve Consumer's Experience.
Description
Technical field
The present invention relates to Internet technical field, be specifically related to a kind of efficiency data query of improving
Method and device.
Background technology
Among IT application in enterprises at present is carried out the most in high gear, company information amount is the most swollen
Swollen.This makes the search work of information become the heaviest.Add up according to investigations, Ren Men
In work at ordinary times, the time of 70% is had all to spend in information search.Thus, how to improve
People search for the efficiency of information becomes the direction of numerous enterprises effort for it.Then enterprise web site
In Web application system, information inquiry design quality directly influence system response time and
How performance the two key index, especially when data volume becomes increasing, process big
The inquiry of data volume become each application developer must faced by problem.
Under the background of mass data, how to improve search efficiency and become the task of top priority.
Summary of the invention
For defect of the prior art, the invention provides a kind of efficiency data query that improves
Method and device, the method increases the efficiency of data query.
First aspect, the present invention provides a kind of method improving efficiency data query, including:
Receiving the data inquiry request that user selects, described data inquiry request includes with to be checked
The keyword of the query categories that data are relevant or key word;
Keyword in described query categories or key word are spliced into character according to preset rules
String, inquires about the data relevant to described data to be checked by described character string in buffer storage
Information, wherein, is cached with in data base the inquiry meeting preset buffer memory condition in buffer storage
Data message;
Described data message is showed the client of the data inquiry request that user selects.
Optionally, keyword or the key word of described query categories includes: with described number to be checked
According to relevant big class and the keyword of group or key word.
Optionally, described by the keyword in described query categories or key word according to preset rules
It is spliced into character string, including:
Keyword according to query categories or key word, obtain big category information in described query categories
And/or little category information;
Keyword in described big category information and/or little category information or key word are carried out splicing raw
Become character string.
Optionally, described method also includes:
Inquired about in described buffer storage and described data phase to be checked by described character string
During the data message closed, if without the data relevant to described data to be checked in described buffer storage
Information, then inquire about the number relevant to described data to be checked by described character string in data base
It is believed that breath;
Data message relevant to described data to be checked for inquiry in the database is shown
To the client of the data inquiry request that user selects.
Optionally, described method also includes:
Relevant to described data to be checked for inquiry in the database is met preset buffer memory
The data message of condition is cached to described buffer storage.
Second aspect, present invention also offers a kind of device improving efficiency data query, including:
Receiver module, for receiving the data inquiry request that user selects, described data query please
Seek keyword or the key word including the query categories relevant to data to be checked;
String-concatenation module, for by the keyword in described query categories or key word according to
Preset rules is spliced into character string;
First enquiry module, is treated with described for being inquired about in buffer storage by described character string
The data message that inquiry data are relevant, wherein, buffer storage is cached with in data base meet pre-
If the data message inquired about of caching condition;
First sending module, for the data query that described data message shows user select
The client of request.
Optionally, keyword or the key word of described query categories includes: with described number to be checked
According to relevant big class and the keyword of group or key word.
Optionally, described string-concatenation module, specifically for:
Keyword according to query categories or key word, obtain big category information in described query categories
And/or little category information;
Keyword in described big category information and/or little category information or key word are carried out splicing raw
Become character string.
Optionally, described device also includes:
Second enquiry module, for inquire about in described buffer storage by described character string and
During the data message that described data to be checked are correlated with, if without to be checked with described in described buffer storage
Ask the data message that data are relevant, then inquired about in data base by described character string and treat with described
The data message that inquiry data are relevant;
Second sending module, for inquiring about in the database and described data phase to be checked
The data message closed shows the client of the data inquiry request that user selects.
Optionally, described device also includes:
3rd sending module, for inquiring about in the database and described data phase to be checked
The data message meeting preset buffer memory condition closed is cached to described buffer storage.
As shown from the above technical solution, a kind of side improving efficiency data query that the present invention provides
Method and device, look into relevant to data to be checked in the inquiry request that user is selected by the method
Ask keyword or the key word of classification, and be spliced into character string, by character string at caching
Device is inquired about the data message relevant to data to be checked, and not be used in data base inquiry,
Substantially increase the efficiency of data query, alleviate system load, reduce user and inquire about the waiting time,
Improve Consumer's Experience.
Accompanying drawing explanation
A kind of method improving efficiency data query that Fig. 1 provides for one embodiment of the invention
Schematic flow sheet;
A kind of device improving efficiency data query that Fig. 2 provides for one embodiment of the invention
Structural representation.
Detailed description of the invention
Below in conjunction with the accompanying drawings, the detailed description of the invention of invention is further described.Hereinafter implement
Example is only used for clearly illustrating technical scheme, and can not limit this with this
Bright protection domain.
Fig. 1 shows a kind of method improving efficiency data query that the embodiment of the present invention provides
Schematic flow sheet, as it is shown in figure 1, the method comprises the steps:
101, receive user select data inquiry request, described data inquiry request include with
The keyword of the query categories that data to be checked are relevant or key word;
Concrete, keyword or the key word of described query categories include: with described number to be checked
According to relevant big class and the keyword of group or key word.
102, the keyword in described query categories or key word are spliced into according to preset rules
Character string, inquires about relevant to described data to be checked in buffer storage by described character string
Data message, wherein, is cached with in buffer storage in data base and has met preset buffer memory condition
The data message of inquiry;
Wherein preset buffer memory condition can according to visit capacity and data within a period of time more
New number of times is configured.
103, described data message is showed the client of the data inquiry request that user selects.
The inquiry relevant to data to be checked in the inquiry request that user is selected by said method
The keyword of classification or key word, and it is spliced into character string, by character string at caching dress
Put the data message that middle inquiry is relevant to data to be checked, and not be used in data base inquiry, greatly
Improve greatly the efficiency of data query, alleviate system load, reduce user and inquire about the waiting time,
Improve Consumer's Experience.
In above-mentioned steps 101, user inquiry time, select corresponding condition i.e. with inquiry number
Inquire about according to relevant classification.Here query categories need not user and is manually entered, permissible
The form such as single choice or combobox of offer, so can control the quantity of querying condition.
It will be appreciated that above-mentioned classification includes big class and group, such as inquire about cookie, its inquiry
Classification may include that food, cookies, cookies etc., and the biggest class can be food, cake
Dry, group is cookies, and ultimately producing character string is the dry cookies of food pie.
By the keyword in described query categories or key word according to default rule in above-mentioned steps 102
Then it is spliced into character string, including following sub-step:
1021, according to keyword or the key word of query categories, obtain in described query categories big
Category information and/or little category information;
1022, the keyword in described big category information and/or little category information or key word are carried out
Splicing generates character string.
In another kind of attainable mode, described method also includes the step not shown in Fig. 1:
104, inquired about in described buffer storage and described number to be checked by described character string
During according to relevant data message, if without relevant to described data to be checked in described buffer storage
Data message, then inquire about relevant to described data to be checked in data base by described character string
Data message;
105, the data message relevant to described data to be checked will be inquired about in the database
Show the client of the data inquiry request that user selects.
106, by relevant to described data to be checked for inquiry in the database meet default
The data message of caching condition is cached to described buffer storage.
In said method after receiving request, querying condition is spliced into character string as
Key, inquires about either with or without corresponding result from caching with this key.If postponed according to key
Deposit middle inquiry less than result, do not did caching before illustrating or caching is the most expired, at this moment
Wait and need to inquire about from data base, and result is met the data message caching of preset buffer memory condition
In caching, in case next time, inquiry used;If there being the result of correspondence in Huan Cun, directly take out
Return to client.
Concrete, above-mentioned buffer storage JCS is a Cache Framework.It is a combined type
Buffering instrument, can be by target buffer to internal memory, hard disk, and having the buffer object time expired sets
Fixed, it is also possible to built the distributed architecture with buffering by JCS, to realize high performance answering
With.The frequently access of some needs is often accessed to the object consuming the most very much resource, can
To be temporarily stored in relief area, the performance of service so can be improved.Buffering instrument is for reading
Operate and improve highly significant far more than the application performance of write operation.
Use JCS can configure corresponding parameter, as cached in the quantity of effective time, caching
Limit etc., can configure the most rational parameter according to the feature of oneself system.
Said method is big especially for data volume, data seldom update (as 1 year updates one
Secondary), the little inquiry system of Query Result content, in order to improve search efficiency, it is possible to use
Caching technology, puts buffer storage into, directly from caching when of inquiry next time by the result of inquiry
Device reads, it is not necessary in huge data base, re-start the retrieval of complexity, computing, from
Buffer storage is inquired about data to exceed much than the efficiency inquiring about data from data base.
Fig. 2 shows a kind of device improving efficiency data query that the embodiment of the present invention provides
Structural representation, as in figure 2 it is shown, this device includes: receiver module 21, string-concatenation mould
Block the 22, first enquiry module the 23, first sending module 24.
Receiver module 21, for receiving the data inquiry request that user selects, described data query
Request includes keyword or the key word of the query categories relevant to data to be checked;
Wherein, keyword or the key word of described query categories includes: with described data to be checked
Relevant big class and the keyword of group or key word.
String-concatenation module 22, for pressing the keyword in described query categories or key word
It is spliced into character string according to preset rules;
First enquiry module 23, for inquiring about with described in buffer storage by described character string
The data message that data to be checked are relevant, wherein, is cached with in data base in buffer storage and meets
The data message inquired about of preset buffer memory condition;
First sending module 24, for looking into the data that described data message shows user to select
Ask the client of request.
Described string-concatenation module 22, specifically for:
Keyword according to query categories or key word, obtain big category information in described query categories
And/or little category information;
Keyword in described big category information and/or little category information or key word are carried out splicing raw
Become character string.
Said apparatus also includes not shown in Fig. 2: the second enquiry module 25, second sends mould
Block the 26, the 3rd sending module 27.
Second enquiry module 25, for inquiring about in described buffer storage by described character string
During relevant to described data to be checked data message, if without treating with described in described buffer storage
The data message that inquiry data are relevant, then inquired about with described in data base by described character string
The data message that data to be checked are relevant;
Second sending module 26, for inquiring about in the database and described data to be checked
Relevant data message shows the client of the data inquiry request that user selects.
3rd sending module 27, for inquiring about in the database and described number to be checked
It is cached to described buffer storage according to the relevant data message meeting preset buffer memory condition.
Assembly of the invention and method are one to one, will no longer carry out specifically in a device
Bright.
In the description of the present invention, illustrate a large amount of detail.It is to be appreciated, however, that this
Inventive embodiment can be put into practice in the case of not having these details.At some examples
In, it is not shown specifically known method, structure and technology, in order to not fuzzy to this specification
Understanding.
It is last it is noted that various embodiments above is only in order to illustrate technical scheme,
It is not intended to limit;Although the present invention being described in detail with reference to foregoing embodiments,
It will be understood by those within the art that: it still can be to described in foregoing embodiments
Technical scheme modify, or the most some or all of technical characteristic carried out equivalent replace
Change;And these amendments or replacement, do not make the essence of appropriate technical solution depart from the present invention each
The scope of embodiment technical scheme, it all should be contained in the claim of the present invention and description
In the middle of scope.
Claims (10)
1. the method improving efficiency data query, it is characterised in that including:
Receiving the data inquiry request that user selects, described data inquiry request includes with to be checked
The keyword of the query categories that data are relevant or key word;
Keyword in described query categories or key word are spliced into character according to preset rules
String, inquires about the data relevant to described data to be checked by described character string in buffer storage
Information, wherein, is cached with in data base the inquiry meeting preset buffer memory condition in buffer storage
Data message;
Described data message is showed the client of the data inquiry request that user selects.
Method the most according to claim 1, it is characterised in that the pass of described query categories
Key word or key word include: the big class relevant to described data to be checked and the keyword of group or
Key word.
Method the most according to claim 2, it is characterised in that described by described inquiry class
Keyword or key word in not are spliced into character string according to preset rules, including:
Keyword according to query categories or key word, obtain big category information in described query categories
And/or little category information;
Keyword in described big category information and/or little category information or key word are carried out splicing raw
Become character string.
Method the most according to claim 1, it is characterised in that described method also includes:
Inquired about in described buffer storage and described data phase to be checked by described character string
During the data message closed, if without the data relevant to described data to be checked in described buffer storage
Information, then inquire about the number relevant to described data to be checked by described character string in data base
It is believed that breath;
Data message relevant to described data to be checked for inquiry in the database is shown
To the client of the data inquiry request that user selects.
Method the most according to claim 4, it is characterised in that described method also includes:
Relevant to described data to be checked for inquiry in the database is met preset buffer memory
The data message of condition is cached to described buffer storage.
6. the device improving efficiency data query, it is characterised in that including:
Receiver module, for receiving the data inquiry request that user selects, described data query please
Seek keyword or the key word including the query categories relevant to data to be checked;
String-concatenation module, for by the keyword in described query categories or key word according to
Preset rules is spliced into character string;
First enquiry module, is treated with described for being inquired about in buffer storage by described character string
The data message that inquiry data are relevant, wherein, buffer storage is cached with in data base meet pre-
If the data message inquired about of caching condition;
First sending module, for the data query that described data message shows user select
The client of request.
Device the most according to claim 6, it is characterised in that the pass of described query categories
Key word or key word include: the big class relevant to described data to be checked and the keyword of group or
Key word.
Device the most according to claim 7, it is characterised in that described string-concatenation mould
Block, specifically for:
Keyword according to query categories or key word, obtain big category information in described query categories
And/or little category information;
Keyword in described big category information and/or little category information or key word are carried out splicing raw
Become character string.
Device the most according to claim 6, it is characterised in that described device also includes:
Second enquiry module, for inquire about in described buffer storage by described character string and
During the data message that described data to be checked are correlated with, if without to be checked with described in described buffer storage
Ask the data message that data are relevant, then inquired about in data base by described character string and treat with described
The data message that inquiry data are relevant;
Second sending module, for inquiring about in the database and described data phase to be checked
The data message closed shows the client of the data inquiry request that user selects.
Device the most according to claim 9, it is characterised in that described device also includes:
3rd sending module, for inquiring about in the database and described data phase to be checked
The data message meeting preset buffer memory condition closed is cached to described buffer storage.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510144447.0A CN106156061A (en) | 2015-03-30 | 2015-03-30 | A kind of method and device improving efficiency data query |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510144447.0A CN106156061A (en) | 2015-03-30 | 2015-03-30 | A kind of method and device improving efficiency data query |
Publications (1)
Publication Number | Publication Date |
---|---|
CN106156061A true CN106156061A (en) | 2016-11-23 |
Family
ID=57340295
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201510144447.0A Pending CN106156061A (en) | 2015-03-30 | 2015-03-30 | A kind of method and device improving efficiency data query |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN106156061A (en) |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107133300A (en) * | 2017-04-27 | 2017-09-05 | 福建中金在线信息科技有限公司 | A kind of data query method and device |
CN108280227A (en) * | 2018-01-26 | 2018-07-13 | 北京奇虎科技有限公司 | Data information processing method based on caching and device |
CN108470043A (en) * | 2018-02-27 | 2018-08-31 | 阿里巴巴集团控股有限公司 | A kind of acquisition methods and device of business result |
CN109447741A (en) * | 2018-10-16 | 2019-03-08 | 翟红鹰 | Improve method, system, equipment and the storage medium of trading processing speed |
CN110399438A (en) * | 2018-04-24 | 2019-11-01 | 北京视联动力国际信息技术有限公司 | A kind of GIS point information query method and device |
CN113127732A (en) * | 2021-03-23 | 2021-07-16 | 金蝶蝶金云计算有限公司 | Method and device for acquiring service data, computer equipment and storage medium |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20020091667A1 (en) * | 2000-07-13 | 2002-07-11 | Amit Jaipuria | Method and apparatus for optimizing networking potential using a secured system for an online community |
CN101650718A (en) * | 2008-08-15 | 2010-02-17 | 华为技术有限公司 | Method and device for matching character strings |
CN102012931A (en) * | 2010-12-01 | 2011-04-13 | 北京瑞信在线系统技术有限公司 | Filter cache method and device, and cache system |
CN102902730A (en) * | 2012-09-10 | 2013-01-30 | 新浪网技术(中国)有限公司 | Method and device for reading data based on data cache |
CN102930054A (en) * | 2012-11-19 | 2013-02-13 | 北京奇虎科技有限公司 | Data search method and data search system |
-
2015
- 2015-03-30 CN CN201510144447.0A patent/CN106156061A/en active Pending
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20020091667A1 (en) * | 2000-07-13 | 2002-07-11 | Amit Jaipuria | Method and apparatus for optimizing networking potential using a secured system for an online community |
CN101650718A (en) * | 2008-08-15 | 2010-02-17 | 华为技术有限公司 | Method and device for matching character strings |
CN102012931A (en) * | 2010-12-01 | 2011-04-13 | 北京瑞信在线系统技术有限公司 | Filter cache method and device, and cache system |
CN102902730A (en) * | 2012-09-10 | 2013-01-30 | 新浪网技术(中国)有限公司 | Method and device for reading data based on data cache |
CN102930054A (en) * | 2012-11-19 | 2013-02-13 | 北京奇虎科技有限公司 | Data search method and data search system |
Cited By (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107133300A (en) * | 2017-04-27 | 2017-09-05 | 福建中金在线信息科技有限公司 | A kind of data query method and device |
CN108280227A (en) * | 2018-01-26 | 2018-07-13 | 北京奇虎科技有限公司 | Data information processing method based on caching and device |
CN108470043A (en) * | 2018-02-27 | 2018-08-31 | 阿里巴巴集团控股有限公司 | A kind of acquisition methods and device of business result |
CN110399438A (en) * | 2018-04-24 | 2019-11-01 | 北京视联动力国际信息技术有限公司 | A kind of GIS point information query method and device |
CN110399438B (en) * | 2018-04-24 | 2022-04-05 | 视联动力信息技术股份有限公司 | GIS point location information query method and device |
CN109447741A (en) * | 2018-10-16 | 2019-03-08 | 翟红鹰 | Improve method, system, equipment and the storage medium of trading processing speed |
CN113127732A (en) * | 2021-03-23 | 2021-07-16 | 金蝶蝶金云计算有限公司 | Method and device for acquiring service data, computer equipment and storage medium |
CN113127732B (en) * | 2021-03-23 | 2024-02-20 | 金蝶蝶金云计算有限公司 | Service data acquisition method, device, computer equipment and storage medium |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN106156061A (en) | A kind of method and device improving efficiency data query | |
US10346432B2 (en) | Compaction policy | |
CN105550338B (en) | A kind of mobile Web cache optimization method based on HTML5 application cache | |
Zhao et al. | Dache: A data aware caching for big-data applications using the MapReduce framework | |
US7331038B1 (en) | Predictive prefetching to improve parallelization of document generation subtasks | |
CN104834675B (en) | A kind of Query Optimization method based on user behavior analysis | |
CN109240946A (en) | The multi-level buffer method and terminal device of data | |
CN106294374B (en) | The method and data query system that small documents merge | |
CN109271355A (en) | A kind of method and device of cleaning journal file caching | |
CN103368986A (en) | Information recommendation method and information recommendation device | |
CN106464669B (en) | Intelligent file prefetching based on access patterns | |
US9292454B2 (en) | Data caching policy in multiple tenant enterprise resource planning system | |
CN109446222A (en) | A kind of date storage method of Double buffer, device and storage medium | |
CN110310060A (en) | Inventory management method and device based on fragment | |
CN104850627A (en) | Method and apparatus for performing paging display | |
US20210216565A1 (en) | Interactive dataflow preview | |
CN105577841A (en) | File synchronization method, device, client, server side and device | |
CN106210015A (en) | A kind of cloud storage method of temperature data buffer storage in mixed cloud structure | |
US11645281B1 (en) | Caching query plans in database systems | |
DE202023101653U1 (en) | Cross-organization and cross-cloud automated data pipelines | |
JP2001101061A (en) | Cache server | |
WO2020014087A1 (en) | System and method for taxonomic analysis of a website | |
US10572562B2 (en) | Methods and systems for performing time-partitioned collaborative filtering | |
US20130031050A1 (en) | System, Method, and Computer Program Product for Accessing Manipulating Remote Datasets | |
CA2589508A1 (en) | Cache for an enterprise software system |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20161123 |
|
RJ01 | Rejection of invention patent application after publication |