Evaluating the performance of hardware platforms and software applications requires the use of realistic production data. Files and tables must be the right sizes, and contain the right data types, record formats, and counts.
Standard benchmarks promulgated by organizations like the Transaction Processing Performance Council may similarly require a wide range of pre-determined volumes and layouts of test data.
Large files and tables can take a long time to build and load without the right tools and techniques. Culling sample data from production can take time, and violate data privacy rules.
IRI RowGen (as well as its parent CoSort product) can synthesize safe, big test data files and database tables in any structured format, all in one job script and I/O pass. With RowGen, you can generate a complete and consistent battery of files for different software and hardware products, helping you find the best processing platforms for your environment.
RowGen can create any number (and size) of files or relational tables with any amount of columns in any fixed or delimited position, with more than 100 different data types available. The test records and fields can be selected and transformed to emulate production data, and values can recur or change in successive runs through random seed management.
Each field contains either randomly generated data, or data randomly selected from set files or numeric ranges to be more realistic.