Information processing program, information processing method, and information processing device.

The information processing program and device automate the identification of corresponding records by displaying and highlighting similarity scores, addressing the operational burden of manual record matching in database integration.

JP7886535B2Active Publication Date: 2026-07-08FUJITSU LTD

Patent Information

Authority / Receiving Office
JP · JP
Patent Type
Patents
Current Assignee / Owner
FUJITSU LTD
Filing Date
2022-12-21
Publication Date
2026-07-08

AI Technical Summary

Technical Problem

Existing systems require manual visual checking of similar records across databases, leading to a significant operational burden during data integration and matching processes.

Method used

An information processing program and device that displays similarity scores for records in both databases, allowing automatic identification and highlighting of corresponding records, reducing the need for manual verification.

Benefits of technology

Facilitates efficient identification of corresponding records by displaying and highlighting similarity scores, thereby reducing the workload and improving data matching efficiency.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure 0007886535000001
    Figure 0007886535000001
  • Figure 0007886535000002
    Figure 0007886535000002
  • Figure 0007886535000003
    Figure 0007886535000003
Patent Text Reader

Abstract

To make it possible to efficiently identify a corresponding record.SOLUTION: A storage unit stores first data including a plurality of first records and second data including a plurality of second records. When a first record is selected from the first data, a processing unit causes a display device to display, for each of the plurality of second records, first degrees of similarity between the selected first record and each of the second records. When a second record is selected from the second data after displaying the first degrees of similarity, the processing unit causes the display device to display, for each of the plurality of first records, second degrees of similarity between the selected second record and each of the first records, together with the first degrees of similarity for each second record.SELECTED DRAWING: Figure 17
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to an information processing program, an information processing method, and an information processing apparatus.

Background Art

[0002] The formats of data registered in databases may be different. Therefore, in some cases such as when integrating databases, a matching operation may be performed to identify corresponding records in each database.

[0003] For example, there has been a proposal for a description item association system that displays candidates for description items in a second document to be associated with description items included in a first document with priorities according to the similarity between keywords included in the description items and allows a user to select them. Also, for example, there has been a proposal for a medical information management system that, when the matching ratio of data between patients exceeds a required information matching degree, associates and outputs the medical information of the corresponding patient pairs assuming that the corresponding patient pairs are the same person.

Prior Art Documents

Patent Documents

[0004]

Patent Document 1

Patent Document 2

Summary of the Invention

Problems to be Solved by the Invention

[0005] The matching operator checks each item of the records and selects corresponding records from each database. Therefore, it is conceivable that a computer presents records in another database that are similar to the records selected from one database. However, even when the computer presents similar records, the operator often visually checks whether or not the two are in a corresponding relationship, and the burden on the operator is large.

[0006] In one aspect, the present invention aims to provide an information processing program, an information processing method, and an information processing device that enable efficient identification of corresponding records. [Means for solving the problem]

[0007] In one embodiment, an information processing program is provided. The information processing program causes a computer to perform the following process: when a first record is selected from first data containing multiple first records, the computer displays the first similarity between the selected first record and each of the multiple second records contained in second data containing multiple second records on a display device for each second record; and after the display of the first similarity, when a second record is selected from second data, the computer displays the second similarity between the selected second record and each of the multiple first records, along with the first similarity for each second record, on a display device for each first record.

[0008] In one embodiment, an information processing method is provided. In one embodiment, an information processing device is provided. [Effects of the Invention]

[0009] In one respect, it allows for efficient identification of corresponding records. [Brief explanation of the drawing]

[0010] [Figure 1] This is a diagram illustrating the information processing device of the first embodiment. [Figure 2] This figure shows an example of an information processing system according to the second embodiment. [Figure 3] This diagram shows an example of server hardware. [Figure 4] This figure shows an example of server functionality. [Figure 5] This figure shows an example of a standard master. [Figure 6] This figure shows an example of a company-specific master data. [Figure 7] It is a diagram showing an example of a grouping item selection screen. [Figure 8] It is a diagram (Part 1) showing an example of a similar record search screen. [Figure 9] It is a diagram (Part 2) showing an example of a similar record search screen. [Figure 10] It is a diagram (Part 3) showing an example of a similar record search screen. [Figure 11] It is a diagram (Part 4) showing an example of a similar record search screen. [Figure 12] It is a diagram showing an example of a record pair list display screen. [Figure 13] It is a diagram showing an example of a record detail display screen. [Figure 14] It is a diagram showing an example of screen transition. [Figure 15] It is a flowchart (Part 1) showing an example of server processing. [Figure 16] It is a flowchart (Part 2) showing an example of server processing. [Figure 17] It is a diagram explaining grouping work support by server processing. [Figure 18] It is a diagram showing an example of a code conversion table.

Mode for Carrying Out the Invention

[0011] Hereinafter, this embodiment will be described with reference to the drawings. [First Embodiment] The first embodiment will be described.

[0012] FIG. 1 is a diagram for explaining an information processing apparatus according to the first embodiment. The information processing apparatus 10 is connected to the display device 20. The information processing apparatus 10 supports the user's grouping work by the screen display of the display device 20. Note that the display device 20 may be a display connected to the information processing apparatus 10 or the like, or a display connected to a device that communicates with the information processing apparatus 10 via a network or the like. The information processing apparatus 10 has a storage unit 11 and a processing unit 12.

[0013] The memory unit 11 may be a volatile memory device such as RAM (Random Access Memory), or a non-volatile memory device such as an HDD (Hard Disk Drive) or flash memory. The processing unit 12 may include a CPU (Central Processing Unit), a DSP (Digital Signal Processor), an ASIC (Application Specific Integrated Circuit), an FPGA (Field Programmable Gate Array), etc. The processing unit 12 may also be a processor that executes programs. "Processor" may include a collection of multiple processors (multiprocessor).

[0014] The storage unit 11 stores first data 11a and second data 11b. First data 11a and second data 11b are databases in which information for each item related to a company or an individual is registered. The items in first data 11a and second data 11b may be the same or different. First data 11a contains multiple first records. Each of the multiple first records records information for each item in first data 11a. For example, first data 11a contains first records with record names "X1", "X2", and "X3". Second data 11b contains multiple second records. Each of the multiple second records records information corresponding to each item in second data 11b. For example, second data 11b contains second records with record names "Y1", "Y2", and "Y3".

[0015] The processing unit 12 accepts the selection of the first record from the first data 11a. For example, the processing unit 12 displays screen 21 on the display device 20. Screen 21 includes record names "X1", "X2", "X3", and checkboxes corresponding to each record name. When the processing unit 12 accepts the selection operation of any checkbox, it accepts the selection of the first record corresponding to the selected checkbox. Here, it is assumed that the first record with record name "X1" has been selected.

[0016] When the first record from the first data 11a is selected, the processing unit 12 calculates the first similarity scores 22a, 22b, and 22c between the selected first record and each of the multiple second records contained in the second data 11b. As an example of similarity calculation, the processing unit 12 first accepts the selection of items from the first data 11a and the second data 11b from the user. The processing unit 12 calculates the similarity by comparing the selected items between the first record with the record name "X1" and each of the multiple second records. For example, if each selected item contains text such as a company name or address, the processing unit 12 calculates a similarity score that indicates the degree of text matching.

