Method and system for scheduling workload in databases
AssigneeInternational Business Machines Corporation
InventorsLaurent Sebastien Mignet, Sourashis Roy, Torsten Steinbach, Ranga Raju Vatsavai
Life of this patent
Estimating the term…
Abstract
A method for scheduling a workload comprising a plurality of transactions relating to a database management system is disclosed. The method comprises the steps of determining a log space amount required by each transaction in the workload, estimating the total log space required for executing the workload based on the log space amounts required by each transaction, and scheduling execution of the workload based on the estimated total log space.
Claims24
A method for scheduling a workload comprising a plurality of transactions relating to a database management system, said method comprising the steps of:
- determining a log space amount required by each transaction in said workload;
- estimating the total log space required for executing said workload based on the log space amounts required by each transaction;
- and
- scheduling execution of said workload based on said estimated total log space.
A system for scheduling a workload comprising a plurality of transactions relating to a database management system, said system comprising a memory unit for storing data and instructions to be performed by a processing unit and a processing unit coupled to said memory unit, said processing unit configured to:
- determine a log space amount required by each transaction in said workload;
- estimate the total log space required for executing said workload based on the log space amounts required by each transaction;
- and
- schedule execution of said workload based on said estimated total log space.
A product comprising a recording means for scheduling workload comprising a plurality of transactions relating to a database management system, said product configured for:
- determining a log space amount required by each transaction in said workload;
- estimating the total log space required for executing said workload based on the log space amounts required by each transaction;
- and
- scheduling execution of said workload based on said estimated total log space;
- wherein said transactions comprise one or more queries on said database management system.
A computer program product comprising a computer readable medium comprising a computer program recorded therein for scheduling a workload comprising a plurality of transactions relating to a database management system, said computer program product comprising:
- computer software program code for determining a log space amount required by each transaction in said workload;
- computer software program code for estimating the total log space required for executing said workload based on the log space amounts required by each transaction;
- and
- computer software program code for scheduling execution of said workload based on said estimated total log space.
Dependencies are inferred from the claim text.