Method and system for scheduling workload in databases
View Patent ↗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.
1. A computer-implemented method for scheduling a workload comprising a plurality of transactions relating to a database management system, said method comprising the steps of:
determining an available amount of transaction log space,
determining a transaction log space amount required by each transaction in said workload;
estimating the total transaction log space required for executing said workload based on the transaction log space amounts required by each transaction;
scheduling execution of said workload on said database management system based on said estimated total required transaction log space, wherein the transaction log space remains unchanged; and
executing said workload on said database management system,
wherein said transactions comprise one or more queries on said database management system,
wherein the transaction log space amounts required by said transactions are determined based on a learned model,
wherein said step of scheduling execution of said workload comprises scheduling execution of each transaction in said workload,
wherein said step of scheduling execution of said workload comprises determining a time to execute each of said transactions, and
wherein execution of said transactions is scheduled such that the estimated total transaction log space required for executing said workload is less than said amount of available transaction log space.