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.

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

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

Performance Evaluation for Distributed Join Based on MapReduce.

Join Query Optimization Based on MapReduce under Skewed Data

Improved LSH-driven String Similarity Join Filtering-Verification Framework

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

A Multi-Table Join Algorithm for Data Warehouse Query Processing

Scalable Parallel Join for Huge Tables

An Effective High-Performance Multiway Spatial Join Algorithm with Spark

Modular Pipeline Architecture for Accelerating Join Operation in RDBMS

A cost aware adaptive multiple table join evaluation in MapReduce

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

Efficient B-tree Based Indexing for Cloud Data Processing.

Multi-Way Windowed Streams Θ-Joins Using Cluster

Skyline-Join in Distributed Databases

PMJoin: Optimizing Distributed Multi-way Stream Joins by Stream Partitioning

Efficient Join Synopsis Maintenance for Data Warehouse.

Efficient Multi-way Theta-Join Processing Using MapReduce

Database Query Optimization Based On Parallel Ant Colony Algorithm

Efficient Join Algorithms For Large Database Tables in a Multi-GPU Environment

An Adaptive Skew Handling Join Algorithm for Large-scale Data Analysis