Cost-based join processing scheme in a hybrid RDBMS and hive system

Author

Taewon Kim ; Haejin Chung ; Wonsuk Choi ; Jongmoo Choi ; Joonmo Kim

Author_Institution

Dept. of Comput. Eng. & Sci., Dankook Univ., Yongin, South Korea

fYear

2014

fDate

15-17 Jan. 2014

Firstpage

160

Lastpage

164

Abstract

This paper introduces Honeybee, a hybrid Hive and RDBMS system, and describes experimental results related with the performance of its query processing. According to our experimental results, in the case of join queries, unlike other queries, query processing delay becomes a problem due to an increase of the size of output data. To solve this problem, we define a new scheme IRP. We also show how the previous scheme IHP and the IRP can be combined together by carefully choosing a threshold value to further improve the join query processing performance.

Keywords

query processing; relational databases; Hive system; Honeybee; IHP; IRP; cost-based join processing scheme; hybrid RDBMS; in Hive processing scheme; in RDBMS processing scheme; join queries; join query processing performance; query processing delay; threshold value; Computer architecture; Data handling; Data storage systems; Google; Information management; Query processing; Relational databases; Cost-based join processing; Hadoop; Hive; Hybrid system; RDBMS;

fLanguage

English

Publisher

ieee

Conference_Titel

Big Data and Smart Computing (BIGCOMP), 2014 International Conference on

Conference_Location

Bangkok

Type

conf

DOI

10.1109/BIGCOMP.2014.6741428

Filename

6741428