Design and evaluation of small-large outer joins in cloud computing environments

Long Cheng, Ilias Tachmazidis, Spyros Kotoulas, Grigoris Antoniou

Research output: Contribution to journalArticlepeer-review

29 Citations (Scopus)


Large-scale analytics is a key application area for data processing and parallel computing research. One of the most common (and challenging) operations in this domain is the join. Though inner join approaches have been extensively evaluated in parallel and distributed systems, there is little published work providing analysis of outer joins, especially in the extremely popular cloud computing environments. A common type of outer join is the small-large outer join, where one relation is relatively small and the other is large. Conventional implementations on this condition, such as one based on hash redistribution, often incur significant network communication, while the duplication-based approaches are complex and inefficient. In this work, we present a new method called DDR (duplication and direct redistribution), which aims to enable efficient small-large outer joins in cloud computing environments while being easy to implement using existing predicates in data processing frameworks. We present the detailed implementation of our approach and evaluate its performance through extensive experiments over the widely used MapReduce and Spark platforms. We show that the proposed method is scalable and can achieve significant performance improvements over the conventional approaches. Compared to the state-of-art method, the DDR algorithm is shown to be easier to implement and can achieve very similar or better performance under different outer join workloads, and thus, can be considered as a new option for current data analysis applications. Moreover, our detailed experimental results also have provided insights of current small-large outer join implementations, thereby allowing system developers to make a more informed choice for their data analysis applications.

Original languageEnglish
Pages (from-to)2-15
Number of pages14
JournalJournal of Parallel and Distributed Computing
Early online date6 Mar 2017
Publication statusPublished - Dec 2017


Dive into the research topics of 'Design and evaluation of small-large outer joins in cloud computing environments'. Together they form a unique fingerprint.

Cite this