The Community for Technology Leaders
RSS Icon
Subscribe
Banff, Alta.
Sept. 6, 2007 to Sept. 8, 2007
ISBN: 978-0-7695-2947-9
pp: 72-84
Elizabeth O'Neil , University of Massachusetts at Boston, USA
Patrick O'Neil , University of Massachusetts at Boston, USA
Kesheng Wu , Lawrence Berkeley National Laboratory, USA
ABSTRACT
Historically, bitmap indexing has provided an important database capability to accelerate queries. However, only a few database systems have implemented these indexes because of the difficulties of modifying fundamental assumptions in the lowlevel design of a database system and in the expectations of customers, both of which have developed in an environment that does not support bitmap indexes. Another problem that arises, and one that may more easily be addressed by a research article, is that there is no definitive design for bitmap indexes; bitmap index designs in Oracle, Sybase IQ, Vertica and MODEL 204 are idiosyncratic, and some of them were designed for older machine architectures. <p>To investigate an efficient design on modern processors, this paper provides details of the Set Query benchmark and a comparison of two research implementations of bitmap indexes. One, called RIDBit, uses the N-ary storage model to organize table rows, and implements a strategy that gracefully switches between the well-known B-tree RID-list structure and a bitmap structure. The other, called FastBit is based on vertical organization of the table data, where all columns are individually stored. It implements a compressed bitmap index, with a linear organization of the bitmaps to optimize disk accesses. Through this comparison, we evaluate the pros and cons of various design choices. Our analysis adds a number of subtleties to the conventional indexing wisdom commonly quoted in the database community.</p>
INDEX TERMS
null
CITATION
Elizabeth O'Neil, Patrick O'Neil, Kesheng Wu, "Bitmap Index Design Choices and Their Performance Implications", IDEAS, 2007, 2007 11th International Database Engineering and Applications Symposium, IDEAS-07, 2007 11th International Database Engineering and Applications Symposium, IDEAS-07 2007, pp. 72-84, doi:10.1109/IDEAS.2007.19
20 ms
(Ver 2.0)

Marketing Automation Platform Marketing Automation Tool