Systems, methods and articles of manufacture for upgrading a database with a shadow system
First Claim
1. A method for upgrading a database, the database including a main system with a source release accessible to a main database user, the method comprising:
- installing in the database a shadow system that includes a destination release accessible to a shadow database user, wherein installing the shadow system comprises defining storage structures for the destination release based on a name of the main database user, and creating synonyms for the shadow database user to provide access to storage structures for the destination release that are stored under the name of the main database user;
operating the shadow system in parallel with operation of the main system;
setting a plurality of triggers to detect and report chances in data in the main production system;
analyzing the triggers, during downtime of the main system, to restore or update the changed data in the shadow system back to the destination release; and
performing, during downtime of the main system, a system switch to remove the source release from the database and provide an upgraded system based on the destination release of the shadow system.
3 Assignments
0 Petitions
Accused Products
Abstract
Methods, systems, and articles of manufacture are disclosed for upgrading a database using of a shadow system. During an upgrade, the shadow system or repository is built as a new instance on the database. The shadow system may be a complete central instance and comprise the new release to be installed in the database. The new release or “destination release” may represent the release(s) of software application(s) and/or data that the user wants to run in the future. The destination release may replace a “source release” of software application(s) and/or data currently running on the database as part of a main productive system. In one embodiment, the shadow system may be operated in parallel with the main productive system to minimize the required downtime for the upgrade.
-
Citations
24 Claims
-
1. A method for upgrading a database, the database including a main system with a source release accessible to a main database user, the method comprising:
-
installing in the database a shadow system that includes a destination release accessible to a shadow database user, wherein installing the shadow system comprises defining storage structures for the destination release based on a name of the main database user, and creating synonyms for the shadow database user to provide access to storage structures for the destination release that are stored under the name of the main database user; operating the shadow system in parallel with operation of the main system; setting a plurality of triggers to detect and report chances in data in the main production system; analyzing the triggers, during downtime of the main system, to restore or update the changed data in the shadow system back to the destination release; and performing, during downtime of the main system, a system switch to remove the source release from the database and provide an upgraded system based on the destination release of the shadow system. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
-
-
13. A system for upgrading a database, the database including a source release accessible to a main database user, the system comprising:
-
means for installing in the database a shadow repository that includes a destination release accessible to a shadow database user, the means for installing comprising means for defining storage structures for the destination release based on a name of the main database user, and means for creating synonyms for the shadow database user to provide access to storage structures for the destination release; means for providing access to the shadow repository in parallel with access to the source release; means for setting a plurality of triggers to detect and report changes in data in the source release; means for analyzing the triggers, during downtime of the main system, to restore or update the chanced data in the shadow repository back to the destination release; and means for performing, during downtime of access to the source release, a system switch to replace the source release in the database with the destination release of the shadow repository. - View Dependent Claims (14, 15, 16, 17, 18)
-
-
19. A computer-readable medium that stores program instructions that are executable by a computing-based environment to perform a method for upgrading a database, the database including a main productive system with a source release accessible to a main database user, the source release comprising a plurality of software applications and associated data, the method comprising:
-
installing in the database a shadow system that includes a destination release accessible to a shadow database user, the destination release comprising at least one new release of a software application or data, wherein installing the shadow system comprises defining storage structures for the destination release based on a name of the main database user, and creating synonyms for the shadow database user to provide access to storage structures for the destination release; operating the shadow system in parallel with operation of the main productive system; setting a plurality of triggers to detect and report changes in data in the main productive system; analyzing the triggers, during downtime of the main productive system, to restore or update the changed data in the shadow system back to the destination release; and performing, during downtime of the main productive system, a system switch to remove the source release from the database and provide an upgraded system based on the destination release of the shadow system. - View Dependent Claims (20, 21, 22, 23, 24)
-
Specification