Computer-implemented column mapping system and method
OwnerShirley J.R. Walker, Paul A. Polo +1inventors
InventorsShirley J.R. Walker, Paul A. Polo, Steven E. Giles
Life of this patent
Estimating the term…
Abstract
A computer-implemented method and system for mapping a computer data input column to a computer data output column. The input column and the output column have attributes. Information is received about at least one of the input column attributes and at least one of the output column attributes. At least one of the input column attributes is compared to at least one of the output column attributes to determine a likelihood ranking for mapping the input column to the output column. The likelihood ranking is between zero and one-hundred percent certain. The decision whether to map the input column to the output column is based upon the likelihood ranking.
Claims25
A computer-implemented method for mapping an input column to an output column, said input column and said output column having attributes, comprising the steps of:
- receiving information about at least one of the input column attributes and at least one of the output column attributes, said attributes of the input column and output column having a name attribute, wherein names of the input and output columns' name attribute differ;
- comparing at least one of the input column attributes to at least one of the output column attributes to determine a likelihood ranking for mapping the input column to the output column, said likelihood ranking indicating a certainty for the mapping that is less than completely certain;
- and
- determining whether to map the input column to the output column based upon the likelihood ranking.
A computer-implemented method for mapping input columns to output columns, said input columns and said output columns having attributes, comprising the steps of:
- retrieving data stored in an input column;
- examining the retrieved input column data to determine format of the input column;
- retrieving data stored in an output column;
- examining the retrieved output column data to determine format of the output column;
- comparing the determined input column format to the determined output column format to determine a likelihood ranking for mapping the input column to the output column, wherein said likelihood ranking is less than certain;
- and
- generating a mapping between the input column and the output column based upon the likelihood ranking that indicates that the mapping is less than certain.
Dependencies are inferred from the claim text.