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

Export BibTeX
1.
Jan Schaffner
Springer International Publishing, 2014
2.
Jan Schaffner,Tim Januschowski,Megan Kercher,Tim Kraska,Hasso Plattner,Michael Franklin,Dean Jacobs
ACM SIGMOD Conference, 2013
3.
Jan Schaffner,Tim Januschowski
8th International Workshop on Self-Managing Database Systems (SMDB 2013), 2013
4.
Jan Schaffner,Dean Jacobs,Tim Kraska,Hasso Plattner
The Fourth International Conference on Advances in Databases, Knowledge, and Data Applications, 2012
5.
Alexander Zeier,Dean Jacobs,Christian Schwarz,Benjamin Eckart,Jan Schaffner
Divyakant Agrawal, K. Selçuk Candan, Wen-Syan Li (Eds.): New Frontiers in Information and Software as Services Service and Application Design Challenges in the Cloud, LNBIP Volume 74, pp. 257–282, Springer-Verlag, Berlin Heidelberg, 2011
6.
Jan Schaffner,Benjamin Eckart,Dean Jacobs,Hasso Plattner,Alexander Zeier,Christian Schwarz
27th IEEE International Conference on Data Engineering (ICDE), 2011
7.
Jan Schaffner,Benjamin Eckart,Christian Schwarz,Jan Brunnert,Dean Jacobs,Alexander Zeier,Hasso Plattner
Datenbanksysteme in Business, Technologie und Web (BTW 2011), 14. Fachtagung des GI-Fachbereichs "Datenbanken und Informationssysteme" (DBIS), Proceedings, Kaiserslautern, Germany, 2011
8.
Franz Faerber,Jan Schaffner,Christian Mathis,Daniel Duane Culp,Wolfram Kleis
Datenbanksysteme in Business, Technologie und Web (BTW 2011), 14. Fachtagung des GI-Fachbereichs "Datenbanken und Informationssysteme" (DBIS), Proceedings, Kaiserslautern, Germany, 2011
9.
Jan Schaffner,Alexander Zeier,Hasso Plattner,Tim Kraska,Michael Franklin,Michael Jordan,David Patterson
Proceedings of the Fall 2010 Future SOC Lab Day, Christoph Meinel, Andreas Polze, AIexander Z., Gerhard Oswald, Dieter Herzog, Volker Smid, Doc D'Errico, Zahid Hussain (Eds.), Volume 42, 2011
10.
Benjamin Eckart,Jan Brunnert,Jan Schaffner,Alexander Zeier,Dean Jacobs
Second IEEE Workshop on Information & Software as Services in Conjunction with ICDE 2010, Long Beach, CA, USA, 2010
11.
Martin Grund,Jan Schaffner,Jens Krüger,Jan Brunnert,Alexander Zeier
Sixth International Workshop on Data Management on New Hardware, 2010
12.
Thomas Legler,Wolfgang Lehner,Jan Schaffner,Jens Krüger
Proceedings of the 35th Conference on Very Large Databases (VLDB), Lyon, France, 2009
13.
Stephan Müller,Jens Krüger,Jan Schaffner,Christian Tinnefeld,Alexander Zeier
16th International Conference on Industrial Engineering and Engineering Management (IE&EM), Beijing, China, 2009
14.
Yazan Boshmaf,Hasso Plattner,Alexander Zeier,Jan Schaffner,Thomas Willhalm,Nicolae Popovici
Proceedings of the 35th Conference on Very Large Databases (VLDB), Lyon, France, 2009
15.
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
16.
Jan Schaffner,Jens Krüger,Stephan Müller,Paul Hofmann,Alexander Zeier
16th International Conference on Industrial Engineering and Engineering Management (IE&EM), Beijing, China, 2009
17.
Marcel Seelig,Jan Schaffner,Gero Decker
Oscar Castillo et al. (Eds.), Trends in Intelligent Systems and Computer Engineering, Lecture Notes in Electrical Engineering, Vol. 6, pp. 557-574, Berlin/Heidelberg, Springer, 2008
18.
Marek Kowalkiewicz,Andre Ludwig,Harald Meyer,Jan Schaffner,Christian Stamber,Sebastian Stein
Kuropka, D., Tröger, P., Staab, S., and Weske, M. (Eds.), Semantic Service Provisioning, pp. 73 ff., Berlin/Heidelberg, 2008, Springer, 2008
19.
Jan Schaffner,Anja Bog,Jens Krüger,Alexander Zeier
Business Intelligence for the Real Time Enterprise (BIRTE 2008) in conjunction with VLDB'08, Auckland, New Zealand, 2008
20.
Matthieu-P. Schapranow,Martin Grund,Jens Krüger,Jan Schaffner,Anja Bog
IEEE Symposium on Advanced Management of Information for Globalized Enterprises (AMIGE'08), Tianjin, China, 2008
21.
Christian Tinnefeld,Jens Krüger,Jan Schaffner,Anja Bog
IEEE Symposium on Advanced Management of Information for Globalized Enterprises (AMIGE'08), Tianjin, China, 2008
22.
Jan Schaffner,Anja Bog,Jens Krüger
IEEE Symposium on Advanced Management of Information for Globalized Enterprises (AMIGE'08), Tianjin, China, 2008
23.
Jens Krüger,Martin Grund,Jan Schaffner,Matthieu-P. Schapranow,Anja Bog
IEEE Symposium on Advanced Management of Information for Globalized Enterprises (AMIGE'08), Tianjin, China, 2008
24.
Martin Grund,Jan Schaffner,Matthieu-P. Schapranow,Anja Bog,Jens Krüger
IEEE Symposium on Advanced Management of Information for Globalized Enterprises (AMIGE'08), Tianjin, China, 2008
25.
Jan Schaffner,Harald Meyer,Cafer Tosun
Proceedings of the 2nd International Workshop on Engineering Service-Oriented Applications: Design and Composition, Chicago, USA, Lecture Notes in Computer Science (LNCS), Vol. 4652, pp. 48-59, Springer-Verlag, Berlin / Heidelberg, 2007
26.
Gero Decker,Jan Schaffner,Marcel Seelig,Volker Gersabeck
Proceedings of the 2007 IAENG International Conference on Software Engineering (ICSE), Hong Kong, China, 2007
27.
Jan Schaffner,Harald Meyer,Mathias Weske
Proceedings of the 2007 IEEE International Conference on Services Computing (SCC 2007), pp. 443-450, Salt Lake City, USA, 2007
28.
Jan Schaffner,Harald Meyer
Proceedings of the International Workshop on Service Oriented Software Engineering, pp. 6-12, Shanghai, China, 2006
Export BibTeX

Publications

As seen by DBLP.

Books