Invention Grant
- Patent Title: Data cache using database trigger and programmatically resetting sequence
-
Application No.: US15985814Application Date: 2018-05-22
-
Publication No.: US11243952B2Publication Date: 2022-02-08
- Inventor: Paramdeep Singh Kalra
- 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
- Agency: Moore & Van Allen PLLC
- Agent James C. Edwards
- Main IPC: G06F16/2455
- IPC: G06F16/2455 ; G06F16/22

Abstract:
Expedition of retrieval of data from a database and loading of the retrieved data in an associated application. A cache table within the database is provided that associates a session identifier (i.e., a data record identifier) with a sequence identifier. As data records are received into the database, a sequencer is triggered that generates a sequence identifier for the data record and an entry is created in the cache table that associates the sequence identifier with the session identifier. Data is retrieved from the database and populated within the application, by (i) accessing the sequencer within the database to determine the last-in-time sequence identifier, (ii) accessing the cache table to determine a range of cache table entries based on the last-in-time sequence identifier, and (iii) retrieving the data records in the applicable data tables based on the associated session identifiers in the cache table entries.
Information query