CN1601524A - Fuzzy inquiry system and method - Google Patents
Fuzzy inquiry system and method Download PDFInfo
- Publication number
- CN1601524A CN1601524A CN 03147001 CN03147001A CN1601524A CN 1601524 A CN1601524 A CN 1601524A CN 03147001 CN03147001 CN 03147001 CN 03147001 A CN03147001 A CN 03147001A CN 1601524 A CN1601524 A CN 1601524A
- Authority
- CN
- China
- Prior art keywords
- query
- fuzzy query
- fuzzy
- user
- submodule
- 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
Images
Abstract
The system includes multiple computers at client ends, a query server and a database. The query server includes a conditional setup module, an implementing query module and a module for outputting queried result. User through computer at client end sets up whether to carry out blur query or not and condition of carrying out blur query. Based on setting, implementing query module queries patent data accorded with blur condition from a database automatically, and queried result in graphic mode is output to computers at client ends. The method includes following procedures: selecting blur query, setting up query fields, inputting key words, generating query program through query program at background, executing blur query and generating query result. The said query result through computer at client end is outputted to user.
Description
[technical field]
The present invention particularly relates to a kind of system and method for carrying out fuzzy query in database about a kind of inquiry system and method.
[background technology]
Along with the arriving of information age, the user in database and utilize data base management system (DBMS) to carry out information integrated and management, obtains required information by Query Database with a large amount of information stores.Existing data base query method is often emphasized the how retrieval of more effective execution relevant information, promptly carries out accurately coupling at the searching keyword of user's input, and user's information that can inquire is just fewer like this.
China national Department of Intellectual Property on January 6th, 1999 disclosed application case number be 98116377.7 patent application case, its name is called " fuzzy input inquiry processing method of database ".This application case discloses a kind of disposal route of fuzzy input keyword query database.The index entry of the every notes record in its database is made of both characters of determined number, and the user imports both input codes of determined number, and each input code is corresponding at least one character.Character string according to input comprises the order of input code, and the character that can find out the index entry same position is all corresponding to all records of the input code of this input of character string.It is one unique and can not be the sign of sky that the deficiency of this application technology that case discloses is to be provided with the index entry of all records in the database, can be very loaded down with trivial details when data are very huge, and index entry just is difficult to revise once being provided with, so its inquiry underaction.In most cases, the user wishes to carry out fuzzy matching and carries out inquiry, promptly at keyword lookup and its same meaning or the close relevant information of input, therefore needs a kind of system and method that can carry out fuzzy query in database.
[summary of the invention]
Fundamental purpose of the present invention is to provide a kind of fuzzy query system and method, the inquiry field that it can be selected according to the user, in database synonym phrase in this field of inquiry with all identical or close information of searching keyword of input.
A further object of the present invention is to provide a kind of fuzzy query method, when the user imports in this synonym phrase any one word, can will inquire about in the lump with this word same meaning or close word in the synonym phrase by fuzzy query.
The invention provides a kind of fuzzy query system, it includes: a plurality of client computers, and the user can be by being provided with fuzzy query conditions and inquiry field; One querying server, it includes: a condition setting module, this condition setting module comprise that a querying condition is provided with submodule, can select whether to carry out fuzzy query for the user; One inquiry field is provided with submodule, can the inquiry field be set for the user.One carries out enquiry module, comprises that a query statement generates submodule, is to be used for the generated query statement, and (Structured QueryLanguage SQL) writes this query statement with Structured Query Language (SQL); One fuzzy query submodule is that the querying condition that is used for being provided with according to the user is carried out fuzzy query.One Query Result output module is to be used for the fuzzy query result being returned to client computer and being shown with patterned way.One database, wherein store default synonym phrase, this synonym phrase is the synonym phrase of being preset by the data base administrator, and the user can not hack, in advance one group of same meaning or close group of words is made into form by the data base administrator and is stored in the database.
The present invention also provides a kind of fuzzy query method, and it includes following steps: (a) provide a querying condition that submodule is set and select fuzzy query for the user; (b) provide an inquiry field that submodule is set and the fuzzy query field is set for the user; (c) provide a searching keyword submodule to be set for the user input query keyword; (d) provide a query statement to generate submodule and be used for the generated query statement; (e) provide a fuzzy query submodule to be used for carrying out the fuzzy query operation; (f) determine whether to obtain Query Result, if obtain Query Result, then Query Result is exported on the client computer and with patterned way and shown; If do not inquire the synonym phrase, inquire further then whether the setting in inquiry field is correct; (g) if the setting in inquiry field is correct, then returns step c and re-execute; (h) if being provided with of inquiry field is incorrect, then returns step b and re-execute.
By fuzzy query system and method provided by the invention, can realize when the user carries out inquiry in database, only need querying condition to be set to fuzzy query, and the inquiry field is set, import a searching keyword, just word enquiring identical or close with this keyword meaning of a word in the database can be come out, thereby improve search efficiency.
[description of drawings]
Fig. 1 is the hardware structure figure of fuzzy query of the present invention system.
Fig. 2 is the functional block diagram of fuzzy query system queries server of the present invention.
Fig. 3 is the information flow chart of fuzzy query of the present invention system
Fig. 4 is the operation process chart of fuzzy query method of the present invention.
[embodiment]
As shown in Figure 1, be the hardware structure figure of fuzzy query of the present invention system.This system includes a plurality of client computer 10, one networks 11, one querying servers 12, one databases 13.Wherein client computer 10 links to each other with querying server 12 respectively by network 11 with database 13, and network 11 can be an intranet Intranet, also can be Internet or other type communication network.Client computer 10 is to be used for being provided with querying condition and inquiry field.Querying server 12 is to be used for carrying out the fuzzy query operation according to the querying condition that the user is provided with, and Query Result is returned to the user.Database 13 stores default synonym phrase, this synonym phrase is the synonym phrase of being preset by the data base administrator, the user can not hack, in advance one group of same meaning or close group of words is made into form by the data base administrator and is stored in the database.Described synonym phrase is meant multi-field multilingual synon set, and same phrase can belong to a plurality of fields and have a plurality of synonym phrases, described synonym phrase to be meant the multilingual synonym set of same phrase.In the specific embodiment of the invention, synonym is meant the one group of similar import or the vocabulary that is mutually related, and is the synonym of computing machine, PC and Computer as computer, and same vocabulary can have the synonym of a plurality of same language
As shown in Figure 2, be the functional block diagram of fuzzy query system queries server of the present invention.Querying server 12 comprises a condition setting module 20, one execution enquiry modules 21, one Query Result output modules 22.Wherein condition setting module 20 is to be used for selecting to carry out fuzzy query and the inquiry field being set, this condition setting module 20 offers two kinds of inquiry modes of user: fuzzy query and accurately inquiry, described fuzzy query is meant carries out the fuzzy query operation, and described accurate inquiry is meant carries out accurate matching inquiry operation.This condition setting module 20 comprises that further a querying condition is provided with that submodule 201, one inquiry fields are provided with submodule 202 and a searching keyword is provided with submodule 203.It is to select to carry out fuzzy query with the cause user by client computer that described querying condition is provided with submodule 201; It is the fields that are used for further selecting fuzzy query after the user selects fuzzy query that the inquiry field is provided with submodule 202, for example mechanical field, electronic applications, chemical field etc., this inquiry field is the default inquiry field of server, and the user can not arbitrarily carry out and revise and editor; It is the keywords that are used for being provided with inquiry that searching keyword is provided with submodule 203, and described keyword is meant the different field that the user imports and the keyword of different language.Carrying out enquiry module 21 is to be used for carrying out the fuzzy query operation, it comprises that further query statement generates submodule 211 and fuzzy query submodule 212, it is to be used for after the user is provided with the field of querying condition and inquiry that this query statement generates submodule 211, polling routine generating structure query language (Structured Query Language, query statement SQL) by running background.Query Result output module 22 is that the result who is used for carrying out fuzzy query exports client computer to patterned way, and this graphic display mode can be form or calcspar etc.
As shown in Figure 3, be the information flow chart of fuzzy query of the present invention system.Condition setting module 20 receives the searching keyword 32 of user by client computer 10 inputs, and the technical field 31 of inquiry is set.Querying condition is provided with submodule 201 keyword place synonym phrase and place technical field thereof further is set, carry out enquiry module 21 and carry out fuzzy query according to searching keyword in synonym phrase 35, Query Result output module 22 exports the gained Query Result to client computer 10.Querying server 12 is provided with synonym phrase and the affiliated technical field 30 selection fuzzy queries 33 execution fuzzy queries 34 thereof that submodule 201 is provided with according to querying condition.
As shown in Figure 4, be the operation process chart of fuzzy query method of the present invention.At first, the user is provided with submodule 201 by querying condition and selects to carry out fuzzy query (step S40), and the inquiry field is provided with the inquiry field (step S41) that submodule 202 is provided with fuzzy query then.After setting is finished, the user is provided with submodule 203 input inquiry keywords (step S42) by searching keyword, generate submodule 211 generating structure query language (Structured QueryLanguage by query statement, SQL) query statement (step S43), in database 13, carry out fuzzy query (step S44) by fuzzy query submodule 212, at this moment, fuzzy query submodule 212 sends inquiry: whether find synonym phrase information (step S45), if find this synonym phrase information, then by Query Result output module 22 Query Result is returned to client computer and shows user (step S46) with patterned way, flow process finishes.If do not find synonym phrase information, then further inquire inquiry field setting whether correctly (step S47), at this moment by fuzzy query submodule 212, customer inspection inquiry field is provided with, if the inquiry field is provided with correctly, illustrate that then searching keyword need re-enter, flow process changes step S42 over to and carries out.If the user is provided with mistake through checking the inquiry field, then revise set inquiry field, reset the inquiry field, flow process enters step S41 place and restarts to carry out, and repeats above-mentioned flow process.
Claims (11)
1. fuzzy query system, it can carry out fuzzy query according to querying condition and inquiry field that the user is provided with, and it is characterized in that: this fuzzy query system includes:
A plurality of client computers are used to be provided with patent querying condition and inquiry field, the output Query Result;
One database wherein stores default synonym phrase, and this synonym phrase is to be made into form by one group of same meaning or close group of words to be stored in this database;
One querying server, it includes:
One condition setting module, it can be provided with fuzzy query conditions for the user;
One carries out enquiry module, the automatic generated query statement of fuzzy query conditions that it can be provided with according to the user, and further carry out fuzzy query;
One Query Result output module, it can return to the fuzzy query result client computer and show with patterned way.
2. fuzzy query as claimed in claim 1 system is characterized in that condition setting module wherein comprises that also a querying condition is provided with submodule, is to be used for choosing fuzzy query by the user.
3. fuzzy query as claimed in claim 1 system is characterized in that condition setting module wherein comprises that also an inquiry field is provided with submodule, is to be used for selecting to carry out fuzzy query place technical field by the user.
4. fuzzy query as claimed in claim 1 system is characterized in that execution enquiry module wherein comprises that also a query statement generates submodule, and this query statement generates the query statement that submodule generates a kind of Structured Query Language (SQL).
5. fuzzy query as claimed in claim 1 system is characterized in that execution enquiry module wherein also comprises a fuzzy query submodule, is to be used for carrying out fuzzy query according to the query statement that generates.
6. fuzzy query as claimed in claim 1 system is characterized in that the synonym phrase that the default synonym phrase of database wherein is made up of the different language word.
7. fuzzy query method is characterized in that including following steps:
Provide a querying condition that submodule is set and select fuzzy query for the user;
Provide an inquiry field that submodule is set and the fuzzy query field is set for the user;
Provide a searching keyword submodule to be set for the user input query keyword;
Provide a query statement to generate submodule and be used for the generated query statement;
Provide a fuzzy query submodule to be used for carrying out the fuzzy query operation;
Provide a Query Result output module to be used for exporting Query Result.
8. fuzzy query method as claimed in claim 7 is characterized in that it is further comprising the steps of, when not inquiring relevant information in database, inquires further whether the user inquiring field is provided with correct.
9. fuzzy query method as claimed in claim 8 is characterized in that if after the inquiry field was provided with correctly, the user need re-enter searching keyword, carries out inquiry job.
10. fuzzy query method as claimed in claim 8 is characterized in that then needing the user to reset the fuzzy query field if the inquiry field is provided with incorrectly, carries out the fuzzy query operation.
11. fuzzy query method as claimed in claim 10 it is characterized in that wherein synonym phrase is meant the set of multi-field multilingual synonym word, and same word can belong to a plurality of fields and a plurality of synonym phrase.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 03147001 CN1601524A (en) | 2003-09-25 | 2003-09-25 | Fuzzy inquiry system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 03147001 CN1601524A (en) | 2003-09-25 | 2003-09-25 | Fuzzy inquiry system and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN1601524A true CN1601524A (en) | 2005-03-30 |
Family
ID=34659745
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 03147001 Pending CN1601524A (en) | 2003-09-25 | 2003-09-25 | Fuzzy inquiry system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1601524A (en) |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100395753C (en) * | 2005-11-01 | 2008-06-18 | 华为技术有限公司 | Inquiry method and system, and inquiry switching device |
| CN101482878A (en) * | 2008-01-11 | 2009-07-15 | 株式会社理光 | Apparatus, system, and method for information search |
| CN101567007A (en) * | 2008-04-10 | 2009-10-28 | 阿博企业有限责任公司 | Fuzzy keyword searching |
| CN101202886B (en) * | 2006-12-28 | 2011-08-10 | 深圳市同洲电子股份有限公司 | Method, apparatus and equipment for searching TV program |
| CN101268463B (en) * | 2005-08-24 | 2012-07-18 | 雅虎公司 | Alternative search query prediction |
| CN102693241A (en) * | 2011-03-25 | 2012-09-26 | 腾讯科技（深圳）有限公司 | Method and device for gathering microblog subject |
| CN103365936A (en) * | 2012-03-30 | 2013-10-23 | 财团法人资讯工业策进会 | Video recommendation system and method thereof |
| CN104484353A (en) * | 2014-11-28 | 2015-04-01 | 华为技术有限公司 | Data imaging method, data imaging device and database server |
| CN101395604B (en) * | 2005-12-30 | 2015-09-16 | 谷歌公司 | For the dynamic search box of web browser |
| CN105303497A (en) * | 2015-12-01 | 2016-02-03 | 浪潮电子信息产业股份有限公司 | Nursing worker query system and method based on cloud computing |
| CN105868249A (en) * | 2015-12-15 | 2016-08-17 | 乐视网信息技术（北京）股份有限公司 | Data query control method and device |
| CN106777283A (en) * | 2016-12-29 | 2017-05-31 | 北京奇虎科技有限公司 | The method for digging and device of a kind of synonym |
| CN109635009A (en) * | 2018-12-27 | 2019-04-16 | 北京航天智造科技发展有限公司 | Fuzzy matching inquiry system and method |
| CN110019307A (en) * | 2017-12-28 | 2019-07-16 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| CN111046304A (en) * | 2018-10-12 | 2020-04-21 | 阿里巴巴集团控股有限公司 | Data searching method and device |
-
2003
- 2003-09-25 CN CN 03147001 patent/CN1601524A/en active Pending
Cited By (21)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101268463B (en) * | 2005-08-24 | 2012-07-18 | 雅虎公司 | Alternative search query prediction |
| CN100395753C (en) * | 2005-11-01 | 2008-06-18 | 华为技术有限公司 | Inquiry method and system, and inquiry switching device |
| CN101395604B (en) * | 2005-12-30 | 2015-09-16 | 谷歌公司 | For the dynamic search box of web browser |
| CN101202886B (en) * | 2006-12-28 | 2011-08-10 | 深圳市同洲电子股份有限公司 | Method, apparatus and equipment for searching TV program |
| CN101482878A (en) * | 2008-01-11 | 2009-07-15 | 株式会社理光 | Apparatus, system, and method for information search |
| CN101482878B (en) * | 2008-01-11 | 2013-09-04 | 株式会社理光 | Apparatus, system, and method for information search |
| CN101567007A (en) * | 2008-04-10 | 2009-10-28 | 阿博企业有限责任公司 | Fuzzy keyword searching |
| US8375053B2 (en) | 2008-04-10 | 2013-02-12 | Abo Enterprises, Llc | Fuzzy keyword searching |
| CN102693241A (en) * | 2011-03-25 | 2012-09-26 | 腾讯科技（深圳）有限公司 | Method and device for gathering microblog subject |
| CN103365936A (en) * | 2012-03-30 | 2013-10-23 | 财团法人资讯工业策进会 | Video recommendation system and method thereof |
| CN104484353A (en) * | 2014-11-28 | 2015-04-01 | 华为技术有限公司 | Data imaging method, data imaging device and database server |
| CN105303497A (en) * | 2015-12-01 | 2016-02-03 | 浪潮电子信息产业股份有限公司 | Nursing worker query system and method based on cloud computing |
| CN105868249A (en) * | 2015-12-15 | 2016-08-17 | 乐视网信息技术（北京）股份有限公司 | Data query control method and device |
| WO2017101398A1 (en) * | 2015-12-15 | 2017-06-22 | 乐视控股（北京）有限公司 | Data query control method and device |
| CN106777283A (en) * | 2016-12-29 | 2017-05-31 | 北京奇虎科技有限公司 | The method for digging and device of a kind of synonym |
| CN110019307A (en) * | 2017-12-28 | 2019-07-16 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| CN110019307B (en) * | 2017-12-28 | 2023-09-01 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| CN111046304A (en) * | 2018-10-12 | 2020-04-21 | 阿里巴巴集团控股有限公司 | Data searching method and device |
| CN111046304B (en) * | 2018-10-12 | 2023-10-13 | 阿里巴巴集团控股有限公司 | Data searching method and device |
| CN109635009A (en) * | 2018-12-27 | 2019-04-16 | 北京航天智造科技发展有限公司 | Fuzzy matching inquiry system and method |
| CN109635009B (en) * | 2018-12-27 | 2023-09-15 | 北京航天智造科技发展有限公司 | Fuzzy matching inquiry system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8352487B2 (en) | Identifier vocabulary data access method and system | |
| US20180157724A1 (en) | Designating Fields in Machine Data Using Templates | |
| US6304872B1 (en) | Search system for providing fulltext search over web pages of world wide web servers | |
| Baldonado et al. | The Stanford digital library metadata architecture | |
| US7062507B2 (en) | Indexing profile for efficient and scalable XML based publish and subscribe system | |
| US6799174B2 (en) | Retrieving, organizing, and utilizing networked data using databases | |
| JP4264118B2 (en) | How to configure information from different sources on the network | |
| EP1618496B1 (en) | A system and method for generating refinement categories for a set of search results | |
| US6983236B1 (en) | Method for system-constraint-based selection for design components | |
| CN101685444B (en) | System and method for realizing metadata search | |
| US8983931B2 (en) | Index-based evaluation of path-based queries | |
| US20070094246A1 (en) | System and method for searching dates efficiently in a collection of web documents | |
| US20040158567A1 (en) | Constraint driven schema association | |
| AU2004203480A1 (en) | A Search System And Method For Retrieval Of Data, And The Use Thereof In A Search Engine | |
| CN1601524A (en) | Fuzzy inquiry system and method | |
| US7024405B2 (en) | Method and apparatus for improved internet searching | |
| US7801880B2 (en) | Crawling databases for information | |
| US6282509B1 (en) | Thesaurus retrieval and synthesis system | |
| US20030200208A1 (en) | Method for rule-based retrieval of database records | |
| US7181454B1 (en) | Asset locator | |
| WO2001027712A2 (en) | A method and system for automatically structuring content from universal marked-up documents | |
| CN115858865A (en) | MBSE-oriented demand model rapid query and visualization method | |
| US6922682B1 (en) | Method and system for engineering discovery | |
| Huan et al. | Query interface schema extraction for hidden web resources searching | |
| Milenkovic et al. | Enabling knowledge management in complex industrial processes using semantic web technology |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |