Multi-row database updating for enterprise workflow application

Patent metadata

Field	Value
Publication number	US-8930397-B2
Application number	US-201313758735-A
Country	US
Kind code	B2
Filing date	Feb 4, 2013
Priority date	Feb 4, 2013
Publication date	Jan 6, 2015
Grant date	Jan 6, 2015

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.

First claim

What is claimed is:

1. A system for updating data within an entity database, the system comprising:
a memory device with computer-readable program code stored thereon;
a communication device;
a processing device operatively coupled to the memory device and the communication device, wherein the processing device is configured to execute the computer-readable program code to:
receive update data for updating original data stored on the entity database, wherein the original data…

Assignees

• Bank Of America

Inventors

• Rambo Ron G
• Walker Steven A

Classifications

• G06F17/30345 Primary

  Physics · mapped topic

• G06F16/23 Primary

  Physics · mapped topic