Database diagnostics interface system

摘要

A database diagnostics system with an interface system that may be used to define, monitor, and deploy database diagnostics tools is presented. The interface system presents a user with a user interface for defining the parameters, behaviors, and schedules of database diagnostic tools. The diagnostic tools execute on a target database recording database parameters and state information. The interface system may present the user with a graphical user interface for assembling diagnostic tools at least partially from a predefined set of reusable modules and scripts.

主权项

1. A database diagnostics system comprising:
one or more processors; and a memory communicatively coupled with and readable by the one or more processors and having stored therein instructions which, when executed by the one or more processors, cause the one or more processors to:
identify a target database system in a first location that is remote from the one or more processors and a list of predefined scripts for execution on the target database system, the predefined scripts at a second location that is remote from the target database system;based at least in part on the identifying, generate a graphical user interface for display with an interface device at the second location or a third location that is remote from the target database system, wherein:
the graphical user interface permits a selection of a script from the list of the predefined scripts, the script corresponding to a predefined library script, the script to be executed on the target database system on occurrence of a condition; andthe graphical user interface permits one or more parameters to be set, the one or more parameters define a reporting function of the script wherein the reporting function returns data related to the target database system;based at least in part on user selections made via the graphical user interface:
define a plug-in structure that encapsulates modules of a plug-in corresponding at least in part to the script and a configuration;define the configuration, the defining the configuration comprising defining:
the one or more parameters; anda mapping of one or more script functions to database system functions of the target database system; andthe condition which triggers execution of the script after the script is transmitted to the target database system;assemble the script and the configuration into the plug-in to perform a diagnostic task based at least in part on the plug-in structure; andcause transmission of the plug-in via a network to the target database system to cause the plug-in to be executed on the target database system, wherein during execution, and on occurrence of the condition, the plug-in returns data related to the target database system according to the one or more parameters.