US 12,411,820 B2
Downtime-minimized database version deployment
Christian Lutter, Karlsruhe (DE); Welf Walter, Waghausel (DE); and Volker Driesen, Heidelberg (DE)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Mar. 21, 2023, as Appl. No. 18/187,261.
Prior Publication US 2024/0320198 A1, Sep. 26, 2024
Int. Cl. G06F 16/00 (2019.01); G06F 16/21 (2019.01)
CPC G06F 16/214 (2019.01) [G06F 16/213 (2019.01)] 18 Claims
OG exemplary drawing
 
1. A system comprising:
a memory storing processor-executable program code; and
at least one processing unit to execute the processor-executable program code to cause the system to:
determine one or more tables of a first data schema of a first database version, each of the one or more tables being associated with a respective table name and a respective first table structure in the first database version and associated with the same respective table name and a respective second table structure different from the respective first table structure in a second data schema of a second database version;
determine one or more views of a first view schema of the first database version, each of the one or more views being associated with a respective view name and a respective first view structure in the first database version and associated with the same respective view name and a respective second view structure different from the respective first view structure in the second database version;
determine runtime objects of the one or more tables and the one or more views of the first database version;
load the runtime objects of the one or more tables and the one or more views of the first database version into a runtime buffer of a first work process connected to the first view schema; and
while the first work process serves first incoming requests using the runtime objects loaded into the runtime buffer and the first view schema:
change the structure of the one or more tables to their respective second table structures;
in a second view schema which is a copy of the first view schema, change the structure of the one or more views to their respective second view structures;
connect a second work process to the second view schema; and
serve second incoming requests with the second work process, the changed views of the second view schema and the changed one or more tables.