Database management system backup and recovery management

Patent metadata

Field	Value
Publication number	US-11537476-B2
Application number	US-202016829531-A
Country	US
Kind code	B2
Filing date	Mar 25, 2020
Priority date	Mar 25, 2020
Publication date	Dec 27, 2022
Grant date	Dec 27, 2022

Abstract

According to some embodiments, a system to manage database management system backups may include a plurality of database services. For each database service, a database backup resource (e.g., a human-readable structured document) may specify desired backup state information (e.g., a buffer size, a schedule, an amount of memory, etc.). A stateless backup operator component may then compare a present backup state of each database service with the associated desired backup state information. When a mismatch is identified between the present backup state of a database service and the associated desired backup state information, that database service may be automatically reconfigured (e.g., in connection with a recover job, backup job, backup configuration job, keystore backup job, etc.) in accordance with the desired backup state information.

First claim

The invention claimed is:

1. A system to manage database management system backups, comprising:
a plurality of database services;
for each database service, a database backup resource that specifies desired backup state information associated with a recovery point objective and recovery time objective of a database service level agreement, wherein the desired backup state information includes backup and recovery operations along with data associated with a keystore backup job that provides database backup privacy and security; and
a stateless backup operator component, including:
a computer processor, and
a computer memory coupled to the computer processor and storing instructions that, when executed by the computer processor, cause the stateless backup operator component to compare a present backup state of each database service with the associated desired backup state information,

wherein when a mismatch is identified between the present backup state of a database service and the associated desired backup state information, that database service is automatically reconfigured in accordance with the desired backup state information.

2. The system of claim 1 , wherein the backup resource comprises a human-readable structured document.

3. The system of claim 1 , wherein the desired backup state information includes configuration information.

4. The system of claim 1 , wherein the desired backup state information includes database key information.

5. The system of claim 1 , wherein the stateless backup operator component periodically performs said comparison in regular intervals.

6. The system of claim 1 , wherein the stateless backup operator component is scaled up responsive to a load increase.

7. The system of claim 1 , wherein the stateless backup operator component is restarted responsive to a failure without impacting an availability of an associated database service.

8. The system of claim 1 , further comprising:
a database services provider to create at least one database backup resource in response to a request received from a user.

9. The system of claim 1 , wherein the plurality of databases is associated with a hyper-scalar environment.

10. A computer-implemented method to manage database management system backups, comprising:
for each of a plurality of database services, specifying a database backup resource that indicates desired backup state information associated with a recovery point objective and recovery time objective of a database service level agreement, wherein the desired backup state information includes backup and recovery operations along with data associated with a keystore backup job that provides database backup privacy and security;
comparing, by a stateless backup operator component, a present backup state of each database service with the associated desired backup state information; and
when a mismatch is identified between the present backup state of a database service and the associated desired backup state information, automatically reconfiguring that database service in accordance with the desired backup state information.

11. The method of claim 10 , wherein the backup resource comprises a human-readable structured document.

12. The method of claim 10 , wherein the desired backup state information includes database key information.

13. A non-transient, computer-readable medium storing instructions to be executed by a processor to perform a method to manage database management system backups, the method comprising:
for each of a plurality of database services, specifying a database backup resource indicating desired backup state information associated with a recovery point objective and recovery time objective of a database service level agreement, wherein the desired backup state information includes backup and recovery operations along with data associated with a keystore backup job that provides database backup privacy and security;
comparing, by a stateless backup operator component, a present backup state of each database service with the associated desired backup state information; and
when a mismatch is identified between the present backup state of a database service and the associated desired backup state information, automatically reconfiguring that database service in accordance with the desired backup state information.

14. The medium of claim 13 , wherein the stateless backup operator component periodically performs said comparison in regular intervals.

15. The medium of claim 13 , wherein the stateless backup operator component is scaled up responsive to a load increase.

16. The medium of claim 13 , wherein the stateless backup operator component is restarted responsive to a failure without impacting an availability of an associated database service.

Assignees

• Sap Se

Inventors

• Brunzema Martin
• Roessiger Anne
• Hempelmann Henrik
• Klus Benedikt
• Voss Stefan
• Kirmse Daniel

Classifications

• G06F11/1448 Primary

  Management of the data involved in backup or backup restore · CPC title

• G06F11/1469 Primary

  Backup restoration techniques · CPC title

• G06F2201/80

  Database-specific techniques · CPC title

• G06F11/1438

  Restarting or rejuvenating · CPC title

• G06F16/2365

  Ensuring data consistency and integrity · CPC title