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
h6b6a65ad689fb31a
Venue
SIGMOD
Year
2018
Pagerank
0.00013129817
Overall Rank
906 | 93.93%
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
834 Benchmarking Learned Indexes 2021 VLDB 0.00013539098
1,529 Updatable Learned Index with Precise Positions 2021 VLDB 0.00010320909
1,655 Aria: A Fast and Practical Deterministic OLTP Database 2020 VLDB 9.9502338e-05
2,590 Are Updatable Learned Indexes Ready? 2022 VLDB 8.2368464e-05
2,870 APEX: A High-Performance Learned Index on Persistent Memory 2022 VLDB 7.9033232e-05
3,207 CDFShop: Exploring and Optimizing Learned Index Structures 2020 SIGMOD 7.5187675e-05
3,719 CoroBase: Coroutine-Oriented Main-Memory Database Engine 2021 VLDB 7.0525094e-05
4,844 Epoch-based Commit and Replication in Distributed OLTP Databases 2021 VLDB 6.3720999e-05
4,915 Can Learned Models Replace Hash Functions? 2023 VLDB 6.3452789e-05
5,087 Spruce: A Fast yet Space-saving Structure for Dynamic Graph Storage 2024 SIGMOD 6.2664244e-05
5,398 Order-Preserving Key Compression for In-Memory Search Trees 2020 SIGMOD 6.1338952e-05
5,965 DEX: Scalable Range Indexing on Disaggregated Memory 2024 VLDB 5.9144433e-05
6,075 When Tree Meets Hash: Reducing Random Reads for Index Structures on Persistent Memories 2023 SIGMOD 5.8776022e-05
6,332 Robust Performance of Main Memory Data Structures by Configuration 2020 SIGMOD 5.7934902e-05
6,901 Evaluating Persistent Memory Range Indexes: Part Two 2022 VLDB 5.6367813e-05
7,049 BP-tree: Overcoming the Point-Range Operation Tradeoff for In-Memory B-trees 2023 VLDB 5.5967284e-05
7,103 LITS: An Optimized Learned Index for Strings 2024 VLDB 5.5824915e-05
7,314 Hyper: A High-Performance and Memory-Efficient Learned Index via Hybrid Construction 2024 SIGMOD 5.5425359e-05
7,516 B^link-hash: An Adaptive Hybrid Index for In-Memory Time-Series Databases 2023 VLDB 5.4896042e-05
8,155 Diva: Dynamic Range Filter for Var-Length Keys and Queries 2025 VLDB 5.372731e-05
8,195 Hyperion: Building the Largest In-memory Search Tree 2019 SIGMOD 5.3639085e-05
8,266 Index Checkpoints for Instant Recovery in In-Memory Database Systems 2022 VLDB 5.3498895e-05
8,668 OptiQL: Robust Optimistic Locking for Memory-Optimized Indexes 2023 SIGMOD 5.2757349e-05
8,903 Why Are Learned Indexes So Effective but Sometimes Ineffective? 2025 VLDB 5.238416e-05
9,571 GIO: Generating Efficient Matrix and Frame Readers for Custom Data Formats by Example 2023 SIGMOD 5.1430298e-05
9,725 FluidKV: Seamlessly Bridging the Gap between Indexing Performance and Memory-Footprint on Ultra-Fast Storage 2024 VLDB 5.1210873e-05
9,747 Disco: A Compact Index for LSM-trees 2025 SIGMOD 5.1177772e-05
9,814 Understanding Robustness Issues of Updatable Learned Indexes: [Experiments & Analysis] 2026 SIGMOD 5.1121061e-05
9,874 High-Ratio Compression for Machine-Generated Data 2023 SIGMOD 5.1049732e-05
10,073 LavaStore: ByteDance's Purpose-built, High-performance, Cost-effective Local Storage Engine for Cloud Services 2024 VLDB 5.0732737e-05
10,222 SWIX: A Memory-efficient Sliding Window Learned Index 2024 SIGMOD 5.0460607e-05
10,491 ART That Lasts: Persistent Multiversion Adaptive Radix Trees with Fast Atomic Range Queries 2026 SIGMOD 4.9605343e-05
10,506 Concurrent Path-Copying Update to Tree Structures 2026 SIGMOD 4.9605343e-05
10,798 SIDLE: Tree-structure Aware Indexes for CXL-based Heterogeneous Memory 2026 VLDB 4.9605343e-05
11,134 LiBox: A Learned Index as an Array to Minimize Last-Mile Search 2026 VLDB 4.9605343e-05
11,301 FB+-tree: A Memory-Optimized B+-tree with Latch-Free Update 2025 VLDB 4.9605343e-05
11,959 DBMS Annihilator: A High-Performance Database Workload Generator in Action 2022 VLDB 4.9605343e-05
12,146 Dynamic Interleaving of Content and Structure for Robust Indexing of Semi-Structured Hierarchical Data 2020 VLDB 4.9605343e-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