Patent ID: 7890476
Filing Date: 2011-02-15
Classification: G06F

Abstract:
1. A computer-implemented method for generating test data for testing data dependent applications, verifying schemas and sizing systems comprising: connecting to a first database; obtaining an existing schema associated with said first database comprising at least one table; connecting to a second database; obtaining profiling information from said second database comprising real data stored in said second database; performing a statistical analysis on at least one field of said second database for automatically determining a set of profile characteristics for at least one field of said first database using said profiling information, wherein the set of profile characteristics includes a cardinality for a particular field of said second database and an associated fill rate based on a percentage of field values across all records of said second database that are not null for that particular field; generating randomized test data for said at least one field of said first database conforming to said set of profile characteristics; adding said randomized test data to said first database; and performing at least one test to validate said existing schema of first database using said randomized test data.