Nothing Special   »   [go: up one dir, main page]

skip to main content
10.1145/1866480.1866497acmconferencesArticle/Chapter ViewAbstractPublication PagesideasConference Proceedingsconference-collections
research-article

Multi-level bitmap indexes for flash memory storage

Published: 16 August 2010 Publication History

Abstract

Due to their low access latency, high read speed, and power-efficient 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.

References

[1]
]]G. Graefe. The five-minute rule twenty years later, and how flash memory changes the rules. In Proc. DaMoN, pages 1--9, 2007.
[2]
]]P. O'Neil. Model 204 architecture and performance. In Proc. HPTS, volume 359 of Lecture Notes in Computer Science, pages 40--59, September 1987.
[3]
]]P. O'Neil and E. O'Neil. Database: principles, programming, and performance. Morgan Kaufmann, second edition, 2000.
[4]
]]P. O'Neil and D. Quass. Improved query performance with variant indices. In Proc. SIGMOD, pages 38--49, 1997.
[5]
]]K. Wu, E. Otoo, and A. Shoshani. Optimizing bitmap indices with efficient compression. ACM TODS, 31(1):1--38, 2006.
[6]
]]K. Wu, A. Shoshani, and K. Stockinger. Analyses of multi-level and multi-component compressed bitmap indexes. ACM TODS, 35(1):1--52, 2010.

Cited By

View all
  • (2020)High Performance Queries Using Compressed Bitmap IndexesEuro-Par 2019: Parallel Processing Workshops10.1007/978-3-030-48340-1_38(493-505)Online publication date: 29-May-2020
  • (2020)Optimizing bitmap index encoding for high performance queriesConcurrency and Computation: Practice and Experience10.1002/cpe.594333:18Online publication date: 7-Sep-2020
  • (2019)Parallel membership queries on very large scientific data sets using bitmap indexesConcurrency and Computation: Practice and Experience10.1002/cpe.515731:15Online publication date: 28-Jan-2019
  • Show More Cited By

Recommendations

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

cover image ACM Conferences
IDEAS '10: Proceedings of the Fourteenth International Database Engineering & Applications Symposium
August 2010
282 pages
ISBN:9781605589008
DOI:10.1145/1866480
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 16 August 2010

Permissions

Request permissions for this article.

Check for updates

Qualifiers

  • Research-article

Funding Sources

Conference

IDEAS '10
Sponsor:
  • ACM
  • Concordia University

Acceptance Rates

Overall Acceptance Rate 74 of 210 submissions, 35%

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)4
  • Downloads (Last 6 weeks)0
Reflects downloads up to 18 Nov 2024

Other Metrics

Citations

Cited By

View all
  • (2020)High Performance Queries Using Compressed Bitmap IndexesEuro-Par 2019: Parallel Processing Workshops10.1007/978-3-030-48340-1_38(493-505)Online publication date: 29-May-2020
  • (2020)Optimizing bitmap index encoding for high performance queriesConcurrency and Computation: Practice and Experience10.1002/cpe.594333:18Online publication date: 7-Sep-2020
  • (2019)Parallel membership queries on very large scientific data sets using bitmap indexesConcurrency and Computation: Practice and Experience10.1002/cpe.515731:15Online publication date: 28-Jan-2019
  • (2018)Optimally Leveraging Density and Locality for Exploratory Browsing and SamplingProceedings of the Workshop on Human-In-the-Loop Data Analytics10.1145/3209900.3209903(1-7)Online publication date: 10-Jun-2018
  • (2014)An Adaptive Endurance-Aware ${B^+}$ -Tree for Flash Memory Storage SystemsIEEE Transactions on Computers10.1109/TC.2013.15863:11(2661-2673)Online publication date: Nov-2014
  • (2013)Column imprintsProceedings of the 2013 ACM SIGMOD International Conference on Management of Data10.1145/2463676.2465306(893-904)Online publication date: 22-Jun-2013
  • (2011)A flash-friendly B+-tree with endurance-awareness2011 9th IEEE Symposium on Embedded Systems for Real-Time Multimedia10.1109/ESTIMedia.2011.6088523(29-36)Online publication date: Oct-2011

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Media

Figures

Other

Tables

Share

Share

Share this Publication link

Share on social media