Invention Grant
- Patent Title: Multi-row database updating for enterprise workflow application
- Patent Title (中): 企业工作流程应用程序的多行数据库更新
-
Application No.: US13758735Application Date: 2013-02-04
-
Publication No.: US08930397B2Publication Date: 2015-01-06
- Inventor: Ron G. Rambo , Steven A. Walker
- Applicant: Bank of America Corporation
- Applicant Address: US NC Charlotte
- Assignee: Bank of America Corporation
- Current Assignee: Bank of America Corporation
- Current Assignee Address: US NC Charlotte
- Agency: Moore & Van Allen PLLC
- Agent Michael A. Springs; Nicholas C. Russell
- Main IPC: G06F17/30
- IPC: G06F17/30

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.
Public/Granted literature
- US20140222872A1 MULTI-ROW DATABASE UPDATING FOR ENTERPRISE WORKFLOW APPLICATION Public/Granted day:2014-08-07
Information query