TU Darmstadt / ULB / TUbiblio

Ibex: an intelligent storage engine with support for advanced SQL offloading

Woods, Louis ; István, Zsolt ; Alonso, Gustavo (2014)
Ibex: an intelligent storage engine with support for advanced SQL offloading.
In: Proceedings of the VLDB Endowment, 7 (11)
doi: 10.14778/2732967.2732972
Artikel, Bibliographie

Kurzbeschreibung (Abstract)

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.

Typ des Eintrags: Artikel
Erschienen: 2014
Autor(en): Woods, Louis ; István, Zsolt ; Alonso, Gustavo
Art des Eintrags: Bibliographie
Titel: Ibex: an intelligent storage engine with support for advanced SQL offloading
Sprache: Englisch
Publikationsjahr: Juli 2014
Verlag: VLDB Endowment
Titel der Zeitschrift, Zeitung oder Schriftenreihe: Proceedings of the VLDB Endowment
Jahrgang/Volume einer Zeitschrift: 7
(Heft-)Nummer: 11
DOI: 10.14778/2732967.2732972
Kurzbeschreibung (Abstract):

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.

Fachbereich(e)/-gebiet(e): 20 Fachbereich Informatik
20 Fachbereich Informatik > Distributed and Networked Systems
Hinterlegungsdatum: 23 Jan 2023 12:31
Letzte Änderung: 04 Mai 2023 14:04
PPN: 507385667
Export:
Suche nach Titel in: TUfind oder in Google
Frage zum Eintrag Frage zum Eintrag

Optionen (nur für Redakteure)
Redaktionelle Details anzeigen Redaktionelle Details anzeigen