Hasso-Plattner-Institut
  
Hasso-Plattner-Institut
Prof. Dr. h.c. Hasso Plattner
  
 

Previous Research Projects

Real-time Sales Data Exploration (POS Explorer)

The POS Explorer helps retail companies to explore their sales data in real time. It supports employees to initiate and plan new promotions. Typical questions are which products should be promoted and how they will react to price changes. To achieve this, the software offers different views on the data such as the basket analysis or the week matrix. Exploring the raw POS data with sub-second response times and finding new interesting combinations of products for promotions generates helpful insights, resulting in actual business value. Read more.

Contact: Martin Faust, David SchwalbDr. Matthias Uflacker

Research Area: In-Memory Data Management for Enterprise Systems


MediTweet

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


PopulAid

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


Flowr

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


ROCK

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


Elastic Online Analytical Processing on RAMCloud

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


HANA Oncolyzer

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


InterMobilyzer

Intermodal Mobility using In-Memory Databases

The usage of electric vehicles is especially attractive for people living in 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 is more complicated if they need to recharge their vehicle during a trip, as they may require up to multiple hours for recharging their vehicle. This project has built a prototype to make it more comfortable to drive an EV, even when recharging is required. Read more.

Contact: Christian Schwarz


GoRFID

High Performance Discovery Service and Information Services for the EPCglobal Network

The GoRFID Project is a strategic SAP project, which targets the development and evaluation of performance critical applications within the EPCglobal Network Architecture. Visibility and real-time awareness are the two major use cases for the implementation of RFID in supply chain management. Objects, assigned with unique identifiers (Electronic Product Codes, EPCs) travel from production facilities to the consumers, producing data, highly relevant for most supply chain processes. Such data need to be stored and exchanged among different, potentially independent, supply chain parties. Read more.

Contact: Martin Lorenz

Research Area: In-Memory Data Management for Enterprise Systems


Global Availability-To-Promise

Global Availability-To-Promise (ATP) provides necessary information about the availability of various products. Global in this context describes the need to gather information from heterogeneous enterprise-wide systems. The ATP check describes the process step which is involved when a customer queries the availability of a certain product. A reasonable feedback of this check must be processed rather in real-time than in batch mode. A typical use case is an online store, which shows the amount of available products selected by a customer. Once the availability for a product is gueranteed and the customer decides to place a sales order the Order-To-Cash Scenario is triggered. Read more.

Contact: Matthieu-P. Schapranow


In-Memory Real-Time Energy Management

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: Christian Schwarz

Research Area: In-Memory Data Management for Enterprise Systems


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

Contact: Christian Schwarz

Research Area: In-Memory Data Management for Enterprise Systems