US 10,592,353 B2 · Systems and methods of restoring a dataset of a database for a point in time

Abstract

Systems and methods are provided for performing a point-in-time restore of data of a first tenant of a multitenanted database system. Metadata can be located to identify an archival version of first data of the first tenant stored in immutable storage of the database system. The archival version includes a most recently committed version of each datum prior to a first point in time. By using the metadata, a restore reference set is mapped into a target database instance of the database system. The mapping can be performed when all existing data for a tenant is to be the archival version, and where versions of data and records committed after the point in time are not available to the target database instance.

Claims14

Dependent claims

A computerized method for performing a point-in-time restore of data of a first tenant of a multitenanted database system, where tenant data is stored in an immutable storage of the database system, and is associated with a metadata tenant identifier and metadata that is indicative of when records are created and deleted from the database system, and is indicative of different versions of tenant data that are committed to the database system from time-to-time, the method comprising:

locating metadata to identify an archival version of first data of a first tenant stored in the immutable storage, wherein the archival version includes a most recently committed version of each datum prior to a first point in time, without use of separate transaction log data;
and
mapping, by using the metadata, a restore reference set into a target database instance of the database system, wherein the restore reference set includes a minimum key and a maximum key to set a boundary range for the tenant data that is to be restored to the first point in time, wherein when all existing data for a tenant is to be the archival version, and wherein versions of data and records committed after the point in time are not available to the target database instance.

A system to perform a point-in-time restore of data of a first tenant of a multitenanted database system, the system comprising:

at least one storage device to store tenant data, wherein the tenant data is associated with a metadata tenant identifier and metadata that is indicative of when records are created and deleted from the database system, and is indicative of different versions of tenant data that are committed to the database system from time-to-time;
at least one server to locate metadata to identify an archival version of first data of a first tenant stored in the at least one storage device without use of separate transaction log data, wherein the archival version includes a most recently committed version of each datum prior to a first point in time, and to map, by using the metadata, a restore reference set into a target database instance of the database system, wherein the restore reference set includes a minimum key and a maximum key to set a boundary range for the tenant data that is to be restored to the first point in time, wherein when all existing data for a tenant is to be replaced with the archival version, and wherein versions of data and records committed after the point in time are not available to the database instance.

Dependencies are inferred from the claim text.

Systems and methods of restoring a dataset of a database for a point in time

Life of this patent

Systems and methods of restoring a dataset of a database for a point in time

Life of this patent

Abstract

Claims14