Scalable Multi-Query Execution using Reinforcement Learning

Summary: RouLette uses reinforcement learning to drive adaptive, runtime sharing for multi-query execution, avoiding costly pre-optimization. It delivers 1.6–28.3× throughput gains vs a query-at-a-time engine and up to 6.5× vs sharing prototypes on TPC-DS-like workloads. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: hb79a83ff31ab2cae
Venue: SIGMOD
Year: 2021
Pagerank: 5.5481233e-05
Overall Rank: 7,341 | 50.65%
DOI: 10.1145/3448016.3452799

Incoming Non-self Citations Over Time

Authors

1. Panagiotis Sioulas (EPFL)
2. Anastasia Ailamaki (EPFL; RAW Labs)

BibTeX Citation

@inproceedings{sioulas_sigmod21,
        title = {{Scalable Multi-Query Execution using Reinforcement Learning}},
        author = {Sioulas, Panagiotis and Ailamaki, Anastasia},
        series = {{SIGMOD} '21},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3448016.3452799},
        url = {https://dl.acm.org/doi/10.1145/3448016.3452799},
        year = {2021}
}

Incoming Citations (Sorted by Pagerank)

Showing 7 of 7 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
5,005	Using Cloud Functions as Accelerator for Elastic Data Analytics	2023	SIGMOD	6.3177105e-05
5,041	LSched: A Workload-Aware Learned Query Scheduler for Analytical Database Systems	2022	SIGMOD	6.3006152e-05
5,788	Lemo: A Cache-Enhanced Learned Optimizer for Concurrent Queries	2023	SIGMOD	5.9947442e-05
6,791	dbET: Execution Time Distribution-based Plan Selection	2023	SIGMOD	5.6811782e-05
11,461	Oligolithic Cross-task Optimizations across Isolated Workloads*	2024	CIDR	4.9793485e-05
11,714	QaaD (Query-as-a-Data): Scalable Execution of Massive Number of Small Queries in Spark	2023	SIGMOD	4.9793485e-05
11,727	SH2O: Efficient Data Access for Work-Sharing Databases	2023	SIGMOD	4.9793485e-05

Outgoing Citations (Sorted by Pagerank)

Showing 27 of 27 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
15	How Good Are Query Optimizers, Really?	2016	VLDB	0.00061066921
48	Weaving Relations for Cache Performance	2001	VLDB	0.00043805923
53	Eddies: Continuously Adaptive Query Processing	2000	SIGMOD	0.00040860054
85	Learned Cardinalities: Estimating Correlated Joins with Deep Learning	2019	CIDR	0.00035864347
129	Efficient and Extensible Algorithms for Multi Query Optimization	2000	SIGMOD	0.0003040756
135	Ripple Joins for Online Aggregation	1999	SIGMOD	0.00029866033
145	Neo: A Learned Query Optimizer	2019	VLDB	0.0002908188
200	Continuously Adaptive Continuous Queries over Streams	2002	SIGMOD	0.000254553
389	QPipe: A Simultaneously Pipelined Relational Query Engine	2005	SIGMOD	0.00019269777
406	Deep Unsupervised Cardinality Estimation	2020	VLDB	0.00019045544
479	The Making of TPC-DS	2006	VLDB	0.00017622471
667	SharedDB: Killing One Thousand Queries With One Stone	2012	VLDB	0.00014978213
692	Selectivity Estimation for Range Predicates using Lightweight Models	2019	VLDB	0.00014741011
762	Cooperative Scans: Dynamic Bandwidth Sharing in a DBMS	2007	VLDB	0.00014140446
827	Adaptive Ordering of Pipelined Stream Filters	2004	SIGMOD	0.00013632674
831	Pipelining in Multi-Query Optimization	2001	PODS	0.00013589597
1,034	A Scalable, Predictable Join Operator for Highly Concurrent Data Warehouses	2009	VLDB	0.00012394538
1,040	The DataPath System: A Data-Centric Analytic Processing Engine for Large Data Warehouses	2010	SIGMOD	0.00012364063
1,108	Maximizing the Output Rate of Multi-Way Join Queries over Streaming Information Sources	2003	VLDB	0.00011991195
1,131	Efficient Exploitation of Similar Subexpressions for Query Processing	2007	SIGMOD	0.0001189909
1,423	Procella: Unifying serving and analytical data at YouTube	2019	VLDB	0.00010719956
1,745	Selecting Subexpressions to Materialize at Datacenter Scale	2018	VLDB	9.7343818e-05
2,225	Shared Workload Optimization	2014	VLDB	8.8081001e-05
2,719	TPC-DS, Taking Decision Support Benchmarking to the Next Level	2002	SIGMOD	8.0967665e-05
4,056	The Case for Precision Sharing	2004	VLDB	6.8261065e-05
4,366	Lifting the Burden of History from Adaptive Query Processing	2004	VLDB	6.6333069e-05
4,730	MQJoin: Efficient Shared Execution of Main-Memory Joins	2016	VLDB	6.4468007e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	6,660	Speeding Up End-to-end Query Execution via Learning-based Progressive Cardinality Estimation	2023	SIGMOD
2	11,283	Robust Plan Evaluation based on Approximate Probabilistic Machine Learning	2025	VLDB
3	4,482	LearnedSQLGen: Constraint-aware SQL Generation using Reinforcement Learning	2022	SIGMOD
4	5,039	Leveraging Query Logs and Machine Learning for Parametric Query Optimization	2022	VLDB
5	11,239	Holistic query Approximation via RL Modeling	2025	VLDB
6	5,158	Facilitating SQL Query Composition and Analysis	2020	SIGMOD
7	5,087	Releasing Cloud Databases from the Chains of Performance Prediction Models	2017	CIDR
8	5,110	Steering Query Optimizers: A Practical Take on Big Data Workloads	2021	SIGMOD
9	5,194	Database Workload Characterization with Query Plan Encoders	2022	VLDB
10	5,041	LSched: A Workload-Aware Learned Query Scheduler for Analytical Database Systems	2022	SIGMOD