19/10/2020

An index advisor using deep reinforcement learning

Hai Lan, Zhifeng Bao, Yuwei Peng

Keywords: database configuration, database system, index recommendation, deep reinforcement learning

Abstract Paper Similar Papers

Abstract: We study the problem of index selection to maximize the workload performance, which is critical to database systems. In contrast to existing methods, we seamlessly integrate index recommendation rules and deep reinforcement learning, such that we can recommend single-attribute and multi-attribute indexes together for complex queries and meanwhile support multiple-index access to a table. Specifically, we first propose five heuristic rules to generate the index candidates. Then, we formulate the index selection problem as a reinforcement learning task and employ Deep Q Network (DQN) on it. Using the heuristic rules can significantly reduce the dimensions of the action space and state space in reinforcement learning. With the neural network used in DQN, we can model the interactions between indexes better than previous methods. We conduct experiments on various workloads to show its superiority.

The video of this talk cannot be embedded. You can watch it here:
https://dl.acm.org/doi/10.1145/3340531.3412106#sec-supp
(Link will open in new window)
 0
 0
 0
 0
  Share    
This is an embedded video. Talk and the respective paper are published at CIKM 2020 virtual conference. If you are one of the authors of the paper and want to manage your upload, see the question "My papertalk has been externally embedded..." in the FAQ section.

Comments

Post Comment
no comments yet
code of conduct: tbd Characters remaining: 140

Similar Papers

 0
 0
 0
 0
 21:30 
 0
 0
 0
 0
 12:53 
 0
 0
 0
 0
 5:07 
 0
 0
 0
 0
 8:44 
 0
 0
 0
 0
 19:12 
 0
 0
 0
 0
 3:23 
 0
 0
 0
 0
 11:42 
 0
 0
 0
 0
 8:42 
 0
 0
 0
 0
 14:00 
 0
 0
 0
 0
 13:42 
 0
 0
 0
 0
 3:22 
 0
 0
 0
 0
 3:21 
 0
 0
 0
 0
 3:19 
 0
 0
 0
 0
 2:52 
 0
 0
 0
 0
 12:12 
 0
 0
 0
 0
 5:00 
 0
 0
 0
 0
 3:24 
 0
 0
 0
 0
 5:07 
 0
 0
 0
 0
 4:32 
 0
 0
 0
 0
 4:55 
 0
 0
 0
 0
 14:40 
 0
 0
 0
 0
 5:18 
 0
 0
 0
 0
 3:19 
 0
 0
 0
 0
 3:06 
 0
 0
 0
 0
 21:04 
 0
 0
 0
 0
 4:24 
 0
 0
 0
 0
 17:51 
 0
 0
 0
 0
 19:08 
 0
 0
 0
 0
 5:11 
 0
 0
 0
 0
 14:27 
 0
 0
 0
 0
 14:50 
 0
 0
 0
 0
 15:21 
 0
 0
 0
 0
 5:16 
 0
 0
 0
 0
 11:33 
 0
 0
 0
 0
 5:04 
 0
 0
 0
 0
 5:36 
 0
 0
 0
 0
 5:01 
 0
 0
 0
 0
 4:57 
 0
 0
 0
 0
 13:41 
 0
 0
 0
 0
 14:47