New binning strategy for bitmap indices on high cardinality attributes


Bitmap indices are the preferred indexing structures for read only & high dimensional data in data warehouses and scientific databases. High cardinality attributes pose a new challenge in terms of having space efficient bitmap indices. Binning is a common technique for reducing space requirements of bitmap indices. It is found that binning has an adverse affect on the query performance. A new efficient binning strategy is proposed for bitmap indices for high cardinality attributes. Exact bins are created based on query distribution. Exact bins are allowed to overlap. This gives a considerable performance advantage over the conventional non-overlapping bins at the expense of marginal increase in space overheads. Overlapping bins minimize the number of candidate-checks that need to be performed for a given set of queries. Algorithms are also presented for performing candidate checks more efficiently. Experimental results are presented in support of the new binning strategy.

DOI: 10.1145/1517303.1517327

Extracted Key Phrases

8 Figures and Tables

Cite this paper

@inproceedings{Goyal2009NewBS, title={New binning strategy for bitmap indices on high cardinality attributes}, author={Navneet Goyal and Yashvardhan Sharma}, booktitle={Bangalore Compute Conf.}, year={2009} }