Category: Join algorithms

Symmetric hash join
The symmetric hash join is a special type of hash join designed for data streams.
Nested loop join
A nested loop join is a naive algorithm that joins two sets by using two nested loops. Join operations are important for database management.
Sort-merge join
The sort-merge join (also known as merge join) is a join algorithm and is used in the implementation of a relational database management system. The basic problem of a join algorithm is to find, for e
Block nested loop
A block-nested loop (BNL) is an algorithm used to join two relations in a relational database. This algorithm is a variation of the simple nested loop join and joins two relations and (the "outer" and
Hash join
The hash join is an example of a join algorithm and is used in the implementation of a relational database management system. All variants of hash join algorithms involve building hash tables from the