Definition
An index on an attribute provides an efficient way to access data records associated with a given range of values for the indexed attribute. Typically, an index stores a list of RIDs (called a RID-list) of all the records associated with each distinct value v of the indexed attribute. In a bitmap index, each RID-list is represented in the form of a bit vector (i.e., bitmap) where the size of each bitmap is equal to the cardinality of the indexed relation, and the i-th bit in each bitmap corresponds to the i-th record in the indexed relation. The simplest bitmap index design is the Value-List index, which is illustrated in Fig. 1b for an attribute A of a 12-record relation R in Fig. 1a. In this bitmap index, there is one bitmap Ev associated with each attribute value v ϵ [0,9] such that the i-th bit of Ev is set to 1 if and only if the i-th record has a value v for the indexed attribute.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsRecommended Reading
Amer-Yahia S, Johnson T. Optimizing queries on compressed bitmaps. In: Proceedings of the 26th International Conference on Very Large Data Bases; 2000. p. 329–38.
Chan CY, Ioannidis YE. Bitmap index design and evaluation. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1998. p. 355–66.
Chan CY, Ioannidis YE. An efficient bitmap encoding scheme for selection queries. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1999. p. 215–26.
Knuth DE. Retrieval on secondary keys. Chap. 6. In: The art of computer programming: sorting and searching, vol. 3. Reading: Addison-Wesley; 1973. p. 550–67.
Koudas N. Space efficient bitmap indexing. In: Proceedings of the International Conference on Information and Knowledge Management; 2000. p. 194–201.
O’Neil P, Graefe G. Multi-table joins through bitmapped join indices. ACM SIGMOD Record. 1995;24(3)8–11.
O’Neil P, Quass D. Improved query performance with variant indexes. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1997. p. 38–49.
Reinfret D, O’Neil P, O’Neil E. Bit-sliced index arithmetic. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 2001. p. 47–57.
Sinha R, Winslett M. Multi-resolution bitmap indexes for scientific data. ACM Trans Database Syst. 2007;32(3):1–39.
Wong HKT, Liu H-F, Olken F, Rotem D, Wong L. Bit transposed files. In: Proceedings of the 11th International Conference on Very Large Data Bases; 1985. p. 448–57.
Wu MC. Query optimization for selections using nitmaps. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1999. p. 227–38.
Wu MC, Buchmann AP. Encoded bitmap indexing for data warehouses. In: Proceedings of the 14th International Conference on Data Engineering; 1998. p. 220–30.
Wu KL, Yu PS. Range-based bitmap indexing for high cardinality attributes with skew. Technical report, IBM Watson Research Center. 1996.
Wu K, Otoo EJ, Shoshani A. Optimizing bitmap indices with efficient compression. ACM Trans Database Syst. 2006;31(1):1–38.
Wu K, Shoshani A, Stockinger K. Analyses of multi-level and multi-component compressed bitmap indexes. ACM Trans Database Syst. 2010;35(1): 1–52.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Section Editor information
Rights and permissions
Copyright information
© 2018 Springer Science+Business Media, LLC, part of Springer Nature
About this entry
Cite this entry
Chan, CY. (2018). Bitmap Index. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_749
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_749
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4614-8266-6
Online ISBN: 978-1-4614-8265-9
eBook Packages: Computer ScienceReference Module Computer Science and Engineering