JP2004139237A - Name matching method, name matching system, accounting method and accounting system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a name matching method and a name matching system that manage, as common customer information, customer data redundant in a plurality of databases due to separate management in a plurality of offices or separate management for a plurality of business items, and an accounting method and an accounting system that can easily determine a refund or an appropriation to a customer by the use of a name-matched database. <P>SOLUTION: For a plurality of individual tables 11A, 11B, etc. prepared for a plurality of items to save customer information respectively, name matching is performed in every table according to item-based name matching rules 13, name matching is next performed across the tables according to item-shared name matching rules 13, and all groups of customers name-matched and given common numbers are saved in a common table 14A together with the common numbers. Even if offices differ in details of management methods, or business items differ in collection items of customer information, name matching can be performed for customer management common to the offices or the business items. <P>COPYRIGHT: (C)2004,JPO

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention relates to a name identification method and a name identification system for a database having a plurality of individual tables storing customer information for a plurality of items, and an accounting method and an accounting processing system using the database.
[0002]
[Prior art]
Generally, when a customer list becomes enormous, it is stored in a database of a computer system and managed. In this case, the database has a table for each business item, and it is widely used to manage a customer list for each business item. In such a system, a plurality of customer data of the same person may exist in the same table. In this case, since the management of customer information becomes complicated, so-called name identification, in which the same customer information is extracted and combined into one piece of information, is performed (for example, see Patent Document 1). It has also been proposed to use the database named in this manner for insurance premium rebate operations (for example, see Patent Document 2).
[0003]
[Patent Document 1]
JP-A-7-192053
[Patent Document 2]
JP 2001-256351 A
[0004]
[Problems to be solved by the invention]
In general, when managing customer information, the name of the customer is managed for each business item or for a plurality of offices handling the business item. In this case, the management method in each office differs in detail, and the collection items of customer information differ for each business item, so the name identification for managing customers in common for each office and business item is performed. It was difficult to do.
[0005]
For this reason, customer management is performed for each office or business item, and various paperwork based on customer information is complicated and inefficient.
[0006]
The merging is performed based on a merging rule that determines which items of the customer information are to be extracted. The name identification rule is determined artificially. However, if the name identification rule is too strict, customers who should be originally extracted as the same customer may be leaked. On the other hand, if the name identification rules are loose, another person may be extracted as the same customer. Therefore, it is important to be able to determine whether the name identification rule is appropriate.
[0007]
An object of the present invention is to manage customer data redundantly present in a plurality of databases as common customer information by being managed for each of a plurality of offices or for each of a plurality of business items. It is an object of the present invention to provide a name identification method and a name identification system.
[0008]
Another object of the present invention is to provide an accounting processing method and an accounting processing system that can easily judge whether a customer is refunded or assigned by using a collated database.
[0009]
[Means for Solving the Problems]
The merging method according to the present invention is a merging method of a database having a plurality of individual tables in which customer information for each of a plurality of items is stored, and among merging rules set in advance for each item, according to a corresponding merging rule, Extract the customer information that is determined to be the same in the individual table and assign a common group number, and also assign a group number individually to all other customer information that is not extracted. Then, for the group for each table to which the group number is assigned, a group determined to be the same is extracted by using a preset name identification rule between items, a common number is assigned, and other unextracted groups are extracted. A common name is also assigned between tables that individually assign a common number to all groups, and customer information of all groups assigned the common number is provided. , Characterized in that stored in the common table with a common number.
[0010]
Further, in the merging method of the present invention, the customer information of all the groups with the common number in each individual table is copied as a candidate to a candidate list table, and the merging rule between the items is copied from the copied candidate. According to a candidate rule having a different criterion, a candidate determined to be the same may be extracted, and a candidate number may be assigned to the extracted candidate.
[0011]
The merging system according to the present invention is a merging system for a database having a plurality of individual tables in which customer information for each of a plurality of items is stored, and among merging rules set in advance for each item, according to a corresponding merging rule, A name identification unit for each table that extracts customer information determined to be identical in the individual table and assigns a common group number, and also assigns a group number individually to all other customers not extracted With respect to the group of each table to which the group number is assigned, a group determined to be the same is extracted by using a preset merging rule between items, a common number is assigned, and all other groups not extracted are extracted. Means for assigning a common number to each of the groups for each of the groups, and the customers of all the groups assigned the common number The distribution, characterized in that a common table for saving with a common number.
[0012]
Further, in the name identification system of the present invention, a candidate list table in which customer information of all groups with a common number assigned to each individual table is copied as a candidate, and a name comparison between items is performed from the copied candidates. There may be provided a candidate list creating means for extracting candidates determined to be the same according to a candidate rule having a different criterion, and assigning a candidate number to each group of the extracted candidates.
[0013]
The accounting method according to the present invention extracts customer information determined to be the same from customer data stored in a plurality of individual tables provided for each of a plurality of items and merges the customer information. Using a common customer database having a common table storing information, when the billing amount is output to the customer from the billing system that determines and outputs the billing amount for the customer, the customer is identified by the common customer database, With the specified customer information, a search is made for an income database that stores the amount of income from the customer for each item and a delinquency database that stores the amount of delinquency for the customer for each item, and the amount of income indicates the amount charged. If the amount exceeds the amount, the customer is notified of whether the excess amount is to be refunded to the customer or, if there is a delinquent amount, whether to apply to the delinquent amount.
[0014]
The accounting processing system according to the present invention extracts the same customer data from the customer data stored in each of a plurality of individual tables provided for each of a plurality of items, performs name matching, and stores this common customer information that has been provided. A common customer database having a common table, a billing system for determining and outputting the billing amount for the customer, a revenue database for storing the amount of revenue from the customer for each item, and a delinquency of the customer for each item A delinquent database that stores the amount of money, and when the billing amount is output to the customer from the billing system, the customer is identified by the common customer database, and the income database and the delinquent database are searched with the identified customer information. If the amount of income exceeds the amount billed, the excess amount will be returned to the customer or, if there is a delinquent amount, the delinquent amount Appropriated to or, characterized in that a refund-appropriated processing means for issuing a notification.
[0015]
In the above-described name identification method and name identification system according to the present invention, in a plurality of individual tables provided for each of a plurality of items and each of which stores customer information, name identification for each table is performed according to the name identification rule for each item. Next, merging between tables is performed in accordance with merging rules between items. Then, the customer information of all groups that have been named and assigned a common number are stored in a common table together with the common number, so that the management method in each office differs in details, and the collection items of the customer information for each business item are different. Even if they are different, it is possible to perform name identification for managing customers in common for each of these offices and business items.
[0016]
Further, in the accounting method and the accounting system according to the present invention, when the billing system outputs the billing amount to the customer, the common customer database is used to store the identified common customer information. The customer is identified by the database, and the income database and the delinquent database are searched with the identified customer information. As a result, when the income amount exceeds the billing amount, a notification is issued as to whether the excess amount is refunded to the customer or, if there is a delinquent amount, applied to the delinquent amount. For this reason, the amount of income and the amount of delinquency can be managed through all items with respect to the billed amount, and efficient accounting management can be performed.
[0017]
BEST MODE FOR CARRYING OUT THE INVENTION
Hereinafter, an embodiment of a name identification method and a name identification system according to the present invention will be described with reference to the drawings.
[0018]
FIG. 1 is a functional block diagram schematically illustrating an embodiment in which the present invention is applied to a tax payment system.
[0019]
In FIG. 1, reference numeral 11 denotes a customer database provided for each of a plurality of items (here, which is a tax item because the tax payment system is targeted), and includes a tax item (for example, a car tax A, a business tax B, a fixed asset tax). C, real estate acquisition tax D, etc.). Each of these databases 11 has an individual table (hereinafter referred to as an individual address table) that stores the address of the taxpayer for each tax item.
[0020]
Here, each individual address table is provided corresponding to each tax item. For example, in the address table relating to the automobile tax A, the address of the taxpayer who has delivered the automobile tax A is stored. In this case, even if the same automobile tax is paid to different offices, the same taxpayer will be assigned a full name code at each office. There will be multiple different name codes for the person.
[0021]
If the tax item is different, a taxpayer code is usually set for each tax item. Therefore, in each individual table, a different name code for the same taxpayer set for each of the tax items A, B, C,. Exists. For example, when the taxpayer X pays the automobile tax A and the business tax B, the taxpayer X has different name codes in the individual address table of the automobile tax A and the individual address table of the business tax B, respectively. Exists in.
[0022]
As described above, in the individual address table for the same tax item, the same taxpayer exists with a different name code due to a difference in the office, and the same taxpayer set for each tax item also exists between the individual address tables for the different tax items. There are different name codes. Therefore, it is necessary to streamline the paperwork for taxpayers by performing name identification and setting a common address for the same taxpayer regardless of tax items.
[0023]
This name identification is performed by the name identification processing means 12 in accordance with the name identification rule 13. This name identification is performed in the first stage (name identification for each table) for each of the tax items A, B, C,..., And between the tax items A, B, C,. There is a second stage (name matching between tables) performed between those individual addressing tables. The name matching rule 13 includes a name matching rule for each table (for each tax item) and a name matching rule for each table (between tax items). have.
[0024]
Taxpayer data that has become a common address between the respective tax items through the two-stage name matching is stored in the common address database 14.
[0025]
In addition, the name identification processing unit 12 creates a candidate list 15 for judging appropriateness of the name identification rule according to the candidate rule 16.
[0026]
Details of this name identification will be described with reference to FIGS. In FIG. 2, reference numeral 11A denotes an individual address table of the automobile tax A, which shows data items for each taxpayer. 11B is an individual address table for business tax B, which also shows data items for each taxpayer. The tables 11A and 11B store these data items for each taxpayer for all taxpayers.
[0027]
In the first-stage name identification for each tax item, first, a name identification key is set for each of the individual addressing tables 11A and 11B. In the first stage, among the data items, No. is used for name identification in each of the tables 11A and 11B. Items other than 1 can basically be used for the name identification key. Actually, essential input items and items whose input values are stable are used as matching keys.
[0028]
For example, in the automobile tax A, the data item No. 0-No. There are 13 items, but the required items are No. which are items of address and name. Nos. 3, 4, 5 and Nos. It is 11. These items have stable input values. That is, the input value is stable, for example, there is no space between the family name and the name in the name, and "prefecture" is always input in the prefectural life. Therefore, in the automobile tax A, these item Nos. Nos. 3, 4, 5 and Nos. 11 is used as a name identification key.
[0029]
Here, a name identification rule 13 in FIG. 1 determines which item is used as a key for identification.
[0030]
In the first stage indicated by the arrow A in FIG. 2, the individual address table 11A is searched according to the above-described identification rule, and the name codes having the same item as the identification key are grouped into groups A1, A2, and A3. The first-stage name identification (arrow A) is similarly performed for the individual addressing table 11B having different tax items, and the name codes having the same identification key item are grouped with the groups B1, B2, and B3.
[0031]
Next, a second-stage name identification indicated by an arrow B is performed. Here, the data items of the individual address tables 11A and 11B are partially different because they are set for each tax item. Therefore, a data item common to both tax items A and B is used as the name identification key. For example, the data item No. of tax item A. 2, 3, 4, 5, 6, 11, 12 and data item No. of tax item B. 2, 4, 5, 6, 12, 15, and 16 are common items from which a name identification key is determined.
[0032]
In the second stage (b), the merging between the tables 11A and 11B is performed according to a merging rule that defines a merging key between the tables 11A and 11B. In the example of the figure, the group A1 of the tax item A and the group B2 of the tax item B are identified with the common address. Similarly, the group A3 of the tax item A and the group B1 of the tax item B are named as common addresses. The group A2 of the tax item A and the group B3 of the tax item B are the common addresses as they are.
[0033]
The procedure for creating a common address by the above-described name identification will be described with reference to FIG. 14A is a common address table of the common address database 14 shown in FIG. 1, and 11A and 11B are individual address tables of the tax items A and B shown in FIG.
[0034]
FIG. 3A shows the first stage of the name identification, in which the individual addressing table 11A for the tax item A and the individual addressing table 11B for the tax item B are each identified. In the figure, C indicates a common number, and Gr indicates a group number.
[0035]
3A, in the individual addressing table 11A, a key item of a predetermined name identification is searched according to the identification rule described in FIG. As a result, there are three name codes determined to be Mr. X in the XX ward, and the number A1 is assigned to group these as the A1 group. By repeating this name identification, as shown in FIG. 3 (b), the individual address table 11A has two name codes determined to be Mr. X in the △△ ward, and There is one name code to be determined, and numbers A3 and A2 are assigned to group these.
[0036]
The merging for each table (for each tax item) is similarly performed in the individual addressing table 11B for the tax item B. As a result, in the individual address table 11B, as shown in FIGS. 3A and 3B, there are three name codes determined to be Mr. X in the △△ ward, and also to Mr. X in the XX ward. There are two name codes to be performed, and one name code determined to be Mr. Y in the ●● ward. Numbers B1, B2, and B3 are numbered to group these.
[0037]
Next, a second stage of merging between different tax items A and B (between different tables 11A and 11B) is performed. That is, the tables 11A and 11B are searched using the matching rule in which the matching key is set from the common data items between the tables 11A and 11B described with reference to FIG. As a result, it is recognized that the group A1 in the table 11A and the group B2 in the table 11B are the data of the name X in the XX ward, respectively, so that the groups A1 and B2 are numbered with the common number (1). I do. Then, the assigned common number and name code are stored in the common address table 14a.
[0038]
Hereinafter, similarly, common numbers are assigned to other groups as shown in FIG. 3C, and stored in the common address table 14A. That is, it is confirmed that the group A2 of the table 11A does not exist in the table 11B, and the common number (2) is assigned. Since it is recognized that the group A3 of the table 11A and the group B1 of the table 11B are Mr. X in the △△ ward, the common number (3) is assigned. Further, it is confirmed that the group B3 of the table 11B does not exist in the table 11A, and the common number (4) is assigned. In the group with the common number, the common number and the name code are stored in the common address table 14A, and the name identification is completed.
[0039]
By performing the name identification in this manner, different name codes for the same taxpayer that exist in the individual address table for the same tax item and different name codes for the same taxpayer that exist between the individual address table for the different tax items, It can be managed with a common number (common address). For this reason, office work can be made more efficient. In particular, by searching the database of each tax item with a common number, it is possible to collectively extract which tax item a certain taxpayer pays.
[0040]
Next, a candidate list creation procedure for determining whether the name identification rule used for name identification is appropriate will be described with reference to FIG.
[0041]
In FIG. 4, reference numerals 11A and 11B denote individual address tables for tax items A and B, as in FIG. 3, which have already been identified according to the predetermined identification rule 13 shown in FIG. Reference numeral 15A denotes a table of the candidate list 15 shown in FIG. 1, in which all records of the identified tables 11A and 11B are copied.
[0042]
All records copied to the candidate list table 15A are searched by the candidate rule 16 shown in FIG. 1 as shown in FIG. 4A, and records determined to be the same person are added to the records shown in FIG. ), The candidate number is assigned. This candidate rule 16 has basically the same purpose as the name identification rule 13, but has a different criterion.
[0043]
Here, the name identification rule 13 defines which item of each personal data is to be used as the name identification key, as described with reference to FIG. 2. In the case where there are too many, for example, a person who should be determined to be the same person may not be extracted. Conversely, if the criterion is too loose (such as when there are too few data items to be the name identification key), another person may be extracted as the same person. Therefore, by using the candidate rule 16 having a different criterion from the name identification rule 13, the individual tables 11A and 11B are searched to extract candidates determined to be the same.
[0044]
In the example shown in the figure, a candidate rule 16 having a looser criterion than the name identification rule 13 is used. Therefore, in the name identification rule 13, in the individual addressing table 11A, a record determined to be Mr. Y in the XX ward, which is a different person from the group A1, and the group number A2 is assigned, It is determined to be the same as A1, and the same candidate number [1] as that of group A1 is assigned. The other records are searched according to the candidate rule, and candidate numbers are assigned as shown in FIG. 4C.
[0045]
After creating the candidate list 15 in this way, it is artificially determined from the contents of the candidate list whether the name identification rule 13 is appropriate. In other words, the candidate using the candidate list 15 determines whether or not the candidate Y determined to be in the same group as the candidate group 16 in the XX ward is exactly the same as the X in the XX ward. . As a result, when it is determined that they are the same person, it is determined that the name identification rule 13 is too strict, so that the name identification rule 13 is changed to, for example, a content close to the candidate rule 16. If it is determined that they are not the same person, it is determined that the name identification rule 13 is appropriate.
[0046]
Note that the candidate list 15 may be created using a candidate rule 16 having a stricter criterion than the name identification rule 13.
[0047]
As described above, by creating the candidate list 15 using the candidate rule 16 having a different criterion from the name identification rule 13, it is possible to determine whether the name identification rule 13 is appropriate and to perform more effective name identification. .
[0048]
Next, an accounting processing system using the common name database 14 that has been identified will be described with reference to FIG. This accounting processing system is an example in which the present invention is applied to tax refund / appropriation.
[0049]
In the accounting system shown in FIG. 5, reference numeral 17 denotes a refund / appropriation processing means, which executes a refund / appropriation process, which will be described later, by a CPU of a computer (not shown) according to a preset allocation rule 18. 19 is an income database, 20 is a delinquent database, and the tax payment amount and the delinquent amount of each taxpayer are stored for each tax item, and these information are provided to the refund / appropriation processing means 17. The refund / appropriation processing means 17 is supplied with common address information on the taxpayer from the common address database 14.
[0050]
Reference numeral 22 denotes each tax item system (billing system), which determines a tax amount that each taxpayer must pay for each tax item based on a report from the taxpayer or the like, and outputs it as a fixed amount. The information on the adjusted amount is given to the refund / appropriation processing means 17. A refund / appropriation screen 23 displays refund / appropriation information for the adjusted amount calculated by the refund / appropriation processing means 17 as shown in the figure.
[0051]
In the above configuration, each tax item system 22 determines the set amount for each tax item based on the taxpayer's filing as described above, and outputs it to the refund / appropriation processing means 17. The refund / appropriation processing means 17 extracts the common address of the taxpayer whose determined amount has been determined from the common address database 14, and first searches the income database 19 using the common address. Then, the adjusted amount is compared with the already paid amount stored in the income database 19 to calculate an incorrect payment.
[0052]
As a result, if there is a refund for the taxpayer, the delinquent database 20 is searched, and if there is delinquent information with the same common address number, it is displayed on the screen 23 together with the refund information. In this case, the delinquent portion within the range that can be paid with the refund amount is automatically selected and displayed. Also, the older delinquents have a higher rate of delinquencies, so they are displayed with priority. In the example of the figure, the refund amount is 12300 yen, and the delinquency information that can be applied within the range of the refund amount is the old arbitration date, tax item: XXX tax, arbitration date: 2001 / 1/1, delinquent amount: 10,000 yen, tax item: □□□ tax, mediation date: 2001/4/1.
[0053]
The tax officer prepares a refund application letter 24 based on the refund / appropriation screen 23 and notifies the corresponding taxpayer for confirmation. As a result, if there is no objection within the predetermined time limit, the allocation is determined. Further, the refund / appropriation processing means 17 reflects the refund / appropriation information determined and processed on the income database 19 and the delinquency database 20.
[0054]
As described above, the use of the identified common address database makes it possible to collectively manage the income status and the delinquent status over a plurality of tax levels. Therefore, the refund / appropriation process for the settled amount, which had been performed individually for each tax item, can now be batch-processed across each tax item, improving the efficiency of tax processing and improving services for taxpayers. be able to.
[0055]
In the above-described embodiment, a tax refund / appropriation system has been described as an example of accounting processing. However, the present invention is not limited to taxes, and can be widely used in an accounting processing system for merchandise sales with a fee advance payment system and a point system.
[0056]
In addition, since the above embodiment is an example applied to a tax system, a common address database in which taxpayer names are identified has been described. However, when applied to other merchandise sales systems, customer information is identified and a common customer number is identified. And can be used as it is as a common customer database having a common table. Similarly, each tax item system is illustrated as the billing system 22 in FIG. 5, but any system may be used as long as it determines and outputs the amount billed to the customer, not limited to the tax items.
[0057]
【The invention's effect】
ADVANTAGE OF THE INVENTION According to the name identification method and the name identification system according to the present invention, it is possible to unify and manage the customer data that is redundantly stored in each of a plurality of databases by storing them in a common customer information database. . In addition, if a candidate list is created, the name identification rule can be optimized.
[0058]
Further, according to the accounting method and the accounting system according to the present invention, the refund / appropriation to the customer can be collectively managed using the name-matched database, so that the processing efficiency can be improved.
[Brief description of the drawings]
FIG. 1 is a system configuration diagram showing an embodiment of a name identification system according to the present invention.
FIG. 2 is a diagram showing data items of an individual table and a process of merging using the data items according to the embodiment of the present invention;
FIG. 3 is a diagram illustrating a common table creation procedure according to the first embodiment.
FIG. 4 is a diagram illustrating a candidate list creation procedure according to the first embodiment.
FIG. 5 is a system configuration diagram showing an embodiment of an accounting system according to the present invention.
[Explanation of symbols]
11 Database
11A, 11B, 11C, 11D, 11E, 11F Individual table for each tax item
12 Means of merging
13 Matching rules
14 Common Customer Database
14A common table
15 Candidate list
16 Candidate Rules
17 Refund / appropriation processing means
19 Income Database
20 Delinquent Database
22 Billing system

