JP7397766B2 - Information processing device, information processing method and program - Google Patents

Description

The present invention relates to an information processing device, an information processing method, and a program.

Recently, electronic data (e.g., data digitized by OCR (Optical Character Recognition) or data imported externally (e.g. imported into a database by EDI (Electronic Data Interchange)) is being processed into ERP (Enterprise Research). ce It has become possible to automatically connect to application software related to planning. When importing external data into ERP, codes used in ERP (specifically, values related to primary key items in various masters used in ERP) are assigned to the external data. "Name identification" (information processing) is required. In other words, the demand for name matching is increasing.

Conventional name matching systems are designed to be used in specific name matching situations. Examples of conventional name aggregation systems include a system that combines name receivables to search for receivables by the same person, and a system that combines software names to manage software correctly by absorbing variations in software name notation due to different versions. A system that performs name matching, a system that performs name matching for the purpose of correctly searching for a target company from the company name and surrounding information in CRM (Customer Relationship Management), and a customer master database used in ERP for the company name in the form. A system for aggregating company names that assigns customer codes (values related to primary key items) in An example of this is a system related to name matching of product names that assigns such values.

Note that Patent Document 1 discloses an insurance premium calculation system that allows addition, change, and deletion of insurance premium calculation formulas without modifying the source code.

Japanese Patent Application Publication No. 2013-065077

However, since ERP handles a wide variety of data, the situations for name matching are also diverse. Therefore, it is considered inefficient to design and develop a name matching system for each name matching situation, as has been the case in the past.

The present invention has been made in view of the above, and is capable of handling a wide variety of name matching situations (specifically, combinations of name matching source data (e.g., form data) and name matching destination data (e.g., master)). The purpose of the present invention is to provide an information processing device, an information processing method, and a program that can create and execute a name matching flow without having to design or develop a name matching flow for each name matching scene without coding.

In order to solve the above-mentioned problems and achieve the purpose, an information processing device according to the present invention is an information processing device including a control unit, in which a method combination of a cleansing method and a similarity calculation method is applied to target data. The template of the source data is a set of item combinations that is stored in association with the destination item, which is an item, and is used when performing name matching, and contains one or more item combinations of the source item and destination item, which are the items of the source data. and a receiving means for receiving the comparison source data and the comparison destination data, and the item combination set linked to the template of the received comparison source data. an acquisition unit that acquires from the storage unit, for each item combination in the acquired item combination set, a method combination that is linked to a previous item in the item combination, from the storage unit; 1) the acquired item combination set; For each combination of the item combination in the middle and the acquired method combination, 11) the value related to the source item in the item combination held by the received name reference data and the value held by the received name reference data; 12) Cleansing processing using the cleansing method in the method combination for the value related to the previous item in the item combination, and 12) Similarity calculation processing using the similarity calculation method in the method combination for both values after the cleansing process. 2) aggregate each of the obtained similarities, and 3) calculate information based on the obtained aggregate value and uniquely identify the reference data held by the reference data. The present invention is characterized by comprising a name matching execution means for outputting a value related to an identification destination item, which is a destination item, as a name matching result.

Further, in the information processing device according to the present invention, the storage unit further stores the weighting value in association with the previous item, and the acquisition means stores the weighting value for each item combination in the acquired item combination set. A weighting value linked to a previous item in the item is further acquired from the storage unit, and the name matching execution means multiplies each degree of similarity by each of the acquired weighted values to total each degree of similarity. do.

Further, in the information processing device according to the present invention, the name matching execution means compares the total value with one threshold value or a plurality of mutually different threshold values, and selects content according to the comparison result from information based on the total value. It is characterized by outputting as .

Further, in the information processing device according to the present invention, the name matching execution means further outputs, as a name matching result, a value related to a previous item in the acquired item combination set, which is held by the received name matching destination data; It is characterized by

Further, in the information processing device according to the present invention, the storage unit stores 1) a method combination set including a plurality of method combinations, and 2) a previous item/method combination of a previous item and identification information of the method combination, in the collation destination data. 3) an item combination set family containing one or more item combination sets, 4) 5) a first combination set family including one or more first combination sets including one or more combinations of identification information of the item combination set and identification information of the previous item/method combination set; and 5) identification of the first combination set. a second combination set including one or more combinations of information and identification information of the template of the reference data, and the acquisition means includes: 1) a template in the received reference data; 2) obtain the identification information of a first combination set linked to the identification information of the second combination set from the second combination set; 3) obtain an item combination set specified by the identification information of the item combination set in the obtained first combination set from the item combination set group; 4) obtain the previous item/method combination set specified by the identification information of the previous item/method combination set from the previous item/method combination set group; A feature of this method is to obtain a method combination that is linked to a previous item in a set of item combinations.

Further, in the information processing device according to the present invention, the control unit allows the operator to set the cleansing method through a first setting screen that includes an area for setting a cleansing method and an area for setting a similarity calculation method. , a first setting means for setting a method combination, an area for setting reference data, an area for displaying a destination item in the set reference data, and setting a method combination to be applied to the destination item. a second setting screen that allows the operator to set a destination item/method combination set, an area for setting a template for the source data, and a second setting screen that includes An area for setting data, an area for setting a destination item/method combination set, a destination item in the set destination data and a source item in the set template are displayed, and the item combination set is displayed. a third setting means for causing the operator to set the item combination set, the template of the source data, and the linkage of the destination item/method combination set via a third setting screen including an area for setting the item combination set; It is characterized by further comprising:

Further, in the information processing device according to the present invention, the storage unit stores a value related to the source item in the item combination set held by the name comparison source data and a value related to the identification destination item held by the name comparison destination data. The linked and registered dictionary data is further stored, and the control unit stores a value related to the original item in the acquired item combination set held by the received name matching source data that is registered in the dictionary data. is the same as the dictionary data, the value related to the identification item registered in the dictionary data and information indicating that the value is registered in the dictionary data are output as the matching result. The name matching execution means further comprises a means for performing name matching, when a value related to a source item in the acquired item combination set held by the received name matching source data is not the same as a value registered in the dictionary data. The method is characterized by executing the processes 1) to 3) above.

Further, in the information processing device according to the present invention, the control unit, in the name matching execution means, obtains a value related to the original item in the acquired item combination set held by the received name matching source data, and a value related to the source item in the acquired item combination set, and When a specific combination with a value related to an identification item held in the identification destination data is recorded a predetermined number of times or more, output proposal information that outputs information for proposing registration of the specific combination in the dictionary data. The method further comprises means.

