X-Subset

X-Subset uses the data model constructed by X-Analysis and X-Rev to produce Data Sets that satisfy all the constraints of the production data model. In this way it is possible to produce data sets that can be used either for testing or data warehousing/migration/download purposes. X-Migrate can be used to download these data sets to other data base types such as, MS Access, MS-SQL etc.. The whole process is repeatable and command driven, and can be driven by user programs or manually as is required with each circumstance.

Key Features

• Select & Edit the X-Rev derived Data Model to your precise requirements
• Totally integrated with X-Analysis Tool Suite
• Intelligent self-tailoring selection interface
• Automated and repeatable
• RPG based I/O for efficiency on large databases.

Instant Test Data Subsets From Live Data...

An entire ‘blank’ test library is built by X-Subset based upon the data model produced in the first phase. The second phase has two possible methods of selecting the records to use for subsetting. This is either a specified number of records of a file that has no dependent data, or all of a predefined selection of these detailed records, which have been identified by specifying an owning or parent file with pre-seeded master records in. In this way it is possible to create test data subsets from the bottom up, or from the top down. A number of records is then extracted from the lowest level detail file of the production system and written to the test library. Each data modeling relationship in turn is then examined and the required data from the production system is written into the relevant place in the test library. The data model is then referenced to check that all referenced records have been included. It completes this process across the entire database – enabling the construction of test data libraries with no ‘broken inks’ between all related records.