Patent ID: 9305074
Filing Date: 2016-04-05
CPC Classification: G06F

Claim Text:
1. In a distributed computing environment including one or more processors and system memory, a method of distributing rows of data in a distributed table distributed across a plurality of nodes, the method comprising: identifying skewed rows of a first table, the first table to be distributed in a distributed database system, the skewed rows comprising a common data value in a column such that the skewed rows are skewed, according to a skew factor, with respect to other rows in the first table not having the common data value, wherein the skew factor is selected based at least in part on generations of hardware used to implement the plurality of nodes, such that a smaller skew factor is used when the plurality of nodes includes a relatively greater portion of nodes that utilize older generations of hardware, and such that a larger skew factor is used when the plurality of nodes includes a relatively lesser portion of nodes that utilize older generations of hardware; identifying non-skewed rows of the first table that are not skewed according to the skew factor; distributing the skewed rows of the first table across nodes in a non-deterministic fashion that is not based on a hash distribution, and such that the skewed rows are enabled to be distributed to any of the plurality of nodes; and distributing the non-skewed rows of the first table across the nodes in a deterministic fashion, which is based on a hash distributions, wherein the rows of the first table distributed across the nodes, whether distributed in a deterministic fashion or non-deterministic fashion, are stored in a single table at each of the nodes.