Furthermore, in the information processing device according to the present invention, the source data and destination data are transferred from application software related to ERP (Enterprise Resource Planning), and the output is a combination of the source data and destination data. It is characterized in that the output destination is application software related to the ERP of the transfer source.

Furthermore, the information processing device according to the present invention is characterized in that the name identification data is a master set in application software related to ERP.

Furthermore, the information processing apparatus according to the present invention is characterized in that the name identification data is electronic data digitized by OCR (Optical Character Recognition) or externally imported.

Further, in the information processing method according to the present invention, a method combination of a cleansing method and a similarity calculation method is stored in association with a destination item that is an item of the name comparison destination data, and a source item that is an item of the name comparison source data is stored. Executed by an information processing device equipped with a control unit that can access a storage unit in which a set of item combinations used when performing name matching, including one or more item combinations of and destination item, is stored in association with the template of the name matching source data. The information processing method includes a receiving step of receiving the reference data and the reference data, which is executed by the control unit, and a set of item combinations linked to the template of the received reference data from the storage unit. an acquisition step of acquiring, for each item combination in the acquired item combination set, a method combination linked to a previous item in the item combination from the storage unit; 1) an item in the acquired item combination set; For each combination of a combination and the acquired method combination, 11) the value related to the source item in the item combination held by the received name reference data and the item combination held by the received name reference data; 12) A cleansing process using the cleansing method in the method combination for the value related to the previous item in 12) A similarity calculation process using the similarity calculation method in the method combination for both values after the cleansing process. 2) aggregate each of the obtained similarities, and 3) calculate information based on the obtained aggregate value and a previous item for uniquely identifying the reference data held by the reference data. It is characterized by including a name matching execution step of outputting a value related to a certain identification destination item as a name matching result.

Further, the program according to the present invention is such that a method combination of a cleansing method and a similarity calculation method is stored in association with a destination item that is an item of the name comparison destination data, and a source item that is an item of the name comparison source data and a destination item are stored. To cause the execution to be executed by an information processing device equipped with a control unit that can access a storage unit in which a set of item combinations used when performing name matching, including one or more item combinations with items, is stored in association with the template of the name matching source data. The program includes a receiving step for receiving the reference data and the reference data to be executed by the control unit, and a set of item combinations linked to the template of the received reference data from the storage unit. , an acquisition step of acquiring, for each item combination in the acquired item combination set, a method combination linked to a previous item in the item combination from the storage unit; 1) the item combination in the acquired item combination set; For each combination with the acquired method combination, 11) the value related to the source item in the item combination held by the received name reference data and the value of the source item in the item combination held by the received name reference data; 12) Perform a cleansing process using the cleansing method in the method combination for the value related to the previous item, and 12) Perform a similarity calculation process on both values after the cleansing process using the similarity calculation method in the method combination. , 2) aggregate each of the obtained similarities, and 3) information based on the obtained aggregate value and identification, which is the first item for uniquely identifying the reference data held by the reference data. The present invention is characterized by including a name matching execution step of outputting a value related to the previous item as a name matching result.

The present invention designs and develops name matching flows for each name matching situation, which correspond to a wide variety of name matching situations (specifically, combinations of name matching source data (e.g., form data) and name matching destination data (e.g., master)). This has the effect that it can be created and executed without any coding.

FIG. 1 is a diagram showing an overview of this embodiment. FIG. 2 is a diagram showing an overview of this embodiment. FIG. 3 is a diagram showing an overview of this embodiment. FIG. 4 is a diagram showing an overview of this embodiment. FIG. 5 is a diagram showing an overview of this embodiment. FIG. 6 is a diagram showing an overview of this embodiment. FIG. 7 is a diagram showing an overview of this embodiment. FIG. 8 is a diagram showing an example of the configuration of the information processing device 100. FIG. 9 is a diagram showing an example of the processing process data 106a. FIG. 10 is a diagram showing an example of cleansing application data 106b. FIG. 11 is a diagram showing an example of the cleansing method master 106c. FIG. 12 is a diagram showing an example of the similarity calculation method master 106d. FIG. 13 is a diagram showing an example of the master-processing process mapping data 106e. FIG. 14 is a diagram showing an example of master-processing process mapping detail data 106f. FIG. 15 is a diagram showing an example of the master list master 106g. FIG. 16 is a diagram showing an example of the master item master 106h. FIG. 17 is a diagram showing an example of the name matching method data 106i. FIG. 18 is a diagram showing an example of the code assignment setting data 106j. FIG. 19 is a diagram showing an example of column mapping data 106k. FIG. 20 is a diagram showing an example of the data template master 106m. FIG. 21 is a diagram showing an example of the data template item master 106n. FIG. 22 is a diagram showing an example of the code assignment dictionary condition data 106p. FIG. 23 is a diagram showing an example of code assignment dictionary assignment data 106q. FIG. 24 is a diagram showing an example of the operation log data 106r. FIG. 25 is a diagram showing an example of the modified log header data 106s. FIG. 26 is a diagram showing an example of modification log detail data 106t. FIG. 27 is a diagram showing an example of the processing step setting screen MA. FIG. 28 is a diagram showing an example of the master-processing process mapping setting screen MB. FIG. 29 is a diagram showing an example of the name matching method setting screen MC. FIG. 30 is a diagram showing an example of the name matching results.

Embodiments of an information processing device, an information processing method, and a program according to the present invention will be described in detail below based on the drawings. Note that the present invention is not limited to this embodiment.

[1. overview]
Here, an overview of this embodiment will be explained with reference to FIGS. 1 to 7.

In the past, name matching systems were created according to the situations in which names were to be linked, but since there are a wide variety of situations in which names should be linked in ERP, it was inefficient to create a system for each situation.

In this embodiment, by defining the optimal name matching processing process for each master item, the operator does not need to be aware of the internal processing of name matching, and can perform appropriate name matching just by mapping items. is now automatically implemented. The processing steps consist of cleansing and similarity calculation, and the cleansing method and similarity calculation method for each processing step can be selected depending on the characteristics of the processing step target value. This reduces development costs and allows you to create a suitable name identification system without the need for coding.

FIG. 1 shows an abstracted flow of the name matching process performed in this embodiment. In this embodiment, the name matching process in each name matching scene is abstracted and the process flow is defined. This clarified the parts that should be customized for each name gathering situation. In the name matching process, first, item mapping is performed between the received name matching source data and the received master, then a cleansing process and similarity calculation are performed for each item, and finally, the similarities are aggregated and a code is assigned.

