Inverted indexes vs. bitmap indexes in decision support systems

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. Categories and Subject Descriptors: H.2.2 Database management: Physical design - access methods General Terms: Experimentation, Performance.

• Type: Conference
• Year: 2009
• Where: CIKM
• Authors: Truls A. Bjørklund, Nils Grimsmo, Johannes Gehrke, Øystein Torbjørnsen
• Keywords: Bitmap Indexes, CIKM 2009, Database, Inverted Indexes, Query Processing Strategies