[0017] Here, let's assume that the first similarity score 22a between the first record with record name "X1" and the second record with record name "Y1" is calculated to be "90". Let's also assume that the first similarity score 22b between the first record with record name "X1" and the second record with record name "Y2" is calculated to be "20". Let's also assume that the first similarity score 22c between the first record with record name "X1" and the second record with record name "Y3" is calculated to be "50". The processing unit 12 displays the first similarity scores 22a, 22b, and 22c on the display device 20 for each second record. For example, the processing unit 12 displays screen 22 on the display device 20, which has the first similarity scores 22a, 22b, and 22c added to screen 21.

[0018] Screen 22 includes the record names "Y1", "Y2", and "Y3", as well as the corresponding first similarity scores 22a, 22b, and 22c for each record name. In Screen 22, the record names and their corresponding first similarity scores are arranged so that the higher the first similarity score, the higher the score. Screen 22 also includes checkboxes corresponding to each of the record names "Y1", "Y2", and "Y3".

[0019] After displaying the first similarity values ​​22a, 22b, and 22c, the processing unit 12 accepts the selection of the second record from the second data 11b. For example, when the processing unit 12 receives a selection operation for one of the checkboxes corresponding to the record names "Y1", "Y2", or "Y3" on screen 22, it accepts the selection of the second record corresponding to the selected checkbox. Here, let's assume that the second record with the record name "Y1" has been selected.

[0020] When the second record from the second data 11b is selected, the processing unit 12 calculates the second similarity scores 23a, 23b, and 23c between the selected second record and each of the multiple first records. For example, the processing unit 12 calculates the second similarity scores 23a, 23b, and 23c between the second record with the record name "Y1" and each of the multiple first records using the same calculation method used to calculate the first similarity scores 22a, 22b, and 22c.

[0021] Here, let's assume that the second similarity score 23a between the second record of record name "Y1" and the first record of record name "X1" is calculated to be "90". Also, let's assume that the second similarity score 23b between the second record of record name "Y1" and the first record of record name "X2" is calculated to be "30". Furthermore, let's assume that the second similarity score 23c between the second record of record name "Y1" and the first record of record name "X3" is calculated to be "60".

[0022] The processing unit 12 displays the second similarity values ​​23a, 23b, and 23c, along with the first similarity values ​​22a, 22b, and 22c for each second record, on the display device 20 for each first record. Here, the processing unit 12 highlights the first record selected when displaying the first similarity values ​​22a, 22b, and 22c. For example, the processing unit 12 displays screen 23 on the display device 20, which has the second similarity values ​​23a, 23b, and 23c added to screen 22.

[0023] Screen 23 includes the record names "X1", "X2", and "X3", as well as the corresponding second similarity scores 23a, 23b, and 23c for each record name. In Screen 23, the record names and their corresponding second similarity scores are arranged so that the higher the second similarity score, the higher the score. Additionally, in Screen 23, the record name "X1" and its corresponding second similarity score 23a are highlighted by being enclosed in a frame.

[0024] After the first similarity scores 22a, 22b, and 22c are displayed, if a pair of a first record and a second record is selected, the processing unit 12 stores information indicating the pair in the storage unit 11. For example, the processing unit 12 stores information in the storage unit 11 indicating that the first record selected on screen 21 and the second record selected on screen 22 are a pair. In other words, the processing unit 12 stores information in the storage unit 11 indicating that the first record with record name "X1" and the second record with record name "Y1" are a pair.

[0025] The processing unit 12 repeats the above process until it receives input indicating that it has completed the selection of pairs for multiple first records and multiple second records. When the processing unit 12 receives input indicating that it has completed the selection of pairs, it identifies the first and second records included in the pair stored in the storage unit 11. The processing unit 12 then outputs information indicating the correspondence between the information of the first data item included in the identified first record and the information of the second data item included in the identified second record. For example, the processing unit 12 stores a table indicating the correspondence between the information of the first data item and the information of the second data item in the storage unit 11.

[0026] The first data item is, for example, a key item among the items of the first data 11a used to search for the first record from the first data 11a. The second data item is, for example, a key item among the items of the second data 11b used to search for the first record from the second data 11b.

[0027] According to the information processing device 10, the storage unit 11 stores first data 11a containing a plurality of first records and second data 11b containing a plurality of second records. When the first record from the first data 11a is selected by the processing unit 12, it displays the first similarity scores 22a, 22b, and 22c between the selected first record and each of the plurality of second records on the display device 20 for each second record. After the display of the first similarity scores 22a, 22b, and 22c, the second record from the second data 11b is selected. Then, the processing unit 12 displays the second similarity scores 23a, 23b, and 23c between the selected second record and each of the plurality of first records, along with the first similarity scores 22a, 22b, and 22c for each second record, on the display device 20 for each first record.

[0028] This allows the information processing device 10 to allow the user performing the data matching operation between the first data 11a and the second data 11b to confirm the first similarity 22a, 22b, 22c and the second similarity 23a, 23b, 23c. By confirming the first similarity 22a, 22b, 22c, the user can select the second record from among multiple second records that is most likely to correspond to the first record. In this way, the information processing device 10 enables the user to efficiently identify the corresponding record.

[0029] Subsequently, the information processing device 10 displays the second similarity values ​​23a, 23b, and 23c along with the first similarity values ​​22a, 22b, and 22c on the display device 20. This allows the user to confirm whether the selected first record is likely to correspond to the second record among multiple first records. Thus, the user can determine whether the selected first record and the selected second record correspond to each other without having to check the details of the selected first record and the selected second record. Therefore, the information processing device 10 can reduce the workload in data matching.

[0030] Furthermore, when displaying the second similarity scores 23a, 23b, and 23c, the processing unit 12 highlights the first record that was selected when displaying the first similarity scores 22a, 22b, and 22c. This makes it easier for the user to confirm the second similarity between the selected second record and the selected first record.

[0031] Furthermore, after displaying the first similarity scores 22a, 22b, and 22c, the processing unit 12 stores information indicating the pair in the storage unit 11 if a pair of the first and second records is selected. This allows the information processing device 10 to save the name matching results performed by the user.

[0032] Furthermore, when the processing unit 12 receives input indicating that it has completed the selection of pairs for a plurality of first records and a plurality of second records, it identifies the first and second records included in the pair stored in the storage unit 11. Then, the processing unit 12 outputs information showing the correspondence between the information of the first data item included in the identified first record and the information of the second data item included in the identified second record. This allows the information processing device 10 to use an item from one of the first data 11a and the second data 11b to retrieve the corresponding data from the other. Thus, the information processing device 10 can improve the usability of the data.

[0033] The functions of the information processing device 10 will be described in more detail below. [Second Embodiment] Next, a second embodiment will be described.