FIG. 2 shows an example of a group of processing steps and a mapping of the processing steps. Since cleansing and similarity calculation differ depending on the data type (for example, person's name, address, etc.), in this embodiment, these are collectively named a "processing step" and a processing step is created for each data type. Furthermore, by mapping appropriate processing steps to items in the master, name matching processing according to the master can be realized by mapping settings. In order to have the master item data in the name matching system, the mapping settings between the master and the processing steps can be stored in the name matching system. This eliminates the need to configure the mapping each time name matching is performed. Further, since the processing steps for the comparison source data are determined only by mapping the processing steps to the master, there is no need to map the comparison source data and the processing steps.

FIG. 3 shows an example of componentization of cleansing and similarity calculation. In this embodiment, the componentization makes it easy to change the processing steps, efficiently add processing steps, cleansing and similarity calculation methods, and customize the processing steps. In this embodiment, necessary parts (cleansing method and similarity calculation method) can be selected for each processing step depending on the usage situation.

FIG. 4 shows the processing of the code assignment dictionary. Depending on the data, there may be unique notation variations depending on the situation, and it may not be possible to assign the correct code. It is inefficient to perform name matching processing on such data. Therefore, in this embodiment, processing is performed using a code assignment dictionary in which the set of the input data value (value related to the item of the name identification source data) and the code to be assigned (value related to the master primary key item) is set as a record. . This will give you the correct code. Furthermore, since codes can be assigned without performing name matching processing, name matching processing can be performed at high speed. In other words, by registering scene-specific spelling variations in a dictionary, name matching can be performed accurately and quickly.

FIG. 5 shows an example of the matching results and matching degree symbols for the matching source data. In this embodiment, the assigned code, degree of matching, and peripheral information corresponding to the code are displayed in the name matching result. The degree of coincidence of the assigned codes is displayed by the degree of coincidence symbol shown in FIG. In this way, by changing the display of codes assigned by the dictionary, it is possible to improve the interpretability of the name matching results.

FIG. 6 shows an example of weighting values to be introduced into similarity aggregation. Name matching uses multiple items in the master and source data, but the importance of each item in name matching differs. Therefore, in this embodiment, by introducing a weighted value and multiplying it by the weighted value when calculating the similarity, it is possible to assign a code in consideration of the importance of each column (item), thereby improving accuracy.

FIG. 7 shows an example of a modification log. In this embodiment, two types of logs can be acquired: operation logs and modification logs. When a log of a set of a specific input and a corrected assigned code is recorded multiple times, it is automatically suggested that this set be registered in the code assigned dictionary. The operator can decide whether or not to register the proposal in the dictionary. For example, as shown in Figure 7, if the input is "OBIC, Chuo-ku, Tokyo, SIer" and the group with the corrected code "A0002" has been recorded several times, then , Chuo-ku, Tokyo, SIer', a code of 'A0002' will be assigned,' and the operator will decide whether registration is possible. Further, when creating a processing step and comparing accuracy with an existing processing step, a modification log is used as a reference for comparison. Using the modification log, evaluate whether the new processing process can accurately assign codes to inputs that required modification in the existing processing process.

According to this embodiment, by retaining processing steps that summarize data types, name matching can be performed for a wide range of usage situations. Furthermore, the processing steps for each type of data can be set simply by mapping, which can reduce costs. In addition, accuracy was maintained by ``setting the appropriate processing process for each data type,'' ``being able to replace parts of the processing process depending on the usage situation,'' and ``corresponding to variations in notation using a code assignment dictionary.'' Name identification can be performed. Furthermore, by ``changing the display of the results using the code assignment dictionary'', the results can be used to assist in correction work. These allow manual correction work to be performed efficiently.

[2. Configuration/Processing]
Here, an example of the configuration and processing of the information processing apparatus according to this embodiment will be described with reference to FIGS. 8 to 30.

FIG. 8 is a block diagram showing an example of the configuration of the information processing device (name matching processing device) 100. Information processing device 100 is a commercially available desktop personal computer. Note that the information processing device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may also be a portable type such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer. It may also be an information processing device.

The information processing device 100 includes a control section 102, a communication interface section 104, a storage section 106, and an input/output interface section 108. Each unit included in the information processing device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicatively connects the information processing device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of connecting the information processing device 100 and the ERP system 200 (information processing device into which application software related to ERP has been installed) so that they can communicate with each other, for example, the Internet or LAN (Local Area Network) etc. Note that the information processing device 100 may be one in which application software related to ERP is installed.

An input device 112 and an output device 114 are connected to the input/output interface unit 108 . As the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used. Note that in the following description, the output device 114 may be referred to as a monitor 114, and the input device 112 may be referred to as a keyboard 112 or a mouse 112.

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for giving instructions to a CPU (Central Processing Unit) to perform various processes in cooperation with an OS (Operating System). As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, etc. can be used.

[2-1. Overview of configuration of storage unit 106]
Here, an overview of the configuration of the storage unit 106 will be explained. In the storage unit 106, a method combination of a cleansing method and a similarity calculation method is stored in association with a destination item that is an item of the data to be compared, and is stored in association with a source item that is an item of the source data. An item combination set used when performing name matching that includes one or more item combinations with the previous item is stored in association with the template of the matching source data.

Here, the storage unit 106 may store the following data [11] to [15]. Note that the storage unit 106 may further store the weighting value in association with the previous item. Further, the storage unit 106 may further store the following data [16].
[11] Method combination set that includes multiple method combinations [12] A destination item/method combination set that includes the number of destination item/method combinations of the destination item and identification information of the method combination, as many as the number of destination items in the destination data, [13] Item combination set family that includes one or more item combination sets [14] Identification information of the item combination set and identification information of the previous item/method combination set A first combination set family that includes one or more first combination sets that include one or more combinations [15] Contains one or more combinations of the identification information of the first combination set and the identification information of the template of the name source data Second combination set [16] The value related to the source item in the item combination set held by the name source data and the identification destination item that is the first item for uniquely identifying the name source data and held by the name source data. Dictionary data registered by linking values related to (e.g. primary key items) and

Here, the source data includes, for example, purchase order data, quotation data, other form data (for example, electronic data digitized by OCR or externally imported (for example, imported into a database by EDI)), etc. ). The name identification data is, for example, a customer master, a product master, or another master set in the ERP system 200.

[2-2. Specific example of configuration of storage unit 106]
Here, a specific example of the configuration of the storage unit 106 will be described with reference to FIGS. 9 to 26. Specifically, the storage unit 106 stores the following data and masters.
・Processing process data 106a
・Cleansing application data 106b
・Cleansing method master 106c
・Similarity calculation method master 106d
・Master processing process mapping data 106e
・Master processing process mapping detail data 106f
・Master list master 106g
・Master item master 106h
・Name identification method data 106i
・Code assignment setting data 106j
・Column mapping data 106k
・Data template master 106m
・Data template item master 106n
・Code assignment dictionary condition data 106 pages
・Code assignment dictionary assignment data 106q
・Operation log data 106r
・Correction log header data 106s
・Correction log detail data 106t

