SAP SE
Database trace debugger

Abstract:

This disclosure describes a trace debugger (TDB) that is used for database workload replay and database debugging. The TDB maintains consistency through synchronization of the state between the database and a corresponding database trace replay. The TDB can provide a sliding window environment for code block execution and global context sharing. The TDB can be used to interactively analyze and troubleshoot various types of database problems by debugging the database itself, query code (e.g., SQL), performance, end-to-end execution, and plan traces, which can be recorded using scripts. In some implementations, the TDB also provides reverse debugging for historical database state analysis, and/or incremental debugging for dynamic editing and debugging within a session without the need to exit the debugger and perform a full rebuild of the code.