Zero downtime maintenance with maximum business functionality

Patent metadata

Field	Value
Publication number	US-9767424-B2
Application number	US-201314055650-A
Country	US
Kind code	B2
Filing date	Oct 16, 2013
Priority date	Oct 16, 2013
Publication date	Sep 19, 2017
Grant date	Sep 19, 2017

Abstract

The present disclosure describes methods, systems, and computer program products for providing multi-level user interface theming. One computer-implemented method includes instantiating a shadow system and database schema for a new version software application in a shared database, the shadow system database schema containing aliases pointing to tables instantiated in a production database schema, instantiating a bridge database schema containing aliases pointing to each database table within the production database schema, preparing a bridge sub-system connected to the bridge database schema aliases, replicating database tables within the production database schema, for use by the bridge sub-system and adjusting the original database tables for structure and content consistent with the new version software application, deploying an upgrade sub-system and tools to complete adjustment of structure and content of the original database tables, and connecting an instantiated instance of the new version software application to adjusted database tables.

First claim

What is claimed is:

1. A computer-implemented method for performing a persistent data upgrade, comprising:
instantiating, by a computer, a shadow system for a new version software application and a shadow system database schema in a database associated with persistent data and shared with a production system executing a first version software application, the shadow system database schema acting as a database connector and containing aliases pointing to original database tables instantiated in a production database schema associated with the production system, the new version software application requiring the persistent data upgrade;
instantiating a bridge database schema in the database, wherein the bridge database schema contains aliases pointing to each database table within the production database schema;
preparing a bridge sub-system to execute as the first version software application, the bridge sub-system being connected to the aliases contained within the bridge database schema;
replicating database tables within the production database schema, wherein the replicated database tables are used by the bridge sub-system and the original database tables are adjusted for structure and content consistent with the new version software application;
deploying an upgrade sub-system and tools to complete adjustment of structure and content of the original database tables, thereby creating new version database tables, for the new version software application; and
instantiating an instance of the new version software application and connecting the new version software application to the new version database tables.

2. The method of claim 1 , wherein an alias in the shadow system database schema points to a table instantiated in the production database schema containing at least the new version software application.

3. The method of claim 1 , wherein each database table within the production database schema is categorized according to the data associated with the database table.

4. The method of claim 3 , wherein only particular categorized database tables are replicated for use by the bridge sub-system.

5. The method of claim 1 , further comprising stopping the first version software application following rolling all end users from the first version software application to the bridge sub-system.

6. The method of claim 1 , wherein a compensation view is generated for the original database tables within the production database schema and is associated with one of the aliases contained within the bridge database schema, the compensation view being generated for one of the original database tables normally accessed using a view.

7. The method of claim 1 , further comprising shutting down the bridge sub-system, deleting the bridge database schema and associated aliases, and deleting the replicated database tables used by the bridge sub-system.

8. The method of claim 1 , further comprising:
generating a new alias with a new alias name to point to one of the original database tables;
dropping the new alias and renaming the one of the original database tables to the new alias name; and
repeating an access attempt to the new alias name after a dynamic or pre-determined time interval if the access attempt is made to the new alias or the one of the original database tables prior to completion of the dropping step and a database access error is generated.

9. A non-transitory, computer-readable medium storing computer-readable instructions executable by a computer and operable to:
instantiate a shadow system for a new version software application and a shadow system database schema in a database associated with persistent data and shared with a production system executing a first version software application, the shadow system database schema acting as a database connector and containing aliases pointing to original database tables instantiated in a production database schema associated with the production system, the new version software application requiring the persistent data upgrade;
instantiate a bridge database schema in the database, wherein the bridge database schema contains aliases pointing to each database table within the production database schema;
prepare a bridge sub-system to execute as the first version software application, the bridge sub-system being connected to the aliases contained within the bridge database schema;
replicate database tables within the production database schema, wherein the replicated database tables are used by the bridge sub-system and the original database tables are adjusted for structure and content consistent with the new version software application;
deploy an upgrade sub-system and tools to complete adjustment of structure and content of the original database tables, thereby creating new version database tables, for the new version software application; and
instantiate an instance of the new version software application and connecting the new version software application to the new version database tables.

10. The medium of claim 9 , wherein an alias in the shadow system database schema points to a table instantiated in the production database schema containing at least the new version software application.

11. The medium of claim 9 , wherein each database table within the production database schema is categorized according to the data associated with the database table.

12. The medium of claim 11 , wherein only particular categorized database tables are replicated for use by the bridge sub-system.

13. The medium of claim 9 , further storing instructions to stop the first version software application following rolling all end users from the first version software application to the bridge sub-system.

14. The medium of claim 9 , wherein a compensation view is generated for the original database tables within the production database schema and is associated with one of the aliases contained within the bridge database schema, the compensation view being generated for one of the original database tables normally accessed using a view.

15. The medium of claim 9 , further storing instructions to shut down the bridge sub-system, deleting the bridge database schema and associated aliases, and deleting the replicated database tables used by the bridge sub-system.

16. The medium of claim 9 , further storing instructions to:
generate a new alias with a new alias name to point to one of the original database tables;
drop the new alias and renaming the one of the original database tables to the new alias name; and
repeat an access attempt to the new alias name after a dynamic or pre-determined time interval if the access attempt is made to the new alias or the one of the original database tables prior to completion of the dropping step and a database access error is generated.

17. A system, comprising:
a memory configured to hold persistent data;
at least one computer interoperably coupled with the memory and configured to:
instantiate a shadow system for a new version software application and a shadow system database schema in a database associated with persistent data and shared with a production system executing a first version software application, the shadow system database schema acting as a database connector and containing aliases pointing to original database tables instantiated in a production database schema associated with the production system, the new version software application requiring the persistent data upgrade;
instantiate a bridge database schema in the database, wherein the bridge database schema contains aliases pointi

Assignees

• Biewald Lars-Eric
• Driesen Volker
• Engelko Andrey
• Haferkorn Andre
• Hartig Martin
• Hoprich Wieland
• Konrad Heiko
• Luettge Christoph
• Mayer Martin
• Meissner Steffen
• Mittelstein Matthias
• Specht Juergen
• Sap Se

Inventors

• Biewald Lars-Eric
• Driesen Volker
• Engelko Andrey
• Haferkorn Andre
• Hartig Martin
• Hoprich Wieland
• Konrad Heiko
• Luettge Christoph
• Mayer Martin
• Meissner Steffen
• Mittelstein Matthias
• Specht Juergen

Classifications

• G06Q10/06 Primary

  Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling · CPC title

• G06Q10/0631 Primary

  Resource planning, allocation, distributing or scheduling for enterprises or organisations · CPC title