Claims (6)

A database matching method having a plurality of individual tables in which customer information for each of a plurality of items is stored,
Among the pre-set merging rules for each item, according to the corresponding merging rule, the customer information determined to be the same in the individual table is extracted, a common group number is assigned, and all other customers not extracted are extracted. For each piece of information, a group number is assigned to each table.
For the group of each table to which the group number is assigned, using a preset name identification rule between items, extracting a group determined to be the same and assigning a common number, and all other groups not extracted Perform group identification between tables that individually assign a common number to groups,
A name identification method, wherein customer information of all groups assigned the common number is stored in a common table together with a common number. The customer information of all the groups with a common number in each individual table is copied to the candidate list table as candidates, and from the copied candidates, candidate rules having different criteria from the merging rules between items 2. The method according to claim 1, further comprising: extracting a candidate determined to be the same in accordance with (1), and assigning a candidate number to the extracted candidate. A database merging system having a plurality of individual tables in which customer information for each of a plurality of items is stored,
Among the pre-set merging rules for each item, according to the corresponding merging rule, the customer information determined to be the same in the individual table is extracted, a common group number is assigned, and all other customers not extracted are extracted. A name merging unit for each table for individually assigning a group number to information,
For the group of each table to which the group number is assigned, using a preset name identification rule between items, extracting a group determined to be the same and assigning a common number, and all other groups not extracted A means for merging tables that assigns a common number to each group individually,
A common table for storing customer information of all groups with the common number, together with a common number,
A name identification system comprising: A candidate list table in which customer information of all groups with a common number in each individual table is copied as a candidate,
From these copied candidates, candidates that are determined to be the same according to the candidate rules different from the merging rules between items are extracted, and a candidate number is assigned to each extracted candidate group. Candidate list creation means,
The name identification system according to claim 3, further comprising: A common table in which customer information determined to be the same is extracted from the customer data stored in a plurality of individual tables provided for each of a plurality of items and identified, and the common customer information that has been saved is stored. Using a common customer database with
When the billing amount is output to the customer from the billing system that determines and outputs the billing amount to the customer, the customer information is specified by the common customer database,
With this specified customer information, a search is made for an income database that stores the amount of income from the customer for each item and a delinquency database that stores the amount of delinquency for the customer for each item,
As a result, if the income amount exceeds the billing amount, the accounting method is characterized by notifying the customer of whether to return the excess amount to the customer or to apply to the delinquent amount if there is a delinquent amount. A common table in which customer information determined to be the same is extracted from the customer data stored in a plurality of individual tables provided for each of a plurality of items and identified, and the common customer information that has been saved is stored. A common customer database with
A billing system that determines and outputs the amount billed to the customer;
An income database that stores the amount of income from customers for each item,
A delinquency database that stores customer delinquency amounts for each item,
When the billing amount is output from the billing system to the customer, the customer information is specified by the common customer database, the revenue database and the delinquent database are searched with the specified customer information, and the revenue amount exceeds the billed amount. Refund / appropriation processing means for notifying the customer of refund of the surplus amount or appropriation of the delinquent amount, if any,
An accounting system comprising:

Images