Reducing downtime during upgrades of interrelated components in a database system

Patent metadata

Field	Value
Publication number	US-10013248-B2
Application number	US-201615236923-A
Country	US
Kind code	B2
Filing date	Aug 15, 2016
Priority date	Sep 28, 2012
Publication date	Jul 3, 2018
Grant date	Jul 3, 2018

Abstract

A method, system, and computer program product for reducing downtime during upgrades of interrelated components in a computing environment. The method commences while at least one running software application is executing within the computing environment by loading a plurality of database objects from an initial run edition into a patch edition. The database objects comprise at least one software application code module, at least one relational database table, and at least one file system. The method continues by applying at least one patch to the software application code module(s) corresponding to the running software application(s) to create patched software application(s), then applying patches to the relational database table to create a patched relational database table, and further applying a patch to the file system to create a patched file system. When the subject patches have been applied, the method stops the running software application(s) and starts the patched software application(s).

First claim

What is claimed is:

1. A computer program product embodied in a non-transitory computer readable medium, the computer readable medium having stored thereon a sequence of instructions which, when executed by a processor, causes the processor to execute a set of acts to implement reducing downtime during upgrades of interrelated components in a computing environment, the set of acts comprising:
identifying a plurality of components from an initial run edition associated with at least one running software application, the plurality of components comprising at least an initial run file system edition, which comprises at least one instance of a running file system, and a portion of a database table;
generating a patch edition corresponding to the at least one running software application at least by:
loading the plurality of components into the patch edition and by applying a plurality of modifications to at least one first component corresponding to the initial run file system edition and to at least one second component corresponding to the portion of the database table in the patch edition associated with the at least one running software application;
identifying at least one instance of a running file system, contents for at least one instance, and at least one file system format for the at least one running software application, the contents including at least one application definition and at least one application metadata that control how the at least one running software application operates;
associating the at least one instance with the initial run file system edition that is further amalgamated into the initial run edition;
creating, for the at least one instance, a file system patch edition that is further synchronized with the initial run file system edition; and
creating at least one patch or upgrade session for the at least one instance of the running file system;
after the plurality of modifications have been applied, shutting down the initial run edition associated with the at least one running software application; and
starting the patch edition after shutting down the initial run edition such that one or more users accessing the initial run edition are placed offline and subsequently return online to access the patch edition associated with the at least one running software application.

2. The computer program product of claim 1 , the sequence of instructions further comprising instructions which, when executed by the processor, causes the processor to execute the set of acts, the set of acts further comprising:
identifying the initial run edition associated with the at least one running software application; and
identifying an interrelation between the at least one running software application and at least the database table using at least one or more synonyms indicative of the interrelation.

3. The computer program product of claim 2 , the sequence of instructions further comprising instructions which, when executed by the processor, causes the processor to execute the set of acts, the set of acts further comprising:
identifying the plurality of components from the initial run edition based in part or in whole upon the interrelation, the plurality of components comprising at least one software application code module for the at least one running software application, at least a portion of the database table, and at least one file system; and
loading the plurality of components into the patch edition.

4. The computer program product of claim 3 , the sequence of instructions further comprising instructions which, when executed by the processor, causes the processor to execute the set of acts, the set of acts further comprising:
applying one or more first modifications of the plurality of modifications comprising at least one first patch to the at least one software application code module in the patch edition corresponding to the at least one running software application to create a patched software application; and
applying one or more first modifications of the plurality of modifications comprising at least one second patch to the at least one relational database table in the patch edition to create a patched relational database table.

5. The computer program product of claim 4 , wherein
one or more users accessing the initial run edition associated with the at least one running software application are placed offline during a cutover period and return online after conclusion of the cutover period.

6. The computer program product of claim 5 , the sequence of instructions further comprising instructions which, when executed by the processor, causes the processor to execute the set of acts, the set of acts further comprising:
identifying one or more other instances the running file system for the at least one running software application; and
identifying running file system contents for the one or more other instances of the running file system, the running file system contents including an application definition and application metadata that control how the at least one running software application operates.

7. The computer program product of claim 6 , the sequence of instructions further comprising instructions which, when executed by the processor, causes the processor to execute the set of acts, the set of acts further comprising:
associating the one or more other instances of the running file system with the initial run file system edition; and
amalgamating the initial run file system edition that is associated with the one or more other instances into the initial run edition that is associated with the at least one running software application.

8. The computer program product of claim 7 , the sequence of instructions further comprising instructions which, when executed by the processor, causes the processor to execute the set of acts, the set of acts further comprising:
updating the file system patch edition for the one or more other instances of the running file system.

9. The computer program product of claim 8 , the sequence of instructions further comprising instructions which, when executed by the processor, causes the processor to execute the set of acts, the set of acts further comprising:
creating one or more additional patch or upgrade session for the one or more other instances of the running file system.

10. The computer program product of claim 9 , the sequence of instructions further comprising instructions which, when executed by the processor, causes the processor to execute the set of acts, the set of acts further comprising:
validating that the one or more instances of the running file system are ready to start the patch or upgrade session at least by cleaning up one or more previous patch sessions and by checking for availability of one or more services needed for the patch or upgrade session; and
determining a patch file system format and patch file system contents for the file system patch edition.

11. The computer program product of claim 10 , the sequence of instructions further comprising instructions which, when executed by the processor, causes the processor to execute the set of acts, the set of acts further comprising:
preparing the file system patch edition for the one or more instances of the running file system.

12. The computer program product of claim 11 , the sequence of instructions further comprising instructions which, when executed by the processor, causes the processor to execute the set of acts, the set of acts further comprising:
modifying the running file system into a patch file system at least by applying the patch system format and the patch file system contents to the file system pa

Assignees

• Oracle Int Corp

Inventors

• Buzsaki George
• Hudson Kevin
• Dujmovic Ivo
• Kadiyala Sandeep
• Palakurthy Venu

Classifications

• G06F16/2365

  Ensuring data consistency and integrity · CPC title

• G06F11/2056

  by mirroring · CPC title

• G06F11/2058

  using more than 2 mirrored copies · CPC title

• G06F16/23

  Updating · CPC title

• G06F16/2358

  Change logging, detection, and notification (replication G06F16/27) · CPC title