Abstract:Non- Volatile Memory (NVM) offers low-latency, non-volatility, and byte-addressability, positioning it as a highly promising device for database performance enhancement. Cur-rent research primarily focuses on utilizing LSM-Tree in con-junction with NVM to reduce write amplification and alleviate write stall issues. However, the comprehensive potential of NVM in simultaneously augmenting both read and write performances remains underexplored. And the previous NVM-enhanced LSM-Tree also ignores the sensitivity of NVM to small-grained random reads and writes, which we believe is the key to further improving read and write performance. To address these issues, we propose BushStore, an innovative LSM-Tree variant specifically optimized for NVM. BushStore is designed with a three-level architecture, where the higher levels of BushStore contain a group of immutable, non-clustered B+Trees, replacing traditional SSTables. By storing the non-leaf nodes in the DRAM and the leaf nodes in NVM, and separating the data pages from the indexes, these B+Trees are able to exhibit high performance for diverse read and write operations. Our approach encompasses four key techniques to significantly boost system efficiency: First, we develop novel data structures that localize read/write operations to confined NVM areas, enhancing access speed. Second, we optimize the key-value data handling during flushing and compaction phases, leveraging the superior scanning and sequantial writing capabilities of B+Trees to ex-pedite write and compaction processes. Third, we dynamically adjust the B+Tree sizes, enabling a balanced and optimized flushing and compaction process, thereby improving overall write performance. Fourth, we implement a lazy-delete Cuckoo filtering and lazy-persistent allocation strategy to accelerate query and compaction processes. Evaluations show that BushStore exhibits high performance and scalability under synthetic and real work-loads, and achieves an average performance improvement of 3.3x in random write throughput and 4.3x in random read throughput compared to the state-of-the-art MioDB system.

A prefetching indexing scheme for in-memory database systems

Path Prefetching: Accelerating Index Searches for In-Memory Databases

Improving Memory Access Performance of In-Memory Key-Value Store Using Data Prefetching Techniques

DEAM：Decoupled, Expressive, Area-Efficient Metadata Cache

BushStore: Efficient B+Tree Group Indexing for LSM-Tree in Non-Volatile Memory

Practical Temporal Prefetching With Compressed On-Chip Metadata

A Comprehensive Performance Evaluation of Modern In-Memory Indices

Towards optimal utilization of main memory for moving object indexing

Tyche: An Efficient and General Prefetcher for Indirect Memory Accesses

IMPACT: a twin-index framework for efficient moving object query processing

Taking the Shortcut: Actively Incorporating the Virtual Memory Index of the OS to Hardware-Accelerate Database Indexing

Improving In-Memory File System Reading Performance by Fine-Grained User-Space Cache Mechanisms

PI : a Parallel in-memory skip list based Index

RC-NVM: Enabling Symmetric Row and Column Memory Accesses for In-memory Databases

Reducing the Storage Overhead of Main-Memory OLTP Databases with Hybrid Indexes

A Performance Evaluation of DRAM Access for In-Memory Databases

Exploration and optimization of novel replacement and prefetching strategies for inefficiencies of advanced MRAM-based hybrid cache systems

Software Prefetching for Indirect Memory Accesses

Fast, Incremental Inverted Indexing in Main Memory for Web-Scale Collections

An Optimized Linear Skewing Interleave Scheme For On-Chip Multi-Access Memory Systems

Research on Prefetching Algrothim in PostgreSQL