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.9759435e-05
Overall Rank: 5,794 | 61.17%
DOI: 10.1145/3626734
PDF: Download (CC BY 4.0)

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
7,561	Learned Offline Query Planning via Bayesian Optimization	2025	SIGMOD	5.4784915e-05
8,657	LIMAO: A Framework for Lifelong Modular Learned Query Optimization	2025	VLDB	5.2790784e-05
9,253	Finding Missed Optimizations in DBMSs through Unbalanced Short-Circuit Query Construction	2026	SIGMOD	5.1860131e-05
9,583	Athena: An Effective Learning-based Framework for Query Optimizer Performance Improvement	2025	SIGMOD	5.140977e-05
10,172	Optimizing Time Series Queries with Versions	2024	SIGMOD	5.0559291e-05
10,370	An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL	2025	SIGMOD	5.0010514e-05
10,484	AgenticScholar: Agentic Data Management with Pipeline Orchestration for Scholarly Corpora	2026	SIGMOD	4.9605343e-05
10,561	NeurBench: A Benchmark Suite for Learned Database Components with Drift Modeling: [Experiments & Analysis]	2026	SIGMOD	4.9605343e-05
10,668	SEFRQO: A Self-Evolving Fine-Tuned RAG-Based Query Optimizer	2026	SIGMOD	4.9605343e-05
10,994	TATA: An Efficient Framework for Task Transfer in Query Plan Representation	2026	VLDB	4.9605343e-05
11,008	Towards Industrial-Scale Parametric Query Optimization	2026	VLDB	4.9605343e-05
11,350	AQETuner: Reliable Query-level Configuration Tuning for Analytical Query Engines	2025	VLDB	4.9605343e-05
11,511	RankPQO: Learning-to-Rank for Parametric Query Optimization	2025	VLDB	4.9605343e-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.00061463175
129	Efficient and Extensible Algorithms for Multi Query Optimization	2000	SIGMOD	0.00030314403
142	Neo: A Learned Query Optimizer	2019	VLDB	0.00029114937
201	Continuously Adaptive Continuous Queries over Streams	2002	SIGMOD	0.00025363666
355	Bao: Making Learned Query Optimization Practical	2021	SIGMOD	0.00020146245
390	QPipe: A Simultaneously Pipelined Relational Query Engine	2005	SIGMOD	0.00019232929
670	SharedDB: Killing One Thousand Queries With One Stone	2012	VLDB	0.00014929358
833	Pipelining in Multi-Query Optimization	2001	PODS	0.00013541546
1,029	A Scalable, Predictable Join Operator for Highly Concurrent Data Warehouses	2009	VLDB	0.00012380835
1,043	The DataPath System: A Data-Centric Analytic Processing Engine for Large Data Warehouses	2010	SIGMOD	0.00012325755
1,137	Efficient Exploitation of Similar Subexpressions for Query Processing	2007	SIGMOD	0.00011856159
1,175	Balsa: Learning a Query Optimizer Without Expert Demonstrations	2022	SIGMOD	0.00011630532
2,169	QueryFormer: A Tree Transformer Model for Query Plan Representation	2022	VLDB	8.9151935e-05
2,190	Lero: A Learning-to-Rank Query Optimizer	2023	VLDB	8.8848923e-05
2,237	Shared Workload Optimization	2014	VLDB	8.7777395e-05
2,696	Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection	2022	VLDB	8.1068354e-05
2,768	Query Performance Prediction for Concurrent Queries using Graph Embedding	2020	VLDB	8.0199086e-05
4,082	The Case for Precision Sharing	2004	VLDB	6.8010384e-05
4,751	MQJoin: Efficient Shared Execution of Main-Memory Joins	2016	VLDB	6.42279e-05
7,347	Scalable Multi-Query Execution using Reinforcement Learning	2021	SIGMOD	5.5308106e-05

Semantically Similar Papers

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