TWI237775B - Method and systems for screening Chinese address data - Google Patents

Abstract

A system is proposed for identifying orders in an order management system which are to individual or organization having Chinese addresses. The Chinese address items of the order management database, and the Chinese address items of a database of proscribed individuals and organizations, are each converted into respective databases in a common writing system, namely the Pin Yin transliteration standard. In the conversion process, Simplified Mandarin items in the order management database which can be converted in multiple ways are converted in each of those ways. The converted items from the two Pin Yin databases are then compared.

Description

1237775 V. Description of the Invention (1) Technical Field The present invention relates to a method and system for comparing a database of two Chinese items. In particular, the present invention is used to compare data items such as personal and / or institutional addresses. 2. Background There have been various standards for writing Chinese text before 2. In addition to the traditional Chinese subset (which is still widely used in Taiwan and Hong Kong), the People's Republic of China uses simplified Chinese characters to write text. 15 ί〇 Like "phonetic characters, such Roman letters, or other systems such as the Roman alphabet defined as ALA_LC. Conversion between single 4Γ standards is very common, such as a traditional order Two = System (SMARTS) needs to input order = address by ❹Pinyin ^, and then the Pinyin characters are converted into double-byte simplified Chinese characters stored in SMARTS library. Note that some conversions are It ’s very obvious, such as iw 4 'Asia and Africa are right at heart ... The earlier simplified Chinese character can be used (using Pinyin) for several Roman alphabet sets. Similar to a bite (using Pinyin) set may also correspond to multiple simplified Chinese characters Γ The earlier Roman alphabet characters will have different meanings. Μ, since these simplified Chinese characters are stored in different databases, w 'Chinese sub 7 ° can be stored using different standards than u Li's father's database in different databases, such as _ the second P member of the project-a difficult experience ("DPL"), two, & issued a list of developers "do not deal with. The transactions conducted by all parties in this column ^, and ^ will be specially translated from Chinese ~ published in central language (that is, the traditional English language and M and there is no sign of any 2) In the future it will be translated into simplified Chinese characters. Therefore it is difficult to compare lists using names stored in order management systems such as SMARTS ^. The difficulty of comparing the two lists raises a possibility, it It will allow product vendors to tearfully provide the product to the parties listed on the DPL form without special treatment. Such errors may cause damage to the company's interests. This figure solves the above problems, in particular, it provides methods and systems for comparing two 0 databases, both of which include Chinese text data items such as the addresses of entities such as individuals or institutions, and two The database uses different Chinese writing systems for Chinese text data items. In summary, the present invention proposes that the Chinese text items of both databases are converted into a common standard language, especially Pinyin spelling standard (pin he> Transliteratlon standard). During the conversion process, any item that can be converted by multiple methods is converted by these methods, so the items in the two broken conversion databases can be performed. "Compare." The first aspect of the present invention is a computer application method for comparing two databases. Each of the two databases includes 0 Chinese text data items. The method includes: for each- A database that converts any Chinese text data item that is not a pre-defined common Chinese language format into a common format that can be converted into the common format in a variety of ways, at least in the _ Zicai: library Any project has some methods to convert it into the same 1237775. 5. Description of invention (), and one-to-one comparison of some data items with a common format, in order to identify the Chinese text data items in the first-tribute database. Corresponding Chinese text data items in this-database. The second aspect of this month is to propose a method for comparing two data -A computer system, each database includes Chinese text data items with specified addresses, the computer system includes: 10 帛 Transform TL 'used to convert the Chinese text data of the first database into a common common Chinese language Format 'and can be used to convert them to any item in the first database in a common format. All of these methods are converted to generate items with a common format. Chinese text resources, converted into the common Chinese language format; and _ = Chinese text data items in the second item database. The first asset corresponding to the shell item = if the data items in the second database are already common Format, then the second conversion unit can be omitted.

