Machine learning is rapidly being used in database research to improve the effectiveness of numerous tasks included but not limited to query optimization, workload scheduling, physical design, etc. essential database components, such as the optimizer, scheduler, and physical designer. Currently, the research focus has been on replacing a single database component responsible for one task by its learning-based counterpart. However, query performance is not simply determined by the performance of a single component, but by the cooperation of multiple ones. As such, learned based database components need to collaborate during both training and execution in order to develop policies that meet end performance goals. Thus, the paper attempts to address the question "Is it possible to design a database consisting of various learned components that cooperatively work to improve end-to-end query latency?". To answer this question, we introduce MADB (Multi-Agent DB), a proof-of-concept system that incorporates a learned query scheduler and a learned query optimizer. MADB leverages a cooperative multi-agent reinforcement learning approach that allows the two components to exchange the context of their decisions with each other and collaboratively work towards reducing the query latency. Preliminary results demonstrate that MADB can outperform the non-cooperative integration of learned components.
翻译:在数据库研究中,正在迅速使用机器学习来提高许多任务的有效性,这些任务包括但不限于查询优化、工作量安排、物理设计等基本数据库组成部分,例如优化、调度和物理设计师。目前,研究重点是更换一个单一的数据库组成部分,由学习对应方负责一项任务。然而,查询的性能不仅仅是由单一组成部分的性能决定,而是由多个组成部分的合作决定。因此,有知识的数据库组成部分需要在培训和执行期间进行合作,以便制定符合最终业绩目标的政策。因此,该文件试图解决“是否有可能设计一个由各种学到的成分组成的数据库,由合作改进端到端的查询延时?”的问题。为了回答这个问题,我们引入了MADB(MUL-Agent DB),一个包含有知识的查询排程器和知识查询优化器的验证概念系统。MADB利用一种合作性多剂强化学习方法,使两个组成部分能够相互交流其决定的背景,并合作减少调查的延迟段。我们采用了不合作的整合结果。