Generating test data

A computer system to improve the generation of test data comprising:

• a memory storing instructions;
• a processor to execute the instructions to:
• generate a schema comprising database tables;
• receive a selection of the schema from a user;
• present a graphical display of the schema including visual representations of the database tables and visual representations of relationships between the database tables;
• receive a selection of a database table presented in the graphical display;
• in response to a receipt of the selection of the schema and the database table, generate a stored procedure to populate the database table with test data;
• execute the stored procedure to:
• generate the test data based on rule definitions and the schema;
• populate the database table with the test data, wherein the database table and the stored procedure are included in a relational database.

A non-transitory, computer-readable medium comprising machine-readable instructions to improve the generation of test data and executable by a processor to:

• generate a schema comprising a plurality of database tables;
• cause a graphical display of the schema, wherein the graphical display of the schema includes visual representations of the plurality of database tables and visual representations of relationships between the plurality of database tables, and wherein the schema is selectable by selecting the visual representation of a database table of the plurality of database tables from the graphical display;
• receive a selection of the schema from a user;
• in response to a receipt of the selection of the schema, generate a stored procedure to populate the database table with test data;
• execute the stored procedure to:
• generate the test data based on rule definitions and the schema;
• and populate the database table with the test data.

A non-transitory, computer-readable medium comprising machine-readable instructions to improve the generation of test data and executable by a processor, wherein the machine-readable instructions, when executed by the processor, cause the processor to:

• generate a schema comprising a database table;
• cause a graphical display of the schema, the schema being selectable by selecting a visual representation of the database table;
• cause a display of a rules interface in response to receiving a selection of the schema, wherein the rules interface receives rule definitions for populating the database table;
• generate a stored procedure to populate the database table, wherein the database table is populated with test data generated based on the rule definitions and the schema;
• and populate the database table using the stored procedure,
• wherein the database table and the stored procedure are included in a relational database.

A non-transitory, computer-readable medium comprising machine-readable instructions to improve the generation of test data and executable by a processor, wherein the machine-readable instructions, when executed by the processor, cause the processor to:

• generate a schema comprising a database table;
• receive a selection of the schema from a user;
• in response to a receipt of the selection of the schema, automatically generate a stored procedure for populating the database table with test data,
• wherein generating the stored procedure comprises receiving from the user via a rule interface, a rule definition including a function for computing at least a portion of the test data based on a column of the schema;
• and
• execute the stored procedure to populate the database table with the test data, wherein executing the stored procedure comprises generating the test data based on the rule definitions, user modifications, and the schema, wherein the database table and the stored procedure are included in a relational database.