Data load process

• US 9,633,094 B2
• Filed: 04/25/2014
• Issued: 04/25/2017
• Est. Priority Date: 04/25/2014
• Status: Active Grant

• Current Assignee: Bank of America Corp.
• Original Assignee: Bank of America Corp.
• Inventors: Rambo, Ron G., Walker, Steven A., Gu, Meng
• Primary Examiner(s): Spieler, William
• Application Number:
  US14/262,014
• Publication Number:
  US 20150310076A1
• Time in Patent Office: 1,096 Days
• CPC Class Codes: G06F 16/215 Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses

Abstract

A source data file can be loaded into a database by extracting data from the source data file at a computing device, validating the data from the source data file at the computing device, transforming the data from the source data file at the computing device, requesting the data to be transferred to a first database at a first message processor module, delivering the data to the first database, and responding that the data has been transferred to the first database at the first message processor module to acknowledge receipt of the data in the database at the computing device.

Claims

1. A computer-implemented method for loading a source data file comprising:

extracting, by a computing device, data from a source data file;

validating, by the computing device, the data from the source data file;

transforming, by the computing device, the data from the source data file to generate transformed data;

sending, to a first message processor, a first request for the transformed data to be transferred to a first database;

in response to the first request for the transformed data to be transferred to the first database, delivering the transformed data to the first database;

sending, to a second message processor, a second request for the transformed data to be transferred to a second database;

in response to the second request for the transformed data to be transferred to the second database, delivering the transformed data to the second database;

generating, by the first message processor and the second message processor, a response that the transformed data has been transferred to the first database and the second database; and

based on the response that the transformed data has been transferred to the first database and the second database, generating, by the computing device, an acknowledgement indicating that the first database and the second database received the transformed data.

2. The method of claim 1, wherein the computing device comprises a server.

3. The method of claim 1, wherein delivering the transformed data to the first database comprises:

receiving, by a first listener device, the transformed data from the first message processor; and

loading, by the first listener device, the transformed data onto the first database, and

wherein delivering the transformed data to the second database comprises;

receiving, by a second listener device, the transformed data from the second message processor; and

loading, by the second listener device, the transformed data onto the second database.

4. The method of claim 1, wherein delivering the transformed data to the second database comprises:

receiving, by a listener device, the transformed data from the second message processor; and

loading, by the listener device, the transformed data onto the second database.

5. The method of claim 1, further comprising updating control records based on the acknowledgement.

6. The method of claim 1, further comprising routing the acknowledgement to a source system.

7. The method of claim 1, further comprising receiving the acknowledgement at a check system monitoring facility.

8. The method of claim 1, further comprising receiving the acknowledgement at a business activity monitoring unit.