# US 2018/0322108 A1 · Item name association processing method, computer-readable recording medium, and information processing apparatus > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 2018/0322108 A1 - Document ID: US20180322108A1 - Status: Published application - Kind: A1 - Application number: 16/036,088 - Filed: 2018-07-16 - Published: 2018-11-08 - Earliest claimed: 2016-02-04 - Assignees: Fujitsu Limited - Applicants: Fujitsu Limited - Inventors: Tsuyoshi Maita; Nobumi Noro; Tetsu Tanaka - Web page: https://patentgrep.com/patent/US20180322108A1 ## CPC - G06F 40/18: of spreadsheets (form-filling G06F40/174) - G06F 16/258: {Data format conversion from or to a database} - G06F 16/285: {Clustering or classification} - G06F 40/103: Formatting, i.e. changing of presentation of documents (automatic justification G06F40/189; automatic line break hyphenation G06F40/191) - G06F 40/177: of tables; using ruled lines - G06Q 10/10: Office automation; Time management - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) - G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR ## Abstract An item name association processing method includes: extracting a plurality of item names from table format data, using a processor; referring to a storage in which a plurality of item groups is stored and determining which item group includes an item name that has a predetermined similar relationship with the plurality of individual extracted item names, using the processor; and selecting, as an association target, from among the plurality of item names, regarding the item name from which a positive determination result has been obtained, the item name having the predetermined similar relationship and submitting, as an association candidate, from among the plurality of item names, regarding the item name from which a negative determination result has been obtained, the item group determined to include the item name having the predetermined similar relationship with another item name, using the processor. ## Claims ### Claim 1 An item name association processing method comprising: extracting a plurality of item names from table format data, using a processor; referring to a storage in which a plurality of item groups is stored and determining which item group includes an item name that has a predetermined similar relationship with the plurality of individual extracted item names, using the processor; and selecting, as an association target, from among the plurality of item names, regarding the item name from which a positive determination result has been obtained, the item name having the predetermined similar relationship and submitting, as an association candidate, from among the plurality of item names, regarding the item name from which a negative determination result has been obtained, the item group determined to include the item name having the predetermined similar relationship with another item name, using the processor. ### Claim 2 (depends on 1) The item name association processing method according to claim 1, wherein, regarding the item name from which the negative determination result has been obtained, the submitting includes further submitting, when submitting the item group determined to include the item name having the predetermined similar relationship with the other item name as the association candidate, a predetermined item group as another association candidate. ### Claim 3 (depends on 2) The item name association processing method according to claim 2, wherein the plurality of item groups includes an item group that is formed for each type of industry and an item group that is formed common to the type of industry and the predetermined item group is associated with the item group that is formed common to the type of industry. ### Claim 4 (depends on 1) The item name association processing method according to claim 1, wherein the plurality of item names is extracted from a table that is detected as a single table from the table format data. ### Claim 5 (depends on 1) The item name association processing method according to claim 1, wherein the plurality of item names has been extracted from a plurality of tables that was detected from the table format data, and regarding the item name from which the negative determination result has been obtained, the submitting includes submitting, as an association candidate, the item group determined to include the item name having the predetermined similar relationship with the other item name extracted from the same table from among the plurality of tables. ### Claim 6 (depends on 1) The item name association processing method according to claim 1, when it is determined that a first item name having the predetermined similar relationship with an item name that is included in the same table that includes the item name from which the negative determination result has been obtained is included and when it is determined that the item name having the predetermined similar relationship with a second item name that is included in a table different from the table that includes the item name from which the negative determination result has been obtained is included, the submitting includes submitting, regarding the item name from which the negative determination result has been obtained, the item group that includes the first item name as an association candidate with priority over the item group that includes the second item name. ### Claim 7 (depends on 1) The item name association processing method according to claim 1, further comprising storing in the storage, from among the association candidates submitted for the item name from which the negative determination result has been obtained, an association relationship between an adopted candidate and the item name from which the negative determination result has been obtained, using the processor, wherein when an item name extracted from the table format data or another table format data is associated with a specific item name by the association relationship, the submitting includes selecting the specific item name as an association target for the item name extracted from the table format data or the other table format data. ### Claim 8 (depends on 7) The item name association processing method according to claim 7, wherein, when submitting an association candidate for the other item name from which the negative determination result has been obtained, the submitting includes submitting the item group that includes the specific item name as an association candidate with priority over the other item group. ### Claim 9 (depends on 1) The item name association processing method according to claim 1, wherein the item name selected as the association target or the item name that has been received selection from among the item names included in the submitted item group is associated with the plurality of individual item names in the table format data and is stored in the storage. ### Claim 10 (depends on 1) The item name association processing method according to claim 1, wherein the extracting the item name includes determining whether or not a data input cell is present regarding each row or column in the input table format data, using the processor, extracting a chunk of a plurality of consecutive rows or columns in each of which the data input cells are present to a single table as a correlated portion, using the processor, specifying an item row or an item column in the chunk of rows or columns, using the processor, and extracting, as the item name, data that is input in each of the cells in the specified item row or the item column, using the processor. ### Claim 11 A non-transitory computer-readable recording medium having stored therein an item name association processing program that causes a computer to execute a process comprising: extracting a plurality of item names from table format data; referring to a storage in which a plurality of item groups is stored and determining which item group includes an item name that has a predetermined similar relationship with the plurality of individual extracted item names; and selecting, as an association target, from among the plurality of item names, regarding the item name from which a positive determination result has been obtained, the item name having the predetermined similar relationship and submitting, as an association candidate, from among the plurality of item names, regarding the item name from which a negative determination result has been obtained, the item group determined to include the item name having the predetermined similar relationship with another item name. ### Claim 12 (depends on 11) The non-transitory computer-readable recording medium according to claim 11, wherein, regarding the item name from which the negative determination result has been obtained, the submitting includes further submitting, when submitting the item group determined to include the item name having the predetermined similar relationship with the other item name as the association candidate, a predetermined item group as another association candidate. ### Claim 13 (depends on 11) The non-transitory computer-readable recording medium according to claim 11, wherein the plurality of item names has been extracted from a plurality of tables that was detected from the table format data, and regarding the item name from which the negative determination result has been obtained, the submitting includes submitting, as an association candidate, the item group determined to include the item name having the predetermined similar relationship with the other item name extracted from the same table from among the plurality of tables. ### Claim 14 (depends on 11) The non-transitory computer-readable recording medium according to claim 11, when it is determined that a first item name having the predetermined similar relationship with an item name that is included in the same table that includes the item name from which the negative determination result has been obtained is included and when it is determined that the item name having the predetermined similar relationship with a second item name that is included in a table different from the table that includes the item name from which the negative determination result has been obtained is included, the submitting includes submitting, regarding the item name from which the negative determination result has been obtained, the item group that includes the first item name as an association candidate with priority over the item group that includes the second item name. ### Claim 15 (depends on 11) The non-transitory computer-readable recording medium according to claim 11, wherein the extracting the item name includes determining whether or not a data input cell is present regarding each row or column in the input table format data, extracting a chunk of a plurality of consecutive rows or columns in each of which the data input cells are present to a single table as a correlated portion, specifying an item row or an item column in the chunk of rows or columns, and extracting, as the item name, data that is input in each of the cells in the specified item row or the item column. ### Claim 16 An information processing apparatus comprising: a memory; and a processor coupled to the memory, wherein the processor executes a process comprising: extracting a plurality of item names from table format data; referring to a storage in which a plurality of item groups is stored and determining which item group includes an item name that has a predetermined similar relationship with the plurality of individual extracted item names; and selecting, as an association target, from among the plurality of item names, regarding the item name from which a positive determination result has been obtained, the item name having the predetermined similar relationship and submitting, as an association candidate, from among the plurality of item names, regarding the item name from which a negative determination result has been obtained, the item group determined to include the item name having the predetermined similar relationship with another item name. ### Claim 17 (depends on 16) The information processing apparatus according to claim 16, wherein, regarding the item name from which the negative determination result has been obtained, the submitting includes further submitting, when submitting the item group determined to include the item name having the predetermined similar relationship with the other item name as the association candidate, a predetermined item group as another association candidate. ### Claim 18 (depends on 16) The information processing apparatus according to claim 16, wherein the plurality of item names has been extracted from a plurality of tables that was detected from the table format data, and regarding the item name from which the negative determination result has been obtained, the submitting includes submitting, as an association candidate, the item group determined to include the item name having the predetermined similar relationship with the other item name extracted from the same table from among the plurality of tables. ### Claim 19 (depends on 16) The information processing apparatus according to claim 16, when it is determined that a first item name having the predetermined similar relationship with an item name that is included in the same table that includes the item name from which the negative determination result has been obtained is included and when it is determined that the item name having the predetermined similar relationship with a second item name that is included in a table different from the table that includes the item name from which the negative determination result has been obtained is included, the submitting includes submitting, regarding the item name from which the negative determination result has been obtained, the item group that includes the first item name as an association candidate with priority over the item group that includes the second item name. ### Claim 20 (depends on 16) The information processing apparatus according to claim 16, wherein the extracting the item name includes determining whether or not a data input cell is present regarding each row or column in the input table format data, extracting a chunk of a plurality of consecutive rows or columns in each of which the data input cells are present to a single table as a correlated portion, and specifying an item row or an item column in the chunk of rows or columns, and extracting, as the item name, data that is input in each of the cells in the specified item row or the item column.