Magic mirror in my hand, which is the best in the land? an experimental evaluation of index selection algorithms

J Kossmann, S Halfpap, M Jankrift… - Proceedings of the VLDB …, 2020 - dl.acm.org
Indexes are essential for the efficient processing of database workloads. Proposed solutions
for the relevant and challenging index selection problem range from metadata-based simple …

TRAP: Tailored Robustness Assessment for Index Advisors via Adversarial Perturbation

W Zhou, C Lin, X Zhou, G Li… - 2024 IEEE 40th …, 2024 - ieeexplore.ieee.org
Many index advisors have recently been proposed to build indexes automatically to improve
query performance. However, they mainly consider performance improvement in static …

Looking Deeply into the Magic Mirror: An Interactive Analysis of Database Index Selection Approaches

S Halfpap, J Kossmann, R Schlosser… - Proceedings of the VLDB …, 2024 - dl.acm.org
Indexes are important data structures for database tuning. However, finding the best indexes
for a given workload is challenging. In this demonstration, we present our extensible open …

Breaking It Down: An In-Depth Study of Index Advisors

W Zhou, C Lin, X Zhou, G Li - Proceedings of the VLDB Endowment, 2024 - dl.acm.org
Index advisors aim to improve workload performance by judiciously selecting an appropriate
set of indexes. Various heuristic-based and learning-based methods have been proposed …

Robust index selection for stochastic dynamic workloads

R Schlosser, M Weisgut, L Hübscher… - SN Computer …, 2022 - Springer
Fast query processing is a primary goal of modern database systems. The use of indexes is
crucial to reduce the execution times of database queries. Hence, it is of great interest to …

Enterprise Platform and Integration Concepts Research at HPI

M Perscheid, H Plattner, D Ritter, R Schlosser… - ACM SIGMOD …, 2023 - dl.acm.org
The Hasso Plattner Institute (HPI), academically structured as the independent Faculty of
Digital Engineering at the University of Potsdam, unites computer science research and …

Unsupervised database optimization: efficient index selection & data dependency-driven query optimization

J Koßmann - 2023 - publishup.uni-potsdam.de
The amount of data stored in databases and the complexity of database workloads are ever-
increasing. Database management systems (DBMSs) offer many configuration options, such …

Das Fachgebiet „Enterprise Platform and Integration Concepts “am Hasso-Plattner-Institut

M Perscheid, H Plattner, D Ritter, R Schlosser… - 2022 - Springer
Das 1998 gegründete Hasso-Plattner-Institut (HPI) ist ein privat finanziertes IT-Institut und
bildet gemeinsam mit der Universität Potsdam die Fakultät „Digital Engineering “. Gründer …

Hybrid Index Selection Using Integer Linear Programming Based on Cached Cost Estimates of Heuristic Approaches

S Halfpap - Proceedings of the 1st Workshop on Simplicity in …, 2023 - dl.acm.org
Indexes are essential for speeding up database workloads. Existing index selection
approaches have different strengths and weaknesses. On the one hand, approaches based …

[PDF][PDF] Solver-based Approaches for Robust Multi-index Selection Problems with Stochastic Workloads and Reconfiguration Costs.

M Weisgut, L Hübscher, O Nordemann, R Schlosser - ICORES, 2022 - scitepress.org
Fast processing of database queries is a primary goal of database systems. Indexes are a
crucial means for the physical design to reduce the execution times of database queries …