IP Library Granted Patent US 11,886,277
Granted Patent B2
US 11,886,277 · App. 17/657,463 · Granted Jan 30, 2024

Systems, apparatuses, and methods for assessing recovery viability of backup databases

Inventor: Rene Cacheaux (Austin, TX)
Assignees: ATLASSIAN PTY LTD.; ATLASSIAN, INC.
G06F11/008G06F11/1451G06F11/1458G06F16/26
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 11,886,277
App. No.
17/657,463
Granted
Jan 30, 2024
Kind
B2
Abstract

Apparatuses and methods for assessing the recovery viability of backup databases are provided. Some embodiments may include identifying a selected backup database set from the plurality of backup databases. In some embodiments, each backup database in the selected backup database set is associated with a database in a corresponding database set. Some embodiments may include triggering a first backup configuration check operation for each database in the corresponding database set. Some embodiments may include triggering a restore verification operation for each database in the selected backup database set. Some embodiments may include generating a recovery point objective score for each database in the selected backup database set. Some embodiments may include causing updating of a recovery point objective score interface based on the recovery point objective score for each database in the selected backup database set.

Claims (50)

1. An apparatus configured for assessing recovery viability for a plurality of backup databases, the apparatus comprising at least a processor, and a memory associated with the processor having computer coded instructions therein, with the computer coded instructions configured to, when executed by the processor, cause the apparatus to:

identify a selected backup database set from the plurality of backup databases, wherein each backup database in the selected backup database set is associated with a database in a corresponding database set;

select a first backup configuration check operation from a plurality of backup configuration check operations based on the corresponding database set;

trigger the first backup configuration check operation for each database in the corresponding database set;

trigger a restore verification operation for each database in the selected backup database set;

generate a recovery point objective score for each database in the selected backup database set, wherein the recovery point objective score is determined based on the first backup configuration check operation and the restore verification operation; and

generate a recovery point objective score interface based on the recovery point objective score for each database in the selected backup database set.

2. The apparatus of claim 1 , wherein the first backup configuration check operation produces a backup configuration check score for each database in the corresponding database set.

3. The apparatus of claim 2 , further configured to:

generate a backup configuration check interface based on the backup configuration check score for each database in the corresponding database set.

4. The apparatus of claim 2 , wherein the restore verification operation produces a restore verification status score for each database in the selected backup database set.

5. The apparatus of claim 4 , further configured to:

generate a restore verification status interface based on the restore verification status score for each database in the selected backup database set.

6. The apparatus of claim 5 , wherein the recovery point objective score is based on the backup configuration check score and the restore verification status score.

7. The apparatus of claim 1 , wherein the corresponding database set comprises a first database type.

8. The apparatus of claim 1 , wherein the first backup configuration check operation comprises:

extracting metadata for each database in the corresponding database set;

generating a database configuration metadata structure comprising a plurality of configuration records each representative of a configuration setting for a respective database, and each comprising a configuration value; and

parsing the database configuration metadata structure to identify whether the configuration value of each configuration record meets a pre-defined configuration value.

9. The apparatus of claim 1 , wherein in response to receiving an input selection from a user, the apparatus is further configured to:

cause rendering of the recovery point objective score interface.

10. A method of assessing recovery viability for a plurality of backup databases, the method comprising:

identifying a selected backup database set from the plurality of backup databases, wherein each backup database in the selected backup database set is associated with a database in a corresponding database set;

selecting a first backup configuration check operation from a plurality of backup configuration check operations based on the corresponding database set;

triggering the first backup configuration check operation for each database in the corresponding database set;

triggering a restore verification operation for each database in the selected backup database set;

generating a recovery point objective score for each database in the selected backup database set, wherein the recovery point objective score is determined based on the first backup configuration check operation and the restore verification operation; and

generating a recovery point objective score interface based on the recovery point objective score for each database in the selected backup database set.

11. The method of claim 10 , wherein the first backup configuration check operation produces a backup configuration check score for each database in the corresponding database set.

12. The method of claim 11 , further comprising:

generating a backup configuration check interface based on the backup configuration check score for each database in the corresponding database set.

13. The method of claim 11 , wherein the restore verification operation produces a restore verification status score for each database in the selected backup database set.

14. The method of claim 13 , further comprising:

generating a restore verification status interface based on the restore verification status score for each database in the selected backup database set.

15. The method of claim 14 , wherein the recovery point objective score is based on the backup configuration check score and the restore verification status score.

16. The method of claim 10 , wherein the corresponding database set comprises a first database type.

17. The method of claim 10 , wherein the first backup configuration check operation comprises:

extracting metadata for each database in the corresponding database set;

generating a database configuration metadata structure comprising a plurality of configuration records each representative of a configuration setting for a respective database, and each comprising a configuration value; and

parsing the database configuration metadata structure to identify whether the configuration value of each configuration records meets a pre-defined configuration value.

18. The method of claim 10 , wherein in response to receiving an input selection from a user, the method further comprises:

causing rendering of the recovery point objective score interface.

19. An apparatus comprising at least a processor, and a memory associated with the processor having computer coded instructions therein, with the computer coded instructions configured to, when executed by the processor, cause the apparatus to:

cause rendering of a backup database recovery viability interface, the backup database recovery viability interface configured to receive an input selecting a selected backup database set from a plurality of backup databases, wherein each database in the selected backup database set is associated with a database in a corresponding database set, the backup database recovery viability interface comprising:

a backup configuration check interface based on a backup configuration check score for each database in the corresponding database set;

a restore verification status interface based on a restore verification status score for each database in the selected backup database set; and

a recovery point objective score interface based on a recovery point objective score for each database in the selected backup database set, wherein the recovery point objective score is based on the backup configuration check score and the restore verification status score.

20. The apparatus of claim 19 , wherein the backup configuration check score for each database in the selected backup database set is calculated by performing a backup configuration check operation on each database in the corresponding database set.

21. The apparatus of claim 19 , wherein the restore verification status score for each database in the selected backup database set is calculated by performing a restore verification operation on each database in the selected backup database set.

22. The apparatus of claim 19 , wherein the corresponding database set comprises a first database type.

Assignments (3)
CORRECTIVE ASSIGNMENT TO CORRECT THE ASSIGNMENT COVER SHEET TO CORRECT THE ASSIGNEE NAME FROM ATLASSIAN (US) LLC TO ATLASSIAN US, INC. PREVIOUSLY RECORDED ON REEL 66029 FRAME 622. ASSIGNOR(S) HEREBY CONFIRMS THE CHANGE OF NAME. Recorded Oct 24, 2024
From: ATLASSIAN, INC.
To: ATLASSIAN US, INC.
Reel/Frame 069267/0923 →
CHANGE OF NAME Recorded Dec 14, 2023
From: ATLASSIAN, INC.
To: ATLASSIAN (US) LLC
Reel/Frame 066029/0622 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Mar 31, 2022
From: CACHEAUX, RENE
To: ATLASSIAN PTY LTD.; ATLASSIAN INC.
Reel/Frame 059460/0523 →
Continuity (1)
Related Publication 20230315552A1 · Oct 5, 2023