Learning by using excess capacity in a capacity controlled environment
First Claim
1. A method, implemented at least partly by a device, the method comprising:
- configuring the database system to operate at a limited capacity below its full capacity for execution of database queries of a database, wherein the database system includes one or more processors operable to process data stored in the database in a database environment in order to process the database queries;
learning about optimization of execution of one or more selected database queries that do not meet at least one performance criteria associated with a target performance for processing the selected database queries with the limited capacity in the database environment, by using the excess capacity of the database system configured to operate with the limited capacity for the execution of database queries of the database;
allowing at least one portion of the excess capacity available to the database system to be used to perform one or more learning activities associated with learning about optimization of execution of one or more selected database queries in the database environment that do not meet at least one performance criteria; and
not allowing the at least one portion of the excess capacity available to the database system to be used to perform other activities not associated with the learning about optimization of execution of the database queries in the database environment.
1 Assignment
0 Petitions
Accused Products
Abstract
Excess capacity of a database system can be used for learning activities in a controlled computing environment. In this context, excess capacity of a database system can be used as needed and/or on a temporary basis. Furthermore, learning activities can be performed without requiring the use of the capacity that is configured or has been allotted for various other database operations, including those deemed, especially by the users of database system, to serve a main function or a more important purpose. As a result, learning can be performed without adversely affecting other operations deemed to be more critical, especially by the users of databases. Learning activities associated with a database environment can, for example, include learning operations directed to optimization of database queries, for example, by using a basic feedback or an expanded or active learning.
19 Citations
19 Claims
-
1. A method, implemented at least partly by a device, the method comprising:
-
configuring the database system to operate at a limited capacity below its full capacity for execution of database queries of a database, wherein the database system includes one or more processors operable to process data stored in the database in a database environment in order to process the database queries; learning about optimization of execution of one or more selected database queries that do not meet at least one performance criteria associated with a target performance for processing the selected database queries with the limited capacity in the database environment, by using the excess capacity of the database system configured to operate with the limited capacity for the execution of database queries of the database; allowing at least one portion of the excess capacity available to the database system to be used to perform one or more learning activities associated with learning about optimization of execution of one or more selected database queries in the database environment that do not meet at least one performance criteria; and not allowing the at least one portion of the excess capacity available to the database system to be used to perform other activities not associated with the learning about optimization of execution of the database queries in the database environment. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
-
-
14. A device that includes one or more processors configured to:
-
learn about optimization of execution of one or more selected database queries that do not meet at least one performance criteria associated with a target performance for processing the one or more selected database queries with the limited capacity in a database environment, by using excess capacity of a database system configured to operate at a limited capacity below its full capacity, wherein the database system is operable to process data stored in the database in the database environment; allow at least a portion of the excess capacity available to the database system to be used to perform one or more learning activities associated with learning about optimization of execution of one or more selected database queries that do not meet the at least one performance criteria in the database environment; and not allow the at least one portion of the excess capacity available to the database system to be used to perform other activities not associated with the learning about optimization of execution of the database queries in the database environment.
-
-
15. A non-transitory computer readable storage medium storing at least executable code for learning by using excess capacity of a database system configured to operate at a limited capacity below its full capacity, wherein the database system includes one or more processors operable to process data stored in the database in a database environment, and wherein the executable code includes:
-
executable code that learns about optimization of execution of one or more selected database queries that do not meet at least one performance criteria associated with a target performance for processing the one or more selected database queries with the limited capacity in the database environment; executable code that allows at least a portion of the excess capacity available to the database system to be used to perform one or more learning activities associated with learning about optimization of execution of the one or more selected database queries that do not meet at least one performance criteria in the database environment; and executable code that does not allow the at least one portion of the excess capacity available to the database system to be used to perform other activities not associated with the learning about optimization of execution of the one or more selected database queries in the database environment. - View Dependent Claims (16, 17, 18, 19)
-
Specification