Database diagnostics interface system

• US 9,547,675 B2
• Filed: 07/10/2013
• Issued: 01/17/2017
• Est. Priority Date: 07/10/2013
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Bostock, Clive
• Primary Examiner(s): OBERLY, VAN HONG
• Application Number:
  US13/938,418
• Publication Number:
  US 20150019497A1
• Time in Patent Office: 1,287 Days
• Field of Search: 707/764
• US Class Current: 1/1
• CPC Class Codes: G06F 11/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 Class Codes: G06F 11/0748 in a remote unit communicating with a single-box computer node experiencing an error/fault remote testing G06F11/2294
• CPC Class Codes: G06F 11/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 Class Codes: G06F 11/3003 Monitoring arrangements specially adapted to the computing system or computing system component being monitored
• CPC Class Codes: G06F 11/3065 Monitoring arrangements determined by the means or processing involved in reporting the monitored data error or fault reporting or logging G06F11/0766
• CPC Class Codes: G06F 11/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 Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/24565 Triggers; Constraints
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 2201/80 Database-specific techniques

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.

Claims

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 part on the plug-in structure; and

cause transmission of the plug-in via a network to the target database system to cause execution of the plug-in on the target database system, wherein during the execution and on occurrence of the condition, the plug-in returns a data related to the target database system according to the reporting parameter.

12. The computer program product of claim 11, wherein the processor-readable instructions further cause the one or more processors to cause the graphical user interface to display the data related to the target database system according to the reporting parameter.

13. The computer program product of claim 11, wherein the condition is a periodic timer, and the condition triggers the execution of the script on a periodic schedule.

14. The computer program product of claim 11, wherein the condition is a threshold value.

15. The computer program product of claim 14, wherein the threshold value may be dynamically changed during execution of the plug-in when the threshold value is exceeded.

16. The computer program product of claim 11, wherein the processor-readable instructions further cause the one or more processors to generate a machine-executable module that includes the script.