Ibex - An Intelligent Storage Engine with Support for Advanced SQL Off-loading
Ibex - An Intelligent Storage Engine with Support for Advanced SQL Off-loading
复制标题
DOI：
--
复制
发表时间：
2014
期刊：
影响因子：
--
通讯作者：
L. Woods;Z. István;G. Alonso
中科院分区：
文献类型：
--
作者：
L. Woods;Z. István;G. Alonso
现代数据设备在将大量数据从存储移动到查询处理节点时面临严重的带宽瓶颈。缓解这些瓶颈的一个可能的解决方案是将查询加载到智能存储引擎，其中部分或全部查询被下推到存储引擎。在本文中，我们提出了Ibex，一个智能存储引擎的原型，支持复杂的查询运算符的O-负载。除了提高性能外，Ibex还降低了能耗，因为它使用FPGA而不是传统的CPU来实现O-负载引擎。Ibex是一个混合引擎，具有以行速率计算SQL表达式的专用硬件和硬件引擎无法处理的任务的软件回退。Ibex支持GROUP BY聚合，以及基于投影和选择的过滤。GROUP BY聚合对性能的影响更大，但在FPGA上实现也是一个更具挑战性的运算符。
Modern data appliances face severe bandwidth bottlenecks when moving vast amounts of data from storage to the query processing nodes. A possible solution to mitigate these bottlenecks is query off-loading to an intelligent storage engine , where partial or whole queries are pushed down to the storage engine. In this paper, we present Ibex , a prototype of an intelligent storage engine that supports off-loading of complex query operators. Besides increasing performance, Ibex also reduces energy consumption, as it uses an FPGA rather than conventional CPUs to implement the off-load engine. Ibex is a hybrid engine, with dedicated hardware that evaluates SQL expressions at line-rate and a software fallback for tasks that the hardware engine cannot handle. Ibex supports GROUP BY aggregation, as well as projection - and selection - based filtering. GROUP BY aggregation has a higher impact on performance but is also a more challenging operator to implement on an FPGA.