[0034] Figure 2 shows an example of an information processing system according to the second embodiment. The information processing system of the second embodiment includes a user terminal 41 and a server 100. The server 100 is a server computer that manages a standard master containing information about multiple companies. The standard master is a table that manages standardized data items for multiple companies. The standard master is included in the database managed by the server 100. The server 100 accepts uploads of individual company masters from the user terminal 41. The individual company master is a table that manages data items defined for each individual company. The individual company master is included in the database managed by the server computer operated by each individual company. Note that the server computers operated by each individual company are omitted in Figure 2. The server 100 then sends screen information to the user terminal 41 to support the data matching work performed by the user operating the user terminal 41, which involves matching records in the individual company master with records in the standard master.

[0035] Server 100 is an example of the information processing device 10 of the first embodiment. Server 100 and user terminal 41 are connected to a network 30. Network 30 is, for example, a WAN (Wide Area Network) or the Internet. Server 100 supports smooth data exchange between companies by holding a standard master.

[0036] The user terminal 41 is a client computer operated by the user. The user terminal 41 may also be remotely controlled from another computer operated by the user. For example, the user terminal 41 displays a screen based on screen information obtained from the server 100, using a browser.

[0037] Figure 3 shows an example of server hardware. The server 100 includes a CPU 101, RAM 102, HDD 103, GPU (Graphics Processing Unit) 104, input interface 105, media reader 106, and NIC (Network Interface Card) 107. Note that the CPU 101 is an example of the processing unit 12 in the first embodiment. The RAM 102 or HDD 103 is an example of the storage unit 11 in the first embodiment.

[0038] The CPU 101 is a processor that executes program instructions. The CPU 101 loads at least a portion of the programs and data stored in the HDD 103 into the RAM 102 and executes the program. The CPU 101 may include multiple processor cores. The server 100 may also have multiple processors. The processes described below may be executed in parallel using multiple processors or processor cores. A collection of multiple processors is sometimes referred to as a "multiprocessor" or simply a "processor."

[0039] RAM102 is a volatile semiconductor memory that temporarily stores programs executed by CPU101 and data used by CPU101 for calculations. Server 100 may also be equipped with other types of memory, and may have multiple memory modules.

[0040] HDD103 is a non-volatile storage device that stores software programs such as the OS (Operating System), middleware, and application software, as well as data. Server 100 may also be equipped with other types of storage devices such as flash memory or SSDs (Solid State Drives), and may have multiple non-volatile storage devices.

[0041] The GPU 104 outputs an image to the display 31 connected to the server 100, according to instructions from the CPU 101. Any type of display can be used as the display 31, such as a CRT (Cathode Ray Tube) display, an LCD (Liquid Crystal Display), a plasma display, or an OLED (Organic Electro-Luminescence) display.

[0042] The input interface 105 acquires input signals from the input device 32 connected to the server 100 and outputs them to the CPU 101. The input device 32 can be a pointing device such as a mouse, touch panel, touchpad, or trackball, as well as a keyboard, remote controller, or button switch. Furthermore, multiple types of input devices may be connected to the server 100.

[0043] The media reader 106 is a reading device that reads programs and data recorded on the recording medium 33. The recording medium 33 can be, for example, a magnetic disk, an optical disk, a magneto-optical disk (MO), or semiconductor memory. Magnetic disks include flexible disks (FD) and HDDs. Optical disks include CDs (Compact Discs) and DVDs (Digital Versatile Discs).

[0044] The media reader 106 copies programs and data read from the recording medium 33 to other recording media such as RAM 102 or HDD 103. The read programs are executed by the CPU 101, for example. The recording medium 33 may be a portable recording medium and may be used for distributing programs and data. The recording medium 33 and HDD 103 are sometimes referred to as computer-readable recording media.

[0045] NIC107 is an interface connected to network 30 and used to communicate with other computers, including user terminals 41, via network 30. NIC107 is connected to communication devices such as switches or routers via cables, for example. NIC107 may also be connected to communication devices wirelessly.

[0046] The user terminal 41 is also implemented using the same hardware as the server 100. The display on the user terminal 41 is an example of the display device 20 of the first embodiment. Figure 4 shows an example of server functionality.

[0047] The server 100 includes a storage unit 110, a screen display control unit 120, a similarity calculation unit 130, and a conversion table output unit 140. The storage unit 110 uses the storage area of ​​RAM 102 or HDD 103. The screen display control unit 120, the similarity calculation unit 130, and the conversion table output unit 140 are realized by the CPU 101 executing a program stored in RAM 102.

[0048] The storage unit 110 stores the standard master data managed by the server 100 and the individual company master data uploaded by the user terminal 41. The screen display control unit 120 controls the display of the GUI (Graphical User Interface) by the user terminal 41 and the input from the user terminal 41 via the GUI. The screen display control unit 120 transmits screen information to the user terminal 41 to support the data matching process and displays the screen on the user terminal 41's display. In the following, transmitting screen information to the user terminal 41 to display a certain screen and displaying that screen on the user terminal 41's display may simply be referred to as "displaying the screen on the user terminal 41."

[0049] The screen display control unit 120 accepts the selection of conditions for the data matching process. For example, the screen display control unit 120 accepts the selection of items from the individual company master and the standard master (conversion items from the individual company master and conversion items from the standard master) to be associated by data matching. Also, for example, the screen display control unit 120 accepts the selection of the similarity calculation method to be used for similarity calculation and the combination of items from the individual company master (matching items from the individual company master) and items from the standard master (matching items from the standard master) to be compared in the similarity calculation.

[0050] The screen display control unit 120 displays records from the company master on the user terminal 41. The screen display control unit 120 accepts the selection of a company master record (source record for matching) from among the displayed company master records to be matched by name matching.

[0051] When the screen display control unit 120 receives a selection of a source record for data matching, it displays the similarity of each record in the standard master to the source record on the user terminal 41. The screen display control unit 120 then receives a selection of a destination record from the displayed standard master records to be associated with the source record for data matching.

[0052] When the screen display control unit 120 receives a selection of a record to be matched, it highlights the source record and displays the degree of similarity between each record in the individual company master and the target record on the user terminal 41.

[0053] The similarity calculation unit 130 calculates the similarity between each record in the standard master and the source record for data matching, and between each record in the individual company master and the target record for data matching. For example, in calculating the similarity between each record in the standard master and the source record for data matching, the similarity calculation unit 130 calculates a similarity index that shows the degree of agreement between the text registered in the matching field of the source record and the text registered in the matching field of the standard master record. Here, the similarity calculation unit 130 may calculate the similarity by first converting predetermined words contained in the text to other words and then comparing the text registered in the matching field. The dictionary used for word conversion may differ depending on the similarity calculation method accepted by the screen display control unit 120. In addition, the similarity calculation unit 130 may calculate the similarity between the source record and each record included in the standard master by a relative evaluation between the source record and each record on the standard master. For example, the similarity calculation unit 130 may calculate the similarity based on the total number of records included in the standard master and the number of records in the standard master that are similar to the source record.

[0054] The conversion table output unit 140 stores information in the storage unit 110 indicating that the source record and the target record are a pair. The conversion table output unit 140 then outputs a code conversion table showing the correspondence between the matching items of the paired records.

[0055] Figure 5 shows an example of a standard master. The standard master 111 is stored in the storage unit 110 in advance. The standard master 111 includes the fields for company name, standard corporate code, and address. The company name field registers the name of the company. The standard corporate code field registers the ID of the company in the standard master 111. The address field registers the address of the company.

