Replicating database updates with batching
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
Information query
Patent Agency Ranking
0/0