Database trace debugger
US11080166B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | May 31, 2018 |
| Grant date | Aug 3, 2021 |
| Priority date | — |
| Expiry date | May 31, 2038 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/284
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.