DBScholar

Back to papers

Dissecting, Designing, and Optimizing LSM-based Data Stores

Summary: Structured, tutorial-like treatment of LSM trees, detailing core operations, access paths, and ingestion/compaction tradeoffs for researchers. Surveys recent optimizations and the design space across ingestion, reads, and queries, offering a roadmap to tune LSM engines and identify open challenges. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h67a6cd004c4bb95b
Venue
SIGMOD
Year
2022
Pagerank
6.2789973e-05
Overall Rank
5,065 | 66.05%
DOI
10.1145/3514221.3522563

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{sarkar_sigmod22,
        title = {{Dissecting, Designing, and Optimizing LSM-based Data Stores}},
        author = {Sarkar, Subhadeep and Athanassoulis, Manos},
        series = {{SIGMOD} '22},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3514221.3522563},
        url = {https://dl.acm.org/doi/10.1145/3514221.3522563},
        year = {2022}
}

Incoming Citations (Sorted by Pagerank)

Showing 10 of 10 citing papers.

Rank Citing Paper Year Venue Pagerank
7,925 CAMAL: Optimizing LSM-trees via Active Learning 2024 SIGMOD 5.4086685e-05
8,638 Limousine: Blending Learned and Classical Indexes to Self-Design Larger-than-Memory Cloud Storage Engines 2024 SIGMOD 5.2825944e-05
9,085 BACH: Bridging Adjacency List and CSR Format using LSM-Trees for HGTAP Workloads 2025 VLDB 5.2097768e-05
9,818 NEXT: A New Secondary Index Framework for LSM-based Data Storage 2025 SIGMOD 5.1111219e-05
10,073 LavaStore: ByteDance's Purpose-built, High-performance, Cost-effective Local Storage Engine for Cloud Services 2024 VLDB 5.0732737e-05
10,335 DobLIX: A Dual-Objective Learned Index for Log-Structured Merge Trees 2025 VLDB 5.0225409e-05
10,730 Making LSM-Tree-based Key-Value Store Practical and Efficient for Multi-Tenant Serverless Cloud Databases 2026 SIGMOD 4.9605343e-05
10,838 IncreQueryFusion: On-demand Data Fusion Framework in Dynamic Data Lakes 2026 VLDB 4.9605343e-05
11,640 On Reducing Space Amplification with Multi-Column Compaction in Apache IoTDB 2024 VLDB 4.9605343e-05
11,726 Data Pipes: Declarative Control over Data Movement 2023 CIDR 4.9605343e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 40 of 40 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
40 The Case for Learned Index Structures 2018 SIGMOD 0.00046249672
177 The Vertica Analytic Database: C-Store 7 Years Later 2012 VLDB 0.00026571747
216 Small Materialized Aggregates: A Light Weight Index Structure for Data Warehousing 1998 VLDB 0.00024446892
261 bLSM: A General Purpose Log Structured Merge Tree 2012 SIGMOD 0.00022862412
402 Monkey: Optimal Navigable Key-Value Store 2017 SIGMOD 0.00019070605
438 Optimizing Space Amplification in RocksDB 2017 CIDR 0.00018259155
461 The PGM-index: a fully-dynamic compressed learned index with provable worst-case bounds 2020 VLDB 0.00017835351
549 Faster: A Concurrent Key-Value Store with In-Place Updates 2018 SIGMOD 0.00016530268
761 Dostoevsky: Better Space-Time Trade-Offs for LSM-Tree Based Key-Value Stores via Adaptive Removal of Superfluous Merging 2018 SIGMOD 0.00014191047
814 SlimDB: A Space-Efficient Key-Value Storage Engine For Semi-Sorted Data 2017 VLDB 0.00013697533
818 Design, Implementation, and Performance of the LHAM Log-Structured History Data Access Method 1998 VLDB 0.00013657405
892 SuRF: Practical Range Query Filtering with Fast Succinct Tries 2018 SIGMOD 0.00013207671
923 AsterixDB: A Scalable, Open Source BDMS 2014 VLDB 0.00013034457
1,147 MyRocks: LSM-Tree Database Storage Engine Serving Facebook's Social Graph 2020 VLDB 0.00011777851
1,324 X-Engine: An Optimized Storage Engine for Large-scale E-commerce Transaction Processing 2019 SIGMOD 0.00011019001
1,327 Hybrid Transactional/Analytical Processing: A Survey 2017 SIGMOD 0.00011014905
1,429 The Log-Structured Merge-Bush & the Wacky Continuum 2019 SIGMOD 0.00010685393
1,611 The Data Calculator*: Data Structure Design and Cost Synthesis from First Principles and Learned Cost Models 2018 SIGMOD 0.00010066379
1,856 Morton Filters: Faster, Space-Efficient Cuckoo Filters via Biasing, Compression, and Decoupled Logical Sparsity 2018 VLDB 9.4802321e-05
1,900 Design Continuums and the Path Toward Self-Designing Key-Value Stores that Know and Learn 2019 CIDR 9.3926585e-05
1,991 Chucky: A Succinct Cuckoo Filter for LSM-Tree 2021 SIGMOD 9.2264312e-05
2,667 Rosetta: A Robust Space-Time Optimized Range Filter for Key-Value Stores 2020 SIGMOD 8.1324472e-05
2,780 Constructing and Analyzing the LSM Compaction Design Space 2021 VLDB 8.0073289e-05
2,796 Lethe: A Tunable Delete-Aware LSM Engine 2020 SIGMOD 7.9849253e-05
3,489 Cosine: A Cloud-Cost Optimized Self-Designing Key-Value Storage Engine 2022 VLDB 7.2421958e-05
3,532 Key-Value Storage Engines 2020 SIGMOD 7.2054521e-05
3,650 Nova-LSM: A Distributed, Component-based LSM-tree Key-value Store 2021 SIGMOD 7.1170026e-05
3,679 Leaper: A Learned Prefetcher for Cache Invalidation in LSM-tree based Storage Engines 2020 VLDB 7.0849238e-05
4,141 On Performance Stability in LSM-based Storage Systems 2020 VLDB 6.7690985e-05
4,897 Design Tradeoffs of Data Access Methods 2016 SIGMOD 6.3489205e-05
4,970 A Comparative Study of Secondary Indexing Techniques in LSM-based NoSQL Databases 2018 SIGMOD 6.3213732e-05
5,046 Breaking Down Memory Walls: Adaptive Memory Management in LSM-based Storage Systems 2021 VLDB 6.2884087e-05
5,272 Endure: A Robust Tuning Paradigm for LSM Trees Under Workload Uncertainty 2022 VLDB 6.1887235e-05
5,651 MaSM: Efficient Online Updates in Data Warehouses 2011 SIGMOD 6.0346713e-05
5,867 An LSM-based Tuple Compaction Framework for Apache AsterixDB 2020 VLDB 5.9486081e-05
5,894 Compactionary: A Dictionary for LSM Compactions 2022 SIGMOD 5.9390155e-05
6,581 Big Data Space Fungus 2015 CIDR 5.7248836e-05
6,954 Breaking Down Memory Walls in LSM-based Storage Systems 2020 SIGMOD 5.6196724e-05
7,328 Immutability Changes Everything 2015 CIDR 5.5371703e-05
7,609 Efficient Data Ingestion and Query Processing for LSM-Based Storage Systems 2019 VLDB 5.46888e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 10,563 O3-LSM: Maximizing Disaggregated LSM Write Performance via Three-Layer Offloading 2026 SIGMOD
2 9,162 Rethinking The Compaction Policies in LSM-trees 2025 SIGMOD
3 5,894 Compactionary: A Dictionary for LSM Compactions 2022 SIGMOD
4 5,046 Breaking Down Memory Walls: Adaptive Memory Management in LSM-based Storage Systems 2021 VLDB
5 9,215 Structural Designs Meet Optimality: Exploring Optimized LSM-tree Structures in A Colossal Configuration Space 2024 SIGMOD
6 12,257 Splaying Log-Structured Merge-Trees 2018 SIGMOD
7 4,141 On Performance Stability in LSM-based Storage Systems 2020 VLDB
8 2,780 Constructing and Analyzing the LSM Compaction Design Space 2021 VLDB
9 6,954 Breaking Down Memory Walls in LSM-based Storage Systems 2020 SIGMOD
10 7,609 Efficient Data Ingestion and Query Processing for LSM-Based Storage Systems 2019 VLDB