Concerted coordination of multidimensional scorecards
First Claim
Patent Images
1. A method to be executed at least in part in a computing device for optimizing data retrieval in a scorecard service, comprising:
- determining a first data source and a second data source associated with a first scorecard element and a second scorecard element, respectively;
determining whether the first data source and the second data source are the same; and
dynamically generating a query to retrieve data associated with the first scorecard element and the second scorecard element, if the first data source and the second data source are the same.
2 Assignments
0 Petitions
Accused Products
Abstract
Data retrieval from data sources associated with elements of a scorecard is optimized by combining the queries for the same data sources into a single query. The querying process is further optimized based on an attribute and/or condition of a data source. Query parameters and execution schedule may be adjusted based on the elements, data sources, or subscriber identity. Retrieved data is cached at element, combination of elements, data source, or scorecard level for rapid and efficient building and maintenance of scorecards.
109 Citations
20 Claims
-
1. A method to be executed at least in part in a computing device for optimizing data retrieval in a scorecard service, comprising:
-
determining a first data source and a second data source associated with a first scorecard element and a second scorecard element, respectively;
determining whether the first data source and the second data source are the same; and
dynamically generating a query to retrieve data associated with the first scorecard element and the second scorecard element, if the first data source and the second data source are the same. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)
-
-
15. A computer-readable medium having computer executable instructions for optimizing queries in a scorecard system, the instructions comprising:
-
determining a plurality of data sources associated with a plurality of elements of a scorecard;
determining those data sources that are shared by the same scorecard elements;
determining an attribute and a condition for each of the plurality of data sources;
generating one or more queries to retrieve data associated with the plurality of elements such that the queries are optimized based on the shared data sources, the attribute of each data source, and the condition of each data source; and
retrieving the data by executing the generated queries. - View Dependent Claims (16, 17)
-
-
18. A system for managing data retrieval from a plurality of data sources in a scorecard system, comprising:
-
a scorecard application configured to compute scorecard metrics and provide a scorecard presentation based on the computed scorecard metrics; and
a query module configured to;
determine a data source associated with a number of scorecard metrics;
determine an attribute and a condition of the data source;
generate a query dynamically such that data for each of the number of scorecard metrics is retrieved together; and
optimize the query based on the attribute and the condition of the data source. - View Dependent Claims (19, 20)
-
Specification