Ai meets ai: Leveraging query executions to improve index recommendations

B Ding, S Das, R Marcus, W Wu, S Chaudhuri… - Proceedings of the …, 2019 - dl.acm.org
query optimizer’s estimates. We study the problem of leveraging query execution statistics
to improve index recommendation quality with minimal changes to state-of-the-art index tuners…

Online Index Recommendation for Slow Queries

G Peng, P Cai, K Ye, K Li, J Cai, Y Shen… - 2024 IEEE 40th …, 2024 - ieeexplore.ieee.org
… As a result, index recommendation methods relying on cost … can still leverage the learned
position information of indexedindex can improve the query execution. If a candidate …

A Data-Driven Index Recommendation System for Slow Queries

G Peng, P Cai, K Ye, K Li, J Cai, Y Shen… - Proceedings of the 32nd …, 2023 - dl.acm.org
… One of the key tasks in DAS is to find missing indexes to improve the slow query execution.
In Meituan, a vast array of business lines deploy tens of thousands of MySQL database …

ML-Powered Index Tuning: An Overview of Recent Progress and Open Challenges

T Siddiqui, W Wu - ACM SIGMOD Record, 2024 - dl.acm.org
… by recommending indexes that accelerate query execution. … rate of queries for just-in-time
recommendation of indexes, … Our idea is to leverage statistics such as table size, selectivity…

An adaptive query execution system for data integration

ZG Ives, D Florescu, M Friedman, A Levy… - ACM SIGMOD …, 1999 - dl.acm.org
… bibliographic references, movie reviews and product in… since they require an initial sorting
or indexing step in this context. Even … Wherever possible, w,e leverage pre-existing standards, …

Learned index benefits: Machine learning based index performance estimation

J Shi, G Cong, XL Li - Proceedings of the VLDB Endowment, 2022 - dl.acm.org
… to estimate execution cost for each query under an index … to leverage attention mechanism
to learn the index interactions … index tuner with LIB can enhance the index recommendation. • …

Rboira: Integrating rules and reinforcement learning to improve index recommendation

W Yu, J You, X Niu, J He, Y Zhang - EAI Endorsed Transactions …, 2023 - publications.eai.eu
… configuration by leveraging expert experience. OBJECTIVES… improves execution efficiency
and reduces the execution cost. (2… indexes on corresponding columns can improve the query

Wred: Workload Reduction for Scalable Index Tuning

M Brucato, T Siddiqui, W Wu, V Narasayya… - Proceedings of the …, 2024 - dl.acm.org
leverage the optimizer’s what-if API to optimize a query for a … queries for execution, but only
for improving the index tuning … the indexes recommended by Dexter as hypothetical indexes

Leveraging recommendations using a multiplex graph database

F Yuehgoh, S Djebali, N Travers - International Journal of Web …, 2024 - emerald.com
… in improving recommendation accuracy and diversity by … be combined to create
recommendation queries for our framework. … Designed for efficiency, these databases use …

Leon: A new framework for ml-aided query optimization

X Chen, H Chen, Z Liang, S Liu, J Wang… - Proceedings of the …, 2023 - dl.acm.org
… framework for leveraging ML to aid the query optimizerÐLEON. … will guide the query optimizer
to find the best execution plan. … recommendations. In Proceedings of the 2019 International …