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.

MOSS-DB: A Hardware-Aware OLAP Database

Towards the Building of a Dense-Region-based OLAP System

DROLAP - A Dense-Region Based Approach to On-Line Analytical Processing

Multi-core vs. I/O Wall: The Approaches to Conquer and Cooperate

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

ScaMMDB: Facing Challenge of Mass Data Processing with MMDB

MiNT-OLAP Cluster: Minimizing Network Transmission Cost in OLAP Cluster for Main Memory Analytical Database

A parallel and distributed method for computing high dimensional MOLAP

Improving Performance by Creating a Native Join-Index for OLAP

Building A Fast and Efficient LSM-tree Store by Integrating Local Storage with Cloud Storage

A Framework for OLAP in Column-Store Database: One-Pass Join and Pushing the Materialization to the End.

A Performance Evaluation of DRAM Access for In-Memory Databases

Virtual Denormalization Via Array Index Reference for Main Memory OLAP.

An Efficient Multidimensional Hierarchical Clustering Storage Schema for OLAP

CDDTA-JOIN: one-pass OLAP algorithm for column-oriented databases

Simple and economical remedy for OLAP systems that can not effectively deal with ragged dimensions

P-MOSS: Learned Scheduling For Indexes Over NUMA Servers Using Low-Level Hardware Statistics

<i>SA-LSM</i>: Optimize Data Layout for LSM-tree Based Storage using Survival Analysis

Dimensional-stores technology in OLAP aggregation

Fusion OLAP: Fusing the Pros of MOLAP and ROLAP Together for In-Memory OLAP

A Novel Index-Organized Storage Model for Hybrid DRAM-PM Main Memory Database Systems