Air quality is an important factor for human quality of life. As a result, many governments are creating guidelines concerning emissions. To achieve better air quality, governments, industry and infrastructure providers have to work together to implement effective pollution management programs

A core requirement for these programs is the effective assessment of the geographical distribution of emissions and their sources. This allows environmental experts to determine the best policies and most effective locations for emission mitigating infrastructure. Read more.

Contact: Günter Hesse, Markus Dreseler, Dr. Matthias Uflacker

Research Area: In-Memory Data Management for Enterprise Systems

Today’s reporting offers unprecedented flexibility. Companies can dive into their data, filter for criteria, and drill down into hierarchies to explore their data live and on line item level. Companies wish to exploit this flexibility not only for reporting but also for forecasting and simulation. They want to define potential future scenarios and calculate how these influence their businesses. Exploiting SAP HANA and our Aggregate Cache technology, what-if analyses can be modeled and run efficiently by means of interactively defined simulation scenarios that are calculated on the fly. In that way, the analyses can not only support the monthly budgeting process but also day-to-day decision-making and simplified planning. Read more.

Contact: Stefan Klauck, Dr. Matthias Uflacker

Research Area: In-Memory Data Management for Enterprise Systems

The HANA Load Simulator creates a realistic enterprise workload of thousands of concurrent users and executes that workload on different database configurations simultaneously. A dashboard monitors several performance indicators of each database, incl. data footprint, transaction latencies, throughput, and overall CPU utilization. The dashboard can also be used to configure several workload parameters like OLTP and OLAP query frequencies or the ratio of actual and historical queries. This provides a simple and interactive tool to assess key performance characteristics of different database setups (e.g., single- vs. multi-node) side-by-side and in real-time. Read more.

Contact: Martin Boissier, Carsten Meyer, Dr. Matthias Uflacker

Research Area: In-Memory Data Management for Enterprise Systems

In October 2014, the Helmholtz Center for Infectious Diseases, Robert Koch Institute, Bernhard Nocht Institute, Nigeria Field Epidemiology and Laboratory Training Program (NFELTP), Hasso Plattner Institute, and SAP consolidated their efforts and expertise in an interdisciplinary committee to build the Surveillance Outbreak and Response Management System (SORMAS), a management tool to support identifying emerging infections and suspected cases as well as their contacts and leveraging immediate information exchange between all involved parties of outbreak control. In order to meet the specific technical requirements of West African countries, SORMAS consists of applications for both desktop PCs and Android smartphones that are connected to a central data management platform. Read more.

Contact: Cindy Perscheid, Dr. Matthieu-P. Schapranow, Dr. Matthias Uflacker

Research Area: In-Memory Data Management for Life Sciences

MediTweet is an open messaging system for clinical environments. It connects Clinical Information Systems (CIS) with both medical devices and personnel. With MediTweet the users are enabled to send structured messages to other users in order to automate documentation and task synchronization. Additionally, users are automatically informed about medical results of patients by medical devices. Read more.

Contact: Martin Boissier, Carsten Meyer, Stefan Klauck, Dr. Matthias Uflacker

Research Area: In-Memory Data Management for Life Sciences

Sales representatives (reps) maximize sales profitability by selling goods and services. They visit retail stores within an assigned territory to fully exploit the sales potential for the products of their represented company. During their visits the sales reps record and optimize product placement, install advertising displays, check products for compliance, i.e. whether the store offers them to buy, as well as out-of stock situations, and talk to the stores’ managers to improve the product representation within the store. Regularly, sales reps have to schedule their store visits for the upcoming time frame with the goal to choose the “right” stores, which are supposed to increase the sales profitability as much as possible. Until now, this planning is done manually based on static and aggregated data provided by spreadsheets from the rep’s manager. Read more.

Contact: Martin Faust, Stefan Klauck, David Schwalb, Dr. Matthias Uflacker

Research Area: In-Memory Data Management for Enterprise Systems 

PopulAid is a tool to generate customized data for application testing. Via a convenient web interface, developers can easily pick their database schemas, assign generators to columns, and get immediate previews of potential results. In doing so, generators consider not only specific value properties for one column such as the data type, ranges, data pools, distributions, or the number of distinct values, but also keep foreign keys, allow for pattern evaluation and fulfill dependencies for column combinations. PopulAid allows developers to create data in a scalable and efficient manner by applying these generators to SAP HANA. Read more.

Contact: Ralf Teusner

Research Area: Methods for Enterprise Systems Design and Engineering

Taking development workflow to the next level

Programming workflow can be disturbed by unnecessary long phases of debugging and web searches for the needed information. To reduce the duration of such phases, Flowr aims at bringing the right information directly to the developer at the right time. This helps increase developer efficiency and also reduces developer stress caused by many cognitive context switches between developing and searching for problem solutions. Flowr analyzes design- and runtime exceptions and searches for solutions and strategies in different data sources. When an exception is thrown, it is isolated from surrounding output and split into parts like type, file, and line. The exception text is then scanned for relevant tokens, such as library versions or technical details. After preprocessing, the exception is fed into several data sources via their respective APIs. Flowr then ranks the results of these queries internally, taking user feedback into account. It then comprises a distraction-free result page, sorted by relevance. This ranked list is shown to the developer who then decides which solution matches the problem best and rates results based on their usefulness. Read more.

Contact: Ralf Teusner

Research Area: Methods for Enterprise Systems Design and Engineering

In-Memory Databases in the Cloud

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. Read more.

This project is joint work with SAP and the University of California in Berkeley.

Contact: Dr. Jan Schaffner, Christian Schwarz

Research Area: In-Memory Enterprise Data Management

Using shared DRAM as persistence for an in-memory DBMS

A shared-nothing architecture is state-of-the-art for deploying a distributed analytical in-memory database management system: it preserves the in-memory performance advantage by processing data locally on each node but is difficult to scale out. Modern switched fabric communication links such as InfiniBand narrow the performance gap between local and remote DRAM data access to a single order of magnitude. Based on these premises, this project introduces a distributed in-memory database architecture that separates the query execution engine and data access: this enables a) the usage of a large-scale DRAM-based storage system such as Stanford's RAMCloud and b) the push-down of bandwidth-intensive database operators into the storage system. We address the resulting challenges such as finding the optimal operator execution strategy and partitioning scheme. The project demonstrates that such an architecture delivers both: the elasticity of a shared-storage approach and the performance characteristics of operating on local DRAM. In our project, we created AnalyticsDB which is a prototypical analytical query processor with a pluggable storage layer.

Contact: Christian Tinnefeld

Research Area: In-Memory Data Management for Enterprise Systems

Help to improve cancer treatments by real-time analysis of medical data

Charité Medicine, Charité IT, SAP's Innovation Center in Potsdam, and the Enterprise Platform and Integration Concepts (EPIC) chair at the Hasso Plattner Institute (HPI) combine their competences in the research initiative "HANA Oncolyzer" to improve the IT-aided treatment of patients suffering from cancer diseases. The improved knowledge about tumor physiognomy and about active medical ingredients will successfully support cancer treatments. As a result, cancer therapies will be more accurately adjustable for individual patients and cancer forms to improve healing evidently. Read more.

Contact: Dr. Matthieu Schapranow

Research Area: In-Memory Data Management for Life Sciences

This Bachelor Project is a cooperation between the SAP Innovation Center Potsdam and the Chair of Prof. Dr. h.c. Hasso Plattner. It 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. Read more.

Contact: Dr. Matthieu Schapranow

Research Area: In-Memory Data Management for Enterprise Systems