ONLINE UPGRADING OF A DATABASE ENVIRONMENT USING TRANSPARENTLY-PATCHED SEED DATA TABLES
First Claim
1. A computer implemented method for online upgrading of a software application in a database environment using a transparently-patched seed data table, the method comprising:
- copying, while the software application is running, data comprising a seed data table to database table rows temporarily inaccessible by the software application, the copying to create a seed data table copy;
modifying the schema of the seed data table copy by applying at least one patch, the modifying to create a patched seed data table copy;
stopping the software application, then changing the database table rows temporarily inaccessible by the software application to become accessible by the software application; and
restarting the software application to point to the patched seed data table copy.
1 Assignment
0 Petitions
Accused Products
Abstract
A method, system, and computer program product for managing upgrades of database systems using a transparently-patched seed data table. The method commences on a running system by copying (while software applications are running) portions of data comprising a seed data table to database table rows that are temporarily inaccessible by the software applications. The copy operation creates new rows (a seed data table copy) in a database table. The method continues while software applications are running by modifying the seed data table copy (e.g., by applying a patch). For a brief time, the method stops the software applications, then changes the database table rows that were temporarily inaccessible by the software applications to become accessible by the software applications and restarts the software application to point to the patched seed data table copy. The patch can add or change a column of the seed data table copy or its schema.
-
Citations
20 Claims
-
1. A computer implemented method for online upgrading of a software application in a database environment using a transparently-patched seed data table, the method comprising:
-
copying, while the software application is running, data comprising a seed data table to database table rows temporarily inaccessible by the software application, the copying to create a seed data table copy; modifying the schema of the seed data table copy by applying at least one patch, the modifying to create a patched seed data table copy; stopping the software application, then changing the database table rows temporarily inaccessible by the software application to become accessible by the software application; and restarting the software application to point to the patched seed data table copy. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A computer system for online upgrading of a software application in a database environment using a transparently-patched seed data table, comprising:
-
a computer processor to execute a set of program code instructions; and a memory to hold the program code instructions, in which the program code instructions comprises program code to perform, copying, while the software application is running, data comprising a seed data table to database table rows temporarily inaccessible by the software application, the copying to create a seed data table copy; modifying the schema of the seed data table copy by applying at least one patch, the modifying to create a patched seed data table copy; stopping the software application, then changing the database table rows temporarily inaccessible by the software application to become accessible by the software application; and restarting the software application to point to the patched seed data table copy. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
-
15. 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 process to implement online upgrading of a software application in a database environment using a transparently-patched seed data table, the process comprising:
-
copying, while the software application is running, data comprising a seed data table to database table rows temporarily inaccessible by the software application, the copying to create a seed data table copy; modifying the schema of the seed data table copy by applying at least one patch, the modifying to create a patched seed data table copy; stopping the software application, then changing the database table rows temporarily inaccessible by the software application to become accessible by the software application; and restarting the software application to point to the patched seed data table copy. - View Dependent Claims (16, 17, 18, 19, 20)
-
Specification