arXivDaily arXiv每日学术速递 周一至周五更新
arXiv 2007.10568cs.DBcs.LG

Buffer Pool Aware Query Scheduling via Deep Reinforcement Learning

Brandeis University(布兰迪斯大学);MIT CSAIL(麻省理工学院计算机科学与人工智能实验室);Intel Labs(英特尔实验室)

Chi Zhang, Ryan Marcus, Anat Kleiman, Olga Papaemmanouil

英文摘要:

In this extended abstract, we propose a new technique for query scheduling with the explicit goal of reducing disk reads and thus implicitly increasing query performance. We introduce SmartQueue, a learned scheduler that leverages overlapping data reads among incoming queries and learns a scheduling strategy that improves cache hits. SmartQueue relies on deep reinforcement learning to produce workload-specific scheduling strategies that focus on long-term performance benefits while being adaptive to previously-unseen data access patterns. We present results from a proof-of-concept prototype, demonstrating that learned schedulers can offer significant performance improvements over hand-crafted scheduling heuristics. Ultimately, we make the case that this is a promising research direction at the intersection of machine learning and databases.

机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。

↑