arrow
Return

Efficient co-processor utilization in database query processing

delete2013-11-01
delete28
PRE
AI
S
Sebastian Breß *
F
Felix Beier
H
Hannes Rauhe
K
Kai-Uwe Sattler
E
Eike Schallehn
G
Gunter Saake
DOI:10.1016/j.is.2013.05.004delete
deleteOriginal
deleteShare
deleteSave
Abstract

Abstract

En 中文
Specialized processing units such as GPUs or FPGAs provide great opportunities to speed up database operations by exploiting parallelism and relieving the CPU. However, distributing a workload on suitable (co-)processors is a challenging task, because of the heterogeneous nature of a hybrid processor/co-processor system. In this paper, we present a framework that automatically learns and adapts execution models for arbitrary algorithms on any (co-)processor. Our physical optimizer uses the execution models to distribute a workload of database operators on available (co-)processing devices. We demonstrate its applicability for two common use cases in modern database systems. Additionally, we contribute an overview of GPU-co-processing approaches, an in-depth discussion of our framework's operator model, the required steps for deploying our framework in practice and the support of complex operators requiring multi-dimensional learning strategies. (C) 2013 Elsevier Ltd. All rights reserved.
Keywords:
Query optimization
Learning-based decision model
Database co-processing
Modern hardware architectures
In-memory databases

Journal

Enterprise Information Systems cover
Enterprise Information Systems
IF:
3.9
Papers:
2.8K
Citations:
2.8K

Organization

T
Technische Universitat Ilmenau
Scholars:
132
Papers: 52
Citations: 986
O
Otto-Von-Guericke University
Scholars:
67
Papers: 20
Citations: 31
Cited Papers

Cited Papers

One-carbon metabolism disturbances in affective disorders
err1985-11-01
err0
PREAI
errRenato D. Alarcon; Lelland C. Tolbert; John A. Monti; Donna A. Morere; William G. Walter-Ryan; Beverly Kemp; John R. Smythies
errShare
errSave
Novel mutations in the OPN1LW and NR2R3 genes in a patient with blue cone monochromacy
err2019-01-07
err0
PREAI
errBincui Cai; Zhiqing Li; Shuo Sun; Linni Wang; Lu Chen; Jin Yang; Xiaorong Li
errShare
errSave
err
IF0
err
err0
PREAI
err
errShare
errSave
Carben‐Reaktionen, XVII. Nitrilylide durch 1,1‐Eliminierung
err2006-01-23
err0
PREAI
errReinhard W. Hoffmann; Wolfgang Barth
errShare
errSave
Defining the mechanism of the mitochondrial Atm1p [2Fe–2S] cluster exporter
err2020-04-27
err0
errOAAI
errStephen A Pearson; Christine Wachnowsky; J A Cowan
errShare
errSave
researcher View more