[0056] For example, standard master 111 contains a record where the company name field is "A Corporation", the standard corporate code field is "99999", and the address field is "Tokyo...". This record indicates that the company ID in standard master 111 for a company named "A Corporation" is "99999" and its address is "Tokyo...".

[0057] Figure 6 shows an example of a company-specific master data. The individual company master 112 is uploaded from the user terminal 41 to the storage unit 110 during the data matching process. The individual company master 112 includes fields for ID, company name, corporate number, and address. The ID field registers the ID of the record in the individual company master 112. The company name field registers the name of the company. The corporate number field registers the corporate number of the company. The address field registers the address of the company.

[0058] For example, in the individual company master 112, there is a record with ID "1" where the ID field is "1", the company name field is "A (Co., Ltd.)", the corporate number field is "12345", and the address field is "Tokyo...". The record with ID "1" indicates that the company name is "A (Co., Ltd.)", the corporate number is "12345", and the address is "Tokyo...".

[0059] Next, we will describe the screen that the screen display control unit 120 displays on the user terminal 41. Figure 7 shows an example of the data matching item selection screen. The data matching item selection screen 200 is a screen that allows the user to select settings for data matching support provided by the server 100. The screen display control unit 120 displays the data matching item selection screen 200 on the user terminal 41 in response to a connection from the user terminal 41. The data matching item selection screen 200 includes a calculation method pull-down 201, a company master display area 202, a standard master display area 203, a matching item display area 204, and conversion item display areas 205, 206.

[0060] The calculation method dropdown 201 is a dropdown menu that accepts the selection of a calculation method for the similarity between records in the standard master 111 and records in the individual company master 112. The screen display control unit 120 receives notification of the calculation method selected in the calculation method dropdown 201 from the user terminal 41.

[0061] The individual company master display area 202 is an area where sample records from the individual company master 112 are displayed. When the user terminal 41 receives a press of the "Individual Company Master Upload" button on the data matching item selection screen 200, it uploads the individual company master 112 to the server 100. Then, the screen display control unit 120 displays sample records from the individual company master 112 in the individual company master display area 202. For example, the individual company master display area 202 displays information for each item in the individual company master 112 and for each item registered in the record with ID "1" in the individual company master 112.

[0062] The standard master display area 203 is an area where sample records from the standard master 111 are displayed. When the user terminal 41 selects the standard master 111 from the standard master selection dropdown, it requests the server 100 to display sample records from the standard master 111. The screen display control unit 120 then displays sample records from the standard master 111 in the standard master display area 203. For example, the standard master display area 203 displays information for each item in the standard master 111 and for each item registered in the record where the company name item in the standard master 111 is "A Corporation".

[0063] The matching item display area 204 is an area that displays combinations of matching items that are compared in the calculation of similarity between records in the standard master 111 and records in the individual company master 112. When the user terminal 41 receives a press of the add button included in the matching item display area 204, it prompts the user to select one item each from the individual company master 112 and the standard master 111. The user terminal 41 notifies the server 100 of the selected items as a combination of matching items. The screen display control unit 120 displays the notified combinations of matching items side by side in the matching item display area 204. For example, the company name item from the individual company master 112 and the corporate name item from the standard master 111 are displayed side by side in the matching item display area 204. Also, the address item from the individual company master 112 and the location item from the standard master 111 are displayed side by side in the matching item display area 204.

[0064] The conversion item display area 205 is the area where the conversion items of the individual company master 112 are displayed. The user terminal 41 accepts the selection of one item from the items of the individual company master 112 displayed in the individual company master display area 202. The user terminal 41 notifies the server 100 of the selected item as a conversion item of the individual company master 112. The screen display control unit 120 displays the notified conversion item of the individual company master in the conversion item display area 205. For example, the corporate number item of the individual company master 112 is displayed in the conversion item display area 205.

[0065] The conversion item display area 206 is the area where the conversion items of the standard master 111 are displayed. The user terminal 41 accepts the selection of one item from the items of the standard master 111 displayed in the standard master display area 203. The user terminal 41 notifies the server 100 of the selected item as a conversion item of the standard master 111. The screen display control unit 120 displays the notified conversion item of the standard master 111 in the conversion item display area 206. For example, the standard corporate code item of the standard master 111 is displayed in the conversion item display area 206.

[0066] Furthermore, the data matching item selection screen 200 includes a "Execute Data Matching" button. When the screen display control unit 120 is notified by the user terminal 41 that the "Execute Data Matching" button has been pressed, it displays the following screen on the user terminal 41. The screen display control unit 120 may accept the selection of the similarity calculation method, matching items, and conversion items from the user terminal 41 when each of the similarity calculation method, matching items, and conversion items has been selected, or it may accept the selection when the "Execute Data Matching" button is pressed.

[0067] Figure 8 is an example (part 1) of the similar record search screen. The Similar Record Search screen 300 is a screen that assists with the data matching process. When the screen display control unit 120 receives notification from the user terminal 41 that the "Execute Data Matching" button on the Data Matching Item Selection screen 200 has been pressed, it displays the Similar Record Search screen 300 on the user terminal 41. The Similar Record Search screen 300 shown in Figure 8 includes a pull-down menu for setting the number of records to display and a company master record display area 301. For example, the Similar Record Search screen 300 is set to display 10 records.

[0068] The individual company master record display area 301 is the area where the user selects the source record for data matching. For each record in the individual company master 112, the individual company master record display area 301 displays information on matching items, conversion items, and checkboxes. For example, the individual company master record display area 301 displays information on company name, corporate number, and address for each record in the individual company master 112.

[0069] When the user terminal 41 receives a selection of a checkbox in the individual company master record display area 301, it notifies the server 100 of the record corresponding to the selected checkbox. The screen display control unit 120 receives the notified record as the source record for data matching.

[0070] Furthermore, the individual company master record display area 301 includes a "Display Standard Master Record for Data Matching" button. When the screen display control unit 120 receives notification from the user terminal 41 that the "Display Standard Master Record for Data Matching" button has been pressed, it instructs the similarity calculation unit 130 to calculate the similarity between the source record for data matching and the record in the standard master 111. The similarity calculation unit 130 calculates the similarity between the source record for data matching and the record in the standard master 111 based on the combination of similarity calculation method and matching items selected on the data matching item selection screen 200. The screen display control unit 120 then displays the similarity between the source record for data matching and the record in the standard master 111 on the similar record search screen 300.

[0071] Figure 9 is a diagram (part 2) showing an example of the similar record search screen. When the user terminal 41 notifies the screen display control unit 120 that the "Display Standard Master Record for Data Matching" button has been pressed, it adds the standard master record display area 302 to the similar record search screen 300. The screen display control unit 120 also adds the "Confirm Selected Record Pair Details" button and the "Display Record Pair List" button to the similar record search screen 300.

[0072] The standard master record display area 302 is an area that displays the similarity of each record in the standard master 111 to the source record for data matching and accepts the selection of the target record for data matching. In the standard master record display area 302, information on matching items, information on conversion items, similarity (score) to the source record for data matching, an edit button, and a checkbox are displayed for each record in the standard master 111. Note that the information for each record in the standard master record display area 302 is arranged so that the information of records with a high similarity to the source record is placed at the top.

