Test data generation and scale up for database testing using unique common factor sequencing
First Claim
1. 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.
1 Assignment
0 Petitions
Accused Products
Abstract
Embodiments of the present invention provide a system and computer program product for test data generation using unique common factor sequencing. In an embodiment of the invention, a computer program product for test data generation using unique common factor sequencing is provided. The computer program product includes loading a table for population with test data in a test data generation tool executing in memory of a computer. A column set of multiple columns in the table associated with a key to the table is selected for processing and different cardinality sequence values are assigned to the columns in the set such that the cardinality sequence values do not share a common factor except for unity as in the case of prime numbers.
-
Citations
12 Claims
-
1. 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. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A computer program product for test data generation using unique common factor sequencing, the computer program product comprising a non-transitory computer readable storage medium having computer readable program code embodied therewith, the computer readable program code comprising:
-
computer readable program code for loading a table for population with test data in a test data generation tool executing in a memory of a computer; computer readable program code for selecting a column set of multiple columns in the table associated with a key to the table; computer readable program code for assigning different cardinality sequence values to the columns in the set, wherein the cardinality sequence values do not share a common factor except for unity; computer readable program code for generating 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;computer readable program code for additionally generating random data for other columns of the table without regard to any particular cardinality sequence value; and computer readable program code for persisting the table for use in database testing. - View Dependent Claims (8, 9, 10, 11, 12)
-
Specification