Invention Grant
- Patent Title: Automatic adoption of parallelized database garbage collection
-
Application No.: US15647045Application Date: 2017-07-11
-
Publication No.: US10481986B2Publication Date: 2019-11-19
- Inventor: Dirk Thomsen , Christoph Roterring , Thorsten Glebe
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Jones Day
- Main IPC: G06F11/14
- IPC: G06F11/14 ; G06F12/02 ; G06F16/23

Abstract:
Recovery of a database system by taking the database system offline is initiated. Thereafter, recovery operations specified by a redo log of the database system are replayed. A cleanup log is generated that identifies cleanup operations occurring during the replay of the recovery operations for garbage collection. Concurrent with the startup of the database, garbage collection of the cleanup operations as specified in the database savepoint is initiated. In addition, concurrent with the replay of the recovery operations, garbage collection of the cleanup operations specified by the cleanup log is initiated. The amount of parallelization of the garbage collection can be varied based on utilized processor resources. The database system is later brought online after all of the recovery operations are replayed.
Public/Granted literature
- US20190018742A1 Automatic Adoption of Parallelized Database Garbage Collection Public/Granted day:2019-01-17
Information query