FIG. 9 is a diagram showing an example of the processing process data 106a. The processing process data 106a includes processing process identification information (corresponding to the identification information of the method combination), similarity calculation method identification information (corresponding to the identification information of the similarity calculation method in the method combination), and data generation date.

FIG. 10 is a diagram showing an example of cleansing application data 106b. The cleansing application data 106b includes processing step identification information (corresponding to the identification information of the method combination), execution order, cleansing method identification information (corresponding to the identification information of the cleansing method in the method combination), the path to dictionary data, and the data generation date. including.

FIG. 11 is a diagram showing an example of the cleansing method master 106c. The cleansing method master 106c includes cleansing method identification information (corresponding to cleansing method identification information) and a dictionary flag.

FIG. 12 is a diagram showing an example of the similarity calculation method master 106d. The similarity calculation method master 106d includes similarity calculation method identification information (corresponding to similarity calculation method identification information) and option flags.

FIG. 13 is a diagram showing an example of the master-processing process mapping data 106e. The master processing step mapping data 106e includes master processing step mapping identification information (corresponding to the identification information of the previous item/method combination set), master identification information (corresponding to the identification information of the collation destination data), and data generation date.

FIG. 14 is a diagram showing an example of master-processing process mapping detail data 106f. The master-processing process mapping detail data 106f corresponds to the previous item/method combination set family. The master processing process mapping detail data 106f includes master processing process mapping identification information (corresponding to the identification information of the previous item/method combination set), master item identification information (corresponding to the identification information of the previous item in the previous item/method combination) , processing step identification information (corresponding to the identification information of the method combination in the previous item/method combination), weighting value, and data generation date.

FIG. 15 is a diagram showing an example of the master list master 106g. The master list master 106g includes master identification information (corresponding to identification information of the name identification data).

FIG. 16 is a diagram showing an example of the master item master 106h. The master item master 106h includes master item identification information (corresponding to the identification information of the previous item), master identification information (corresponding to the identification information of the data to be collated), and primary key setting information.

FIG. 17 is a diagram showing an example of the name matching method data 106i. The name matching method data 106i corresponds to a second combination set. The name matching method data 106i includes name matching method identification information (corresponding to the identification information of the first combination set), data template identification information (corresponding to the identification information of the template of the name matching source data), and data generation date.

FIG. 18 is a diagram showing an example of the code assignment setting data 106j. The code assignment setting data 106j corresponds to the first combination set family. The code assignment setting data 106j includes name matching method data identification information (corresponding to the identification information of the item combination set), name matching method identification information (corresponding to the identification information of the first combination set), master processing process mapping identification information (previous item/method (equivalent to the identification information of the combination set) and the data generation date.

FIG. 19 is a diagram showing an example of column mapping data 106k. The column mapping data 106k corresponds to an item combination set family. Name matching method data identification information (corresponds to the identification information of the item combination set), master item identification information (corresponds to the identification information of the previous item in the item combination), and data item identification information (corresponds to the identification information of the source item in the item combination) )including.

FIG. 20 is a diagram showing an example of the data template master 106m. The data template master 106m includes data template identification information (corresponding to identification information of the template of the name matching source data).

FIG. 21 is a diagram showing an example of the data template item master 106n. The data template item master 106n includes data item identification information (corresponding to the identification information of the original item) and data template identification information (corresponding to the identification information of the template of the source data).

FIG. 22 is a diagram showing an example of the code assignment dictionary condition data 106p. The code assignment dictionary condition data 106p includes code assignment dictionary record identification information, data item identification information, and a code value related to the item specified by the data item identification information.

FIG. 23 is a diagram showing an example of code assignment dictionary assignment data 106q. The code assignment dictionary assignment data 106q includes code assignment dictionary record identification information, master identification information, and a code value related to a primary key item held by a master specified by the master identification information.

FIG. 24 is a diagram showing an example of the operation log data 106r. The operation log data 106r includes operation log identification information, data name identification information, name matching method identification information (corresponding to identification information of the first combination set), and data generation date.

FIG. 25 is a diagram showing an example of the modified log header data 106s. The modification log header data 106s includes modification log identification information, operation log identification information, name identification method data identification information (corresponding to identification information of an item combination set), a pre-modification code value, a post-modification code value, and a data generation date.

FIG. 26 is a diagram showing an example of modification log detail data 106t. The modification log detail data 106t includes modification log identification information, data item identification information (corresponding to the identification information of the original item in the item combination), a code value related to the item specified by the data item identification information, and a data generation date. .

This concludes the description of the specific example of the configuration of the storage unit 106.

Returning to FIG. 8, the control unit 102 is a CPU or the like that centrally controls the information processing device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs specifying various processing procedures, required data, etc., and performs various information processing based on these stored programs. Execute.

Functionally, the control unit 102 includes a first setting unit 102a, a second setting unit 102b, a third setting unit 102c, a receiving unit 102d, an acquisition unit 102e, a dictionary use name matching unit 102f, a name matching unit 102g, and proposal information. It includes an output section 102h and the like.

[2-3. Overview of processing executed by each processing unit included in the control unit 102]
Here, an overview of the processing executed by each processing unit included in the control unit 102 will be explained.

The first setting unit 102a allows the operator to set the method combination via the first setting screen. The first setting screen includes an area for setting a cleansing method and an area for setting a similarity calculation method.

The second setting unit 102b allows the operator to set the previous item/method combination set via the second setting screen. The second setting screen has an area for setting the name reference data, an area for displaying the destination item in the set name reference data, and an area for setting the method combination to be applied to the destination item. ,including.

The third setting unit 102c allows the operator to set the linkage of the item combination set, the template of the source data, and the destination item/method combination set via the third setting screen. The third setting screen has an area for setting a template for the reference data, an area for setting the reference data, an area for setting a target item/method combination set, and an area for setting the reference data that has been set. It includes an area for displaying the previous item in the data and the original item in the set template, and setting an item combination set.

The receiving unit 102d receives the matching source data and the matching destination data. The receiving unit 102d may receive the comparison source data and the comparison destination data transferred from the ERP system 200.

The acquisition unit 102e acquires from the storage unit 106 an item combination set that is linked to the template of the matching source data received by the reception unit 102d, and for each item combination in the acquired item combination set, selects the previous item in the item combination. The method combination associated with is acquired from the storage unit 106.

