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 …

An adaptive approach for index tuning with learning classifier systems on hybrid storage environments

WG Pedrozo, JC Nievola, DC Ribeiro - … 2018, Oviedo, Spain, June 20-22 …, 2018 - Springer
Index tuning is an activity typically performed by database administrators (DBAs) and
advisors tools to decrease the response times of commands submitted to a database …

Automatic database index tuning using machine learning

M Valavala, W Alhamdani - 2021 6th International Conference …, 2021 - ieeexplore.ieee.org
Index tuning is considered as a powerful technique used to improve the database
performance by ensuring the swift data access. Automating the index tuning by using …

Airindex: versatile index tuning through data and storage

S Chockchowwat, W Liu, Y Park - … of the ACM on Management of Data, 2023 - dl.acm.org
The end-to-end lookup latency of a hierarchical index---such as a B-tree or a learned index---
is determined by its structure such as the number of layers, the kinds of branching functions …

TIER: Table index evaluator and recommender—A proposed model to improve transaction performance in distributed heterogeneous database

S Naik - 2017 International Conference on Soft Computing and …, 2017 - ieeexplore.ieee.org
Use of appropriate indexing improves the performance of transactions in heterogeneous
distributed database whereas inappropriate or no indexing deteriorates the same. Properly …

[PDF][PDF] Automated Management of Indexes for Dataflow Processing Engines in IaaS Clouds.

H Kllapi, I Pietri, V Kantere, YE Ioannidis - EDBT, 2020 - academia.edu
Data structures like indexes are typically used to accelerate dataflow execution locating and
accessing data more efficiently. The automated management of data structures has been a …

[PDF][PDF] A Survey on Database Index Tuning and Defragmentation

M Valavala, W Alhamdani - International Journal of Engineering …, 2020 - academia.edu
Database performance tuning is an evolutionary field and is considered a difficult task,
especially with large databases. Indexing contributes largely to improve the Database …

[PDF][PDF] Tuning de Índices em Sistemas Gerenciadores de Banco de Dados Relacionais, utilizando Sistemas Classificadores

WG Pedrozo - ppgia.pucpr.br
A velocidade de processamento em CPU teve um aumento exponencial nas últimas
décadas. Contudo, o número de entradas/saídas por segundo, em unidades de disco rígido …

[引用][C] 数据库物理结构优化技术

崔跃生, 张勇, 曾春, 冯建华, 邢春晓 - 软件学报, 2013

Parsing Set of Queries to Obtain Parse Matrix for Table Index Evaluator and Recommender

S Naik - IUP Journal of Information Technology, 2018 - search.proquest.com
The use of appropriate indexing improves the performance of transactions in heterogeneous
distributed database, whereas inappropriate or no indexing deteriorates the same. Properly …