Correlation of data sets using determined data types
AssigneeInternational Business Machines Corporation
InventorsTamer E. Abuelsaad, Gregory J. Boss, Craig M. Trim
Life of this patent
Estimating the term…
Abstract
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.
Claims20
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.
A computer program product for correlating data sets, the computer program product comprising:
- one or more computer-readable storage media and program instructions stored on the one or more computer-readable storage media, the program instructions comprising:
- program instructions to determine, 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;
- program instructions to identify a second column of a second data set associated with the data type;
- program instructions to compare the column data of the first and second columns and, in response, determine a score representing a degree of relevance between the first and second data columns;
- and
- program instructions to determine whether the score exceeds a threshold and, if so, suggest the second data set to a user.
A computer system for correlating data sets, the computer system comprising:
- one or more computer processors;
- one or more computer-readable storage media;
- program instructions to determine, 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;
- program instructions to identify a second column of a second data set associated with the data type;
- program instructions to compare the column data of the first and second columns and, in response, determine a score representing a degree of relevance between the first and second data columns;
- and
- program instructions to determine whether the score exceeds a threshold and, if so, suggest the second data set to a user.
Dependencies are inferred from the claim text.