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

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Veröffentlicht in:Information systems (Oxford) 2023-10, Vol.119, p.102287, Article 102287
Hauptverfasser: Kwon, Yongsik, Lee, Seonho, Nam, Yehyun, Na, Joong Chae, Park, Kunsoo, Cha, Sang K., Moon, Bongki
Format: Artikel
Sprache:eng
Schlagworte:
Online-Zugang:Volltext
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung: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