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...

Celý popis

Uložené v:
Podrobná bibliografia
Vydané v:Information systems (Oxford) Ročník 119; s. 102287
Hlavní autori: Kwon, Yongsik, Lee, Seonho, Nam, Yehyun, Na, Joong Chae, Park, Kunsoo, Cha, Sang K., Moon, Bongki
Médium: Journal Article
Jazyk:English
Vydavateľské údaje: Elsevier Ltd 01.10.2023
Predmet:
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
On-line prístup:Získať plný text
Tagy: Pridať tag
Žiadne tagy, Buďte prvý, kto otaguje tento záznam!
Popis
Shrnutí: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