基于索引列聚集的HBase二级索引设计

HBase is a open-source column-oriented storage database of Apache and it solves massive data storage problem in some degree. But because HBase lacks function of secondary index, query on non-rowkey columns must be done through filter and whole table scan, which is low performance in big data scenario. This paper proposed an index column aggregation scheme of secondary index based on structure of rowkey\'s index and structure of secondary index in relational database. Besides, the secondary index mechanism proposed by this paper also supported composite index and special index column value senario, which enhanced the performance of secondary index and broadened the applicable scenario of HBase secondary index. In the end, this paper built system test and verified that the secondary index greatly promoted the query efficiency of HBase.