Loading patent…
AssigneeInternational Business Machines Corporation
InventorShih-Gong Li
Estimating the term…
A method, system and program for determining a set of tables from which data can be redistributed between nodes in a parallel database. First, a list of candidate tables from those stored in the memories associated with a plurality of nodes in the parallel database is established. The list is ordered according a workload of each of the candidate tables. Next, each of the candidate tables is tested to determine whether it can be scanned at each of the plurality of nodes at which the candidate table is stored within a predetermined time period. Any candidate table which can be scanned within the predetermined time period is added to the set of tables from which data can be redistributed. Once the set of tables for redistribution are established, data sets, or buckets, within the redistribution tables are selected. The selected buckets are redistributed from the plurality of nodes to a receiving node. The receiving node is a new node to the parallel database system or an underutilized node in the parallel database system.
A process for redistributing data between nodes in a parallel database system, wherein the redistributing process is operating concurrently with other processes, each process operating in a respective time period allotted to the respective process, comprising the steps of:
A system for redistributing data between nodes in a parallel database system in which a redistribution process operates concurrently with other processes, each process operating in a respective time period allotted to the respective process, comprising:
A computer program product readable in a computer memory for redistributing data between nodes in a parallel database system, which when executed causes a redistribution process to operate concurrently with other processes, each process operating in a respective time period allotted to the respective process, the product comprising:
Dependencies are inferred from the claim text.