The Chinese language format of Ch is the first to use the Pinyin character ⑽Yin㈣. The first asset library can be the data item of: = and / or pickup address. The first item in the database can be simplified Chinese characters. The second database is a combination of central Chinese or traditional English text and pinyin, for example, the 1237775 V. Invention Description (4 The second database may be some or all third parties published by the second party List. Chinese text data items can be defined as items in the Chinese language. "For example, Chinese characters." Alternatively or in addition, "Chinese text data items 5 items can be defined to include or contain items that are located in the designated Chinese territory." Address-related data items, such as in the People's Republic of China and / or any other Chinese language territories commonly available for ordering and / or shipping (especially in areas with simplified Chinese characters). Note that in addition to the Chinese text data Any item that contains a non-Chinese text data item in the database, such as the order management system, can include data that has nothing to do with China. Similarly, the first shellfish database (such as some or In the case of all DPLs and parties) Including projects verifying that their entities' addresses are not located in the designated China Preferably, in any case, the conversion process only converts Chinese items in each database, and only the comparison determines whether the converted item in the first database is converted with the second database The items correspond. Brief introduction to the drawings Additional advantages and features of the invention related to the described examples of the invention will be discussed, just as an example, referring to the following drawings, which include: Figure 1 is used to show Block diagram of the method as a specific example of the present invention; FIG. 2 疋 Structure of the system as a specific example of the present invention block 1237775

Figure 'Dagger' is used to implement the method of Figure 1. Figure 3 shows a window generated by the system in Figure 2, which is used to form the simplified Chinese character address obtained from Pinyin characters; 苐 4 Figure 疋 A window created by the system of Figure 2 which shows the addresses stored in the system in simplified Chinese characters; Figure 5 from Figures 5 (a) to 5 (c) ), Which shows the steps of the method for converting simplified Chinese characters into Pinyin characters in Figure 丨; Figure 6 shows a database of Pinyin characters generated by DpL by the method in Figure 丨; and 10 Figure 7 is a window generated by the system of Figure 2, which shows the results of the comparison between the two databases. detailed description

Fig. 1 shows the steps of a method according to a specific embodiment of the invention, which is used to compare the addresses of potential recipients with at least a portion of the addresses in the list DPL 15. This method is implemented by the system shown in FIG. The system of FIG. 2 contains an order management system 100, such as the smarts system, which includes a database 110 for storing individual and / or company shipping and / or pick-up addresses, and the individual and / or company has placed an order Or prepare 20 to accept an order; and a data input device 120, which uses Pinyin characters to input data into the database 110. Only one data input device 120 is shown, but in practice there may be multiple such units. The system also includes a second database 13 0, which is used to store DPL for English and Japanese. 1237775 V. Description of the invention (6) The system further includes a first conversion unit 140, which is used to convert the simplified Chinese character data items in the first database 110 into Pinyin data items so as to form the first Pinyin data library 150. This process does not delete the database 120. The system still includes a second conversion unit 160 for converting the English language data in the second material 1 database 130 into Pinyin data items, and the Pinyin data items are in the second Pinyin database 17. This process does not delete the second data base 130. The system includes a comparison unit 1800 and the pinyin items in the second data bases 150 and 170, and the output unit 190 is used for the first data base. Any match m corresponding to each of the items in the second pinyin database 150 and 170 is notified to the operator of the system, and the match status is found by the comparison unit 180. The first two steps of the method of the graph reduction (that is, 2 above the short dashed line in the i-th figure) are well-known steps for entering data into the first-middle database m of the order management system. Specifically, in step 10, for example, a p μ material input device 120 in a sales representative is used to input information such as an order and a shipping address into the order management system ⑽. The "produced by the user" window is displayed to the user. In step 20, the r: Hai order management system will convert the input data into a simplified Chinese character: == the item in the first database 110. When starting from the first -Funded ": When they are printed, they are a simplified Chinese character input and a single window output from the library. It has 0 1237775 V. Description of the invention (7) Double-byte simplified Chinese character亓 查 Both a # & Italian, database u. Available :; Order: and mailing address. Note the items that are not relevant to the present invention. Such items, if they have been: use = language It may be directly compared to the Beam (for example, non-Chinese items) by a well-known method. In step 30, 'to simplify the Chinese double character — ordering and transportation information in the warehouse cut, from the first -The conversion unit 140 converts the daggers into pinyin characters so as to form the '0 20 立 — 上 所 ㉛—the single simplified Chinese character S may correspond to multiple Pinyin' sets in the first-Pinyin database 150. * Therefore , For every simplified Chinese character of the first-database " Changing the order% 14G will generate all possible sets of Pinyin characters, which can be derived from the items described. And the mother of these Pinyin character sets is formed in the database 150. However, we have already Make sure that this "simplified" axis does not compromise the integrity of other processes. In particular, the conversion done by the conversion unit 在 in step 3G can be achieved by using a conversion file, such as the one already loaded The simplified operating system «System Presets« of Microsoft Windows 98 can be found at C: \ Wmd〇WS \ system \ winpyc〇m for each installed file system. 'This operating system is installed in each machine. Figure 5 shows an example of the process of step 30. The address shown in window 2 of Figure 4 is the 46th in the first database. Order 〇2249〇1 丨 is shown in Figure 5 (a). Figure 5⑼ shows various methods that can convert each simplified Chinese character to Pinyin. Most characters only have one 10Ϊ237775

