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.2998284e-05
Overall Rank
5,041 | 66.12%
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,909 CAMAL: Optimizing LSM-trees via Active Learning 2024 SIGMOD 5.4266123e-05
8,619 Limousine: Blending Learned and Classical Indexes to Self-Design Larger-than-Memory Cloud Storage Engines 2024 SIGMOD 5.3001199e-05
9,065 BACH: Bridging Adjacency List and CSR Format using LSM-Trees for HGTAP Workloads 2025 VLDB 5.2270607e-05
9,786 NEXT: A New Secondary Index Framework for LSM-based Data Storage 2025 SIGMOD 5.1280785e-05
10,034 LavaStore: ByteDance's Purpose-built, High-performance, Cost-effective Local Storage Engine for Cloud Services 2024 VLDB 5.0901047e-05
10,307 DobLIX: A Dual-Objective Learned Index for Log-Structured Merge Trees 2025 VLDB 5.0392037e-05
10,669 Making LSM-Tree-based Key-Value Store Practical and Efficient for Multi-Tenant Serverless Cloud Databases 2026 SIGMOD 4.9769913e-05
10,777 IncreQueryFusion: On-demand Data Fusion Framework in Dynamic Data Lakes 2026 VLDB 4.9769913e-05
11,592 On Reducing Space Amplification with Multi-Column Compaction in Apache IoTDB 2024 VLDB 4.9769913e-05
11,680 Data Pipes: Declarative Control over Data Movement 2023 CIDR 4.9769913e-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.00046363107
178 The Vertica Analytic Database: C-Store 7 Years Later 2012 VLDB 0.00026620521
216 Small Materialized Aggregates: A Light Weight Index Structure for Data Warehousing 1998 VLDB 0.00024485637
258 bLSM: A General Purpose Log Structured Merge Tree 2012 SIGMOD 0.00022932099
400 Monkey: Optimal Navigable Key-Value Store 2017 SIGMOD 0.00019124757
436 Optimizing Space Amplification in RocksDB 2017 CIDR 0.00018312911
458 The PGM-index: a fully-dynamic compressed learned index with provable worst-case bounds 2020 VLDB 0.00017880664
546 Faster: A Concurrent Key-Value Store with In-Place Updates 2018 SIGMOD 0.00016584272
753 Dostoevsky: Better Space-Time Trade-Offs for LSM-Tree Based Key-Value Stores via Adaptive Removal of Superfluous Merging 2018 SIGMOD 0.00014232329
816 Design, Implementation, and Performance of the LHAM Log-Structured History Data Access Method 1998 VLDB 0.00013686255
817 SlimDB: A Space-Efficient Key-Value Storage Engine For Semi-Sorted Data 2017 VLDB 0.00013685662
889 SuRF: Practical Range Query Filtering with Fast Succinct Tries 2018 SIGMOD 0.00013243846
921 AsterixDB: A Scalable, Open Source BDMS 2014 VLDB 0.00013064043
1,147 MyRocks: LSM-Tree Database Storage Engine Serving Facebook's Social Graph 2020 VLDB 0.00011810023
1,313 X-Engine: An Optimized Storage Engine for Large-scale E-commerce Transaction Processing 2019 SIGMOD 0.00011055196
1,321 Hybrid Transactional/Analytical Processing: A Survey 2017 SIGMOD 0.00011038031
1,422 The Log-Structured Merge-Bush & the Wacky Continuum 2019 SIGMOD 0.00010720711
1,606 The Data Calculator*: Data Structure Design and Cost Synthesis from First Principles and Learned Cost Models 2018 SIGMOD 0.00010091937
1,846 Morton Filters: Faster, Space-Efficient Cuckoo Filters via Biasing, Compression, and Decoupled Logical Sparsity 2018 VLDB 9.511501e-05
1,891 Design Continuums and the Path Toward Self-Designing Key-Value Stores that Know and Learn 2019 CIDR 9.4233024e-05
1,982 Chucky: A Succinct Cuckoo Filter for LSM-Tree 2021 SIGMOD 9.2570284e-05
2,664 Rosetta: A Robust Space-Time Optimized Range Filter for Key-Value Stores 2020 SIGMOD 8.1532061e-05
2,771 Constructing and Analyzing the LSM Compaction Design Space 2021 VLDB 8.0338932e-05
2,788 Lethe: A Tunable Delete-Aware LSM Engine 2020 SIGMOD 8.0114055e-05
3,480 Cosine: A Cloud-Cost Optimized Self-Designing Key-Value Storage Engine 2022 VLDB 7.2661848e-05
3,525 Key-Value Storage Engines 2020 SIGMOD 7.2293566e-05
3,643 Nova-LSM: A Distributed, Component-based LSM-tree Key-value Store 2021 SIGMOD 7.1406131e-05
3,672 Leaper: A Learned Prefetcher for Cache Invalidation in LSM-tree based Storage Engines 2020 VLDB 7.1084283e-05
4,121 On Performance Stability in LSM-based Storage Systems 2020 VLDB 6.7915554e-05
4,875 Design Tradeoffs of Data Access Methods 2016 SIGMOD 6.3699172e-05
4,943 A Comparative Study of Secondary Indexing Techniques in LSM-based NoSQL Databases 2018 SIGMOD 6.3423449e-05
5,022 Breaking Down Memory Walls: Adaptive Memory Management in LSM-based Storage Systems 2021 VLDB 6.309271e-05
5,250 Endure: A Robust Tuning Paradigm for LSM Trees Under Workload Uncertainty 2022 VLDB 6.2092552e-05
5,640 MaSM: Efficient Online Updates in Data Warehouses 2011 SIGMOD 6.0541838e-05
5,855 An LSM-based Tuple Compaction Framework for Apache AsterixDB 2020 VLDB 5.9683418e-05
5,879 Compactionary: A Dictionary for LSM Compactions 2022 SIGMOD 5.9587188e-05
6,571 Big Data Space Fungus 2015 CIDR 5.7438762e-05
6,934 Breaking Down Memory Walls in LSM-based Storage Systems 2020 SIGMOD 5.6382919e-05
7,310 Immutability Changes Everything 2015 CIDR 5.5555401e-05
7,593 Efficient Data Ingestion and Query Processing for LSM-Based Storage Systems 2019 VLDB 5.4870235e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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