Patent ID: 9582337
Date: 2017-02-28
CPC Classifications: G06F

Claim:
1. A method, comprising: monitoring, by a database operating in an operating system on a computer, one or more database transactions, the monitoring including determining resource usage statistics for the one or more database transactions, the resource usage statistics indicating amounts of computing resources being used by each database transaction; obtaining, by the database, one or more rules, each rule specifying a respective condition for triggering reduction of consumption of the computing resources for each of one or more database transactions and a respective value indicating an amount of computing resources to reduce; first identifying a database transaction in the database and by the database, including determining, based on the resource usage statistics and a first rule of the one or more rules, that resource usage statistics of the database transaction satisfy a condition specified by the first rule; communicating, by the database, the first identifying to the operating system; second identifying the database transaction in the operating system and by the operating system responsive to the communicating of the first identifying to the operating system, the second identifying including determining, by the operating system, a process, sub process or thread that runs and manages the database transaction in the operating system; and managing, by the operating system and in the operating system, the process, sub process or thread, including reducing, according to the value specified in the first rule, computer resources allocated to the process, sub process or thread, wherein reducing the computer resources allocated to the process, sub process or thread in the operating system comprises periodically suspending and resuming the process, sub process or thread at a predetermined frequency for a plurality of repetitions until the database transaction finishes, wherein the predetermined frequency of the suspending and the resuming in the plurality of repetitions is configured to correspond to the value specified in the first rule, and wherein the predetermined frequency is specified in the first rule.