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

  • Schaffner, J.: Workload Management and Data Placement. Springer International Publishing (2014).
     
  • Schaffner, J., Januschowski, T.: Realistic Tenant Traces for Enterprise !DBaaS. 8th International Workshop on Self-Managing Database Systems (SMDB 2013) (2013).
     
  • Schaffner, J., Januschowski, T., Kercher, M., Kraska, T., Plattner, H., Franklin, M., Jacobs, D.: RTP: Robust Tenant Placement for Elastic In-Memory Database Clusters. ACM SIGMOD Conference (2013).
     
  • Schaffner, J., Jacobs, D., Kraska, T., Plattner, H.: The Multi-Tenant Data Placement Problem. The Fourth International Conference on Advances in Databases, Knowledge, and Data Applications (2012).
     
  • Schaffner, J., Eckart, B., Schwarz, C., Brunnert, J., Jacobs, D., Zeier, A., Plattner, H.: Simulating Multi-Tenant OLAP Database Clusters. Datenbanksysteme in Business, Technologie und Web (BTW 2011), 14. Fachtagung des GI-Fachbereichs "Datenbanken und Informationssysteme" (DBIS), Proceedings, Kaiserslautern, Germany (2011).
     
  • Zeier, A., Jacobs, D., Schwarz, C., Eckart, B., Schaffner, J.: Towards Analytics-as-a-Service Using an In-Memory Column Database. 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).
     
  • Schaffner, J., Zeier, A., Plattner, H., Kraska, T., Franklin, M., Jordan, M., Patterson, D.: Workload Management for Main Memory Databases in Data Clouds. 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).
     
  • Faerber, F., Schaffner, J., Mathis, C., Culp, D.D., Kleis, W.: An In-Memory Database System for Multi-Tenant Applications. Datenbanksysteme in Business, Technologie und Web (BTW 2011), 14. Fachtagung des GI-Fachbereichs "Datenbanken und Informationssysteme" (DBIS), Proceedings, Kaiserslautern, Germany (2011).
     
  • Schaffner, J., Eckart, B., Jacobs, D., Plattner, H., Zeier, A., Schwarz, C.: Predicting In-Memory Database Performance for Automating Cluster Management Tasks. 27th IEEE International Conference on Data Engineering (ICDE) (2011).
     
  • Grund, M., Schaffner, J., Krüger, J., Brunnert, J., Zeier, A.: The Effects of Virtualization on Main Memory Systems. Sixth International Workshop on Data Management on New Hardware (2010).
     
  • Eckart, B., Brunnert, J., Schaffner, J., Zeier, A., Jacobs, D.: Towards Enterprise Software as a Service in the Cloud. Second IEEE Workshop on Information & Software as Services in Conjunction with ICDE 2010, Long Beach, CA, USA (2010).
     
  • Legler, T., Lehner, W., Schaffner, J., Krüger, J.: Robust Distributed Top-N Frequent Pattern Mining Using the SAP BW Accelerator. Proceedings of the 35th Conference on Very Large Databases (VLDB), Lyon, France (2009).
     
  • Boshmaf, Y., Plattner, H., Zeier, A., Schaffner, J., Willhalm, T., Popovici, N.: SIMD-Scan: Ultra Fast in-Memory Table Scan using on-Chip Vector Processing Units. Proceedings of the 35th Conference on Very Large Databases (VLDB), Lyon, France (2009).
     
  • Krueger, J., Grund, M., Tinnefeld, C., Schaffner, J., Mueller, S., Zeier, A.: Enterprise Data Management in Mixed Workload Environments. Proceedings of 16th International Conference on Industrial Engineering and Engineering Management (IE&EM), Beijing, China (2009).
     
  • Mueller, S., Krüger, J., Schaffner, J., Tinnefeld, C., Zeier, A.: Controlled Natural Language for Information Integration. 16th International Conference on Industrial Engineering and Engineering Management (IE&EM), Beijing, China (2009).
     
  • Schaffner, J., Krueger, J., Mueller, S., Hofmann, P., Zeier, A.: Analytics on Historical Data Using a Clustered Insert-Only In-Memory Column Database. 16th International Conference on Industrial Engineering and Engineering Management (IE&EM), Beijing, China (2009).
     
  • Seelig, M., Schaffner, J., Decker, G.: Performance Engineering for Enterprise Applications. 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).
     
  • Schaffner, J., Bog, A., Krüger, J., Zeier, A.: A Hybrid Row-Column OLTP Database Architecture for Operational Reporting. Business Intelligence for the Real Time Enterprise (BIRTE 2008) in conjunction with VLDB'08, Auckland, New Zealand (2008).
     
  • Kowalkiewicz, M., Ludwig, A., Meyer, H., Schaffner, J., Stamber, C., Stein, S.: Composition and Binding. Kuropka, D., Trö,ger, P., Staab, S., and Weske, M. (Eds.), Semantic Service Provisioning, pp. 73 ff., Berlin/Heidelberg, 2008. Springer (2008).
     
  • Tinnefeld, C., Krüger, J., Schaffner, J., Bog, A.: A Database Engine for Flexible Real-Time Available-to-Promise. IEEE Symposium on Advanced Management of Information for Globalized Enterprises (AMIGE'08), Tianjin, China (2008).
     
  • Krüger, J., Grund, M., Schaffner, J., Schapranow, M.-P., Bog, A.: Shared Table Access Pattern Analysis for Multi-Tenant Applications. IEEE Symposium on Advanced Management of Information for Globalized Enterprises (AMIGE'08), Tianjin, China (2008).
     
  • Grund, M., Schaffner, J., Schapranow, M.-P., Bog, A., Krüger, J.: Operational Reporting Using Navigational SQL. IEEE Symposium on Advanced Management of Information for Globalized Enterprises (AMIGE'08), Tianjin, China (2008).
     
  • Schapranow, M.-P., Grund, M., Krüger, J., Schaffner, J., Bog, A.: Combining Advantages - Unified Data Stores in Global Enterprises. IEEE Symposium on Advanced Management of Information for Globalized Enterprises (AMIGE'08), Tianjin, China (2008).
     
  • Schaffner, J., Bog, A., Krüger, J.: A Composite Benchmark for Online Transaction Processing and Operational Reporting. IEEE Symposium on Advanced Management of Information for Globalized Enterprises (AMIGE'08), Tianjin, China (2008).
     
  • Decker, G., Schaffner, J., Seelig, M., Gersabeck, V.: Architecture-Based Performance Simulation. Proceedings of the 2007 IAENG International Conference on Software Engineering (ICSE), Hong Kong, China (2007).
     
  • Schaffner, J., Meyer, H., Tosun, C.: A Semi-automated Orchestration Tool for Service-based Business Processes. 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).
     
  • Schaffner, J., Meyer, H., Weske, M.: A Formal Model for Mixed Initiative Service Composition. Proceedings of the 2007 IEEE International Conference on Services Computing (SCC 2007), pp. 443-450, Salt Lake City, USA (2007).
     
  • Schaffner, J., Meyer, H.: Mixed Initiative Use Cases for Semi-Automated Service Composition: A Survey. Proceedings of the International Workshop on Service Oriented Software Engineering, pp. 6-12, Shanghai, China (2006).
     

Publications

As seen by DBLP.

Books