CN101645086B - Retrieval method - Google Patents

Retrieval method Download PDF

Info

Publication number
CN101645086B
CN101645086B CN 200910091591 CN200910091591A CN101645086B CN 101645086 B CN101645086 B CN 101645086B CN 200910091591 CN200910091591 CN 200910091591 CN 200910091591 A CN200910091591 A CN 200910091591A CN 101645086 B CN101645086 B CN 101645086B
Authority
CN
China
Prior art keywords
data
attribute
retrieval
user
input
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.)
Expired - Fee Related
Application number
CN 200910091591
Other languages
Chinese (zh)
Other versions
CN101645086A (en
Inventor
孙亮朝
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Yonyou Network Technology Co Ltd
Original Assignee
Yonyou Software Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Yonyou Software Co Ltd filed Critical Yonyou Software Co Ltd
Priority to CN 200910091591 priority Critical patent/CN101645086B/en
Publication of CN101645086A publication Critical patent/CN101645086A/en
Application granted granted Critical
Publication of CN101645086B publication Critical patent/CN101645086B/en
Expired - Fee Related legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Abstract

The invention proposes a retrieval method which is characterized by comprising a step S102 and a step S104, wherein establishing a metadata table for storing metadata and the association relationship among the metadata in the step S102, and carrying out retrieval in a business data table described by the metadata table according to characters inputted by a user and returning to a retrieval result in the step S104. According to a whole object retrieval method provided by the invention, a unitive textbox can be provided to serve as an entry of input and retrieval; a user can input a name or a code of any data in a business system. During the input process, a pull-down input prompt with high efficiency and convenience exists, and a required data interface can be rapidly opened in the system after determination; if an end user only needs one attribute of a certain data, a spacebar can also be pressed to continue to input a field heading, thereby retrieving the data of the assigned attribute; if associated data also exists in the data of assigned attribute, the spacebar can be pressed so as to input a field heading of subsequent attribute and retrieve an attribute value.

Description

Search method
Technical field
The present invention relates to search method, relate more specifically to the quick-searching of whole business objects of management software and the method for location.
Background technology
In user's application system, there are a large amount of data, generally, these data have two kinds of retrieval modes, a kind of mode is in full this retrieval, namely take text-string as basic data, retrieves all relevant business datums according to the mode of fuzzy matching from whole operation system.Another kind of mode is according to fixing data field title retrieve data from the tables of data of appointment.But this dual mode has weak point separately.
This retrieval mode of full text, the data volume that often retrieves is very large, and not only retrieve data is slow, and because the result who retrieves is too many, causes the final user also will with the naked eye go the own needed data of retrieval from numerous results, and actual efficiency is very low.Although and fixing retrieval mode can accurately retrieve the required data of user, complicated operation, and also different results will enter from different entrances, and the operation limitation is very large.
Therefore, need a kind of retrieval mode, can solve the defective of above-mentioned two kinds of methods.
Summary of the invention
In order to solve the defective in the above-mentioned dual mode, the present invention proposes a kind of search method, it is characterized in that, comprising: step S102, set up metadata table, be used for the incidence relation between storing metadata and the described metadata; And step S104, in the described business datum table of metadata table, retrieve and return result for retrieval according to the character of user's input.
Preferably, step S104 further comprises: in the process of described user's input, prompting frame is lower drop-down list of pulling out the content that is complementary with input content automatically, and the different objects that wherein have same names or coding are presented in the described drop-down list together with its object type.
Preferably, behind the selected object, if described user inputs default symbol, then the corresponding attribute field title of described selected object is presented in the drop-down list from described drop-down list described user; And
According to the attribute field title of described user selection, from corresponding metadata table, retrieve corresponding property value.
Preferably, if the described property value that retrieves is reference object, then the metadata information with described reference object returns together, carries out the retrieval of lower one deck reference object so that described user continues to click described default symbol.
Preferably, step S102 comprises the following metadata table of foundation: the menu information menu, for the address of storage menu title and related interfaces; Table information data information table is used for storage list title, master data condition, is used for name field name and the code field of retrieval; And the field information data attribute list, be used for name attribute storage, the association of tables of data and the adduction relationship of attribute.
Wherein, the character of described user's input comprises base profile title or the arbitrary data attribute of document coding, base profile or document or any next stage attribute of attribute in pad name, the operation system.
Preferably, described step S104 comprises: judge according to the bytecode of described character whether described character is Chinese character, and determine the described metadata table of preferred retrieval according to judged result.Judging that described character is in the situation of Chinese character, then directly retrieve title, otherwise retrieve encoded.
Preferably, above-mentioned search method further comprises: for described metadata table is set up index, with the order of the described metadata table of deterministic retrieval.
Preferably, above-mentioned search method further comprises: after retrieving the occurrence of predetermined quantity, and auto-returned.
The full object search method that proposes according to the present invention, it has not only solved the problems referred to above, has also realized a kind of efficient retrieval locator meams.In operation system, the entrance of a unified text box as input and retrieval can be provided, the user can the incoming traffic system in title or the coding of arbitrary data, in input process, efficiently easily drop-down input prompt is arranged, needed data interface can be in system, opened fast after determining, if the final user only needs an attribute of a certain data, thereby the data that the input field title retrieves specified attribute can also be continued.Because data among systems is associated with each other, certain attribute that might data also has next attribute, and this engine can be according to the relation retrieve between object to the inferior data of arbitrary number of level, so this search mechanism is called as full object retrieval engine.
Description of drawings
Fig. 1 shows the process flow diagram according to search method of the present invention; And
Fig. 2 shows the according to an embodiment of the invention process flow diagram of search method.
Embodiment
Fig. 1 shows the process flow diagram according to search method of the present invention.As shown in Figure 1, search method according to the present invention comprises: step S102, set up metadata table, and be used for the incidence relation between storing metadata and the described metadata; And step S104, in the described business datum table of metadata table, retrieve and return result for retrieval according to the character of user's input.
Preferably, step S104 further comprises: in the process of described user's input, prompting frame is lower drop-down list of pulling out the content that is complementary with input content automatically, and the different objects that wherein have same names or coding are presented in the described drop-down list together with its object type.
Preferably, behind the selected object, if described user inputs default symbol, then the corresponding attribute field title of described selected object is presented in the drop-down list from described drop-down list described user; And
According to the attribute field title of described user selection, from corresponding metadata table, retrieve corresponding property value.
Preferably, if the described property value that retrieves is reference object, then the metadata information with described reference object returns together, carries out the retrieval of lower one deck reference object so that described user continues to click described default symbol.
Preferably, step S102 comprises the following metadata table of foundation: the menu information menu, for the address of storage menu title and related interfaces; Table information data information table is used for storage list title, master data condition, is used for name field name and the code field of retrieval; And the field information data attribute list, be used for name attribute storage, the association of tables of data and the adduction relationship of attribute.
Wherein, the character of described user's input comprises base profile title or the arbitrary data attribute of document coding, base profile or document or any next stage attribute of attribute in pad name, the operation system.
Preferably, described step S104 comprises: judge according to described character whether described character is Chinese character, and determine the described metadata table of preferred retrieval according to judged result.Judging that described character is in the situation of Chinese character, then directly retrieve title, otherwise retrieve encoded.
Preferably, above-mentioned search method further comprises: for described metadata table is set up index, with the order of the described metadata table of deterministic retrieval.
Preferably, above-mentioned search method further comprises: after retrieving the occurrence of predetermined quantity, and auto-returned.
Fig. 2 shows the according to an embodiment of the invention process flow diagram of search method.Specifically describe the application scenarios of this embodiment below in conjunction with Fig. 2.
One, use scenes is described:
1, interface description: the use interface of this search engine is very simple in full, is comprised of a text box, an auxiliary drop-down prompting frame of input and a hop button.The user is in text box in the typing, prompting frame is the lower content that is complementary with it of pulling out automatically, the user can click at any time one drop-down of up and down button selection or select one drop-down with mouse, then click hop button or carriage return, the prompting of just automatically opening related pages or ejecting related data.
2, retrieval mode: in full this search engine provides three kinds of modes the most basic: certain data attribute of coding, base profile or the document of function title (pad name), the base profile title in the operation system or document that the user can input system or any next stage attribute of attribute.For example:
Input " commodity " after determining, is opened the newly-increased interface of commodity;
Input " Coca-Cola " after determining, is opened the editing interface of this commodity of Coca-Cola;
Input " Coca-Cola. supplier ", after determining, eject prompting: Coca-Cola. and supplier is " XX company ";
Input " Coca-Cola. supplier. the address ", after determining, eject prompting: Coca-Cola. and supplier. the address is " XX area XX street XX number ".
Wherein the separator of data attribute can be inputted space or decimal deparator.
Two, realize principle:
1, metadata store: in operation system, have three metadata table MenuIno, TableInfo, FieldInfo, respectively the menu information menu in the storage service system, table information data table, field information data attribute list.MenuInfo menu information table needs the address of recording menu title and related interfaces; TableInfo data message table needs record sheet title, master data condition, is used for name field name and the code field name of retrieval; The FieldInfo data attribute list needs the adduction relationship of the related and attribute of record attribute title and tables of data.As described herein is the most basic a kind of storage mode of metadata, in addition, can also otherwise store, as long as can keep the related information of data, just can obtain according to this related information the data attribute of lower one deck.
Basic retrieval: when user's typing, at first according to the character of user's typing, the character of judging user's input is Chinese character or numeral and alphabetical, if title preferentially retrieved in Chinese character, if the preferential retrieve encoded of letter and number.In retrieving, during retrieval, elder generation and pad name coupling are searched relative recording more successively from each tables of data, based on the consideration of recall precision, need to set up an index for each tables of data here, in order to determine to retrieve first those tables of data commonly used.During retrieval, if found 10 occurrences, then auto-returned is no longer retrieved other tables of data, and this is to consider for efficient, only needs 10 result for retrieval, and the one page that satisfies in the drop-down prompting gets final product.
3, advanced search: if the user inputs space or decimal separator, the object type that then matches according to current retrieving information, continue its data attribute of retrieval, the header list of data field is returned to the user, during an attribute of user selection, from corresponding tables of data, retrieve its property value, if attribute is a reference object, then object metadata information can also be returned together, so that the user continues to click the retrieval that decimal separator carries out lower one deck reference object.The user clicks and determines or when pressing enter key, the data result that retrieves is prompted to the user.
4, re-treatment: if the title of some object and coding repetition in the system, then in input process because the existence of drop-down list is arranged, the different objects of same names or coding can be presented in the drop-down list together with its object type, like this, the user just can know the object that oneself will be retrieved clearly, thereby further selects and confirm.
Its concrete operational flowchart is seen Fig. 2.As shown in Figure 2, user's input (S202) determines whether separator (S204) afterwards, if judged result is yes, then proceeds to S206, the retrieve data attribute, otherwise proceed to S208, judge whether it is Chinese character.If judged result is yes, then preferentially retrieve title (S212), otherwise preferential retrieve encoded (S210).After S206, S210 and S212, all proceed to S214, return 10 row-column lists, should understand this those skilled in the art, specifically return several row-column lists and be that actual needs according to the client determines, can be not only 10 row.Then proceed to S216, the user selects and determines.At S218, judge whether user's selection is data attribute, if so, then proceed to S220, eject prompting, show data result, otherwise proceed to step S222, open related interfaces.
Three, instantiation is described
When user input text " Zhang San ", search engine at first in menu retrieval have and do not have name to be called Zhang San's menu, if this menu item is arranged then the metadata information of backtrack menu.After user's carriage return is determined, open the page address of specifying menu.
If the text of retrieval does not retrieve the menu of coupling in menu, then can in the data message table, find all tables of data, all tables of data that circulate are searched the data in the tables of data, because " Zhang San " two literal are Chinese characters, so search according to name field first, search according to code field again.After in subscriber's meter, finding the data of coupling, can return the information of these data.If user's carriage return is confirmed, then can be opened user " Zhang San's " edit page.
If the user continues input ". " number, then because the result for retrieval of front, search engine can know that the Zhang San of current input belongs to subscriber's meter.And then can continue from data attribute list, to search all fields and the field title of subscriber's meter and quote and related information, then in the input combobox, can return all users' field title, user selection department confirms, then can eject with the form of pop-up box user Zhang San's department name.
If the user continues input ". " number, then the search engine department's field that can search the user from data attribute list is related with which tables of data, when the department's attribute that retrieves the user with after the division data table is related, list of fields below meeting and then the retrieval department table, then in the input combobox, can demonstrate all properties tabulation of Zhang San's department, if the responsible official of user selection department after determining, can eject with the form of pop-up box responsible official's name of user Zhang San's department.
To sum up, search method of the present invention is the novel concept that proposes for the deficiency of this search engine of full text, in user's actual application, very general for the retrieval of special object or the retrieval of particular data, in full this retrieval is because retrieval rate is slow, as a result out of true and the complicacy of setting up this search engine of full text in operation system, determined that its range of application is very limited, so user's frequency of utilization is very low.
Under the overwhelming majority's condition, the data that the user will search for him, can clearly know its title or coding, and in most systems, the title of object or to be coded in the total system be unique, polyisomenism is also few, therefore, the user is very easily title and the coding of this object of Rapid input in the main interface of system just, the interface of viewing or editing of opening fast this object after the carriage return.And if above-mentioned action is opened corresponding Object Query interface by master menu, open again after the input coding inquiry, then increased the operation in four or five steps.
More the time, the user only wants to check certain specific attribute of a certain object, such as client Zhang San's telephone number, in this class situation, full object retrieval engine more can play the result of use of its convenient and efficient, the user only need to input " opening " in text box, then automatically occur in the combobox " Zhang San ", select to click the space behind the Zhang San, then automatically occur in the combobox " telephone number ", determine after selecting, then Zhang San's phone will automatic-prompting to the user.This obviously checks that than the record that the editing interface of opening the user retrieves Zhang San telephone number is succinct and efficient many again.
As everyone knows, in the BS system, interface efficient is a very large bottleneck, by full object retrieval engine can be greatly user-friendly, reduce running time and response time, be the technology that is worthy to be popularized very much.The Metadata mechanism that this engine provides makes full object retrieval engine be not limited to certain fixing operation system, as long as any management software has been set up metadata table and the business datum table of oneself done comprehensive a description just can enable easily full object retrieval function.And, this engine can effectively combine with voice entry system, when the user reads pad name, can open related interfaces, when the user reads " Zhang San's telephone number " by voice, these texts enter full object retrieval frame automatically, retrieve relevant information after, be prompted to the user with the form of voice.
Search method according to the present invention has solved efficiency of the prior art, for user's retrieval provides a kind of convenient effective mode, in a frame retrieval, can retrieve rapidly the data in the operation system in the mode of object oriented, coding and attribute list and navigate to editing interface corresponding to data.
The above is the preferred embodiments of the present invention only, is not limited to the present invention, and for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any modification of doing, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.

Claims (5)

1. a search method is characterized in that, comprising:
Step S102 sets up metadata table, is used for the incidence relation between storing metadata and the described metadata, sets up following metadata table: the menu information menu, for the address of storage menu title and related interfaces; Table information data information table is used for storage service tables of data title, master data condition, is used for name field name and the code field of retrieval; And the field information data attribute list, for the adduction relationship of name attribute storage with the related and attribute of tables of data; And
Step S104, character according to user's input is retrieved in described menu information menu, if do not retrieve the pad name of coupling, then in the described business datum table of described table information data information table, retrieve and return result for retrieval, wherein, described step S104 further comprises:
In the process of described user's input, prompting frame is the lower drop-down list that comprises the content that is complementary with the character of inputting of pulling out automatically, and the different objects that wherein have same names or coding are presented in the described drop-down list together with its object type;
Described user from described drop-down list behind the selected object, if described user inputs default symbol, then the corresponding attribute field title of described selected object is presented in the drop-down list, if described user does not input described default symbol, then opens the editing interface of described selected object; And
According to the attribute field title of described user selection, from the business datum table that corresponding metadata table is described, retrieve corresponding property value and show with the form of pop-up box.
2. search method according to claim 1 is characterized in that, further comprises:
If the described property value that retrieves is reference object, then the metadata information with described reference object returns together, carries out the retrieval of lower one deck reference object so that described user continues to input described default symbol.
3. search method according to claim 1, it is characterized in that the character of described user's input comprises base profile title or the arbitrary data attribute of document coding, base profile or document or any next stage attribute of attribute in pad name, the operation system;
Described step S104 comprises:
Character according to described user's input is at first retrieved in described menu information menu, if do not retrieve the pad name that the character with described input is complementary, then judge according to the bytecode of described character whether described character is Chinese character, and determine the field of preferred retrieval according to judged result;
Judging that described character is in the situation of Chinese character, then in described table information data information table, find all business datum tables and preferential retrieval title in described all business datum tables, judging that described character is in the situation of numeral and letter, finds all business datum tables and preferential retrieve encoded in described all business datum tables in described table information data information table.
4. search method according to claim 1 is characterized in that, further comprises:
For the described business datum table of described metadata table is set up index, with the order of the described business datum table of deterministic retrieval.
5. search method according to claim 1 is characterized in that, further comprises:
After retrieving the occurrence of predetermined quantity, auto-returned retrieves the result for retrieval that is shown to the user of predetermined quantity.
CN 200910091591 2009-08-28 2009-08-28 Retrieval method Expired - Fee Related CN101645086B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN 200910091591 CN101645086B (en) 2009-08-28 2009-08-28 Retrieval method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN 200910091591 CN101645086B (en) 2009-08-28 2009-08-28 Retrieval method

Publications (2)

Publication Number Publication Date
CN101645086A CN101645086A (en) 2010-02-10
CN101645086B true CN101645086B (en) 2013-01-09

Family

ID=41656974

Family Applications (1)

Application Number Title Priority Date Filing Date
CN 200910091591 Expired - Fee Related CN101645086B (en) 2009-08-28 2009-08-28 Retrieval method

Country Status (1)

Country Link
CN (1) CN101645086B (en)

Families Citing this family (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103019665A (en) * 2011-09-27 2013-04-03 深圳市金蝶友商电子商务服务有限公司 Receipt opening method and device
CN103123638B (en) * 2011-11-21 2017-08-04 北京神州泰岳软件股份有限公司 Data search method and device
CN103218364B (en) * 2012-01-19 2016-05-04 阿里巴巴集团控股有限公司 A kind of searching method and system
CN103885943B (en) * 2012-12-19 2018-04-27 北大方正集团有限公司 The implementation method of drop-down list box control in webpage
CN103905479B (en) * 2012-12-25 2018-04-27 联想(北京)有限公司 Method, the method for information processing and the electronic equipment that a kind of data upload
CN104572663A (en) * 2013-10-15 2015-04-29 镇江金软计算机科技有限责任公司 Realizing method for intelligently searching classifiable data based on JSP
CN105447063A (en) * 2014-09-30 2016-03-30 远光软件股份有限公司 Database subject retrieval method and retrieval device thereof
CN105824831A (en) * 2015-01-06 2016-08-03 中兴通讯股份有限公司 Method and apparatus looking for software functions
CN110851459B (en) * 2018-07-25 2021-08-13 上海柯林布瑞信息技术有限公司 Searching method and device, storage medium and server
CN109636556B (en) * 2018-12-07 2023-01-10 用友网络科技股份有限公司 Bill recommendation method and system and computer-readable storage medium
CN110109959B (en) * 2019-04-30 2021-08-13 北京达佳互联信息技术有限公司 Data processing method, device, server and storage medium

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1584886A (en) * 2003-08-19 2005-02-23 日本先锋公司 Contents retrieval system
CN1588369A (en) * 2004-09-06 2005-03-02 杭州恒生电子股份有限公司 Relation type data base system and its search and report method

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1584886A (en) * 2003-08-19 2005-02-23 日本先锋公司 Contents retrieval system
CN1588369A (en) * 2004-09-06 2005-03-02 杭州恒生电子股份有限公司 Relation type data base system and its search and report method

Also Published As

Publication number Publication date
CN101645086A (en) 2010-02-10

Similar Documents

Publication Publication Date Title
CN101645086B (en) Retrieval method
US7243080B2 (en) Systems and associated methods for wireless services for package tracking during delivery
US7788590B2 (en) Lightweight reference user interface
CN103379212B (en) Method for rapidly replying message and mobile terminal
CN102096717A (en) Search method and search engine
WO2002031682A2 (en) Email to database import utility
CN102982049B (en) Methods and systems for implementing email recipient templates
CN110888990A (en) Text recommendation method, device, equipment and medium
CN101027670B (en) Method and information database structure with user defined priorities for faster data access
CN101727201A (en) Method and device for automatically adjusting symbol rank and input method system
CN101087462B (en) Information browsing method
CN104636477A (en) Push list duplicate removal method before information push
US9075866B2 (en) System and method for providing search keyword list
CN104731823A (en) Multi-device document browsing method and device
US20140330774A1 (en) Information searching method and system
CN101945178A (en) Method, system and mobile terminal for viewing news information
CN101178740A (en) Method for publishing search information
KR20040107867A (en) Multimedia message service system and method of the same
CN100574340C (en) A kind of method of searching SMS
CN101894146A (en) Method and system for realizing advertising function by using created text edit box
CN102253967B (en) Data searching system and data searching method
US20080312901A1 (en) Character input assist method, character input assist system, character input assist program, user terminal, character conversion method and character conversion program
JP2009026249A (en) Browsing-history-editing terminal, program, and its method
CN100411468C (en) Method of deleting short messages in mobile communication terminal
US20130124615A1 (en) Retrieval terminal device, retrieval server device, retrieval tree compression method, and center-linked retrieval 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
C14 Grant of patent or utility model
GR01 Patent grant
C56 Change in the name or address of the patentee

Owner name: YONYOU NETWORK TECHNOLOGY CO., LTD.

Free format text: FORMER NAME: UFIDA SOFTWARE CO., LTD.

CP03 Change of name, title or address

Address after: 100094 Haidian District North Road, Beijing, No. 68

Patentee after: Yonyou Network Technology Co., Ltd.

Address before: 100094 Beijing city Haidian District North Road No. 68, UFIDA Software Park

Patentee before: UFIDA Software Co., Ltd.

CF01 Termination of patent right due to non-payment of annual fee
CF01 Termination of patent right due to non-payment of annual fee

Granted publication date: 20130109

Termination date: 20180828