Generating workloads for system verification

A computer system for facilitating processing within a computing environment, the computer system comprising:

• a memory;
• and
• at least one processor in communication with the memory, wherein the computer system is configured to perform a method, said 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.

A computer-implemented method of facilitating processing within a computing environment, the computer-implemented 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.