JP2004078336A - Computer-assisted name sorting system and computer-assisted name sorting method - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To easily utilize information by allowing various types of computer-assisted name sorting processing to be executed according to the contents of various types of processing when a plurality of databases are integrally processed. <P>SOLUTION: This computer-assisted name sorting system comprises a first computer-assisted name sorting processing means generating a first computer-assisted name sorting conversion master by executing a computer-assisted name sorting processing by aiming at a first key, a second computer-assisted name sorting processing means generating a second computer-assisted name sorting conversion master by executing a computer-assisted name sorting processing by aiming at a second key involving the first key, a collective pattern set means accepting the setting of collective patterns by the combination of the first key with the other keys for each data collected by the second key and generating the collective pattern master based on the setting of the accepted collective pattern, and a computer-assisted name sorting totalling processing means executing the computer-assisted name sorting totalling processing based on the collective pattern master. <P>COPYRIGHT: (C)2004,JPO

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention relates to a name identification processing method and a name identification processing system for eliminating duplicate data, and in particular, to provide a name identification processing method and a name identification processing system that enable arbitrary data integration in accordance with processing contents and user settings. .
[0002]
[Prior art]
In the case of a company or an organization that sells products or conducts financial transactions, customer information is managed by creating a database of customer information. When constructing such a customer information management system, data may be duplicated when performing a predetermined process using a plurality of data masters. Need to do it.
[0003]
In particular, JA (agricultural cooperative) is an economic business, such as a sales business that collects and sells agricultural products produced by members and a purchasing business that collectively purchases materials necessary for agricultural production and supplies necessary for daily living. , Transactions, deposit acceptance, loan of funds, handling of foreign exchange, credit discount such as bill discount, debt guarantee, mutual aid business which plays the same role as life insurance and non-life insurance, and several other businesses. For each business, a system has been established that manages data by individual members and data for each household. Even within the same business, one individual may have multiple member codes, and when such various data are aggregated according to the processing content, individual members or households It is necessary to perform aggregation processing by performing name identification processing.
[0004]
For example, the same person's name identification processing based on the member's basic information such as affiliated branch office, member code, gender, date of birth, telephone number, address, etc. owned by each system of the main business, economic business, credit business, mutual aid business To create a personal name conversion master. In the same way, the same household is used to perform name identification processing based on the member's basic information such as affiliated branch office, member code, gender, date of birth, telephone number, address, etc. held in each system of economic business, credit business, mutual aid business Build a household conversion master. By using such a personal name conversion master and a household name conversion master, a name matching tally process is performed for each individual and household according to each processing content, and display on a monitor screen, form output, and the like are performed.
[0005]
[Problems to be solved by the invention]
In many cases, the work of the system organization as described above is vertically divided, and even though individual name identification processing and household name identification processing are executed in each business, integration of name identification processing between each business has not been implemented Or have not been introduced in many cases. Further, in the case where a part of the information of each union member is disclosed as regional information, if the name identification process is performed for each union member or household, it becomes difficult to utilize this information. For example, if one crop of economic business transactions needs to be tabulated for the whole family, other crops need to be tabulated for the person and the eldest son, and for other crops, it is necessary to tabulate the eldest son and the second son. There is. Therefore, if all the same households are aggregated, the information cannot be used, and there is a problem that sufficient information cannot be provided.
[0006]
SUMMARY OF THE INVENTION An object of the present invention is to make it possible to execute various name identification processes according to various processing contents when processing a plurality of databases in an integrated manner, and to facilitate utilization of information.
[0007]
[Means for Solving the Problems]
A name identification processing system according to the present invention performs first name identification processing by focusing on a first key and generates a first name identification conversion master, and name identification by focusing on a second key including the first key. A second merging processing unit for executing a process to generate a second merging conversion master; and accepting and accepting an aggregation pattern setting by a combination of the first key and another key for each data aggregated by the second key. An aggregation pattern setting unit that generates an aggregation pattern master based on the setting of the aggregation pattern, and a name identification aggregation processing unit that executes a name identification aggregation process based on the aggregation pattern master.
[0008]
Here, the aggregation pattern setting unit further includes a function of receiving an aggregation rejection setting for rejecting the name identification aggregation processing by the aggregation pattern master for each processing content, and generating an aggregation rejection master based on the received aggregation rejection setting, The name identification tally processing means can be configured to execute the name identification tally processing based on the aggregation pattern master and the aggregation refusal master.
[0009]
Also, the first key can be an individual and the second key can be a household.
A name identification processing system according to the present invention focuses on a first key from a plurality of basic information masters to execute a name identification process to generate a first name conversion master, and includes the first key from the plurality of basic information masters. A step of executing a name identification process by focusing on the second key to generate a second name identification conversion master, and setting an aggregation pattern by a combination of the first key and another key for each data aggregated by the second key Accepting, receiving the setting of the aggregation pattern master based on the setting of the received aggregation pattern, and accepting the setting of the aggregation rejection for rejecting the merger aggregation processing by the aggregation pattern master for each processing content, based on the received aggregation rejection setting A step of generating an aggregation refusal master and a step of executing a name identification aggregation process based on the aggregation pattern master and the aggregation refusal master are included.
[0010]
Here, the first key can be an individual and the second key can be a household.
[0011]
BEST MODE FOR CARRYING OUT THE INVENTION
As one embodiment of the present invention, a case where data processing relating to economic business transactions, credit business transactions, and teaching material business transactions, which are the main business of JA (agricultural cooperative), will be considered.
The economic business transaction includes a sales business that collects and sells agricultural products produced by members, and a purchasing business that collectively purchases materials necessary for agricultural production and supplies necessary for daily living. The member's basic information such as the affiliated branch, member's code, gender, date of birth, telephone number, and address of the member who conducts the economic business transaction is stored in the economic business basic master 11.
[0012]
Credit business transactions involve transactions, deposit acceptance, loan of funds, handling of foreign exchange, discounting of bills, and guarantee of debts. Basic member information such as the affiliated branch office, member code, gender, date of birth, telephone number, and address of the member performing the credit business transaction is stored in the credit business basic master 12.
Furthermore, the mutual aid business transaction plays a role equivalent to life insurance and non-life insurance, and the affiliated branch office, member code, gender, date of birth, telephone number, address, etc. The member basic information is stored in the mutual aid business basic master 13.
[0013]
The individual name identification processing means 110 executes a name identification process focusing on an individual from each of the economic business basic master 11, the credit business basic master 12, and the mutual aid business basic master 13, and generates an individual name comparison conversion master 31.
Similarly, the household name identification processing means 120 executes a name identification process focusing on the household from each of the economic business basic master 11, the credit business basic master 12, and the mutual aid business basic master 13, and generates a household name conversion master 32.
[0014]
The aggregation pattern setting unit 40 receives an aggregation pattern setting based on a combination of an individual and other items for each data aggregated by the household, and generates an aggregation pattern master 42 based on the received aggregation pattern setting. Further, the aggregation pattern setting unit 40 receives an aggregation rejection setting for rejecting the name identification aggregation processing by the aggregation pattern master for each processing content, and generates an aggregation rejection master 41 based on the received aggregation rejection setting.
[0015]
The individual / household identification aggregation processing means 130 performs data aggregation based on the individual identification conversion master 31, the household conversion master 32, the aggregation pattern master 42, and the aggregation rejection master 41, and executes the name identification aggregation processing. The data aggregated by the individual / household name aggregation aggregation processing means 130 is transaction data 20 such as economic business transaction data 21, credit business transaction data 22, and mutual aid business transaction data 23.
[0016]
The data subjected to the name aggregation processing by the individual / household name aggregation processing means 130 is displayed on various screens 51 through the monitor screen and output as various forms 52.
[Personal name identification]
The case of setting an aggregation pattern for personal identification will be described with reference to FIG.
[0017]
In this example, Taro Fujitsu, a member of the association, cultivates and ships tomatoes with the member code "123", and cultivates and ships pears with the member code "555". Also, Taro Fujitsu grows and ships tea under the union member code “888” and the union member name “Fujitsu Seisakuen”. Due to the convenience of shipping, tomatoes are shipped to branch A and pears are shipped to branch B, so they have different member codes even though they have the same member name. Further, it is assumed that the eldest son "Fujitsu Ichiro" of the same household of "Taro Fujitsu" is cultivating and shipping tomatoes with the member code "222".
[0018]
When the name identification process is not performed, the aggregation process is performed for each of the member codes “123”, “555”, “888”, and “222” as shown in the left column of FIG. The personal identification processing means 110 performs personal identification processing based on the affiliated branch, member code, gender, date of birth, telephone number, address, etc. of "Taro Fujitsu", and the member codes "123", "555". , And "888" are registered in the personal name conversion master 31. When the name identification tallying process is performed using such a personal name identification conversion master 31, all data of Taro Fujitsu will be aggregated as shown in the rightmost column of FIG.
[0019]
Here, the aggregation pattern setting means 40 accepts various aggregation pattern settings so that aggregation processing by a combination of an individual and other items is enabled. For example, in the aggregation pattern (1), the data of the member code "555" and the data of the member code "888" are merged, and data related to pear shipment and tea shipment are aggregated and aggregated. I have. In the aggregation pattern (2), the data of the member code "123" and the data of the member code "555" are merged, and data on the shipment of tomatoes and the shipment of pears are aggregated and aggregated. I have. Further, in the aggregation pattern (3), the data of the member code "123" and the data of the member code "888" are merged, and data relating to the shipment of tomatoes and the shipment of pears are aggregated and aggregated. I have.
[0020]
Each aggregation pattern can be set for each processing content. For example, as shown in FIG. 3, the aggregation pattern (2) is used for purchase supply results, receivables list, sales receipt evaluation results, sales results, and the like. ) Is used to execute the name identification tabulation process.
In FIG. 3, in addition to the aggregation processing using the aggregation pattern (2), a case where the aggregation processing is performed without using the name identification, and a case where the identification aggregation processing using the personal identification master 31 is performed are described. Is set appropriately according to.
[0021]
[House name identification]
In the case where the aggregation pattern (1) is used among the aggregation patterns of the individual name identification in FIG. 2, the case where the name identification aggregation processing is further performed using the aggregation pattern for each household will be considered. When the name identification process for each household is not performed, as shown in the leftmost column of FIG. 4, the name identification aggregation process using the aggregation pattern (1) of the individual name identification is executed. Therefore, data of the union member code "555" and the data of the union member code "888" are merged, and data relating to pear shipment and tea shipment are aggregated and aggregated.
[0022]
In addition, when the name identification tabulation process is executed using the household name identification conversion master 32, as shown in the rightmost column of FIG. 4, the data of Taro Fujitsu's union member code "123", "555", "888" In addition, all the data of Ichiro Fujitsu's union member code "222" is aggregated and processed.
Here, the aggregation pattern setting means 40 accepts various aggregation pattern settings so that aggregation processing by a combination of an individual and other items is enabled. For example, in the aggregation pattern (1), data of the union member code “123” and the union member code “222” are merged, and data relating to Taro Fujitsu's shipment of tomatoes and Ichiro Fujitsu's shipment of tomatoes are aggregated. It is configured to perform aggregation processing. In the aggregation pattern (2), the data of the member codes "123", "555", and "888" are merged, and data on the shipment of tomato, pear, and tea by Taro Fujitsu are aggregated and aggregated. It is configured as follows. Further, in the aggregation pattern (3), the data of the member code “555”, the member code “888” and the member code “222” are merged, and the pear and tea of Fujitsu Taro and the tomato of Fujitsu Ichiro are processed. The system is configured to aggregate data related to shipping and perform aggregation processing.
[0023]
In this way, by setting various aggregation pattern settings as the aggregation pattern master 42, it becomes possible to select the most suitable aggregation pattern for each processing content.
[Aggregation pattern master]
The aggregation pattern stored in the aggregation pattern master 42 is set based on the processing content as described above, and this example will be described with reference to FIGS.
[0024]
For example, in the case where the head of the household is Taro Fujitsu and the number of household members is four or less Taro Fujitsu, a merging and counting process using the personal name conversion master 31 and a merging and counting process using the household name conversion master 32 In addition to the above, a name identification aggregation process using the aggregation patterns (3) to (7) set in the aggregation pattern master 42 is prepared.
As shown in FIG. 6, as for the process 232 (bookkeeping data aggregation) during the operation 001 (management), the data of Taro Fujitsu of the member code 110-12345 and the data of Jiro Fujitsu of the member code 110-12322 are aggregated. Using the aggregation pattern (3), the aggregation pattern (4) that aggregates the data of Hanako Fujitsu of the member code 110-33332, and the aggregation pattern (5) that aggregates the data of Yoshio Fujitsu of the member code 110-98767. It has been set to execute the name identification tabulation process.
[0025]
Also, as shown in FIG. 7, the processing 554 (purchase receivable) during the operation 002 (purchase) includes a name collation tallying process using the household name collation conversion master 32 and Taro Fujitsu of the union member code 110-12345. It is set to execute the name identification aggregation process using the aggregation pattern (3) that aggregates the data of Jiro Fujitsu of the union member code 110-12322.
[0026]
Further, as shown in FIG. 8, in the process 882 (transaction result) during the operation 003 (sales), the name identification tallying process using the personal name identification conversion master 31 and the name identification tallying process using the household name identification conversion master 32 are performed. Is set to execute.
[Aggregation refusal master]
In accordance with each processing content, the configuration is such that an aggregation rejection setting for rejecting the name identification aggregation process using the aggregation pattern master 42 can be accepted and the aggregation rejection master 41 can be set. FIG. 9 shows a setting menu for accepting the setting of the aggregation refusal.
[0027]
The consolidation refusal setting menu includes a business display column and a process display column indicating the business classification of each process and the content of the process, and a corresponding rejection category display column, setting status display column, and the like. The processing contents for which rejection is set are configured so that the items in the setting status are not aggregated. Further, when the rejection category is not set, all the targets are aggregated.
[0028]
[Data management system]
As shown in FIG. 5, each database and search system can be configured to be centrally managed by a data warehouse. Here, transaction data 200 such as purchase transaction record data 201, sales transaction record data 202, mutual aid transaction record data 203, and margin transaction record data 204 are managed by the data warehouse.
[0029]
This data warehouse further manages an integrated household master 310 (household conversion master), an integrated member master 320 (individual name conversion master), an aggregation refusal master 401, an aggregation pattern master 402, a member affiliation master 403, and the like. ing.
Further, the family name matching processing means 501 (personal / household name matching tallying processing means) performs name matching tally processing of the transaction data 200 based on the integrated household master 310, the integrated member master 320, the aggregation refusal master 401, and the aggregation pattern master 402. Then, a business alias called mart 600 composed of purchase transaction family name matching data 601, sales transaction family name matching data 602, mutual aid transaction family name matching data 603, margin transaction family name matching data 604, and the like is generated.
[0030]
The aggregation refusal master 401, the aggregation pattern master 402, and the member affiliation master 403 can perform maintenance via the aggregation rejection setting means 301, the aggregation pattern setting means 302, and the affiliation setting means 303, respectively. Aggregation rejection setting means 301, aggregation pattern setting means 302, and affiliation setting means 303 are set in terminals installed in business offices and the like, and are activated when business conditions are maintained by the staff 210 and changed. And so on.
[0031]
The aggregation rejection setting means 301, aggregation pattern setting means 302, and affiliation setting means 303 can be operated by the union member 220 through the Internet network, and the union members can perform business-specific condition maintenance. I have. It should be noted that, for the processing of the condition maintenance by business by staff and the maintenance of condition by business by individual members, authentication processing by respective IDs and passwords is required.
[0032]
In the data warehouse, an information search tool 700 for searching each data in the business alias Yori Mart 600 is prepared, and the data search can be performed on the staff terminal 230 using this information search tool. It has become. Further, data search using the information search tool 700 from the terminal 240 owned by the union member via the Internet is possible.
[0033]
【The invention's effect】
According to the present invention, the setting of the aggregation pattern is accepted and the name identification aggregation processing is performed using the aggregation pattern. Therefore, the aggregation processing using various aggregation patterns is possible, and it is not possible to cope with the case where name identification is performed only by individuals or households. Fine-grained aggregation processing can be realized.
[Brief description of the drawings]
FIG. 1 is an explanatory diagram of a name identification processing system to which an embodiment of the present invention is applied;
FIG. 2 is an explanatory diagram of an individual name identification pattern.
FIG. 3 is an explanatory diagram of pattern setting for each process.
FIG. 4 is an explanatory diagram of a household name identification pattern.
FIG. 5 is an explanatory diagram of a data management system.
FIG. 6 is an explanatory diagram of an aggregation pattern setting for each process.
FIG. 7 is an explanatory diagram of an aggregation pattern setting for each process.
FIG. 8 is an explanatory diagram of an aggregation pattern setting for each process.
FIG. 9 is an explanatory diagram of an aggregation rejection pattern setting.

