Bank of America Corporation
DATABASE TOOL

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.