Index Selection for NoSQL Database with Deep Reinforcement Learning

by   Shun Yao, et al.

We propose a new approach of NoSQL database index selection. For different workloads, we select different indexes and their different parameters to optimize the database performance. The approach builds a deep reinforcement learning model to select an optimal index for a given fixed workload and adapts to a changing workload. Experimental results show that, Deep Reinforcement Learning Index Selection Approach (DRLISA) has improved performance to varying degrees according to traditional single index structures.


page 1

page 2

page 3

page 4


Progressive Neural Index Search for Database System

In database systems, index is the key component to support efficient sea...

The Case for Automatic Database Administration using Deep Reinforcement Learning

Like any large software system, a full-fledged DBMS offers an overwhelmi...

Automatic Storage Structure Selection for hybrid Workload

In the use of database systems, the design of the storage engine and dat...

Automated Database Indexing using Model-free Reinforcement Learning

Configuring databases for efficient querying is a complex task, often ca...

UDO: Universal Database Optimization using Reinforcement Learning

UDO is a versatile tool for offline tuning of database systems for speci...

Learning a Partitioning Advisor with Deep Reinforcement Learning

Commercial data analytics products such as Microsoft Azure SQL Data Ware...

Opportunistic View Materialization with Deep Reinforcement Learning

Carefully selected materialized views can greatly improve the performanc...