Need to Load a Test Database? RowGen Generates Safe Database Test Data.

Home » Solutions » Test Data » DB Population

Safe Test Data for DB Population

Rapidly Populate Huge DBs with Safe, Referentially Correct Test Data Based on Your Data Models

Challenges:

Good DBAs know that testing should not be done with live data. Using production data may reflect reality well, but it can be expensive (depending on volume and test complexity) and carry the risk of exposing confidential information. The next best thing has been to run a population analysis, and manually build test data based on production volumes and layouts, key relationships and weighted distributions. But building and loading many types and rows of test data can take a long time.

Solutions:

Now there is a better, and much faster, way to generate massive amounts of test data in your table formats while also preserving referential integrity. IRI's test data generation package, RowGen, rapidly generates billions of rows of safe, intelligent test data for:

Oracle
Sybase
SQL Server
Teradata
DB2 UDB
Packaged Apps (e.g. PeopleSoft, Informatica)
Interdependent Flat Files

RowGen generates test data in custom file formats that comply with the column layouts, data types, and primary-foreign key relationships in your data models.

You can build as many rows -- with any length, layout, and field data types -- that your database can load and use. With RowGen, you can rapidly create all the files you need to populate huge, referentially correct database tables.

The field values in each row can be randomly generated or randomly selected from one or more real data pools (set files). Records can also begenerated in primary key order (since RowGen leverages the parallel CoSort engine) to improve the performance of bulk load utilities. This allows you to rapidly simulate load and query operations.

For database indexing, you can declare a "sequencer" field to assign an integer value to each sorted output record, and specify its starting value and offset position. This allows the database to cross-reference records over a number of fields, and helps DBAs using the left outer join option for key lookups when loading fact tables.

Because RowGen can produce multiple outputs (in multiple formats) simultaneously, each RowGen target can be a pipe into one or more database load utilities -- thus you can generate multiple tables (even an entire database) with common field names simultaneously. Multiple test files with common fields enable foreign keys and joins, and RowGen creates the tables and set files automatically, according to your data models.

Please request a free trial to see how quickly RowGen can mimic your database table and update characteristics with safe, model-driven, referentially correct, and pre-sorted test data.

IRI, The CoSort Company