US 12,079,243 B2
System and method for data transmission from mainframe database to log database
Praveen Bangera, Bangalore (IN); Harishkumar Lakshminarasimhamurthy, Bangalore (IN); Suhas Mathakari, Bangalore (IN); and Ramgopal Reddy Gonnuru, Bangalore (IN)
Assigned to JPMORGAN CHASE BANK, N.A., New York, NY (US)
Filed by JPMorgan Chase Bank, N.A., New York, NY (US)
Filed on Dec. 14, 2021, as Appl. No. 17/644,176.
Claims priority of application No. 202111049600 (IN), filed on Oct. 29, 2021.
Prior Publication US 2023/0139224 A1, May 4, 2023
Int. Cl. G06F 16/00 (2019.01); G06F 16/11 (2019.01); G06F 16/23 (2019.01); G06F 16/27 (2019.01)
CPC G06F 16/273 (2019.01) [G06F 16/116 (2019.01); G06F 16/2379 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method for data transmission by utilizing one or more processors along with allocated memory, the method comprising:
implementing, by at least one processor, a modular data transmission module that includes an accessing module, an implementing module, a publishing module, a converting module, a parsing module, a creating module, and a transmitting module;
accessing, by calling the accessing module by a first application programming interface (API), a database that stores data relating to one or more transactions;
implementing, by calling the implementing module by a second API, a replication tool that is configured for a table within the database, and when a row is added to the table or modified in the table, the replication tool is configured to identify the added or modified row;
publishing, by utilizing the replication tool and by calling the publishing module by a third API, the data associated with the added or modified row onto a local message queue (MQ);
converting, by calling the converting module by a fourth API, the data into a configuration file having a predefined file format;
parsing, by calling the parsing module by a fifth API, the data from the configuration file;
creating, by calling the creating module by a sixth API, a predefined payload based on the parsed data; and
transmitting, by calling the transmitting module by a seventh API, the predefined payload onto a log database via a data bus and transmitting real-time data from a mainframe onto a distributed environment;
retaining of data on the log database for certain days compared to mainframe resulting no login to mainframe and not exposing an application for performance metrics purpose,
wherein the local MQ is a mainframe local MQ, and in publishing the transaction details data onto the mainframe local MQ, the method further comprising:
writing required columns to the mainframe local MQ in response to the added or modified row; and
configuring the replication tool and the mainframe local MQ in a manner such that writing the required columns does not impact performance of mainframe database as the replication tool works against logs only.