Back to results
US 11,379,452 B2Granted
Database tool
AssigneeBank of America Corporation
InventorsMagaranth Jayasingh, Anirudh Kumar Sharma
Life of this patent
Estimating the term…
Abstract
A memory stores a first cache and a second cache. A processor copies a first portion of data from a first table stored in a database into a second table. The processor further determines that a second portion of data from the first table will be overwritten and copies the second portion into a third table. The processor further determines that a probability that a user will access a third portion of the first table is greater than a threshold and copies the third portion into the first cache. The processor further determines a fourth portion of the first table that the user accesses at a frequency greater than a set frequency and copies the fourth portion into the second cache.
Claims20
An apparatus comprising:
- a memory configured to store:
- a first cache;
- and
- a second cache;
- and
- a hardware processor communicatively coupled to the memory, the hardware processor configured to:
- copy a first portion of data from a first table stored in a database into a second table stored in the database, the first portion of data from the first table comprising data stored at locations in the first table flagged with an identifier;
- determine that a second portion of data from the first table stored in the database is set to be overwritten, the second portion of data from the first table stored in the database comprising data stored at locations in the first table flagged with the identifier;
- in response to determining that the second portion of the first table stored in the database is set to be overwritten, copy the second portion of data from the first table stored in the database into a third table stored in the database;
- determine, based on a set of historical information, that a probability that a user will access a third portion of the first table stored in the database at a future date is greater than a set threshold;
- in response to determining that the probability that the user will access the third portion of the first table stored in the database at the future date is greater than the set threshold, copy the third portion of the first table stored in the database into the first cache prior to the future date;
- determine a fourth portion of the first table stored in the database that the user accesses at a frequency greater than a set frequency;
- and
- in response to determining the fourth portion of the first table stored in the database that the user accesses at the frequency greater than the set frequency, copy the fourth portion of the first table stored in the database into the second cache.
11 more elements
A method comprising:
- copying a first portion of data from a first table stored in a database into a second table stored in the database, the first portion of data from the first table comprising data stored at locations in the first table flagged with an identifier;
- determining that a second portion of data from the first table stored in the database is set to be overwritten, the second portion of data from the first table stored in the database comprising data stored at locations in the first table flagged with the identifier;
- in response to determining that the second portion of the first table stored in the database is set to be overwritten, copying the second portion of data from the first table stored in the database into a third table stored in the database;
- determining, based on a set of historical information, that a probability that a user will access a third portion of the first table stored in the database at a future date is greater than a set threshold;
- in response to determining that the probability that the user will access the third portion of the first table stored in the database at the future date is greater than the set threshold, copying the third portion of the first table stored in the database into a first cache prior to the future date;
- determining a fourth portion of the first table stored in the database that the user accesses at a frequency greater than a set frequency;
- and
- in response to determining the fourth portion of the first table stored in the database that the user accesses at the frequency greater than the set frequency, copying the fourth portion of the first table stored in the database into a second cache.
5 more elements
A system comprising:
- a storage element operable to store:
- a first cache;
- and
- a second cache;
- and
- a processing element communicatively coupled to the storage element and operable to:
- copy a first portion of data from a first table stored in a database into a second table stored in the database, the first portion of data from the first table comprising data stored at locations in the first table flagged with an identifier;
- determine that a second portion of data from the first table stored in the database is set to be overwritten, the second portion of data from the first table stored in the database comprising data stored at locations in the first table flagged with the identifier;
- in response to determining that the second portion of the first table stored in the database is set to be overwritten, copy the second portion of data from the first table stored in the database into a third table stored in the database;
- determine, using a machine learning model operating on a set of historical information, that a probability that the user will access a third portion of the first table stored in the database at a future date is greater than a set threshold;
- in response to determining that the probability that the user will access the third portion of the first table stored in the database at the future date is greater than the set threshold, copy the third portion of the first table stored in the database into the first cache prior to the future date;
- determine a fourth portion of the first table stored in the database that the user accesses at a frequency greater than a set frequency;
- and
- in response to determining the fourth portion of the first table stored in the database that the user accesses at the frequency greater than the set frequency, copy the fourth portion of the first table stored in the database into the second cache.
11 more elements
Dependencies are inferred from the claim text.