KR20000053937A - Searching Method of Character Information Service Using an Initial Sound Consonant in Mobile Phone - Google Patents

Abstract

PURPOSE: A method for searching character information services by using initial sound consonants in a mobile telephone terminal, is provided that a simple search system searches contents of a database and displays object information including corresponding characters when inputting only initial sound consonants of a word, and a user selects demanded information through operation of a direction key. CONSTITUTION: A method for searching character information services by using initial sound consonants in a mobile telephone terminal, comprises the steps of: transmitting initial sound consonants of a corresponding searched characters by using a button of the terminal through a base station; dividing the transmitted consonants in a search system; obtaining sequence by divided respective consonants; obtaining a next consonant by respective consonants; constituting a search sequence sentence through the obtained consonant; obtaining the search sequence sentence through a database by checking data; making a transmission file for the obtained data; and transmitting the transmission file to the base station to transmit a result to the mobile telephone terminal.

Description

Searching method of character information service using an initial sound consonant in mobile phone}

The present invention relates to a text information service searching method using consonant consonants in a mobile phone terminal.

In order to input a search word desired by a user using a conventional mobile phone terminal, it is inconvenient to make and transmit a desired search word (for example, Park Chan Ho) by repeatedly pressing 2-3 letters assigned to the corresponding button installed on the terminal. In addition to wasting waste and input time, there is a difficulty in using the button again because the incidence of typos is extremely high when the button is pressed. In other words, when a user wants to search for news, for example, to see information about "Park Chan Ho," "7 (ㅂ) + 1 (ㅣ) + 2 (.) + 4 (a), 9 + 9 (ㅊ) 13 button inputs are required, such as + 1 (ㅣ) + 2 (.) + 5 (ㄴ), 8 + 8 (ㅎ) + 2 (.) + 3 (ㅡ) ".

According to the present invention, when using an interactive text information service provided by a mobile communication service provider, the target information is displayed by inputting only consonant consonants of desired information, and then the information is selected by using a direction key to shorten an input time and prevent a typo. It is intended to be able to import and promote service activation and new service development.

According to the present invention, if the user inputs only the consonants of a word for searching in a mobile phone terminal (mobile phone), the simple search system searches the contents of the database and displays the target information including the corresponding phonemes. The technical challenge is to provide input and retrieval methods for selecting information.

In order to achieve the above object, the present invention provides a method of transmitting a consonant of a corresponding search character through a base station using a button of a mobile phone terminal, separating the transmitted consonant from a search system, and separating each consonant sequence. Acquiring the next consonant for each consonant, constructing an SQL statement through the obtained consonant obtained in the step, and acquiring the SQL statement obtained in the step through a database And a step of creating a transmission file of the obtained data and transmitting a result of the transmission file to the base station.

1 is an overall configuration diagram and a flow diagram of the present invention

2 is a flow chart of consonant separation of the present invention

3 is a flowchart for acquiring the sequence of each consonant of the present invention, acquiring the next consonant of each consonant, and constructing an SQL statement

4 is a flow chart for the retrieved data acquisition of the present invention

5 is a flowchart for creating a transmission file of the present invention.

Figure 6 is a base table configuration diagram of the present invention

7 is an exemplary view of stored data of the present invention.

<Explanation of Signs of Major Parts of Drawings>

10: mobile communication telephone terminal 20, 21: base station

30: simple search system 31: database

1 is an overall configuration and flow chart illustrating the present invention, the present invention is to wirelessly transmit the input signal of the mobile communication telephone terminal 10 such as a mobile phone to the base station 20 to search the contents of the database 31 Hardware means using an interactive text information service (wireless data service) is used through the simple search system (server) 30.

In the above, the database 31 has a base table configuration as shown in FIG. 6, and the stored data is as shown in FIG. 7. That is, it consists of 19 consonants and 52 English letters.

Referring to the overall flow of the present invention through such a system and database 31 as follows. That is, using the button of the mobile phone terminal 10 to transmit the initial consonants of the corresponding search character through the base station (S1), and separating the transmitted consonants from the search system 30 (S2) and separation Acquiring a sequence (S3) for each consonant, a step (S4) for acquiring the next consonant for each consonant, and an SQL statement (a search order sentence) through the obtained consonants obtained in the step (S4) A step (S6) of constructing the data, a step (S6) of acquiring the SQL statement obtained in the step through a database (S6), a step (S7) of creating a transmission file of the obtained data, and a transmission file of the base station ( 21) through the step (S8) of transmitting the result to the mobile phone terminal is to receive the search results are received.

