Paper Info
Title
One DBMS for all: the brawny few and the wimpy crowd
Abstract
Shipments of smartphones and tablets with wimpy CPUs are outpacing brawny PC and server shipments by an ever-increasing margin. While high performance database systems have traditionally been optimized for brawny systems, wimpy systems have received only little attention; leading to poor performance and energy inefficiency on such systems. This demonstration presents HyPer, a high-performance hybrid OLTP&OLAP main memory database system that we optimized for both, brawny and wimpy systems. The efficient compilation of transactions and queries into efficient machine code allows for high performance, independent of the target platform. HyPer has a memory footprint of just a few megabytes, even though it supports the SQL-92 standard, a PL/SQL-like scripting language, and ACID-compliant transactions. It is the goal of this demonstration to showcase the same HyPer codebase running on (a) a wimpy ARM-based smartphone system and (b) a brawny x86-64-based server system. In particular, we run the TPC-C, TPC-H, and a combined CH-benCHmark and report performance and energy numbers. The demonstration further allows the interactive execution of arbitrary SQL queries and the visualization of optimized query plans.
Year
DOI
Venue
2014
10.1145/2588555.2594527
SIGMOD Conference
Keywords
Field
DocType
high performance,relational databases,transaction processing,brawny,wimpy,parallel databases,energy efficiency,query processing
Codebase,SQL,Data mining,Megabyte,Computer science,Online transaction processing,Machine code,Memory footprint,Online analytical processing,Operating system,Database,Scripting language
Conference
Citations 
PageRank 
References 
7
0.49
9
Authors
6
Name
Order
Citations
PageRank
Tobias Mühlbauer121712.21
Wolf Rödiger21297.03
Robert Seilbeck3401.47
Angelika Reiser4191.15
Alfons Kemper53519769.50
Thomas Neumann62523156.50