BinDex: A Two-Layered Index for Fast and Robust Scans

Summary: BinDex is a two-layer in-memory index using binned bitmaps to filter data. By tuning the first-layer bitmaps, it trades memory for speed, surpassing prior work with less memory than a B+-tree and up to 2.9x faster scans, removing the scan-type choice. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: hac62a700dae0cff2
Venue: SIGMOD
Year: 2020
Pagerank: 6.0602908e-05
Overall Rank: 5,619 | 62.24%
DOI: 10.1145/3318464.3380563

Incoming Non-self Citations Over Time

Authors

1. Linwei Li (Fudan University)
2. Kai Zhang (Fudan University)
3. Jiading Guo (Fudan University)
4. Wen He (Fudan University)
5. Zhenying He (Fudan University)
6. Yinan Jing (Fudan University)
7. Weili Han (Fudan University)
8. X. Sean Wang (Fudan University)

BibTeX Citation

@inproceedings{li_sigmod20,
        title = {{BinDex: A Two-Layered Index for Fast and Robust Scans}},
        author = {Li, Linwei and Zhang, Kai and Guo, Jiading and He, Wen and He, Zhenying and Jing, Yinan and Han, Weili and Wang, X. Sean},
        series = {{SIGMOD} '20},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3318464.3380563},
        url = {https://dl.acm.org/doi/10.1145/3318464.3380563},
        year = {2020}
}

Incoming Citations (Sorted by Pagerank)

Showing 8 of 8 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
6,240	Predicate Caching: Query-Driven Secondary Indexing for Cloud Data Warehouses	2024	SIGMOD	5.8373399e-05
6,447	RTScan: Efficient Scan with Ray Tracing Cores	2024	VLDB	5.7798274e-05
7,486	CUBIT: Concurrent Updatable Bitmap Indexing	2025	VLDB	5.5102404e-05
8,541	Cabin: a Compressed Adaptive Binned Scan Index	2024	SIGMOD	5.3190248e-05
9,746	LES3: Learning-based Exact Set Similarity Search	2021	VLDB	5.1325223e-05
10,360	Raster is Faster: Rethinking Ray Tracing in Database Indexing	2026	CIDR	4.9769913e-05
10,602	RABIT: Efficient Range Queries with Bitmap Indexing	2026	SIGMOD	4.9769913e-05
10,946	RayDB: Building Databases with Ray Tracing Cores	2026	VLDB	4.9769913e-05

Outgoing Citations (Sorted by Pagerank)

Showing 28 of 28 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
1	Access Path Selection in a Relational Database Management System	1979	SIGMOD	0.0023943337
12	C-Store: A Column-oriented DBMS	2005	VLDB	0.0006897844
27	Database Architecture Optimized for the New Bottleneck: Memory Access	1999	VLDB	0.00051576613
61	Integrating Compression and Execution in Column-Oriented Database Systems	2006	SIGMOD	0.00039236924
107	Improved Query Performance with Variant Indexes	1997	SIGMOD	0.00033459417
216	Small Materialized Aggregates: A Light Weight Index Structure for Data Warehousing	1998	VLDB	0.00024485637
219	SIMD-Scan: Ultra Fast in-Memory Table Scan using on-Chip Vector Processing Units	2009	VLDB	0.00024367137
287	Implementing Database Operations Using SIMD Instructions	2002	SIGMOD	0.00022001327
627	Rethinking SIMD Vectorization for In-Memory Databases	2015	SIGMOD	0.00015454197
669	SharedDB: Killing One Thousand Queries With One Stone	2012	VLDB	0.00014975391
704	Main-Memory Scan Sharing For Multi-Core CPUs	2008	VLDB	0.00014653079
762	Cooperative Scans: Dynamic Bandwidth Sharing in a DBMS	2007	VLDB	0.00014134432
769	Bitmap Index Design and Evaluation	1998	SIGMOD	0.00014106166
873	BitWeaving: Fast Scans for Main Memory Data Processing	2013	SIGMOD	0.00013334067
910	Dictionary-based Order-preserving String Compression for Main Memory Column Stores	2009	SIGMOD	0.00013122392
1,036	Fine-grained Partitioning for Aggressive Data Skipping	2014	SIGMOD	0.00012372946
1,332	Fast Updates on Read-Optimized Databases Using Multi-Core CPUs	2012	VLDB	0.00010993664
1,495	An Efficient Bitmap Encoding Scheme for Selection Queries	1999	SIGMOD	0.00010493769
1,531	Column Imprints: A Secondary Index Structure	2013	SIGMOD	0.00010344951
1,718	ByteSlice: Pushing the Envelop of Main Memory Data Processing with a New Storage Layout	2015	SIGMOD	9.7983307e-05
2,011	An Experimental Study of Bitmap Compression vs. Inverted List Compression	2017	SIGMOD	9.1924806e-05
2,187	Database Compression on Graphics Processors	2010	VLDB	8.891124e-05
2,225	Shared Workload Optimization	2014	VLDB	8.8062552e-05
2,954	Column Sketches: A Scan Accelerator for Rapid and Robust Predicate Evaluation	2018	SIGMOD	7.8119682e-05
3,083	Skipping-oriented Partitioning for Columnar Layouts	2017	VLDB	7.6620866e-05
3,597	Access Path Selection in Main-Memory Optimized Data Systems: Should I Scan or Should I Probe?	2017	SIGMOD	7.1759026e-05
4,393	Sharing Data and Work Across Concurrent Analytical Queries	2013	VLDB	6.618354e-05
6,788	Adaptive Data Skipping in Main-Memory Systems	2016	SIGMOD	5.6808999e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	2,954	Column Sketches: A Scan Accelerator for Rapid and Robust Predicate Evaluation	2018	SIGMOD
2	4,771	UpBit: Scalable In-Memory Updatable Bitmap Indexing	2016	SIGMOD
3	5,601	Approximate Encoding for Direct Access and Query Processing over Compressed Bitmaps	2006	VLDB
4	1,495	An Efficient Bitmap Encoding Scheme for Selection Queries	1999	SIGMOD
5	1,531	Column Imprints: A Secondary Index Structure	2013	SIGMOD
6	2,270	FINEdex: A Fine-grained Learned Index Scheme for Scalable and Concurrent Memory Systems	2022	VLDB
7	5,950	DEX: Scalable Range Indexing on Disaggregated Memory	2024	VLDB
8	769	Bitmap Index Design and Evaluation	1998	SIGMOD
9	10,666	LiveBin: A Localized and Version-Aware Binned Scan Index	2026	SIGMOD
10	8,541	Cabin: a Compressed Adaptive Binned Scan Index	2024	SIGMOD