Abstract:The amount of data managed in today's Cloud systems has reached an unprecedented scale. In order to speed up query processing, an effective mechanism is to build indexes on attributes that are used in query predicates. However, conventional indexing schemes fail to provide a scalable service: as the size of these indexes are proportional to the data size, it is not space efficient to build many indexes. As such, it becomes more crucial to develop effective index to provide scalable database services in the Cloud. In this paper, we propose a compact bitmap indexing scheme for a large-scale data store. The bitmap indexing scheme combines state-of-the-art bitmap compression techniques, such as WAH encoding and bit-sliced encoding. To further reduce the index cost, a novel and query efficient partial indexing technique is adopted, which dynamically refreshes the index to handle updates and process queries. The intuition of our indexing approach is to maximize the number of indexed attributes, so that a wider range of queries, including range and join queries, can be efficiently supported. Our indexing scheme is light-weight and its creation can be seamlessly grafted onto the MapReduce processing engine without incurring significant running cost. Moreover, the compactness allows us to maintain the bitmap indexes in memory so that performance overhead of index access is minimal. We implement our indexing scheme on top of the underlying Distributed File System (DFS) and evaluate its performance on an in-house cluster. We compare our index-based query processing with HadoopDB to show its superior performance. Our experimental results confirm the effectiveness, efficiency and scalability of the indexing scheme.

Estore: An Effective Optimized Data Placement Structure For Hive

RCFile: A Fast and Space-Efficient Data Placement Structure in MapReduce-based Warehouse Systems

Accelerating Apache Hive with MPI for Data Warehouse Systems

Evaluating partitioning and bucketing strategies for Hive-based Big Data Warehousing systems

Ustore: an Optimized Storage System for Enterprise Data Warehouses at Unionpay

Scalable RDF store based on HBase and MapReduce

DualTable: A hybrid storage model for update optimization in Hive

R-Store: A scalable distributed system for supporting real-time analytics

An Efficient and Compact Indexing Scheme for Large-Scale Data Store.

Query optimization for massively parallel data processing.

EStore: A User-Friendly Encrypted Storage Scheme for Distributed File Systems

SciHive: Array-Based Query Processing with HiveQL

Super Rack: Reusing the Results of Queries in MapReduce Systems

Efficient Distributed Query Processing in Large RFID-enabled Supply Chains

E3: an Elastic Execution Engine for Scalable Data Processing.

HBaseSpatial: A Scalable Spatial Data Storage Based on HBase

Apache Hive: From MapReduce to Enterprise-grade Big Data Warehousing

Indexing multi-dimensional data in a cloud system.

Reusing the Results of Queries in MapReduce Systems by Adopting Shared Storage.

An Improved Multi-Dimensional Storage Structure for Data Warehousing

Hybrid storage architecture and efficient MapReduce processing for unstructured data