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

Dr. Jan Schaffner

E-Mail: jan.schaffner(at)sap.com
XING: Profile
LinkedIn

Research Topics

  • In-Memory Column Databases
  • Software-as-a-Service
  • Data Placement
  • Optimization
  • Semi-Automated Web Service Composition

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. Make sure to have a look at our project poster.

Teaching Activities

  • Lecture "Trends and Concepts in the Software Industry I", Summer term 2012
  • Seminar "Trends and Concepts in the Software Industry II" (Coach), Winter term 2011/12
  • Lecture "Trends and Concepts in the Software Industry I", Summer term 2011
  • Seminar "Trends and Concepts in the Software Industry II" (Coach), Winter term 2010/11
  • Seminar "In-Memory Data Processing and Management", Winter term 2010
  • Lecture "Trends and Concepts in the Software Industry I", Summer term 2010
  • Seminar "Trends and Concepts in the Software Industry II" (Coach), Winter term 2009/10
  • Seminar "Main Memory Data Management", Summer term 2009
  • Lecture "Trends and Concepts in the Software Industry I", Summer term 2009
  • Seminar "Trends and Concepts in the Software Industry II" (Coach), Winter term 2008/09
  • Lecture "Trends and Concepts in the Software Industry I", Summer term 2008
  • Seminar " Enterprise Data Models and their Performance", Summer term 2008
  • Seminar "Trends and Concepts in the Software Industry II" (Coach), Winter term 2007/08
  • Seminar " Enterprise Data Models and their Performance", Summer term 2007
  • Lecture "Trends and Concepts in the Software Industry I", Summer term 2007
  • B.Sc. Project "FIA" (Supervisor), Summer term 2007
  • Bachelor Project Preparatory Seminar, Winter term 2006/07
  • Seminar "Trends and Concepts in the Software Industry II" (Coach), Winter term 2006/07
  • Studienbegleitendes Seminar, Winter term 2006

Patents

Publications

RTP: Robust Tenant Placement for Elastic In-Memory Database Clusters

Jan Schaffner,Tim Januschowski,Megan Kercher,Tim Kraska,Hasso Plattner,Michael Franklin,Dean Jacobs
ACM SIGMOD Conference, 2013

BibTeX file

@conference{Jan2013a,
author = { Jan Schaffner,Tim Januschowski,Megan Kercher,Tim Kraska,Hasso Plattner,Michael Franklin,Dean Jacobs },
title = { RTP: Robust Tenant Placement for Elastic In-Memory Database Clusters },
year = { 2013 },
month = { 0 },
booktitle = { ACM SIGMOD Conference },
priority = { 0 }
}

Copyright Notice

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

Publications

As seen by DBLP.

Books