• Extract accurate test data subsets from production data
• Scramble sensitive customer data
• Warp dates for testing purposes
• Verify referential integrity of production data
• Purge & archive obsolete production database records

X-Verify uses the data model constructed by X-Model to automatically verify that all application data satisfies the relationships deduced by the data model.The product examines each data record in turn to see if its referential integrity relationships are satisfied. Each integrity relationship that is breached is separately reported on in a comprehensive audit print produced by the product.

X-Cube uses all of the logical view indices and data in a transaction type file set to build the data and the data model from the bottom upwards. The output can then be used by one of Databorough's client products: ·

• DB2 Web Query

The result is an n-dimensional business intelligence application created without any programming effort at all.

X-Archive makes the task of purging and archiving live data manageable, simple and repeatable. Archived data can be browsed and restored as required, all without any need for program recompilation and maintaining referential integrity. With a combination of filtering and the system data model, it is possible to meet even the most complex of archiving requirements.The archiving can be controlled for an entire system, a predefined area of the system, or even an individual file.