CN105447063A - Database subject retrieval method and retrieval device thereof - Google Patents
Database subject retrieval method and retrieval device thereof Download PDFInfo
- Publication number
- CN105447063A CN105447063A CN201410520574.1A CN201410520574A CN105447063A CN 105447063 A CN105447063 A CN 105447063A CN 201410520574 A CN201410520574 A CN 201410520574A CN 105447063 A CN105447063 A CN 105447063A
- Authority
- CN
- China
- Prior art keywords
- data
- subject
- options
- unit
- key word
- 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)
Abstract
The invention relates to a database subject retrieval method and a retrieval device thereof. The retrieval method comprises the following steps: a step 1: inputting a keyword; a step 2: retrieving subject information from a cache of a client; when the data of a matched subject are not found in the cache, retrieving the data from a server and caching the data in the client; a step 3: storing the data in an object form and establishing an index for each object; a step 4: displaying retrieval data options; a step 5: locating the data options; and a step 6: confirming the selected data options. The invention further relates to a retrieval device for realizing the retrieval method.
Description
Technical field
The present invention relates to a kind of search method, particularly a kind of for database section object search method.The invention still further relates to a kind of indexing unit for realizing described search method.
Background technology
When accountant needs the typing of accounting original certificate, need this accounting original certificate to be entered into corresponding section now.And due to section's object quantity too many, open subject select interface to carry out subject selection again if adopted, then can cause complex operation, inefficiency.
Therefore, need accurately to search corresponding subject, and existing in generally search according to section's destination code or title.When carrying out section's object and searching, directly carry out in the server searching and calling, in the client corresponding subject data are shown.
But be all obtain from server end in real time during existing subject peek, when querying condition is identical, user often selects a subject just to need to server, get a number, causes server load to increase the weight of when visit capacity is huge, customer terminal webpage loads slowly, and Consumer's Experience is not good.
Meanwhile, in prior art when retrieving subject, needing operating personnel to confirm, causing inefficient operation, can not automatically retrieve.
Summary of the invention
The object of the invention is to overcome the shortcoming of prior art and deficiency, a kind of database section object search method is provided and realizes the indexing unit of described search method.
The present invention is achieved by the following technical solutions: a kind of database section object search method, comprises the following steps:
Step one: input key word;
Step 2: retrieve subject information from the buffer memory of client; When not found coupling section destination data in the buffer, data cached to client from service end retrieve data;
Step 3: adopt object form to store data, and index is set up to each object;
Step 4: display retrieve data option;
Step 5: data options is positioned;
Step 6: confirm the data options selected.
Compared to prior art, the present invention, by subject data are carried out buffer memory, alleviates the pressure of server.It is concrete by servers' data is cached to client: when querying condition is constant, client subject data obtain from caching data on client, when only having querying condition and last querying condition incomplete same, just from server end downloading data, thus alleviate large concurrent time pressure to server.
Further, in the data of client-cache, adopt the form of object to store data, and set up index for each object, support coupling and fuzzy matching two kinds of mode retrieve data completely, improve client end interface and play up and user operation efficiency.
As a further improvement on the present invention, the key word inputted in step one is subject code or Course in English; When using subject code, use the mode of exact matching, and by going to rear order to mate; When using Course in English, adopt fuzzy matching.Due to most of user to needing typing section object subject code, Course in English has clear or fuzzy memory, can remember by these, just subject can be inputted fast, accurately at main interface, and allow subject select interface to become the selection of small part user, become a kind of non-productive operation, thus lower performance requirement subject being selected to interface.
As a further improvement on the present invention, in step one, when being greater than 0.5 second the interval time inputting key word, then perform step 2.In order to accelerate effectiveness of retrieval, system starts to perform retrieval subject data manipulation automatically according to the key word inputted.
As a further improvement on the present invention, in step 4, use drop-down list display subject data options, the subject data options shown in described drop-down list is not more than 10, and focus is positioned on first option.
As a further improvement on the present invention, in step 5, by using mouse or keyboard, data options is positioned.
As a further improvement on the present invention, when using keyboard to carry out data options location, by up and down arrow keys, location is moved up and down to data options.
As a further improvement on the present invention, when confirming the data options selected, confirm by using the "enter" key" of mouse or keyboard.
The present invention also provides a kind of database section object indexing unit, comprising:
Recognition unit, it identifies the keyword message of input for detecting;
Search unit, it retrieves subject information according to keyword message in the buffer memory of client; When not found coupling section destination data in the buffer, data cached to client from service end retrieve data;
Storage unit, it adopts the form of object to store data, and sets up index to each object;
Display unit, it is for showing the data options of retrieval;
Option positioning unit, it is for locator data option;
Option confirmation unit, it selects data options for confirming.
As a further improvement on the present invention, when the key word that described recognition unit recognizes is subject code, use the mode of exact matching, and by going to rear order to mate; When the key word recognized is Course in English, adopt fuzzy matching mode.
As a further improvement on the present invention, when the input of the key word that recognition unit recognizes is greater than 0.5 second interval time, then search by described the retrieval that unit carries out key word automatically.
Below in conjunction with Figure of description, the present invention is described in detail.
Accompanying drawing explanation
Fig. 1 is the flow chart of steps of database subject search method of the present invention.
Fig. 2 is the anatomical connectivity schematic diagram of database subject indexing unit of the present invention.
Embodiment
Refer to Fig. 1, it is the flow chart of steps of database section of the present invention object search method.Database section of the present invention object search method, comprises the following steps:
S1: input key word.In the present embodiment, specifically comprise the following steps:
S11: the key word of input, described key word can be subject code or Course in English;
S12: judge key word, when using subject code, uses the mode of exact matching, and by going to rear order to mate; When using Course in English, adopt fuzzy matching.In the present embodiment, Course in English is used to be to use Chinese character or phonetic.
S13: judge the time interval of input key word, when being greater than 0.5 second the interval time inputting key word, then performing step S2, automatically retrieves.
S2: retrieve subject information according to key word from the buffer memory of client; When not found coupling section destination data in the buffer, data cached to client from service end retrieve data.
S3: adopt object form to store data, and index is set up to each object.
S4: display retrieve data option; In the present embodiment, especially by use drop-down list display subject data options, the subject data options shown in described drop-down list is not more than 10, and focus is positioned on first option by acquiescence automatically.
S5: data options is positioned; In the present embodiment, can position data options by using mouse or keyboard.Wherein, when using keyboard to carry out data options location, by up and down arrow keys, location being moved up and down to data options, not supporting circulation location, press the upper options that key navigates to current options, if options is first, do not perform any operation; Press the next options that key navigates to current options, if options is last, do not perform any operation.
S6: confirm the data options selected.In the present embodiment, when confirming the data options selected, confirm by using the "enter" key" of mouse or keyboard.By "enter" key" the option of locating in step S4 chosen and result is filled in Text Entry.Choose option and after filling result to text box, hide drop-down list.
Compared to prior art, the present invention, by caching data on client, alleviates server number of concurrent pressure, and sets up index to client data, thus supports fast finding data.According to query argument in the corresponding data of client-cache, data cachedly empty destruction along with the closedown of client, in other words, data cached life cycle is identical with client life cycle.
All obtain from server end in real time during existing subject peek, when querying condition is identical, user often selects a subject just to need to server, get a number, causes server load to increase the weight of when visit capacity is huge, customer terminal webpage loads slowly, and Consumer's Experience is not good.Because subject data movement is less, can according to query argument by the data buffer storage of correspondence to client, constant and when not closing client, from buffer memory, take out subject data at querying condition, decrease the number of times be connected with server, decrease taking of bandwidth.Time data cached, index is set up to data, the subject data that fast finding goes out to need under exact matching or fuzzy matching pattern.
Select operation for subject frequently, use caching technology not only alleviate server pressure, reduce taking of the network bandwidth, also improve the speed that client plays up the page, reduce period of reservation of number; Index technology is used to improve the efficiency of retrieve data from mass data; In input frame, using the subject data that auto-complete function assisted user quick-searching needs, subject data selection can be completed without the need to ejecting subject choice box.
Refer to Fig. 2, it is the anatomical connectivity schematic diagram of database subject indexing unit of the present invention.Present invention also offers a kind of indexing unit being applied to above-mentioned database section object search method, comprise recognition unit 1, search unit 2, storage unit 3, display unit 4, option positioning unit 5 and option confirmation unit 6.
Described recognition unit 1, it identifies the keyword message of input for detecting.When the key word that described recognition unit recognizes is subject code, use the mode of exact matching, and by going to rear order to mate; When the key word recognized is Course in English, adopt fuzzy matching mode.When the input of the key word that recognition unit recognizes is greater than 0.5 second interval time, then search by described the retrieval that unit carries out key word automatically.
Describedly search unit 2, it retrieves subject information according to keyword message in the buffer memory of client; When not found coupling section destination data in the buffer, data cached to client from service end retrieve data.
Described storage unit 3, it adopts the form of object to store data, and sets up index to each object.
Described display unit 4, it is for showing the data options of retrieval.In the present embodiment, described display unit is especially by use drop-down list display subject data options, and the subject data options shown in described drop-down list is not more than 10, and focus is positioned on first option by acquiescence automatically.
Described option positioning unit 5, it is for locator data option.In the present embodiment, described positioning unit is mouse or keyboard.Wherein, when using keyboard to carry out data options location, by up and down arrow keys, location is moved up and down to data options.
Described option confirmation unit 6, it selects data options for confirming.In the present embodiment, described option confirmation unit is that the "enter" key" of mouse or keyboard confirms.
Compared to prior art, the present invention, by subject data are carried out buffer memory, alleviates the pressure of server.It is concrete by servers' data is cached to client: when querying condition is constant, client subject data obtain from caching data on client, when only having querying condition and last querying condition incomplete same, just from server end downloading data, thus alleviate large concurrent time pressure to server.
The present invention is not limited to above-mentioned embodiment, if do not depart from the spirit and scope of the present invention to the various change of inventing or distortion, if these are changed and distortion belongs within claim of the present invention and equivalent technologies scope, then the present invention is also intended to comprise these changes and distortion.
Claims (10)
1. a database section object search method, comprises the following steps:
Step one: input key word;
Step 2: retrieve subject information from the buffer memory of client; When not found coupling section destination data in the buffer, data cached to client from service end retrieve data;
Step 3: adopt object form to store data, and index is set up to each object;
Step 4: display retrieve data option;
Step 5: data options is positioned;
Step 6: confirm the data options selected.
2. database section object search method according to claim 1, is characterized in that: the key word inputted in step one is subject code or Course in English; When using subject code, use the mode of exact matching, and by going to rear order to mate; When using Course in English, adopt fuzzy matching.
3. database section object search method according to claim 2, is characterized in that: in step one, when being greater than 0.5 second the interval time inputting key word, then performs step 2.
4. database section object search method according to claim 1, it is characterized in that: in step 4, use drop-down list display subject data options, the subject data options shown in described drop-down list is not more than 10, and focus is positioned on first option.
5. database section object search method according to claim 1, is characterized in that: in step 5, positions data options by using mouse or keyboard.
6. database section object search method according to claim 5, is characterized in that: when using keyboard to carry out data options location, move up and down location by up and down arrow keys to data options.
7. database section object search method according to claim 1, is characterized in that: when confirming the data options selected, and confirms by using the "enter" key" of mouse or keyboard.
8. a database section object indexing unit, is characterized in that: comprise
Recognition unit, it identifies the keyword message of input for detecting;
Search unit, it retrieves subject information according to keyword message in the buffer memory of client; When not found coupling section destination data in the buffer, data cached to client from service end retrieve data;
Storage unit, it adopts the form of object to store data, and sets up index to each object;
Display unit, it is for showing the data options of retrieval;
Option positioning unit, it is for locator data option;
Option confirmation unit, it selects data options for confirming.
9. database section object indexing unit according to claim 8, is characterized in that: when the key word that described recognition unit recognizes is subject code, uses the mode of exact matching, and by going to rear order to mate; When the key word recognized is Course in English, adopt fuzzy matching mode.
10. database section object indexing unit according to claim 9, is characterized in that: when the input of the key word that recognition unit recognizes is greater than 0.5 second interval time, then search by described the retrieval that unit carries out key word automatically.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410520574.1A CN105447063A (en) | 2014-09-30 | 2014-09-30 | Database subject retrieval method and retrieval device thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410520574.1A CN105447063A (en) | 2014-09-30 | 2014-09-30 | Database subject retrieval method and retrieval device thereof |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105447063A true CN105447063A (en) | 2016-03-30 |
Family
ID=55557245
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410520574.1A Pending CN105447063A (en) | 2014-09-30 | 2014-09-30 | Database subject retrieval method and retrieval device thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105447063A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106201539A (en) * | 2016-07-18 | 2016-12-07 | 浪潮通用软件有限公司 | A kind of method realizing accounting item dynamic calculation in Star Model |
| CN107608536A (en) * | 2017-09-25 | 2018-01-19 | 武汉优品鼎盛科技服务有限公司 | A kind of method and apparatus for being automatically performed data input |
| CN107622090A (en) * | 2017-08-22 | 2018-01-23 | 上海艾融软件股份有限公司 | Acquisition methods, the apparatus and system of object |
| CN109783791A (en) * | 2019-01-24 | 2019-05-21 | 陈德芹 | A kind of pre-trial audit statement generation method and device |
| CN113706010A (en) * | 2021-08-26 | 2021-11-26 | 北京沃东天骏信息技术有限公司 | Linkage processing method and device, equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101645086A (en) * | 2009-08-28 | 2010-02-10 | 用友软件股份有限公司 | Retrieval method |
| CN102279880A (en) * | 2011-07-28 | 2011-12-14 | 深圳市五巨科技有限公司 | Method and system for updating cache in real time |
| CN102307234A (en) * | 2011-08-24 | 2012-01-04 | 北京邮电大学 | Resource retrieval method based on mobile terminal |
| CN102682037A (en) * | 2011-03-18 | 2012-09-19 | 阿里巴巴集团控股有限公司 | Data acquisition method, system and device |
-
2014
- 2014-09-30 CN CN201410520574.1A patent/CN105447063A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101645086A (en) * | 2009-08-28 | 2010-02-10 | 用友软件股份有限公司 | Retrieval method |
| CN102682037A (en) * | 2011-03-18 | 2012-09-19 | 阿里巴巴集团控股有限公司 | Data acquisition method, system and device |
| CN102279880A (en) * | 2011-07-28 | 2011-12-14 | 深圳市五巨科技有限公司 | Method and system for updating cache in real time |
| CN102307234A (en) * | 2011-08-24 | 2012-01-04 | 北京邮电大学 | Resource retrieval method based on mobile terminal |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106201539A (en) * | 2016-07-18 | 2016-12-07 | 浪潮通用软件有限公司 | A kind of method realizing accounting item dynamic calculation in Star Model |
| CN107622090A (en) * | 2017-08-22 | 2018-01-23 | 上海艾融软件股份有限公司 | Acquisition methods, the apparatus and system of object |
| CN107622090B (en) * | 2017-08-22 | 2020-10-16 | 上海艾融软件股份有限公司 | Object acquisition method, device and system |
| CN107608536A (en) * | 2017-09-25 | 2018-01-19 | 武汉优品鼎盛科技服务有限公司 | A kind of method and apparatus for being automatically performed data input |
| CN109783791A (en) * | 2019-01-24 | 2019-05-21 | 陈德芹 | A kind of pre-trial audit statement generation method and device |
| CN113706010A (en) * | 2021-08-26 | 2021-11-26 | 北京沃东天骏信息技术有限公司 | Linkage processing method and device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102314439B (en) | The input method combined with application interface and equipment | |
| CN105447063A (en) | Database subject retrieval method and retrieval device thereof | |
| CN104252536B (en) | A kind of internet log data query method and device based on hbase | |
| CN110377908B (en) | Semantic understanding method, semantic understanding device, semantic understanding equipment and readable storage medium | |
| CN102262641B (en) | Online handwriting recognition system and method in network inquiry | |
| US20230221837A1 (en) | Coalescing Notifications Associated with Interactive Digital Content | |
| CN105988996B (en) | Index file generation method and device | |
| CN107085583B (en) | Electronic document management method and device based on content | |
| CN102982049B (en) | Methods and systems for implementing email recipient templates | |
| CN101876878A (en) | Word prediction input system and method | |
| CN103778133A (en) | Database object changing method and device | |
| CN107704202A (en) | A kind of method and apparatus of data fast reading and writing | |
| CN111552704A (en) | Data report generation method and device, computer equipment and storage medium | |
| CN104391941A (en) | Method for rapidly establishing full-text retrieval tool for common files | |
| WO2017196407A1 (en) | Forking digital content items between digital topical environments | |
| CN110533456A (en) | A kind of coupon information method for pushing, system and server | |
| CN101685459B (en) | Multi-media searching method and device | |
| US20140244408A1 (en) | Systems and methods for providing a gesture-based electronic ticket wheel | |
| CN102937975A (en) | Device and method for webpage search | |
| CN104021191A (en) | Method and system for providing solutions to mobile terminal related problems and server | |
| CN108255963A (en) | A kind of control method and device of the News Retrieval based on internet | |
| CN103123651A (en) | Method of rapidly searching multiple same-kind paper, device and mobile equipment | |
| CN103377246B (en) | Bookmark processing method and terminal browser | |
| CN102314224B (en) | A kind of method database adding of input method and equipment | |
| CN111552527A (en) | Method, device and system for translating characters in user interface and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | 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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160330 |