Self-tuning Database Systems: A Systematic Literature Review of Automatic Database Schema Design and Tuning

M Mozaffari, A Dignös, J Gamper, U Störl - ACM Computing Surveys, 2024 - dl.acm.org
Self-tuning is a feature of autonomic databases that includes the problem of automatic
schema design. It aims at providing an optimized schema that increases the overall …

Automatic Database Index Tuning: A Survey

Y Wu, X Zhou, Y Zhang, G Li - IEEE Transactions on …, 2024 - ieeexplore.ieee.org
Index tuning plays a crucial role in facilitating the efficiency of data retrieval within database
systems, which adjusts index settings to optimize the database performance. Recently, with …

SmartIX: A database indexing agent based on reinforcement learning

G Paludo Licks, J Colleoni Couto, P de Fátima Miehe… - Applied …, 2020 - Springer
Configuring databases for efficient querying is a complex task, often carried out by a
database administrator. Solving the problem of building indexes that truly optimize database …

Efficient and Economical Allocation of Irrigation Water under a Changing Environment: a Stochastic Multi‐Objective Nonlinear Programming Model

Z Yan, M Li, Z Li - Irrigation and Drainage, 2021 - Wiley Online Library
Water scarcity causes conflicts between natural resources and socio‐economic
development which reinforces the need for optimal allocation of irrigation water resources …

The next 50 years in database indexing or: the case for automatically generated index structures

J Dittrich, J Nix, C Schön - Proceedings of the VLDB Endowment, 2021 - dl.acm.org
Index structures are a building block of query processing and computer science in general.
Since the dawn of computer technology there have been index structures. And since then, a …

Indexer++ workload-aware online index tuning with transformers and reinforcement learning

V Sharma, C Dyreson - Proceedings of the 37th ACM/SIGAPP …, 2022 - dl.acm.org
With the increasing workload complexity in modern databases, the manual process of index
selection is a challenging task. There is a growing need for a database with an ability to …

Optimal Index Selection Using Optimized Deep Q-Learning Algorithm for NoSQL Database

V Sumalatha, S Pabboju - SN Computer Science, 2024 - Springer
The resource requirements for managing the data for sophisticated applications have
increased as big data technology has advanced. NoSQL (MongoDB) databases are being …

Intelligent Indexing—Boosting Performance in Database Applications by Recognizing Index Patterns

A Arteta Albert, N Gómez Blas, LF Mingo López - Electronics, 2020 - mdpi.com
An issue that most databases face is the static and manual character of indexing operations.
This old-fashioned way of indexing database objects is proven to affect the database …

Automated database indexing using model-free reinforcement learning

GP Licks, F Meneguzzi - arXiv preprint arXiv:2007.14244, 2020 - arxiv.org
Configuring databases for efficient querying is a complex task, often carried out by a
database administrator. Solving the problem of building indexes that truly optimize database …

There is No Such Thing as an" Index"! or: The next 500 Indexing Papers

J Dittrich, J Nix, C Schön - arXiv preprint arXiv:2009.10669, 2020 - arxiv.org
Index structures are a building block of query processing and computer science in general.
Since the dawn of computer technology there have been index structures. And since then, a …