Abstract:Data analysis is an important functionality in cloud computing which allows a huge amount of data to be processed over very large clusters. MapReduce is recognized as a popular way to handle data in the cloud environment due to its excellent scalability and good fault tolerance. However, compared to parallel databases, the performance of MapReduce is slower when it is adopted to perform complex data analysis tasks that require the joining of multiple data sets in order to compute certain aggregates. A common concern is whether MapReduce can be improved to produce a system with both scalability and efficiency. In this paper, we introduce Map-Join-Reduce, a system that extends and improves MapReduce runtime framework to efficiently process complex data analysis tasks on large clusters. We first propose a filtering-join-aggregation programming model, a natural extension of MapReduce's filtering-aggregation programming model. Then, we present a new data processing strategy which performs filtering-join-aggregation tasks in two successive MapReduce jobs. The first job applies filtering logic to all the data sets in parallel, joins the qualified tuples, and pushes the join results to the reducers for partial aggregation. The second job combines all partial aggregation results and produces the final answer. The advantage of our approach is that we join multiple data sets in one go and thus avoid frequent checkpointing and shuffling of intermediate results, a major performance bottleneck in most of the current MapReduce-based systems. We benchmark our system against Hive, a state-of-the-art MapReduce-based data warehouse on a 100-node cluster on Amazon EC2 using TPC-H benchmark. The results show that our approach significantly boosts the performance of complex analysis queries.

Scalable Parallel Join for Huge Tables

Optimization Factor Analysis Of Large-Scale Join Queries On Different Platforms

Join Query Optimization Based on MapReduce under Skewed Data

Performance Evaluation for Distributed Join Based on MapReduce.

Join Optimization in the MapReduce Environment for Column-wise Data Store

Efficient Query Processing Framework for Big Data Warehouse: an Almost Join-Free Approach

MAP-JOIN-REDUCE: Toward Scalable and Efficient Data Analysis on Large Clusters

A Distributed Join Algorithm on Separated Data Storage

Parallel Graph Pattern Matching in Massive Networks Based on MapReduce

Vhadoop: A Scalable Hadoop Virtual Cluster Platform for MapReduce-Based Parallel Machine Learning with Performance Consideration

A multi-table connection strategy based on Hadoop

An Effective High-Performance Multiway Spatial Join Algorithm with Spark

Parallel Similarity Joins on Massive High-Dimensional Data Using Mapreduce

Efficient Star Join for Column-oriented Data Store in the MapReduce Environment.

Query optimization for massively parallel data processing.

Fast and Scalable Distributed Set Similarity Joins for Big Data Analytics.

A Filter-Based Multi-Join Algorithm in Cloud Computing Environment

An Efficient Method for Parallel Multi-Dimensional Join and Aggregation

Parallel Join Based on Distributed System OceanBase

High-Performance Data Distribution Algorithm on Distributed Stream Systems

Efficient String Similarity Join in Multi-Core and Distributed Systems.