Data access management during zero downtime upgrade

Patent metadata

Field	Value
Publication number	US-9519675-B2
Application number	US-201414504241-A
Country	US
Kind code	B2
Filing date	Oct 1, 2014
Priority date	Oct 1, 2014
Publication date	Dec 13, 2016
Grant date	Dec 13, 2016

Abstract

A zero downtime upgrade procedure upgrading a source system to a target system is initiated that prepares software for the target system in parallel to the operation of the source system. As part of the upgrade procedure, source tables of the source system are renamed. Thereafter, the renamed source tables are cloned for the target system. Further, the renamed source tables are equipped with database triggers to transfer data from the renamed source tables to the cloned tables used by the source system according to a source database schema. Next, the target tables are generated that include updated software content for later use by the target system while the source tables are used via a bridge database schema. Tables can then be shared between the source database schema accessed via the bridge database schema and the target system.

First claim

What is claimed is:

1. A method comprising:
initiating a zero downtime upgrade procedure upgrading a source system to a target system that prepares software for the target system in parallel to the operation of the source system;
renaming source tables of the source system;
cloning the renamed source tables for the target system;
equipping the renamed source tables with database triggers to transfer data from the renamed source tables to the cloned tables used by the source system according to a source database schema;
generating the target tables comprising updated software content for later use by the target system while the source tables are used via a bridge database schema; and
sharing tables between the source database schema accessed via the bridge database schema and the target system.

2. The method of claim 1 , wherein restricting access to at least one table other than the cloned tables comprises:
determining which of a plurality of a tables should have restricted access during the upgrade procedure;
generating a names table comprising runtime objects corresponding to those tables;
deleting runtime objects from the names table that cannot be accessed during the upgrade; and
adding runtime objects to the names table corresponding to those tables that are determined not to be able to be accessed during the upgrade after completion of the upgrade procedure.

3. The method of claim 2 , wherein the names table comprises a metadata declaration for each listed runtime object.

4. The method of claim 3 , wherein the names table comprises field names and information types for each listed runtime object.

5. The method of claim 1 , wherein the restricted access prevents both read and write accesses to the corresponding tables.

6. The method of claim 1 further comprising:
logging attempts to access the tables with restricted access in a logging table.

7. The method of claim 6 , wherein the logging comprises storing the corresponding database table name, the accessed key, and a current timestamp.

8. The method of claim 6 , wherein there is a dedicated logging table for each table for which access is requested.

9. The method of claim 6 , wherein there is a single logging table for each of a plurality of tables for which access is requested.

10. The method of claim 1 , wherein restricting access to at least one table other than the cloned tables comprises:
preventing both read and write access to the at least one table.

11. The method of claim 1 , wherein restricting access to at least one table other than the cloned tables comprises:
preventing write access to the at least one table while allowing read access to the at least one table.

12. The method of claim 11 , further comprising: testing the target system prior to completing the upgrade procedure.

13. The method of claim 1 , wherein restricting access to at least one table other than the cloned tables comprises:
determining which of a plurality of a tables should have restricted write access during the upgrade procedure;
generating, for each table for which it was determined that should have restricted write access, a database trigger which prevents write accesses to the table; and
removing the database triggers preventing write access to the tables after completion of the upgrade procedure.

14. A non-transitory computer program product storing instructions, which when executed by at least one data processor forming part of at least one computing system, result in operations comprising:
initiating a zero downtime upgrade procedure upgrading a source system to a target system that prepares software for the target system in parallel to the operation of the source system;
renaming source tables of the source system;
cloning the renamed source tables for the target system;
equipping the renamed source tables with database triggers to transfer data from the renamed source tables to the cloned tables used by the source system according to a source database schema;
generating the target tables comprising updated software content for later use by the target system while the source tables are used via a bridge database schema; and
sharing tables between the source database schema accessed via the bridge database schema and the target system.

15. The computer program product of claim 14 , wherein restricting access to at least one table other than the cloned tables comprises:
determining which of a plurality of a tables should have restricted access during the upgrade procedure;
generating a names table comprising runtime objects corresponding to those tables;
deleting runtime objects from the names table that cannot be accessed during the upgrade; and
adding runtime objects to the names table corresponding to those tables that are determined not to be able to be accessed during the upgrade after completion of the upgrade procedure.

16. The computer program product of claim 15 , wherein the names table comprises a metadata declaration for each listed runtime object and comprises field names and information types for each listed runtime object.

17. The computer program product of claim 14 , wherein restricting access to at least one table other than the cloned tables comprises:
determining which of a plurality of a tables should have restricted write access during the upgrade procedure;
generating, for each table for which it was determined that should have restricted write access, a database trigger which prevents write accesses to the table; and
removing the database triggers preventing write access to the tables after completion of the upgrade procedure.

18. A system comprising:
at least one data processor; and
memory storing instructions, which when executed by the at least one data processor, result in operations comprising:
initiating a zero downtime upgrade procedure upgrading a source system to a target system that prepares software for the target system in parallel to the operation of the source system;
renaming source tables of the source system;
cloning the renamed source tables for the target system;
equipping the renamed source tables with database triggers to transfer data from the renamed source tables to the cloned tables used by the source system according to a source database schema;
generating the target tables comprising updated software content for later use by the target system while the source tables are used via a bridge database schema; and
sharing tables between the source database schema accessed via the bridge database schema and the target system.

19. The system of claim 18 , wherein restricting access to at least one table other than the cloned tables comprises:
determining which of a plurality of a tables should have restricted access during the upgrade procedure;
generating a names table comprising runtime objects corresponding to those tables;
deleting runtime objects from the names table that cannot be accessed during the upgrade; and
adding runtime objects to the names table corresponding to those tables that are determined not to be able to be accessed during the upgrade after completion of the upgrade procedure.

20. The system of claim 19 , wherein restricting access to at least one table other than the cloned tables comprises:
determining which of a plurality of a tables should have restricted write access during the upgrade procedure;
generating, for each table for which it was determined that should have restricted write access, a database trigger which prevents write acce

Assignees

• Specht Juergen
• Biewald Lars-Eric
• Konrad Heiko
• Meissner Steffen
• Hoprich Wieland
• Driesen Volker
• Sap Se

Inventors

• Specht Juergen
• Biewald Lars-Eric
• Konrad Heiko
• Meissner Steffen
• Hoprich Wieland
• Driesen Volker

Classifications

• G06F8/67

  Physics · mapped topic

• G06F17/30377 Primary

  Physics · mapped topic

• G06F17/30292

  Physics · mapped topic

• G06F8/65

  Updates (security arrangements therefor G06F21/57) · CPC title

• G06F8/656 Primary

  while running · CPC title