5. Description of Invention (9). For reference, the corresponding Simplified Chinese address is shown in the right-hand column of FIG. 6 'Although the present invention does not need to generate this block. Although it is possible in principle to convert all items in the DPL list to Pinyin, this embodiment only converts the address of Chinese item 5 in the DPL list. For example, in this context, Chinese, Can be defined as items that are addresses within the People's Republic of China and within other optional territories. By adopting this, simplified,, means, the number of transformations (and therefore also for the next comparison) is greatly reduced. Generally speaking, because the authentication process is based on the address, and the attributes of the address have not occurred, the conversion ", the above method will not reduce the integrity of the authentication. In step 50, for the first and second The two Pinyin databases are compared at 15 and 17 to determine whether they match. These are automatically extracted by the 4th pinyin string in the database (for example, 5 shown in Figure 5 (c)). Substrings) and the Pinyin strings in the second database (Figure 6, "Pinyin Address" column). Fig. 7 shows a window which can be selectively displayed to the user, and the comparison unit 180 is used to let the user determine how these matches are processed. As shown in the figure, it has been found that one of the order number 402211〇81 (as shown in Figures 4 and 5 °, and the upper half of Figure 7) and the entity PIN-YIN in the chart 4 (as shown in the lower half of Figure 7). Note that the entity name in the DPL list ("Beijing Aer〇space Automatic Control Limited,") and the name ("DaLi Furniture (China) Ltd.) (Dali Furniture (China) have 1237775. The description of the invention (10 limited company)) is different, in which the application name (Dali Furniture (China) Co., Ltd.) is used to make orders; this embodiment has found that this compliance is based on the address alone. Pass Enter a click into the common optional dialog box in the window in Figure 7 and click "〇κ", the user can indicate how this compliance is handled. If desired, step 50 can be executed by running the order The DPL compliance department of the organization that manages the system completes the situation, and the status of this project can be matched with the local schedule, that is, the organization that runs the order management system will develop the parties listed in the table ( (Can be different from DPL list) for trading, at least 10 is no filtering cloud operation. Then, the local muscle list may be used for appending to the exit In the management system, it is used for the purpose of complying with export regulations, which is just like the generation of export / transport documents. Therefore, 'steps 30 and 40 have formed a common platform (pinyin), so that in step 50, Achieve a consistent cloud of address for Chinese orders. This embodiment can be operated in a processing manner, in which multiple items in the first database iig (for example, all the Chinese in the first database) Items) one after the other (for example, like a continuous sequence converted into a day-to-day item 'to form the database inventory π, and then the database ⑽) each of the converted items is related to the second database 17 〇 the converted items are compared (for example, _ connected to _ land). Optionally, the 30th item in the _f library n 进 can be subscribed to step 30 separately (for example, whenever a new item is added To the first database) and by converting each converted item with the second pinyin material 13 1237775

All converted items in library 170 are compared, and step 50 may be performed for the resulting items in database 150. If no match is found, the contents of the database 150 can be discarded, in other words, the monthly change 'the first Pinyin database 160 does not need to contain any more than the simplified Chinese characters in the database m at any time. Some—The number of Pinyin items derived from a single item is greater. The comparison in step 50 can be performed by the method described above-any matching condition of the woman is found, that is, the wheel out unit 1 is used so that the operator of the system can be informed. He (she) can make special orders for the corresponding order. Household Management 〇

