SYNONYMOUS COLUMN DETECTING DEVICE AND SYNONYMOUS COLUMN DETECTING METHOD

摘要

PROBLEM TO BE SOLVED: To determine whether or not each of a plurality of columns having similar attributes is synonymous to any other column.SOLUTION: A synonymous column determining unit 199 of a synonymous column detecting device 100 extracts, on the basis of the result of comparison of attributes of individual columns contained in a first column group in a first database and attributes of individual columns contained in a second column group in a second database, synonymous column candidates from each of the first column group and the second column group. If there are two or more each of first candidates, which are synonymous column candidates extracted from the first column group, and of second candidates, which are synonymous column candidates extracted from the second column group, the synonymous column determining unit 199 determines, on the basis of the results of analyses of the hysteresis of query issues to the first database and of the hysteresis of query issues to the second database, a column each identifiable as a synonymous column from the first candidates and the second candidates.