US 2024/0202210 A1 · DISCOVERY OF SOURCE RANGE PARTITIONING INFORMATION IN DATA EXTRACT JOB

Abstract

Techniques are described for the discovery of source range partitioning information. An example method includes a device determining a partition boundary value for the data based at least in part on the following steps. The device can determine a first plurality of bounded value sets and a second plurality of bounded value sets. The device can calculate a first average value of a first value and a second average value. The device can determine a first deviation value of the first average value from the first value and a second deviation value of the second average value from a third value. The device can determine the first partition boundary value based at least in part on the first deviation value and the second deviation value, the first partition boundary value being the first candidate partition boundary value or the second candidate partition boundary value.

Claims20

Dependent claims

A method, comprising:

receiving, by a computing device and from a source system, a first set of values from data to be transmitted to a target system and a second set of values from the data to be transmitted to the target system;
determining, by the computing device, a partition boundary value for the data based at least in part on:
determining, by the computing device, a first plurality of bounded value sets based at least in part on the first set of values and a second plurality of bounded value sets based at least in part on the second set of values;
determining, by the computing device, a first deviation value based at least in part on the first plurality of bounded value sets and a second deviation value based at least in part on the second plurality of bounded value sets;
determining, by the computing device, a first partition boundary value based at least in part on the first deviation value and the second deviation value;
partitioning, by the computing device, the data based at least in part on the first partition boundary value;
and
transmitting, by the computing device, the partitioned data to the target system.

5 more elements

A computing device, comprising:

a processor;
and
a computer-readable medium including instructions that, when executed by the processor, cause the processor to perform operations comprising:
receiving, from a source system, a first set of values from data to be transmitted to a target system and a second set of values from the data to be transmitted to the target system;
determining a partition boundary value for the data based at least in part on:
determining a first plurality of bounded value sets based at least in part on the first set of values and a second plurality of bounded value sets based at least in part on the second set of values;
determining a first deviation value based at least in part on the first plurality of bounded value sets and a second deviation value based at least in part on the second plurality of bounded value sets;
determining a first partition boundary value based at least in part on the first deviation value and the second deviation value;
partitioning the data based at least in part on the first partition boundary value;
and
transmitting the partitioned data to the target system.

8 more elements

A non-transitory computer-readable medium having stored thereon a sequence of instructions that, when executed by a processor, causes the processor to perform operations comprising:

receiving, from a source system, a first set of values from data to be transmitted to a target system and a second set of values from the data to be transmitted to the target system;
determining a partition boundary value for the data based at least in part on:
determining a first plurality of bounded value sets based at least in part on the first set of values and a second plurality of bounded value sets based at least in part on the second set of values;
determining a first deviation value based at least in part on the first plurality of bounded value sets and a second deviation value based at least in part on the second plurality of bounded value sets;
determining a first partition boundary value based at least in part on the first deviation value and the second deviation value;
partitioning the data based at least in part on the first partition boundary value;
and
transmitting the partitioned data to the target system.

5 more elements

Dependencies are inferred from the claim text.

Discovery of source range partitioning information in data extract job

Life of this patent

Discovery of source range partitioning information in data extract job

Life of this patent

Abstract

Claims20