Prof. Dr. h.c. Hasso Plattner

Jan Kossmann, M.Sc.

Research Assistant, PhD Candidate

  Phone: +49 (331) 5509-1323
  Fax: +49 (331) 5509-579
  Email: jan.kossmann(at)hpi.de
  Room: V-2.02 (Campus II)


Paving the Way for Self-Managing Database Systems

The performance of a database system depends on its configuration. Modern database systems offer many inter-dependent configuration options to allow the processing of variable workloads from different domains and running on heterogeneous hardware. The amount of possible configurations increases exponentially with the available options. Thus, the - already expensive - configuration process surpasses the capabilities of human database administrators. To tackle this issue, self-managing database systems utilize workload-driven optimization and machine learning techniques to configure database systems.

We focus our work on three specific self-managing database challenges: (i) system integration, (ii) index selection, and (iii) cost estimation. (i) System integration: DBMSs were not designed with self-managing capabilities in mind. We propose a generalized framework that provides facilities to enable self-managing DBMS by providing components for workload monitoring, forecasting, and tuning. (ii) Index selection: Diverse and volatile workloads from different applications complicate the selection of performance-enhancing indexes. We developed an efficient and scalable index selection approach that accounts for index interaction and reconfiguration costs while outperforming the runtime of state-of-the-art algorithms. (iii) Cost estimation: knowledge of query costs is crucial to determine efficient query execution plans. Self-managing systems must assess and quantify the cost impact of options available to them to be able to select the most beneficial one. We generate cost estimations with high accuracy by training estimation models continuously on actual runtime observations.

Our contributions pave the way for self-managing database systems by providing solutions for core challenges in this field. The aforementioned techniques are implemented in the research database system Hyrise.



  • Magic mirror in my hand, ... - Download
    Kossmann, J., Halfpap, S., Jankrift, M., Schlosser, R.: Magic mirror in my hand, which is the best in the land? An Experimental Evaluation of Index Selection Algorithms.Proceedings of the VLDB Endowment. pp. 2382-2395 (2020).
  • Kossmann, J., Schlosser, R.: Self-driving database systems: a conceptual approach.Distributed and Parallel Databases.38,795-817 (2020).


  • A Framework for Self-Mana... - Download
    Kossmann, J., Schlosser, R.: A Framework for Self-Managing Database Systems.2019 IEEE 35th International Conference on Data Engineering Workshops (ICDEW). pp. 100-106 (2019).
  • Efficient Scalable Multi-... - Download
    Schlosser, R., Kossmann, J., Boissier, M.: Efficient Scalable Multi-Attribute Index Selection Using Recursive Strategies.IEEE 35th International Conference on Data Engineering (ICDE 2019). pp. 1238-1249. IEEE (2019).
  • Hyrise Re-engineered: An ... - Download
    Dreseler, M., Kossmann, J., Boissier, M., Klauck, S., Uflacker, M., Plattner, H.: Hyrise Re-engineered: An Extensible Database System for Research in Relational In-Memory Data Management.22nd International Conference on Extending Database Technology (EDBT). pp. 313-324 (2019).


  • Kossmann, J.: Self-Driving: From General Purpose to Specialized DBMSs.Proceedings of the VLDB 2018 PhD Workshop co-located with the 44th International Conference on Very Large Databases (VLDB 2018), Rio de Janeiro, Brasil, Aug 27-31, 2018 (2018).
  • Fused Table Scans: Combin... - Download
    Dreseler, M., Kossmann, J., Frohnhofen, J., Uflacker, M., Plattner, H.: Fused Table Scans: Combining AVX-512 and JIT to Double the Performance of Multi-Predicate Scans.Joint Workshop of HardBD (International Workshop on Big Data Management on Emerging Hardware) and Active (Workshop on Data Management on Virtualized Active Systems), in conjunction with ICDE (2018).
  • Visual Evaluation of SQL ... - Download
    Kossmann, J., Dreseler, M., Gasda, T., Uflacker, M., Plattner, H.: Visual Evaluation of SQL Plan Cache Algorithms.Australasian Database Conference (ADC) (2018).
  • Adaptive Access Path Sele... - Download
    Dreseler, M., Gasda, T., Kossmann, J., Uflacker, M., Plattner, H.: Adaptive Access Path Selection for Hardware-Accelerated DRAM Loads.Australasian Database Conference (ADC) (2018).


  • Mueller, S., Fritzsche, M., Kossmann, J., Schneider, M., Striebel, J., Baudisch, P.: Scotty: Relocating Physical Objects Across Distances Using Destructive Scanning, Encryption, and 3D Printing.TEI '15 Proceedings of the Ninth International Conference on Tangible, Embedded, and Embodied Interaction. pp. 233-240 (2015).
  • Schwalb, D., Kossmann, J., Faust, M., Klauck, S., Uflacker, M., Plattner, H.: Hyrise-R: Scale-out and Hot-Standby through Lazy Master Replication for Enterprise Applications.Proceedings of the 3rd VLDB Workshop on In-Memory Data Mangement and Analytics (IMDM), in conjunction with VLDB 2015 Kohala Coast, Hawaii (2015).

Selected Talks & Presentations

  • "Magic mirror in my hand, which is the best in the land? An Experimental Evaluation of Index Selection Algorithms", VLDB 2020, September, Online 
  • "Learned Operator Cost Models", AIDB @ VLDB 2019, August 2019, Los Angeles, USA
  • "Efficient Scalable Multi-Attribute Index Selection Using Recursive Strategies", ICDE 2019, April 2019, Macao SAR, China
  • "Self-Driving: From General Purpose to Specialized DBMSs", VLDB 2018, August 2018, Rio de Janeiro, Brazil

Supervised Master's Theses


  • Reducing the overhead of chunked storage concepts


  • Automatic Clustering in Hyrise
  • Utilizing Segment and Chunk Access Metrics for Data Placement
  • Evaluation of Index Selection Algorithms
  • Learned Cost Models for Query Optimization
  • Cardinality Estimation and Access Avoidance in Horizontally Partitioned IMDBs
  • Adaptive Query Optimization for In-Memory Databases
  • Probabilistic Data Structures for In-Memory Databases
  • Just-in-Time Compilation for Efficient Query Plan Execution of OLAP Workloads in Column Stores
  • Heterogenous Index Distribution in Multi-Node In-Memory Database Systems
  • Building an SQL Interface and Leveraging Query Plan Caching for a Relational Database