[0073] For example, the standard master record display area 302 displays information for each record in the standard master 111, including the company name, standard corporate code, and address. Additionally, the standard master record display area 302 also displays a similarity score between 0 and 100 for each record in the standard master 111, based on the source record used for data matching.

[0074] When the user terminal 41 receives a selection of a checkbox in the standard master record display area 302, it notifies the server 100 of the record corresponding to the selected checkbox. The screen display control unit 120 accepts the notified record as the record to be matched. Furthermore, when the user terminal 41 receives a press of the edit button, it accepts a request to re-select the record to be matched.

[0075] Furthermore, the standard master record display area 302 includes a "Display Source Company Master Record" button. When the screen display control unit 120 receives notification from the user terminal 41 that the "Display Source Company Master Record" button has been pressed, it instructs the similarity calculation unit 130 to calculate the similarity between the target record and the record in the company master 112. The similarity calculation unit 130 calculates the similarity between the target record and the record in the company master 112 based on the combination of similarity calculation method and matching items selected on the matching item selection screen 200. The screen display control unit 120 then displays the similarity between the target record and the record in the company master 112 on the similar record search screen 300. The screen display control unit 120 may also accept the selection of the target record when the "Display Source Company Master Record" button is pressed.

[0076] When the user terminal 41 notifies the screen display control unit 120 that the "Confirm Selected Record Pair Details" button has been pressed, it displays a screen on the user terminal 41 for confirming the details of the source record and the target record for data matching. Furthermore, when the user terminal 41 notifies the screen display control unit 120 that the "Display Record Pair List" button has been pressed, it displays a list of the pairs selected as the source and target records for data matching on the user terminal 41. Additionally, when the user terminal 41 notifies the conversion table output unit 140 that either the "Confirm Selected Record Pair Details" button or the "Display Record Pair List" button has been pressed, it stores information indicating that the source record and the target record are a pair in the storage unit 110.

[0077] Figure 10 is a diagram (part 3) showing an example of the similar record search screen. When the screen display control unit 120 receives notification from the user terminal 41 that the "Display Source Company Master Record" button has been pressed, it adds the company master record display area 303 to the similar record search screen 300.

[0078] The individual company master record display area 303 is an area that displays the similarity of each record in the individual company master 112 to the target record for data matching. In the individual company master record display area 303, information on matching items, information on conversion items, and the similarity (score) with the target record for each record in the individual company master 112 are displayed. The information for each record in the individual company master 112 displayed in the individual company master record display area 303 is arranged so that the information of records with a high similarity to the target record is placed at the top. In addition, among the information for each record in the individual company master 112 displayed in the individual company master record display area 303, the information of the source record for data matching is displayed in emphasis.

[0079] For example, the individual company master record display area 303 displays information for each record in the individual company master 112, including the company name, corporate number, and address. Additionally, the individual company master record display area 303 displays a similarity score between 0 and 100 for each record in the individual company master 112. Furthermore, the information of the source records displayed in the individual company master record display area 303 is highlighted in a conspicuous color.

[0080] Furthermore, the similarity of each record in the individual company master 112 may be calculated based on the total number of records in the individual company master 112 and the ranking of the individual company master 112 records that are similar to the target record. Similarly, the similarity of each record in the standard master 111 displayed in the standard master record display area 302 may be calculated based on the total number of records in the standard master 111 and the ranking of the standard master 111 records that are similar to the source record. Therefore, the similarity between the source record and the target record displayed in the standard master record display area 302 may differ from the similarity between the source record and the target record displayed in the individual company master record display area 303.

[0081] Next, we will explain the case where, after the source record and destination record for matching are selected on the similar record search screen 300, a different similarity calculation method (another calculation method) is selected than the one used to display the similar record search screen 300.

[0082] Figure 11 is an example (part 4) of the similar record search screen. The similar record search screen 300 shown in Figure 11 displays records from the standard master 111 and the individual company master 112 based on the similarity calculated by other calculation methods and the target record selected in the similar record search screen 300 shown in Figures 8-10. For example, after the source record and target record for matching are selected as shown in Figures 8-10, the screen display control unit 120 displays the similar record search screen 300 shown in Figure 11 on the user terminal 41 when another similarity calculation method is selected in the matching item selection screen 200. Note that the calculation method pulldown 201 may also be included in the similar record search screen 300. In the individual company master record display area 301 of the similar record search screen 300 shown in Figure 11, it is assumed that the same source record for matching as in the similar record search screen 300 is selected.

[0083] In the standard master record display area 302 shown in Figure 11, the similarity of each record in the standard master 111 is displayed, calculated using other methods with respect to the source record. In addition, the information for each record in the standard master 111 displayed in the standard master record display area 302 shown in Figure 11 is arranged so that the information for records with a higher similarity calculated using other methods is placed higher up. Furthermore, among the information for each record in the standard master 111 displayed in the standard master record display area 302 shown in Figure 11, the information for the target record selected in the similar record search screen 300 shown in Figures 8-10 is highlighted.

[0084] In the individual company master record display area 303 shown in Figure 11, the similarity of each record in the individual company master 112 is displayed, calculated using a different method than the standard master record display area 302 shown in Figure 11. Furthermore, the information for each record in the individual company master 112 displayed in the individual company master record display area 303 shown in Figure 11 is arranged so that the information for records with a higher similarity calculated using the other method than the standard master record display area is placed higher up. In addition, among the information for each record in the individual company master 112 displayed in the individual company master record display area 303 shown in Figure 11, the information for the source record selected in the individual company master record display area 301 shown in Figure 11 is highlighted.

[0085] Figure 12 shows an example of the record pair list display screen. The record pair list display screen 400 is a screen that displays a list of records selected as pairs of source records and destination records for data matching. When the screen display control unit 120 receives notification from the user terminal 41 that the "Display Record Pair List" button on the similar record search screen 300 has been pressed, it displays the record pair list display screen 400 on the user terminal 41. The record pair list display screen 400 includes a company master record display area 401 and a standard master record display area 402.

[0086] The individual company master record display area 401 displays matching item information and conversion item information for each record in the individual company master 112. For example, the individual company master record display area 401 displays information for the company name, corporate number, and address for each record in the individual company master 112. The user terminal 41 accepts the selection of a record displayed in the individual company master record display area 401. When the screen display control unit 120 receives notification from the user terminal 41 that it has accepted the selection of a record displayed in the individual company master record display area 401, it displays a screen on the user terminal 41 to confirm the details of that record and the record to which that record is deduplication is performed.

[0087] The standard master record display area 402 displays information about the standard master 111 records, which are the matching target records for each individual company master 112 record displayed in the individual company master record display area 401. The standard master record display area 402 displays information about matching items and conversion items for each record in the standard master 111. For example, the standard master record display area 402 displays information about the company name, standard corporate code, and address for each record in the standard master 111.

[0088] In the standard master record display area 402, information about the matching record for each record is placed next to the information of each record in the individual company master 112 displayed in the individual company master record display area 401. Note that next to the information of a record in the individual company master 112 for which there is no matching record, a message indicating that there is no matching record, such as "No matching records found," may be displayed.