The acquisition unit 102e may further acquire from the storage unit 106, for each item combination in the acquired item combination set, a weighting value associated with the previous item in the item combination.

The acquisition unit 102e may execute the following processes [21] to [24].
[21] Obtain the identification information of the first combination set linked to the identification information of the template in the matching source data received by the receiving unit 102d from the second combination set.
[22] A first combination set specified by the identification information of the first combination set obtained in [21] is obtained from the first combination set family.
[23] Obtain the item combination set specified by the identification information of the item combination set in the first combination set obtained in [22] from the item combination set family, and also obtain the previous item in the obtained first combination set. - Obtain the previous item/method combination set specified by the identification information of the method combination set from the previous item/method combination set family.
[24] From the previous item/method combination set obtained in [23], obtain the method combination that is linked to the previous item in the item combination set obtained in [23].

The dictionary-using name matching execution unit 102f selects "original items in the item combination set acquired by the acquisition unit 102e (specifically, the item combination set acquired in [23]) that is held by the name matching source data received by the receiving unit 102d. If the "value related to" is the same as the one registered in the dictionary data, the value related to the identification item (e.g. primary key item) registered in the dictionary data and the value related to the value registered in the dictionary data. The information indicating that the name is the same (for example, the character information "ji") is output as the name matching result, for example, to the ERP system 200, which is the transfer source of the name matching source data and the name matching destination data, as an output destination.

The name matching execution unit 102g executes the following processes [31] to [33].
[31] “Item combinations in the item combination set acquired by the acquisition unit 102e (specifically, the item combination set acquired in [23])” and “method combinations acquired by the acquisition unit 102e (specifically, the item combination set acquired in [23])” The following process [311] and process [312] are executed for each combination of "method combination obtained in )".
[311] “The value related to the source item in the item combination that is held by the matching source data received by the receiving unit 102d” and “the previous item in the item combination that is held by the matching destination data received by the receiving unit 102d” [312] Similarity calculation processing using the similarity calculation method in the combination of methods for both values after the cleansing process [32] [31] The calculated similarities are then aggregated.
[33] The information based on the aggregate value obtained in [32] and the value related to the identification item (e.g. primary key item) held by the target data are merged with, for example, the source data as the merge result. The ERP system 200 from which the destination data is transferred is output as the output destination.

The name matching execution unit 102g may aggregate each similarity degree by multiplying each similarity degree by each acquired weighting value.

The name matching execution unit 102g compares the total value with one threshold value or a plurality of mutually different threshold values, and selects content according to the comparison result (e.g., a symbol (e.g., ○) indicating that the name matching accuracy is high), A symbol (for example, △) that means that the accuracy of name matching is medium, and a symbol (for example, ×) that means that the accuracy of name matching is low may be output as information based on the total value.

The name matching execution unit 102g performs a process based on “the previous item in the item combination set obtained by the obtaining unit 102e (specifically, the item combination set obtained in [23]) that is held by the name matching data received by the receiving unit 102d. value" may be further output as the name matching result.

The name matching execution unit 102g performs a process based on “the original item in the item combination set obtained by the obtaining unit 102e (specifically, the item combination set obtained in [23]) that is held by the name matching source data received by the receiving unit 102d. If the "value" is not the same as that registered in the dictionary data, the processes from [31] to [33] may be executed.

The proposal information output unit 102h outputs "the original item in the item combination set acquired by the acquisition unit 102e (specifically, the item combination set acquired in [23]) held by the name matching data received by the reception unit 102d". When a specific combination of ``value related to this value'' and ``value related to an identification item (e.g. primary key item) held by the name comparison data received by the receiving unit 102d'' is recorded a predetermined number of times or more in the name comparison execution unit 102g. , the proposal information for proposing registration of the particular combination in the dictionary data (for example, text information regarding the proposal) is outputted to, for example, the ERP system 200 that is the source of the transfer source data and destination data. .

This concludes the explanation of the outline of the processing executed by each processing unit included in the control unit 102.

[2-4. Specific example of processing executed by each processing unit included in the control unit 102]
Here, specific examples of processing executed by each processing unit included in the control unit 102 will be described with reference to FIGS. 27 to 30 and the like.

The first setting unit 102a allows the operator to set the cleansing method and similarity calculation method, which are the basis of the processing step to be registered, via the processing step setting screen MA.

FIG. 27 is a diagram showing an example of the processing step setting screen MA. The processing step setting screen MA includes a registration button MA1, a cancel button MA2, a back button MA3, a setting area MA4, a setting area MA5, and a setting area MA6.

Setting area MA4 is an area for setting processing process identification information of a processing process to be registered. The setting area MA5 is an area for setting cleansing method identification information of the cleansing method that is the basis of the processing step to be registered. The setting area MA6 is an area for setting similarity calculation method identification information of the similarity calculation method that is the basis of the processing step to be registered.

The operator sets the processing step to be registered in the setting area MA4, and sets the cleansing method and similarity calculation method that are the basis of the processing step in the setting area MA5 and setting area MA6. The operator may press the + button to set multiple cleansing methods. The cleansing methods and similarity calculation methods that can be set are those in the cleansing method master 106c in FIG. 11 and the similarity calculation method master 106d in FIG. 12. When the registration button MA1 is pressed, the information on the treatment process setting screen MA is registered in the treatment process data 106a in FIG. 9 and the cleansing application data 106b in FIG. 10. The information shown in FIGS. 9 and 10 is registered before executing the name matching process.

Returning to FIG. 8, the second setting unit 102b allows the operator to set the master, master item, processing process, and weighting value on which the master processing process mapping to be registered is based via the master processing process mapping setting screen MB. .

FIG. 28 is a diagram showing an example of the master-processing process mapping setting screen MB. The master-processing process mapping setting screen MB includes a registration button MB1, a cancel button MB2, a back button MB3, a setting area MB4, a setting area MB5, and a setting area MB6.

The setting area MB4 is an area for setting master identification information of a master that is the basis of the master processing step mapping to be registered. The setting area MB5 is an area for setting master processing process mapping identification information of the master processing process mapping to be registered. The setting area MB6 displays the master item identification information of the master item in the master specified by the master identification information set in the setting area MB4, and sets the process process identification information and weighting value of the process process applied to the master item. This is an area for

