The architectural changes introduced with multi-core processors have triggered a redesign of main-memory join algorithms for relational database systems. Join processing in database systems is a complex and a demanding operation. Traditionally, there have been sorting and hashing based approaches for implementing joins. However, in the last few years several diverging views have appeared regarding
![Parallel & Distributed Joins](https://cdn-ak-scissors.b.st-hatena.com/image/square/ac81ed745cec272ceab90a4e312e445c752db704/height=288;version=1;width=512/https%3A%2F%2Fethz.ch%2Fetc%2Fdesigns%2Fethz%2Fimg%2Fheader%2Feth_default_og.jpg)