Invention Grant
- Patent Title: Replicating database updates with batching
-
Application No.: US15811797Application Date: 2017-11-14
-
Publication No.: US10248707B2Publication Date: 2019-04-02
- Inventor: Phillip R. Koza
- Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Applicant Address: US NY Armonk
- Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Current Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Current Assignee Address: US NY Armonk
- Agency: Cantor Colburn LLP
- Agent Robert Bunker
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A computer-implemented method includes detecting a source update applied to a source table, where the source table includes a plurality of columns, and where the source update modifies a first subset of columns of the plurality of columns. A second subset of columns of the plurality of columns is determined, by a computer processor. The second subset of columns has more columns than the first subset of columns and fewer columns than the plurality of columns. Determining the second subset of columns includes determining which of the plurality of columns were updated most recently. The second subset of columns is included in a set clause of an update statement for updating a target table, where the target table is or includes a replica of the source table. The update statement is applied to the target table to achieve at least a minimum batching percentage within a plurality of update statements.
Public/Granted literature
- US20180096044A1 REPLICATING DATABASE UPDATES WITH BATCHING Public/Granted day:2018-04-05
Information query