Jan Schaffner, M. Sc.
|
|
Research assistant, PhD student
|
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.
Publications
As seen by
DBLP.
Conference and Workshop Papers
2013 (2)
-
Jan Schaffner, Tim Januschowski, Megan Kercher, Tim Kraska, Hasso Plattner, Michael Franklin, Dean Jacobs: RTP: Robust Tenant Placement for Elastic In-Memory Database Clusters, ACM SIGMOD Conference, 2013
- Download, BibTeX
-
Jan Schaffner, Tim Januschowski: Realistic Tenant Traces for Enterprise DBaaS?, 8th International Workshop on Self-Managing Database Systems (SMDB 2013), 2013
- Download, BibTeX
2012 (1)
-
Jan Schaffner, Dean Jacobs, Tim Kraska, Hasso Plattner: The Multi-Tenant Data Placement Problem, The Fourth International Conference on Advances in Databases, Knowledge, and Data Applications, 2012
- Download, BibTeX
2011 (3)
-
Jan Schaffner, Benjamin Eckart, Christian Schwarz, Jan Brunnert, Dean Jacobs, Alexander Zeier, Hasso Plattner: 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
- Download, BibTeX
-
Franz Faerber, Christian Mathis, Daniel Duane Culp, Wolfram Kleis, Jan Schaffner: 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
BibTeX
-
Jan Schaffner, Benjamin Eckart, Dean Jacobs, Christian Schwarz, Hasso Plattner, Alexander Zeier: Predicting In-Memory Database Performance for Automating Cluster Management Tasks, 27th IEEE International Conference on Data Engineering (ICDE), 2011
- Download, BibTeX
2010 (2)
-
Jan Schaffner, Dean Jacobs, Benjamin Eckart, Jan Brunnert, Alexander Zeier: 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
- Download, BibTeX
-
Martin Grund, Jan Schaffner, Jens Krüger, Jan Brunnert, Alexander Zeier: The Effects of Virtualization on Main Memory Systems, Sixth International Workshop on Data Management on New Hardware, 2010
- Download, BibTeX
2009 (5)
-
Thomas Legler, Wolfgang Lehner, Jan Schaffner, Jens Krüger: 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
- Download, BibTeX
-
Thomas Willhalm, Nicolae Popovici, Yazan Boshmaf, Hasso Plattner, Alexander Zeier, Jan Schaffner: 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
- Download, BibTeX
-
Stephan Müller, Jens Krüger, Jan Schaffner, Christian Tinnefeld, Alexander Zeier: Controlled Natural Language for Information Integration, 16th International Conference on Industrial Engineering and Engineering Management (IE&EM), Beijing, China, 2009
- Download, BibTeX
-
Jens Krüger, Martin Grund, Christian Tinnefeld, Jan Schaffner, Stephan Müller, Alexander Zeier: Enterprise Data Management in Mixed Workload Environments, 16th International Conference on Industrial Engineering and Engineering Management (IE&EM), Beijing, China, 2009
- Download, BibTeX
-
Jan Schaffner, Jens Krüger, Stephan Müller, Paul Hofmann, Alexander Zeier: 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
- Download, BibTeX
2008 (6)
-
Christian Tinnefeld, Jens Krüger, Jan Schaffner, Anja Bog: 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
- Download, BibTeX
-
Anja Bog, Jan Schaffner, Jens Krüger: 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
- Download, BibTeX
-
Martin Grund, Jan Schaffner, Matthieu-P. Schapranow, Jens Krüger, Anja Bog: Shared Table Access Pattern Analysis for Multi-Tenant Applications, IEEE Symposium on Advanced Management of Information for Globalized Enterprises (AMIGE'08), Tianjin, China, 2008
- Download, BibTeX
-
Martin Grund, Jens Krüger, Jan Schaffner, Matthieu-P. Schapranow, Anja Bog: Operational Reporting Using Navigational SQL, IEEE Symposium on Advanced Management of Information for Globalized Enterprises (AMIGE'08), Tianjin, China, 2008
- Download, BibTeX
-
Matthieu-P. Schapranow, Martin Grund, Jens Krüger, Jan Schaffner, Anja Bog: Combining Advantages - Unified Data Stores in Global Enterprises, IEEE Symposium on Advanced Management of Information for Globalized Enterprises (AMIGE'08), Tianjin, China, 2008
- Download, BibTeX
-
Jan Schaffner, Anja Bog, Jens Krüger, Alexander Zeier: 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
- Download, BibTeX
2007 (3)
-
Gero Decker, Volker Gersabeck, Jan Schaffner, Marcel Seelig: Architecture-Based Performance Simulation, Proceedings of the 2007 IAENG International Conference on Software Engineering (ICSE), Hong Kong, China, 2007
- Download, BibTeX
-
Jan Schaffner, Harald Meyer, Mathias Weske: A Formal Model for Mixed Initiative Service Composition, Proceedings of the 2007 IEEE International Conference on Services Computing (SCC 2007), pp. 443-450, ISBN: 0-7695-2925-9, Salt Lake City, USA, 2007
- Download, BibTeX
-
Jan Schaffner, Harald Meyer, Cafer Tosun: 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
- Download, BibTeX
2006 (1)
-
Jan Schaffner, Harald Meyer: Mixed Initiative Use Cases for Semi-Automated Service Composition: A Survey, Proceedings of the International Workshop on Service Oriented Software Engineering, pp. 6-12, ISBN: 1-59593-398-0, Shanghai, China, 2006
- Download, BibTeX
Book Chapters
2011 (1)
-
Jan Schaffner, Benjamin Eckart, Christian Schwarz, Dean Jacobs, Alexander Zeier: 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, 2011
- Download, BibTeX
2008 (2)
-
Marcel Seelig, Jan Schaffner, Gero Decker: 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, ISBN: 978-0-387-74934-1, Springer-Verlag, Berlin/Heidelberg, 2008
- Download, BibTeX
-
Marek Kowalkiewicz, Andre Ludwig, Harald Meyer, Jan Schaffner, Christian Stamber, Sebastian Stein: Composition and Binding, Kuropka, D., Tröger, P., Staab, S., and Weske, M. (Eds.), Semantic Service Provisioning, pp. 73 ff., ISBN: 978-3-540-78616-0, Springer-Verlag, Berlin/Heidelberg, 2008, 2008
- Download, BibTeX
Technical Reports
2011 (1)
-
Jan Schaffner, Alexander Zeier, Hasso Plattner, Tim Kraska, Michael Franklin, Michael Jordan, David Patterson: 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, ISBN 978-3-86956-114-1, 2011
- Download, BibTeX
Master Thesis
2006 (1)
-
Jan Schaffner: Supporting the Modeling of Business Processes Using Semi-Automated Web Service Composition Techniques, Master Thesis, Hasso Plattner Institute, University of Potsdam, Germany, 2006
- Download, BibTeX
Patents
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
