DATA COORDINATION SUPPORT APPARATUS AND DATA COORDINATION SUPPORT METHOD

摘要

A data coordination support apparatus is provided to efficiently detect between which table and a table being a coordination destination there is a reference relation, in data coordination. The data coordination support apparatus identifies, with respect to each table other than the table being the coordination destination, a first column designated as the primary key and a second column not designated as the primary key, from a plurality of columns included in a table concerned. The data coordination support apparatus extracts such a table that a third column similar to the first column is included in the table being the coordination destination, and a fourth column similar to the second column is included the table being the coordination destination, from tables other than the table being the coordination destination. The data coordination support apparatus outputs recommendation information that recommends using a combination of the table being the coordination destination and the table extracted, in the data coordination.

主权项

1. A data coordination support apparatus that supports data coordination of a database including a plurality of tables, the data coordination support apparatus comprising:
an information storage unit to store primary key information indicating whether or not each of a plurality of columns included in each of the plurality of tables is designated as a primary key, and attribute information indicating an attribute of data contained in each of the plurality of columns included in each of the plurality of tables; a table selection unit to select a table being a coordination destination of the data coordination, from among the plurality of tables; a column identification unit to identify, with respect to each table among the plurality of tables other than the table selected by the table selection unit, a first column designated as the primary key and a second column not designated as the primary key, from a plurality of columns included in a table, based on the primary key information stored in the information storage unit; a table extraction unit to extract such a table that a third column similar to the first column identified by the column identification unit is included in the table selected by the table selection unit, and a fourth column similar to the second column identified by the column identification unit is included in the table selected by the table selection unit, from tables among the plurality of tables other than the table selected by the table selection unit, based on the attribute information stored in the information storage unit; and an information output unit to output recommendation information that recommends using a combination of the table selected by the table selection unit and the table extracted by the table extraction unit, in the data coordination, wherein the table extraction unit, with respect to a table in which two or more second columns are identified by the column identification unit, extracts such a table that the fourth column exists, in the table selected by the table selection unit, individually for a largest number of the second columns.