HaoLap: A Hadoop based OLAP system for big data

Jie Song, Chaopeng Guo, Zhi Wang, Yichan Zhang, Ge Yu, Jean-Marc Pierson

Abstract: Highlights •We implement the Hadoop based multidimensional OLAP system for big data.•We propose dimension coding and traverse algorithm to achieve the roll up operation on hierarchy of dimension values; the chunk model and partition strategy to shard the cube; the linearization and reverse-linearization algorithm to store chunks and cells; the chunk selection algorithm to optimize OLAP performance.•We compared HaoLap performance with Hive, HadoopDB, HBaseLattice, and Olap4Cloud on several big datasets and OLAP applications.