The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.

The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.

Date of Patent:
Jul. 26, 2022

Filed:

Sep. 09, 2020
Applicant:

International Business Machines Corporation, Armonk, NY (US);

Inventors:

Felix Beier, Haigerloch, DE;

Sabine Perathoner-Tschaffler, Nufringen, DE;

Dennis Butterstein, Stuttgart, DE;

Einar Lueck, Filderstadt, DE;

Attorney:
Primary Examiner:
Int. Cl.
CPC ...
G06F 16/23 (2019.01); G06F 11/34 (2006.01); G06F 16/21 (2019.01); G06F 16/22 (2019.01);
U.S. Cl.
CPC ...
G06F 16/2358 (2019.01); G06F 11/3409 (2013.01); G06F 16/217 (2019.01); G06F 16/2282 (2019.01); G06F 16/235 (2019.01); G06F 16/2322 (2019.01);
Abstract

A method comprises receiving a stream of change log records from a source database system; generating change statistics based on a number of pending changes per table partition according to the change log records; estimating, based on performance statistics, a first amount of time for applying the pending changes to a target database system using an incremental update path; estimating, based on the performance statistics, a second amount of time for applying the pending changes to the target database using a bulk update path; dynamically selecting, based on comparison of the first amount of time with the second amount of time, one of the incremental update path and the bulk update path for applying the pending changes to the target database system; and applying the pending changes to the target database system using the selected update path.


Find Patent Forward Citations

Loading…