Patent ID: 8898147

Claim:
A method to respond to a request for data, the method including: receiving 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, responsive to the receiving the request performing a search of a logical table based on the criterion to identify a plurality of rows in the logical table, the receiving the request to search for the data including receiving a request for searching all physical tables and all database instances associated with the logical table; 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 tuple and a 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, the generating done at least in part through by one or more processors; and querying the at least two data sources for the data to generate results by utilizing the first plurality of tuples, the querying the at least two data sources including: identifying 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 identifying an unsuccessful retrieval of data for a second plurality of data objects included in the plurality of data objects based on the second tuple.