US 12,001,292 B2Granted

Backup housekeeping operations between database management systems and external storage

AssigneeSap SE

InventorsHenrik Hempelmann, Anne Roessiger, Benedikt Klus, Martin Brunzema, Stefan Voss

Life of this patent

Estimating the term…

Loading patent…

Abstract

A system to manage database management system backup objects may include an external storage component storing a first database management system backup object. A database management system node (e.g., associated with a database as a service cluster of a hyper-scalar infrastructure) may be configured to write information to and read information from the external storage component without being able to delete information in the external storage component. A backup housekeeping component, independent of the database management system node, may trigger a request to retrieve backup requirement information (e.g., associated with a maximum backup age, a latest backup identifier, an indication of a newest backup to be deleted, etc.) from the database management system node. The backup housekeeping component may then delete all database management system backup objects in the external storage component that are no longer required, including the first database management object, based on the retrieved backup requirement information.

Claims19

Dependent claims

A system to manage database management system backup objects, comprising:

an external storage component storing at least a first database management system backup object;
a database management system node in a database management system, the database management system node being configured to write information to and read information from the external storage component;
and
a backup housekeeping component in the database management system, the backup housekeeping component being independent of the database management system node and configured to delete information in the external storage component, including:
a computer processor;
and
a computer memory, coupled to the computer processor, storing instructions that, when executed by the computer processor, cause the system to:
write information to and read information from the external storage component by the database management system node, wherein the database management system node is disallowed from deleting information in the external storage component;
trigger, by the backup housekeeping component, a request to retrieve backup requirement information from the database management system node, wherein the backup housekeeping component is disallowed to write information to and read information from the external storage component;
and
delete, by the backup housekeeping component, all database management system backup objects in the external storage component that are no longer required based on the retrieved backup requirement information from the database management system node, including the first database management object, based on the retrieved backup requirement information including an indication of the backup objects in the external storage component to delete.

8 more elements

A non-transitory, computer-readable medium storing instructions to be executed by a processor to perform a method to manage database management system backup objects, the method comprising:

writing information to and reading information from an external storage component storing at least a first database management system backup object by a processor of a database management system node in a database management system, wherein the database management system node is disallowed from deleting information in the external storage component;
triggering, by a computer processor of a backup housekeeping component in the database management system that is independent of the database management system node and configured to delete information in the external storage component and disallowed to write information to and read information from the external storage component, a request to retrieve backup requirement information from the database management system node;
and
deleting, by the computer processor of the backup housekeeping component, all database management system backup objects in the external storage component that are no longer required based on the retrieved backup requirement information from the database management system node, including the first database management object, based on the retrieved backup requirement information including an indication of the backup objects in the external storage component to delete.

1 more element

Dependencies are inferred from the claim text.

Facts

Application: 16/829,463Filed 25 Mar 2020
Published: US 2021/0303412 A130 Sep 2021
Granted: 4 Jun 2024
Term ends: Not estimatedThe source records don’t support an estimate.

Classification8 codes

G06F 11/1464
Management of the backup or restore process: for networked environments
G06F 11/1451
Management of the data involved in backup or backup restore: by selection of backup contents
G06F 11/1461
Management of the backup or restore process: backup scheduling policy
G06F 11/1469
Management of the backup or restore process: backup restoration techniques

Family

US 2021/0303412 A1Pre-grant publication · published 30 Sep 2021
US 12,001,292 B2This patent

From the US filing history. Foreign family members aren’t listed.

Timeline

Citations

Open elsewhere

Building an agent or pulling many patents? Use the API or MCP server instead of scraping pages. Get an API key