Conference proceeding
Update Conscious Bitmap Indices
19th International Conference on Scientific and Statistical Database Management (SSDBM 2007), pp.15-15
07/2007
DOI: 10.1109/SSDBM.2007.24
Abstract
Bitmap indices have been widely used in several domains such as data warehousing and scientific applications due to their efficiency in answering certain query types over large data sets. However, their utilization has been largely limited to read-only data sets or to static snapshots of data due to the cost associated with the update and append of new data. Typically, several bitmaps are associated with each indexed attribute in a table, i.e. one for each attribute value, bin, or range. Each one of these bitmaps needs to be updated to reflect a new, appended row. Since a given table could be represented by hundreds or even thousands of bitmaps, the insertion of a single record can be prohibitively costly. In order to transfer the fast query response times offered by bitmap indices to dynamic database domains, we propose an update conscious bitmap index that provides a mechanism to quickly update bitmaps to reflect dynamic database changes. For an insert operation only the bitmaps that represent the values being inserted need to be updated. We formalize the insert and delete operations of the proposed technique and provide a cost model for bitmap updates. We compare the update conscious bitmaps to traditional bitmaps in terms of storage space, update performance, and query execution time.
Details
- Title: Subtitle
- Update Conscious Bitmap Indices
- Creators
- Guadalupe Canahuate - Ohio State UniversityMichael Gibas - Ohio State UniversityHakan Ferhatosmanoglu - Ohio State University
- Resource Type
- Conference proceeding
- Publication Details
- 19th International Conference on Scientific and Statistical Database Management (SSDBM 2007), pp.15-15
- Publisher
- IEEE
- DOI
- 10.1109/SSDBM.2007.24
- ISSN
- 1551-6393
- Language
- English
- Date published
- 07/2007
- Academic Unit
- Electrical and Computer Engineering
- Record Identifier
- 9984197104602771
Metrics
9 Record Views