Invention Grant
US08930397B2 Multi-row database updating for enterprise workflow application 有权
企业工作流程应用程序的多行数据库更新

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.
Public/Granted literature
Information query
Patent Agency Ranking
0/0