Interleaving with Coroutines: A Practical Approach for Robust Index Joins

Summary: Introduces coroutine-based instruction-stream interleaving for robust index joins, hiding cache-miss latency across concurrent lookups. Demonstrated on SAP HANA binary search and CSB+-tree joins, it matches prior techniques while preserving conventional code and enabling both execution modes. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: 11926
Venue: VLDB
Year: 2018
Pagerank: 7.9880033e-05
Overall Rank: 2,890 | 80.18%
DOI: 10.14778/3149193.3149202

Incoming Non-self Citations Over Time

Authors

1. Georgios Psaropoulos (EPFL)
2. Thomas Legler (SAP)
3. Norman May (SAP)
4. Anastasia Ailamaki (EPFL; RAW Labs)

BibTeX Citation

@article{psaropoulos_vldb18,
        title = {{Interleaving with Coroutines: A Practical Approach for Robust Index Joins}},
        author = {Psaropoulos, Georgios and Legler, Thomas and May, Norman and Ailamaki, Anastasia},
        journal = {PVLDB},
        series = {{VLDB} '18},
        volume = {11},
        number = {2},
        pages = {230--242},
        doi = {10.14778/3149193.3149202},
        url = {https://doi.org/10.14778/3149193.3149202},
        year = {2018}
}

Incoming Citations (Sorted by Pagerank)

Showing 15 of 15 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
2,767	Exploiting Coroutines to Attack the "Killer Nanoseconds"	2018	VLDB	8.1507611e-05
3,642	CoroGraph: Bridging Cache Efficiency and Work Efficiency for Graph Algorithm Execution	2024	VLDB	7.2312616e-05
3,644	CoroBase: Coroutine-Oriented Main-Memory Database Engine	2021	VLDB	7.2306862e-05
3,791	Hardware-conscious Query Processing in GPU-accelerated Analytical Engines	2019	CIDR	7.1235328e-05
4,888	Enabling Low Tail Latency on Multicore Key-Value Stores	2020	VLDB	6.4609843e-05
5,234	MxTasks: How to Make Efficient Synchronization and Prefetching Easy	2021	SIGMOD	6.3051801e-05
5,542	Put an Elephant into a Fridge: Optimizing Cache Efficiency for In-memory Key-value Stores	2020	VLDB	6.180117e-05
5,765	Charting the Design Space of Query Execution using VOILA	2021	VLDB	6.0953705e-05
6,003	ThunderRW: An In-Memory Graph Random Walk Engine	2021	VLDB	6.0130964e-05
7,991	Micro-architectural Analysis of OLAP: Limitations and Opportunities	2020	VLDB	5.5107319e-05
8,238	Interleaved Multi-Vectorizing	2020	VLDB	5.4599422e-05
8,410	Robust and Budget-Constrained Encoding Configurations for In-Memory Database Systems	2022	VLDB	5.4309397e-05
9,499	GastCoCo: Graph Storage and Coroutine-Based Prefetch Co-Design for Dynamic Graph Processing	2024	VLDB	5.2602156e-05
10,581	Tux: Efficient Drop-in Networking for Database Systems	2026	VLDB	5.093636e-05
11,029	Analytics Are Heavy. The DBMS Is Busy. When Will My Mission-Critical Transaction Start Running?	2025	VLDB	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 12 of 12 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
29	Database Architecture Optimized for the New Bottleneck: Memory Access	1999	VLDB	0.00052093615
67	Making B+-Trees Cache Conscious in Main Memory	2000	SIGMOD	0.00038461275
109	DBMSs On A Modern Processor: Where Does Time Go?	1999	VLDB	0.000331207
165	DB2 with BLU Acceleration: So Much More than Just a Column Store	2013	VLDB	0.00027693424
278	FAST: Fast Architecture Sensitive Tree Search on Modern CPUs and GPUs	2010	SIGMOD	0.00022476841
940	Enhancements to SQL Server Column Stores	2013	SIGMOD	0.00013081205
941	Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation	2016	SIGMOD	0.00013078348
1,110	Buffering Accesses to Memory-Resident Index Structures	2003	VLDB	0.00012140661
1,222	Data Compression in Oracle	2003	VLDB	0.00011602327
1,747	SQL Server Column Store Indexes	2011	SIGMOD	9.8494706e-05
2,649	Asynchronous Memory Access Chaining	2016	VLDB	8.2926258e-05
4,772	Improving Database Performance on Simultaneous Multithreading Processors	2005	VLDB	6.5154736e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,740	Adopting Worst-Case Optimal Joins in Relational Database Systems	2020	VLDB
2	5,829	Inspector Joins	2005	VLDB
3	7,012	Adaptive Hybrid Indexes	2022	SIGMOD
4	964	Reducing the Storage Overhead of Main-Memory OLTP Databases with Hybrid Indexes	2016	SIGMOD
5	1,110	Buffering Accesses to Memory-Resident Index Structures	2003	VLDB
6	8,234	The Case for Learned In-Memory Joins	2023	VLDB
7	11,794	Dynamic Interleaving of Content and Structure for Robust Indexing of Semi-Structured Hierarchical Data	2020	VLDB
8	3,622	Robust Join Processing with Diamond Hardened Joins	2024	VLDB
9	2,767	Exploiting Coroutines to Attack the "Killer Nanoseconds"	2018	VLDB
10	6,012	Parallel Index-based Stream Join on a Multicore CPU	2020	SIGMOD