US 11,734,238 B2
Correcting data errors for data processing fault recovery
Venkata Durga Rao Medisetti, Hyderabad (IN); Naresh Soni, Mumbai (IN); Siju Abraham, Mumbai (IN); Barnali Sanyal, Kolkata (IN); and Vinay Jaisinghani, Mumbai (IN)
Assigned to Bank of America Corporation, Charlotte, NC (US)
Filed by Bank of America Corporation, Charlotte, NC (US)
Filed on May 7, 2021, as Appl. No. 17/314,483.
Prior Publication US 2022/0358101 A1, Nov. 10, 2022
Int. Cl. G06F 16/215 (2019.01); G06F 16/25 (2019.01); G06F 16/27 (2019.01); G06F 16/21 (2019.01); G06F 16/178 (2019.01)
CPC G06F 16/215 (2019.01) [G06F 16/1794 (2019.01); G06F 16/212 (2019.01); G06F 16/254 (2019.01); G06F 16/258 (2019.01); G06F 16/27 (2019.01); G06F 16/273 (2019.01); G06F 16/275 (2019.01); G06F 16/278 (2019.01)] 15 Claims
OG exemplary drawing
 
1. An apparatus comprising:
at least one processor configured to:
obtain an erroneous data element received from a source system before loading the erroneous data element into a production database;
generate a plurality of probable data values for the data element;
before processing the erroneous data element by an Extract, Transform and Load (ETL) logic and loading the processed data element in the production database, for each probable data value of the plurality of probable data values, verify whether the probable data value can be processed successfully by the ETL logic and by one or more target applications configured to process the data element, wherein verifying whether the probable data value can be processed successfully by the one or more target applications comprises:
generating a temporary database, wherein the temporary database is a replica of at least a portion of the production database in which the ETL logic is to load the data element:
loading the probable data value in the temporary database;
performing one or more processing steps at the temporary database having the probable data value, wherein the one or more processing steps are same as corresponding one or more processing steps performed by the one or more target applications at the production database; and
checking whether the one or more processing steps were processed successfully;
if the one or more processing steps were processed successfully, determine the probable data value as a suggested data value of the data element, based on the verification of the probable data values; and
output the suggested data value for processing by the ETL logic; and
a memory coupled to the at least one processor configured to store the ETL logic.