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, the at least one processor to perform a search of a logical table based on a single criterion to identify a plurality of rows in 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 and 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
• a query module executable by the at least one processor to query at least two data sources for the data to generate results that include the data, the at least two data sources at least partially identified via the first plurality of tuples, the communication module to communicate the data in response to the request to search for the data.

A machine readable medium storing a set of instructions that, when executed by a machine, cause the machine to:

• receive a request to search for the data;
• search a logical table based on a single 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 includes a first and 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;
• query at least two data sources for the data to generate results that include the data, the at least two data sources at least partially identified via the first plurality of tuples;
• and
• communicate the data in response to the request to search for the data.

A system to respond to a request for data, the method including:

• a means for receiving a request to search for the data, the receiving automatically to cause a processor to perform a search of a logical table based on a single criterion to identify a plurality of rows in the logical table;
• a means for generating 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 including a first and second tuple, the first tuple identifying a first server and a first physical table that is accessed via the first server, the second tuple identifying a second server and a second physical table that is accessed via the second server;
• a means for querying at least two data sources for the data to generate results that include the data, the at least two data sources being at least partially identified by utilizing the first plurality of tuples;
• and
• a means for communicating the data in response to the request to search for the data.