B2-Tree: Cache-Friendly String Indexing within B-Trees.

Josef Schmeißer, Maximilian E. Schüle, Viktor Leis, Thomas Neumann, Alfons Kemper

Research output: Chapter in Book/Report/Conference proceedingConference contributionpeer-review

4 Scopus citations

Abstract

Recently proposed index structures, that combine trie-based and comparison-based search mechanisms, considerably improve retrieval throughput for in-memory database systems. However, most of these index structures allocate small memory chunks when required. This stands in contrast to block-based index structures, that are necessary for disk-accesses of beyond main-memory database systems such as Umbra. We therefore present the B2-tree. The outer structure is identical to that of an ordinary B+-tree. It still stores elements in a dense array in sorted order, enabling efficient range scan operations. However, B2-tree is composed of multiple trees, each page integrates another trie-based search tree, which is used to determine a small memory region where a sought entry may be found. An embedded tree thereby consists of decision nodes, which operate on a single byte at a time, and span nodes, which are used to store common prefixes. This architecture usually accesses fewer cache lines than a vanilla B+-tree as shown in our performance evaluation. As a result, the B2-tree answers point queries considerably faster.

Original languageEnglish
Title of host publicationDatenbanksysteme fur Business, Technologie und Web, BTW 2021
EditorsKai-Uwe Sattler, Melanie Herschel, Wolfgang Lehner
PublisherGesellschaft fur Informatik (GI)
Pages39-58
Number of pages20
ISBN (Electronic)9783885797050
DOIs
StatePublished - 2021
Event2021 Datenbanksysteme fur Business, Technologie und Web, BTW 2021 - 2021 Database Systems for Business, Technology and Web, BTW 2021 - Dresden, Germany
Duration: 13 Sep 202117 Sep 2021

Publication series

NameLecture Notes in Informatics (LNI), Proceedings - Series of the Gesellschaft fur Informatik (GI)
VolumeP-311
ISSN (Print)1617-5468
ISSN (Electronic)2944-7682

Conference

Conference2021 Datenbanksysteme fur Business, Technologie und Web, BTW 2021 - 2021 Database Systems for Business, Technology and Web, BTW 2021
Country/TerritoryGermany
CityDresden
Period13/09/2117/09/21

Keywords

  • B-tree
  • Indexing
  • String

Fingerprint

Dive into the research topics of 'B2-Tree: Cache-Friendly String Indexing within B-Trees.'. Together they form a unique fingerprint.

Cite this