CN101944117B - Sorting and searching method and system based on database - Google Patents

Sorting and searching method and system based on database Download PDF

Info

Publication number
CN101944117B
CN101944117B CN 201010287407 CN201010287407A CN101944117B CN 101944117 B CN101944117 B CN 101944117B CN 201010287407 CN201010287407 CN 201010287407 CN 201010287407 A CN201010287407 A CN 201010287407A CN 101944117 B CN101944117 B CN 101944117B
Authority
CN
China
Prior art keywords
database
record
type
character types
character
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.)
Active
Application number
CN 201010287407
Other languages
Chinese (zh)
Other versions
CN101944117A (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.)
Yulong Computer Telecommunication Scientific Shenzhen Co Ltd
Original Assignee
Yulong Computer Telecommunication Scientific Shenzhen 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 Yulong Computer Telecommunication Scientific Shenzhen Co Ltd filed Critical Yulong Computer Telecommunication Scientific Shenzhen Co Ltd
Priority to CN 201010287407 priority Critical patent/CN101944117B/en
Publication of CN101944117A publication Critical patent/CN101944117A/en
Application granted granted Critical
Publication of CN101944117B publication Critical patent/CN101944117B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Landscapes

  • Machine Translation (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention provides a sorting and searching method based on a database, comprising the following steps of: inserting one or more characters in a second character type in a first data table based on a first character type according to a preset sequence, and generating a second data table, wherein the first character type is different from the second character type; when increasing a record in the database, analyzing a keyword of the record based on the first character type to be a keyword based on the second character type, and both storing the keyword based on the first character type and the keyword based on the second character type into a record searching table according to a sequence defined by the second data table to be supplied to search. The invention also provides a sorting and searching system and a mobile terminal provided with the system. Based on the technical scheme, mixing sorting and rapid searching of record lists in two or more than two character types can be realized, therefore, the response speed of a processor is enhanced, and the needs to a memory of equipment is reduced.

Description

The ordering of based on database and search method and system
Technical field
The present invention relates to the communication technology, relate in particular to ordering and search method, system and the portable terminal of based on database.
Background technology
In the mobile-terminal platform of existing for example Android system, Symbian system, Windows Mobile system, the scale of contact person and music list all may very large (5000-10000 bar record), and therefore ordering and retrieval are just particularly important.
The contact list contact application of contact database ISP management is take field display_name (name of contact person) as index, the music table audio of media database ISP management all adopts the collation rule in bottom ICU storehouse to sort take field title (music title) as index.Can input of character string mate display_name/title and retrieve qualified record.
Contact person and music list can only sequentially sort according to English in the relevant technical scheme, and so Chinese contact person and music song tabulation seem disorderly and unsystematic, can only to English complete chain retrieval, not consider Chinese factor.Chinese contact person and music can not fast location and retrievals of character a-z all less than ordering.The Chinese contact person can not carry out phonetic spelling and initial retrieval (three location, ldh just can locate " Liu Dehua " such as input).
Adopt in the XT702 of the Motorola mobile phone music tabulation of Android2.1 system, all Chinese are all in English back, do not have Chinese and English hybrid-sorting (meaning of Chinese and English hybrid-sorting is that " axxx " and " Alishan " is all before " bxxx " and Pentium), can not locate fast by a-z; All Chinese of Samsung i9000 mobile phone contact and music do not have Chinese and English hybrid-sorting all in English back, and Chinese contact person can not carry out a-z location and phonetic spelling and initial retrieval.
Therefore, the ordering and search method, ordering and searching system and the portable terminal that need new based on database, can consider the factor of two kinds of different literals, realize the hybrid-sorting of two kinds of different literals, locate fast for example record of associated person information and music information.
Summary of the invention
Technical matters to be solved by this invention is, a kind of system and a kind of portable terminal of ordering and search method, a kind of ordering and retrieval of based on database are provided, realize the hybrid-sorting of two kinds of kinds of characters types (for example Chinese and English), locate fast the record of associated person information for example and/or music information.
In view of this, embodiments of the invention provide a kind of ordering and search method of based on database, are used for keeping data to connect at cordless communication network by long interface channel, comprising:
Step 102 is inserted one or more characters of the second character types according to predefined procedure in based on the first tables of data of the first character types, generate the second tables of data, and wherein, described the first character types are different from described the second character types; And
Step 104 when the record of retrieval in the described database, is retrieved the key word of described record according to described the second tables of data.
In technique scheme, preferably, between described step 102 and described step 104, further comprise step 103: when in described database, increasing described record, the key word based on described the first character types of described record is resolved to key word based on described the second character types, according to the defined order of described the second tables of data, described key word based on the first character types and described key word based on the second character types all are kept in the record retrieval table, for retrieval.
In technique scheme, preferably, described the first character types are the Chinese character type, and described the second character types are the English alphabet type.
In technique scheme, preferably, described Chinese character type comprises simplified Chinese character type and traditional Chinese type, and described English alphabet type comprises capitalization English letter type and small letter English alphabet type.
In technique scheme, preferably, record in described the first tables of data sorts according to the sequencing of the first letter of pinyin of Chinese character, and the record in described the second tables of data is according to the sequencing of Chinese character and the sequencing hybrid-sorting of English alphabet.
In technique scheme, preferably, described the first character types are the English alphabet type, and described the second character types are the Chinese character type.
In technique scheme, preferably, described Chinese character type comprises simplified Chinese character type and traditional Chinese type, and described English alphabet type comprises capitalization English letter type and small letter English alphabet type.
In technique scheme, preferably, the record in described the first tables of data sorts according to the sequencing of English alphabet, and the record in described the second tables of data is according to the sequencing of English alphabet and the sequencing hybrid-sorting of Chinese character.
In technique scheme, preferably, described database is the database based on the international assembly of Unified coding (ICU).
In technique scheme, preferably, described database is based on Android system platform, Symbian system platform or Windows Mobile system platform.
In technique scheme, preferably, the described fileinfo that is recorded as associated person information, audio-frequency information, video information, text message or any type.
In the situation that the described audio-frequency information that is recorded as, when adding or upgrade audio-frequency information, automatically obtain sorting key word according to the method for sorting of title key field by database, described sorting key word is kept in the title key field with 16 system forms.
By technique scheme, can realize hybrid-sorting and the quick-searching of record tabulation of two or more language.Improve the response speed of processor, reduced the demand to device memory.
By such scheme, the hybrid-sorting of two or more kinds of characters type that the present invention can based on database (for example Chinese and English) is located for example record of associated person information and audio-frequency information fast.Associated person information can also carry out phonetic retrieval or initial retrieval.
Embodiments of the invention also provide a kind of ordering and searching system of based on database, comprise: order module, in based on the first tables of data of the first character types, insert one or more characters of the second character types according to predefined procedure, generate the second tables of data, wherein, described the first character types are different from described the second character types; And
Retrieval module when the record of retrieval in the described database, is retrieved the key word of described record according to described the second tables of data.
In technique scheme, preferably, described ordering and searching system further comprise parsing module, be used for when described database increases described record, the key word based on described the first character types of described record is resolved to key word based on described the second character types, according to the defined order of described the second tables of data, described key word based on the first character types and described key word based on the second character types all are kept in the record retrieval table, for retrieval.
In technique scheme, preferably, described the first character types are the Chinese character type, and described the second character types are the English alphabet type.
In technique scheme, preferably, described Chinese character type comprises simplified Chinese character type and traditional Chinese type, and described English alphabet type comprises capitalization English letter type and small letter English alphabet type.
In technique scheme, preferably, record in described the first tables of data sorts according to the sequencing of the first letter of pinyin of Chinese character, and the record in described the second tables of data is according to the sequencing of Chinese character and the sequencing hybrid-sorting of English alphabet.
In technique scheme, preferably, described the first character types are the English alphabet type, and described the second character types are the Chinese character type.
In technique scheme, preferably, described Chinese character type comprises simplified Chinese character type and traditional Chinese type, and described English alphabet type comprises capitalization English letter type and small letter English alphabet type.
In technique scheme, preferably, the record in described the first tables of data sorts according to the sequencing of English alphabet, and the record in described the second tables of data is according to the sequencing of English alphabet and the sequencing hybrid-sorting of Chinese character.
In technique scheme, preferably, described database is the database based on ICU.
In technique scheme, preferably, described database is based on Android system platform, Symbian system platform or Windows Mobile system platform.
In technique scheme, preferably, the described fileinfo that is recorded as associated person information, audio-frequency information, video information, text message or any type.
Those skilled in the art are to be understood that, technical scheme as described herein is to be illustrated as example take Chinese and English, but the present invention is not limited thereto, and the present invention goes for hybrid-sorting and the quick-searching of the record tabulation of any two or more kinds of characters type.
By such scheme, the hybrid-sorting of two or more kinds of characters type that the present invention can based on database (for example Chinese and English) is located for example record of associated person information and audio-frequency information fast.Associated person information can also carry out phonetic retrieval or initial retrieval.
By technique scheme, can also realize hybrid-sorting and the quick-searching of record tabulation of two or more language.Improve the response speed of processor, reduced the demand to device memory.
Embodiments of the invention also provide a kind of portable terminal, comprise ordering and the searching system of aforesaid based on database.This portable terminal can be realized hybrid-sorting and the quick-searching that the record of two or more character types is tabulated.Improve the response speed of mobile terminal processor, reduced the demand to the portable terminal internal memory, improved user's experience.
Description of drawings
Fig. 1 is the ordering of based on database according to an embodiment of the invention and the process flow diagram of search method;
Fig. 2 is the block diagram of ordering according to an embodiment of the invention and searching system;
Fig. 3 is the block diagram according to portable terminal of the present invention;
Fig. 4 is the process flow diagram of the process that the contact person is retrieved according to an embodiment of the invention;
Fig. 5 is the process flow diagram of the process that music is retrieved according to an embodiment of the invention.
Embodiment
Below in conjunction with the drawings and specific embodiments the present invention is further described in detail.
Set forth in the following description a lot of details so that fully understand the present invention, still, the present invention can also adopt other to be different from other modes described here and implement, and therefore, the present invention is not limited to the restriction of following public specific embodiment.
Fig. 1 is the ordering of based on database according to an embodiment of the invention and the process flow diagram of search method.
As shown in Figure 1, the invention provides a kind of ordering and search method.Comprise:
Step 102 is inserted one or more characters of the second character types according to predefined procedure in based on the first tables of data of the first character types, generate the second tables of data, and wherein, described the first character types are different from described the second character types; And
Step 104 when the record of retrieval in the described database, is retrieved the key word of described record according to described the second tables of data.
In technique scheme, preferably, between described step 102 and described step 104, further can also comprise step 103: when in described database, increasing described record, the key word based on described the first character types of described record is resolved to key word based on described the second character types, according to the defined order of described the second tables of data, described key word based on the first character types and described key word based on the second character types all are kept in the record retrieval table, for retrieval.
In technique scheme, preferably, described the first character types are the Chinese character type, and described the second character types are the English alphabet type.
In technique scheme, preferably, record in described the first tables of data sorts according to the sequencing of the first letter of pinyin of Chinese character, and the record in described the second tables of data is according to the sequencing of Chinese character and the sequencing hybrid-sorting of English alphabet.
In technique scheme, preferably, described the first character types are the English alphabet type, and described the second character types are the Chinese character type.
In technique scheme, preferably, described Chinese character type comprises simplified Chinese character type and traditional Chinese type, and described English alphabet type comprises capitalization English letter type and small letter English alphabet type.
In technique scheme, preferably, the record in described the first tables of data sorts according to the sequencing of English alphabet, and the record in described the second tables of data is according to the sequencing of English alphabet and the sequencing hybrid-sorting of Chinese character.
In technique scheme, preferably, described database is the database based on ICU.
In technique scheme, preferably, described database is based on Android system platform, Symbian system platform or Windows Mobile system platform.
In technique scheme, preferably, the described fileinfo that is recorded as associated person information, audio-frequency information, video information, text message or any type.In the situation that the described audio-frequency information that is recorded as, when adding or upgrade audio-frequency information, automatically obtain sorting key word according to the method for sorting of title key field by database, described sorting key word is kept in the title key field with 16 system forms.
It will be appreciated by those skilled in the art that according to one embodiment of present invention, step 102 and step 104 can consist of a complete technical scheme, can solve technical matters of the present invention.Step 103 has thereafter consisted of preferred embodiment with the technology contents of above-described embodiment, is not intended to limit the present invention.
Those skilled in the art are to be understood that, technical scheme as described herein is to be illustrated as example take Chinese and English, but the present invention is not limited thereto, and the present invention goes for hybrid-sorting and the quick-searching of the record tabulation of any two or more kinds of characters type.For example, the present invention goes for hybrid-sorting and the quick-searching of the record tabulation of Chinese and Japanese, also be applicable to English hybrid-sorting and quick-searching of tabulating with the record of Japanese, hybrid-sorting and the quick-searching of the record tabulation that is applicable to Chinese, English, Japanese is set.
By such scheme, the hybrid-sorting of two or more kinds of characters type that the present invention can based on database (for example Chinese and English) is located for example record of associated person information and audio-frequency information fast.Associated person information can also carry out phonetic retrieval or initial retrieval.
By technique scheme, can also realize hybrid-sorting and the retrieval of record of two or more character types.Improve the response speed of processor, reduced the demand to device memory.
Fig. 2 is the ordering of based on database according to an embodiment of the invention and the block diagram of searching system.
As shown in Figure 2, the ordering of based on database according to an embodiment of the invention and searching system 200, comprise: order module 202, in based on the first tables of data of the first character types, insert one or more characters of the second character types according to predefined procedure, generate the second tables of data, wherein, described the first character types are different from described the second character types; Retrieval module 204 when the record of retrieval in the described database, is retrieved the key word of described record according to described the second tables of data.
In technique scheme, preferably, described ordering and searching system 200 further comprise parsing module 203, be used for when described database increases described record, the key word based on described the first character types of described record is resolved to key word based on described the second character types, according to the defined order of described the second tables of data, described key word based on the first character types and described key word based on the second character types all are kept in the record retrieval table, for retrieval.
It will be appreciated by those skilled in the art that according to one embodiment of present invention, order module 202 and retrieval module 204 can consist of a complete technical scheme, can solve technical matters of the present invention.Parsing module 203 has consisted of preferred embodiment with the technology contents of above-described embodiment, is not intended to limit the present invention.
In technique scheme, preferably, described the first character types are the Chinese character type, and described the second character types are the English alphabet type.
In technique scheme, preferably, described Chinese character type comprises simplified Chinese character type and traditional Chinese type, and described English alphabet type comprises capitalization English letter type and small letter English alphabet type.
In technique scheme, preferably, record in described the first tables of data sorts according to the sequencing of the first letter of pinyin of Chinese character, and the record in described the second tables of data is according to the sequencing of Chinese character and the sequencing hybrid-sorting of English alphabet.
In technique scheme, preferably, described the first character types are the English alphabet type, and described the second character types are the Chinese character type.
In technique scheme, preferably, described Chinese character type comprises simplified Chinese character type and traditional Chinese type, and described English alphabet type comprises capitalization English letter type and small letter English alphabet type.
In technique scheme, preferably, the record in described the first tables of data sorts according to the sequencing of English alphabet, and the record in described the second tables of data is according to the sequencing of English alphabet and the sequencing hybrid-sorting of Chinese character.
In technique scheme, preferably, described database is the database based on ICU.
In technique scheme, preferably, described database is based on Android system platform, Symbian system platform or Windows Mobile system platform.
In technique scheme, preferably, the described fileinfo that is recorded as associated person information, audio-frequency information, video information, text message or any type.
Those skilled in the art are to be understood that, technical scheme as described herein is to be illustrated as example take Chinese and English, but the present invention is not limited thereto, and the present invention goes for hybrid-sorting and the quick-searching of the record tabulation of any two or more kinds of characters type.For example, the present invention goes for hybrid-sorting and the quick-searching of the record tabulation of Chinese and Japanese, also be applicable to English hybrid-sorting and quick-searching of tabulating with the record of Japanese, hybrid-sorting and the quick-searching of the record tabulation that is applicable to Chinese, English, Japanese is set.
By such scheme, the hybrid-sorting of two or more kinds of characters type that the present invention can based on database (for example Chinese and English) is located for example record of associated person information and audio-frequency information fast.Associated person information can also carry out phonetic retrieval or initial retrieval.
By technique scheme, can realize hybrid-sorting and the quick-searching of record tabulation of two or more character types.Improve the response speed of processor, reduced the demand to device memory.
For example, the present invention can realize the Chinese and English hybrid-sorting of based on database, quickly positioning contact person and music, and the contact person can also carry out the technique effect of phonetic retrieval or initial retrieval.
Fig. 3 is the block diagram of portable terminal according to an embodiment of the invention.
As shown in Figure 3, portable terminal 300 according to the present invention has ordering and the searching system 200 of the based on database shown in Fig. 2.This portable terminal can be realized hybrid-sorting and the quick-searching that the record of two or more character types is tabulated.Improve the response speed of mobile terminal processor, reduced the demand to the portable terminal internal memory, improved user's experience.
Fig. 4 be in according to one embodiment of present invention to automatically generating the process flow diagram of search key in contact person's the retrieval.Fig. 5 is according to an embodiment of the invention to automatically generating the process flow diagram of title_key in the retrieval of music.
Illustrate that below in conjunction with Fig. 4 and Fig. 5 embodiments of the invention are applied to the situation of retrieving contacts and music retrieval.
ICU (International Components for Unicode, the international assembly of Unified coding) be that engine module is supported in internationalization/localization, be built-in with Chinese support, can change the compiling configuration and add Chinese support, the collation rule adopts phonetic, Chinese character can use Pinyin sorting like this, but can't accomplish Chinese and English hybrid-sorting.
At first will revise bottom ICU storehouse, database sort and application program retrieval are all based on this.A big table is used in the phonetic transcriptions of Chinese characters ordering, the inside has sequenced order to Chinese character more than 20,000 1 thousand, insert respectively alphabetical a-z and A-Z inside, be placed on the place of "<huge legendary turtle<Ao<b<B<eight<Ba " such as alphabetical b and B, one field is set up index has been exactly Chinese and English hybrid-sorting to database automatically like this, and the sort algorithm time efficiency is the constant level.
Need to open the translit function of ICU4c (ICU4c is the version of ICU under the C/C++ platform), realize that Chinese is to the conversion of phonetic.
The contact person provides the contact list 402 of device 404 management take display Name field (display_name) as index, the music table 502 that provides device 504 management with media is take title (title) as index, and contact person and music have all realized the Chinese and English hybrid-sorting of database level like this.
The Chinese character string coupling Android2.1 system of contact person and music carries, need here to add that character a-z locates fast, the contact person also will add and carry out the retrieval of phonetic retrieval and initial, and both all do not need the data database table structure is changed, and only need to revise partial logic.
Retrieval to the contact person is to provide the name look-up table (name_lookup) of device (ContactsProvider) 404 management to realize by inquiring contactor, all search keys preserved in field specification assumed name's word (normalized_name) of name look-up table, a few row data of many increases in the name look-up table are with regard to many several keywords.Automatically according to display name (display_name) field generation phonetic spelling and the initial simplicity word string of contact list 402 (contacts), then these word strings are all added in the name look-up table in the time of interpolation or renewal contact person.Contact application just can be come quickly positioning contact person by character a-z automatically, can also carry out the retrieval of phonetic retrieval and initial.406 couples of contact names of structuring name row processor (Structured NameRowHandler) carry out structuring and process, and add the name look-up table to and make up the name look-up table that device (NameLookupBuilder) 408 makes up, 410 pairs of names of name normalizer (NameNormalizer) are standardized, and SQLite database 412 is used for preserving associated person information.
In this embodiment, with reference to figure 5, the location is just passable fast only need to add character a-z to the retrieval of music.This is to provide the title_key field of the music table 502 of device 504 (MediaProvider) management to realize by the inquiry media.Add or automatically obtain sortkey according to arrangement (collation) method of title field by ICU when upgrading music, be kept in the title_key field with 16 system forms.In music application a-z is also generated sortkey equally and mate music title, so just can locate fast.Media stored audio program 506 is used for the stored audio file, obtain arrangement key word (CollationKey) from data base tool (databaseUtils) 508, data base tool (databaseUtils) 508 obtains the arrangement key word from ICU reorganizer (Collator) 510, and SQLite database 512 is used for preserving media data.
In technique scheme, the location is just passable fast only need to add character a-z to the retrieval of music.This is to realize by the title_key field that the audio that inquiry media database ISP manages shows.Add or automatically obtain sortkey according to the collation method of title field by icu when upgrading music, be kept in the title_key field with 16 system forms.We also generate sortkey in music application to a-z and mate music title equally, so just can locate fast.
According to technique scheme, consider Chinese factor, utilize order module to carry out the Chinese phonetic alphabet ordering of Chinese contact person and Chinese music, and energy and English hybrid-sorting; Can realize that by change contact database ISP/media database ISP input character a-z comes quickly positioning contact person and music, the contact person can also carry out phonetic retrieval or initial retrieval by retrieval module.Reduced greatly the complexity of upper level applications contact application and music application, improved effectiveness of performance, made the ordering of based on database and the performance of searching system reach best.
Chinese contact person and Chinese music can sort according to the Chinese phonetic alphabet, and energy and English hybrid-sorting, can come quickly positioning contact person and music by input character a-z, and the contact person can also carry out phonetic retrieval or initial retrieval.
At present, the related platform solution is that database does not have Chinese and English hybrid-sorting, all reads up to ten thousand by application program at every turn and all is converted to phonetic by third party library behind the record, then in internal memory ordering and retrieval, time-consumingly takes the space and application logic is complicated.
And technical scheme according to the present invention sequences order when adding record by database automatically, and ordering is the constant time level, and retrieval is also finished by database; Support storehouse and database section logic by a small amount of modification bottom icu, reduced greatly the complexity of upper level applications Contacts and Music and improved effectiveness of performance, the performance of this scheme is best.
Technical scheme according to the present invention is the universal solution of the mobile-terminal platform of Android system, Symbian system, Windows Mobile system for example, and all large-scale tabulations by the database storage all can come quicksort and retrieval with this scheme.
It will be appreciated by those skilled in the art that according to technical scheme of the present invention not to be confined to list of songs and Chinese contact person, all relate to arrangement and search method that similar application can adopt technical scheme according to the present invention to relate to.
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 (7)

1. the ordering of a based on database and search method is characterized in that, comprising:
Step 102 is inserted one or more characters of the second character types according to predefined procedure in based on the first tables of data of the first character types, generate the second tables of data, and wherein, described the first character types are different from described the second character types;
Step 103, when in described database, increasing record, the key word based on described the first character types of described record is resolved to key word based on described the second character types, according to the defined order of described the second tables of data, described key word based on the first character types and described key word based on the second character types all are kept in the record retrieval table, for retrieval; And
Step 104 when the record of retrieval in the described database, is retrieved the key word of described record according to described the second tables of data.
2. the ordering of based on database according to claim 1 and search method is characterized in that:
Described the first character types are the Chinese character type, and described the second character types are the English alphabet type; Described Chinese character type comprises simplified Chinese character type and traditional Chinese type, and described English alphabet type comprises capitalization English letter type and small letter English alphabet type; Record in described the first tables of data sorts according to the sequencing of the first letter of pinyin of Chinese character, and the record in described the second tables of data is according to the sequencing of Chinese character and the sequencing hybrid-sorting of English alphabet.
According to claim 1 and 2 in ordering and the search method of each described based on database, it is characterized in that, described database is the database based on the international assembly of Unified coding; Described database is based on Android system platform, Symbian system platform or Windows Mobile system platform.
According to claim 1 and 2 in ordering and the search method of each described based on database, it is characterized in that the described fileinfo that is recorded as associated person information, audio-frequency information, video information, text message or any type; In the situation that the described audio-frequency information that is recorded as, when adding or upgrade audio-frequency information, automatically obtain sorting key word according to the method for sorting of title key field by database, described sorting key word is kept in the title key field with 16 system forms.
5. the ordering of a based on database and searching system is characterized in that, comprising:
Order module is inserted one or more characters of the second character types according to predefined procedure in based on the first tables of data of the first character types, generate the second tables of data, and wherein, described the first character types are different from described the second character types;
Parsing module, be used for when described database increases record, the key word based on described the first character types of described record is resolved to key word based on described the second character types, according to the defined order of described the second tables of data, described key word based on the first character types and described key word based on the second character types all are kept in the record retrieval table, for retrieval; And
Retrieval module when the record of retrieval in the described database, is retrieved the key word of described record according to described the second tables of data.
6. the ordering of based on database according to claim 5 and searching system is characterized in that:
Described the first character types are the Chinese character type, and described the second character types are the English alphabet type; Described Chinese character type comprises simplified Chinese character type and traditional Chinese type, and described English alphabet type comprises capitalization English letter type and small letter English alphabet type;
Record in described the first tables of data sorts according to the sequencing of the first letter of pinyin of Chinese character, and the record in described the second tables of data is according to the sequencing of Chinese character and the sequencing hybrid-sorting of English alphabet.
7. ordering and the searching system of each described based on database according to claim 5 or in 6 is characterized in that, described database is the database based on the international assembly of Unified coding; Described database is based on Android system platform, Symbian system platform or Windows Mobile system platform.
CN 201010287407 2010-09-20 2010-09-20 Sorting and searching method and system based on database Active CN101944117B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN 201010287407 CN101944117B (en) 2010-09-20 2010-09-20 Sorting and searching method and system based on database

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN 201010287407 CN101944117B (en) 2010-09-20 2010-09-20 Sorting and searching method and system based on database

Publications (2)

Publication Number Publication Date
CN101944117A CN101944117A (en) 2011-01-12
CN101944117B true CN101944117B (en) 2013-04-24

Family

ID=43436108

Family Applications (1)

Application Number Title Priority Date Filing Date
CN 201010287407 Active CN101944117B (en) 2010-09-20 2010-09-20 Sorting and searching method and system based on database

Country Status (1)

Country Link
CN (1) CN101944117B (en)

Families Citing this family (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110086922B (en) * 2019-04-19 2022-11-11 上海掌门科技有限公司 Address book ordering method, equipment and storage medium
CN111046255A (en) * 2019-12-16 2020-04-21 金蝶软件(中国)有限公司 Data sorting method and related equipment
CN112241558A (en) * 2020-09-03 2021-01-19 深圳市华阳国际工程设计股份有限公司 Element type name unifying method and device and computer storage medium
CN112597244B (en) * 2020-12-23 2023-05-16 浙江中控技术股份有限公司 Data synchronization method and device and electronic equipment
CN113722480A (en) * 2021-08-11 2021-11-30 安徽帕觅智能科技有限公司 Japanese contact person mixed retrieval method

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1852345A (en) * 2005-04-22 2006-10-25 英华达(上海)电子有限公司 Telephone number intelligent inquiry method for mobile phone directory
CN101436203A (en) * 2008-12-10 2009-05-20 深圳华为通信技术有限公司 Recording index method and apparatus
CN101686274A (en) * 2008-09-22 2010-03-31 深圳富泰宏精密工业有限公司 Contact name searching system and method

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1852345A (en) * 2005-04-22 2006-10-25 英华达(上海)电子有限公司 Telephone number intelligent inquiry method for mobile phone directory
CN101686274A (en) * 2008-09-22 2010-03-31 深圳富泰宏精密工业有限公司 Contact name searching system and method
CN101436203A (en) * 2008-12-10 2009-05-20 深圳华为通信技术有限公司 Recording index method and apparatus

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
孙志岗.android中文联系人排序及检索补丁的原理.《http://blog.sunner.cn/android_pinyin_sorting/》.2009, *

Also Published As

Publication number Publication date
CN101944117A (en) 2011-01-12

Similar Documents

Publication Publication Date Title
CN109670163B (en) Information identification method, information recommendation method, template construction method and computing device
US7277029B2 (en) Using language models to expand wildcards
CN101167075B (en) Characteristic expression extracting device, method, and program
CN103294776A (en) Smartphone address book fuzzy search method
CN101944117B (en) Sorting and searching method and system based on database
CN101876878A (en) Word prediction input system and method
CN101799816A (en) Method and mobile terminal for searching keywords in mobile terminal information
CN102033928B (en) Handwritten original handwriting recording and querying system and electronic device
CN102262471A (en) Touch intelligent induction system
CN101631398A (en) Mobile terminal electronic-book management system and mobile terminal electronic-book management method
CN101673186A (en) Intelligent operating system and method based on keyword input
CN101645086A (en) Retrieval method
CN104035993A (en) Memory search method for e-books, e-book management system and reading system
CN102270238B (en) Method and device for establishing continuation of Chinese knowledge points
CN100574340C (en) A kind of method of searching SMS
CN101374307B (en) Method and apparatus for updating digital content information of mobile equipment
CN103428341A (en) Method and device for searching for mobile phone contacts
CN102999639B (en) A kind of lookup method based on speech recognition character index and system
CN104331434A (en) Method for generating search prompt word service and device for generating search prompt word service
CN102014199A (en) Information display method and terminal
CN101446975B (en) File location method and device
CN101873381A (en) Mobile phone menu displaying method and mobile phone
CN101267635B (en) Chinese input device for contact book of mobile phone
KR20080082985A (en) Method and apparatus for manipulating data files
CN102004598A (en) Media player and character input method thereof

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