Claims (5)

First name identification processing means for executing a name identification process by focusing on the first key and generating a first name identification conversion master;
A second merging processing unit that performs a merging process by focusing on a second key including the first key and generates a second merging conversion master;
Aggregation pattern setting for receiving an aggregation pattern setting based on a combination of the first key and another key for each data aggregated by the second key, and generating an aggregation pattern master based on the received aggregation pattern setting Means,
Name identification tabulation processing means for performing a name identification tabulation process based on the aggregation pattern master,
A name identification processing system comprising: The aggregation pattern setting means further includes a function of receiving an aggregation rejection setting for rejecting the name identification aggregation processing by the aggregation pattern master for each processing content, and generating an aggregation rejection master based on the received aggregation rejection setting, The name identification processing system according to claim 1, wherein the name identification aggregation processing unit executes the name identification aggregation processing based on the aggregation pattern master and the aggregation refusal master. The name identification processing system according to claim 1, wherein the first key is an individual, and the second key is a household. Focusing on the first key from the plurality of basic information masters to execute a name identification process to generate a first name identification conversion master;
Focusing on a second key that includes the first key from the plurality of basic information masters, performing a name identification process to generate a second name identification conversion master;
Receiving a setting of an aggregation pattern by a combination of the first key and another key for each data aggregated by the second key, and generating an aggregation pattern master based on the received aggregation pattern setting;
A step of receiving an aggregation rejection setting that rejects the name aggregation aggregation processing by the aggregation pattern master for each processing content, and generating an aggregation rejection master based on the received aggregation rejection setting,
Performing a merge aggregation process based on the aggregation pattern master and the aggregation refusal master,
Name matching processing method including 5. The method according to claim 4, wherein the first key is an individual and the second key is a household.

Images