ScyPer: a hybrid OLTP&OLAP distributed main memory database system for scalable real-time analytics

Abstract

ScyPer is an abbreviation for Scaled-out HyPer, a version of the HyPer main memory hybrid OLTP&OLAP database system that horizontally scales out on sharednothing commodity hardware. Our demo shows that ScyPer a) achieves a near-linear scale-out of OLAP query throughput with the number of active nodes, b) sustains a constant OLTP throughput, c) is resilient to node failures, and d) offers real-time analytical capabilities through market-leading query response times and periodically forked TX-consistent virtual memory snapshots with sub-second lifetime durations.