# US 11,907,111 B2 · Database troubleshooting with automated functionality > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 11,907,111 B2 - Document ID: US11907111B2 - Status: Granted - Kind: B2 - Application number: 17/473,869 - Filed: 2021-09-13 - Published: 2023-03-16 - Granted: 2024-02-20 - Earliest claimed: 2021-09-13 - Assignees: Sap SE - Applicants: Sap SE - Inventors: Mingqian Zhong - Web page: https://patentgrep.com/patent/US11907111B2 ## CPC - G06F 11/3452: {Performance evaluation by statistical analysis} - G06F 11/3688: {for test execution, e.g. scheduling of test suites} - G06F 9/451: Execution arrangements for user interfaces - G06F 11/3466: {Performance evaluation by tracing or monitoring} - G06F 16/252: {between a Database Management System and a front-end application} - G06F 11/3409: {for performance assessment} - G06F 11/3414: {Workload generation, e.g. scripts, playback} - G06F 2201/80: Database-specific techniques - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## Abstract Technologies are described for establishing a connection to an IMDB (in-memory database) via a GUI, automatically detecting an IMDB version, and selecting at least one script from a plurality of scripts based on the detected IMDB version. Differences among the plurality of scripts can relate to data parameter differences in different IMDB versions. The selected at least one script to be executed returns data of a type recognized in the detected IMDB version. ## Claims ### Claim 1 A system comprising: at least one data processor; and memory storing instructions which, when executed by the at least one data processor, result in operations comprising: establishing a connection to an IMDB (in-memory database) via a GUI (graphical user interface); automatically detecting an IMDB version; selecting at least one script from a plurality of scripts based on the detected IMDB version, wherein differences among the plurality of scripts relate to data parameter differences in different IMDB versions; and causing the selected at least one script to be executed to return data of a type recognized in the detected IMDB version. ### Claim 2 (depends on 1) The system of claim 1, wherein establishing a connection to the IMDB via the GUI comprises detecting an open GUI session and automatically opening a command editor. ### Claim 3 (depends on 2) The system of claim 2, further comprising causing the selected at least one script to be entered within the command editor. ### Claim 4 (depends on 2) The system of claim 2, further comprising causing the selected at least one script to be executed in the command editor. ### Claim 5 (depends on 4) The system of claim 4, further comprising causing the output of the selected at least one script executed in the command editor to be copied to a clipboard. ### Claim 6 (depends on 1) The system of claim 1, wherein establishing a connection to the IMDB comprises accessing the IMDB via a GUI-specific API. ### Claim 7 (depends on 1) The system of claim 1, further comprising: selecting at least first and second database diagnostic parameters from a plurality of database diagnostic parameters and causing respective first and second database diagnostic scripts to be run in parallel; processing the output of the first and second database diagnostic scripts together; and modifying at least a third database diagnostic script based on the output of the first and second database diagnostic script; executing the modified third database diagnostic script; and generating a report from the modified third database diagnostic script to be displayed via the GUI. ### Claim 8 (depends on 7) The system of claim 7, wherein the first and second database diagnostic parameters relate to different database views. ### Claim 9 (depends on 7) The system of claim 7, wherein the database diagnostic parameters comprise a top SQLs with most elapsed time parameter and a top SQLs with most memory consumption parameter. ### Claim 10 (depends on 9) The system of claim 9, wherein modifying the third database diagnostic script and executing the modified third database diagnostic script comprises determining SQL texts of top SQLs with most elapsed time and top SQLs most memory consumption. ### Claim 11 A method for implementation by one or more data processors forming part of at least one computing device, the method comprising: establishing a connection to an IMDB (in-memory database) via a GUI (graphical user interface); automatically detecting an IMDB version of the IMDB; selecting at least one script from a plurality of scripts based on the detected IMDB version, wherein differences among the plurality of scripts relate to data parameter differences in different IMDB versions; and causing the selected at least one script to be executed to return data of a type recognized in the detected IMDB version. ### Claim 12 (depends on 11) The method of claim 11, wherein establishing a connection to the IMDB via the GUI comprises detecting an open GUI session and automatically opening a command editor. ### Claim 13 (depends on 11) The method of claim 11, further comprising causing the selected at least one script to be entered within the command editor. ### Claim 14 (depends on 12) The method of claim 12, further comprising causing the selected at least one script to be executed in the command editor. ### Claim 15 (depends on 14) The method of claim 14, further comprising causing the output of the selected at least one script executed in the command editor to be copied to a clipboard. ### Claim 16 (depends on 11) The method of claim 11, wherein establishing a connection to the IMDB comprises accessing the IMDB via a GUI-specific API. ### Claim 17 (depends on 11) The method of claim 11, further comprising: selecting at least first and second database diagnostic parameters from a plurality of database diagnostic parameters and causing respective first and second database diagnostic scripts to be run in parallel; processing the output of the first and second database diagnostic scripts together; and modifying at least a third database diagnostic script based on the output of the first and second database diagnostic script; executing the modified third database diagnostic script; and generating a report from the modified third database diagnostic script to be displayed via the GUI. ### Claim 18 A non-transitory computer program product storing instructions which, when executed by at least one data processor forming part of at least one computing device, perform operations comprising: establishing a connection to an IMDB (in-memory database) via a GUI (graphical user interface); automatically detecting an IMDB version of the IMDB; selecting at least one script from a plurality of scripts based on the detected IMDB version, wherein differences among the plurality of scripts relate to data parameter differences in different IMDB versions; and causing the selected at least one script to be executed to return data of a type recognized in the detected IMDB version. ### Claim 19 (depends on 18) The program product according to claim 18, wherein establishing a connection to the IMDB via the GUI comprises detecting an open GUI session and automatically opening a command editor. ### Claim 20 (depends on 18) The program product according to claim 18, wherein the operations further comprise: selecting at least first and second database diagnostic parameters from a plurality of database diagnostic parameters and causing respective first and second database diagnostic scripts to be run in parallel; processing the output of the first and second database diagnostic scripts together; and modifying at least a third database diagnostic script based on the output of the first and second database diagnostic script; executing the modified third database diagnostic script; and generating a report from the modified third database diagnostic script to be displayed via the GUI.