[0089] The record pair list display screen 400 also includes a "Conversion Table Output" button. When the screen display control unit 120 receives notification from the user terminal 41 that the "Conversion Table Output" button has been pressed, it causes the conversion table output unit 140 to generate a code conversion table showing the correspondence between the conversion items of the source record and the conversion items of the target record. The conversion table output unit 140 generates the code conversion table and stores it in the storage unit 110.

[0090] Figure 13 shows an example of the record details display screen. The record details display screen 500 is a screen that displays the details of a pair of records, specifically the source record and the destination record for data matching. When the screen display control unit 120 receives notification from the user terminal 41 that the "Confirm Selected Record Pair Details" button on the similar record search screen 300 has been pressed, it displays the record details display screen 500 on the user terminal 41. The screen display control unit 120 also receives notification from the user terminal 41 that it has accepted the selection of a record displayed in the individual company master record display area 401 of the record pair list display screen 400, and it displays the record details display screen 500 on the user terminal 41. The record details display screen 500 includes a conversion item display area 501, a source record display area 502, and a destination record display area 503.

[0091] The conversion item display area 501 displays information on the conversion items for both the source record and the target record. The source record display area 502 displays information on each item in the individual company master 112 and each item registered in the source record. The target record display area 503 displays information on each item in the standard master 111 and each item registered in the target record.

[0092] The record details display screen 500 also includes a "Conversion Table Output" button. When the screen display control unit 120 receives notification from the user terminal 41 that the "Conversion Table Output" button has been pressed, it causes the conversion table output unit 140 to generate a code conversion table showing the correspondence between the conversion items of the source record and the conversion items of the target record. The conversion table output unit 140 generates the code conversion table and stores it in the storage unit 110.

[0093] Figure 14 shows an example of screen transitions. The screen display control unit 120 displays the matching item selection screen 200, the similar record search screen 300, the record pair list display screen 400, and the record details display screen 500 on the user terminal 41.

[0094] First, the screen display control unit 120 displays the data matching item selection screen 200 on the user terminal 41 in response to a connection from the user terminal 41. When the screen display control unit 120 is notified that the "Execute Data Matching" button has been pressed from the user terminal 41 displaying the data matching item selection screen 200 (i.e., a pair search is requested), it displays the similar record search screen 300 on the user terminal 41.

[0095] When the user terminal 41 displaying the Similar Record Search screen 300 requests to return to the Matching Item Selection screen 200 (i.e., when a change in the similarity calculation method is requested), the screen display control unit 120 displays the Matching Item Selection screen 200 on the user terminal 41. Furthermore, when the user terminal 41 displaying the Similar Record Search screen 300 is notified that the "Display Record Pair List" button has been pressed, the screen display control unit 120 displays the Record Pair List display screen 400 on the user terminal 41. Additionally, when the user terminal 41 displaying the Similar Record Search screen 300 is notified that the "Confirm Selected Record Pair Details" button has been pressed, the screen display control unit 120 displays the Record Details display screen 500 on the user terminal 41.

[0096] When the screen display control unit 120 receives notification from the user terminal 41, which is displaying the record pair list display screen 400, that it has received notification that a record displayed in the individual company master record display area 401 has been selected, it displays the record details display screen 500 on the user terminal 41.

[0097] Next, we will explain the processing procedure for server 100. Figure 15 is a flowchart (part 1) showing an example of server processing. (S11) The screen display control unit 120 displays the name matching item selection screen 200 on the user terminal 41.

[0098] (S12) The screen display control unit 120 acquires the company master 112. Specifically, the screen display control unit 120 acquires the company master 112 uploaded by the user terminal 41 to the server 100 and stores it in the storage unit 110. Then, the screen display control unit 120 displays a sample of the record from the company master 112 in the company master display area 202 of the name matching item selection screen 200.

[0099] (S13) The screen display control unit 120 accepts the selection of a standard master. When the screen display control unit 120 receives notification from the user terminal 41 that the standard master 111 has been selected, it displays a sample of the record from the standard master 111 in the standard master display area 203 of the name matching item selection screen 200.

[0100] (S14) The screen display control unit 120 accepts the selection of conversion items from the standard master 111 and the individual company master 112. Specifically, the screen display control unit 120 receives notification from the user terminal 41 of the conversion items from the standard master 111 and the individual company master 112 selected on the data matching item selection screen 200. The screen display control unit 120 then displays the conversion items from the individual company master 112 in the conversion item display area 205 of the data matching item selection screen 200. The screen display control unit 120 also displays the conversion items from the standard master 111 in the conversion item display area 206 of the data matching item selection screen 200.

[0101] (S15) The screen display control unit 120 accepts the selection of matching items from the standard master 111 and the individual company master 112. Specifically, the screen display control unit 120 receives notification from the user terminal 41 of the combination of matching items selected on the matching item selection screen 200. The screen display control unit 120 displays the notified combination of matching items in the matching item display area 204.

[0102] (S16) The screen display control unit 120 accepts the selection of a similarity calculation method. Specifically, the screen display control unit 120 receives notification from the user terminal 41 of the similarity calculation method selected on the name matching item selection screen 200.

[0103] The steps S14 to S16 described above may be executed in any order. In other words, the screen display control unit 120 may accept the selection of conversion items, matching items, and similarity calculation method in any order. Alternatively, the screen display control unit 120 may accept the selection of conversion items, matching items, and similarity calculation method all at once.

[0104] (S17) The screen display control unit 120 displays the records of the individual company master 112 on the user terminal 41. Specifically, when the screen display control unit 120 is notified by the user terminal 41 that the "Execute Matching" button on the matching item selection screen 200 has been pressed, it displays the similar record search screen 300 on the user terminal 41. The screen display control unit 120 then displays the matching item information and the conversion item information for each record of the individual company master 112 in the individual company master record display area 301 of the similar record search screen 300.

[0105] (S18) The screen display control unit 120 accepts the selection of the source record for data matching. Specifically, the screen display control unit 120 receives notification from the user terminal 41 of the source record for data matching selected on the similar record search screen 300.

[0106] (S19) The similarity calculation unit 130 calculates the similarity between the source record selected in step S18 and the record in the standard master 111. Here, the similarity calculation unit 130 calculates the similarity between the source record and the record in the standard master 111 based on the matching items selected in step S15 and the similarity calculation method selected in step S16.

[0107] For example, the similarity calculation unit 130 calculates, as the similarity, an index indicating the degree of match between the text registered in the matching item of the grouping source record and the text registered in the matching item of the record in the standard master 111. Here, the similarity calculation unit 130 may convert a predetermined word included in the text into another word (for example, after converting “(Inc.)” into “Limited Company”), and then compare the texts registered in the matching items to calculate the similarity. The dictionary used for word conversion may be different for each similarity calculation method. Also, the similarity calculation unit 130 may calculate the similarity based on the total number of records included in the standard master 111 and the position among the records in the standard master 111 where the record is similar to the grouping source record. Then, the similarity calculation unit 130 proceeds to the process in step S20.

