The Community for Technology Leaders
Green Image
Issue No. 07 - July (2012 vol. 24)
ISSN: 1041-4347
pp: 1231-1243
Gap-Joo Na , Sungkyunkwan University, Suwon and the Electronics and Telecommunications Research Institute (ETRI), Daejon
Sang-Won Lee , Sungkyunkwan University, Suwon,
Bongki Moon , University of Arizona, Tucson
Unlike database tables, {\rm B}^{+}-tree indexes are hierarchical and their structures change over time by node splitting operations, which may propagate changes from one node to another. The node splitting operation is difficult for the basic In-Page Logging (IPL) scheme to deal with, because it involves more than one node that may be stored separately in different flash blocks. In this paper, we propose Dynamic IPL B^{+}\hbox{-}tree (d\hbox{-}IPL B^{+}\hbox{-}tree in short) as a variant of the IPL scheme tailored for flash-based {\rm B}^{+}-tree indexes. The d\hbox{-}IPL B^{+}\hbox{-}tree addresses the problem of frequent log overflow by allocating a log area in a flash block dynamically. It also avoids a page evaporation problem, imposed by the contemporary NAND flash chips, by introducing ghost nodes to d\hbox{-}IPL B^{+}\hbox{-}tree. This simple but elegant design of the d\hbox{-}IPL B^{+}\hbox{-}tree provides significant performance improvement over existing approaches. For a random insertion workload, the d\hbox{-}IPL B^{+}\hbox{-}tree outperformed a {\rm B}^{+}-tree with the plain IPL scheme by more than a factor of two in terms of page write and block erase operations.
Dynamic in-page logging, flash memory indexing, {\rm B}^{+}-tree.
Gap-Joo Na, Sang-Won Lee, Bongki Moon, "Dynamic In-Page Logging for B⁺-tree Index", IEEE Transactions on Knowledge & Data Engineering, vol. 24, no. , pp. 1231-1243, July 2012, doi:10.1109/TKDE.2011.32
82 ms
(Ver 3.3 (11022016))