Semantic discovery and mapping between data sources

A method for determining a functional correlation between columns of a first data source and a second data source, the method comprising:

• combining the first data source and the second data source into a combined data source based on a binding condition;
• identifying a correlation count for columns of the first data source and the second data source in the combined data source;
• comparing the correlation count to a threshold value;
• determining the functional correlation between columns of the first data source and the second data source, when the correlation count is more than the threshold value.

A method for determining a mapping between a plurality of columns of a first data source and a second data source by using a fuzzy match, the method comprising:

• identifying a join condition between the plurality of plurality of columns of a first data source and a second data source;
• constructing source data objects based on a set of relationship between the plurality of columns of the first data source and the second data source and a identified join condition;
• determining the fuzzy match between the plurality of columns of a first data source and a second data;
• and
• identifying the mapping corresponding to the fuzzy match between the plurality of columns of the first data source and the second data.