Component number comparison table 10… ••• Step 20… ••• Step 30… •••• Step 40… ••• Step 50….… Step 100… ••… Order Management System 110 ··… Database 120 ···· Data input device 130… Second database 140… First conversion unit 150 ··· First Pinyin database 160 ... Second conversion unit 170 ··· Second Pinyin database 180 ·· Comparison unit 190 ...

— 14

Claims (1)

1237775 If VI. Applying for more than 1 patent replacement scope A8 B8 C8 D8 15 20 No. 91110251 applying for amendment of patent scope for application 94 3 > 71.-A computer application method for comparing two databases, each database Both contain Chinese text data items with specified addresses. The method includes: child; parent > material bank, which converts any Chinese text data item that is not a pre-defined common Chinese language format into a common format, which can be used in a variety of ways Any item converted into the common format and at least in the first database is converted into the common format by all of these methods; and comparing these data items with the common format, it is more recognizable with the first The Chinese text data items in the first database correspond to the Chinese text data items in the library. The method according to item 1 of the patent application scope, wherein the common Chinese language format is Pin Yin characters. The method according to item 1 or 2 of the scope of patent application, wherein the first database is an order management system database and includes data items containing corresponding shipping and / or order addresses. The method according to item 1 of the scope of patent application, wherein the Chinese text data item of the first database uses simplified Mandarin characters. The method according to item 1 of the scope of patent application, wherein the second material A library is a list of third parties published by a second party. The method as described in item 1 of the scope of the patent application, which does not include the second database located at the address within at least one designated Chinese territory 2. 3. 4. 5. This paper size applies to the Chinese National Standard (CNS) A4 size (210 X 297 mm) -------- „(Please read the precautions on the back before filling in this page) Order 15 1237775 Scope of application for patents 10 Printed by the Ministry of Economic Affairs of the Ministry of Economic Affairs of the Ministry of Economic Affairs and Consumer Cooperatives. Wisdom Knee Production Bureau 20 Data items will not be converted to this common mode. The method as described in item i of the scope of patent application, wherein, by comparing items of the Chinese text data with the common format, if they are found to be 'matched in time', the corresponding items of the data library are edited. A computer system for comparing two databases, where each database includes a Chinese text data item with a specified address, the computer system contains a first conversion unit to convert the Chinese text data of the first database Items are converted into-a pre-defined common Chinese language format, and any item in the first database that can be converted to a common format in a variety of ways is converted using all of these methods to generate a project with a common pattern; A conversion unit for converting the Chinese text of the second database into the common Chinese language format; and a comparison unit for comparing the converted data items so as to identify the Chinese with the second database The Chinese text data items in the first database corresponding to the text data items. The system according to item 8 of the scope of patent application, wherein the common Chinese language format is Pinyin characters. 10. The system according to item 8 or 9 of the scope of patent application, wherein the first database is an order management system database and includes Chinese text data items containing the corresponding shipping and / or order addresses. 11 · The system according to item 8 of the scope of patent application, wherein the Chinese text data item of the first database uses simplified Chinese characters. 7. 8. Please read the notes of the memorandum before writing this page. T Order 9. A4 size (210X297 mm) 16 10 1237775 Scope of patent application 12. :: Please = The system described in item 8, wherein the second database is a list of third parties published by a second party. 13. As described in item 8 of the scope of the patent application, 1 β π # ^ 糸 ,, 'First of all, the second conversion does not convert those second materials that do not contain addresses located in at least __ designated Chinese territories. Library data items. 14. For example, in the patent application No. 8 a ^ ^ fantasy system, in which the comparison unit is used to operate the output device to send a signal by detecting the matching between the Chinese text data items with a common format, so that the The corresponding items of the first database are edited. K The system according to item 8 of the scope of patent application, wherein by detecting the matching between the Chinese text data items in the common format, the comparison is used to edit the corresponding items in the first database. , Nn In mm 111 1¾-tm 1 m! I ϋ ^ — · -ii (Please read the precautions on the back before filling out this page) Ministry of Economy Φ Central Standard 隼 Industrial Cooperative Cooperative Printed Wisdom Spider Production Bureau i This paper Standards are applicable to China National Standard (CNS) A4 specifications (210X297 mm) 17