Demonstration venue · read-only. Every page can be browsed; the buttons that would change it are switched off. Create an account to run TaxoReview on your own data. A simulation from public publication records: the people listed were not invited and did not agree to review.
? Tutorial for this page

Hedui Chen

dblp:344/5077 · DBLP profile ↗
← Back
1ranked-venue papers
0as first author
1since 2021 · last 2023
—ORCID · none

Domains — the database's venue-derived domains; a paper can count in several

Databases, data management, data science and information retrieval · 1 · 1 since 2021

Expertise — from the expertise taxonomy: the topics of the expert's papers under the CCF categories. A weight counts papers with recency: 1 for a paper about the topic, 0.3 when the topic is its context, halved every five years.

Databases, data mining, and information retrieval
1 paper
Query processing and optimization · 91% Machine learning and data management · 9%

Topics — the 4 heaviest of 4, each with the papers that count most for it

TopicWeightPapersLastEvidence papers
Query processing and optimization › query optimization
join ordering
0.712023
LOGER: A Learned Optimizer towards Generating Efficient and Robust Query Execution Plans · Proc. VLDB Endow. 2023
Query processing and optimization › query optimization
learned query optimization
0.712023
LOGER: A Learned Optimizer towards Generating Efficient and Robust Query Execution Plans · Proc. VLDB Endow. 2023
Query processing and optimization
query optimization
0.712023
LOGER: A Learned Optimizer towards Generating Efficient and Robust Query Execution Plans · Proc. VLDB Endow. 2023
Machine learning and data management
learned database components
0.212023
LOGER: A Learned Optimizer towards Generating Efficient and Robust Query Execution Plans · Proc. VLDB Endow. 2023

Methods — techniques the papers use, named apart from their topics

graph transformer · 0.7deep reinforcement learning · 0.7beam search · 0.7
YearPublicationVenuePosition
2023 LOGER: A Learned Optimizer towards Generating Efficient and Robust Query Execution Plans
abstract
Query optimization based on deep reinforcement learning (DRL) has become a hot research topic recently. Despite the achieved promising progress, DRL optimizers still face great challenges of robustly producing efficient plans, due to the vast search space for both join order and operator selection and the highly varying execution latency taken as the feedback signal. In this paper, we propose LOGER, a learned optimizer towards generating efficient and robust plans, aiming at producing both efficient join orders and operators. LOGER first utilizes Graph Transformer to capture relationships between tables and predicates. Then, the search space is reorganized, in which LOGER learns to restrict specific operators instead of directly selecting one for each join, while utilizing DBMS built-in optimizer to select physical operators under the restrictions. Such a strategy exploits expert knowledge to improve the robustness of plan generation while offering sufficient plan search flexibility. Furthermore, LOGER introduces ε -beam search, which keeps multiple search paths that preserve promising plans while performing guided exploration. Finally, LOGER introduces a loss function with reward weighting to further enhance performance robustness by reducing the fluctuation caused by poor operators, and log transformation to compress the range of rewards. We conduct experiments on Join Order Benchmark (JOB), TPC-DS and Stack Overflow, and demonstrate that LOGER can achieve a performance better than existing learned query optimizers, with a 2.07x speedup on JOB compared with PostgreSQL.
Jun Gao 0003, Hedui Chen, Yaofeng Tu
Proc. VLDB Endow.3