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: 6811
Venue: SIGMOD
Year: 2023
Pagerank: 6.1167049e-05
Overall Rank: 5,701 | 60.89%
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 12 of 12 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
8,163	Learned Offline Query Planning via Bayesian Optimization	2025	SIGMOD	5.4751517e-05
9,428	LIMAO: A Framework for Lifelong Modular Learned Query Optimization	2025	VLDB	5.2709145e-05
9,947	Optimizing Time Series Queries with Versions	2024	SIGMOD	5.1915905e-05
9,971	Athena: An Effective Learning-based Framework for Query Optimizer Performance Improvement	2025	SIGMOD	5.1845938e-05
10,108	An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL	2025	SIGMOD	5.1347137e-05
10,190	AgenticScholar: Agentic Data Management with Pipeline Orchestration for Scholarly Corpora	2026	SIGMOD	5.093636e-05
10,243	Finding Missed Optimizations in DBMSs through Unbalanced Short-Circuit Query Construction	2026	SIGMOD	5.093636e-05
10,272	NeurBench: A Benchmark Suite for Learned Database Components with Drift Modeling: [Experiments & Analysis]	2026	SIGMOD	5.093636e-05
10,401	SEFRQO: A Self-Evolving Fine-Tuned RAG-Based Query Optimizer	2026	SIGMOD	5.093636e-05
10,586	TATA: An Efficient Framework for Task Transfer in Query Plan Representation	2026	VLDB	5.093636e-05
10,886	AQETuner: Reliable Query-level Configuration Tuning for Analytical Query Engines	2025	VLDB	5.093636e-05
11,103	RankPQO: Learning-to-Rank for Parametric Query Optimization	2025	VLDB	5.093636e-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
18	How Good Are Query Optimizers, Really?	2016	VLDB	0.00059284255
128	Efficient and Extensible Algorithms for Multi Query Optimization	2000	SIGMOD	0.0003072825
154	Neo: A Learned Query Optimizer	2019	VLDB	0.00028726181
193	Continuously Adaptive Continuous Queries over Streams	2002	SIGMOD	0.00025964286
378	Bao: Making Learned Query Optimization Practical	2021	SIGMOD	0.00019638121
383	QPipe: A Simultaneously Pipelined Relational Query Engine	2005	SIGMOD	0.00019520728
670	SharedDB: Killing One Thousand Queries With One Stone	2012	VLDB	0.00015157572
822	Pipelining in Multi-Query Optimization	2001	PODS	0.00013807229
1,022	A Scalable, Predictable Join Operator for Highly Concurrent Data Warehouses	2009	VLDB	0.00012602841
1,024	The DataPath System: A Data-Centric Analytic Processing Engine for Large Data Warehouses	2010	SIGMOD	0.0001258839
1,154	Efficient Exploitation of Similar Subexpressions for Query Processing	2007	SIGMOD	0.00011934202
1,241	Balsa: Learning a Query Optimizer Without Expert Demonstrations	2022	SIGMOD	0.00011521639
2,276	Shared Workload Optimization	2014	VLDB	8.8196376e-05
2,355	QueryFormer: A Tree Transformer Model for Query Plan Representation	2022	VLDB	8.7022189e-05
2,420	Lero: A Learning-to-Rank Query Optimizer	2023	VLDB	8.605257e-05
2,762	Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection	2022	VLDB	8.1539867e-05
2,812	Query Performance Prediction for Concurrent Queries using Graph Embedding	2020	VLDB	8.0979597e-05
3,978	The Case for Precision Sharing	2004	VLDB	6.9771565e-05
4,639	MQJoin: Efficient Shared Execution of Main-Memory Joins	2016	VLDB	6.5918791e-05
7,213	Scalable Multi-Query Execution using Reinforcement Learning	2021	SIGMOD	5.670422e-05

Semantically Similar Papers

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