Learning State Representations for Query Optimization with Deep Reinforcement Learning
Not on the map. Why?
Abstract (arXiv)
Deep reinforcement learning is quickly changing the field of artificial intelligence. These models are able to capture a high level understanding of their environment, enabling them to learn difficult dynamic tasks in a variety of domains. In the database field, query optimization remains a difficult problem. Our goal in this work is to explore the capabilities of deep reinforcement learning in the context of query optimization. At each state, we build queries incrementally and encode properties of subqueries through a learned representation. The challenge here lies in the formation of the state transition function, which defines how the current subquery state combines with the next query operation (action) to yield the next state. As a first step in this direction, we focus the state representation problem and the formation of the state transition function. We describe our approach and show preliminary results. We further discuss how we can use the state representation to improve query optimization using reinforcement learning.
Key facts. Cited by 14 papers in the map (data through 7 Oct 2026). First posted on arXiv 22 Mar 2018.
Builds on
No reference list yet.
Built on by
Citing papers per year: 2021: 6; 2022: 1; 2023: 3; 2024: 1; 2025: 2; 2026: 1.
14 papers.
Sort:
- 2021DB-BERT: a Database Tuning Tool that "Reads the Manual"cited by 19
- 2021A Unified Transferable Model for ML-Enhanced DBMScited by 10
- 2021CARMI: A Cache-Aware Learned Index with a Cost-based Construction Algorithmcited by 8
- 2021Efficient Deep Learning Pipelines for Accurate Cost Estimations Over Large Scale Query Workloadcited by 4
- 2023InTune: Reinforcement Learning-based Data Pipeline Optimization for Deep Recommendation Modelscited by 3
- 2024TERC: A Transfer Entropy Redundancy Criterion for State Variable Selection in Reinforcement Learningcited by 3
- 2021A Pluggable Learned Index Method via Sampling and Gap Insertioncited by 1
- 2021Phoebe: A Learning-based Checkpoint Optimizercited by 1
- 2023JoinGym: An Efficient Query Optimization Environment for Reinforcement Learningcited by 1
- 2022Multi-agent Databases via Independent Learningcited by 0
- 2023BitE : Accelerating Learned Query Optimization in a Mixed-Workload Environmentcited by 0
- 2025Low Rank Learning for Offline Query Optimizationcited by 0
- 2026RELOAD: A Robust and Efficient Learned Query Optimizer for Database Systems16 Apr 2026
- 2025OntoTune: Ontology-Driven Learning for Query Optimization with Convolutional Models10 Nov 2025
- 2025Low Rank Learning for Offline Query Optimization8 Apr 2025
- 2024TERC: A Transfer Entropy Redundancy Criterion for State Variable Selection in Reinforcement Learning21 Jan 2024
- 2023InTune: Reinforcement Learning-based Data Pipeline Optimization for Deep Recommendation Models13 Aug 2023
- 2023JoinGym: An Efficient Query Optimization Environment for Reinforcement Learning21 Jul 2023
- 2023BitE : Accelerating Learned Query Optimization in a Mixed-Workload Environment1 Jun 2023
- 2022Multi-agent Databases via Independent Learning28 May 2022
- 2021DB-BERT: a Database Tuning Tool that "Reads the Manual"21 Dec 2021
- 2021Phoebe: A Learning-based Checkpoint Optimizer5 Oct 2021
- 2021A Unified Transferable Model for ML-Enhanced DBMS6 May 2021
- 2021Efficient Deep Learning Pipelines for Accurate Cost Estimations Over Large Scale Query Workload23 Mar 2021
- 2021DB-BERT: a Database Tuning Tool that "Reads the Manual"cited by 19
- 2021A Unified Transferable Model for ML-Enhanced DBMScited by 10
- 2021CARMI: A Cache-Aware Learned Index with a Cost-based Construction Algorithmcited by 8
- 2021Efficient Deep Learning Pipelines for Accurate Cost Estimations Over Large Scale Query Workloadcited by 4
- 2023InTune: Reinforcement Learning-based Data Pipeline Optimization for Deep Recommendation Modelscited by 3
- 2024TERC: A Transfer Entropy Redundancy Criterion for State Variable Selection in Reinforcement Learningcited by 3
- 2021A Pluggable Learned Index Method via Sampling and Gap Insertioncited by 1
- 2021Phoebe: A Learning-based Checkpoint Optimizercited by 1
- 2023JoinGym: An Efficient Query Optimization Environment for Reinforcement Learningcited by 1
- 2022Multi-agent Databases via Independent Learningcited by 0
- 2023BitE : Accelerating Learned Query Optimization in a Mixed-Workload Environmentcited by 0
- 2025Low Rank Learning for Offline Query Optimizationcited by 0
12 most cited of 14 All 14 (JSON)
- 2026RELOAD: A Robust and Efficient Learned Query Optimizer for Database Systems16 Apr 2026
- 2025OntoTune: Ontology-Driven Learning for Query Optimization with Convolutional Models10 Nov 2025
- 2025Low Rank Learning for Offline Query Optimization8 Apr 2025
- 2024TERC: A Transfer Entropy Redundancy Criterion for State Variable Selection in Reinforcement Learning21 Jan 2024
- 2023InTune: Reinforcement Learning-based Data Pipeline Optimization for Deep Recommendation Models13 Aug 2023
- 2023JoinGym: An Efficient Query Optimization Environment for Reinforcement Learning21 Jul 2023
- 2023BitE : Accelerating Learned Query Optimization in a Mixed-Workload Environment1 Jun 2023
- 2022Multi-agent Databases via Independent Learning28 May 2022
- 2021DB-BERT: a Database Tuning Tool that "Reads the Manual"21 Dec 2021
- 2021Phoebe: A Learning-based Checkpoint Optimizer5 Oct 2021
- 2021A Unified Transferable Model for ML-Enhanced DBMS6 May 2021
- 2021Efficient Deep Learning Pipelines for Accurate Cost Estimations Over Large Scale Query Workload23 Mar 2021
12 newest of 14 All 14 (JSON)