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: 5838
Venue: SIGMOD
Year: 2020
Pagerank: 6.1913331e-05
Overall Rank: 5,512 | 62.19%
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,602	Predicate Caching: Query-Driven Secondary Indexing for Cloud Data Warehouses	2024	SIGMOD	5.8246665e-05
7,412	RTScan: Efficient Scan with Ray Tracing Cores	2024	VLDB	5.624223e-05
7,960	CUBIT: Concurrent Updatable Bitmap Indexing	2025	VLDB	5.5181056e-05
8,370	Cabin: a Compressed Adaptive Binned Scan Index	2024	SIGMOD	5.4409293e-05
10,124	Raster is Faster: Rethinking Ray Tracing in Database Indexing	2026	CIDR	5.093636e-05
10,395	RABIT: Efficient Range Queries with Bitmap Indexing	2026	SIGMOD	5.093636e-05
10,588	RayDB: Building Databases with Ray Tracing Cores	2026	VLDB	5.093636e-05
11,702	LES3: Learning-based Exact Set Similarity Search	2021	VLDB	5.093636e-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.0024089429
12	C-Store: A Column-oriented DBMS	2005	VLDB	0.00069513174
29	Database Architecture Optimized for the New Bottleneck: Memory Access	1999	VLDB	0.00052093615
60	Integrating Compression and Execution in Column-Oriented Database Systems	2006	SIGMOD	0.0003955489
104	Improved Query Performance with Variant Indexes	1997	SIGMOD	0.00033932213
216	SIMD-Scan: Ultra Fast in-Memory Table Scan using on-Chip Vector Processing Units	2009	VLDB	0.00024498128
227	Small Materialized Aggregates: A Light Weight Index Structure for Data Warehousing	1998	VLDB	0.00023958508
293	Implementing Database Operations Using SIMD Instructions	2002	SIGMOD	0.00022259273
634	Rethinking SIMD Vectorization for In-Memory Databases	2015	SIGMOD	0.00015533814
670	SharedDB: Killing One Thousand Queries With One Stone	2012	VLDB	0.00015157572
696	Main-Memory Scan Sharing For Multi-Core CPUs	2008	VLDB	0.00014891322
761	Cooperative Scans: Dynamic Bandwidth Sharing in a DBMS	2007	VLDB	0.00014254351
794	Bitmap Index Design and Evaluation	1998	SIGMOD	0.00013969303
870	BitWeaving: Fast Scans for Main Memory Data Processing	2013	SIGMOD	0.0001350293
925	Dictionary-based Order-preserving String Compression for Main Memory Column Stores	2009	SIGMOD	0.00013182044
1,044	Fine-grained Partitioning for Aggressive Data Skipping	2014	SIGMOD	0.0001244236
1,315	Fast Updates on Read-Optimized Databases Using Multi-Core CPUs	2012	VLDB	0.00011181796
1,464	An Efficient Bitmap Encoding Scheme for Selection Queries	1999	SIGMOD	0.00010689981
1,507	Column Imprints: A Secondary Index Structure	2013	SIGMOD	0.0001054177
1,761	ByteSlice: Pushing the Envelop of Main Memory Data Processing with a New Storage Layout	2015	SIGMOD	9.8154969e-05
2,224	An Experimental Study of Bitmap Compression vs. Inverted List Compression	2017	SIGMOD	8.9183396e-05
2,232	Database Compression on Graphics Processors	2010	VLDB	8.8970926e-05
2,276	Shared Workload Optimization	2014	VLDB	8.8196376e-05
2,937	Column Sketches: A Scan Accelerator for Rapid and Robust Predicate Evaluation	2018	SIGMOD	7.9435581e-05
3,106	Skipping-oriented Partitioning for Columnar Layouts	2017	VLDB	7.7515666e-05
3,598	Access Path Selection in Main-Memory Optimized Data Systems: Should I Scan or Should I Probe?	2017	SIGMOD	7.2718988e-05
4,330	Sharing Data and Work Across Concurrent Analytical Queries	2013	VLDB	6.7563122e-05
6,653	Adaptive Data Skipping in Main-Memory Systems	2016	SIGMOD	5.8138531e-05

Semantically Similar Papers

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