International Business Machines Corporation

Yuan Su

Naresh K Chainani

Liping Zhang

Kiran Chinta

A method for use in processing database queries performed on a database, having tables made up of outer table data and corresponding inner table data, distributed among storage associated with multiple nodes of a multi-threaded cluster of computers is described. The method involves, on each node, constructing a Bloom filter by writing a local portion of the complete Bloom filter and then receiving and merging Bloom filter components sent from each node using different startingOffset positions and then, once the Bloom filter is complete at a node, using the complete Bloom filter as a join filter in a table join operation, without regard to Bloom filter construction occurring at other nodes.

Bloom filter construction method for use in a table join operation portion of processing a query to a distributed database

A method for use in processing database queries performed on a database, having tables made up of outer table data and corresponding inner table data, distributed among storage associated with multiple nodes of a multi-threaded cluster of computers is described. The method involves constructing a Bloom filter at nodes by merging Bloom filter components on each node using different startingOffset positions for each thread and then, once the Bloom filter is complete at a node and using the complete Bloom filter as a join filter in a table join operation, without regard to Bloom filter construction occurring at others of the multiple nodes.

Growing community of inventors

Unionville, Canada

Yuan Su