论文标题
硬件加速DBMS中的倒车查询序列优化
The ReProVide Query-Sequence Optimization in a Hardware-Accelerated DBMS
论文作者
论文摘要
数据库查询处理的硬件加速度可以在FPGA的帮助下进行。特别是,它们在运行时可以部分重新配置,这允许将硬件适应各种查询。但是,重新配置本身需要一些时间。由于在重新配置期间无法进行FPGA的影响区域,因此避免某些重新配置可以改善整体性能。本文根据查询序列进行了优化,从而减少了重新配置的影响。即将到来的查询的知识用于(i)在查询仍在运行时已经启动重新配置,并且(ii)避免覆盖可重新配置区域,这些区域将在后续查询中再次使用。我们通过校准模型和测量各种参数值评估我们的优化。即使只有两个查询序列,也可以获得最多可获得28%的执行时间的改进。
Hardware acceleration of database query processing can be done with the help of FPGAs. In particular, they are partially reconfigurable at runtime, which allows for the runtime adaption of the hardware to a variety of queries. Reconfiguration itself, however, takes some time. As the affected area of the FPGA is not available for computations during the reconfiguration, avoiding some of the reconfigurations can improve overall performance. This paper presents optimizations based on query sequences, which reduces the impact of the reconfigurations. Knowledge of upcoming queries is used to (I) speculatively start reconfiguration already when a query is still running and (II) avoid overwriting of reconfigurable regions that will be used again in subsequent queries. We evaluate our optimizations with a calibrated model and measurements for various parameter values. Improvements in execution time of up to 28% can be obtained even with sequences of only two queries.