Steven B Walker

US Patent:

20170147663, May 25, 2017

Filed:

Feb 3, 2017

Appl. No.:

15/424094

Inventors:

- Charlotte NC, US
Steven A. Walker - North Salt Lake UT, US
Meng Gu - Marietta GA, US

International Classification:

G06F 17/30

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.

US Patent:

20150310076, Oct 29, 2015

Filed:

Apr 25, 2014

Appl. No.:

14/262014

Inventors:

- Charlotte NC, US
Steven A. Walker - North Salt Lake UT, US
Meng Gu - Marietta GA, US

Assignee:

Bank of America Corporation - Charlotte NC

International Classification:

G06F 17/30

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.

US Patent:

20140222768, Aug 7, 2014

Filed:

Feb 4, 2013

Appl. No.:

13/758691

Inventors:

- Charlotte NC, US
Steven A. Walker - North Salt Lake UT, US

Assignee:

BANK OF AMERICA COPORATION - Charlotte NC

International Classification:

G06F 17/30

US Classification:

707692, 707803, 707756

Abstract:

Embodiments of the invention are directed to a system, method, or computer program product for providing expedited loading/inserting of data by an entity. Specifically, the invention expedites the loading/inserting of large quantities of data to database tables. Initially received data for loading is processed, via multi-row insert, onto in-memory or temporary tables. The data is staged on a temporary table while the appropriate base table is determined. Once determined, data from the temporary table is pointed to the base table. In this way, a massive amount of data loading from the temporary table to a base table may occur. This prevents logging and locking associated with adding individual data points or row to a base table independently. Errors are check and processed accordingly. Once updated, the data on the temporary table is deleted in mass and a check point restart is issued.

US Patent:

20140222872, Aug 7, 2014

Filed:

Feb 4, 2013

Appl. No.:

13/758735

Inventors:

- Charlotte NC, US
Steven A. Walker - North Salt Lake UT, US

Assignee:

BANK OF AMERICA CORPORATION - Charlotte NC

International Classification:

G06F 17/30

US Classification:

707803

Abstract:

Embodiments of the invention are directed to a system, method, or computer program product for providing expedited updating of data stored by an entity. Specifically, the invention expedites the updating of data within large quantities of data on database tables. Initially received update data is processed, via multi-row insert, onto in-memory or temporary tables. The update data is staged on a temporary table while the appropriate base table (housing the data to be updated) is determined. Once determined, update data from the temporary table is pointed to the base table. In this way, a massive amount of data updating may occur. This prevents logging and locking associated with adding individual data updates or row updates to the base table independently. Errors are check and processed accordingly. Once updated, the update data on the temporary table is deleted in mass and a check point restart is issued.