Title :
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
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;
Conference_Titel :
Big Data and Smart Computing (BIGCOMP), 2014 International Conference on
Conference_Location :
Bangkok
DOI :
10.1109/BIGCOMP.2014.6741428
