WiSeDB:基于学习的云数据库管理顾问
WiSeDB: A Learning-based Workload Management Advisor for Cloud Databases
摘要:
云数据库的数据库管理必须以满足应用程序性能目标的方式处理资源配置,查询放置和查询调度任务,同时最大限度地降低使用云资源的成本。现有的解决方案孤立地处理这三个挑战,并且只考虑特定类型的性能目标。在本文中,我们介绍了WiSeDB,一个基于学习的框架,用于生成定制的应用程序定义的性能指标和工作负载特性的整体工作负载管理解决方案。我们的方法依赖于监督学习训练成本效益的决策树模型,用于指导查询放置,调度和资源配置决策。应用程序可以将这些模型用于传入工作负载的批处理和在线调度。我们的系统的一个独特功能是,它可以调整其离线模型,以更严格/更宽松的性能目标,最小的重新训练。这使我们能够提出替代的工作负载管理策略,解决云服务的典型性能与成本权衡。实验结果表明,我们的方法具有非常低的训练开销,同时为各种性能目标和工作负载特性提供低成本的策略。
英文摘要:
Workload management for cloud databases must deal with the tasks of resource provisioning, query placement and query scheduling in a manner that meets the application's performance goals while minimizing the cost of using cloud resources. Existing solutions have approached these three challenges in isolation, and with only a particular type of performance goal in mind. In this paper, we introduce WiSeDB, a learning-based framework for generating holistic workload management solutions customized to application-defined performance metrics and workload characteristics. Our approach relies on supervised learning to train cost-effective decision tree models for guiding query placement, scheduling, and resource provisioning decisions. Applications can use these models for both batch and online scheduling of incoming workloads. A unique feature of our system is that it can adapt its offline model to stricter/looser performance goals with minimal re-training. This allows us to present alternative workload management strategies that address the typical performance vs. cost trade-off of cloud services. Experimental results show that our approach has very low training overhead while offering low cost strategies for a variety of performance goals and workload characteristics.
机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。