US 10,255,313 B2Granted

Estimating database modification

AssigneeInternational Business Machines Corporation

InventorsTing Xu Guan, Shuo Li, Ping Liang, Ke Wei Wei, Xin Ying Yang

Life of this patent

Estimating the term…

Loading patent…

Abstract

A computer-implemented method includes identifying one or more database modification statements and identifying one or more operational unit indicators. The one or more operation unit indicators are caused to be generated by the one or more database modification statements. An anticipated operational size is determined. The anticipated operational size is an estimated total number of the one or more operational unit indicators. An anticipated operational throughput rate is determined. The anticipated operational throughput rate is a rate at which the operational unit indicators are expected to be generated. An anticipated total execution time of the one or more database modification statements is determined based on the anticipated operational size and the anticipated operational throughput rate. A corresponding computer program product and computer system are also disclosed.

Claims20

Dependent claims

A computer program product, comprising:

one or more computer readable storage media and program instructions stored on said one or more computer readable storage media, said program instructions comprising instructions to:
identify one or more database modification statements;
identify one or more recovery logs, said one or more recovery logs being caused to be generated as a result of execution of said one or more database modification statements;
identify one or more operational unit indicators within said one or more recovery logs, said one or more operational unit indicators being caused to be generated within said one or more recovery logs as a result of execution of said one or more database modification statements;
determine an anticipated operational size, said anticipated operational size being an estimated total number of said one or more operational unit indicators;
determine an anticipated operational throughput rate, said anticipated operational throughput rate being a rate at which said one or more operational unit indicators are expected to be generated within said one or more recovery logs, said anticipated operational throughput rate being based on a number of operational units generated within said one or more recovery logs during a particular time interval;
and
determine an anticipated total execution time of said one or more database modification statements based on said anticipated operational size and said anticipated operational throughput rate.

5 more elements

A computer system, comprising:

a processor;
one or more computer readable storage media;
computer program instructions;
said computer program instructions being stored on said one or more computer readable storage media;
and
said computer program instructions comprising instructions to:
identify one or more database modification statements;
identify one or more recovery logs, said one or more recovery logs being caused to be generated as a result of execution of said one or more database modification statements;
identify one or more operational unit indicators within said one or more recovery logs, said one or more operational unit indicators being caused to be generated within said one or more recovery logs as a result of execution of said one or more database modification statements;
determine an anticipated operational size, said anticipated operational size being an estimated total number of said one or more operational unit indicators;
determine an anticipated operational throughput rate, said anticipated operational throughput rate being a rate at which said one or more operational unit indicators are expected to be generated within said one or more recovery logs, said anticipated operational throughput rate being based on a number of operational units generated within said one or more recovery logs during a particular time interval;
and
determine an anticipated total execution time of said one or more database modification statements based on said anticipated operational size and said anticipated operational throughput rate.

10 more elements

Dependencies are inferred from the claim text.