JP4248819B2 - Name identification processing system and name identification processing method - Google Patents

Description

[0001]
BACKGROUND 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 according to processing contents and user settings. .
[0002]
[Prior art]
In the case of a company or group 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, it is possible that data is duplicated when executing a predetermined process using a plurality of data masters. Need to run.
[0003]
In particular, in JA (Agricultural Cooperative Association), economic businesses such as a sales business that aggregates and sells the crops made by the members, and a purchasing business that purchases materials necessary for agricultural production and supplies necessary for daily life. , Transactions, deposit acceptance, lending of funds, handling of foreign exchange, bill discounts, credit guarantees such as debt guarantee, mutual aid business that plays the same role as life insurance and non-life insurance, and other multiple businesses, A system for managing data by individual members and data for each household has been established for each business. Even within the same business, there may be cases where one individual holds multiple member codes, and when such various data is aggregated according to the processing content, each member individual or household It is necessary to perform aggregation processing by performing name identification processing.
[0004]
For example, name identification processing by the same person from the basic information of the member such as the branch office, member code, gender, date of birth, telephone number, address, etc. held in each system of the main business, economic business, credit business, mutual aid business To build a personal name identification conversion master. Similarly, name identification processing by the same household is performed from the basic information of the members such as the affiliated branch, member code, gender, date of birth, telephone number, address, etc. held in each system of economic business, credit business and mutual aid business Build a housekeeping conversion master. Using such an individual name identification conversion master and a household name identification conversion master, an individual and household name identification totaling process corresponding to each processing content is executed to display on a monitor screen, output a form, and the like.
[0005]
[Problems to be solved by the invention]
Businesses of the systematic organization as described above are often vertically divided, and even if personal name identification processing and household name identification processing are executed in each business, name identification processing between each business is not integrated In many cases, it has not been introduced. In addition, when part of the information of each member is disclosed as regional information, if the name identification process is performed for each member or household, it becomes difficult to utilize this information. For example, a certain crop in an economic business transaction needs to be counted for the entire family, for other crops it is necessary to count for the person and the eldest son, and for other crops 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]
It is an object of the present invention to make it possible to execute various name identification processes according to various processing contents and facilitate the utilization of information when processing a plurality of databases in an integrated manner.
[0007]
[Means for Solving the Problems]
The name identification processing system according to the present invention focuses on a first name identification processing means for generating a first name identification conversion master by performing name identification processing focusing on the first key, and on a second key including the first key. The second name identification processing means for executing the process and generating the second name identification conversion master, and for each data aggregated by the second key, the setting of the aggregate pattern by the combination of the first key and another key is accepted and accepted. Aggregation pattern setting means for generating an aggregation pattern master based on the setting of the aggregation pattern, and name identification aggregation processing means for executing name identification aggregation processing based on the aggregation pattern master.
[0008]
Here, the aggregation pattern setting means further includes a function of accepting an aggregation rejection setting for refusing the name identification aggregation process by the aggregation pattern master for each processing content, and generating an aggregation rejection master based on the accepted aggregation rejection setting, The name identification aggregation processing means can be configured to execute name identification aggregation processing based on the aggregation pattern master and the aggregation rejection master.
[0009]
Also, the first key can be an individual and the second key can be a household.
The name identification processing system according to the present invention includes a step of generating a first name identification conversion master by performing name identification processing focusing on the first key from a plurality of basic information masters, and a first key from the plurality of basic information masters. Focusing on the second key, performing a name identification process to generate a second name identification conversion master, and setting an aggregation pattern by combining the first key and other keys for each data aggregated by the second key Accepting and accepting an aggregation pattern master based on the accepted aggregation pattern settings, and accepting an aggregation rejection setting that rejects the name aggregation aggregation process by the aggregation pattern master for each processing content, and based on the accepted aggregation rejection settings The method includes a step of generating an aggregation rejection master, and a step of executing name identification aggregation processing based on the aggregation pattern master and the aggregation rejection master.
[0010]
Here, the first key can be an individual and the second key can be a household.
[0011]
DETAILED DESCRIPTION OF THE INVENTION
As an embodiment of the present invention, a case where data processing related to economic business transactions, credit business transactions, and teaching material business transactions, which are main operations of JA (agricultural cooperatives), is considered.
Economic business transactions include a sales business that aggregates and sells crops made by union members, and a purchasing business that purchases materials necessary for agricultural production and supplies necessary for daily life. Member basic information such as the affiliated branch office, member 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 include transactions, deposit acceptance, lending of funds, currency exchange, bill discounts, and debt guarantees. Member basic information such as the affiliated branch of the member performing the credit business transaction, the member code, gender, date of birth, telephone number, and address is stored in the credit business basic master 12.
Furthermore, mutual aid business transactions play the same role as 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 personal 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 a personal name identification conversion master 31.
Similarly, the household name identification processing means 120 executes a name identification process focusing on households 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 identification conversion master 32.
[0014]
The aggregate pattern setting means 40 receives an aggregate pattern setting based on a combination of an individual and other items for each data aggregated by a household, and generates an aggregate pattern master 42 based on the accepted aggregate pattern setting. Further, the aggregation pattern setting unit 40 accepts an aggregation rejection setting for rejecting the name identification aggregation process by the aggregation pattern master for each processing content, and generates an aggregation rejection master 41 based on the accepted aggregation rejection setting.
[0015]
The individual / household name collation processing means 130 performs data collation by executing data aggregation based on the personal name identification conversion master 31, the household conversion master 32, the aggregation pattern master 42, and the aggregation rejection master 41. Data to be aggregated by the individual / household name identification aggregation processing means 130 is transaction data 20 such as economic business transaction data 21, credit business transaction data 22, mutual aid business transaction data 23.
[0016]
The data subjected to the name collation processing by the personal / household name collation processing means 130 is displayed on various screens 51 through the monitor screen and is output as various forms 52.
[Individual name collation]
The case of setting a personal name collation pattern will be described with reference to FIG.
[0017]
In this example, a member, Taro Fujitsu, is cultivating and shipping tomatoes with the member code “123”, and cultivates and ships pears with the member code “555”. Taro Fujitsu grows and ships tea with the union member code "888" and the union member name "Fujitsu Tea Garden". Because of the convenience of shipment, tomatoes are shipped to branch A and pears are shipped to branch B, so they have the same member name but different member codes. Furthermore, suppose that the eldest son “Fujitsu Ichiro” of “Fujitsu Taro” grows and ships 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.
In the personal name identification processing means 110, personal name identification processing is performed based on the affiliated branch of “Fujitsu Taro”, member code, gender, date of birth, telephone number, address, etc., and member codes “123”, “555” , “888” are registered in the personal name identification conversion master 31. When the name collation processing is executed using such a personal name collation conversion master 31, all of the data of Fujitsu Taro will be aggregated as shown in the rightmost column of FIG.
[0019]
Here, the aggregate pattern setting means 40 accepts various aggregate pattern settings so as to enable aggregation processing by a combination of individuals and other items. For example, in the aggregation pattern (1), the data of the union member code “555” and union member code “888” is processed by name identification, and the data on pear shipment and tea shipment is aggregated and aggregated. Yes. Also, in the aggregation pattern (2), the data of the member code “123” and the member code “555” is processed by name identification, and the data relating to the shipment of tomatoes and the shipment of pears are aggregated and aggregated. Yes. Furthermore, in the aggregation pattern (3), the data of the union member code “123” and union member code “888” is processed by name identification, and the data related to tomato shipment and pear shipment is aggregated and aggregated. Yes.
[0020]
Each aggregation pattern can be set for each processing content. For example, as shown in FIG. 3, the aggregated pattern (2 ) Is used to execute name identification aggregation processing.
In FIG. 3, in addition to the aggregation process using the aggregation pattern (2), each of the processing contents includes a case where the aggregation process is performed without using name identification and a case where the name identification aggregation process is performed using the personal name identification master 31. Set appropriately according to
[0021]
[Household name gathering]
When the aggregate pattern (1) is used among the aggregate patterns of personal name identification of FIG. 2, the case where name identification total processing is further performed using the aggregate 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 totaling process based on the personal name identification aggregation pattern (1) is executed. Therefore, the data of the union member code “555” and union member code “888” is subjected to a name identification process, and the data relating to the shipment of pears and the shipment of tea are aggregated and aggregated.
[0022]
Further, when the name collation processing is executed using the household name collation conversion master 32, as shown in the rightmost column of FIG. 4, the data of the member codes “123”, “555”, “888” of Fujitsu Taro Not only that, but all the data of Fujitsu Ichiro's union member code "222" is aggregated and processed.
Here, the aggregate pattern setting means 40 accepts various aggregate pattern settings so as to enable aggregation processing by a combination of individuals and other items. For example, in Aggregation Pattern (1), the data of union member code “123” and union member code “222” is processed by name identification, and the data on the shipment of tomatoes by Fujitsu Taro and the shipments of tomatoes by Ichiro Fujitsu are aggregated. It is configured to perform aggregation processing. In Aggregation Pattern (2), the data of union members "123", "555", and "888" are processed by name identification, and data related to the shipment of tomato, pear and tea by Fujitsu Taro are aggregated and aggregated. It is configured as follows. Furthermore, in Aggregation Pattern (3), the data of union member code “555”, union member code “888”, and union member code “222” are processed by name identification, and the pear and tea of Fujitsu Taro and the tomato of Ichiro Fujitsu It is configured to aggregate and process data related to shipment.
[0023]
As described above, by setting various aggregate patterns as the aggregate pattern master 42, it is possible to select the most suitable aggregate pattern for each processing content.
[Aggregation pattern master]
The aggregation pattern stored in the aggregation pattern master 42 is set based on the processing contents as described above, and this example will be described with reference to FIGS.
[0024]
For example, when the head of the household is Mr. Taro Fujitsu and the number of household members is 4 or less, the name identification totaling process using the personal name identification conversion master 31 and the name identification totaling process using the household name identification conversion master 32 In addition to this, name identification and aggregation processing using the aggregation patterns (3) to (7) set in the aggregation pattern master 42 is prepared.
As shown in FIG. 6, for processing 232 (bookkeeping data aggregation) during business 001 (management), the data of Fujitsu Taro with member code 110-12345 and Jiro Fujitsu with member code 110-12322 are consolidated. Aggregation pattern (3), Aggregation pattern (4) for aggregating data of Hanako Fujitsu with member code 110-33332, Aggregation pattern (5) for aggregating data of Yoshio Fujitsu with member code 110-98767 It is set to execute name collation processing.
[0025]
In addition, as shown in FIG. 7, for the process 554 (purchase receivable) during the business 002 (purchasing), the name collation process using the household name collation conversion master 32 and the member code 110-12345 with Mr. Taro Fujitsu It is set to execute name identification aggregation processing using an aggregation pattern (3) for aggregating data of Jiro Fujitsu with member code 110-12322.
[0026]
Further, as shown in FIG. 8, regarding the process 882 (transaction results) during the business 003 (sales), the name identification totaling process using the personal name identification conversion master 31 and the name identification totaling process using the household name identification conversion master 32 Is set to run.
[Consolidation rejection master]
According to each processing content, it is configured to be able to set the aggregation rejection master 41 by accepting an aggregation rejection setting for rejecting the name identification aggregation process using the aggregation pattern master 42. FIG. 9 shows a setting menu for accepting this aggregation rejection setting.
[0027]
This aggregation rejection setting menu includes a task display column and a process display column indicating the task classification of each process and the content of the process, a rejection category display column corresponding thereto, a setting status display column, and the like. The processing contents for which refusal has been set are configured not to be aggregated for items in the setting status. Further, when the rejection category is not set, all the objects are configured to be aggregated.
[0028]
[Data management system]
As shown in FIG. 5, each database, search system, etc. 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 credit transaction record data 204 is managed by a data warehouse.
[0029]
This data warehouse further manages an integrated household master 310 (household name identification conversion master), an integrated union member master 320 (personal name identification conversion master), an aggregation rejection master 401, an aggregation pattern master 402, an union membership master 403, and the like. ing.
Further, the family name identification processing means 501 (individual / household name identification aggregation processing means) performs a name identification aggregation process on the transaction data 200 based on the integrated household master 310, the integrated member master 320, the aggregation rejection master 401, and the aggregation pattern master 402. Then, a business alias name Mart 600 composed of purchase transaction family name identification data 601, sales transaction family name identification data 602, mutual aid transaction family name identification data 603, margin transaction family name identification 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 be maintained via the aggregation refusal setting unit 301, the aggregation pattern setting unit 302, and the affiliation setting unit 303, respectively. Aggregation refusal setting means 301, aggregation pattern setting means 302, and affiliation setting means 303 are set in a terminal installed in a sales office or the like, and are activated when the staff 210 performs business-specific condition maintenance, and the setting is changed. It is configured to be able to.
[0031]
Further, the aggregation rejection setting means 301, the aggregation pattern setting means 302, and the affiliation setting means 303 can be operated by the union member 220 through the Internet network, and business condition maintenance by the union member can be performed. Yes. In addition, about the process of the condition maintenance classified by business by the staff and the condition maintenance classified by business by the individual members, authentication processing by each ID and password is required.
[0032]
In the data warehouse, an information search tool 700 for searching each data in the business alias Yi-Mart 600 is prepared, and it is possible to perform data search on the staff terminal 230 using this information search tool. It has become. In addition, data search using the information search tool 700 can be performed from the terminal 240 owned by the member through the Internet.
[0033]
【The invention's effect】
In the present invention, since the aggregation pattern setting is accepted and name identification aggregation processing is executed by this aggregation pattern, aggregation processing by various aggregation patterns is possible, and it has not been possible to perform name identification 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 in which one embodiment of the present invention is adopted.
FIG. 2 is an explanatory diagram of a personal 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 processing-specific aggregate pattern setting.
FIG. 7 is an explanatory diagram of processing-specific aggregate pattern setting.
FIG. 8 is an explanatory diagram of processing-specific aggregate pattern setting.
FIG. 9 is an explanatory diagram of an aggregation rejection pattern setting.

