Rapidly Populate Huge DBs with Safe, Referentially
Correct Test Data Based on Your Data Models
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.
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:
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.
- SQL Server
- DB2 UDB
- Packaged Apps (e.g. PeopleSoft, Informatica)
- Interdependent Flat Files
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
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.
Blog > Test Data
Solutions > Test Data for Benchmarking
Products > RowGen (Test Data)
Solutions > ETL/DB Acceleration > DB Operations
Thank you for sending us a request for information. We will get back to you shortly.