Lemo: A Cache-Enhanced Learned Optimizer for Concurrent Queries

Summary: Lemo is a cache-enhanced learned optimizer for concurrent multi-query workloads. A shared buffer caches subquery results with a replacement policy, leveraging cached data to guide plan generation in PostgreSQL. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h893c634ef239e106
Venue: SIGMOD
Year: 2023
Pagerank: 5.9947442e-05
Overall Rank: 5,788 | 61.09%
DOI: 10.1145/3626734

Incoming Non-self Citations Over Time

Authors

1. Songsong Mo (Nanyang Technological University)
2. Yile Chen (Nanyang Technological University)
3. Hao Wang (Nanyang Technological University)
4. Gao Cong (Nanyang Technological University)
5. Zhifeng Bao (Royal Melbourne Institute of Technology)

BibTeX Citation

@inproceedings{mo_sigmod23,
        title = {{Lemo: A Cache-Enhanced Learned Optimizer for Concurrent Queries}},
        author = {Mo, Songsong and Chen, Yile and Wang, Hao and Cong, Gao and Bao, Zhifeng},
        series = {{SIGMOD} '23},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3626734},
        url = {https://dl.acm.org/doi/10.1145/3626734},
        year = {2023}
}

Incoming Citations (Sorted by Pagerank)

Showing 13 of 13 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
8,332	Learned Offline Query Planning via Bayesian Optimization	2025	SIGMOD	5.3528188e-05
9,219	Finding Missed Optimizations in DBMSs through Unbalanced Short-Circuit Query Construction	2026	SIGMOD	5.2056825e-05
9,546	Athena: An Effective Learning-based Framework for Query Optimizer Performance Improvement	2025	SIGMOD	5.1604755e-05
9,610	LIMAO: A Framework for Lifelong Modular Learned Query Optimization	2025	VLDB	5.1526493e-05
10,131	Optimizing Time Series Queries with Versions	2024	SIGMOD	5.0751052e-05
10,336	An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL	2025	SIGMOD	5.0200193e-05
10,406	AgenticScholar: Agentic Data Management with Pipeline Orchestration for Scholarly Corpora	2026	SIGMOD	4.9793485e-05
10,484	NeurBench: A Benchmark Suite for Learned Database Components with Drift Modeling: [Experiments & Analysis]	2026	SIGMOD	4.9793485e-05
10,596	SEFRQO: A Self-Evolving Fine-Tuned RAG-Based Query Optimizer	2026	SIGMOD	4.9793485e-05
10,924	TATA: An Efficient Framework for Task Transfer in Query Plan Representation	2026	VLDB	4.9793485e-05
10,938	Towards Industrial-Scale Parametric Query Optimization	2026	VLDB	4.9793485e-05
11,287	AQETuner: Reliable Query-level Configuration Tuning for Analytical Query Engines	2025	VLDB	4.9793485e-05
11,453	RankPQO: Learning-to-Rank for Parametric Query Optimization	2025	VLDB	4.9793485e-05

Outgoing Citations (Sorted by Pagerank)

Showing 20 of 20 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
129	Efficient and Extensible Algorithms for Multi Query Optimization	2000	SIGMOD	0.0003040756
145	Neo: A Learned Query Optimizer	2019	VLDB	0.0002908188
200	Continuously Adaptive Continuous Queries over Streams	2002	SIGMOD	0.000254553
362	Bao: Making Learned Query Optimization Practical	2021	SIGMOD	0.00019989474
389	QPipe: A Simultaneously Pipelined Relational Query Engine	2005	SIGMOD	0.00019269777
667	SharedDB: Killing One Thousand Queries With One Stone	2012	VLDB	0.00014978213
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,131	Efficient Exploitation of Similar Subexpressions for Query Processing	2007	SIGMOD	0.0001189909
1,199	Balsa: Learning a Query Optimizer Without Expert Demonstrations	2022	SIGMOD	0.00011563985
2,210	Lero: A Learning-to-Rank Query Optimizer	2023	VLDB	8.8257742e-05
2,225	Shared Workload Optimization	2014	VLDB	8.8081001e-05
2,250	QueryFormer: A Tree Transformer Model for Query Plan Representation	2022	VLDB	8.7533306e-05
2,690	Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection	2022	VLDB	8.1258173e-05
2,842	Query Performance Prediction for Concurrent Queries using Graph Embedding	2020	VLDB	7.949193e-05
4,056	The Case for Precision Sharing	2004	VLDB	6.8261065e-05
4,730	MQJoin: Efficient Shared Execution of Main-Memory Joins	2016	VLDB	6.4468007e-05
7,341	Scalable Multi-Query Execution using Reinforcement Learning	2021	SIGMOD	5.5481233e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	11,447	LASER: Buffer-Aware Learned Query Scheduling in Master-Standby Databases	2025	VLDB
2	5,041	LSched: A Workload-Aware Learned Query Scheduler for Analytical Database Systems	2022	SIGMOD
3	4,980	An Incremental Anytime Algorithm for Multi-Objective Query Optimization	2015	SIGMOD
4	11,857	DeepO: A Learned Query Optimizer	2022	SIGMOD
5	9,670	Low Rank Learning for Offline Query Optimization	2025	SIGMOD
6	2,842	Query Performance Prediction for Concurrent Queries using Graph Embedding	2020	VLDB
7	6,660	Speeding Up End-to-end Query Execution via Learning-based Progressive Cardinality Estimation	2023	SIGMOD
8	5,039	Leveraging Query Logs and Machine Learning for Parametric Query Optimization	2022	VLDB
9	2,210	Lero: A Learning-to-Rank Query Optimizer	2023	VLDB
10	9,610	LIMAO: A Framework for Lifelong Modular Learned Query Optimization	2025	VLDB