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

Abstract

The present invention relates to a text information service searching method using consonant consonants in a mobile phone terminal. When using an interactive text information service provided by a mobile communication service provider, only target consonants of desired information are displayed to display target information. After that, the information can be selected by using the direction keys to reduce input time and prevent typos, and facilitate service activation and new service development.

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, acquiring a sequence for each consonant, and Acquiring the next consonant for each consonant, constructing an SQL statement through the consonants obtained in the step, acquiring the SQL statement obtained in the step through a database, and acquiring the acquired data And a step of creating a transmission file and transmitting a result to the base station by transmitting the transmission file to the base station.

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. As well as waste of the ship 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. That is, 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 the interactive text information service provided by a mobile communication service provider, only the initial consonants of the desired information are displayed and the target information is displayed. To facilitate service activation and new service development.

According to the present invention, if only the initial consonant of a word for searching in a mobile phone terminal (mobile phone) is inputted, the simple search system searches the contents of a database and then displays the target information including the corresponding phoneme, and the user desires the desired information through a direction key operation. It is a technical task to provide an input and search method for selecting.

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 through the obtained data, and transmitting the transmission file to the base station and transmitting the result to the mobile terminal.

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 diagram and a 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 textual information service (wireless data service) via a 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) Comprising a step (S5), the step of obtaining the data obtained by querying the SQL statement obtained in the step (S6), the step of creating a transmission file through the obtained data (S7), and the transmission file Through the step S8 of transmitting the result to the base station 21 and transmitting the result to the mobile phone terminal, the search word is received and the search result is transmitted.

In the above, the step (S2) of separating the transmitted consonants in the retrieval system 30 is a temporary variable (as shown in FIG. 2, a variable in a program for consonant separation, which is the same as the character transmitted in the copy concept). Acquiring the total length of the temporary variable substituted (e.g. 3) from the transmitted character (e.g. ㅂ. To set the loop count to " 0 " (S22), and if the count number (0) is greater than the total length of the temporary variable (3), it ends, and if it is small, it separates and counts by one second (S23). That is, for example, if the input character is "ㅂ. ㅊ. ㅎ", it counts three times.

In addition, a step (S3) of acquiring the separated SEQ (order) for each consonant, a step (S4) of acquiring the next consonant for each consonant, and an SQL statement (a search sequence) obtained through the obtained consonants 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) to obtain a step (S42), and SQL conditional statement (indicated by "stmt" in Figure 3, which is the statement corresponding to the first letter of the consonant, for example, equal to or greater than "ㅂ", "ㅃ" Generating a smaller sentence) and adding "1" to the variable (i) to obtain the next SEQ, that is, "ts", and repeating the above steps if the reference number is less than "19". That is, in step S52 of generating " h " to generate the conditional statements of these respective SQLs, and in the step S52, if the SEQ is greater than the reference number " 19 " In step S53, a sentence (SQL statement) is constructed. In the 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 "Park Chan-ho", "Chan-ho-ho", "Kang-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 through the obtained data is shown in FIG. 5. This step (S7) is divided into a step of reading the next data from the data database table to the end of file (OFF) and creating a transmission file through this.

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 phone 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) Step S5 of constructing the SQL statement through the consonant, step S6 of obtaining and querying the SQL statement obtained in the step through the database, and creating a transmission file through the acquired data (S7). And a step (S8) of 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. And setting the loop count to "0" (S22) and ending if the count number (0) is greater than the total length of the temporary variable, and counting separately if it is smaller (S23). A text information service searching method using consonant consonants 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 conditional statement of SQL (S51), add "1" to the variable (i) to obtain the next SEQ, and repeating the above steps if the reference number is less than "19". Performing step (S52) to obtain the input SEQ, and generating each of these stmts, wherein in step S52, the SEQ is greater than the reference number " 19 " If larger, step (S53) of constructing an SQL statement from the data database table of the database (31) characterized in that the character information service search method using a consonant consonant in a mobile phone terminal.