DBScholar

Back to papers

HOT: A Height Optimized Trie Index for Main-Memory Database Systems

Summary: Height Optimized Trie (HOT) - in-memory index with per-node dynamic bit-width to maximize fanout and cache locality. Compact node layout and SIMD-accelerated search deliver superior string-key performance and smaller memory footprint vs. state-of-the-art indexes, with competitive integer-key results; a general-purpose main-memory index for DBs. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
5604
Venue
SIGMOD
Year
2018
Pagerank
0.0001342403
Overall Rank
882 | 93.96%
DOI
10.1145/3183713.3196896

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{binna_sigmod18,
        title = {{HOT: A Height Optimized Trie Index for Main-Memory Database Systems}},
        author = {Binna, Robert and Zangerle, Eva and Pichl, Martin and Specht, Günther and Leis, Viktor},
        series = {{SIGMOD} '18},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3183713.3196896},
        url = {https://dl.acm.org/doi/10.1145/3183713.3196896},
        year = {2018}
}

Incoming Citations (Sorted by Pagerank)

Showing 38 of 38 citing papers.

Rank Citing Paper Year Venue Pagerank
847 Benchmarking Learned Indexes 2021 VLDB 0.0001365768
1,551 Updatable Learned Index with Precise Positions 2021 VLDB 0.00010381398
1,700 Aria: A Fast and Practical Deterministic OLTP Database 2020 VLDB 9.9726588e-05
2,806 Are Updatable Learned Indexes Ready? 2022 VLDB 8.1013097e-05
2,910 APEX: A High-Performance Learned Index on Persistent Memory 2022 VLDB 7.9700885e-05
3,152 CDFShop: Exploring and Optimizing Learned Index Structures 2020 SIGMOD 7.7003613e-05
3,644 CoroBase: Coroutine-Oriented Main-Memory Database Engine 2021 VLDB 7.2306862e-05
4,780 Can Learned Models Replace Hash Functions? 2023 VLDB 6.5118885e-05
4,869 Epoch-based Commit and Replication in Distributed OLTP Databases 2021 VLDB 6.4709867e-05
4,946 Spruce: A Fast yet Space-saving Structure for Dynamic Graph Storage 2024 SIGMOD 6.4319457e-05
5,285 Order-Preserving Key Compression for In-Memory Search Trees 2020 SIGMOD 6.2821588e-05
5,852 DEX: Scalable Range Indexing on Disaggregated Memory 2024 VLDB 6.0658952e-05
5,954 When Tree Meets Hash: Reducing Random Reads for Index Structures on Persistent Memories 2023 SIGMOD 6.0292226e-05
6,187 Robust Performance of Main Memory Data Structures by Configuration 2020 SIGMOD 5.9485755e-05
6,733 Evaluating Persistent Memory Range Indexes: Part Two 2022 VLDB 5.7880281e-05
7,189 BP-tree: Overcoming the Point-Range Operation Tradeoff for In-Memory B-trees 2023 VLDB 5.6775326e-05
7,224 LITS: An Optimized Learned Index for Strings 2024 VLDB 5.6675134e-05
7,392 Hyper: A High-Performance and Memory-Efficient Learned Index via Hybrid Construction 2024 SIGMOD 5.6265456e-05
8,015 Hyperion: Building the Largest In-memory Search Tree 2019 SIGMOD 5.5071737e-05
8,099 Index Checkpoints for Instant Recovery in In-Memory Database Systems 2022 VLDB 5.4873906e-05
8,255 B^link-hash: An Adaptive Hybrid Index for In-Memory Time-Series Databases 2023 VLDB 5.4574671e-05
8,308 Diva: Dynamic Range Filter for Var-Length Keys and Queries 2025 VLDB 5.4562543e-05
8,474 OptiQL: Robust Optimistic Locking for Memory-Optimized Indexes 2023 SIGMOD 5.4172941e-05
8,709 Why Are Learned Indexes So Effective but Sometimes Ineffective? 2025 VLDB 5.3789739e-05
9,436 GIO: Generating Efficient Matrix and Frame Readers for Custom Data Formats by Example 2023 SIGMOD 5.2692207e-05
9,506 FluidKV: Seamlessly Bridging the Gap between Indexing Performance and Memory-Footprint on Ultra-Fast Storage 2024 VLDB 5.258497e-05
9,535 Disco: A Compact Index for LSM-trees 2025 SIGMOD 5.2533796e-05
9,599 Understanding Robustness Issues of Updatable Learned Indexes: [Experiments & Analysis] 2026 SIGMOD 5.2492748e-05
9,673 High-Ratio Compression for Machine-Generated Data 2023 SIGMOD 5.2383683e-05
9,998 SWIX: A Memory-efficient Sliding Window Learned Index 2024 SIGMOD 5.1814573e-05
10,197 ART That Lasts: Persistent Multiversion Adaptive Radix Trees with Fast Atomic Range Queries 2026 SIGMOD 5.093636e-05
10,212 Concurrent Path-Copying Update to Tree Structures 2026 SIGMOD 5.093636e-05
10,545 SIDLE: Tree-structure Aware Indexes for CXL-based Heterogeneous Memory 2026 VLDB 5.093636e-05
10,617 LiBox: A Learned Index as an Array to Minimize Last-Mile Search 2026 VLDB 5.093636e-05
10,829 FB+-tree: A Memory-Optimized B+-tree with Latch-Free Update 2025 VLDB 5.093636e-05
11,281 LavaStore: ByteDance's Purpose-built, High-performance, Cost-effective Local Storage Engine for Cloud Services 2024 VLDB 5.093636e-05
11,601 DBMS Annihilator: A High-Performance Database Workload Generator in Action 2022 VLDB 5.093636e-05
11,794 Dynamic Interleaving of Content and Structure for Robust Indexing of Semi-Structured Hierarchical Data 2020 VLDB 5.093636e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 10 of 10 cited papers.

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

Previous Page 1 / 1 Next

Semantically Similar Papers