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

Dr. Anja Bog

Research Topic: Benchmarking Composite Transaction and Analytical Processing Systems

The focus of my thesis within our research area In-Memory Enterprise Data Management is the development of a composite workload benchmark, based on real SAP applications and customer data, and a surrounding comparison methodology that includes dimensions such as flexibility, ease-of-use, total cost of ownership, and timeliness of results. This methodology will be applied to conventional data management systems as a baseline as well as new systems that are able to adapt to varying workloads flexibly. The expected contributions of this research are a) guidelines for which composite systems are appropriate to use in which circumstances, b) the comparison methodology itself (see my blog post "The Case for a Combined OLTP and OLAP Benchmark" in our In-Memory Blog), and c) a quantification of fundamental trade-offs in system design when expecting mixed workloads.

  • Development of a benchmark called Composite Benchmark for Transactions and Reporting (CBTR) for mixed OLTP and OLAP workloads
  • Implementation of a tool chain to run the benchmark and result evaluation (please also see the CBTR benchmark page for more details)
  • Application of the proposed benchmark on different database types (in-memory, disk-based, row and column-oriented) for the evaluation of the impact of

    • mixing OLTP with OLAP
    • the variation of logical database design, in particular data schemas on OLTP and OLAP query performance

Teaching Activities

TermTypeTitle
Winter 2011/12 Lecture Trends and Concepts in the Software Industry II - Evaluation of in-memory databases for enterprise applications
Summer 2011 Project Trends und Konzepte in der Software Industrie I - Enterprise iOS Applications
Winter 2010/11 Lecture Trends and Concepts in the Software Industry II - Information for the Mobile Manager
Summer 2010 Seminar In-Memory Data Processing and Management
Lecture Trends and Concepts in the Software Industry I
Bachelor Project Supply Chain Planning Processes
Winter 2009/10 Bachelor Project Supply Chain Planning Processes
Lecture Trends and Concepts in the Software Industry II
Summer 2009 Seminar Main-memory Data Processing
Winter 2008/09 Lecture Trends and Concepts in the Software Industry II
Summer 2008 Lecture Trends and Concepts in the Software Industry I
Seminar Enterprise Data Models and their Performance
Winter 2007/08 Lecture Trends and Concepts in the Software Industry II
Summer 2007 Lecture Trends and Concepts in the Software Industry I
Seminar Enterprise Data Models and their Performance
Bachelor Project Financials Accelerator - Real-time Reporting on Operational Data
Winter 2006/07 Bachelor Project Financials Accelerator - Real-time Reporting on Operational Data
Seminar Trends and Concepts in the Software Industry II

Publications

  • Bog, A.: The Creation of a Mixed Workload Benchmark and its Application. Springer-Verlag Berlin Heidelberg (2014).
     
  • Bog, A., Sachs, K., Plattner, H.: Interactive Performance Monitoring of a Composite OLTP & OLAP Workload. Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data. bll. 645-648 (2012).
     
  • Bog, A., Sachs, K., Zeier, A.: Benchmarking Database Design for Mixed OLTP and OLAP Workloads. Proceeding of the second joint WOSP/SIPEW international conference on Performance engineering (2011).
     
  • Bog, A., Sachs, K., Zeier, A., Plattner, H.: Normalization in a Mixed OLTP and OLAP Workload Scenario. Third TPC Technology Conference on Performance Evaluation & Benchmarking (TPC TC), Collocated with VLDB2011, Aug 29 - Sep 3, Seattle, WA (2011).
     
  • Bog, A., Plattner, H., Zeier, A.: A mixed transaction processing and operational reporting benchmark. Information Systems Frontiers, Springer, pp. 1-15. (2010).
     
  • Bog, A., Panchenko, O., Spichale, K., Zeier, A.: Automatic Identification of Cohesive Structures within Modularity Reengineering. International Journal On Advances in Software, vol 3 nr 1&2. (2010).
     
  • Bog, A., Uflacker, M., Zeier, A., Domschke, M.: Managing Globally Distributed Engineering Teams: A Case Study on Virtual Industrial Engineering. 16th International Conference on Industrial Engineering and Engineering Management (IE&EM), Beijing, China (2009).
     
  • Müller, J., Borovskiy, V., Panchenko, O., Bog, A., Zeier, A.: NFC at the Workplace - Simplify Enterprise Work Flows with NFC. Proceedings of 16th International Conference on Industrial Engineering and Engineering Management (IE&EM), Beijing, China (2009).
     
  • Domschke, M., Bog, A., Zeier, A.: Teaching Design Thinking to Software Engineers: Two Future-Oriented Curriculum Case Studies. 26th ICSID World Design Congress, Design Education Conference, Singapore (2009).
     
  • Bog, A., Domschke, M., Müller, J., Zeier, A.: A Framework for Simulating Combined OLTP and OLAP Workloads. 16th International Conference on Industrial Engineering and Engineering Management (IE&EM), Beijing, China (2009).
     
  • Spichale, K., Panchenko, O., Bog, A., Zeier, A.: Preserving Cohesive Structures for Tool-based Modularity Re-engineering. Proceedings of the Fourth International Conference on Software Engineering Advances, ICSEA 2009, Porto, Portugal (2009).
     
  • 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).
     
  • 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).
     
  • 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).
     
  • 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).
     
  • Bog, A., Puhlmann, F., Weske, M.: The !PiVizTool: Simulating Choreographies with Dynamic Binding. BPM Conference 2007 Demonstration Program, CEUR Workshop Proceedings Vol. 272, Brisbane, Australia (2007).
     
  • Kuropka, D., Bog, A., Weske, M.: Semantic Enterprise Services Platform: Motivation, Potential, Functionality and Application Scenarios. Proceedings of the 10th IEEE International Enterprise Distributed Object Computing Conference (EDOC'06) - Volume 00 EDOC '06, Hong Kong, China (2006).
     
  • Bog, A., Puhlmann, F.: A Tool for the Simulation of Pi-Calculus Systems. Open.BPM 2006: Geschä,ftsprozessmanagement mit Open Source-Technologien, Hamburg, Germany (2006).