Inverted indexes vs. bitmap indexes in decision support systems

  • Authors:

  • Truls A. Bjørklund;Nils Grimsmo;Johannes Gehrke;Øystein Torbjørnsen

  • Affiliations:

  • Norwegian University of Science and Technology, Trondheim, Norway;Norwegian University of Science and Technology, Trondheim, Norway;Cornell University, Ithaca, NY, USA;Fast Search and Transfer, a Microsoft® subsidiary, Trondheim, Norway

  • Venue:
  • Proceedings of the 18th ACM conference on Information and knowledge management
  • Year:
  • 2009

Quantified Score

Hi-index 0.00

Visualization

Abstract

Bitmap indexes are widely used in Decision Support Systems (DSSs) to improve query performance. In this paper, we evaluate the use of compressed inverted indexes with adapted query processing strategies from Information Retrieval as an alternative. In a thorough experimental evaluation on both synthetic data and data from the Star Schema Benchmark, we show that inverted indexes are more compact than bitmap indexes in almost all cases. This compactness combined with efficient query processing strategies results in inverted indexes outperforming bitmap indexes for most queries, often significantly.