[0108] FIG. 16 is a flowchart (part 2) showing a processing example of the server. (S20) The similarity calculation unit 130 determines whether there is a similarity calculation (already executed similarity calculation) between the grouping source record and each record in the standard master 111 that is executed based on a similarity calculation method different from the similarity calculation method for which the selection was received in step S16. If there is an already executed similarity calculation, the similarity calculation unit 130 proceeds to the process in step S22. Also, if there is no already executed similarity calculation, the similarity calculation unit 130 proceeds to the process in step S21.

[0109] (S21) The screen display control unit 120 causes the user terminal 41 to display the similarity between each record in the standard master 111 and the grouping source record. Specifically, the screen display control unit 120 displays, in the standard master record display area 302 of the similar record search screen 300, for each record in the standard master 111, the information of the matching item, the information of the conversion item, and the similarity with the grouping source record. Then, the process proceeds to step S23.

[0110] (S22) The screen display control unit 120 highlights the records selected as the target records for matching in the completed similarity calculation and displays the similarity of each record in the standard master 111 to the source record for matching on the user terminal 41. Specifically, the screen display control unit 120 displays the matching item information, the conversion item information, and the similarity to the source record for matching for each record in the standard master 111 in the standard master record display area 302 of the similar record search screen 300. The screen display control unit 120 highlights and displays the information of the records selected as the target records for matching in the completed similarity calculation on the user terminal 41 from among the records whose information is displayed in the standard master record display area 302.

[0111] (S23) The screen display control unit 120 accepts the selection of the record to be matched. Specifically, the screen display control unit 120 receives notification from the user terminal 41 of the record to be matched that was selected on the similar record search screen 300.

[0112] (S24) The similarity calculation unit 130 calculates the similarity between the data matching target record selected in step S23 and the record in the individual company master 112. Here, the similarity calculation unit 130 calculates the similarity between the data matching target record and the record in the individual company master 112 based on the matching items selected in step S15 and the similarity calculation method selected in step S16.

[0113] The similarity calculation unit 130 may calculate the similarity based on the total number of records in the individual company master 112 and the ranking of the records in the individual company master 112 that are similar to the target record. Here, the total number of records in the standard master 111 and the total number of records in the individual company master 112 may differ. Therefore, the similarity between the source record and the target record calculated in step S20 may be different from the similarity between the source record and the target record calculated in step S24.

[0114] (S25) The screen display control unit 120 highlights the source record selected in step S18 and displays the similarity of each record in the individual company master 112 to the target record on the user terminal 41. Specifically, the screen display control unit 120 displays the matching item information, the conversion item information, and the similarity to the target record for each record in the individual company master 112 in the individual company master record display area 303 of the similar record search screen 300. The screen display control unit 120 highlights and displays the information of the source record among the records whose information is displayed in the individual company master record display area 303 on the user terminal 41.

[0115] (S26) The conversion table output unit 140 stores information in the storage unit 110 indicating that the source record and the target record are a pair. If information indicating that there is a pair in the source record or the target record has already been stored in the storage unit 110, the conversion table output unit 140 deletes the information indicating that there is a pair in the source record or the target record.

[0116] (S27) The screen display control unit 120 determines whether or not it has received a request to change the conditions. Specifically, the screen display control unit 120 determines that it has received a request to change the conditions if it receives a request from the user terminal 41 to return to the matching item selection screen 200. Also, the screen display control unit 120 determines that it has not received a request to return to the matching item selection screen 200 if it has not received a request to change the conditions. If the screen display control unit 120 determines that it has received a request to change the conditions, it proceeds to step S15. Also, if the screen display control unit 120 determines that it has not received a request to change the conditions, it proceeds to step S28.

[0117] (S28) The screen display control unit 120 determines whether or not there has been an input indicating that the selection of a pair has been completed. Specifically, the screen display control unit 120 determines that there has been an input indicating that the selection of a pair has been completed if it is notified by the user terminal 41 that the "Conversion Table Output" button has been pressed on the record pair list display screen 400 or the record details display screen 500. If the screen display control unit 120 is not notified by the user terminal 41 that the "Conversion Table Output" button has been pressed, it determines that there has been no input indicating that the selection of a pair has been completed. If the screen display control unit 120 determines that there has been an input indicating that the selection of a pair has been completed, it proceeds to step S29. If the screen display control unit 120 determines that there has been no input indicating that the selection of a pair has been completed, it proceeds to step S27.

[0118] (S29) The conversion table output unit 140 outputs a code conversion table. Specifically, the conversion table output unit 140 identifies the paired records from the standard master 111 and the individual company master 112 from the pair-representing information stored in the storage unit 110. The conversion table output unit 140 then generates a code conversion table that associates the information registered in the conversion items selected in step S14 with each of the identified records. The conversion table output unit 140 then stores the generated code conversion table in the storage unit 110.

[0119] In this way, the screen display control unit 120 displays the similar record search screen 300 on the user terminal 41 to support the user's data matching work. As a result, the screen display control unit 120 can reduce the user's workload in data matching.

[0120] Furthermore, the screen display control unit 120 can accept changes to conditions such as the similarity calculation method and display the similarity of each record in the standard master 111 with the source record for data matching, calculated using other similarity calculation methods, on the user terminal 41. This allows the screen display control unit 120 to present the user with multiple criteria for data matching. Therefore, the screen display control unit 120 can improve the accuracy of data matching.

[0121] Here, the screen display control unit 120 highlights the record that was previously selected as the target record for data matching in the similarity display. This makes it easier for the user to confirm the records that the screen display control unit 120 previously determined to be in a corresponding relationship with the source record for data matching.

[0122] Next, we will explain how the similar record search screen 300 supports user data matching. Figure 17 illustrates the server's processing support for data matching.

[0123] When a source record for matching is selected, the screen display control unit 120 displays the similarity between each record in the standard master 111 and the source record in the standard master record display area 302 of the similar record search screen 300. This allows the screen display control unit 120 to allow the user operating the user terminal 41 to check the similarity between each record in the standard master 111 and the source record, thereby enabling them to select a target record that is highly likely to correspond to the source record.

[0124] When a record to be matched is selected, the screen display control unit 120 displays the degree of similarity between each record in the individual company master 112 and the record to be matched in the individual company master record display area 303 of the similar record search screen 300. This allows the screen display control unit 120 to confirm to the user how likely it is that the source record to be matched is to correspond to the record to be matched among the records in the individual company master 112.

[0125] By displaying this bidirectional similarity, the screen display control unit 120 allows the user to determine whether a source record and a target record are in a corresponding relationship without having to check the details of the source and target records. Therefore, the screen display control unit 120 enables the user to efficiently identify corresponding records in the data matching process.

[0126] Furthermore, the screen display control unit 120 highlights the source records and displays the similarity between each record in the company master 112 and the target record. This makes it easier for the user to confirm the similarity between the source record and the target record for each record in the company master 112. In this way, the server 100 can support the user in performing the data matching work smoothly.

[0127] Next, I will explain the code conversion table. Figure 18 shows an example of a code conversion table. The code conversion table 113 is generated by the conversion table output unit 140 and stored in the storage unit 110. The code conversion table 113 shown in Figure 18 is generated when the standard corporate code item is selected as the conversion item in the standard master 111 and the corporate number is selected as the conversion item in the individual company master 112 record. The code conversion table 113 has corporate number and standard corporate code items.

