US 12,461,839 B1
Database instance clustering
Jingun Hong, Seoul (KR); Dong Won Hwang, Seoul (KR); Sumi Yun, Seoul (KR); and Won Joon Lee, Seoul (KR)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on May 1, 2024, as Appl. No. 18/652,597.
Int. Cl. G06F 16/24 (2019.01); G06F 11/14 (2006.01); G06F 11/34 (2006.01); G06F 16/21 (2019.01); G06F 16/2453 (2019.01); G06F 16/25 (2019.01)
CPC G06F 11/3414 (2013.01) [G06F 11/1469 (2013.01); G06F 16/219 (2019.01); G06F 16/24542 (2019.01); G06F 16/256 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computing system comprising:
at least one hardware processor;
at least one memory coupled to the at least one hardware processor; and
one or more computer-readable storage media comprising computer-executable instructions that, when executed, cause the computing system to perform operations comprising:
for respective database instances of a plurality of database instances, receiving a respective set of attribute values for a defined set of attributes describing database instances of the plurality of database instances, wherein the defined set of attributes comprises values reflecting characteristics of database instances that are used to group the database instances into clusters for selecting representative instances to support workload capture and replay;
clustering the plurality of database instances into a plurality of clusters using the respective set of attribute values for the defined set of attributes for database instances of the plurality of database instances;
selecting at least one representative database instance from at least one cluster of the plurality of clusters using cluster definitions resulting from the clustering; and
capturing a workload executed on the at least one representative database instance, and fewer than database instances of the at least one cluster, to provide a captured workload, wherein capturing the workload comprises recording information describing database operations executed as part of the workload, the recorded information being sufficient to enable replay of the workload at another database instance of the plurality of database instances.