|
Published Articles >> Table of Contents >> Abstract
11th International Database Engineering and Applications Symposium (IDEAS 2007)
pp. 72-84
Bitmap Index Design Choices and Their Performance Implications
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
Full Article Text:
 
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/IDEAS.2007.19
Send link to a friend
| 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.
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.
|
 Additional Information
|
Citation:
Elizabeth O'Neil, Patrick O'Neil, Kesheng Wu,
"Bitmap Index Design Choices and Their Performance Implications,"
ideas,
pp. 72-84,
11th International Database Engineering and Applications Symposium (IDEAS 2007),
2007
|
|