In the above, the step (S2) of separating the transmitted consonants in the retrieval system 30 is a temporary variable (as a variable in the program for consonant separation, the same as the character transmitted in the copy concept), as shown in FIG. And obtaining the total length of the temporary variable substituted (e.g., 3) from the transmitted character (e.g. Park Chan-ho's initial consonant) (e.g. 3), and loop count to "0" to count the temporary variable. Step S22, and if the count number 0 is greater than the temporary variable total length 3, the process is terminated. If the letter is "ㅂ. ㅊ. ㅎ", count 3 times.

In addition, a step (S3) of acquiring the separated SEQ (order) for each consonant, a step (S4) of obtaining the next consonant for each consonant, and an SQL statement (a search order) are obtained through the obtained consonants obtained in the step (S4). As shown in FIG. 3, the step S5 of constructing a sentence) generates an SQL statement when the variable i (for example, 널) is null, and terminates if the variable (i) is null, and a temporary variable (for example, ㅂ) and a variable if it is not null. Substituting (i) in the same manner, selecting SEQ in the field 1, i.e., "8" from the base table (S31), and "19" which is the end number of the consonants as a reference (to distinguish from English) Step (S41) comparing with the SEQ (e.g. 8) obtained in step (S31), and if SEQ is less than "19" in step (S41), the sequence of the next consonant sequence of SEQ (current: 8) (e.g., 9) step S42 and stmt (SQL conditional statement: a sentence corresponding to the first letter of the consonant, for example, a sentence equal to or larger than "보다" and smaller than "ㅃ"). Step (S51) and the variable (i) add "1" to obtain the next SEQ, that is, "ts", and if the reference number is less than "19", the above steps are repeated to obtain the input SEQ, that is, "ㅎ" Generating each of these stmts, and constructing a search order statement (SQL statement) from the data database table of the database 31 if the SEQ at step S52 is greater than the reference number " 19 " (S53). Above, the process will be described in more detail, for example, enter "ㅂ ㅎ ㅎ"

select * from xxxxx (database table)

where Mid (xx, 1,1)> = "ㅂ" and Mid (xx, 1,1) <"ㅂ" and

Mid (xx, 2,1)> = "ㅊ" and Mid (xx, 2,1) <"z" and

Mid (xx, 3,1)> = "ㅎ"

SQL statement (Query statement) is generated. Therefore, the query statement will select all initial data of "ㅂ ㅎ". That is, all of the data such as "Chan Chan Ho", "Chan Chan Ho", "Chang-ho", etc., are selected. This data acquisition is shown in FIG. 4 as a step S6 of inquiring data, and the step S7 of creating a transmission file of the obtained data is shown in FIG. This step (S7) is divided into a step of creating a transfer file by reading the data obtained from the data database table until the end of file (EOF).

The search result is displayed on the display unit of the terminal 10 through the step (S8) of transmitting the transmission file thus obtained to the base station 21 and transmitting the result to the mobile telephone terminal 10, through which the user manipulates the direction keys. By selecting the desired information by, information retrieval is made.

According to the present invention, if only the consonants of the desired information are inputted, the search object including the consonants is limited to be displayed, and the user can access the desired information by operating the direction keys, thereby providing convenience of input work and call time accordingly. In addition to gaining economic benefits from the reduction of the number of times, it reduces the probability of typos in typo input, and provides the vast and diverse information for mobile operators and information providers, as well as facilitating service activation and new service development by simplifying input methods. It has the effect of reducing the cost of building the present invention because it does not need to change the existing built database or mechanically change the existing mobile phone.

Claims (3)

In using the interactive text information service provided by the mobile communication provider, using the button of the mobile phone terminal 10 transmitting the initial consonant of the corresponding search character through the base station (S1), and search the transmitted consonant Separating in the system 30 (S2), obtaining a sequence for each consonant separated (S3), obtaining a next consonant for each consonant (S4), and obtaining obtained in the step (S4) Constructing an SQL statement through the consonants (S5), acquiring and acquiring the SQL statement obtained in the step through a database (S6), and creating a transmission file (S7); And transmitting the transmission file to the base station (21) and transmitting the result to the mobile telephone terminal (S8). The method of claim 1, wherein the step S2 of separating the transmitted consonants from the retrieval system 30 includes obtaining a total length of the temporary variable and the temporary variable substituted in the transmitted character (S21), and counting the temporary variable. Setting the loop count to " 0 " (S22) and ending if the count number (0) is greater than the total length of the temporary variable (3), and if the count is smaller, counting separately by one second (S23). Character information service retrieval method using a consonant consonant in a mobile phone terminal. The method of claim 1, wherein the step (S3) of acquiring the separated consonants of each consonant, the step of acquiring the next consonant of each consonant (S4), and constructs an SQL statement through the obtained consonants obtained in the step (S4) In step S5, if the variable i is null, an SQL statement is generated and terminated. If not, the step S5 selects the SEQ in field 1 from the base table by replacing the temporary variable and the variable i equally. ) And a step (S41) comparing the SEQ obtained in the step (S31) based on the end number "19" of the consonant, and if the SEQ in the step (S41) is less than "19", the next consonant of the SEQ Obtaining the sequence SEQ (S42), generating the stmt (S51), the variable (i) by adding "1" to obtain the next SEQ, if less than the reference number "19" repeating the above steps Obtaining an input SEQ and generating each of these stmts (S52), and if the SEQ at step S52 is greater than the reference number " 19 " Emitter text information search service method using leading consonants in a mobile phone handset that features yirueojim data from database tables of the base (20) to step (S53) to configure a SQL statement.