Invention Grant
US09026504B2 Multi-row database data loading for enterprise workflow application
有权
企业工作流程应用程序的多行数据库数据加载
- Patent Title: Multi-row database data loading for enterprise workflow application
- Patent Title (中): 企业工作流程应用程序的多行数据库数据加载
-
Application No.: US13758691Application Date: 2013-02-04
-
Publication No.: US09026504B2Publication Date: 2015-05-05
- 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 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.
Public/Granted literature
- US20140222768A1 MULTI-ROW DATABASE DATA LOADING FOR ENTERPRISE WORKFLOW APPLICATION Public/Granted day:2014-08-07
Information query