Database diagnostics interface system

Patent metadata

Field	Value
Publication number	US-9547675-B2
Application number	US-201313938418-A
Country	US
Kind code	B2
Filing date	Jul 10, 2013
Priority date	Jul 10, 2013
Publication date	Jan 17, 2017
Grant date	Jan 17, 2017

Abstract

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.

First claim

What is claimed is:

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; and
the 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; and
a mapping of one or more script functions to database system functions of the target database system; and
the 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; and
cause 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.

2. The database diagnostics system of claim 1 , wherein the condition is a periodic timer, and the condition triggers the execution of the script on a periodic schedule.

3. The database diagnostics system of claim 1 , wherein the condition is a threshold value for a parameter of the target database system.

4. The database diagnostics system of claim 3 , wherein the threshold value may be dynamically changed during execution of the plug-in when the threshold value is exceeded.

5. The database diagnostics system of claim 1 , wherein the defining the plug-in structure comprises generating a machine-executable module that includes script functionality of the script.

6. A method for defining a database system diagnostic tool, the method comprising:
identifying, by a computer system, a target database system in a first location that is remote from the computer system 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:
generating, by the computer system, a first 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 first graphical user interface permits selecting 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; and
generating, by the computer system, a second graphical user interface that permits defining a reporting parameter, the reporting parameter describing 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 one or both of the first graphical user interface and the second graphical user interface:
generating a plug-in structure, wherein the plug-in structure encompasses the script and a configuration;
define the configuration, the defining the configuration comprising defining:
the reporting parameter;
a mapping of one or more script functions to database system functions of the target database system; and
the condition which triggers the execution of the script after the script is transmitted to the target database system;

generating, by the computer system, a third graphical user interface that facilitates options for deploying the plug-in structure to the target database system; and
assembling, by the computer system, the script and the configuration into a plug-in to perform a diagnostic task based at least in part on the plug-in structure; and
causing, by the computer system, transmission of the plug-in via a network to the target database system to cause executing the plug-in on the target database system, wherein during execution and on occurrence of the condition, the plug-in returns a data related to the target database system according to the reporting parameter.

7. The method of claim 6 , further comprising generating, by the computer system, a fourth graphical user interface that displays the data related to the target database system according to the reporting parameter.

8. The method of claim 6 , wherein the condition is a periodic timer and the condition triggers the execution of the script on a periodic schedule.

9. The method of claim 6 , wherein the condition is a threshold value.

10. The method of claim 6 , wherein the generating the plug-in structure comprises generating a machine-executable module that includes the script.

11. A computer program product residing on a non-transitory, processor-readable medium and comprising processor-readable instructions, which, when executed by 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 selecting 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; and
the graphical user interface provides options for defining;
a reporting parameter, the reporting parameter describing 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:
generate a plug-in structure, wherein the plug-in structure encompasses the script and a configuration;
define the configuration, the defining the configuration comprising defining:
the reporting parameter;
a mapping of one or more script functions to database system functions of the target database system; and
a condition which triggers execution of the script after the script is transmitted to the target database system;

assembling the script and the configuration into a plug-in to perform a diagnostic task based at least in

Assignees

• Oracle Int Corp

Inventors

• Bostock Clive

Classifications

• G06F11/0727

  in a storage system, e.g. in a DASD or network based storage system (drivers for digital recording or reproducing units G06F3/06; circuits for error detection or correction within digital recording or reproducing units G11B20/18; for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS], H04L67/1097) · CPC title

• G06F11/3003

  Monitoring arrangements specially adapted to the computing system or computing system component being monitored · CPC title

• G06F2201/80

  Database-specific techniques · CPC title

• G06F11/3089

  Monitoring arrangements determined by the means or processing involved in sensing the monitored data, e.g. interfaces, connectors, sensors, probes, agents (software debugging using additional hardware using a specific debug interface G06F11/3656; performance evaluation by tracing or monitoring G06F11/3466) · CPC title

• G06F11/079

  Root cause analysis, i.e. error or fault diagnosis (in a hardware test environment G06F11/22; in a software test environment G06F11/36) · CPC title