BIPie: Fast Selection and Aggregation on Encoded Data using Operator Specialization

Summary: BIPie: fast selection and aggregation on encoded data via operator specialization, fusing decoding, filtering, and GROUP BY on MemSQL. Leverages SIMD and modern CPUs; 2–4× speedups vs TPC-H Q1, highlights decode/select/aggregate interdependence. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 5492
Venue: SIGMOD
Year: 2018
Pagerank: 4.302191e-05
Overall Rank: 9,671 | 32.79%
DOI: 10.1145/3183713.3190658

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
3,612	SingleStore-V: An Integrated Vector Database System in SingleStore	2024	VLDB	6.9177653e-05
5,691	Cloud-Native Transactions and Analytics in SingleStore	2022	SIGMOD	5.3697521e-05
6,218	Charting the Design Space of Query Execution using VOILA	2021	VLDB	5.1462707e-05

Outgoing Citations (Sorted by Pagerank)

Showing 9 of 9 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
35	MonetDB/X100: Hyper-Pipelining Query Execution	2005	CIDR	0.00076209479
59	Efficiently Compiling Efficient Query Plans for Modern Hardware	2011	VLDB	0.0006445664
241	DB2 with BLU Acceleration: So Much More than Just a Column Store	2013	VLDB	0.00031314629
343	Implementing Database Operations Using SIMD Instructions	2002	SIGMOD	0.00026756534
959	Rethinking SIMD Vectorization for In-Memory Databases	2015	SIGMOD	0.00015034808
1,260	Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation	2016	SIGMOD	0.00012990853
2,019	Voodoo - A Vector Algebra for Portable Database Performance on Modern Hardware	2016	VLDB	9.7814175e-05
2,419	Real-Time Analytical Processing with SQL Server	2015	VLDB	8.8485055e-05
3,150	The MemSQL Query Optimizer: A modern optimizer for real-time analytics in a distributed database	2016	VLDB	7.4765759e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
5,567	Rethinking MIMD-SIMD Interplay for Analytical Query Processing in In-Memory Database Engines	2025	CIDR	5.4288714e-05
6,367	Improving Execution Efficiency of Just-in-time Compilation based Query Processing on GPUs	2021	VLDB	5.0887599e-05
5,334	Fast In-Memory SQL Analytics on Typed Graphs	2017	VLDB	5.5625443e-05
9,625	Optimization of Disjunctive Predicates for Main Memory Column Stores	2017	SIGMOD	4.3115918e-05
7,095	Fast Multi-Column Sorting in Main-Memory Column-Stores	2016	SIGMOD	4.8289712e-05
11,155	Pipeline Group Optimization on Disaggregated Systems	2023	CIDR	4.1905499e-05
4,359	Hardware-conscious Query Processing in GPU-accelerated Analytical Engines	2019	CIDR	6.2493951e-05
515	QPipe: A Simultaneously Pipelined Relational Query Engine	2005	SIGMOD	0.00021209491
6,116	Database Processing-in-Memory: An Experimental Study	2020	VLDB	5.1995375e-05
7,427	Selection Pushdown in Column Stores using Bit Manipulation Instructions	2023	SIGMOD	4.7282014e-05