Back to results
US 12,743,345 B2Granted
Systems and methods for data recovery
AssigneeSap SE
InventorDirk Thomsen
Life of this patent
Estimating the term…
Abstract
Embodiments of the present disclosure include techniques for recovering data. In one embodiment, data is copied to a buffer. A plurality of processing functions receive the data in the buffer as data pages and perform processing operations. The processed data pages are then stored in persistent memory. The main memory is monitored so that the main memory of the database is maintained in a state such that a consistent flow of data may be written to persistent memory during the recovery process.
Claims20
A method of data recovery for a database system, the method comprising:
- retrieving data from a backup data storage medium, wherein the data was previously backed up to the backup data storage medium from the database system;
- storing the data in a buffer;
- retrieving data pages of the data from the buffer into a main memory of the database system;
- performing, in parallel, a plurality of checksum validation jobs on the data pages in the main memory to produce processed data pages;
- storing the processed data pages in the main memory and subsequently writing the processed data pages from the main memory to a persistent memory of the database system, thereby restoring the data to the database system;
- and
- adjusting a number of the plurality of checksum validation jobs being performed in parallel based on an available capacity of the main memory so that the available capacity of the main memory is kept between first and second thresholds during the data recovery,
- wherein adjusting the number of the plurality of checksum validation jobs based on the available capacity of the main memory is prioritized over adjusting the number of the plurality of checksum validation jobs based on a number of tasks in one or more queues.
5 more elements
A computer system comprising:
- at least one processor;
- at least one non-transitory computer readable medium storing computer executable instructions that, when executed by the at least one processor, cause the computer system to perform a method of data recovery for a database system comprising:
- retrieving data from a backup data storage medium, wherein the data was previously backed up to the backup data storage medium from the database system;
- storing the data in a buffer;
- retrieving data pages of the data from the buffer into a main memory of the database system;
- performing, in parallel, a plurality of checksum validation jobs on the data pages in the main memory to produce processed data pages;
- storing the processed data pages in the main memory and subsequently writing the processed data pages to a persistent memory of the database system, thereby restoring the data to the database system;
- and
- adjusting a number of the plurality of checksum validation jobs being performed in parallel based on an available capacity of the main memory so that the available capacity of the main memory is kept between first and second thresholds during the data recovery,
- wherein adjusting the number of the plurality of checksum validation jobs based on the available capacity of the main memory is prioritized over adjusting the number of the plurality of checksum validation jobs based on a number of tasks in one or more queues.
7 more elements
A non-transitory computer-readable medium storing computer-executable instructions that, when executed by at least one processor, perform a method of data recovery for a database system, the method comprising:
- retrieving data from a backup data storage medium, wherein the data was previously backed up to the backup data storage medium from the database system;
- storing the data in a buffer;
- retrieving data pages of the data from the buffer into a main memory of the database system;
- performing, in parallel, a plurality of checksum validation jobs on the data pages in the main memory to produce processed data pages;
- and
- storing the processed data pages in the main memory and subsequently writing the processed data pages from the main memory to a persistent memory of the database system, thereby restoring the data to the database system;
- and
- adjusting a number of the plurality of checksum validation jobs being performed in parallel based on an available capacity of the main memory so that the available capacity of the main memory is kept between first and second thresholds during the data recovery,
- wherein adjusting the number of the plurality of checksum validation jobs based on the available capacity of the main memory is prioritized over adjusting the number of the plurality of checksum validation jobs based on a number of tasks in one or more queues.
6 more elements
Dependencies are inferred from the claim text.