B+-tree Index Optimization by Exploiting Internal Parallelism of Flash-based Solid State Drives

Details B+-tree Index Optimization by Exploiting Internal Parallelism of Flash-based Solid State Drives B+-tree Index Optimization by Exploiting Internal Parallelism of Flash-based Solid State Drives

2011-12-31

arxiv.org/abs/1201.0227v1

Proceedings of the VLDB Endowment (PVLDB), Vol. 5, No. 4, pp. 286-297 (2011)

Computer Science

Databases

VLDB2012

Scientific paper

Previous research addressed the potential problems of the hard-disk oriented design of DBMSs of flashSSDs. In this paper, we focus on exploiting potential benefits of flashSSDs. First, we examine the internal parallelism issues of flashSSDs by conducting benchmarks to various flashSSDs. Then, we suggest algorithm-design principles in order to best benefit from the internal parallelism. We present a new I/O request concept, called psync I/O that can exploit the internal parallelism of flashSSDs in a single process. Based on these ideas, we introduce B+-tree optimization methods in order to utilize internal parallelism. By integrating the results of these methods, we present a B+-tree variant, PIO B-tree. We confirmed that each optimization method substantially enhances the index performance. Consequently, PIO B-tree enhanced B+-tree's insert performance by a factor of up to 16.3, while improving point-search performance by a factor of 1.2. The range search of PIO B-tree was up to 5 times faster than that of the B+-tree. Moreover, PIO B-tree outperformed other flash-aware indexes in various synthetic workloads. We also confirmed that PIO B-tree outperforms B+-tree in index traces collected inside the Postgresql DBMS with TPC-C benchmark.

Affiliated with

Also associated with

No associations

Rating

B+-tree Index Optimization by Exploiting Internal Parallelism of Flash-based Solid State Drives does not yet have a rating. At this time, there are no reviews or comments for this scientific paper.

If you have personal experience with B+-tree Index Optimization by Exploiting Internal Parallelism of Flash-based Solid State Drives, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and B+-tree Index Optimization by Exploiting Internal Parallelism of Flash-based Solid State Drives will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFWR-SCP-O-672805