Reducing downtime during upgrades of interrelated components in a database system

Patent metadata

Field	Value
Publication number	US-2016357549-A1
Application number	US-201615236923-A
Country	US
Kind code	A1
Filing date	Aug 15, 2016
Priority date	Sep 28, 2012
Publication date	Dec 8, 2016
Grant date	—

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 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; 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 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 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 , 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:
after the at least one first patch and the at least one second patch have been applied, shutting down the initial run edition associated with the at least one running software application; and starting the patch edition corresponding to the at least one running software application after shutting down the initial run edition such that the 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 instances of a running file system for the at least one running software application; identifying a running file system format for the one or more instances of the running file system; and identifying running file system contents for the one or more 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 instances of the running file system with an initial run file system edition; and amalgamating the initial run file system edition 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:
creating a file system patch edition for the one or more instances of the running file system; and synchronizing the file system patch edition with the initial run file system edition.

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 a patch or upgrade session for the one or more 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 patch edition.

13 . The computer program product of claim 12 , 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:
determining one or more cutover actions for the cutover pe

Assignees

• Oracle Int Corp

Inventors

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

Classifications

• G06F16/245

  Query processing · CPC title

• G06F11/2058

  using more than 2 mirrored copies · CPC title

• G06F16/2393

  Updating materialised views · CPC title

• G06F16/2365

  Ensuring data consistency and integrity · CPC title

• G06F16/2358

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