TEST DATA GENERATION AND SCALE UP FOR DATABASE TESTING USING UNIQUE COMMON FACTOR SEQUENCING
First Claim
1. A method for test data generation using unique common factor sequencing, the method comprising:
- loading a first table for population with test data in a test data generation tool executing in a memory of a computer;
selecting a column set of multiple columns in the first table associated with a key to the first table;
assigning different cardinality sequence values to each column in the column set of multiple columns, wherein the cardinality sequence values do not share a common factor except for unity and each cardinality sequence value indicates a number of values in a sequence before the sequence repeats;
generating data for a specified number of rows of each column in the column set of multiple columns according to a corresponding one of the cardinality sequence values;
additionally generating random data for other columns of the first table without regard to any particular cardinality sequence value; and
persisting the first table for use in database testing.
1 Assignment
0 Petitions
Accused Products
Abstract
Embodiments of the present invention provide a method, system and computer program product for test data generation using unique common factor sequencing. In an embodiment of the invention, a method for test data generation using unique common factor sequencing is provided. The method 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 can be 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
21 Claims
-
1. A method for test data generation using unique common factor sequencing, the method comprising:
-
loading a first table for population with test data in a test data generation tool executing in a memory of a computer; selecting a column set of multiple columns in the first table associated with a key to the first table; assigning different cardinality sequence values to each column in the column set of multiple columns, wherein the cardinality sequence values do not share a common factor except for unity and each cardinality sequence value indicates a number of values in a sequence before the sequence repeats; generating data for a specified number of rows of each column in the column set of multiple columns according to a corresponding one of the cardinality sequence values; additionally generating random data for other columns of the first table without regard to any particular cardinality sequence value; and persisting the first table for use in database testing. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A test data generation data processing system comprising:
-
a host computer with at least one processor and a 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 unique common factor sequencing module comprising program code configured to; select in a first table loaded for test data generation in the test data generator, a column set of multiple columns in the first table associated with a key to the first table; assign different cardinality sequence values to each column in the column set of multiple columns, wherein the cardinality sequence values do not share a common factor except for unity and each cardinality sequence value indicates a number of values in a sequence before the sequence before the sequence repeats; generate data for a specified number of rows of each column in the column set of multiple columns according to a corresponding one of the cardinality sequence values; additionally generate random data for other columns of the first table without regard to any particular cardinality sequence value; and persist the first table for use in database testing. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
-
15. 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 first 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 first table associated with a key to the first table; computer readable program code for assigning different cardinality sequence values to the columns in the column set of multiple columns, wherein the cardinality sequence values do not share a common factor except for unity and each cardinality sequence value indicates a number of values in a sequence before the sequence repeats; computer readable program code for generating data for the specified number of rows of each column in the column set of multiple columns according to a corresponding one of the cardinality sequence values; computer readable program code for additionally generating random data for other columns of the first 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 (16, 17, 18, 19, 20, 21)
-
Specification