Diagnostic test sets

• US 7,681,079 B2
• Filed: 02/26/2007
• Issued: 03/16/2010
• Est. Priority Date: 02/26/2007
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Casalgrandi, Michele, Xu, Minyi
• Primary Examiner(s): McCarthy; Christopher S
• Application Number:
  US11/710,703
• Publication Number:
  US 20080209267A1
• Time in Patent Office: 1,114 Days
• Field of Search: None
• US Class Current: 714/25
• CPC Class Codes: G06F 11/2294 by remote test
• CPC Class Codes: G06F 11/3688 for test execution, e.g. scheduling of test suites

Abstract

Systems, methodologies, media, and other embodiments associated with metadata driven diagnostic test execution are described. One exemplary system embodiment includes a diagnostic test set repository where pre-defined and/or user-defined XML files that store the metadata for driving the diagnostic test execution can be stored. The example system may also include a first logic to prepare the XML file to control a diagnostic session and a second logic to control the diagnostic session based on the prepared XML file.

Claims

1. A system, comprising:

a data store to store a diagnostic test set, where the diagnostic test set comprises metadata that describes a diagnostic test to be performed, where the diagnostic test is configurable to control analysis of a user selectable set of features for a user selectable set of applications resident on a user-selectable set of computers, and where the set of applications interact with a user selectable set of databases resident on a second user selectable set of computers;

a first logic to prepare the diagnostic test set to control a diagnostic session; and

a second logic to cause the diagnostic session to execute, the diagnostic session to be controlled, at least in part, by the diagnostic test set prepared by the first logic.

2. The system of claim 1 including a web-based user interface to locate a diagnostic test set, to configure a diagnostic test set, to select a diagnostic test set to control a diagnostic session, and to create a user-defined diagnostic test set.

3. The system of claim 2, the web-based user interface being a Java Server Pages (JSP) application.

4. The system of claim 2, where the web-based user interface is to locate a diagnostic test set on the Internet.

5. The system of claim 1, where to prepare a diagnostic test set to control a diagnostic session includes to select a feature to be tested, to select an application to be tested, to select a database to be tested, to select an interaction between an application and a database to be tested, and to select a target machine to be tested.

6. The system of claim 1 a diagnostic test set being an XML (extensible markup language) file that provides a description of one or more diagnostic tests configured to analyze one or more of, a database application, a database, and a database application interaction with a database.

7. The system of claim 6, the description to include one or more of, a diagnostic test name, a diagnostic test location, and a set of inputs for the diagnostic test.

8. The system of claim 1 where a diagnostic test is receivable from one or more of, a database provider, a database application provider, a quality assurance entity, a support entity, and a user.

9. The system of claim 1 a diagnostic test being one or more of, a PL/SQL (procedural language/structured query language) executable, a JSP executable, a PerI executable, a shell script executable, and a Java executable.

10. The system of claim 1, the second logic residing on the system to be tested.

11. The system of claim 1, the second logic not residing on the system to be tested.

12. The system of claim 1, where to prepare the diagnostic test set to control a diagnostic session includes selectively acquiring an input available in the test set and selectively acquiring a missing input value.

13. The system of claim 12, the missing input value to be acquired from one or more of, a user, and a default source.

14. A system, comprising:

a data store to store a diagnostic test set, the diagnostic test set comprising metadata that describes a diagnostic test to be performed;

a first logic to prepare the diagnostic test set to control a diagnostic session; and

a second logic to cause the diagnostic session to execute, the diagnostic session to be controlled, at least in part, by the diagnostic test set prepared by the first logic;

a JSP web-based user interface to locate the diagnostic test set on one of, the Internet, an intranet, and a file system, to configure the diagnostic test set, to select a diagnostic test set to control the diagnostic session, and to create a user-defined diagnostic test set, the diagnostic test set being an XML file that provides a description of one or more diagnostic tests configured to analyze one or more of, a database application, a database, and a database application interaction with a database, the description to include one or more of, a diagnostic test name, a diagnostic test location, and a set of inputs for the diagnostic test;

