US 2025/0156280 A1 · DATA LINEAGE BASED MULTI-DATA STORE RECOVERY

Abstract

Embodiments disclosed herein provide systems, methods, and computer readable media for data lineage based multi-data store recovery. In a particular embodiment, a method provides identifying first data in a first table of a plurality of tables stored in a plurality of data stores and restoring the first data to a first correct version of the first data in a prior version of the first table. The method further provides identifying a second table of the plurality of tables that descends from the first table and includes second descendent data that stems from the first data. The method also provides restoring the second descendent data to a second correct version of the second descendent data in a prior version of the second table.

Claims20

Dependent claims

A method, comprising:

identifying that a first version of a first table of a plurality of tables comprises a corrupt version of first data;
identifying a prior version of the first table that comprises a correct version of the first data;
restoring the first data using the correct version of the first data from the prior version of the first table;
identifying a second table that descends from the first table, the second table including second data that is based at least in part on the corrupt version of the first data;
identifying, for the second table, a prior version of the second table that comprises a correct version of the second data that is based at least in part on the correct version of the first data;
and
restoring the second data using the correct version of the second data from the identified prior version of the second table.

4 more elements

A system, comprising:

one or more non-transitory computer readable storage media storing processor-executable instructions;
and
one or more processors coupled with the one or more non-transitory computer readable storage media, the one or more processors individually or collectively operable to execute the instructions to cause the system to:
identify that a first version of a first table of a plurality of tables comprises a corrupt version of first data;
identify a prior version of the first table that comprises a correct version of the first data;
restore the first data using the correct version of the first data from the prior version of the first table;
identify a second table that descends from the first table, the second table including second data that is based at least in part on the corrupt version of the first data;
identify, for the second table, a prior version of the second table that comprises a correct version of the second data that is based at least in part on the correct version of the first data;
and
restore the second data using the correct version of the second data from the identified prior version of the second table.

7 more elements

A non-transitory computer readable storage medium, comprising instructions executable by one or more hardware-implemented processors to cause a system to:

identify that a first version of a first table of a plurality of tables comprises a corrupt version of first data;
identify a prior version of the first table that comprises a correct version of the first data;
restore the first data using the correct version of the first data from the prior version of the first table;
identify a second table that descends from the first table, the second table including second data that is based at least in part on the corrupt version of the first data;
identify, for the second table, a prior version of the second table that comprises a correct version of the second data that is based at least in part on the correct version of the first data;
and
restore the second data using the correct version of the second data from the identified prior version of the second table.

4 more elements

Dependencies are inferred from the claim text.

Facts

Application

19/025,761Filed 16 Jan 2025

Priority

5 Jan 2015

Published

15 May 2025

Term ends

Not estimatedThe source records don’t support an estimate.

Classification6 codes

G06F 11/1451
Management of the data involved in backup or backup restore: by selection of backup contents
G06F 11/1469
Management of the backup or restore process: backup restoration techniques
G06F 16/219
Design, administration or maintenance of databases: managing data history or versioning
G06F 16/2329
Optimistic concurrency control: using versioning

Family

Application62/099,747Us provisional application · filed 5 Jan 2015

Application14/988,307Continuation · filed 5 Jan 2016

Application18/397,987Continuation · filed 27 Dec 2023

Application19/025,761Continuation

US 11,892,913 B2Related patent

US 12,235,729 B2Related patent

US 12,585,546 B2Related patent

US 2016/0196187 A1Published application

US 2024/0126655 A1Published application

US 2025/0156280 A1This patent

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

Data lineage based multi-data store recovery

Life of this patent

Data lineage based multi-data store recovery

Life of this patent

Abstract

Claims20