Semantic discovery and mapping between data sources

摘要

An apparatus and method are described for the discovery of semantics, relationships and mappings between data in different software applications, databases, files, reports, messages, or systems. In one aspect, semantics and relationships and mappings are identified between a first and a second data source. A binding condition is discovered between portions of data in the first and the second data source. The binding condition is used to discover correlations between portions of data in the first and the second data source. The binding condition and the correlations are used to discover a transformation function between portions of data in the first and the second data source.

主权项

1. 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 columns of the first data source and the second data source; constructing source data objects based on a set of relationships between the plurality of columns of the first data source and the second data source and the identified join condition; determining a fuzzy match between the plurality of columns of the first data source and the second data; identifying the mapping corresponding to the fuzzy match between the plurality of columns of the first data source and the second data source; and generating a window providing a display of success for the mapping between the columns of the first data source and the second data source.