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: hae5036acca59dff5
Venue: VLDB
Year: 2018
Pagerank: 7.8446029e-05
Overall Rank: 2,926 | 80.34%
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,809	Exploiting Coroutines to Attack the "Killer Nanoseconds"	2018	VLDB	7.9788276e-05
3,406	CoroGraph: Bridging Cache Efficiency and Work Efficiency for Graph Algorithm Execution	2024	VLDB	7.3251673e-05
3,711	CoroBase: Coroutine-Oriented Main-Memory Database Engine	2021	VLDB	7.0757906e-05
3,775	Hardware-conscious Query Processing in GPU-accelerated Analytical Engines	2019	CIDR	7.0261504e-05
4,682	Enabling Low Tail Latency on Multicore Key-Value Stores	2020	VLDB	6.4696727e-05
5,034	Put an Elephant into a Fridge: Optimizing Cache Efficiency for In-memory Key-value Stores	2020	VLDB	6.3024123e-05
5,344	MxTasks: How to Make Efficient Synchronization and Prefetching Easy	2021	SIGMOD	6.1716571e-05
5,545	Charting the Design Space of Query Execution using VOILA	2021	VLDB	6.0860849e-05
6,093	ThunderRW: An In-Memory Graph Random Walk Engine	2021	VLDB	5.8870862e-05
8,056	Micro-architectural Analysis of OLAP: Limitations and Opportunities	2020	VLDB	5.3967893e-05
8,385	Interleaved Multi-Vectorizing	2020	VLDB	5.3404356e-05
8,570	Robust and Budget-Constrained Encoding Configurations for In-Memory Database Systems	2022	VLDB	5.3113492e-05
9,691	GastCoCo: Graph Storage and Coroutine-Based Prefetch Co-Design for Dynamic Graph Processing	2024	VLDB	5.1397563e-05
10,235	Analytics Are Heavy. The DBMS Is Busy. When Will My Mission-Critical Transaction Start Running?	2025	VLDB	5.0547568e-05
10,875	Tux: Efficient Drop-in Networking for Database Systems	2026	VLDB	4.9769913e-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
27	Database Architecture Optimized for the New Bottleneck: Memory Access	1999	VLDB	0.00051576613
68	Making B+-Trees Cache Conscious in Main Memory	2000	SIGMOD	0.00037957995
110	DBMSs On A Modern Processor: Where Does Time Go?	1999	VLDB	0.00032696785
163	DB2 with BLU Acceleration: So Much More than Just a Column Store	2013	VLDB	0.00027480091
277	FAST: Fast Architecture Sensitive Tree Search on Modern CPUs and GPUs	2010	SIGMOD	0.00022320139
907	Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation	2016	SIGMOD	0.00013157412
944	Enhancements to SQL Server Column Stores	2013	SIGMOD	0.00012934104
1,105	Buffering Accesses to Memory-Resident Index Structures	2003	VLDB	0.00011991167
1,192	Data Compression in Oracle	2003	VLDB	0.00011585228
1,765	SQL Server Column Store Indexes	2011	SIGMOD	9.6934008e-05
2,674	Asynchronous Memory Access Chaining	2016	VLDB	8.1445101e-05
4,873	Improving Database Performance on Simultaneous Multithreading Processors	2005	VLDB	6.370725e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	5,915	Inspector Joins	2005	VLDB
2	7,157	Adaptive Hybrid Indexes	2022	SIGMOD
3	960	Reducing the Storage Overhead of Main-Memory OLTP Databases with Hybrid Indexes	2016	SIGMOD
4	1,105	Buffering Accesses to Memory-Resident Index Structures	2003	VLDB
5	8,402	The Case for Learned In-Memory Joins	2023	VLDB
6	12,102	Dynamic Interleaving of Content and Structure for Robust Indexing of Semi-Structured Hierarchical Data	2020	VLDB
7	10,894	Storing and Indexing Multiple Tables by Interesting Orderings: For Efficient Joins, Groupings, and Updates in Relational Databases	2026	VLDB
8	3,154	Robust Join Processing with Diamond Hardened Joins	2024	VLDB
9	2,809	Exploiting Coroutines to Attack the "Killer Nanoseconds"	2018	VLDB
10	6,125	Parallel Index-based Stream Join on a Multicore CPU	2020	SIGMOD