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

Enterprise Data Management in Mixed Workload Environments

Jens Krüger,Martin Grund,Christian Tinnefeld,Jan Schaffner,Stephan Müller,Alexander Zeier
Proceedings of 16th International Conference on Industrial Engineering and Engineering Management (IE&EM), Beijing, China, 2009

BibTeX file

@conference{Jens2009a,
author = { Jens Krüger,Martin Grund,Christian Tinnefeld,Jan Schaffner,Stephan Müller,Alexander Zeier },
title = { Enterprise Data Management in Mixed Workload Environments },
year = { 2009 },
month = { 0 },
booktitle = { Proceedings of 16th International Conference on Industrial Engineering and Engineering Management (IE&EM), Beijing, China },
priority = { 0 }
}

Copyright Notice

last change: Mon, 08 Jun 2015 14:39:05 +0200

Publications

As seen by DBLP.

Books