One DBMS for all: the Brawny Few and the Wimpy Crowd

T Mühlbauer, W Rödiger, R Seilbeck, A Reiser… - Proceedings of the …, 2014 - dl.acm.org
T Mühlbauer, W Rödiger, R Seilbeck, A Reiser, A Kemper, T Neumann
Proceedings of the 2014 ACM SIGMOD international conference on Management of …, 2014dl.acm.org
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 …
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.
ACM Digital Library
Showing the best result for this search. See all results