Patent ID: 8549045

Claim:
A test data generation data processing system comprising: a host computer with at least one processor and memory; a test data generator configured to generate test data executing in the memory of the host computer; and a unique common factor sequencing module coupled to the test data generator, the module comprising program code configured to: select in a table loaded for test data generation in the test data generator, a column set of multiple columns in the table associated with a key to the table; assign different cardinality sequence values to the columns in the set, wherein the cardinality sequence values do not share a common factor except for unity; generate data for a specified number of rows of each column in the column set according to a formula currentRowValue=((row_number−1) % cardinality_value)+1; additionally generate random data for other columns of the table without regard to any particular cardinality sequence value; and persist the table for use in database testing.