主权项 |
1. A computer-implemented method for optimizing a queue of queries for database efficiency, the method implemented by a controller computing device coupled to a memory device, the method comprising:
receiving a plurality of database queries from the queue of queries, at the controller computing device, from at least one host; evaluating the plurality of database queries to determine a resource impact associated with each database query of the plurality of database queries, wherein the resource impact is determined based on a schedule impact and a human resource impact associated with the each database query of the plurality of database queries; prioritizing the plurality of database queries based upon a set of prioritization factors and the resource impact associated with the each database query of the plurality of database queries to optimize the plurality of database queries for greater efficiency, wherein the set of prioritization factors includes (i) a ranking of an analyst generating the each database query of the plurality of database queries, (ii) a data source quality, and (iii) a financial impact for receiving a response to the each database query of the plurality of database queries, wherein the data source quality represents a relative quality of data in a data source associated with the each database query, and wherein a higher priority factor is assigned to the each database query that has a corresponding response having a greatest financial impact; submitting the prioritized plurality of database queries to a database system for execution; and executing, with the database system, the prioritized plurality of database queries in an order of priority produced by the prioritizing of the plurality of database queries. |