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:
Dec. 12, 2023

Filed:

Jun. 29, 2021
Applicant:

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

Inventors:

Chengxuan Xing, Romsey, GB;

Doina Liliana Klinger, Winchester, GB;

Alexander Robert Wood, Romsey, GB;

Tom Soal, Whitehill, GB;

Attorney:
Primary Examiner:
Int. Cl.
CPC ...
G06F 17/00 (2019.01); G06F 16/25 (2019.01); G06F 11/34 (2006.01); G06F 16/215 (2019.01); G06F 11/14 (2006.01);
U.S. Cl.
CPC ...
G06F 16/254 (2019.01); G06F 11/1402 (2013.01); G06F 11/3414 (2013.01); G06F 16/215 (2019.01);
Abstract

An approach to implement an extract, transform and load system, a queue is provided for holding units of data between extraction and transformation. When units of data suffer a rate limit error in the load phase, they are requeued so they can be resubmitted for transformation. The contents of the queue are monitored and, if too many requeued units of data are detected in the queue, then this is taken as an indicator of an unacceptable number of rate limit errors and active pacing management is triggered. A retry schedule is defined for the requeued units of data. Extraction is temporarily halted to allow the requeued units of data to be retransformed without more units of data queuing up. Then, after the suspension is lifted, a pacing delay is inserted between subsequent extract events to avoid the same load phase bottleneck recurring.


Find Patent Forward Citations

Loading…