System and method for procedure for point-in-time recovery of cloud or database data and records in whole or in part

• US 10,540,237 B2
• Filed: 11/05/2018
• Issued: 01/21/2020
• Est. Priority Date: 09/16/2015
• Status: Active Grant

• Current Assignee: Sesame Software, Inc.
• Original Assignee: Sesame Software, Inc.
• Inventors: Banister, Richard
• Primary Examiner(s): Chau, Dung K
• Application Number:
  US16/181,338
• Publication Number:
  US 20190102258A1
• Time in Patent Office: 442 Days
• Field of Search: 707685, 707679, 707999204
• CPC Class Codes: G06F 11/1451 by selection of backup contents
• CPC Class Codes: G06F 16/113 Details of archiving lifecycle management in storage systems G06F3/0649; backup systems G06F11/1446
• CPC Class Codes: G06F 16/273 Asynchronous replication or reconciliation
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: G06F 2201/80 Database-specific techniques
• CPC Class Codes: G06F 2201/805 Real-time
• CPC Class Codes: G06F 2201/82 Solving problems relating to consistency ensuring consistency in mirrored systems G06F11/2064
• CPC Class Codes: G06F 3/04847 Interaction techniques to control parameter settings, e.g. interaction with sliders or dials

Abstract

A user interface, system and method are provided for the recovery and restoration of software records or elements thereof to earlier record or data iterations or versions in order to overcome or repair consequences of database corruption or data deletion. A source database and/or a current archive database further enable recording of records of the source database to an historical data archive, from which records or elements thereof may be recovered. A restore command is detectable by the system as directly input via a user interface and/or as sent via an electronics communications modality or network. The databases and archives may have access to multiple iterations/versions of a record including the original record version as stored in an historical archive or elsewhere in a network. The records may optionally be updated in a batch method, in real time, and/or as the software records are created.

Claims

1. A system comprising:

a non-transitory memory comprising a current copy of a source database, a current data archive and a historical data archive, wherein the historical data archive comprises prior versions of a plurality of records previously received via the current data archive;

a display device;

an input channel receiving selections and selection data; and

one or more processors communicatively coupled with the memory, the display device and the input channel, and the one or more processors configured to perform operations comprising;

displaying a first user interface element on the display device, the first user interface element enabling a receipt from the input channel of a date and time range to filter records by update time stamps as are individually associated with each record of a record archive;

displaying a second user interface element on the display device, the second user interface element enabling a receipt from the input channel of one or more record types to include in a record recovery action;

displaying a third user interface element on the display device, the third user interface element displaying a listing of a plurality of record types and enabling a receipt from the input channel each displayed record type for inclusion in a record recovery action;

displaying a fourth user interface element on the display device, the fourth user interface element displaying and enabling a receipt from the input channel of an additional plurality of records from a plurality of relationally related records present in the current data archive in separated lists for each distinguishable record type;

displaying a fifth user interface element on the display device, the fifth user interface element displaying and enabling a receipt from the input channel of a specific version of a record from the historical data archive for a given record present in the current data archive;

generating a recording of a recovery workflow specifying selected records for use by an information recovery process;

copying each record specified in the information recovery workflow from the current data archive into the historical data archive;

updating specified records into the corresponding records in the current data archive;

setting a recovery status field flag in records updated in the current data archive in accordance with the recovery workflow; and

updating the source database in accordance with each record updated in the current data archive by using the recovery status field flag as an indicator of whether to newly create records or update source database records specified in the recovery workflow.

2. The system of claim 1, wherein the current data archive comprises the source database.

3. The system of claim 1, wherein the source database is at least partially maintained in a remote database server accessible via an electronics communications network.

4. The system of claim 1, wherein the current data archive comprises a relational database.

5. The system of claim 1, wherein the current data archive comprises an object-oriented database.

6. The system of claim 1, wherein the current data archive comprises a NoSQL database.

7. The system of claim 1, wherein the historical data archive is at least partially maintained in a remote database server accessible via an electronics communications network.

8. The system of claim 1, wherein the historical data archive comprises a relational database.

9. The system of claim 1, wherein the historical data archive comprises an object-oriented database.

10. The system of claim 1, wherein the historical data archive comprises a NoSQL database.

11. The system of claim 1, wherein the list of all available records is limited to records which match specified value ranges of a searchable field.

12. The system of claim 1, wherein a plurality of fields is selected from at least one record displayed in the current data archive.

13. The system of claim 1, wherein a plurality of fields is selected from a displayed plurality of records displayed via the display device as rendered from the historical data.

14. The system of claim 1, wherein a plurality of fields is selected from a plurality of relationally related records displayed by reference or content in the current data archive.

15. The system of claim 1, wherein the update time stamp is less than a specified point-in-time range for each unique record identifier, and there are no newer records with a matching unique record identifier comprising an update timestamp that is less than the specified point-in-time range.

16. The system of claim 1, wherein the current data archive is comprised within the source database.

17. The system of claim 1, wherein the current data archive is at least partially maintained in a database server accessible via an electronics communications network.

18. The system of claim 17, is at least partially maintained in a database server accessible via an electronics communications network.

19. The system of claim 1, wherein the current data archive is comprised within a database.

20. The system of claim 1, wherein the historical data archive is comprised within a database.