Method and system for a transparent application of multiple queries across multiple data sources

A system to respond to a request for data, the system includes:

• at least one processor;
• a communication module executable by the at least one processor to receive a request to search for the data based on a criterion and to populate a plurality of data objects with the data, the request further utilized to identify a plurality of columns that determine at least two data sources to query, the at least one processor to perform a search of a logical table based on the criterion to identify a plurality of rows in the logical table, the communication module is to receive a request to search all physical tables and all database instances associated with the logical table;
• a dynamic data module executable by the at least one processor to generate a first plurality of tuples based on the plurality of rows to identify a first plurality of physical tables that are mapped to the logical table, the first plurality of tuples includes a first tuple and a second tuple, the first tuple identifies a first server and a first physical table that is accessed via the first server, the second tuple identifies a second server and a second physical table that is accessed via the second server;
• a query module executable by the at least one processor to query the at least two data sources for the data, the at least two data sources are identified via the first plurality of tuples,
• the query module to successfully retrieve data for a first plurality of data objects included in the plurality of data objects based on the first tuple,
• the query module to unsuccessfully retrieve data for a second plurality of data objects included in the plurality of data objects based on the second tuple.

A non-transitory machine readable medium storing a set of instructions that, when executed by a machine, causes the machine to:

• receive a request to search for the data based on a criterion and to populate a plurality of data objects with the data, the request further utilized to identify a plurality of columns that determine at least two data sources to query, the receipt of the request to search for the data includes receipt of a request to search all physical tables and all database instances associated with the logical table;
• search a logical table based on a criterion to identify a plurality of rows in the logical table;
• generate a first plurality of tuples based on the plurality of rows to identify a first plurality of physical tables that are mapped to the logical table, the first plurality of tuples include a first tuple and a second tuple, the first tuple identifies a first server and a first physical table that is accessed via the first server, the second tuple identifies a second server and a second physical table that is accessed via the second server;
• and
• query the at least two data sources for the data to generate results by use of the first plurality of tuples, the query of the at least two data sources includes:
• identification of a successful retrieval of data for a first plurality of data objects included in the plurality of data objects based on the first tuple and
• identification of an unsuccessful retrieval of data for a second plurality of data objects included in the plurality of data objects based on the second tuple.