CN105912627A - Data search system and method - Google Patents
Data search system and method Download PDFInfo
- Publication number
- CN105912627A CN105912627A CN201610213480.9A CN201610213480A CN105912627A CN 105912627 A CN105912627 A CN 105912627A CN 201610213480 A CN201610213480 A CN 201610213480A CN 105912627 A CN105912627 A CN 105912627A
- Authority
- CN
- China
- Prior art keywords
- data
- keyword
- server end
- interim table
- user side
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2477—Temporal data queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
Abstract
The invention discloses a data search system and method. The data search system and method are characterized in that: a client receives a keyword input by a user, and the keyword is a Chinese character or a letter; a transmission module asynchronously transmits keyword data to a server; the server receives the keyword data, determines the type of the keyword, queries data from a database of the server if the keyword is the Chinese character, and transmits the query result to the client through the transmission module; if the keyword is the letter, the server determines if the database has a temporary table or not; the server queries data from the temporary table if so, and transmits the query result to the client through the transmission module; and the server establishes a temporary table if not, fetches out original data in the database, and converts the original data into letter data to be stored in the temporary table; and then the server queries data from the established temporary table and transmits the query result to the client through the transmission module.
Description
Technical field
The present invention relates to data searching technology field, particularly relate to one and utilize AJAX asynchronous transmission dynamic
Realize data searching technology.
Background technology
Internet develops the most with surprising rapidity, and the page quantity in network has reached tens billion of, tradition
Search method be no longer desirable for WEB information retrieval, search engine become important Web Search Tools it
One.Traditional search engine is based on disposable " request-response " pattern (i.e. synchronous transfer module), search
Engine mates with described request according to user's request quickly acquirement from many numerous and jumbled internet datas
Data utilize for user, and therefore search speed and matching degree also become the important indicator of its execution efficiency, especially
It is under Chinese search environment, owing to Chinese is not as English such, it is only necessary to according to the order arrangement of letter
Combination just can scan for, easily when not affecting search speed and matching degree, for making user
Also can use input Pinyin, alphabetic mode search-related data under Chinese search environment, existing Chinese is searched
Index is held up provides combobox search matching feature at user's inputting interface, after user inputs letter or phonetic,
Occur that combobox options for user clicks and input some the contents mated with it.Though the method can provide user
Chinese character or phonetic/alphabetic search is carried out, so for providing this combobox search coupling under Chinese search environment
Function, prior art uses manual entry mode to arrange the content that combobox shows, if number to be arranged
Still use manual entry mode according to when measuring the biggest, not only waste time and energy, but also there will be data record
Enter mistake.
Therefore, it is necessary to propose a kind of new data searching technology, to avoid above-mentioned existing search technique institute face
The problems faced, have become the difficult problem that current industry urgently overcomes in fact.
Summary of the invention
In view of the disappearance of above-mentioned prior art, the purpose of the present invention is to propose a kind of new data search system
And method, its can automatic dynamic typing multiple coupling function of search with realize Chinese character, phonetic search conversion, keep away
The problems such as low, the error in data of efficiency that manpower-free's typing conversion causes.
Another object of the present invention is to propose a kind of new data search system and method, and it can provide asynchronous
Function of search, substep completes search, and user scans for operation without waiting for the most sustainable.
For reaching above-mentioned and other purpose, the present invention proposes a kind of data search system, including: user side,
Receiving the keyword of user's input, described keyword is Chinese character or letter；Transport module, by described keyword
Data asynchronous transmission is to server end；Server end, receives described key data, it is judged that described keyword
Type, if Chinese character, then from the data base querying data of described server end, and Query Result is passed through
Described transport module is transmitted back to described user side, if alphabetical, the most described server end judges described database
In whether there is interim table, if then inquiring about data from this interim table, and by Query Result through described transmission
Module is transmitted back to described user side, if there is not described interim table, then creates interim table, and by described data
Initial data taking-up in storehouse is converted into alphabet data and is stored in described interim table, interim from being created afterwards
Table inquiry data also return to described user side through described transport module.
It is preferred that the server end of the present invention includes: judge module, for judging the class of described keyword
Type；Creation module, is used for creating described interim table；Modular converter, original for by described database
Data taking-up is converted into alphabet data and is stored in described interim table；And enquiry module, for from described number
The data with described keyword match are inquired about according to storehouse or described interim table；
It is preferred that the interim table of the present invention is previously stored in internal memory.
It is preferred that described server end also includes data processing module, for described transport module is transmitted
Key data carry out processing to remove dangerous character, such as the character such as *, space.
It is preferred that described transport module uses AJAX (Asynchronous JavaScript XML) data lattice
Described critical word transfer is given described server end by formula.
The present invention also proposes a kind of method utilizing above-mentioned search system to carry out data search, and the method includes:
Step S1: user inputs keyword from user side, described keyword is Chinese character or letter；Step S2: will
Described key data asynchronous transmission is to server end；Step S3: server end judges the class of described keyword
Type, if Chinese character then performs step S4, if letter then performs step S5；Step S4: from described service
The data base querying of device end returns to described user side with the data of described keyword match；Step S5: described
Server end judges whether to store the interim table of alphabet data, if having, enters step S8, if without,
Enter step S6；Step S6: create an interim table；Step S7: take out initial data from described database
And convert thereof into phonetic data and be stored in the interim table created；Step S8: inquire about from described interim table
Described user side is returned to the data of described keyword match.
It is preferred that in the method step S2 of the present invention, be to use AJAX by described critical word transfer to institute
State server end.
It is preferred that in the method step S3 of the present invention, at described received server-side to described number of keyword
Also include removing the step of dangerous character in described keyword according to rear.
It is preferred that in the method step S6 of the present invention, be to use SQL (Structured Query
Language, SQL) the statement described interim table of establishment.
Compared with prior art, the keyword that the present invention mainly inputs for user at server end is carried out
Classified inquiry, if the keyword of input is that Chinese character returns to user directly from data base querying data, if
The keyword of input is that letter is then inquired about (if this interim table does not exists, then by server end from interim table
First set up described interim table), the interim table of the present invention dynamically can be given birth to according to the initial data in database
Become, and do not change initial data structure, compared with prior art employing manual entry mode, the present invention
Human cost can be saved and can ensure that in interim table, data are errorless and then can promote data search matching degree；
Furthermore, the interim table of the present invention be stored in internal memory can, can quickly read, and then data search can be promoted
Speed.And, the present invention utilizes such as AJAX to make user side and server end carry out the asynchronous biography of data
Defeated, it is possible to make user side and server end response, mutual asynchronization.
Accompanying drawing explanation
Below by the way of the most understandable, accompanying drawings preferred embodiment, to a kind of data search
Above-mentioned characteristic, technical characteristic, advantage and the implementation thereof of system and method are further described.
Fig. 1 is the basic framework figure of the data search system of the present invention；And
Fig. 2 is the data search method flow chart of the present invention.
Drawing reference numeral illustrates:
10. user side, 11. transport modules, 12. server ends, 120. judge modules, 121. creation modules, 122.
Enquiry module, 123. interim tables, 124. databases, 125. modular converters.
Detailed description of the invention
In order to be illustrated more clearly that the embodiment of the present invention or technical scheme of the prior art, will compare attached below
The detailed description of the invention of the figure explanation present invention.It should be evident that the accompanying drawing in describing below is only the present invention
Some embodiments, for those of ordinary skill in the art, on the premise of not paying creative work,
Other accompanying drawing can also be obtained according to these accompanying drawings, and obtain other embodiment.
For making simplified form, only schematically show part related to the present invention in each figure, they are also
Do not represent its practical structures as product.It addition, so that simplified form readily appreciates, have in some figure
There are the parts of identical structure or function, only symbolically depict one of them, or only marked therein
One.In this article, " one " not only represents " only this ", it is also possible to represent the situation of " more than one ".
Refer to Fig. 1, the data search system basic framework schematic diagram of its display present invention.As it is shown in figure 1,
The data search system of the present invention includes user side 10, transport module 11 and server end 12, the most right
Each part of the present invention describes in detail.
User side 10, for user input its search data keyword, the described keyword for example, Chinese
Word or letter, described letter for example, phonetic transcriptions of Chinese characters or Chinese character initial phonetic.
Transport module 11, carries out data exchange transmission for user side 10 and server end, and transport module 11 will be used
The key data asynchronous transmission of family end 10 input is to server end, and the inquiry number that can be returned by server end
According to being transferred to user side.In the present embodiment, the use AJAX (Asynchronous of transport module 11
JavaScript XML) key data described in asynchronous transmission is server end 12.In the present embodiment, user
Inputting interface (such as keyboard) the input keyword triggering JavaScript provided through user side 10 calls
AJAX, is created the such as XMLHttpRequest request comprising described keyword by AJAX, and please by being created
Asking and be transferred to server end 12, server end 12 responds for described request, and by Query Result with word
Symbol string or XML format return to AJAX, AJAX Query Result is transferred to user side 10.
Server end 12, is connected with transport module 11, receives described number of keyword, to described key word type
Judge, and carry out subsequent query process for key word type.As it is shown in figure 1, server end 12 enters
One step includes judge module 120, creation module 121, enquiry module 122, interim table 123, database 124.
Hereinafter i.e. each part of server end 12 is described in detail.
Key word type received by server end 12 is judged by judge module 120, i.e. judges described
Keyword is Chinese character or letter, if described keyword is letter, it is judged that module 120 also needs to judge server
Whether end 12 exists interim table 123, final judge module 120 can will determine that result export to enquiry module 122,
Creation module 121.
At judge module 120, creation module 121, judges that server end is created when there is not interim table 123 the most automatically
Building interim table, in the present embodiment, creation module 121 uses SQL statement to create interim table, is created the storage of interim table
In the internal memory of presence server end 12.Modular converter 125 takes out initial data in database 124 afterwards, and
Utilize Chinese character conversion phonetic technology that described initial data is converted into phonetic transcriptions of Chinese characters or Chinese character initial phonetic, and
Initial data is stored in what creation module was created with phonetic transcriptions of Chinese characters or Chinese character initial phonetic one_to_one corresponding
In interim table 123.
Enquiry module 122, carries out data query according to the judged result of judge module.If it is determined that module 120
Judge that the keyword that user side 10 inputs is Chinese character, then directly from the initial data of database directly inquiry with
The data of described keyword match, and the data inquired about are returned to transport module 11, by transport module 11
By described data re-transmission to user side 10.If it is determined that module 120 judges that the keyword that user side inputs is
Letter, then inquiry and the data of described keyword match in interim table 123, and the data inquired about are returned
Back to transport module 11, by transport module 11 by described data re-transmission to user side 10.
In other embodiments of the present invention, it is with the difference of embodiment illustrated in fig. 1, in the present embodiment
Server end 12 also include processing module (not shown), for key that transport module 11 is transmitted
Digital data processes, to remove dangerous character.
The method detailed process such as figure of data search is performed through the data search system shown in Fig. 1 of the present invention
Shown in 2, described data search method comprises the following steps.
Step S1: inputted keyword at user side 10 by user.
Step S2: key data step S1 inputted by transport module 11 is according to being transferred to server end
12。
Step S3: judge module 120 first-selection of server end 12 judges whether the type of described keyword is the Chinese
Word, if described keyword is Chinese character, the most directly performs step S8, and otherwise identifying described keyword is letter,
Then perform step S4.
Step S4: judge module 120 continues to judge whether server end 12 exists interim table, if existing, holds
Row step S7, if not existing, performs subsequent step S5.
Step S5: creation module 122 creates interim table 123.
Step S6: modular converter 125 takes out initial data in database 124 and utilizes Chinese character to change phonetic skill
Described initial data is converted into phonetic transcriptions of Chinese characters or Chinese character initial phonetic by art, and initial data is spelled with Chinese character
Sound or Chinese character initial phonetic one_to_one corresponding are stored in the interim table 123 that step S5 is created.
Step S7: enquiry module 122 inquires about the data with described keyword match in interim table 123, and will
The data inquired about return to transport module 11, transport module 11 data of inquiry are transferred to user side.
Step S8: enquiry module 122 returns to institute from the data of database 124 inquiry with described keyword match
State user side 10.
The present invention also proposes a kind of data search method, and it is with the difference of said method, described step S3
In, also include removing in described keyword uneasy after described server end 12 receives described key data
The step of all-character.
It should be noted that, above-described embodiment all can independent assortment as required.The above is only this
Bright preferred embodiment, it is noted that for those skilled in the art,
Without departing from the principles of the invention, it is also possible to make some improvements and modifications, these improve and profit
Decorations also should be regarded as protection scope of the present invention.
Claims (8)
1. a data search system, it is characterised in that including:
User side, receives the keyword of user's input, and described keyword is Chinese character or letter；
Transport module, by described key data asynchronous transmission to server end；And
Server end, receive described key data, judge the type of described keyword, if Chinese character, then from the data base querying data of described server end, and Query Result is transmitted back to described user side through described transport module, if it is alphabetical, the most described server end judges whether to exist in described database interim table, if then inquiring about data from this interim table, and Query Result is transmitted back to described user side through described transport module, if there is not described interim table, then create interim table, and the initial data in described database taken out be converted into alphabet data and be stored in described interim table, afterwards from being created interim table inquiry data and returning to described user side through described transport module.
2. data search system as claimed in claim 1, it is characterised in that: described server end also includes:
Judge module, for judging the type of described keyword；
Creation module, is used for creating described interim table；
Modular converter, is stored in described interim table for the initial data taking-up in described database is converted into alphabet data；And
Enquiry module, for inquiring about the data with described keyword match from described database or described interim table.
3. data search system as claimed in claim 1, it is characterised in that: described server end also includes data processing module, processes to remove dangerous character for the key data being transmitted described transport module.
4. data search system as claimed in claim 1, it is characterised in that: described transport module is to utilize Asynchronous JavaScript XML engine by described critical word transfer to described server end.
5. a data search method, it is characterised in that including:
Step S1: user inputs keyword from user side, described keyword is Chinese character or letter；
Step S2: by described key data asynchronous transmission to server end；
Step S3: server end judges the type of described keyword, if Chinese character then performs step S4, if letter then performs step S5；
Step S4: return to described user side from the data of the data base querying of described server end Yu described keyword match；
Step S5: described server end judges whether to store the interim table of alphabet data, if having, enters step S8, if without, enter step S6；
Step S6: create an interim table；
Step S7: take out initial data from described database and convert thereof into phonetic data and be stored in the interim table created；
Step S8: return to described user side from the data of the inquiry of described interim table with described keyword match.
6. data search method as claimed in claim 5, it is characterised in that: in described step S2, be through Asynchronous JavaScript XML engine by described critical word transfer to described server end.
7. data search method as claimed in claim 5, it is characterised in that: in described step S3, after described received server-side to described key data, also include removing the step of dangerous character in described keyword.
8. data search method as claimed in claim 5, it is characterised in that: in described step S6, it is to use SQL statement to create described interim table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610213480.9A CN105912627A (en) | 2016-04-07 | 2016-04-07 | Data search system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610213480.9A CN105912627A (en) | 2016-04-07 | 2016-04-07 | Data search system and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105912627A true CN105912627A (en) | 2016-08-31 |
Family
ID=56745688
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610213480.9A Pending CN105912627A (en) | 2016-04-07 | 2016-04-07 | Data search system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105912627A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108509505A (en) * | 2018-03-05 | 2018-09-07 | 昆明理工大学 | A kind of character string retrieving method and device based on subregion even numbers group Trie |
| CN111737288A (en) * | 2020-06-05 | 2020-10-02 | 富途网络科技(深圳)有限公司 | Search control method, device, terminal equipment, server and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101546315A (en) * | 2008-03-25 | 2009-09-30 | 英业达股份有限公司 | System and method for judging data query of target language |
| CN101610393A (en) * | 2009-07-17 | 2009-12-23 | 深圳创维数字技术股份有限公司 | IPTV system and program information search system thereof and method |
| CN103186588A (en) * | 2011-12-30 | 2013-07-03 | 大连天维科技有限公司 | Pinyin searching method |
-
2016
- 2016-04-07 CN CN201610213480.9A patent/CN105912627A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101546315A (en) * | 2008-03-25 | 2009-09-30 | 英业达股份有限公司 | System and method for judging data query of target language |
| CN101610393A (en) * | 2009-07-17 | 2009-12-23 | 深圳创维数字技术股份有限公司 | IPTV system and program information search system thereof and method |
| CN103186588A (en) * | 2011-12-30 | 2013-07-03 | 大连天维科技有限公司 | Pinyin searching method |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108509505A (en) * | 2018-03-05 | 2018-09-07 | 昆明理工大学 | A kind of character string retrieving method and device based on subregion even numbers group Trie |
| CN108509505B (en) * | 2018-03-05 | 2022-04-12 | 昆明理工大学 | Character string retrieval method and device based on partition double-array Trie |
| CN111737288A (en) * | 2020-06-05 | 2020-10-02 | 富途网络科技(深圳)有限公司 | Search control method, device, terminal equipment, server and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8374849B1 (en) | Multi-language relevance-based indexing and search | |
| KR100372584B1 (en) | Method and system for data processing | |
| US8180753B1 (en) | Automatically extracting data from semi-structured documents | |
| US20100325169A1 (en) | Representing Markup Language Document Data in a Searchable Format in a Database System | |
| EP1411448A2 (en) | Data searching apparatus | |
| CN107341080B (en) | Test case management system and method | |
| US20170169131A1 (en) | Method and system for handling non-presence of elements or attributes in semi-structured data | |
| CN103970751A (en) | Multi-language web page converting system and method | |
| CN111400323A (en) | Data retrieval method, system, device and storage medium | |
| CN111190920A (en) | Data interactive query method and system based on natural language | |
| CN100456293C (en) | Information fast searching device, client end, system and method | |
| CN105912627A (en) | Data search system and method | |
| US20110302220A1 (en) | Sql processing for data conversion | |
| WO2006076665A1 (en) | Systems, methods, and software for retrieving information using multiple query languages | |
| US11620282B2 (en) | Automated information retrieval system and semantic parsing | |
| CN100442275C (en) | Method and system for indentifying Chinese address data | |
| CN101576897A (en) | File content retrieval system and file content retrieval method | |
| JPH0619756A (en) | Edi format conversion method | |
| CN103164458A (en) | Method and system for downloading patent abstract attached drawings | |
| US20230054519A1 (en) | Automatic creation of database objects | |
| JP4031921B2 (en) | Machine translation apparatus, machine translation method, and machine translation program | |
| CN114036269A (en) | Pinyin retrieval method, tool and client | |
| CN113760737A (en) | Data testing method and device | |
| CN101546315A (en) | System and method for judging data query of target language | |
| KR101739766B1 (en) | Apparatus and Method for similarity based keyword mapping in Semantic Search |
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 | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20160831 |
|
| WD01 | Invention patent application deemed withdrawn after publication |