where to configure the diagnostic test set includes selecting a feature to be tested, selecting an application to be tested, selecting a database to be tested, selecting an interaction between an application and a database to be tested, and selecting a target machine to be tested,

the diagnostic test being one or more of, a PL/SQL executable, a JSP executable, a PerI executable, a shell script executable, and a Java executable,

the diagnostic test set being configurable to control analysis of a user selectable set of features for a user selectable set of applications resident on a user-selectable set of computers, where the set of applications interact with a user selectable set of databases resident on a second user selectable set of computers; and

where to prepare the diagnostic test set to control a diagnostic session comprises selectively acquiring an input available in the test set and selectively acquiring a missing input value from one or more of, a user, and a default source.

15. A computer-readable medium storing processor executable instructions operable to perform a method, the method comprising:

identifying a diagnostic to be performed as part of a session to analyze one or more of an application, a database, and an interaction between the application and the database, where identifying the diagnostic includes receiving an input from a web-based user interface;

configuring an XML file to control the session, where the XML file is to store metadata to control metadata driven diagnostic test execution, where configuring the XML file includes bundling a set of diagnostics to be performed as part of the session, ordering the set of diagnostics, and resolving inputs for the set of diagnostics, and where the metadata is to describe one or more of, a diagnostic name, a diagnostic location, a diagnostic input, and a diagnostic output;

controlling a diagnostic logic to perform the session in accordance with the XML file; and

providing a first signal concerning the outcome of the session.

16. The computer-readable medium of claim 15, where configuring the XML file includes determining a feature to be diagnosed and determining a set of applications for which the feature is to be diagnosed.

17. The computer-readable medium of claim 15, where controlling the diagnostic logic includes providing a second signal that is generated in response to processing the XML file.

18. The computer-readable medium of claim 15, where providing the first signal concerning the outcome of the session includes providing one or more of, an HTML (hypertext markup language) file, an XML file, and a compressed collection of files.

19. A system, comprising:

a data store to store a diagnostic test set, where the diagnostic test set comprises metadata that describes a diagnostic test to be performed, where the diagnostic test is configurable to control analysis of a user selectable set of features for a user selectable set of applications resident on a user-selectable set of computers, and where the set of applications interact with a user selectable set of databases resident on a second user selectable set of computers;

means for preparing the diagnostic test set to control a diagnostic session; and

means for causing the diagnostic session to execute, the diagnostic session to be controlled, at least in part, by the diagnostic test set prepared by the means for preparing.

20. The system of claim 19, comprising:

means for interfacing to locate the diagnostic test set;

means for configuring the diagnostic test set;

means for selecting the diagnostic test set to control a diagnostic session; and

means for creating a user-defined diagnostic test set.

21. A method, comprising:

identifying a diagnostic to be performed as part of a session to analyze one or more of an application, a database, and an interaction between the application and the database, where identifying the diagnostic includes receiving an input from a web-based user interface;

configuring an XML file to control the session, where the XML file is to store metadata to control metadata driven diagnostic test execution, where configuring the XML file includes bundling a set of diagnostics to be performed as part of the session, ordering the set of diagnostics, and resolving inputs for the set of diagnostics, and where the metadata is to describe one or more of, a diagnostic name, a diagnostic location, a diagnostic input, and a diagnostic output;

performing the session in accordance with the XML file; and

providing a first signal concerning the outcome of the session.

22. The method of claim 21, where configuring the XML file comprises determining a feature to be diagnosed and determining a set of applications for which the feature is to be diagnosed.

23. The method of claim 21, where performing the session in accordance with the XML file comprises providing a second signal that is generated in response to processing the XML file.

24. The method of claim 21, where providing the first signal concerning the outcome of the session comprises providing one or more of, an HTML (hypertext markup language) file, an XML file, and a compressed collection of files.