Learning Index Selection with Structured Action Spaces

09/16/2019
by   Jeremy Welborn, et al.
0

Configuration spaces for computer systems can be challenging for traditional and automatic tuning strategies. Injecting task-specific knowledge into the tuner for a task may allow for more efficient exploration of candidate configurations. We apply this idea to the task of index set selection to accelerate database workloads. Index set selection has been amenable to recent applications of vanilla deep RL, but real deployments remain out of reach. In this paper, we explore how learning index selection can be enhanced with task-specific inductive biases, specifically by encoding these inductive biases in better action structures. Index selection-specific action representations arise when the problem is reformulated in terms of permutation learning and we rely on recent work for learning RL policies on permutations. Through this approach, we build an indexing agent that is able to achieve improved indexing and validate its behavior with task-specific statistics. Early experiments reveal that our agent can find configurations that are up to 40 the same levels of latency as compared with other approaches and indicate more intuitive indexing behavior.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
05/11/2022

LSI: A Learned Secondary Index Structure

Learned index structures have been shown to achieve favorable lookup per...
research
12/15/2019

Progressive Neural Index Search for Database System

In database systems, index is the key component to support efficient sea...
research
06/16/2020

Index Selection for NoSQL Database with Deep Reinforcement Learning

We propose a new approach of NoSQL database index selection. For differe...
research
01/21/2019

Predictive Indexing

There has been considerable research on automated index tuning in databa...
research
07/25/2020

Automated Database Indexing using Model-free Reinforcement Learning

Configuring databases for efficient querying is a complex task, often ca...
research
09/05/2023

Dialog Action-Aware Transformer for Dialog Policy Learning

Recent works usually address Dialog policy learning DPL by training a re...
research
01/29/2020

Human Action Performance using Deep Neuro-Fuzzy Recurrent Attention Model

A great number of computer vision publications have focused on distingui...

Please sign up or login with your details

Forgot password? Click here to reset