Patent · US Active

Data access management during zero downtime upgrade

US9519675B2 · kind B2 · utility

17Cited by

0References

20Claims

0Family size

Assignee

SAP SE · DE

Inventors

Juergen Specht · Memmingen, DE
Lars-Eric Biewald · Mannheim, DE
Heiko Konrad · Hockenheim, DE
Steffen Meissner · Heidelberg, DE
Wieland Hoprich · Mannheim, DE
Volker Driesen · Heidelberg, DE

Key dates

Filing date	Oct 1, 2014
Grant date	Dec 13, 2016
Priority date	—
Expiry date	Jun 10, 2035

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/211
WIPO fieldComputer technology
WIPO sectorElectrical engineering

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.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.