Handling Data-skew Effects in Join Operations using MapReduce

Mohamad Al Hajj Hassan (1) , Mostafa Bamha (1) , Frédéric Loulergue (2)

1 LIFO - Laboratoire d'Informatique Fondamentale d'Orléans
2 PaMDA

For over a decade, MapReduce has become a prominent programming model to handle vast amounts of raw data in large scale systems. This model ensures scalability, reliability and availability aspects with reasonable query processing time. However these large scale systems still face some challenges: data skew, task imbalance, high disk I/O and redistribution costs can have disastrous effects on performance. In this paper, we introduce MRFA-Join algorithm: a new frequency adaptive algorithm based on MapReduce programming model and a randomised key redistribution approach for join processing of large-scale datasets. A cost analysis of this algorithm shows that our approach is insensitive to data skew and ensures perfect balancing properties during all stages of join computation. These performances have been confirmed by a series of experimentations.

Domaines: Calcul parallèle, distribué et partagé [cs.DC]; Base de données [cs.DB]

Mohamad Al Hajj Hassan, Mostafa Bamha, Frédéric Loulergue. Handling Data-skew Effects in Join Operations using MapReduce. ICCS, 2014, Cairns, Australia. ⟨hal-00958116⟩