US 12,292,883 B1
Snapshot changes for cloud systems during zero downtime upgrades
Lars-Eric Biewald, Mannheim (DE); Andrea Klein, Waghäusel (DE); and Stefan Runge, Mörlenbach (DE)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Mar. 21, 2024, as Appl. No. 18/611,833.
Int. Cl. G06F 16/23 (2019.01); G06F 11/14 (2006.01)
CPC G06F 16/2379 (2019.01) [G06F 11/1469 (2013.01); G06F 16/2358 (2019.01); G06F 2201/80 (2013.01); G06F 2201/84 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method for execution of an upgrade procedure for a database system, the method being executed by one or more processors and comprising:
providing, in a database system, a snapshot table;
replacing, in a first access schema of an access layer, a first projection view into records of a data table with a union view into records of the data table and records of the snapshot table;
creating, in a second access schema, a snapshot projection view, a second projection view, and a set of database triggers; and
during execution of an upgrade procedure that results in changes to records of the data table:
recording the changes to the records of the data table in the snapshot table, each change being implemented through the second projection view,
for each record of the data table changed by the upgrade procedure, providing the record in the snapshot table in an unchanged state through at least one database trigger of the set of database triggers and the snapshot projection view, and
returning a set of records through the union view in response to a query, the set of records comprising a first sub-set of records of the data table and a second sub-set of records of the snapshot table.