TW440778B - Query method for spelling codes of database - Google Patents

Abstract

This invention is a kind of query method for spelling codes of database by the combination of spelling rules and the key/keyword of Chinese to implement a database query method with the advantages of easy query, easy coding, fast input and fast sorting. The disclosed method is based on the spelling rules of Chinese to transform the data types of Chinese index field value into other key/keyword consisting of corresponding spelling codes, and the key/keyword is stored into an index file. Therefore, users can easily key in the corresponding key/keyword of Chinese to be queried according to known spelling rules of Chinese. It is unnecessary to remember the boring numeric key/keyword but can query related information rapidly.

Description

440778 a7 _______ B7 V. Description of the invention () ^ [Scope of application of the invention] The present invention relates to a Pinyin code query method of a database, and is particularly suitable for index fields containing data types of Chinese characters [for example (but not (Limited to): The database of primary key (external index key)], provided by combining Chinese pinyin rules with key / keywords—a simple encoding, fast input, and Sort key / words quickly, making querying easier. [Background of the Invention] The technique of finding specific information through index fields in a relational database is already well known, but in the specific implementation example, the input data type (data based on key / keyword) (data typ〇, can be divided into many different search methods' for example: the input key value / word may be a string composed of numbers, letters, text, or any combination of two or more of the aforementioned data types. Stock market / stock information query as an example. Although investors can quickly find real-time quotes of specific stocks through connected computer software or stock machines, how can investors find the hundreds of thousands of stocks in the fastest way? The stock information that you care about is a very important issue. Because in the changing stock market, time is money. 'It may allow you to make a considerable wealth in a short period of time, or it may make you A lot of money is lost in a short period of time, so investors need to be able to seize those fleeting opportunities. The quick query method is It is indispensable. Only the appropriate scale] Chinese g family standard net (—rNS) Λ4 * 见 格 (2) 0χΐί7: mm y ~~~~ ----- f Please read the back: > (3 · φ ^, then fill out this page)

l1T 4407 7 8 a7 B7 ~ ~ _ V. Description of the invention ()-(谙 Read the notes on the back before filling this page) According to the type of input data of key / keyword, known stocks There are two ways to achieve information query: 1 · stock code input method; 2. stock name input method. By entering the stock code and the stock name, we can find the relevant information of the corresponding stock. But summing up these two input methods, we can find that using the stock code input method is convenient and fast, but it is usually a _ number, and it is difficult to remember. As for the stock name input method, it overcomes the digital stock code. The shortcomings are boring and difficult to remember, but it is inconvenient to use. Whether inputting key values / words by Zhuyin input method or other input methods, its turn-in efficiency is obviously poor and slow. [Summary of the Invention] The object of the present invention is to provide an index field that contains Chinese characters in the data type [such as (but not limited to): a primary index (pri [nary key), an external key (foreign key)] Database, and query methods that can improve the speed of query operations. According to the technical means disclosed in the present invention, according to the pinyin rules of several Chinese characters, one of the data types in the database is Chinese. The index value of the word 'converts to another key value / word (key / keyword)' composed of the corresponding pinyin code. Therefore, users can easily follow the rules of the Chinese phonetic alphabet when they are inquiring about data. , Enter the appropriate key figure / word consisting of the pinyin code, and use this key figure / word to find the specified information. Another object of the present invention is to include an index field with the data type of Chinese characters [for example (but not limited to): primary key, ------- —___ 4___ China National Standard (? 阽), 4 specifications (2! 0 > < 297 public *) — A7 B7 4407 7 8 V. Description of the invention () '~~ External key (foreign key)], build a database The database index block of the material type is the pinyin code, which is used to improve the operation efficiency when querying. Another object of the present invention is to provide an area that is applied to different Chinese Pinyin rules, and can still include index fields that contain Chinese characters in the data type [for example (but not limited to): a primary key (prifflary key), External index (foreign key)] database, a fast method of query. The technical content and embodiments of the present invention are described below with reference to the drawings. [Schematic description] Figure 1 'is a data architecture diagram of the first embodiment of the database of the present invention. FIG. 2A is a data structure diagram of the embodiment of the database of the present invention, showing the structure of the index file of the pinyin code. FIG. 2B is a data structure diagram of the embodiment of the database of the present invention, showing the structure of the index file of the phonetic code. Fig. 2C 'is a data structure diagram of the embodiment of the database of the present invention, showing the index block structure of the Cantonese code. Figure 3 is a character comparison table of Zhuyin symbols, continental pinyin, and pinyin codes. Figure 4 is a character comparison table for Cantonese Pinyin, Continental Pinyin, and Pinyin codes. Fig. 5 'shows a transcoding block diagram of the Pinyin code of the present invention. _The size of this paper-~~ --—— (诮 Please read the note on the back of the book 4 written book) Binding · Seed setting: * Ministry of Zhongrong Standard Bureau κί, τ Consumer Goods Co., Ltd. Printing Purple 〇7 7 8 Α7 ______ Β7 _ ~ ~ '-5. Description of the invention () Figure 6' is a diagram of the embodiment of the index file of the present invention. H-n I n II— In n-n 1— I n T (Please read the precautions on the back before filling out this page) Figure 7A shows the invention using the cone sort (Heap s〇rt) method as an example Will the pinyin code be searched for?丨 Block diagram of an embodiment flowchart. Figures 7B ~ 7G show the binary tree data structure diagram corresponding to the sorting process of Figure 7A. Fig. 8A 'is another flowchart of Fig. 7A, which shows the flow of reordering. Figures 8B ~ 8J show the restructured binary tree data structure diagram corresponding to Figure 8A and the output ranking results. Fig. 9 'is a flowchart of a first embodiment of query execution according to the present invention. Fig. 10 'is a block diagram of the hardware structure of the present invention. Fig. 11 'is a flowchart of a second embodiment of query execution according to the present invention, showing the process of querying by dichotomy. Fig. 12 'is a data structure diagram of the third embodiment of the database of the present invention. Fig. 13 'shows a daylight surface according to an embodiment of the present invention, showing a case where a pinyin code is selected as an input type. Fig. 14 'is a screen according to an embodiment of the present invention, and shows a case where an input type of a phonetic code is selected. Fig. 15 is a screen of an embodiment of the present invention, showing a case where a Cantonese code is selected as the input type of a pinyin code. Fig. 16A is a schematic view of a query operation screen of the present invention, showing the input of the first pinyin The result after the code. FIG. 16B is a schematic view of the query operation screen of the present invention, showing the country of the paper size system and country __) (210x297 Gongmeng 7 " " ~~

4 4 07 7 B A7 B7 V. Description of the invention (.¾¾ 4i.t- Bureau Yuegong Consumer Cooperatives Co., Ltd. printed $ !. The result after entering the second pinyin code. 6 C 'is the invention Schematic diagram of the query operation screen, showing the result after entering the second digit phonetic code. Figure 7 A is a schematic diagram of the query operation screen, showing the result after entering the first phonetic code. Schematic diagram of query operation screen, showing the result after inputting the second digit phonetic code. Figure 7C 'is a schematic diagram of query operation screen, showing the result after inputting the second digit phonetic code. Figure 18A' is the invention Schematic diagram of the query operation screen, showing the result after entering the first Cantonese code. Figure 1 8B 'is a schematic diagram of the query operation screen of the present invention, showing the result after the second digit of Cantonese code is entered. Figure 18 C' This is a schematic view of the query operation screen of the present invention, showing the result after entering the third-digit Cantonese code. [Explanation of the embodiment] Before starting to explain the technical content and embodiments of the present invention, first The symbols and nouns used in the following are explained as follows: 1 · About the field name in the database is marked with "" before and after. About the type of data in a block in the database (such as from type) The F symbol is marked before and after. A bottom line "" is added below the key value / word. ', *' · '----- 〇 According to the technical means of the present invention, the 7th of the database is carried out with pinyin codes. No. 2 3 _______7_ Wood Paper Music Scale Luzhou Chinese Family Home (('NS > Λ4 Specification (210X297 Gt)-i 11 II —-m 1- nl dn--III I t! (^ 1 (诮 Please read the notes on the back before filling in this page)

The "quotation in the Ministry of Foreign Affairs" ^ 吴 -7 · Consumption is included in private printing and inquiries can be achieved by the following two stages of implementation: The first stage is in the index field containing the data type of Chinese characters [ For example (but not limited to): In the database of the primary key and the foreign key, create a database index position of Pinyin code of 1 mile (hereinafter referred to as " ,, pinyin > * w bit)) to improve the operation efficiency when querying. The second stage: In the database established in the first stage, using the pinyin code as the key value / word (key / keyword) of the query to perform information inquiry and output the result of the inquiry. — In order to specifically explain the technical means of the present invention, in the following examples, the content and inquiry method of the stock market / stock database will be taken as examples to explain. [First stage] According to the goal of the first stage, firstly, at least one database is set up in a database containing at least relevant information fields such as "share $ data and stock name". Record the "Pinyin Index" field of the pinyin code (as shown in the "Picture"); of which, the stock name "-the data type of the field must be" Chinese characters "(for example: Acheng (Steel); of course, the name is expressed in terms of the basic concerns of the database. This stop does not have to be in a table that is the same as the "Pinyin Index" stand. If it is related The database is structured. The column "Stock Name" and the "Pinyin Index" can be placed in different data tables that are related to each other. As long as the query results can be provided, users can represent this. Only the information of the stock name is sufficient. Therefore, using "Chinese characters" as the data type will be I. ^ _ --- Order (please read the notes on the back before filling this page) Β ft 逆 部 屮 " Standard Bureau Negative two Superimposed by the Bamboo Club printed A7 B7 V. Description of the invention () A better choice. As for the Pinyin Daima's "coding rules" recorded in the a field of the spelling a, the same data in the database (the so-called The same / pen data contains at least the "Stock Name", "Pinyin Index", "Stock Data" and other blocks) in the "Stock Name" niches, the first letters of each Chinese character in Pinyin are arranged in order String, and this string is the key / word of the index field [for example (but not limited to): primary key, external key] that can be used for query. From the facts of the rule of thumb, in mainland China, Taiwan, and Hong Kong, etc., the Chinese pinyin rules are not the same. Therefore, if only the Chinese pinyin rules of a single region are used to create the "Pinyin Index" field The recorded pinyin codes are bound to cause inconvenience to users in other areas, and this result is also a problem to be avoided by the present invention. Therefore, in the above database structure, it is necessary to establish a distinction Record the Pinyin Index of the applicable Pinyin codes in different regions. In the present invention, the Pinyin codes applicable in Mainland China, Taiwan, and Hong Kong are temporarily taken as examples to illustrate the structure of the query database. The database structure is shown in "Figure 2A-2C", which is based on the Chinese Pinyin rules for 'Taiwan, Hong Kong, and other regions of China. Three index fields that are applicable to different regions are created. It is easy to distinguish, in the respective names, "continental code" stands for mainland China, "Zhuyin code," stands for Taiwan, Cantonese code, and Hong Kong. In principle, in order to make users in all regions familiar with it Pinyin rules for inputting pinyin codes required for inquiries ,,, and spelling __________________9 _ This paper ruler g wealth information (rNS) Λ4 specifications (210X297 public ΰ ΰ----~ __ nn n ^ ii -f I.-- -----11 ---- I-I --t ^ i (Please read the notes on the back before filling this page) 4

7 B A7 ---------- B7 I 丨 丨 ----—— __ V. Description of the invention () ~~~ The contents of the "Sound Index" block should be based on the Pinyin letters used in each area Or Pinyin waiting number is better for its data type, for example: 1- I: 1 n 1 ί 1- -I I. III! -1 an — I I- I. 1 ^ T (Please read the note on the back first Please fill in this page again for the matter} "Continent Code" directly uses its customary "English alphabet" as its data type; '' '' Zhuyin Code "directly uses its customary" Zhuyin Symbol "as its data type; ~" Cantonese Code " Directly adopts its customary "English letter is the type of filling." In addition to mainland China, Taiwan and Hong Kong can also use the "Zhuyin code" and "Cantonese code" according to the comparison table not shown in "Figures 3 and 4". The value of, is converted into "Pinyin Code" with "English letters" as its data type, and stored in the same index file (as shown in "Figures 2B ~ 2C"). Because the phonetic symbols are already on the standard keyboard There is a unified configuration position, except that every _3 symbol is used as the key / word value of the phonetic code You can also directly use the keyboard value (such as English letters, symbols, or numbers) corresponding to the Zhuyin symbol as the data type of the Zhuyin code, and the value of the Pinyin code in the comparison table in Figure 3 is based on this principle. Example: "Stock name" is "Dali Papermaking", except that the phonetic symbol ϊι3 V iH. Can be used as the key value / word of the "phonetic code". If it is based on the conversion table, its phonetic code is 2χγ5. Pinyin codes for each region " The establishment method and rules are as follows: '[Mainland Pinyin Coding Rules] 1 Take the first letter (in English) of each Chinese character in the "Stock Name" block in sequence, and form a string of characters. "1 I — —, II. ------- 1 Π This paper is made of towels_ 家 鲜-Λ Π7 7 8 A7 B7 2 Example 5. Description of the invention (Key values / words of the mainland code field. Example: listed in Shanghai The stock— "Guo Jia Industry", whose first 1 仏 'is sequentially taken as a string consisting of the first letter of its Pinyin as "GJSY" (case uppercase and lowercase, ^ Fengzi J curse), so it corresponds to " "Stock Name" is "Guo Jiashi Purple ΑΛ-> A + industry J # 音 索? Ί "column, the key value / word is: GJ3Y 0 For double-byte pinyin such as ΗΗ 'CH' SH in pinyin, the same as ζ, c's is the first Pronunciation—like, unified—replaced with Z, C, S. The name of the stock is "Sichuan Changhong 丨 Li Li Li% 1 Zhanhong" with pinyin: ii £ huan £ hang i [〇ng, where The double-byte Pinyin Ch only needs to take the first letter C, so the stock name corresponds to the "Pinyin Index" block of "Sichuan Changhong", and its key value / word is: SCCH. For stocks that include A shares and B shares in the "Stock Name", A 'B is also replaced by its original letter a, b. "Stock Name"-"Shenzhen Development A", its pinyin is: Youku (Shen) [a (发) lhan (展) 4 (A), so it corresponds to the "Stock Name" "Shenzhen Development A" Pinyin index, , Field, and its key value / word is: SFZA. [Zhuyin Pinyin coding rules] The rules for coding Pinyin in Taiwan are the same as above. Only the first place of Zhuyin Pinyin for each Chinese character is selected. Phonetic symbol; For example: "Stock name"-"Dali papermaking", so it corresponds to "Stock 11 paper size Shizhou Chinese storehouse standard 嗥 ((WS) Λ4 size (210X 297 public)} ------ --Installation ------ Order (please read the notes on the back before filling this page) Example: ¾¾Ministry of Zhongyu Standard Bureau β 标准 消 Η 合 竹 社 印 ^

： 7 S A7 _____ B7 _ * ™ * · __- ——-— —--V. Description of the Invention () The "Zhuyin Code" field of "Dali Papermaking" has the key value / word as: 9? ^ v} ϋ. Of course, you can also convert the key value / word of the phonetic symbol type according to the comparison table in "Figure 3" to convert the "phonetic symbol" into the corresponding "English letter" in the unified "Pinyin code" table, which is 2W5, and Become, the key value / word in Zhuyin Code; whether it is the type of data that uses "Zhuyin Symbol" as the "Zhuyin Code" block, or the "English alphabet" that has been converted as the "Zhuyin Code" column The type of data, or the use of both, is not limited in implementation. It depends on the needs of the user. [Cantonese Pinyin coding rules] 1. The coding rules are basically similar to the coding rules of mainland Chinese pinyin. 2 · For the conversion of Hong Kong's Cantonese Pinyin and the English alphabet of "Pinyin Code", please refer to "Figure 4". 3 · When special pinyin is encountered in the monogram pinyin, such as ts, dz, the Cantonese code is "take the first letter t and z. For example: stock name"-"Dongbai Group", corresponding to "stock name" The "Cantonese code" for "Dongbai Group" is dbdt. The content of the pinyin index ', the fields (including ,, the mainland code "," Zhuyin code "Cantonese code,'," pinyin code, "can be completed in the way shown in" Figure 5 ", its basic The functional structure is based on a transcoding unit 9 5 according to the conversion table shown in "Figures 3 and 4", which sequentially takes the first letter of each Chinese character in ', stock name' and its Pinyin, and then converts it into the corresponding "Continent code" ,,, Zhuyin code ,,,,,, Cantonese. This ————————— f Please read the notes on the back before filling out this page > Pei, 1Τ ι \ 1 Β ΑΊ Β7 V. Invention Note ("Code") and other key values / words ", and the data type of this key value / word is as described above, which can be" English letters "or" F Zhuyin symbols "compared with" Pin Yin code ", Basically, the data type of "Continent code" is "Pinyin code", so it can be regarded as the same. Therefore, in the index broadcast shown in "Figure 2A", only the "Continent" is recorded in the field. Code. " In the query method that generally uses Chinese characters as the key value / word of the query, 'Because of the large vocabulary of Chinese characters', we cannot determine the user's input based on a simple pronunciation combination such as extracting the first letter of each Chinese character pronunciation, but for For querying stock information, the number of Chinese stocks and the number of Chinese characters included in the index block are limited. For example, the name of a general listed stock can be identified and distinguished by only 4 to 6 Chinese characters. We can use simple Pinyin rules and combinations to allow users to quickly input, in order to achieve their rapid positioning purpose. However, as far as the above examples are concerned, in the process of implementation, the user may only need to input the two "English letters" or "Zhuyin symbols" in the key value / word of the "Pinyin Index" block, and they can check To the desired stock information. However, since only the first letter of the Chinese pinyin of the order text is taken, two problems will inevitably arise. That is: the double-code phenomenon and the one-to-many phenomenon; for example, "Dajiang shares" and "Duojia shares", The "continental code" is all DJGF, so there are multiple corresponding "stock names" for the same pinyin code. The solution is to use smart query method to solve it. The specific implementation method is when the user enters the pinyin code to query , The search engine will display all stock names that match this pinyin code for use in this paper scale, ® gj $: 料 (('NS) (21〇Χ297 / > «_) " ~ (Please Read the precautions on the back before filling in this page.) Equipment · -1Τ 妗 治, .Qiu Zhongbiao ^ β-τ eliminates the private seal with bamboo $, 'A7 B7 L, the invention description () The further selection and determination In order to achieve the purpose of quick sorting and querying, the present invention arranges the key values / words of the "Pinyin Index" field applicable to different regions into an index in the order of "English letters (or" Zhuyin symbols "). File so that To implement the smart query method mentioned above, assuming that the maximum number of characters preset for the stock name or "Pinyin Index" blocks is four, this arrangement should be completed in four steps , The first is to sort the first letter of the key value / word in the "pinyin cable bow" block, then the second letter, the third letter, the fourth letter in order, and the structure diagram is like " As shown in "Figure 6", an array of any one of the letters is provided with an indicator Ptr (Pointer). With the connection of the indicator ptr (iink), the corresponding stocks can be turned in turn in order to find the corresponding stock. The "Figure 7A ~ 8J" shows an example of the present invention sorting the key values / words in the Pinyin index field in order, which reveals a way of sorting by cone (heap s〇rt ) Method to perform the sorting function flow chart, because the cone sorting method is one of the known sorting methods, so only the data of "Table 1" is used as an example to illustrate the sorting in conjunction with the flow chart of "Figure 7A" The way;

Node 1 — 2 3 4 1 5 ~ 6TT] 8 9 ΤίΡ Data 26 5 77 1 ^ 1 61 π 59 15 L- J _48 trri table According to the flow chart of "Figure 7 A", the steps include: S1 : Start stacking (ordering) from disordered records; that is, turn the order | Team Zhang Chipeng Peng] in the transfer material (rNS) Λ4 specifications (210X 297 mm) -------- binding ( Please read the notes on the back before filling this page] 8 a A7 _________B7 V. Description of the invention (, '~ ^-The information entered is built into a complete binary tree as shown in "Figure 78", and the so-called, ", Build a pile", in this case, the system H builds a binary tree whose value of the parent node is not greater than (or not less than) the value of its left and right child nodes. Note: In the "Figure 7C ~ 7G" In the example, a binary tree built with a parent node whose value is not greater than the value of its left and right child nodes is taken as an example for illustration. S2: If there are η records, then from L n / 2 The data of the pen (that is, the data of / = L η / 2-1) starts to be sorted as the root node. After completing the sort of the pen data, the node is sequentially decremented until the first data (that is, node = 丄) is skipped. To step Complete a sorted binary tree (as shown in "Figure 7G" S3: temporarily store the value of this root node into the temporary register as a reference record (reference value); 54: determine the node of this reference record Is the position value not greater than the total number of nodes in this binary tree, and does the sorting operation of step S2 end? If yes, go to the next step, if not, skip to step S2; 55: If there is a right child in this reference record Tree, compare the left and right subtrees' and perform the sorting action in the direction of the smaller terminal node (downward); 56: determine whether the reference record is less than the minimum value in the left and right subtrees; if yes, skip to step S2 Sort the next data (sort the existing node__l), if not, skip to the next step; The paper size is 财 赖 赖 料 料 (('NS) Λ 视 (210X 297 公 楚) 1 --- ------—f 1 -I u I- mn I—-1 __-, order (please read the notes on the back before filling this page) Α7 Β7

V. Description of the invention () ^ -¾ • Blow in the ministry ^-^ Bing Erxiao at the cooperative seal " 57: Reverse the minimum value in the left and right subtrees with the position of the root node of the reference record, and then with its left and right subtree The minimum value in the comparison, then skip to step S4; and 58: end the cone sort. The complete unary tree created in accordance with the data entry order listed in "Table 1" (as shown in "Figure 7B"), and the results of sequential execution according to the above steps can be represented by "Figure 7C ~ 7 G" see;

When node = 5 (that is, n = 5), n5 (61)> nl0 (19), so n5 is swapped with nlO (that is, n5 = 19, and nl0 = 61). The adjusted result is as shown in "Figure 7C" ; When node = 4 (that is, n = 4), n4 (l) < min {n8 (15), n9 (48)}, so there is no need to adjust the data structure, and the adjusted result is as shown in "Figure 7D"; node = 3 (that is, n = 3), n3 (77) > min {n6 (ll), n7 (59)}, so we swap n3 with n6 (that is, Π3 = 11, and n6 = 77). The result is shown in the “7th E diagram”; when node = 2 (that is, η = 2), n2 (5) > min {n4 (l), η5 (19)}, so η2 and η4 are reversed (that is, η2 = ΐ , And η4 = 5), the adjusted result is like the “Figure 7 F”; when node = l (that is, n = l), nl (26) > min {n2 (l) 'n3 (U)}, so Swap nl and n2 (that is, η = ι, and n2 = 26), and adjust the new n2 (26) &min; n {n4 (5), η5 (19)}, so η2 and η4 are swapped again (that is, η2 = 5 'and η4 = 26), and η4 and η8 are swapped in the same way (that is, η4 = 15 and η8 = 26), and the result after the final adjustment is like "Figure 7G". So far, the establishment of a sort The action of a binary tree. _________! 6___________ This paper is suitable for ΛChinese S family standard Wei (ΓΝ5) Λ4 size (2 丨 0X 297 mm) -1 t 11 1- I--1 Less ^ II-. ≫ 1-- ^ 14 -sa (Please read the notes on the back before filling out this page)

1 07 1 B A7 ---_____ B7____ V. Description of the invention () ^ Continue to perform a cone sort on the complete binary tree of the "7th G 圏" according to the flowchart of "Figure 8A", The steps include: S11: Obtain a sorted binary tree as shown in "7G graph j; S22: Determine whether the number of nodes of the sorted binary tree ^ (iiode) is greater than or equal to 2 'if yes Then proceed to the next step, if not, skip to step s55; S33: Swap the first node with the last node, and then output the value of the last node; S44: Rebuild a sorted binary tree according to the above method Readjusted into a complete sorting binary tree; and S55: ending cone sorting. The results of the sequential execution according to the above steps S11 ~ S55 can be seen from r 8th B ~ 8J "; node = 10 (ie n = i〇) 'Swap 111 (1) and η1〇 (61) to the left of "Figure 8B", and output the value of η1〇 (1), and reorder them to the right of "Figure 8B" Node = 9 (that is, η = 9), swap nl (5) and η9 (48) to the left of "Figure 8c", and output η9 (5), and reordered to the right of "Figure 8C"; 11〇 If = 8 (that is, 11 = 8) ', swap 111 (11) and 118 (61) into "Figure 8〇" "The one shown on the left, and the value of n8 (u) 'is rounded and reordered to the" Figure 81 "The one shown on the right; node = 7 (that is, n = 7)' will be nl (15) Contrast with n7 (59) to the one shown on the left of the "8th graph", and output the value of n7 (15), and reorder ----; -------- 17 paper method X degrees 谪State Central National Standard (TNS) {270 ^ 297¾) ------- (Please read the precautions on the back before filling this page) Binding 44〇π a A7 ^ '_________ B7 V. Description of the invention () '一 ~~' --- Become the one shown to the right of "Figure 8 E"; pn〇de = 6 (ie ^ 6) 'Reverse 〇1 (19) and n6 (77) into "Figure 8" What is left is left, and the value of n6 (ig) is input, and reordered as shown in the right of "Figure 8F"; 〇⑽ ## (that is, n = 5) 'will be nl (26) and n5 ( 61) Reverse to the left of "Figure 8" and round out the value of n5 (26), and reorder the ones shown on the right of "Figure 8G"; H n〇de = 4 (ie η = 4) 'Put nl (48) and n4 ( 77) Reverse to "the 8th 圏 J does not exist on the left side, and round out the value of π4 (48), and reorder it to the right side of the" 8th Η graph "; I n〇de = 3 (ie η = 3) 'Reverse η1 (59; ^ η3 (61) to the one shown on the left of the "8th graph", and output the value of η3 (59), and reorder it into the figure on the right of the wide 8 " ; 〇de = 2 (that is, η = 2), η1 (61: ^ η2 (77) is reversed to "the 8th one shown on the left, and the value of η2 (6ΐ) is output, and finally η (77) Value, so that a cone sorting action is completed. [Second stage] The Ministry of Education's Ministry of Foreign Affairs-T-elimination Han Zuoshe Yinfan — 1 1 ^ 1 ^ nm n ^ i I 1 .11— I-I 1 ^ 1 i 1. · # ^-so (Please read the notes on the back before filling this page) "After completing the first stage of the goal, use the Pinyin code as the key value / word in the database established in the first stage ( key / keyw〇rd) to query information and output the results of the query. The query process and the implemented hardware structure can be seen in "Figure 9, 10", which includes the following steps: 1. By One input unit 90 (such as keyboard, mouse, light pen, etc.) to input the key / keyword of the query. Quasi (('NS) six shirts first grid (2) 0〆297 mm) λ 40 7 b A7 B7 V. Description of the invention () is the pinyin code; 2, find and store in a storage unit 9 2 (such as memory , CDs, disks, magnetic tapes *, and other recording media); (that is, according to the order of key / keywords entered, by a search engine 9 1 (such as search Or MPU (micro process unit)) to find its position in the index file) 3 _re-define the search range; (that is, it is linked to the index (Ptr) of each key value / word in the index file to Position of the next key value / word in the index file, and finally find its linked information such as "stock data" by the search engine 9 1) 4 · Determine whether the search in step 3 was successful? If yes, go to step 7 If not, proceed to the next step; 5 · Determine if the key figure / word number entered is equal to the maximum character length of the pinyin code? If yes, proceed to the next step; if not, return Go to step 1 and wait for the user to re-enter the key figure / word of the query; 6 · Find data similar to the key figure / word for the user to select and confirm 'and skip to step 8; (For example, the input pinyin code is AEDC, but the data Only the data such as AEDB and AEDH are stored in the database. The first three key values / words that are the same, or the data of the adjacent pinyin code AEDC, such as feet, are regarded as similar data and displayed in a display unit 9 3 ( Such as a display) 9 0 (Input devices such as keyboard, air-scraper, light pen, etc.) Select and confirm.) 7. Obtain the information obtained by the search (such as "Stock Data" or "Stock Name" 'Refer to the "Day 16" display ); And ____] 9 paper rule cans) kinds of materials) Λ4 specifications (centimeter) " ~ n ^ in In -II i f'J Je (Please read the precautions on the back before filling out this page >

Oil V. Description of Invention (

Wait for a round of the unit 94 (such as the display, the printing device is damaged. · = Words or the query selected and confirmed by the user and in actual implementation, the cattle in the script include: Λ Among them (Please refer to " iwork drawing ”spelling =, / select the pinyin code _; (The yinling rules in each region described by m are different, # 姑 ^ j J. With this step, the user can Feng Zhangan code, such as "English alphabet" is a character "Pin: The type of the data of the second spell, or the type of the data type with the" Zhuyin symbol "as the character * day code) Load the corresponding pinyin code type selected in the above 2 2 Indexing right. 1 2 "" is another _ * feasible "in the Bekoku structure for querying. The index" in addition to the above-mentioned "Pinyin is often a number", of course, it can be increased. "Stock code" (pass: is a number to the code), for users to choose which query method to read, please read the intent and then%% Binding on this page ^ " • 部 十 " sample rate " 7 negative Second elimination " 合 ft 社 印 & quot:: a search method, such as " Take the dichotomous figure 11 in Figure j, and two_ as an example. The query flow is two and two: Γη 'is A in order, and the data is the middle term (in the middle term of a certain word, the force term). It can be converted into the ASC code values corresponding to d and 疋 in the Pinyin code.) It is divided into upper and lower halves. In V, the input key value / word is greater than the middle term of the data: the second term is larger than the middle term, then it is discarded. The lower part of Bobby "疋 searches for the above main stem I. The above A, B way continues P; C, if it is smaller than the middle term 'then discard the upper half and press 20 paper rule money_ 杂 彳 (75s ) Λ4 specification (2) Ox 29 ·? 公 # 〇1 A7 lil V. Description of the invention (The method described in A and B continues to search for the lower half of the item. The corresponding process in steps B and c above is known Please refer to (13th to 15th) after taking the picture, to understand the implementation example of the present invention through the display situation of the display unit 93 during the actual check of the tenth and the input process of the input unit 90, such as "the first "Figure 3" shows' When you want to query a stock information, the stock does not query the function, the user can use the input unit 90 (the first one in the picture) Touch display interface interface) Switch the type of pinyin code to be selected for input = "Pinyin instead of Shima" ("Picture 13" is indicated by ,, pinyin ,,), code "(see" 第 1 Figure 4 "), or Cantonese code (see" Figure 15 ").… Take Α 陆 code, which is the type of data type Α" Pinyin code ") as an example to explain that you want to check that the dog Pinyin code is the ancestor's query Process: First, we enter the English alphabet of the first Pinyin code as ", D". The displayed result is as shown in "16A 圏". All the first alphabetical codes of the Pinyin code are "D", The display order of stock names is in the order of the English alphabet of the second digit Pinyin code. Secondly, enter the English alphabet of the second digit Pinyin code. The result is as shown in "Figure ...". The letters of the pinyin code are “'and —τ„ brother — the English son of the pinyin code is the name of all “stocks”, and the name is in the order of display, and the letters of the pinyin code are arranged in order. Applicable national standards (cNsT ^ jTir ^ k ^ y D, To find the information I want to search), you can refer to "Figure 11" _______________ ¾ ----- 11 (please read this first and pay attention to the city ears to fill in this κ)-= s HI ---, -I— I i 440778 A7 B7 V. Description of the Invention (Continue to enter the third letter of the alphabetic code in English. The display result is as shown in "Figure 16C". The first letter of the alphabetic code is " D ", All the "stock names" of the English alphabet of the second digit Pinyin code " J "'and the English alphabet of the third digit Pinyin code are " g", the display order is the English of the fourth digit Pinyin code The letters are arranged in order. In principle, you should be able to find the name of the stock you want to query from the displayed list. Otherwise, enter the fourth letter of the Pinyin code to find the stock name you want. Similarly, if the user chooses to use "Zhuyin code," (that is, the type of data entered is "Zhuyin"), or select, "Cantonese code" (that is, the type of data entered is "Cantonese Pinyin"). The screens are shown as "17A to 17 (: pictures" and "18A to 18 (: pictures", respectively.) [Effects of the invention] 1. The present invention proposes a kind of Chinese pinyin rules and key values of index fields / Key (key / keyword) combination of fast input query method, its simple coding, fast sorting, convenient input, will make the weekly handy in use. 2 'Fast access to stock code rotation and stock name input method Combined with easy-to-remember method, it provides an easy-to-remember quick input method of pinyin code. [Illustration of Schematic Symbols] ..... Input Unit 91 ..... Search Engine --------- --- 22 This paper size applies to Chinese National Standard (CNS) A4 specifications (2) 0X297 mm, one mu 1— ^ ϋ ^ fn n ^ 9 ^ V, T f Please read the notes on the back before filling (F) Consumption cooperation with employees of the Central Bureau of Standards of the Ministry of Economic Affairs Printed by the Central Bureau of Standards Staff Consumer Cooperatives 31 Five 'Invention Description () 9 2 * * * • Storage unit 9 3 · · • Display unit 9 • Output unit 9 5 * * * * • Transcoding unit' 1 ~ 1 i I ~ '^ 农 I 1— “. I order (please read the precautions on the back before filling this page) This paper size applies Chinese National Standard (CNS) A4 specification (2〗 0X297 mm)

Claims (1)

4 Printed by the Consumers' Cooperative of the Central Standards Bureau of the Ministry of Economic Affairs 4407 7 8 Scope of patent application • A method of searching for code in a database, which is applied to a database of index fields in Chinese characters, including The following steps are established in the = library. According to the Chinese Pinyin rules of the Chinese character, the library # ^ ㈣ is a database index field (hereinafter referred to as the "Pin Yin Index" bit) corresponding to the exhaustion of the Chinese characters. Pinyin is used as the key / keyword of the query to search the information in the database and input the result of the query. Such as applying for the first batch of materials! The pinyin code query method of the libraries mentioned in the item above is that the database includes information blocks that are linked (associated) with the pinyin index to store related information. According to the Pinyin code query method of the database described in Item 丨 of the patent application scope, the index field of the database can also include the general stock code (numeric code). The database pinyin code query method described in item i of the scope of patent application, wherein the pinyin code is a string formed by sequentially taking the first letter of the Chinese pinyin rule for each Chinese character in the index stop And the string is the key value / word of the index field. According to the Pinyin code query method of the database described in item 4 of the scope of the patent application, where the string is obtained in accordance with the mainland Chinese pinyin rules. According to the Pinyin code query method of the database described in item 4 of the scope of patent application, the string is based on Taiwan ’s Zhuyin Pinyin rules (24 phonetic notations, using Chinese National Standards (CNS) Λ4 specification (2 丨 0X 297 Gong Tang: 1 ^ ------ 'Order ------,% l · (Please read the notes on the back before filling this page) 44077 8 A8 B8 a Bureau Co., Ltd. ’s consumer cooperation, Du printed equipment, patent application scope number). 7 · As for the Pinyin code of the database described in item 4 of the scope of patent application, go to 'where the Shai string is obtained according to the Cantonese staircase rules in Hong Kong. α 8 'Go to the Pinyin code of the database as described in Item 4 of the scope of patent application', where the string is obtained based on a Pinyin code (English son and daughter). 9 * As in the database of Item 8 in the scope of patent application Pinyin code query method 'where the pinyin code corresponds to the Chinese pinyin rules of Mainland China, Taiwan, and Hong Kong. 1 0. The database of Pinyin code query method as described in the first item of the scope of patent application' where the pinyin code is obtained by A transcoding unit is obtained. 1 1 · Query the Pinyin code of the database described in item 1 of the scope of the patent application, where the pinyin cord 5 丨 襕 is the primary key. 1 2 · As in the pinyin code of the database described in item 1 of the scope of patent application Query method 'where the pinyin index block is a foreign key. 1 3 · The Pinyin code query method of the database as described in item 1 of the patent application range', where the pinyin index field is stored as an index file , And link (correlate) to the corresponding information in the database. 1 4 · As in the Pinyin code query method of the database described in item 13 of the scope of patent application, the second step includes: (1). Enter The key / keyword of the query is the pinyin code; (2) 'Find the index file; (3)' Reset the search range; (that is, according to each paper size in the index file that applies to China) National Standard (CNS) A4 specification (210X297 male 嫠 i ------, 玎 ------ 4 (Read the notes on the back of the poem before filling this page) '44-07 7 B __ VI. Application Patent range key-value / word metrics linked to next key / Word in the index file 'to find its linked data) (4), determine whether the search in step (3) is successful? If yes, go to step (7)' If no, go to the next Steps; (5) · Determine whether the input key value / word number > = the length of the phonetic code of the phonetic code? Right 'is yes, then proceed to the next step, if not, return to step (i) Waiting for the user to re-enter the key figure / word of the query; (6) ♦ Find data similar to the key figure / word for the user to select and confirm, and skip to step (8); (7). Obtain the data obtained by the search; And (8) * output query results that match key values / words or selected by the user for confirmation. 15. The method of querying the Pinyin code of the database as described in Item 24 of the scope of the patent application, wherein the step (1) further includes: (1-1) _Select the input type of the Pinyin code; and (1-2 ). Load the corresponding index file according to the selected Pinyin code type. 16-A method of creating a key value / word using a Pinyin code as a query in a database containing an index block whose data type is Chinese characters is to sequentially take each of the Chinese characters in the index block. The string consisting of the first letter of the Chinese pinyin rule. The string is the key value / word of the pinyin code used in the query. 1 7 · The method as described in item 6 of the scope of patent application, wherein the word content is 26 paper standards applicable to Chinese National Standards (CNS) --- --------- equipment ------ order ------ Grade (Please read the precautions on the back before filling in this page > printed by 4 ^ 0778 AS BS cs "! 08 VI. The scope of patent application ~ 1 ~ It is obtained according to the A land pinyin rules of the mainland of China. Β 1 8: The method described in item 16 of the scope of patent application, wherein the string is based on the Taiwan phonetic alphabet (Symbol). 19 The method as described in item 16 of the scope of the patent application, wherein the string is obtained according to the Cantonese Pinyin rules in Hong Kong. 20 The method as described in item 16 of the scope of patent application β, where the string Obtained according to a pinyin code (English mother and son). 21 * The method described in item 20 of the scope of patent application, wherein the benchmark pinyin code corresponds to the Chinese pinyin rules of mainland China, Taiwan, and Hong Kong. The method described in item 16 of the scope of patent application, wherein the pinyin code is a transcoding 2 3 · The method described in item 16 of the scope of patent application, wherein the pinyin index field is the primary key ° 2 4. The method described in item 16 of the scope of patent application, The Pinyin index field is an external key (foreign key). -------- • —Installation ------ Order ------. Line L Please read the notes on the back first (Fill in this page again.) Printed by the Central Standards Bureau of the Ministry of Economic Affairs, Shellfish Consumer Cooperatives-Printed on paper