Managing excess capacity of database systems in a capacity controlled computing environment
First Claim
1. A computer-implemented method to manage capacity of a database system, wherein the database system that includes one or more database nodes operable to process data associated with a database, wherein the one or more database nodes include one or more physical processors, and wherein the computer-implemented method comprises:
- configuring the database system to operate at an allotted limited capacity below its full capacity to process database queries, by configuring at least one of the one or more database nodes to operate at an allotted usage capacity below its full usage capacity to process database queries, wherein an excess capacity in relation to the allotted limited usage capacity is available to the database system on demand;
determining by the one or more physical processors that one or more problematic operations associated with the database have occurred, wherein the one or more problematic operations include at least one of;
(i) one or more database queries that have been determined to encounter an error during execution, and (ii) execution of one or more database queries have been determined not to be optimal;
determining by the one or more physical processors whether to allow excess capacity that is available to the database system on demand in relation to the allotted limited capacity to be used to resolve the problematic operations by at least performing one or more selected operations pertaining to at least one of;
processing of a selected one or more of the database queries that have encountered an error, and optimization of a selected one or more database queries determined not to be optimal; and
when the determining determines to allow the excess capacity available to the database system to be used to perform the one or more selected operations;
allowing by the one or more physical processors the excess capacity of the database system to be used on demand to perform the one or more selected operations, by allowing the at least one database node to exceed its allotted usage capacity on demand to perform the one or more operations,not allowing by the one or more physical processors the excess capacity of the database system to be used to process one or more of the database queries that have not been selected for least one of;
processing of the selected one or more of the database queries that has encountered an error, and the optimization of the selected one or more of the database queries.
1 Assignment
0 Petitions
Accused Products
Abstract
Excess capacity available to a database system in a capacity controlled environment can be effectively managed. In particular, excess capacity that is not made available for normal operations of a database system can be used to manage errors, especially situations that may hinder expected performance of the database system. In addition, excess capacity can be used to optimize or further optimize database queries, especially those that meet a criterion (e.g., not fully optimize, not optimized as expected).
19 Citations
19 Claims
-
1. A computer-implemented method to manage capacity of a database system, wherein the database system that includes one or more database nodes operable to process data associated with a database, wherein the one or more database nodes include one or more physical processors, and wherein the computer-implemented method comprises:
-
configuring the database system to operate at an allotted limited capacity below its full capacity to process database queries, by configuring at least one of the one or more database nodes to operate at an allotted usage capacity below its full usage capacity to process database queries, wherein an excess capacity in relation to the allotted limited usage capacity is available to the database system on demand; determining by the one or more physical processors that one or more problematic operations associated with the database have occurred, wherein the one or more problematic operations include at least one of;
(i) one or more database queries that have been determined to encounter an error during execution, and (ii) execution of one or more database queries have been determined not to be optimal;determining by the one or more physical processors whether to allow excess capacity that is available to the database system on demand in relation to the allotted limited capacity to be used to resolve the problematic operations by at least performing one or more selected operations pertaining to at least one of;
processing of a selected one or more of the database queries that have encountered an error, and optimization of a selected one or more database queries determined not to be optimal; andwhen the determining determines to allow the excess capacity available to the database system to be used to perform the one or more selected operations; allowing by the one or more physical processors the excess capacity of the database system to be used on demand to perform the one or more selected operations, by allowing the at least one database node to exceed its allotted usage capacity on demand to perform the one or more operations, not allowing by the one or more physical processors the excess capacity of the database system to be used to process one or more of the database queries that have not been selected for least one of;
processing of the selected one or more of the database queries that has encountered an error, and the optimization of the selected one or more of the database queries. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. An apparatus, comprising:
-
one or more processors operable to; process and store data for a database system configured to operate at a limited capacity below its full capacity; configure the database system to operate at an allotted limited capacity below its full capacity to process database queries, by configuring at least one of the one or more database nodes of the database system to operate at an allotted usage capacity below its full usage capacity to process database queries, wherein an excess capacity in relation to the allotted limited usage capacity is available to the database system on demand; determine that one or more problematic operations associated with the database have occurred, wherein the one or more problematic operations associated with the database include at least one of;
(i) one or more database queries that have been determined to encounter and error, and (ii) execution of one or more database queries determined not to be optimal;determine whether to allow excess capacity available to the database on demand to be used to resolve one or more problematic operations associated with the database; allow the excess capacity to be used on demand to resolve the one or more problematic operations when the determining determines to allow the excess capacity available to the database system to be used on demand to perform the one or more operations associated with the database; and not allowing the excess capacity to be used to perform one or more other operations associated with the database that are determined not be problematic. - View Dependent Claims (8, 9, 10, 11, 12, 13, 14)
-
-
15. A non-transitory computer readable storage medium storing at least executable computer code for managing capacity of a database system that includes one or more database nodes operable to process data associated with a database, wherein the database system is configured to operate at a limited capacity below its full capacity, and wherein the non-transient computer readable storage medium includes:
-
executable computer code operable to configure the database system to operate at an allotted limited capacity below its full capacity to process database queries, by configuring at least one of the one or more database nodes of the database system to operate at an allotted usage capacity below its full usage capacity to process database queries, wherein an excess capacity in relation to the allotted limited usage capacity is available to the database system on demand; executable computer code operable to determine whether to allow excess capacity available to the database system on demand to be used to perform one or more problematic operations associated with processing of the data by the one or more database nodes, wherein the one or more operations associated with the database include;
(i) one or more database queries that have been determined to encounter and error, and (ii) optimizations of one or more database queries determined not be optimal; andexecutable computer code operable to allow the excess capacity to be used to perform the one or more problematic operations when the determining determines to allow the excess capacity available to the database system on demand to be used to perform the one or more problematic operations associated with processing of the data by the one or more database nodes; and executable computer code operable not to allow the excess capacity to be used to perform one or more other operations associated with the database that are determined not to be problematic. - View Dependent Claims (16, 17, 18, 19)
-
Specification