The operator sets the master processing step mapping to be registered in the setting area MB5, and sets the master on which the master processing step mapping to be registered is based in the setting area MB4. The masters that can be set are the masters in the master list master 106g in FIG. 15. When a master is set in the setting area MB4, master items linked to the set master in the master item master 106h in FIG. 16 are displayed in the setting area MB6. The operator sets the processing steps and weighting values to be applied to the displayed master item in the setting area MB6. When the registration button MB1 is pressed, the information on the master-processing process mapping setting screen MB is registered in the master-processing process mapping data 106e in FIG. 13 and the master-processing process mapping detailed data 106f in FIG. 14. The information shown in FIGS. 13 and 14 is registered before executing the name matching process.

Returning to FIG. 8, the third setting unit 102c prompts the operator, via the name matching method setting screen MC, to provide the data template, name matching method data, master processing process mapping, master item, and data item that are the basis of the name matching method to be registered. Let it be set.

FIG. 29 is a diagram showing an example of the name matching method setting screen MC. The name identification method setting screen MC includes a registration button MC1, a cancel button MC2, a return button MC3, a setting area MC4, a setting area MC5, a setting area MC6, a setting area MC7, and a setting area MC8.

The setting area MC4 is an area for setting the name matching method identification information of the name matching method to be registered. The setting area MC5 is an area for setting data template identification information of a data template that is the basis of the name matching method to be registered. The setting area MC6 is an area for setting a master. The setting area MC7 is an area for setting master processing process mapping identification information of a master processing process mapping that is the basis of the name matching method to be registered. The setting area MC8 is linked to the master item identification information of the master item in the master specified by the master identification information set in the setting area MC6 and the data template specified by the data template identification information set in the setting area MC5. This area is for displaying the data item identification information of the attached data item and for setting name matching method data for assigning one code.

The operator sets the name matching method to be registered in the setting area MC4, and sets the data template that is the basis of the name matching method to be registered in the setting area MC5. The data templates that can be set are the templates in the data template master 106m in FIG. 20. When a data template is set in the setting area MC5, the data items linked to the set data template in the data template item master 106n in FIG. will be displayed. The operator sets a master used for assigning one code in the setting area MC6. The masters that can be set are the masters in the master list master 106g in FIG. 15. When a master is set in the setting area MC6, the master items linked to the set master in the master item master 106h in FIG. 16 are displayed in an area titled "Master Column" in the setting area MC8. . The operator sets, in the selection area MC7, a master processing process mapping that is the basis of the name matching method to be registered. The operator sets a combination of data items and master items displayed in the setting area MC8 to be used when assigning one code using a line or the like as shown in FIG. 28. When the registration button MC1 is pressed, the information on the name matching method setting screen MC is registered in the name matching method data 106i of FIG. 17, the code assignment setting data 106j of FIG. 18, and the column mapping data 106k of FIG. 19. The information shown in FIGS. 17, 18, and 19 is registered before the name matching process is executed.

Returning to FIG. 8, the receiving unit 102d receives the form data (table) (an example of the data to be compared) and the master (table) (an example of the data to be compared) transferred from the ERP system 200.

The acquisition unit 102e executes the following processes [41] to [46].
[41] From the name matching method data 106i, the name matching method identification information that is linked to the template identification information of the form data that is given to the form data received by the receiving unit 102d is acquired.
[42] One or more "combinations of name matching method data identification information and master processing step mapping identification information" that are linked to the name matching method identification information obtained in [41] are acquired from the code assignment setting data 106j.
[43] For each name matching method data identification information obtained in [42], one or more "combinations of master item identification information and data item identification information" linked to the name matching method data identification information are extracted from the column mapping data 106k. get.
[44] For each master processing process mapping identification information acquired in [42], from the master processing process mapping data 106e and the master processing process mapping detailed data 106f, the master identification information linked to the master processing process mapping identification information and a plurality of The "combination of master item identification information, processing process identification information, and weighting value" is obtained.
[45] For each master item identification information obtained in [43], a process of linking it to the master item identification information from the multiple "combinations of master item identification information, processing process identification information, and weighting values" obtained in [44]. Obtain process identification information and weighting values.
[46] For each processing step identification information acquired in [45], from the processing step data 106a and the cleansing application data 106b, "one or more cleansing method identification information and one or more "combination of similarity calculation method identification information" is obtained.

The dictionary use name matching execution unit 102f i) acquires data item identification information and code values, which are conditions for matching judgment, from the code assignment dictionary condition data 106p based on the code assignment dictionary record identification information; The code value to be assigned is acquired from the data 106q, and ii) the acquisition unit 102e acquires each data item identification information acquired in [43] and the respective data item identification information held by the form data received by the reception unit 102d. It is determined whether each value related to each specified item all matches the data item identification information and code value obtained in i).

When the dictionary use name matching execution unit 102f determines that there is a match, the code value to be assigned obtained in step i) and information indicating that the value is registered in the dictionary data (for example, character information "ji") are added. ) is output as the name matching result, for example, to the ERP system 200 from which the form data and master are transferred.

For example, when the dictionary-using name matching execution unit 102f does not determine that there is a match, the name matching execution unit 102g executes the following processes [51] to [53].
[51] The acquisition unit 102e acquires the “combination of master item identification information and data item identification information” acquired in [43], and the acquisition unit 102e acquires “one or more cleansing method identification information and one The following cleansing process [511] and the following similarity calculation process [512] are executed for each combination of "combination of one or more similarity calculation method identification information".
[511] “The value related to the item specified by the data item identification information in the “combination of master item identification information and data item identification information” held by the form data received by the receiving unit 102d” The "one or more cleansing method identifications" for the "value related to the item specified by the master item identification information in the "combination of master item identification information and data item identification information" held by the master received in [512] Cleansing processing using the cleansing method specified by the cleansing method identification information in the "combination of similarity calculation method identification information and one or more similarity calculation method identification information." Each similarity calculation process obtained by the similarity calculation process [52] [51] specified by the similarity calculation method identification information in "Combination of method identification information and one or more similarity calculation method identification information" The similarity is multiplied by each weighting value obtained by the acquisition unit 102e in [45], and the respective similarity is totaled.
[53] The magnitude of the aggregate value obtained in [52] is compared with one threshold value or a plurality of mutually different threshold values, and the following information is used as the name matching result, for example, in the ERP of the transfer source of the form data table and the master table. The system 200 is used as the output destination.
・Contents according to the comparison results (e.g., a symbol that means the accuracy of name matching is high (e.g., ○), a symbol that means that the accuracy of name matching is medium (e.g., △), a symbol that means that the accuracy of name matching is low, Symbols that mean things (e.g. ×))
・The master primary key item received by the receiving unit 102d and the value (code) related to the primary key item
- Identification using the master item identification information in the "combination of master item identification information and data item identification information" acquired by the acquisition unit 102e in [43] and the master item identification information held by the master received by the receiving unit 102d. Value related to the item

