*Database Technology Group / †Center for Information Services and High Performance Computing
BibTeX
@MISC{Lehner_*databasetechnology,
author = {Wolfgang Lehner and Technische Universität Dresden},
title = {*Database Technology Group / †Center for Information Services and High Performance Computing},
year = {}
}
Share
 |
 |
 |
 |
||
OpenURL
Abstract
The ever-growing demand for more computing power forces hardware vendors to put an increasing number of multipro-cessors into a single server system, which usually exhibits a non-uniform memory access (NUMA). In-memory database systems running on NUMA platforms face several issues such as the increased latency and the decreased bandwidth when accessing remote main memory. To cope with these NUMA-related issues, NUMA-awareness has to be consid-ered as a major design principle for the fundamental archi-tecture of a database system. In this paper we present ERIS, a NUMA-aware in-memory storage engine that is based on a data-oriented ar-chitecture. In contrast to existing approaches that focus on transactional workloads on a disk-based DBMS, ERIS aims at tera-scale analytical workloads that are executed entirely in main memory. ERIS uses an adaptive partition-ing approach that exploits the topology of the underlying NUMA platform and significantly reduces NUMA-related issues. We evaluate ERIS on widespread standard server systems as well as on a system consisting of 64 multiproces-sors and 512 cores. On these platforms, we achieve a more than linear speedup for index lookups and scalable parallel scan operations that are only limited by the available local bandwidth of the multiprocessor. Moreover, we measured a performance gain of up to 200 % (index lookups) respectively 660 % (column scans) in the memory-bound case compared to a NUMA-agnostic storage subsystem. 1.
Keyphrases
information service database technology group center high performance computing index lookup main memory numa-related issue numa platform data-oriented ar-chitecture linear speedup adaptive partition-ing approach column scan major design principle disk-based dbms database system single server system several issue non-uniform memory access numa-agnostic storage subsystem computing power force hardware vendor widespread standard ever-growing demand memory-bound case numa-aware in-memory storage engine transactional workload decreased bandwidth increased latency scalable parallel scan operation performance gain fundamental archi-tecture in-memory database system present eris available local bandwidth tera-scale analytical workload
