US 2015/0309999 A1 · METHOD FOR REBALANCING DATA PARTITIONS

Abstract

Embodiments of the present invention disclose a method, computer program product, and system for rebalancing partitioned data based, at least in part, on one or more characteristics of the plurality of database partitions. The computer updating characteristics, wherein the one or more characteristics include one or both of a) an average number of records per partition, and b) an average number of unique limit key values per partition. Embodiments of the present invention disclose a method, computer program product, and system for limit key extrapolation in a database. Responsive to a determination that the upper limit key value of the last loaded record is greater than the first upper limit key value of the first empty partition, the computer redefines the first upper limit key value of the first empty partition by an extrapolated upper limit key value based, at least in part, on the range of limit key values.

Claims20

Dependent claims

A method for rebalancing partitioned data in a database, the method comprising:

a computer initiating a rebalance of a set of data records included in a plurality of database partitions by unloading the set of data records, wherein the rebalance of the set of data records is improved based, at least in part, on one or more characteristics of the plurality of database partitions that are determined during the rebalance of the set of data records;
the computer updating the one or more characteristics during the rebalancing of the set of data records, wherein the one or more characteristics include one or both of a) an average number of records per partition, and b) an average number of unique limit key values per partition;
and
the computer loading the set of data records into the plurality of database partitions based, at least in part, on the one or more characteristics, wherein the one or more characteristics are used to direct the rebalancing of the set of data records.

1 more element

A computer program product for rebalancing partitioned data in a database, the computer program product comprising:

a computer readable storage medium and program instructions stored on the computer readable storage medium, the program instructions comprising:
program instructions to initiate a rebalance of a set of data records included in a plurality of database partitions by unloading the set of data records, wherein the rebalance of the set of data records is improved based, at least in part, on one or more characteristics of the plurality of database partitions that are determined during the rebalance of the set of data records;
program instructions to update the one or more characteristics during the rebalancing of the set of data records, wherein the one or more characteristics include one or both of a) an average number of records per partition, and b) an average number of unique limit key values per partition;
and
program instructions to load the set of data records into the plurality of database partitions based, at least in part, on the one or more characteristics, wherein the one or more characteristics are used to direct the rebalancing of the set of data records.

2 more elements

A computer system for rebalancing partitioned data in a database, the computer system comprising:

one or more computer processors;
one or more computer readable storage media;
program instructions stored on the computer readable storage media for execution by at least one of the one or more processors, the program instructions comprising:
program instructions to initiate a rebalance of a set of data records included in a plurality of database partitions by unloading the set of data records, wherein the rebalance of the set of data records is improved based, at least in part, on one or more characteristics of the plurality of database partitions that are determined during the rebalance of the set of data records;
program instructions to update the one or more characteristics during the rebalancing of the set of data records, wherein the one or more characteristics include one or both of a) an average number of records per partition, and b) an average number of unique limit key values per partition;
and
program instructions to load the set of data records into the plurality of database partitions based, at least in part, on the one or more characteristics, wherein the one or more characteristics are used to direct the rebalancing of the set of data records.

4 more elements

Dependencies are inferred from the claim text.

Method for rebalancing data partitions

Life of this patent

Method for rebalancing data partitions

Life of this patent

Abstract

Claims20