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, performs statistical analysis on the first portion, and stores the results into the second table. The processor further determines that a second portion of data from the first table will be overwritten, copies the second portion into a third table, performs statistical analysis on the second portion and stores the results into the 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.