Converting Traces of In-Memory Database Systems to OPEN.XTRACE on the Example of SAP HANA

Abstract

The shift of data-intensive application logic to inmemory Database Management Systems increases their importance for the overall performance of the software system. The performance of a processed query on a Database Management System is influenced by the utilized query execution plan, while traces capture the runtime behavior of the processed execution plan. However, the use of proprietary trace formats limits the usability within Application Performance Management tools and Software Performance Engineering approaches. OPEN.XTRACE is an open format to exchange execution traces, but its current data model does not support the integration of internal Database Management System operations. In this paper, we propose a modification to OPEN.XTRACE that enables a common representation of a query execution trace. In addition, we convert traces of the state-of-the-art in-memory Database Management System SAP HANA into this format.