International Business Machines Corporation
DISTRIBUTING ROWS OF A TABLE IN A DISTRIBUTED DATABASE SYSTEM

Abstract:

In an approach to copying of table rows across logical nodes in a distributed database system comprising a plurality of logical nodes, for each logical node of a plurality of logical nodes, a connection is made to a current logical node of the plurality of logical nodes. One or more rows are selected from source nodes of the logical nodes to be stored in a target table on the current logical node, where the one or more rows are selected based on a distribution rule for distributing data in the distributed database system. The rows are stored into the target table, where the rows are pulled from the source nodes and stored in the current logical node.