System and method for automatically linking data sources for providing data related to a query

摘要

A computer-implemented method of linking a predefined set of electronic data sources comprises electronically identifying a query data item and one or more query dimensions based on a query statement, electronically determining first data sources in which at least one of one or more source fields is equivalent to the query data item, determining whether any one of the first data sources has the ability to provide the data related to the one or more query dimensions, and identifying one or more second data sources within the database corresponding to one or more of the first data sources if it is determined that the first data sources do not have the ability to provide data related to the one or more query dimensions. The one or more second data sources meet the following criteria: (1) one or more source fields of the one or more second data sources are equivalent to the one or more query dimensions not contained in the first data source; and (2) each source dimension of the one or more second data sources are either: (A) equivalent to a source field of the first source or (B) have values that are capable of being obtained from the query statement. One or more first data sources are linked with the corresponding one or more second data sources to generate one or more composite data sources to provide the necessary data in response to the query statement.