Back to results
US 10,402,389 B2Granted
Automatic adaptation of parameters controlling database savepoints
AssigneeSap SE
InventorsDirk Thomsen, Christoph Roterring, Werner Thesing
Life of this patent
Estimating the term…
Abstract
Each of a plurality of database transactions are logged (i.e., recorded) in a log. Concurrent with the logging, one or more characteristics of the log are monitored. Thereafter, a savepoint is triggered when a pre-defined condition is met as indicated by the monitoring. The triggered savepoint can override or accelerate a savepoint that would have otherwise been triggered based on pre-specified parameters.
Claims19
A computer-implemented method comprising:
- logging each of a plurality of database transactions for a database system in a log;
- monitoring, concurrent with the logging, one or more characteristics of the log;
- and
- triggering, based on the monitoring, a savepoint for use in recovering the database system when a pre-defined condition is met;
- wherein:
- the savepoint comprises a pre-critical phase, a critical phase, and a post-critical phase;
- in the pre-critical phase all modified pages are iterated through and flushed to physical persistence;
- in the critical phase all parallel updates are blocked and all remaining I/O is triggered to ensure a consistent state of data;
- all remaining I/O is waited for in the post-critical phase;
- and
- based on such monitoring, the savepoint is triggered to minimize critical phase time;
- wherein the monitoring monitors (i) an amount of log generated, (ii) filling of specific log areas, (iii) a number and/or size of modified pages which need to be written to disk, and (iv) and times measured for previous savepoints.
9 more elements
A system comprising:
- at least one processor;
- and
- memory storing instructions which, when executed by the at least one processor, result in operations comprising:
- logging each of a plurality of database transactions for a database system in a log;
- monitoring, concurrent with the logging, one or more characteristics of the log;
- and
- triggering, based on the monitoring, a savepoint for use in recovering the database system when a pre-defined condition is met;
- wherein:
- the savepoint comprises a pre-critical phase, a critical phase, and a post-critical phase;
- in the pre-critical phase all modified pages are iterated through and flushed to physical persistence;
- in the critical phase all parallel updates are blocked and all remaining I/O is triggered to ensure a consistent state of data;
- all remaining I/O is waited for in the post-critical phase;
- and
- based on such monitoring, the savepoint is triggered to minimize critical phase time;
- wherein the monitoring monitors (i) an amount of log generated, (ii) filling of specific log areas, (iii) a number and/or size of modified pages which need to be written to disk, and (iv) and times measured for previous savepoints.
12 more elements
A non-transitory computer program product storing instructions which, when executed by at least one data processor, result in operations comprising:
- logging each of a plurality of database transactions for a database system in a log;
- monitoring, concurrent with the logging, one or more characteristics of the log;
- and
- triggering, based on the monitoring, a savepoint for use in recovering the database system when a pre-defined condition is met;
- wherein:
- the savepoint comprises a pre-critical phase, a critical phase, and a post-critical phase;
- in the pre-critical phase all modified pages are iterated through and flushed to physical persistence;
- in the critical phase all parallel updates are blocked and all remaining I/O is triggered to ensure a consistent state of data;
- all remaining I/O is waited for in the post-critical phase;
- and
- based on such monitoring, the savepoint is triggered to minimize critical phase time;
- wherein the monitoring monitors (i) an amount of log generated, (ii) filling of specific log areas, (iii) a number and/or size of modified pages which need to be written to disk, and (iv) and times measured for previous savepoints.
9 more elements
Dependencies are inferred from the claim text.