FIG. 30 is a diagram showing an example of the name matching results output by the name matching execution unit 102g.

The proposal information output unit 102h outputs each data item identification in each ``combination of master item identification information and data item identification information'' acquired by the acquisition unit 102e in [43], which is held in the form data received by the reception unit 102d. When a specific combination of "each value associated with each item specified by the information" and "the value associated with the primary key item held by the master received by the receiving unit 102d" is recorded a predetermined number of times or more in the name matching execution unit 102g. , proposal information (for example, text information regarding the proposal) for proposing registration of the specific combination in the code assignment dictionary data (specifically, the code assignment dictionary condition data 106p and the code assignment dictionary assignment data 106q), For example, the ERP system 200, which is the transfer source of the form data and the master, is output as the output destination.

[3. Summary of this embodiment]
As described above, according to this embodiment, name matching can be performed at low cost in a wide range of usage situations. In addition, by setting the appropriate processing process for each type of data, making detailed settings for each usage situation, and changing the display of results using a code dictionary, the burden of manual correction of name matching results is reduced. Ru.

[4. Other embodiments]
In addition to the embodiments described above, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.

For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all of the processes described as being performed manually can be performed manually. Alternatively, some of the steps can be performed automatically using known methods.

In addition, unless otherwise specified, information including processing procedures, control procedures, specific names, parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings are included. It can be changed arbitrarily.

Further, regarding the information processing device 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, the processing functions provided in the information processing device 100, especially each processing function performed by the control unit, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be implemented as hardware using wired logic. Note that the program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processing described in this embodiment. Machine read to 100. That is, a storage unit such as a ROM or an HDD (Hard Disk Drive) stores a computer program that cooperates with an OS to give instructions to a CPU and perform various processes. This computer program is executed by being loaded into the RAM, and constitutes a control unit in cooperation with the CPU.

Further, this computer program may be stored in an application program server connected to the information processing device 100 via an arbitrary network, and all or part of it may be downloaded as necessary. be.

Further, a program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), and an EE. PROM (registration Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk) ), DVD (Digital Versatile Disk), Blu-ray (registered trademark) Disc, etc. shall include any “portable physical medium”.

Further, a "program" is a data processing method written in any language or writing method, and does not matter in the form of source code or binary code. Note that a "program" is not necessarily limited to a unitary structure, but may be distributed as multiple modules or libraries, or may work together with separate programs such as an OS to achieve its functions. Including things. Note that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiments, and the installation procedure after reading.

The various databases stored in the storage unit are storage devices such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and are used for various processing and website provision. Stores programs, tables, databases, web page files, etc.

Further, the information processing device 100 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as the information processing device to which any peripheral device is connected. Further, the information processing device 100 may be implemented by installing software (including programs, data, etc.) that allows the device to implement the processing described in this embodiment.

Furthermore, the specific form of dispersion and integration of devices is not limited to what is shown in the diagram, and all or part of them can be functionally or physically divided into arbitrary units according to various additions or functional loads. It can be configured in a distributed/integrated manner. That is, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively.

The present invention is particularly useful in name matching processing.

100 Information processing device 102 Control unit
102a First setting section
102b Second setting section
102c Third setting section
102d Receiving section
102e Acquisition part
102f Dictionary usage name matching execution unit
102g name matching execution part
102h Proposal information output section 104 Communication interface section 106 Storage section
106a Processing process data
106b Cleansing application data
106c cleansing method master
106d Similarity calculation method master
106e Master processing process mapping data
106f Master processing process mapping detail data
106g Master list master
106h Master item master
106i name identification method data
106j Code assignment setting data
106k column mapping data
106m data template master
106n Data template item master
106p code assignment dictionary condition data
106q Code assignment dictionary assignment data
106r operation log data
106s modification log header data
106t Modification log detailed data 108 Input/output interface section 112 Input device 114 Output device 200 ERP system 300 Network

Claims (12)

