Efficient star join for column-oriented data store in the MapReduce environment

  • Haitong Zhu*
  • , Minqi Zhou
  • , Fan Xia
  • , Aoying Zhou
  • *Corresponding author for this work

Research output: Chapter in Book/Report/Conference proceedingConference contributionpeer-review

5 Scopus citations

Abstract

MapReduce is a parallel computing paradigm that has gained a lot of attention from both industry and academia recent years. Unlike parallel DBMSs, with MapReduce, it is easier for non-expert to develop scalable parallel programs for analytical applications over huge data sets across clusters of commodity machines. As the nature of scan-oriented processing, the performance of MapReduce for relation operators can be enhanced dramatically since it is inevitably accessing lots of unnecessary data tuples, especially for table join operators. In this paper, we propose an efficient star join strategy called HdBmp join for column-oriented data store by using a three-level content aware index (i.e., HdBmp Index). Armed with this index, most of the unnecessary tuples in the join processing can be filtered out, and consequently result in immense reduction in both communication cost and execution time. Our extensive experimental studies confirm the efficiency, scalability and effectiveness of our new proposed join methods.

Original languageEnglish
Title of host publicationProceedings -8th Web Information Systems and Applications Conference,WISA 2011,Workshop on Semantic Web and Ontology, SWON 2011 Workshop on Electronic Government Technology and Application, EGTA 2011
Pages13-18
Number of pages6
DOIs
StatePublished - 2011
Event8th Web Information Systems and Applications Conference, WISA 2011, Workshop on Semantic Web and Ontology, SWON 2011, Workshop on Electronic Government Technology and Application, EGTA 2011 - Chongqing, China
Duration: 21 Oct 201123 Oct 2011

Publication series

NameProceedings -8th Web Information Systems and Applications Conference, WISA 2011, Workshop on Semantic Web and Ontology,SWON 2011,Workshop on Electronic Government Technology and Application,EGTA 2011

Conference

Conference8th Web Information Systems and Applications Conference, WISA 2011, Workshop on Semantic Web and Ontology, SWON 2011, Workshop on Electronic Government Technology and Application, EGTA 2011
Country/TerritoryChina
CityChongqing
Period21/10/1123/10/11

Keywords

  • Column store
  • HdBmp index
  • HdBmp join
  • Star join

Fingerprint

Dive into the research topics of 'Efficient star join for column-oriented data store in the MapReduce environment'. Together they form a unique fingerprint.

Cite this