MERGING OF DISTRIBUTED DATASETS

摘要

Aspects include operating a distributed database that includes multiple computing nodes that are connected via a network for exchanging data, and a database management system for managing a source dataset and a target dataset. The target dataset is stored in a distributed fashion across the multiple computing nodes. The method includes repeatedly, using the multiple computing nodes, checking for a matching condition between a source element selected from a source dataset and one of multiple target elements in the target dataset. The multiple computing nodes are used to calculate a command set of a merged command list of commands to merge the source element with the target element using the matching condition. The command set is executed to merge the source element with the target dataset before checking for the matching condition between a next source element selected from the multiple source element and one of the multiple target elements.

主权项

1. A method of operating a distributed database, the method comprising:
executing a join command to merge a source dataset with a target dataset, the executing by multiple computing nodes in the distributed database, the multiple computing nodes for implementing storage and computation for the database management system, the multiple computing nodes connected via a network for exchanging data, and the database management system for managing at least the source dataset and the target dataset, the target dataset being stored in a distributed fashion across the multiple computing nodes, the source dataset comprising multiple source elements, the target dataset comprising multiple target elements, the executing comprising:
checking for a matching condition between a source element selected from the multiple source elements and one of the multiple target elements;calculating a command set of a merge command list, the command list comprising a list of commands to merge the source element with the target element using the matching condition; andrepeatedly executing the command set to merge the source element with the target dataset before checking for the matching condition between a next source element selected from the multiple source elements and one of the multiple target elements.