# US 12,001,292 B2 · Backup housekeeping operations between database management systems and external storage > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 12,001,292 B2 - Document ID: US12001292B2 - Status: Granted - Kind: B2 - Application number: 16/829,463 - Filed: 2020-03-25 - Published: 2021-09-30 - Granted: 2024-06-04 - Earliest claimed: 2020-03-25 - Assignees: Sap SE - Applicants: Sap SE - Inventors: Henrik Hempelmann; Anne Roessiger; Benedikt Klus; Martin Brunzema; Stefan Voss - Web page: https://patentgrep.com/patent/US12001292B2 ## CPC - G06F 11/1464: {for networked environments} - G06F 11/1451: {by selection of backup contents} - G06F 11/1461: {Backup scheduling policy} - G06F 11/1469: {Backup restoration techniques} - G06F 16/122: {using management policies (point-in-time backing up or restoration of persistent data G06F11/1446; file migration policies for HSM systems G06F16/185)} - G06F 16/1734: {Details of monitoring file system events, e.g. by the use of hooks, filter drivers, logs} - G06F 2201/80: Database-specific techniques - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## 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. ## Claims ### Claim 1 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. ### Claim 2 (depends on 1) The system of claim 1, wherein the backup housekeeping component is part of a storage system associated with the external storage component. ### Claim 3 (depends on 1) The system of claim 1, wherein the external storage component stores a plurality of database management system backup objects for a customer. ### Claim 4 (depends on 3) The system of claim 3, wherein the external storage component stores a plurality of database management system backup objects for a plurality of customers. ### Claim 5 (depends on 1) The system of claim 1, wherein the backup requirement information is associated with at least one of: (i) a maximum backup age, (ii) a latest backup identifier, and (iii) an indication of a newest backup to be deleted. ### Claim 6 (depends on 1) The system of claim 1, wherein the backup housekeeping component is further to transmit, to the database management system node, a confirmation that the first database management system backup object has been deleted. ### Claim 7 (depends on 6) The system of claim 6, wherein the database management system node updates a database backup catalog in response to the confirmation received from the backup housekeeping component. ### Claim 8 (depends on 1) The system of claim 1, wherein the database management system node is associated with a database as a service cluster of a hyper-scaler infrastructure. ### Claim 9 (depends on 1) The system of claim 1, wherein a backup housekeeping strategy of the backup housekeeping component is updated. ### Claim 10 A computer-implemented method to manage database management system backup objects, 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. ### Claim 11 (depends on 10) The method of claim 10, wherein the backup housekeeping component is part of a storage system associated with the external storage component. ### Claim 12 (depends on 10) The method of claim 10, wherein the external storage component stores a plurality of database management system backup objects for a customer. ### Claim 13 (depends on 12) The method of claim 12, wherein the external storage component stores a plurality of database management system backup objects for a plurality of customers. ### Claim 14 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. ### Claim 15 (depends on 14) The medium of claim 14, wherein the backup requirement information is associated with at least one of: (i) a maximum backup age, (ii) a latest backup identifier, and (iii) an indication of a newest backup to be deleted. ### Claim 16 (depends on 14) The medium of claim 14, wherein the backup housekeeping component is further to transmit, to the database management system node, a confirmation that the first database management system backup object has been deleted. ### Claim 17 (depends on 16) The medium of claim 16, wherein the database management system node updates a database backup catalog in response to the confirmation received from the backup housekeeping component. ### Claim 18 (depends on 14) The medium of claim 14, wherein the database management system node is associated with a database as a service cluster of a hyper-scaler infrastructure. ### Claim 19 (depends on 14) The medium of claim 14, wherein a backup housekeeping strategy of the backup housekeeping component is updated.