Invention Grant
- Patent Title: Database tool
-
Application No.: US16199925Application Date: 2018-11-26
-
Publication No.: US10915517B2Publication Date: 2021-02-09
- Inventor: Magaranth Jayasingh , Anirudh Kumar Sharma
- Applicant: Bank of America Corporation
- Applicant Address: US NC Charlotte
- Assignee: Bank of America Corporation
- Current Assignee: Bank of America Corporation
- Current Assignee Address: US NC Charlotte
- Agent Michael A. Springs
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/22 ; G06F12/0868 ; G06F17/18 ; G06F16/2455

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.
Public/Granted literature
- US20200167423A1 DATABASE TOOL Public/Granted day:2020-05-28
Information query