DATABASE DIAGNOSTICS INTERFACE SYSTEM

• US 20150019497A1
• Filed: 07/10/2013
• Published: 01/15/2015
• 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
• Granted Patent: US 9,547,675 B2
• Time in Patent Office: Days
• US Class Current: 707/687
• 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;

output for display a graphical user interface, wherein;

the graphical user interface permits a selection of a script, the script to be executed on a 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;

define a plug-in structure, wherein the plug-in structure comprises the script and the one or more parameters, the plug-in structure further defines the condition which triggers execution of the script;

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 selection of a script comprises selecting a predefined library script from a list of predefined scripts.

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

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

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

7. A method for defining a database system diagnostic tool, the method comprising:

presenting, by a computer system, a first graphical user interface that displays options for selecting a script;

selecting, using the first graphical user interface, the script, the script to be executed on a target database system on occurrence of a condition;

presenting, by the computer system, a second graphical user interface that displays options for defining a parameter;

defining, using the second graphical user interface, a reporting parameter, the reporting parameter describes a reporting function of the script wherein the reporting function returns data related to the target database system;

generating a plug-in structure, wherein the plug-in structure encompasses the script and the reporting parameter, the plug-in further defines the condition which triggers the execution of the script;

presenting, by the computer system, a third graphical user interface that displays options for deploying the plug-in structure to a target database system;

deploying, using the third graphical user interface, the plug-in structure to the target database system; and

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.

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

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

10. The method of claim 7, wherein the selecting of the script comprises selecting a predefined library script from a list of predefined scripts.

11. The method of claim 7, wherein the condition is a threshold value.

12. The method of claim 7, wherein the first graphical user interface, the second graphical user interface, and the third graphical user interface are the same graphical user interface.

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

14. A computer program product residing on a non-transitory processor-readable medium and comprising processor readable instructions configured to cause one or more processors to:

cause a graphical user interface to be presented that displays options for selecting a script;

accept a selection, using the graphical user interface, of the script, the script to be executed on a target database system on occurrence of a condition;

cause the graphical user interface to display options for defining a parameter;

accept a selection, using the graphical user interface, of a reporting parameter, the reporting parameter describes a reporting function of the script wherein the reporting function returns data related to the target database system;

generate a plug-in structure, wherein the plug-in structure encompasses the script and the reporting parameter, the plug-in further defines the condition which triggers the execution of the script;

cause the graphical user interface to display options for deploying the plug-in structure to the target database system;

deploy the plug-in structure to the target database system; and

execute 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.

15. The computer program of claim 14, further comprising instructions configured to cause 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.

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

17. The computer program of claim 14, wherein the selection of the script comprises selecting a predefined library script from a list of predefined scripts.

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

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

20. The computer program of claim 14, wherein the instructions that cause one or more processors to generate a plug-in structure comprises instructions that generate a machine executable module that includes the script.