Corpus ID: 224703403

DBA bandits: Self-driving index tuning under ad-hoc, analytical workloads with safety guarantees

@article{Perera2020DBABS,
  title={DBA bandits: Self-driving index tuning under ad-hoc, analytical workloads with safety guarantees},
  author={R. M. Perera and Bastian Oetomo and Benjamin I. P. Rubinstein and Renata Borovica-Gajic},
  journal={ArXiv},
  year={2020},
  volume={abs/2010.09208}
}
  • R. M. Perera, Bastian Oetomo, +1 author Renata Borovica-Gajic
  • Published 2020
  • Computer Science
  • ArXiv
  • Automating physical database design has remained a long-term interest in database research due to substantial performance gains afforded by optimised structures. Despite significant progress, a majority of today's commercial solutions are highly manual, requiring offline invocation by database administrators (DBAs) who are expected to identify and supply representative training workloads. Unfortunately, the latest advancements like query stores provide only limited support for dynamic… CONTINUE READING

    Figures and Tables from this paper

    References

    SHOWING 1-10 OF 47 REFERENCES
    The Case for Automatic Database Administration using Deep Reinforcement Learning
    • 22
    • Highly Influential
    • PDF
    Query-based Workload Forecasting for Self-Driving Database Management Systems
    • 68
    • PDF
    On-Line Index Selection for Shifting Workloads
    • 61
    • PDF
    Self-Driving Database Management Systems
    • 126
    • PDF
    Smooth Scan: robust access path selection without cardinality estimation
    • 11
    • PDF
    Database Cracking
    • 253
    • PDF
    Database Tuning Advisor for Microsoft SQL Server 2005
    • 205
    AI Meets AI: Leveraging Query Executions to Improve Index Recommendations
    • 23
    • Highly Influential
    • PDF