Claims (4)

Using a plurality of data masters, which is a set of data including at least an item related to the first key and an item related to a second key including one or more of the first keys, the first key or the second key A name identification processing system that performs aggregation processing by items related to keys,
For each piece of data included in the plurality of data masters, a search is performed using an item related to the first key, and data considered to be related to the same first key is stored in association with the corresponding first key. First name identification processing means for generating a first name identification conversion master,
For each piece of data included in the plurality of data masters, a search is performed using an item related to the second key, and data considered to be related to the same second key is stored in association with the corresponding second key. Second name identification processing means for generating a second name identification conversion master,
For each data aggregated by the item related to the second key, setting of an aggregation pattern for executing a search process aggregated by a combination of the item related to the first key and the item related to the other key An aggregate pattern setting means for generating an aggregate pattern master based on the accepted aggregate pattern setting;
And a name identification counting processing means for performing a name identification aggregation processing a search process intensive to on the basis of the aggregate pattern master for each data of the plurality of data master, the aggregate pattern setting means, using the pre-Symbol aggregate pattern A function for accepting a setting as to whether or not to execute name collation processing for each of the summarization processing and generating an aggregation rejection master for the summarization processing that does not execute the name collation processing using the aggregation pattern; Is a name identification processing system that executes name identification aggregation processing based on the aggregation pattern master and the aggregation rejection master.   The name identification processing system according to claim 1, wherein the first key is an individual and the second key is a household. Using a plurality of data masters, which is a set of data including at least an item related to the first key and an item related to a second key including one or more of the first keys, the first key or the second key A name identification processing method executed by a name identification processing system that performs aggregation processing by items related to keys,
For each piece of data included in the plurality of data masters, a search is performed using an item related to the first key, and data considered to be related to the same first key is stored in association with the corresponding first key. Generating a first name identification conversion master to:
For each piece of data included in the plurality of data masters, a search is performed using an item related to the second key, and data considered to be related to the same second key is stored in association with the corresponding second key. Generating a second name identification conversion master to:
For each data aggregated by the item related to the second key, setting of an aggregation pattern for executing a search process aggregated by a combination of the item related to the first key and the item related to the other key And generating an aggregate pattern master based on the accepted aggregate pattern settings;
Accept name identification aggregation process of whether to perform setting using the previous SL aggregate pattern for each of the aggregation process, the steps of generating an aggregate reject master for aggregation processing is not executed name identification aggregation processing using the aggregate pattern,
Executing name identification aggregation processing based on the aggregation pattern master and the aggregation rejection master;
Name identification processing method including.   The name identification processing method according to claim 3, wherein the first key is an individual and the second key is a household.

Images