Data analyzing and processing are important tasks in cloud computing. In this field, the MapReduce framework has become a more and more popular tool to analyze large-scale data over large clusters. Compared with the parallel relational database, it has the advantages of excellent scalability and good fault tolerance. However, the performance of join operation using MapReduce is not as good as that of parallel relational database. Thus, how to optimize theta-join operations using MapReduce is an attractive point to which researchers have been paying attention. In this paper, a randomized algorithm named Strict-Even-Join(SEJ) is designed to solve the multi-way theta-joins in a single MapReduce job. Moreover, a dynamic programming algorithm is elaborated to optimize the multi-way theta-joins by calling the SEJ algorithm. The results of experiments show that our approach is feasible and effective.
목차
Abstract 1 Introduction 2 Related Work 3 Designing and Implementation of Strict-Even-Join 3.1 Multi-way Theta-joins in a Single MapReduce Job 3.2 Data Partitioning 3.3 Algorithm 3.4 Analysis of Skew Data 4 Optimizing Multi-Way Theta-Joins using MapReduce 4.1 Generating Optimal Query Plan 4.2 Concurrent MapReduce Jobs 5 Cost Model of Multi-way Joins using MapReduce 5.1 Building Equi-Width Histogram using MapReduce 5.2 Cost Model of Theta-Joins using MapReduce 5.3 Cost Model of Equi-Joins using MapReduce 6 Experiments 6.1 Effect of SEJ 6.2 Effect of Query Optimization 7 Conclusion and Future Work 8 Acknowledgements References
키워드
MapReduceMultiway Theta-JoinsQuery OptimizationSkewCost Model
저자
Changchun Zhang [ School of Computer Science and Technology, University of Science and Technology of China ]
Jing Li [ School of Computer Science and Technology, University of Science and Technology of China ]
Lei Wu [ School of Computer Science and Technology, University of Science and Technology of China ]
보안공학연구지원센터(IJDTA) [Science & Engineering Research Support Center, Republic of Korea(IJDTA)]
설립연도
2006
분야
공학>컴퓨터학
소개
1. 보안공학에 대한 각종 조사 및 연구
2. 보안공학에 대한 응용기술 연구 및 발표
3. 보안공학에 관한 각종 학술 발표회 및 전시회 개최
4. 보안공학 기술의 상호 협조 및 정보교환
5. 보안공학에 관한 표준화 사업 및 규격의 제정
6. 보안공학에 관한 산학연 협동의 증진
7. 국제적 학술 교류 및 기술 협력
8. 보안공학에 관한 논문지 발간
9. 기타 본 회 목적 달성에 필요한 사업
간행물
간행물명
International Journal of Database Theory and Application
간기
격월간
pISSN
2005-4270
수록기간
2008~2016
십진분류
KDC 505DDC 605
이 권호 내 다른 논문 / International Journal of Database Theory and Application Vol.6 No.4