An information processing device comprising a control unit,
A method combination of a cleansing method and a similarity calculation method is stored in association with a destination item that is an item of the source data, and one or more item combinations of the source item and destination item that are the items of the source data are stored. It is possible to access a storage unit in which a set of item combinations including multiple items used when performing name matching is stored in association with a template of the name matching source data having a predetermined pattern or layout ;
The control unit includes:
a receiving means for receiving the reference data and the reference data;
The item combination set linked to the template identification information given to the received name reference data is obtained from the storage unit, and for each item combination in the obtained item combination set, the item combination set is linked to the previous item in the item combination. an acquisition means for acquiring a combination of methods from the storage unit;
1) For each combination of the item combination in the acquired item combination set and the acquired method combination, 11) The value related to the original item in the item combination held by the received name matching source data and the value of the received item combination. 12) Cleansing processing by the cleansing method in the method combination for the value related to the previous item in the item combination held by the name identification data held by the name matching destination data, and 12) similarity in the method combination for both values after the cleansing process. 2) aggregate each of the obtained similarities, and 3) collect information based on the obtained aggregate value and the name reference data held by the name reference data. a name matching execution means that outputs a value related to an identification destination item that is a destination item for uniquely identifying data as a name matching result;
In addition,
The storage unit includes:
Dictionary data that is registered by linking the value related to the source item in the item combination set held by the name reference data and the value related to the identification destination item held by the name reference data.
store and
The control unit includes:
If the value of the source item in the acquired item combination set held by the received name identification data is the same as that registered in the dictionary data, the identification target item registered in the dictionary data. Dictionary-using name matching execution means that outputs a value related to , and information indicating that the value is registered in the dictionary data, as a name matching result.
Equipped with
The name matching execution means performs the above 1) when the value of the original item in the acquired item combination set held by the received name matching source data is not the same as that registered in the dictionary data. Executing the process of 3) above from
An information processing device characterized by: The storage unit further stores the weighted value in association with the previous item,
The acquisition means further acquires, for each item combination in the acquired item combination set, a weighting value linked to a previous item in the item combination from the storage unit,
The name aggregation executing means multiplies each degree of similarity by each of the obtained weighting values to total each degree of similarity;
The information processing device according to claim 1, characterized in that: The name matching execution means compares the total value with one threshold value or a plurality of mutually different threshold values, and outputs content according to the comparison result as information based on the total value;
The information processing device according to claim 1 or 2, characterized in that: The name matching execution means further outputs, as a name matching result, a value related to a previous item in the acquired item combination set, which is held by the received name matching destination data;
The information processing device according to any one of claims 1 to 3, characterized in that: The storage unit includes:
1) A method combination set including multiple method combinations,
2) A destination item/method combination set that includes a plurality of destination item/method combination sets for each destination data, each containing a destination item/method combination of the destination item and the identification information of the method combination, as many as the number of destination items in the destination data. With the family,
3) an item combination set family containing one or more item combination sets;
4) a first combination set family that includes one or more first combination sets that include one or more combinations of identification information of an item combination set and identification information of a previous item/method combination set;
5) a second combination set including one or more combinations of the identification information of the first combination set and the identification information of the template of the name reference data;
It stores
The acquisition means is
1) obtaining the identification information of the first combination set linked to the identification information of the template in the received name matching source data from the second combination set;
2) acquiring a first combination set specified by the identification information of the acquired first combination set from the first combination set family;
3) Acquire the item combination set specified by the identification information of the item combination set in the acquired first combination set from the item combination set group, and also acquire the previous item/method combination in the acquired first combination set. obtaining a previous item/method combination set specified by the identification information of the set from the previous item/method combination set family;
4) obtaining a method combination linked to a previous item in the obtained item combination set from the obtained previous item/method combination set;
The information processing device according to any one of claims 1 to 4. The control unit includes:
a first setting means for causing an operator to set a method combination via a first setting screen including an area for setting a cleansing method and an area for setting a similarity calculation method;
A second setting including an area for setting the reference data, an area for displaying the destination item in the set reference data, and an area for setting the method combination to be applied to the destination item. a second setting means for causing an operator to set a destination item/method combination set via a screen;
An area for setting the template of the reference data, an area for setting the reference data, an area for setting the destination item/method combination set, and the destination item and setting in the set reference data. The third setting screen, which includes an area for displaying the source items in the template and setting the item combination set, allows the operator to set the item combination set, the source data template, and the destination item. a third setting means for setting the linkage of the method combination set;
further equipping;
The information processing device according to claim 5, characterized in that: The control unit includes:
The name matching execution means specifies a value related to the source item in the acquired item combination set held by the received name matching source data and a value related to the identification destination item held by the received name matching destination data. further comprising a suggestion information output means for outputting information for proposing registration of the specific combination in the dictionary data when the combination is recorded a predetermined number of times or more;
The information processing device according to claim 1 , characterized in that: The source data and destination data are transferred from application software related to ERP (Enterprise Resource Planning).
The output destination is the application software related to the ERP that is the transfer source of the source data and destination data;
The information processing device according to any one of claims 1 to 7 . The name reference data must be the master set in the application software related to ERP,
The information processing device according to claim 8 , characterized in that: The source data must be electronic data that has been digitized by OCR (Optical Character Recognition) or imported externally;
The information processing device according to claim 9 , characterized by: A method combination of a cleansing method and a similarity calculation method is stored in association with a destination item that is an item of the source data, and one or more item combinations of the source item and destination item that are the items of the source data are stored. The item combination set used when performing the name matching is executed by an information processing device equipped with a control unit that can access a storage unit in which a set of item combinations used when performing the name matching is stored in association with a template of the name matching source data having a predetermined pattern or layout. An information processing method comprising:
executed by the control unit,
a receiving step for receiving the reference data and the reference data;
The item combination set linked to the template identification information given to the received name reference data is obtained from the storage unit, and for each item combination in the obtained item combination set, the item combination set is linked to the previous item in the item combination. an acquisition step of acquiring a method combination from the storage unit;
1) For each combination of the item combination in the acquired item combination set and the acquired method combination, 11) The value related to the original item in the item combination held by the received name matching source data and the value of the received item combination. 12) Cleansing processing by the cleansing method in the method combination for the value related to the previous item in the item combination held by the name identification data held by the name matching destination data, and 12) similarity in the method combination for both values after the cleansing process. 2) aggregate each of the obtained similarities, and 3) collect information based on the obtained aggregate value and the name reference data held by the name reference data. a name matching execution step of outputting a value related to an identification destination item that is a destination item for uniquely identifying data as a name matching result;
including, and further,
The storage unit includes:
Dictionary data that is registered by linking the value related to the source item in the item combination set held by the name reference data and the value related to the identification destination item held by the name reference data.
store and
executed by the control unit,
If the value of the source item in the acquired item combination set held by the received name identification data is the same as that registered in the dictionary data, the identification target item registered in the dictionary data. a dictionary-using name matching execution step of outputting, as a name matching result, a value related to , and information indicating that the value is registered in the dictionary data;
including;
In the name matching execution step, if the value of the original item in the acquired item combination set held by the received name matching source data is not the same as the value registered in the dictionary data, the step of performing 1) Executing the process of 3) above from
An information processing method characterized by: A method combination of a cleansing method and a similarity calculation method is stored in association with a destination item that is an item of the source data, and one or more item combinations of the source item and destination item that are the items of the source data are stored. Execute by an information processing device equipped with a control unit that can access a storage unit in which a set of item combinations used when performing name matching that includes multiple items has a predetermined pattern or layout and is stored in association with a template of the name matching source data. It is a program for
for the control unit to execute,
a receiving step for receiving the reference data and the reference data;
The item combination set linked to the template identification information given to the received name reference data is obtained from the storage unit, and for each item combination in the obtained item combination set, the item combination set is linked to the previous item in the item combination. an acquisition step of acquiring a method combination from the storage unit;
1) For each combination of the item combination in the acquired item combination set and the acquired method combination, 11) The value related to the original item in the item combination held by the received name matching source data and the value of the received item combination. 12) Cleansing processing by the cleansing method in the method combination for the value related to the previous item in the item combination held by the name identification data held by the name matching destination data, and 12) similarity in the method combination for both values after the cleansing process. 2) aggregate each of the obtained similarities, and 3) collect information based on the obtained aggregate value and the name reference data held by the name reference data. a name matching execution step of outputting a value related to an identification destination item that is a destination item for uniquely identifying data as a name matching result;
including, and further,
The storage unit is
Dictionary data that is registered by linking the value related to the source item in the item combination set held by the name reference data and the value related to the identification destination item held by the name reference data.
store and
for the control unit to execute,
If the value of the source item in the acquired item combination set held by the received name identification data is the same as that registered in the dictionary data, the identification target item registered in the dictionary data. a dictionary-using name matching execution step of outputting, as a name matching result, a value related to , and information indicating that the value is registered in the dictionary data;
including;
In the name matching execution step, if the value of the original item in the acquired item combination set held by the received name matching source data is not the same as the value registered in the dictionary data, the step of performing 1) Executing the process of 3) above from
A program featuring.

Images