论文标题

可重新配置硬件加速系统的查询序列优化

Query-Sequence Optimization on a Reconfigurable Hardware-Accelerated System

论文作者

G., Lekshmi B., Becher, Andreas, Meyer-Wegener, Klaus

论文摘要

数据库查询处理的硬件加速度可以在FPGA的帮助下进行。特别是,它们在运行时可以部分重新配置,这允许将硬件适应各种查询。但是,重新配置本身需要一些时间。由于在重新配置期间无法进行FPGA的影响区域,因此避免某些重新配置可以改善整体性能。本文根据查询序列进行了优化,从而减少了重新配置的影响。即将到来的查询的知识用于(i)在查询仍在运行时已经投机启动重新配置,并且(ii)避免覆盖可重构区域,这些区域将在后续查询中再次使用。我们通过校准模型和测量各种参数值评估我们的优化。即使只有两个查询的序列,也可以获得最多可获得21%的执行时间的改进

Hardware acceleration of database query processing can be done with the help of FPGAs. In particular, they are partially reconfigurable during 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 coming 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 21% can be obtained even with sequences of only two queries

扫码加入交流群

加入微信交流群

微信交流群二维码

扫码加入学术交流群,获取更多资源