Patent ID: 8126750

Claim:
A method to be executed at least in part in a computing device for optimizing data retrieval in a scorecard service, the method comprising: determining a first data source and a second data source associated with a first scorecard element and a second scorecard element, respectively, the first scorecard element and the second scorecard element being part of a scorecard comprising scorecard elements associated with multiple data sources; receiving a first query for the first scorecard element associated with the first data source; receiving a second query for the second scorecard element associated with the second data source; determining whether the first data source and the second data source are the same; dynamically generating, by a computer, a combined query to retrieve data associated with the first scorecard element and the second scorecard element, when the first data source and the second data source are the same, wherein dynamically generating the combined query comprises rewriting the first query and the second query into the combined query comprising: a) determining the identity associated with the subscriber requesting one of the first scorecard element and the second scorecard element; b) employing attributes associated with the identity of the subscriber associated with the combined query and a corresponding permission attribute associated with the subscriber; c) determining a condition associated with one of the first data source and the second data source, the condition comprising one of: a measure of data transfer reliability, a time of day, a geographic location of the data source, and a data transfer capacity; d) optimizing the combined query based on the determined condition; retrieving results associated with the first scorecard element and the second scorecard element by executing the dynamically generated combined query; and providing an optimized result set for a scorecard matrix comprising the first scorecard element and the second scorecard element based on the retrieved results of the combined query.