×

Test data generation and scale up for database testing using unique common factor sequencing

  • US 9,171,025 B2
  • Filed: 08/23/2013
  • Issued: 10/27/2015
  • Est. Priority Date: 12/30/2010
  • Status: Expired due to Fees
First Claim
Patent Images

1. 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 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;

    persist the first table for use in database testing; and

    scale up the first table to a new table of an original upper portion and an added lower portion by continuing into the added lower portion of the new table a sequence for each column in the column set of multiple columns based upon corresponding ones of the cardinality sequence values and based upon computing values of rows for each column in the column set of multiple columns in the added lower portion of the new table according to a formula;


    modifiedRowValue=(L+V−

    1% R)+1,where L is a last value in the first table for the column, V is an existing value for a row of the column in the new table, and R is a range for the column in the new table, while duplicating data in the other columns of the first table in the added lower portion of the new table.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×