CPC G06F 16/2379 (2019.01) [G06F 16/2329 (2019.01); G06F 16/2358 (2019.01); G06F 16/244 (2019.01); G06F 16/24556 (2019.01); G06N 3/02 (2013.01)] | 20 Claims |
1. A system for providing real-time updates to a destination application program interface (API) comprising one or more memory devices storing instructions and one or more processors configured to execute the instructions that, when executed, cause operations comprising:
obtaining a database transaction request associated with a first transaction identifier via a first API, wherein the database transaction request comprises a first value;
accessing a second API of a sequential transactions database to store a transaction entry in the sequential transactions database based on the database transaction request;
generating a reversed key by reversing the first transaction identifier;
accessing a third API of an aggregation database to determine whether the aggregation database comprises any transaction aggregation records indexed by the reversed key;
in response to a determination that the aggregation database does not store any transaction aggregation records indexed by the reversed key, generating a transaction aggregation record comprising the first value in the aggregation database, wherein the transaction aggregation record is indexed with the reversed key in the aggregation database;
obtaining an update message indicating an update to the sequential transactions database, wherein the update message comprises a second transaction identifier and a second value, and wherein the first API was not used to update the sequential transactions database;
reversing the second transaction identifier to reconstruct the reversed key;
searching the aggregation database with the reversed key to retrieve the transaction aggregation record;
updating the transaction aggregation record based on the second value; and
sending the transaction aggregation record to the destination API after updating the transaction aggregation record with the second value.
|