US 11,789,920 B1
Framework for workload prediction and physical database design
Michael Brendle, Leimen (DE); Norman May, Karlsruhe (DE); Robert Schulze, Chemnitz (DE); Alexander Boehm, Schwetzingen (DE); Michael Grossniklaus, Kreuzlingen (CH); and Guido Moerkotte, Schriesheim (DE)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Mar. 28, 2022, as Appl. No. 17/705,728.
Int. Cl. G06F 16/22 (2019.01); G06F 11/34 (2006.01); G06F 16/25 (2019.01); G06F 16/21 (2019.01)
CPC G06F 16/2282 (2019.01) [G06F 11/3414 (2013.01); G06F 16/213 (2019.01); G06F 16/256 (2019.01)] 21 Claims
OG exemplary drawing
 
1. A system associated with a cloud computing environment, comprising:
a workload prediction framework, including:
a computer processor, and
a computer memory storing instructions that, when executed by the computer processor, cause the workload prediction framework to:
receive observed workload information associated with a database in the cloud computing environment,
based on the observed workload information, generate a Statement Arrival Rate (“SAR”) prediction,
based on the observed workload information, generate a host variable assignment prediction, and
using the SAR prediction and the host variable assignment prediction to automatically create a workload prediction for the database; and
a physical database design advisor, coupled to the workload prediction framework, to receive the workload prediction and, responsive to the workload prediction and a current physical layout of the database, automatically generate a recommended physical layout for the database.