DBScholar

Back to papers

FITing-Tree: A Data-aware Index Structure

Summary: FITing-Tree presents a data-aware index that uses piecewise-linear approximations bounded by a tunable error. A cost model selects the error to balance lookup latency and storage, delivering near full-index performance with orders of magnitude less memory on real datasets. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h9761bd39cb86219d
Venue
SIGMOD
Year
2019
Pagerank
0.00014030069
Overall Rank
779 | 94.77%
DOI
10.1145/3299869.3319860

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{galakatos_sigmod19,
        title = {{FITing-Tree: A Data-aware Index Structure}},
        author = {Galakatos, Alex and Markovitch, Michael and Binnig, Carsten and Fonseca, Rodrigo and Kraska, Tim},
        series = {{SIGMOD} '19},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3299869.3319860},
        url = {https://dl.acm.org/doi/10.1145/3299869.3319860},
        year = {2019}
}

Incoming Citations (Sorted by Pagerank)

Showing 19 of 69 citing papers.

Rank Citing Paper Year Venue Pagerank
9,910 Cardinality Estimation for Similarity Search on High-Dimensional Data Objects: The Impact of Reference Objects 2025 VLDB 5.1103839e-05
9,918 Route Travel Time Estimation on A Road Network Revisited: Heterogeneity, Proximity, Periodicity and Dynamicity 2023 VLDB 5.1103839e-05
10,185 SWIX: A Memory-efficient Sliding Window Learned Index 2024 SIGMOD 5.0651993e-05
10,217 DBMS Fitting: Why should we learn what we already know? 2020 CIDR 5.0582281e-05
10,322 SSCard: Substring Cardinality Estimation using Suffix Tree-Guided Learned FM-Index 2026 SIGMOD 5.0346745e-05
10,475 LINE: A Learned Index with Group-Enhanced Leaves and Cache-Optimized Inner Tree 2026 SIGMOD 4.9793485e-05
10,480 Mathematical Foundations of Poisoning Attacks on Linear Regression over Cumulative Distribution Functions 2026 SIGMOD 4.9793485e-05
10,489 On Self-Designing Learned Indexes 2026 SIGMOD 4.9793485e-05
10,575 High Performance or Low Memory? An Updatable Learned Index Framework for Time-Space Tradeoff 2026 SIGMOD 4.9793485e-05
10,645 From Learning to Recycling: A Log-Structured Learned-Less Index 2026 SIGMOD 4.9793485e-05
10,648 HIRE: A Hybrid Learned Index for Robust and Efficient Performance under Mixed Workloads 2026 SIGMOD 4.9793485e-05
10,656 LM-Tree: A Hybrid Learned Index for Similarity Search in Metric Spaces 2026 SIGMOD 4.9793485e-05
10,691 The Case For Language Model Approximated LIKE Predicate 2026 SIGMOD 4.9793485e-05
10,751 Toward Drift-Aware Database Benchmarking 2026 VLDB 4.9793485e-05
10,764 Kirin: Efficient In-Storage Learned Compaction for LSM-Trees via System-Algorithm Co-Design 2026 VLDB 4.9793485e-05
10,844 Rethinking Learned Index and LSM-tree Integration 2026 VLDB 4.9793485e-05
11,064 LiBox: A Learned Index as an Array to Minimize Last-Mile Search 2026 VLDB 4.9793485e-05
11,122 VEGA: An Active-tuning Learned Index with Group-Wise Learning Granularity 2025 SIGMOD 4.9793485e-05
11,342 DobLIX: A Dual-Objective Learned Index for Log-Structured Merge Trees 2025 VLDB 4.9793485e-05
Previous Page 2 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 19 of 19 cited papers.

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

Rank Cited Paper Year Venue Pagerank
34 The Design Of Postgres 1986 SIGMOD 0.00049142315
40 The Case for Learned Index Structures 2018 SIGMOD 0.00046284649
216 Small Materialized Aggregates: A Light Weight Index Structure for Data Warehousing 1998 VLDB 0.00024485024
253 Database Cracking 2007 CIDR 0.00023042111
282 FAST: Fast Architecture Sensitive Tree Search on Modern CPUs and GPUs 2010 SIGMOD 0.00022264207
400 Monkey: Optimal Navigable Key-Value Store 2017 SIGMOD 0.00019129175
773 Bitmap Index Design and Evaluation 1998 SIGMOD 0.00014084831
811 Dimensionality Reduction for Similarity Searching in Dynamic Databases 1998 SIGMOD 0.00013745617
954 RDF-3X: a RISC-style Engine for RDF 2008 VLDB 0.00012867202
971 Reducing the Storage Overhead of Main-Memory OLTP Databases with Hybrid Indexes 2016 SIGMOD 0.00012766019
1,510 BF-Tree: Approximate Tree Indexing 2014 VLDB 0.00010438563
1,671 Efficient Parallel Lists Intersection and Index Compression Algorithms using Graphics Processing Units 2011 VLDB 9.9310625e-05
1,713 Online Piece-wise Linear Approximation of Numerical Streams with Precision Guarantees 2009 VLDB 9.8143771e-05
1,896 Performance Measurements of Compressed Bitmap Indices 1999 VLDB 9.4099587e-05
2,329 Correlation Maps: A Compressed Access Method for Exploiting Soft Functional Dependencies 2009 VLDB 8.6292256e-05
3,419 Revisiting Reuse for Approximate Query Processing 2017 VLDB 7.3190065e-05
3,597 Two Birds, One Stone: A Fast, yet Lightweight, Indexing Scheme for Modern Database Systems 2017 VLDB 7.1788912e-05
4,810 UpBit: Scalable In-Memory Updatable Bitmap Indexing 2016 SIGMOD 6.4050834e-05
4,885 Design Tradeoffs of Data Access Methods 2016 SIGMOD 6.3706825e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 10,575 High Performance or Low Memory? An Updatable Learned Index Framework for Time-Space Tradeoff 2026 SIGMOD
2 8,378 Tuning Hierarchical Learned Indexes on Disk and Beyond 2022 SIGMOD
3 9,786 Memory-Efficient Search Trees for Database Management Systems 2021 SIGMOD
4 7,831 The hcC-tree: An Efficient Index Structure For Object Oriented Databases 1994 VLDB
5 6,452 Just-In-Time Data Structures 2015 CIDR
6 1,550 Updatable Learned Index with Precise Positions 2021 VLDB
7 1,841 Main-Memory Index Structures with Fixed-Size Partial Keys 2001 SIGMOD
8 8,856 Adaptive Index Structures 2002 VLDB
9 7,154 Adaptive Hybrid Indexes 2022 SIGMOD
10 229 A Study of Index Structures for Main Memory Database Management Systems 1986 VLDB