Managed Acceleration for In-Memory Database Analytic Workloads

Eoghan O'Neill, John McGlone, Peter Kilpatrick, Dimitrios Nikolopoulos

Research output: Contribution to journalArticle

296 Downloads (Pure)

Abstract

In-Memory Databases (IMDBs), such as SAP HANA, enable new levels of database performance by removing the disk bottleneck and by compressing data in memory. The consequence of this improved performance means that reports and analytic queries can now be processed on demand. Therefore, the goal is now to provide near real-time responses to compute and data intensive analytic queries. To facilitate this, much work has investigated the use of acceleration technologies within the database context. While current research into the application of these technologies has yielded positive results, they have tended to focus on single database tasks or on isolated single user requests. This paper uses SHEPARD, a framework for managing accelerated tasks across shared heterogeneous resources, to introduce acceleration into an IMDB. Results show how, using SHEPARD, multiple simultaneous user queries all receive speed-up by using a shared pool of accelerators. Results also show that offloading analytic tasks onto accelerators can have indirect benefits for other database workloads by reducing contention for CPU resources.
Original languageEnglish
Pages (from-to)406-427
JournalInternational Journal of Parallel, Emergent and Distributed Systems
Volume32
Issue number4
Early online date06 May 2016
DOIs
Publication statusEarly online date - 06 May 2016

Fingerprint Dive into the research topics of 'Managed Acceleration for In-Memory Database Analytic Workloads'. Together they form a unique fingerprint.

  • Cite this