CN101944117A - Sorting and searching method and system as well as mobile terminal based on database - Google Patents
Sorting and searching method and system as well as mobile terminal based on database Download PDFInfo
- Publication number
- CN101944117A CN101944117A CN 201010287407 CN201010287407A CN101944117A CN 101944117 A CN101944117 A CN 101944117A CN 201010287407 CN201010287407 CN 201010287407 CN 201010287407 A CN201010287407 A CN 201010287407A CN 101944117 A CN101944117 A CN 101944117A
- Authority
- CN
- China
- Prior art keywords
- type
- database
- record
- ordering
- 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.)
- Granted
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
Technical field
The present invention relates to the communication technology, relate in particular to ordering and search method, system and portable terminal 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 big (5000-10000 bar record), and therefore ordering and retrieval are just particularly important.
The contact list contact application of contact database ISP management is an index with field display_name (name of contact person), the music table audio of media database ISP management is an index with field title (music title), all adopts the collation rule in bottom ICU storehouse to sort.Can input of character string mate display_name/title and retrieve qualified record.
Contact person and music list can only be according to English rank order in the relevant technical scheme, and so Chinese contact person and music song tabulation seem disorderly and unsystematic, can only Chinese factor do not considered in English complete chain retrieval.Chinese contact person and music can not character a-z location and retrievals fast 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 to mix ordering (meaning that Chinese and English mixes ordering 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 to mix ordering all in English back, and Chinese contact person can not carry out a-z location and phonetic spelling and initial retrieval.
Therefore, need new ordering and search method, ordering and searching system and portable terminal based on database, can consider the factor of two kinds of different literals, realize the mixing ordering of two kinds of different literals, locate for example record of associated person information and music information fast.
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 the retrieval based on database are provided, realize the mixing ordering of two kinds of kinds of characters types (for example Chinese and English), locate the record of associated person information for example and/or music information fast.
In view of this, embodiments of the invention provide a kind of ordering and search method 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 second character types according to predefined procedure in based on first tables of data of first character types, generate second tables of data, and wherein, described first character types are different with described 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 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 first character types of described record is resolved to key word based on described second character types, according to the defined order of described second tables of data, described key word and described key word based on second character types based on first character types all is kept in the record retrieval table, for retrieval.
In technique scheme, preferably, described first character types are the Chinese character type, and described 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 first tables of data sorts according to the sequencing of the first letter of pinyin of Chinese character, and the record in described second tables of data mixes ordering according to the sequencing of Chinese character and the sequencing of English alphabet.
In technique scheme, preferably, described first character types are the English alphabet type, and described 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 first tables of data sorts according to the sequencing of English alphabet, and the record in described second tables of data mixes ordering according to the sequencing of English alphabet and the sequencing 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.
Under the described situation that is recorded as audio-frequency information, when adding or upgrade audio-frequency information, obtain sorting key word according to the method for sorting of title key field by database automatically, described sorting key word is kept in the title key field with 16 system forms.
By technique scheme, can realize the mixing ordering and the retrieval fast of record tabulation of two or more language.Improved the response speed of processor, reduced demand Device memory.
By such scheme, the present invention can be based on the mixing ordering of two or more kinds of characters type of database (for example Chinese and English), locatees 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 based on database, comprise: order module, in based on first tables of data of first character types, insert one or more characters of second character types according to predefined procedure, generate second tables of data, wherein, described first character types are different with described 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 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 first character types of described record is resolved to key word based on described second character types, according to the defined order of described second tables of data, described key word and described key word based on second character types based on first character types all is kept in the record retrieval table, for retrieval.
In technique scheme, preferably, described first character types are the Chinese character type, and described 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 first tables of data sorts according to the sequencing of the first letter of pinyin of Chinese character, and the record in described second tables of data mixes ordering according to the sequencing of Chinese character and the sequencing of English alphabet.
In technique scheme, preferably, described first character types are the English alphabet type, and described 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 first tables of data sorts according to the sequencing of English alphabet, and the record in described second tables of data mixes ordering according to the sequencing of English alphabet and the sequencing 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 be with Chinese and English be that example is illustrated, but the present invention is not limited thereto, and the present invention goes for the mixing ordering and the retrieval fast of the record tabulation of any two or more kinds of characters type.
By such scheme, the present invention can be based on the mixing ordering of two or more kinds of characters type of database (for example Chinese and English), locatees 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 the mixing ordering and the retrieval fast of record tabulation of two or more language.Improved the response speed of processor, reduced demand Device memory.
Embodiments of the invention also provide a kind of portable terminal, comprise aforesaid ordering and searching system based on database.This portable terminal can be realized mixing ordering and the retrieval fast that the record of two or more character types is tabulated.Improved the response speed of mobile terminal processor, reduced demand, improved user experience the portable terminal internal memory.
Description of drawings
Fig. 1 is according to an embodiment of the invention based on the ordering of database 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 a lot of details in the following description 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 according to an embodiment of the invention based on the ordering of database 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 second character types according to predefined procedure in based on first tables of data of first character types, generate second tables of data, and wherein, described first character types are different with described 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 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 first character types of described record is resolved to key word based on described second character types, according to the defined order of described second tables of data, described key word and described key word based on second character types based on first character types all is kept in the record retrieval table, for retrieval.
In technique scheme, preferably, described first character types are the Chinese character type, and described second character types are the English alphabet type.
In technique scheme, preferably, record in described first tables of data sorts according to the sequencing of the first letter of pinyin of Chinese character, and the record in described second tables of data mixes ordering according to the sequencing of Chinese character and the sequencing of English alphabet.
In technique scheme, preferably, described first character types are the English alphabet type, and described 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 first tables of data sorts according to the sequencing of English alphabet, and the record in described second tables of data mixes ordering according to the sequencing of English alphabet and the sequencing 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.Under the described situation that is recorded as audio-frequency information, when adding or upgrade audio-frequency information, obtain sorting key word according to the method for sorting of title key field by database automatically, 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 constitute a complete technical scheme, can solve technical matters of the present invention.Step 103 has thereafter constituted preferred embodiment with the technology contents of the foregoing description, and is not used in qualification the present invention.
Those skilled in the art are to be understood that, technical scheme as described herein be with Chinese and English be that example is illustrated, but the present invention is not limited thereto, and the present invention goes for the mixing ordering and the retrieval fast of the record tabulation of any two or more kinds of characters type.For example, the present invention goes for Chinese and sorts and retrieval fast the mixing of record tabulation of Japanese, also be applicable to English and Japanese the record tabulation mix ordering and retrieval fast, the mixing ordering of the record tabulation that is applicable to Chinese, English, Japanese be set and retrieve fast.
By such scheme, the present invention can be based on the mixing ordering of two or more kinds of characters type of database (for example Chinese and English), locatees 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 the mixing ordering and the retrieval of record of two or more character types.Improved the response speed of processor, reduced demand Device memory.
Fig. 2 is according to an embodiment of the invention based on the ordering of database and the block diagram of searching system.
As shown in Figure 2, ordering and searching system 200 based on database according to an embodiment of the invention, comprise: order module 202, in based on first tables of data of first character types, insert one or more characters of second character types according to predefined procedure, generate second tables of data, wherein, described first character types are different with described 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 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 first character types of described record is resolved to key word based on described second character types, according to the defined order of described second tables of data, described key word and described key word based on second character types based on first character types all is 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 constitute a complete technical scheme, can solve technical matters of the present invention.Parsing module 203 has constituted preferred embodiment with the technology contents of the foregoing description, and is not used in qualification the present invention.
In technique scheme, preferably, described first character types are the Chinese character type, and described 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 first tables of data sorts according to the sequencing of the first letter of pinyin of Chinese character, and the record in described second tables of data mixes ordering according to the sequencing of Chinese character and the sequencing of English alphabet.
In technique scheme, preferably, described first character types are the English alphabet type, and described 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 first tables of data sorts according to the sequencing of English alphabet, and the record in described second tables of data mixes ordering according to the sequencing of English alphabet and the sequencing 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 be with Chinese and English be that example is illustrated, but the present invention is not limited thereto, and the present invention goes for the mixing ordering and the retrieval fast of the record tabulation of any two or more kinds of characters type.For example, the present invention goes for Chinese and sorts and retrieval fast the mixing of record tabulation of Japanese, also be applicable to English and Japanese the record tabulation mix ordering and retrieval fast, the mixing ordering of the record tabulation that is applicable to Chinese, English, Japanese be set and retrieve fast.
By such scheme, the present invention can be based on the mixing ordering of two or more kinds of characters type of database (for example Chinese and English), locatees 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 the mixing ordering and the retrieval fast of record tabulation of two or more character types.Improved the response speed of processor, reduced demand Device memory.
For example, the present invention can realize mixing ordering based on the Chinese and English of 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 based on database shown in Fig. 2.This portable terminal can be realized mixing ordering and the retrieval fast that the record of two or more character types is tabulated.Improved the response speed of mobile terminal processor, reduced demand, improved user experience the portable terminal internal memory.
Fig. 4 be in according to one embodiment of present invention to generating the process flow diagram of search key in contact person's the retrieval automatically.Fig. 5 is according to an embodiment of the invention to generating the process flow diagram of title_key in the retrieval of music automatically.
Illustrate that below in conjunction with Fig. 4 and Fig. 5 embodiments of the invention are applied to the situation of contact person's retrieval 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 that Chinese and English mixes ordering.
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 preface to Chinese character more than 20,000 1 thousand, insert alphabetical a-z and A-Z inside respectively, be placed on the place of "<huge legendary turtle<Ao<b<B<eight<Ba " such as alphabetical b and B, database is set up index to a field and is exactly Chinese and English automatically and mixes and sorted like this, and the sort algorithm time efficiency is the constant level.
Need open the translit function of ICU4c (ICU4c is the version of ICU under the C/C++ platform), realize the conversion of Chinese to phonetic.
It is index with display Name field (display_name) that the contact person provides the contact list 402 of device 404 management, providing the music table 502 of device 504 management with medium is index with title (title), and contact person and music have realized that all the Chinese and English of database level mixes ordering like this.
The Chinese character string coupling Android2.1 system of contact person and music carries, need here to add that character a-z locatees fast, the contact person will add also and carry out phonetic retrieval and initial retrieval that both all do not need 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, several line 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 handle, 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 to preserve 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 medium.Add or obtain sortkey according to arrangement (collation) method of title field by ICU automatically 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.Medium 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 to preserve 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 obtain sortkey according to the collation method of title field by icu automatically 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 can mix ordering with English; 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 the complexity of upper level applications contact application and music application greatly, improved effectiveness of performance, made based on the ordering of database and the performance of searching system to reach best.
Chinese contact person and Chinese music can sort according to the Chinese phonetic alphabet, and can mix ordering with English, 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 to mix ordering, all reads up to ten thousand whole records backs by application program at every turn and is converted to phonetic by third party library, then in internal memory ordering and retrieval, time-consuming space and the application logic complexity of taking.
And technical scheme according to the present invention sequences preface 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 minor modifications bottom icu, reduced the complexity of upper level applications Contacts and Music greatly 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 come quicksort and retrieval by all available this scheme of the large-scale tabulation of database storing.
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 changes and variation.Within the spirit and principles in the present invention all, any modification of being done, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. ordering and search method based on a database is characterized in that, comprising:
Step 102 is inserted one or more characters of second character types according to predefined procedure in based on first tables of data of first character types, generate second tables of data, and wherein, described first character types are different with described 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 second tables of data.
2. ordering and search method based on database according to claim 1, it is characterized in that, 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 first character types of described record is resolved to key word based on described second character types, according to the defined order of described second tables of data, described key word and described key word based on second character types based on first character types all is kept in the record retrieval table, for retrieval.
3. ordering and search method based on database according to claim 1 is characterized in that:
Described first character types are the Chinese character type, and described 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 first tables of data sorts according to the sequencing of the first letter of pinyin of Chinese character, and the record in described second tables of data mixes ordering according to the sequencing of Chinese character and the sequencing of English alphabet;
Perhaps, described first character types are the English alphabet type, and described second character types are the Chinese character 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 first tables of data sorts according to the sequencing of English alphabet, and the record in described second tables of data mixes ordering according to the sequencing of English alphabet and the sequencing of Chinese character.
4. according to each described ordering and search method in the claim 1 to 3, it is characterized in that described database is the database based on the international assembly of Unified coding based on database; Described database is based on Android system platform, Symbian system platform or Windows Mobile system platform.
5. according to each described ordering and search method in the claim 1 to 3, 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 based on database; Under the described situation that is recorded as audio-frequency information, when adding or upgrade audio-frequency information, obtain sorting key word according to the method for sorting of title key field by database automatically, described sorting key word is kept in the title key field with 16 system forms.
6. ordering and searching system based on a database is characterized in that, comprising:
Order module is inserted one or more characters of second character types according to predefined procedure in based on first tables of data of first character types, generate second tables of data, and wherein, described first character types are different with described 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 second tables of data.
7. ordering and searching system based on database according to claim 6, it is characterized in that, described ordering and searching system further comprise parsing module, be used for when described database increases described record, the key word based on described first character types of described record is resolved to key word based on described second character types, according to the defined order of described second tables of data, described key word and described key word based on second character types based on first character types all is kept in the record retrieval table, for retrieval.
8. ordering and searching system based on database according to claim 7 is characterized in that:
Described first character types are the Chinese character type, and described 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 first tables of data sorts according to the sequencing of the first letter of pinyin of Chinese character, and the record in described second tables of data mixes ordering according to the sequencing of Chinese character and the sequencing of English alphabet;
Perhaps, described first character types are the English alphabet type, and described second character types are the Chinese character 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 first tables of data sorts according to the sequencing of English alphabet, and the record in described second tables of data mixes ordering according to the sequencing of English alphabet and the sequencing of Chinese character.
9. according to each described ordering and searching system in the claim 6 to 8, it is characterized in that described database is the database based on the international assembly of Unified coding based on database; Described database is based on Android system platform, Symbian system platform or Windows Mobile system platform.
10. a portable terminal is characterized in that, comprises as each described ordering and searching system based on database in the claim 6 to 9.
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 true CN101944117A (en) | 2011-01-12 |
CN101944117B 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) |
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110086922A (en) * | 2019-04-19 | 2019-08-02 | 上海掌门科技有限公司 | A kind of 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 |
CN112597244A (en) * | 2020-12-23 | 2021-04-02 | 浙江中控技术股份有限公司 | Data synchronization method and device and electronic equipment |
CN113722480A (en) * | 2021-08-11 | 2021-11-30 | 安徽帕觅智能科技有限公司 | Japanese contact person mixed retrieval method |
Citations (3)
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 |
-
2010
- 2010-09-20 CN CN 201010287407 patent/CN101944117B/en active Active
Patent Citations (3)
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)
Title |
---|
《http://blog.sunner.cn/android_pinyin_sorting/》 20090426 孙志岗 android中文联系人排序及检索补丁的原理 1-10 , 2 * |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110086922A (en) * | 2019-04-19 | 2019-08-02 | 上海掌门科技有限公司 | A kind of address book ordering method, equipment and storage medium |
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 |
CN112597244A (en) * | 2020-12-23 | 2021-04-02 | 浙江中控技术股份有限公司 | Data synchronization method and device and electronic equipment |
CN113722480A (en) * | 2021-08-11 | 2021-11-30 | 安徽帕觅智能科技有限公司 | Japanese contact person mixed retrieval method |
Also Published As
Publication number | Publication date |
---|---|
CN101944117B (en) | 2013-04-24 |
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 | |
CN101673186B (en) | Intelligent operating system and method based on keyword input | |
CN103294776A (en) | Smartphone address book fuzzy search method | |
CN101876878A (en) | Word prediction input system and method | |
CN101944117B (en) | Sorting and searching method and system based on database | |
CN101799816A (en) | Method and mobile terminal for searching keywords in mobile terminal information | |
CN101631398A (en) | Mobile terminal electronic-book management system and mobile terminal electronic-book management method | |
CN101645086A (en) | Retrieval method | |
CN104035993A (en) | Memory search method for e-books, e-book management system and reading system | |
CN101459884A (en) | Method and device for processing service | |
CN103354576B (en) | The storage of mobile phone and cell-phone number attaching information thereof and lookup method | |
CN101212739A (en) | Information processing device for mobile communication terminal | |
CN100574340C (en) | A kind of method of searching SMS | |
US20080312901A1 (en) | Character input assist method, character input assist system, character input assist program, user terminal, character conversion method and character conversion program | |
US20090077031A1 (en) | System and method for creating full-text indexes of patent documents | |
WO2011020372A1 (en) | Method and apparatus for performing search in mobile terminal | |
CN102999639B (en) | A kind of lookup method based on speech recognition character index and system | |
US20080104036A1 (en) | Mobile phone capable of building a quick launch item according a search result and related method | |
CN101446975B (en) | File location method and device | |
CN101436203B (en) | Recording index method and apparatus | |
CN101267635B (en) | Chinese input device for contact book of mobile phone | |
EP1964001A2 (en) | Method and apparatus for manipulating data files | |
CN102567768B (en) | Method and device for realizing electronic dictionary based on intelligent card |
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 |