Abstract: Systems, methods, and other embodiments associated with managing query loads are described. In one embodiment, a system is configured to define a fingerprint for received queries that are requested for execution on a database system and determine whether the defined fingerprint matches or does not match an existing fingerprint. For queries having a fingerprint that does not match an existing fingerprint: the system executes the query to completion and sets a classification for the fingerprint indicating the query (i) is flagged for evaluation or (ii) is permissible. For queries having a fingerprint that matches an existing fingerprint: determine whether the fingerprint was previously flagged and evaluate statistics for the fingerprint to determine whether execution will cause a negative impact on the system. The classification of the fingerprint is modified accordingly. The system controls execution of the query based on the classification of the fingerprint.

Abstract: Systems, methods, and other embodiments associated with assessing and adaptively managing query loads are described. In one embodiment, a method includes determining that a query invoked by a client terminal against an application object has a duration that exceeds a completion threshold. In response to receiving a subsequent invocation of the query, statistics for the query are obtained. The obtained statistics are analyzed to determine whether the query causes the unacceptable negative impact on the application object. A data structure is modified to include a classification of the query into one of a plurality of different query classes based on a result of the analysis, and execution of the query in response to a future invocation is controlled based on the classification of the query in the modified data structure.

Abstract: Systems, methods, and other embodiments associated with assessing and adaptively managing query loads are described. In one embodiment, a method includes determining that a query invoked by a client terminal against an application object has a duration that exceeds a completion threshold. In response to receiving a subsequent invocation of the query, statistics for the query are obtained. The obtained statistics are analyzed to determine whether the query causes the unacceptable negative impact on the application object. A data structure is modified to include a classification of the query into one of a plurality of different query classes based on a result of the analysis, and execution of the query in response to a future invocation is controlled based on the classification of the query in the modified data structure.