Prof. Dr. h.c. Hasso Plattner

Christian Schwarz, M. Sc.

Research Projects

Predictive Analytics on In-Memory Databases

For manufacturers it is important to have an accurate demand forecast for their products in order to avoid over or under capacity in their stores. In case of Vendor-Managed-Inventory the manufacturer is solely responsible for filling the shelfs inside the retail stores. Point-of-Sale (POS) data is one of the most important basis for forecasting. However, for different reasons, many shops cannot provide this kind of data. Instead of using imprecise shipment forecasting, new approaches have to be evaluated.

Intermodal Mobility using In-Memory Databases

The usage of electric vehicles is especially attractive for people living urban areas. Those people often only have to drive short distances and are able to charge their electric vehicles at home. Thus, the limited travel distance does not negatively affect the overall comfort of owning an electric vehicle vs. using a normal car. Nevertheless, in larger cities like Berlin, the range provided by one charging cycle might not be enough for one day. For drivers of electrical vehicles it got complicated if they need to recharge their vehicle during a trip, requiring up to multiple hours for recharging their vehicle. This project has build a prototype to make it more comfortable to drive an EV, even when recharging is required.

In-Memory Real-Time Energy Management

The project focuses on the real-time evaluation and processing of huge amounts of data that arise from smart grids, both for enterprises as well as customers since smart homes and smart industries leverage great possibilities for the existing challenges in the energy business. In-memory column store technology allows us to process the huge amount of data in real time, including energy demand forecasting and consumption pattern analysis.

The Rock Project

For traditional data warehouses, mostly large and expensive server and storage systems are used. In particular, for small- and medium size companies, it is often too expensive to run or rent such systems. This problem stems from the use of a) complex cube structures containing pre-aggregated values for reporting and b) materialized views to pre-compute joins between fact and dimensions tables. The inherent design principles of memory-based column databases allow for the computation of aggregations and joins on-the-fly without relying on materialized views, making them the technology of choice for SME analytics. SMEs might, however, need analytical services only from time to time, for example at the end of a billing period. A solution to overcome these problems is to use Cloud Computing. In the Rock project, we are building an OLAP cluster of analytics databases on the Amazon EC2 cloud. For this purpose we build infrastructure around SAP's in-memory column database TREX to support multi-tenancy, replication, and failover. This project is joint work with SAP and the University of California in Berkeley.


Optimizing Operation Scheduling for In-Memory Databases

Christian Schwarz,Vadym Borovskiy,Alexander Zeier
The 2011 International Conference on Modeling, Simulation and Visualization Methods, 2011

BibTeX file

author = { Christian Schwarz,Vadym Borovskiy,Alexander Zeier },
title = { Optimizing Operation Scheduling for In-Memory Databases },
year = { 2011 },
month = { 0 },
booktitle = { The 2011 International Conference on Modeling, Simulation and Visualization Methods },
priority = { 0 }

Copyright Notice

last change: Fri, 08 May 2015 14:38:44 +0200