Managed acceleration for In-Memory database analytic workloads

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. Graphical Abstract Interaction of the SHEPARD management framework to process user queries from an in-memory database system.

• Publication year

  2017

• Venue

  Int. J. Parallel Emergent Distributed Syst.

• Publication date

  2017-07-04

• Fields of study

  Computer Science, Engineering

• Identifiers
  DOI 10.1080/17445760.2016.1170832
• External record

  Open on Semantic Scholar

• Source metadata

  Semantic Scholar

• No claims are published for this paper.

• No concepts are published for this paper.

• Transaction Processing Performance Council

  2019cited by this paper
• SHEPARD: Scheduling on Heterogeneous Platforms Using Application Resource Demands

  2014cited by this paper
• Cross Resource Optimisation of Database Functionality across Heterogeneous Processors

  2014influential reference
• A Framework for Cost based Optimization of Hybrid CPU / GPU Query Plans in Database Systems

  2013cited by this paper
• Efficient co-processor utilization in database query processing

  2013cited by this paper
• Multi-level Parallel Query Execution Framework for CPU and GPU

  2013cited by this paper
• The SAP HANA Database -- An Architecture Overview

  2012cited by this paper
• Database analytics acceleration using FPGAs

  2012cited by this paper
• Automatic Selection of Processing Units for Coprocessing in Databases

  2012cited by this paper
• Applicability of GPU Computing for Efficient Merge in In-Memory Databases

  2011cited by this paper
• Accelerating SQL database operations on a GPU with CUDA

  2010cited by this paper
• Database compression on graphics processors

  2010cited by this paper
• Column-stores vs. row-stores: how different are they really?

  2008cited by this paper
• GPUTeraSort: high performance graphics co-processor sorting for large database management

  2006cited by this paper

• No citing papers are available for this paper.