UPGRADE TRACKING SYSTEM

• US 20090113411A1
• Filed: 06/27/2008
• Published: 04/30/2009
• Est. Priority Date: 10/24/2007
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Halliday, Matthew
• Granted Patent: US 8,752,040 B2
• Time in Patent Office: Days
• US Class Current: 717/169
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409

Abstract

An upgrade tracking system for tracking aspects of an application upgrade. In various embodiments, the update tracking system includes a statistics collection component configured to collect statistics related an execution of the application upgrade, where the application upgrade includes a plurality of data upgrade files, and where the plurality of data upgrade files are organized into a plurality of functional upgrade groups. The system further includes a timing component configured to report execution timings related to the execution of the application upgrade, and a status component configured to track statuses related to the execution of the application upgrade.

Claims

1. An upgrade tracking system comprising:

a statistics collection component configured to collect statistics related to an execution of an application upgrade, wherein the application upgrade includes a plurality of data upgrade files, and wherein the plurality of data upgrade files are organized into a plurality of functional upgrade groups;

a timing component configured to report execution timings related to the execution of the application upgrade; and

a status component configured to track statuses related to the execution of the application upgrade.

2. The system of claim 1, wherein reporting execution timings related to the execution of the application upgrade comprises reporting execution timings of individual data upgrade files in the plurality of data upgrade files.

3. The system of claim 1, wherein reporting execution timings related to the execution of the application upgrade comprises reporting aggregate execution timings of data upgrade files per functional upgrade group.

4. The system of claim 1, wherein reporting execution timings related to the execution of the application upgrade comprises reporting aggregate execution timings of data upgrade files per product family.

5. The system of claim 1, wherein the timing component is further configured to identify a critical path of data upgrade files for the execution of the application upgrade.

6. The system of claim 1, wherein tracking statuses related to the execution of the application upgrade comprises:

automatically determining a responsible party for each data upgrade file or each functional upgrade group; and

receiving, from the responsible party, one or more status updates related to the data upgrade file or the functional upgrade group.

7. The system of claim 6, wherein the one or mores status updates include an update of a success status indicating whether the data upgrade file or functional upgrade group was executed successfully during the execution of the application upgrade.

8. The system of claim 7, wherein the success status is represented by a percentage value.

9. The system of claim 6, wherein the one or more status updates include an update of a completion status indicating whether the responsible party has completed validation of the data upgrade file or functional upgrade group.

10. The system of claim 6, wherein the one or more status updates include an update of a performance status indicating whether the responsible party has completed a performance review of the data upgrade file or functional upgrade group.

11. The system of claim 6, wherein the status component is further configured to automatically log a bug against the responsible party after the execution of the application upgrade, thereby reminding the responsible party to provide the one or more status updates.

12. The system of claim 1 further comprising a bug integration component configured to report bugs logged against one or more data upgrade files in the plurality of data upgrade files as a result of the execution of the application upgrade.

13. The system of claim 12, wherein reporting bugs logged against one or more data upgrade files in the plurality of data upgrade files as a result of the execution of the application upgrade comprises:

accessing a bug database;

identifying one or more bugs in the bug database that include a predefined template; and

collecting bug information from each bug in the one or more bugs by parsing the predefined template.

14. The system of claim 13, wherein the bug information includes a reference to a data upgrade file associated with the bug, a version of the data upgrade file, and an issue type.

15. The system of claim 1 further comprising a file history component configured to report upgrade history information for each data upgrade file in the plurality of data upgrade files.

16. The system of claim 15, wherein the upgrade history information includes prior executions of the data upgrade file and an execution timing for each prior execution.

17. A machine-readable medium for a computer system, the machine-readable medium having stored thereon a series of instructions which, when executed by a processing component, cause the processing component to:

collect statistics related to an execution of an application upgrade, wherein the application upgrade includes a plurality of data upgrade files, and wherein the plurality of data upgrade files are organized into a plurality of functional upgrade groups;

report execution timings related to the execution of the application upgrade; and

track statuses related to the execution of the application upgrade.

18. The machine-readable medium of claim 17, wherein the series of instructions further cause the processing component to report bugs logged against one or more data upgrade files in the plurality of data upgrade files as a result of the execution of the application upgrade.

19. The machine-readable medium of claim 17, wherein the series of instructions further cause the processing component to report upgrade history information for each data upgrade file in the plurality of data upgrade files.