US 11,907,108 B2
Generating workloads for system verification
Xue Bin Cong, Beijing (CN); Xiao Feng Meng, Beijing (CN); Ping Liang, Shang Di (CN); Yu He, Beijing (CN); and Peng Hui Jiang, Beijing (CN)
Assigned to INTERNATIONAL BUSINESS MACHINES CORPORATION, Armonk, NY (US)
Filed by INTERNATIONAL BUSINESS MACHINES CORPORATION, Armonk, NY (US)
Filed on Jan. 5, 2022, as Appl. No. 17/568,966.
Prior Publication US 2023/0214315 A1, Jul. 6, 2023
Int. Cl. G06F 11/00 (2006.01); G06F 11/36 (2006.01)
CPC G06F 11/3684 (2013.01) [G06F 11/3688 (2013.01)] 15 Claims
OG exemplary drawing
 
1. A computer program product for facilitating processing within a computing environment, the computer program product comprising:
at least one non-transitory computer readable storage medium and program instructions collectively stored on the at least one computer readable storage medium to perform a method comprising:
testing a database system of the computing environment, the testing incorporating database system runtime data to enhance accuracy of the testing, the testing comprising:
dynamically generating, by a testing engine running in the computing environment, a test workload to be executed to test the database system of the computing environment, the test workload being dynamically generated based, at least, on one or more runtime conditions of the database system, the dynamically generating the test workload comprising:
parsing, by a statement parser of the testing engine, one or more database statements of an input test case to generate one or more parsed structures;
performing, by a comparator engine of the testing engine, based on generation of the one or more parsed statement structures, a comparison of at least one parsed structure of the one or more parsed structures and at least one test workload structure of at least one existing workload to identify one or more workload structures as matching the at least one parsed structure;
running the database system and collecting, using a runtime engine of the testing engine, database system runtime data relating to running at least the one or more workload structures identified as matching the at least one parsed structure;
based on the database system runtime data and one or more new database statements of one or more candidate test workloads, automatically generating at least one combined workload structure comprising one or more statement structures representing the one or more new database statements of the one or more candidate test workloads, and at least a portion of the database system runtime data, the at least a portion of the database system runtime data representing a requested alteration to a statement structure of the one or more statement structures;
generating a plurality of workloads based, at least, on the at least one combined workload structure with the at least a portion of the database system runtime data;
generating the test workload based on the plurality of workloads, wherein generating the test workload includes binding, based on the database system runtime data, the plurality of workloads to generate the test workload to be used to test the database system, wherein use of the database system runtime data enhances accuracy of the database system testing; and
executing the test workload to test the database system.