DB+-tree: A new variant of B+-tree for main-memory database systems

The B-tree and its variants are an indispensable tool for database systems and applications. Hence the efficiency of the B-tree is one of the few critical factors that determine the performance of a database system. In main-memory database systems, the computational overhead intrinsic in the B-tree...

Full description

Saved in:
Bibliographic Details
Published in:Information systems (Oxford) Vol. 119; p. 102287
Main Authors: Kwon, Yongsik, Lee, Seonho, Nam, Yehyun, Na, Joong Chae, Park, Kunsoo, Cha, Sang K., Moon, Bongki
Format: Journal Article
Language:English
Published: Elsevier Ltd 01.10.2023
Subjects:
B+-tree
Branching algorithm
Distinction bit slice
Point search
Range search
Trie
Update operations
Update operations
Range search
Point search
Branching algorithm
Distinction bit slice
Trie
B+-tree
ISSN:0306-4379, 1873-6076
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:The B-tree and its variants are an indispensable tool for database systems and applications. Hence the efficiency of the B-tree is one of the few critical factors that determine the performance of a database system. In main-memory database systems, the computational overhead intrinsic in the B-tree algorithms for branching becomes the dominant factor in performance. In this paper, we propose yet another but disruptive variant of the B+-tree called the DB+-tree that redesigns the node structure for faster branching operations. The novel branching algorithm of the DB+-tree can be implemented in an O(1) number of SIMD and other sequential instructions, which supports fast branching, and this leads to efficient point search, range search, and update operations. •DB+ tree redesigns the node structure of B+ tree for faster branching operation•Our branching algorithm can be implemented in an O(1) number of instructions•DB+ tree performs point search 170% faster than pkB-tree.•DB+ tree performs range search 130% faster than pkB-tree.•DB+ tree performs insertions and deletions 140% faster than pkB-tree.
ISSN:0306-4379
1873-6076
DOI:10.1016/j.is.2023.102287