Estimating database modification
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.
1. A computer-implemented method comprising:
identifying one or more database modification statements;
identifying 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;
identifying 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;
determining an anticipated operational size, said anticipated operational size being an estimated total number of said one or more operational unit indicators;
determining 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
determining 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.
2. The computer-implemented method of claim 1 , further comprising formatting the contents of said one or more recovery logs, wherein said formatting comprises marking said one or more operational unit indicators within said one or more recovery logs as separate from one another.
3. The computer-implemented method of claim 1 , wherein said one or more operational unit indicators comprise one or more recovery log records.
4. The computer-implemented method of claim 1 , wherein said one or more operational unit indicators comprise one or more recovery log control intervals.
5. The computer-implemented method of claim 1 , further comprising:
receiving one or more progress indicators, said one or more progress indicators denoting the total number of said one or more operational unit indicators successfully generated; and
determining a progress ratio indicator based on said anticipated operational size and said one or more progress indicators.
6. The computer-implemented method of claim 1 , wherein:
said one or more database modification statements comprise one or more elements selected from the group consisting of one or more update statements and one or more delete statements; and
determining said anticipated operational size comprises accessing one or more pieces of statistic information.
7. The computer-implemented method of claim 1 , wherein:
said one or more database modification statements comprise one or more insert statements; and
said anticipated operational size is one.
8. The computer-implemented method of claim 1 , wherein:
said one or more operational unit indicators comprise operational unit indicators of a first type and operational unit indicators of a second type; and
determining said anticipated operational throughput rate further comprises averaging values of a rate at which said first type of operational unit indicators are generated and a rate at which said second type of operational unit indicators are generated.
9. The computer-implemented method of claim 8 , wherein:
said one or more operational unit indicators further comprise operational unit indicators of a third type;
said averaged values further comprise a rate at which said third type of operational unit indicators are generated; and
said one or more operational unit indicators of said first type, said second type, and said third type comprise one or more log records, one or more log control intervals, and one or more affected rows.
10. The computer-implemented method of claim 1 , wherein determining said anticipated total execution time of said one or more database modification statements is further based on an adjustment factor, wherein said adjustment factor is based on respective adjustment values for each of said one or more database modification statements.