[0128] The Corporate Number field contains the information registered in the Corporate Number field of the individual company master 112 record included in the pair. The Standard Corporate Code field contains the information registered in the Corporate Information field of the standard master 111 record included in the pair.

[0129] For example, the code conversion table 113 contains a record where the corporate number field is "12345" and the standard corporate code field is "99999". This record indicates that it is a pair of records: one in the individual company master 112 where the corporate number field is "12345", and another in the standard master 111 where the standard corporate code field is "99999".

[0130] The server 100 can also send the code conversion table 113 to the user terminal 41. The user terminal 41 can then use the code conversion table 113 to search for records in the standard master 111 that correspond to records in the individual company master 112. Furthermore, for example, the corporate number in records registered in the standard master 111 from the individual company can be appropriately converted to the standard corporate code. Therefore, by generating such a code conversion table 113, the conversion table output unit 140 can facilitate the conversion of records registered in the standard master 111 and streamline data exchange between companies via the server 100.

[0131] According to the second embodiment, the server 100 performs the following processing. The storage unit 110 stores first data containing a plurality of first records and second data containing a plurality of second records.

[0132] When a first record from the first data is selected, the screen display control unit 120 displays the first similarity between the selected first record and each of the multiple second records on the display device for each second record. After displaying the first similarity, when a second record from the second data is selected, the screen display control unit 120 displays the second similarity between the selected second record and each of the multiple first records on the display device for each first record, along with the first similarity for each second record.

[0133] Here, the individual company master 112 is an example of the first data. The standard master 111 is an example of the second data. The user terminal 41 is an example of a display device. The source record for matching is an example of the selected first record. The destination record for matching is an example of the selected second record.

[0134] This allows server 100 to have the user performing the data matching process check the first similarity score and select the second record from among multiple second records that is most likely to correspond to the first record. Furthermore, after selecting the second record, the user can check the second similarity score displayed along with the first similarity score to confirm whether the selected first record is likely to correspond to the second record among multiple first records. Thus, the user can determine whether the selected first and second records correspond without having to check the details of the selected first and second records. Therefore, server 100 enables users to efficiently identify corresponding records. In addition, server 100 can reduce the workload on users in data matching.

[0135] Furthermore, the screen display control unit 120 highlights the first record selected when displaying the first similarity. This makes it easier for the server 100 to allow the user to confirm the second similarity between the selected second record and the selected first record.

[0136] Furthermore, after the display of the second similarity, a different calculation method may be selected than the one used to calculate the first and second similarity. In this case, the screen display control unit 120 displays the third similarity between the first record selected when displaying the first similarity and each of the multiple second records, calculated using the other calculation method, on the display device for each second record. This allows the server 100 to present the user with multiple criteria for matching data. Therefore, the server 100 can improve the accuracy of data matching.

[0137] Furthermore, the screen display control unit 120 displays a third similarity score for each second record instead of the first similarity score, and highlights the second record that was selected when displaying the second similarity score. This makes it easier for the server 100 to allow the user to confirm the second record that it previously determined to be related to the first record.

[0138] Furthermore, after displaying the first similarity score, the conversion table output unit 140 stores information indicating the pair in the storage unit when a pair of the first and second records is selected. This allows the server 100 to save the name matching results performed by the user.

[0139] Furthermore, when the conversion table output unit 140 receives input indicating the completion of selecting pairs for a plurality of first records and a plurality of second records, it identifies the first and second records included in the pair stored in the storage unit 110. The conversion table output unit 140 then outputs information showing the correspondence between the information of the first data item included in the identified first record and the information of the second data item included in the identified second record. This allows the server 100 to easily convert, for example, the information of the first data item in a record containing the information of the first data item to the information of the second data item. For example, by making it easy for the server 100 to convert the information of the first data item in a record managed by one user to the information of the second data item in a record managed by another user, or in a standard record, data exchange between users can be facilitated. Note that the conversion items in the individual company master 112 are an example of first data items. Also, the conversion items in the standard master 111 are an example of second data items.

[0140] Furthermore, the information processing in the first embodiment can be achieved by having the processing unit 12 execute a program. Similarly, the information processing in the second embodiment can be achieved by having the CPU 101 execute a program. The program can be recorded on a computer-readable recording medium 33.

[0141] For example, a program can be distributed by distributing a recording medium 33 on which the program is stored. Alternatively, the program may be stored on another computer and distributed via a network. A computer may, for example, store (install) a program stored on the recording medium 33 or a program received from another computer into a storage device such as RAM 102 or HDD 103, and then read and execute the program from that storage device. [Explanation of Symbols]

[0142] 10 Information Processing Devices 11 Storage section 11a Data 1 11b Second Data 12 Processing Units 20 Display device Screens 21, 22, 23 22a,22b,22c 1st similarity 23a,23b,23c 2nd similarity

Claims

1. On the computer, When a first record is selected from a first data set containing multiple first records, the first similarity between the selected first record and each of the multiple second records contained in the second data set containing multiple second records is displayed on the display device for each second record. After the display of the first similarity, if the second record from the second data is selected, the second similarity between the selected second record and each of the plurality of first records is displayed on the display device for each first record, along with the first similarity for each second record. An information processing program that executes a process.

2. In the display of the second similarity, the first record selected in the display of the first similarity is highlighted. The information processing program according to claim 1.

3. If, after the display of the second similarity, another calculation method different from the calculation method used to calculate the first and second similarity is selected, the third similarity between the first record selected when displaying the first similarity and each of the plurality of second records, calculated using the other calculation method, is displayed on the display device for each second record. The information processing program according to claim 1, which causes the computer to perform further processing.

4. In the display of the third similarity, instead of the first similarity, the third similarity is displayed for each second record, and the second record selected when displaying the second similarity is highlighted. The information processing program according to claim 3.

5. After the display of the first similarity score, if a pair of the first record and the second record is selected, information indicating the pair is stored in the storage unit. The information processing program according to claim 1, which causes the computer to perform further processing.

6. Upon receiving input indicating the completion of selecting pairs for the plurality of first records and the plurality of second records, the storage unit identifies the first and second records included in the pair and outputs information showing the correspondence between the information of the first data item included in the identified first record and the information of the second data item included in the identified second record. The information processing program according to claim 5, which causes the computer to perform further processing.

7. Computers When a first record is selected from a first data set containing multiple first records, the first similarity between the selected first record and each of the multiple second records contained in the second data set containing multiple second records is displayed on the display device for each second record. After the display of the first similarity, if the second record from the second data is selected, the second similarity between the selected second record and each of the plurality of first records is displayed on the display device for each first record, along with the first similarity for each second record. Information processing methods.

8. A storage unit that stores first data containing multiple first records and second data containing multiple second records, When a first record from the first data is selected, the processing unit displays the first similarity between the selected first record and each of the plurality of second records on the display device for each second record, and after the display of the first similarity, when a second record from the second data is selected, the processing unit displays the second similarity between the selected second record and each of the plurality of first records on the display device for each first record, along with the first similarity for each second record. An information processing device having