CORRELATION OF DATA SETS USING DETERMINED DATA TYPES

摘要

A computer receives a data set and determines the data type of the column data within. The computer identifies a second data set with columns of the same data type. The computer compares the contents of the columns and the formatting of the contents to determine a score representative of the relevancy of the data sets to one another. Responsive to the score exceeding a threshold, the computer suggests the second data set to a user.

主权项

1. A computer-implemented method for correlating data sets, the method comprising:
determining, by a computer system, for a first data set comprising one or more columns, each column comprising column data, a data type of the column data of a first column of the first data set; identifying, by the computer system, a second column of a second data set associated with the data type; comparing, by the computer system, the column data of the first and second columns and, in response, determining, by the computer system, a score representing a degree of relevance between the first and second data columns; and determining, by the computer system, whether the score exceeds a threshold and, if so, suggesting, by the computer system, the second data set to a user.