Multi-level bitmap indexes for flash memory storage

Kesheng Wu, Kamesh Madduri, Shane Canon

Research output: Chapter in Book/Report/Conference proceedingConference contribution

4 Citations (Scopus)

Abstract

Due to their low access latency, high read speed, and powerefficient operation, flash memory storage devices are rapidly emerging as an attractive alternative to traditional magnetic storage devices. However, tests show that the most efficient indexing methods are not able to take full advantage of flash memory storage devices. In this paper, we present a set of multi-level bitmap indexes that can effectively utilize flash storage devices. These indexing methods use coarsely binned indexes to answer queries approximately, and then use finely binned indexes to refine the answers. Our new methods read significantly lower volumes of data at the expense of an increased disk access count, thus taking full advantage of the improved read speed and low access latency of flash devices. To demonstrate the advantage of these new indexes, we measure their performance on a number of storage systems using a standard data warehousing benchmark called the Set Query Benchmark. We observe that multilevel strategies on flash drives are up to 3 times faster than traditional indexing strategies on magnetic disk drives.

Original languageEnglish (US)
Title of host publicationProceedings of the 14th International Database Engineering and Applications Symposium, IDEAS '10
Pages114-116
Number of pages3
DOIs
StatePublished - Dec 15 2010
Event14th International Database Engineering and Applications Symposium, IDEAS '10 - Montreal, QC, Canada
Duration: Aug 16 2010Aug 18 2010

Publication series

NameACM International Conference Proceeding Series

Other

Other14th International Database Engineering and Applications Symposium, IDEAS '10
CountryCanada
CityMontreal, QC
Period8/16/108/18/10

Fingerprint

Flash memory
Magnetic storage
Data warehouses
Data storage equipment

All Science Journal Classification (ASJC) codes

  • Software
  • Human-Computer Interaction
  • Computer Vision and Pattern Recognition
  • Computer Networks and Communications

Cite this

Wu, K., Madduri, K., & Canon, S. (2010). Multi-level bitmap indexes for flash memory storage. In Proceedings of the 14th International Database Engineering and Applications Symposium, IDEAS '10 (pp. 114-116). (ACM International Conference Proceeding Series). https://doi.org/10.1145/1866480.1866497
Wu, Kesheng ; Madduri, Kamesh ; Canon, Shane. / Multi-level bitmap indexes for flash memory storage. Proceedings of the 14th International Database Engineering and Applications Symposium, IDEAS '10. 2010. pp. 114-116 (ACM International Conference Proceeding Series).
@inproceedings{f85cb5c23a0e4098b4b6d5895b70b528,
title = "Multi-level bitmap indexes for flash memory storage",
abstract = "Due to their low access latency, high read speed, and powerefficient operation, flash memory storage devices are rapidly emerging as an attractive alternative to traditional magnetic storage devices. However, tests show that the most efficient indexing methods are not able to take full advantage of flash memory storage devices. In this paper, we present a set of multi-level bitmap indexes that can effectively utilize flash storage devices. These indexing methods use coarsely binned indexes to answer queries approximately, and then use finely binned indexes to refine the answers. Our new methods read significantly lower volumes of data at the expense of an increased disk access count, thus taking full advantage of the improved read speed and low access latency of flash devices. To demonstrate the advantage of these new indexes, we measure their performance on a number of storage systems using a standard data warehousing benchmark called the Set Query Benchmark. We observe that multilevel strategies on flash drives are up to 3 times faster than traditional indexing strategies on magnetic disk drives.",
author = "Kesheng Wu and Kamesh Madduri and Shane Canon",
year = "2010",
month = "12",
day = "15",
doi = "10.1145/1866480.1866497",
language = "English (US)",
isbn = "9781605589008",
series = "ACM International Conference Proceeding Series",
pages = "114--116",
booktitle = "Proceedings of the 14th International Database Engineering and Applications Symposium, IDEAS '10",

}

Wu, K, Madduri, K & Canon, S 2010, Multi-level bitmap indexes for flash memory storage. in Proceedings of the 14th International Database Engineering and Applications Symposium, IDEAS '10. ACM International Conference Proceeding Series, pp. 114-116, 14th International Database Engineering and Applications Symposium, IDEAS '10, Montreal, QC, Canada, 8/16/10. https://doi.org/10.1145/1866480.1866497

Multi-level bitmap indexes for flash memory storage. / Wu, Kesheng; Madduri, Kamesh; Canon, Shane.

Proceedings of the 14th International Database Engineering and Applications Symposium, IDEAS '10. 2010. p. 114-116 (ACM International Conference Proceeding Series).

Research output: Chapter in Book/Report/Conference proceedingConference contribution

TY - GEN

T1 - Multi-level bitmap indexes for flash memory storage

AU - Wu, Kesheng

AU - Madduri, Kamesh

AU - Canon, Shane

PY - 2010/12/15

Y1 - 2010/12/15

N2 - Due to their low access latency, high read speed, and powerefficient operation, flash memory storage devices are rapidly emerging as an attractive alternative to traditional magnetic storage devices. However, tests show that the most efficient indexing methods are not able to take full advantage of flash memory storage devices. In this paper, we present a set of multi-level bitmap indexes that can effectively utilize flash storage devices. These indexing methods use coarsely binned indexes to answer queries approximately, and then use finely binned indexes to refine the answers. Our new methods read significantly lower volumes of data at the expense of an increased disk access count, thus taking full advantage of the improved read speed and low access latency of flash devices. To demonstrate the advantage of these new indexes, we measure their performance on a number of storage systems using a standard data warehousing benchmark called the Set Query Benchmark. We observe that multilevel strategies on flash drives are up to 3 times faster than traditional indexing strategies on magnetic disk drives.

AB - Due to their low access latency, high read speed, and powerefficient operation, flash memory storage devices are rapidly emerging as an attractive alternative to traditional magnetic storage devices. However, tests show that the most efficient indexing methods are not able to take full advantage of flash memory storage devices. In this paper, we present a set of multi-level bitmap indexes that can effectively utilize flash storage devices. These indexing methods use coarsely binned indexes to answer queries approximately, and then use finely binned indexes to refine the answers. Our new methods read significantly lower volumes of data at the expense of an increased disk access count, thus taking full advantage of the improved read speed and low access latency of flash devices. To demonstrate the advantage of these new indexes, we measure their performance on a number of storage systems using a standard data warehousing benchmark called the Set Query Benchmark. We observe that multilevel strategies on flash drives are up to 3 times faster than traditional indexing strategies on magnetic disk drives.

UR - http://www.scopus.com/inward/record.url?scp=78649940437&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=78649940437&partnerID=8YFLogxK

U2 - 10.1145/1866480.1866497

DO - 10.1145/1866480.1866497

M3 - Conference contribution

SN - 9781605589008

T3 - ACM International Conference Proceeding Series

SP - 114

EP - 116

BT - Proceedings of the 14th International Database Engineering and Applications Symposium, IDEAS '10

ER -

Wu K, Madduri K, Canon S. Multi-level bitmap indexes for flash memory storage. In Proceedings of the 14th International Database Engineering and Applications Symposium, IDEAS '10. 2010. p. 114-116. (ACM International Conference Proceeding Series). https://doi.org/10.1145/1866480.1866497