Utilizing machine learning to determine data storage pruning parameters

Patent metadata

Field	Value
Publication number	US-2019317916-A1
Application number	US-201916431092-A
Country	US
Kind code	A1
Filing date	Jun 4, 2019
Priority date	Apr 11, 2018
Publication date	Oct 17, 2019
Grant date	—

Abstract

A device receives, from a user device, a request to prune a primary database, and receives primary database information associated with the primary database and secondary database information associated with a secondary database that is different than the primary database. The device processes the primary database information and the secondary database information, with a machine learning model, to generate suggested pruning parameters, and provides the suggested pruning parameters to the user device. The device receives selected pruning parameters from the user device, where the selected pruning parameters are selected from the suggested pruning parameters or are input via the user device. The device removes pruned information from the primary database based on the selected pruning parameters, and provides the pruned information to the secondary database based on the selected pruning parameters.

First claim

What is claimed is:

1 . A method, comprising:
removing, by a device, first data from primary database based on one or more pruning parameters; providing, by the device, the first data to a secondary database based on the one or more pruning parameters; determining, by the device and based on a pattern identified from historical access to the first data, a predicted point in time associated with the first data,
the historical access to the first data including at least one of:
historical access to the first data when the first data was stored in the primary database, or
historical access to the first data when the first data was stored in the secondary database;

removing, by the device, the first data from the secondary database prior to the predicted point in time; and providing, by the device, the first data to the primary database prior to the predicted point in time.

2 . The method of claim 1 , further comprising:
analyzing primary database information associated with the primary database to determine a utilization frequency parameter associated with the first data; and identifying the first data based on the utilization frequency parameter.

3 . The method of claim 1 , further comprising:
analyzing metadata associated with the primary database; and determining, based on analyzing the metadata, a backup strategy associated with the primary database,
the backup strategy specifying a periodic schedule for data to be removed from the primary database.

4 . The method of claim 1 , further comprising:
analyzing metadata associated with the primary database,
the metadata specifying a frequency of use associated with a portion of the first data; and
generating a pruning parameter, of the one or more pruning parameters, based on analyzing the metadata and the frequency of use.

5 . The method of claim 1 , further comprising:
analyzing metadata associated with the primary database,
the metadata specifying a quantity of data associated with a portion of the first data; and
generating a pruning parameter, of the one or more pruning parameters, based on analyzing the metadata and the quantity of data.

6 . The method of claim 1 , wherein:
the first data includes at least one database record that includes data indicating a previous access time associated with the at least one database record, and providing the first data to the secondary database based on the one or more pruning parameters comprises:
providing the first data to the secondary database based on the one or more pruning parameters and the data indicating the previous access time.

7 . The method of claim 1 , wherein:
the first data is associated with a first cost associated with storing the first data in the primary database, the first data is associated with a second cost associated with storing the first data in the secondary database, and providing the first data to the secondary database based on the one or more pruning parameters comprises:
providing the first data to the secondary database based on the one or more pruning parameters, the first cost, and the second cost.

8 . A device, comprising:
one or more memories; and one or more processors communicatively coupled to the one or more memories, configured to:
remove first data from primary database based on one or more pruning parameters;
provide the first data to a secondary database based on the one or more pruning parameters;
determine, based on a pattern identified from historical access to the first data, a predicted point in time associated with the first data,
the historical access to the first data including at least one of:
historical access to the first data when the first data was stored in the primary database, or
historical access to the first data when the first data was stored in the secondary database;

remove the first data from the secondary database prior to the predicted point in time; and
provide the first data to the primary database prior to the predicted point in time.

9 . The device of claim 8 , wherein the one or more processors are further configured to:
analyze primary database information associated with the primary database to determine a utilization frequency parameter associated with the first data; and identify the first data based on the utilization frequency parameter.

10 . The device of claim 8 , wherein the one or more processors are further configured to:
analyze metadata associated with the primary database; and determine, based on analyzing the metadata, a backup strategy associated with the primary database,
the backup strategy specifying a periodic schedule for data to be removed from the primary database.

11 . The device of claim 8 , wherein the one or more processors are further configured to:
analyze metadata associated with the primary database,
the metadata specifying a frequency of use associated with a portion of the first data; and
generate a pruning parameter, of the one or more pruning parameters, based on analyzing the metadata and the frequency of use.

12 . The device of claim 8 , wherein the one or more processors are further configured to:
analyze metadata associated with the primary database,
the metadata specifying a quantity of data associated with a portion of the first data; and
generate a pruning parameter, of the one or more pruning parameters, based on analyzing the metadata and the quantity of data.

13 . The device of claim 8 , wherein:
the first data includes at least one database record that includes data indicating a previous access time associated with the at least one database record, and one or more processors, when providing the first data to the secondary database based on the one or more pruning parameters, are configured to:
provide the first data to the secondary database based on the one or more pruning parameters and the data indicating the previous access time.

14 . The device of claim 8 , wherein:
the first data is associated with a first cost associated with storing the first data in the primary database, the first data is associated with a second cost associated with storing the first data in the secondary database, and the one or more processors, when providing the first data to the secondary database based on the one or more pruning parameters, are configured to:
provide the first data to the secondary database based on the one or more pruning parameters, the first cost, and the second cost.

15 . A non-transitory computer-readable medium storing instructions, the instructions comprising:
one or more instructions that, when executed by one or more processors, cause the one or more processors to:
remove first data from primary database based on one or more pruning parameters;
provide the first data to a secondary database based on the one or more pruning parameters;
determine, based on a pattern identified from historical access to the first data, a predicted point in time associated with the first data,
the historical access to the first data including at least one of:
historical access to the first data when the first data was stored in the primary database, or
historical access to the first data when the first data was stored in the secondary database;

remove the first data from the secondary database prior to the predicted point in time; and
provide the first data to the primary database prior to the predicted point in time.

16 . The non-transitory computer-readable medium of claim 15 , wherein the one or more instructions, when executed by the one or

Assignees

• Capital One Services Llc

Inventors

• Deshpande Amit
• Subramanian Ponnazhakan
• Chikkaveerappa Satish
• Pandya Asutosh
• Venuraju Mithra Kosur
• Mohammed Sahul

Classifications

• G06F16/284

  Relational databases · CPC title

• G06F16/125 Primary

  characterised by the use of retention policies (retention policies for HSM systems G06F16/185) · CPC title

• G06F16/113 Primary

  Details of archiving (lifecycle management in storage systems G06F3/0649; point-in-time backing up or restoration of persistent data G06F11/1446) · CPC title

• G06F16/2365

  Ensuring data consistency and integrity · CPC title