Multi-row database updating for enterprise workflow application

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.