Database Subsetting

What is Database Subsetting?

Database subsetting is a new and innovative way to make referentially correct, business intact, cut-down versions of your production database. Once a cut-down version is made, one or many smaller copies of that database are created for use in development or testing; saving you space and making your testing more efficient.

GT Datamaker™ contains a powerful subsetting tool. GT Subset allows you to define sets of tables to be extracted, add in your own relationships and define selection criteria. Grid-Tools database subsetting software uses native database utilities to migrate the data allowing you to incorporate the generated scripts into your existing test data management framework.

GT Subset can also scramble or mask your data as it is being extracted from production.

Grid-Tools offer basic to advanced subsetting

We have a vast level of experience in organising database subsetting tasks in highly complex environments.

These include:

An easy to use data explorer, allowing you to view the data as you design your subsets.
Utilization of the native database utilities to move the data, for example Oracle Data Pump, allows for high performance database subset builds.
The ability to shrink a database in situ, allowing you to reorganize your tables into different tablespaces and compress your data.
The ability to validate the quality of your data during testing. These checks can be incorporated into your standard testing processes.
The ability to compare data before and after a transaction, providing detail on what exactly changed in the database not just what you expect to have changed.
The ability to use “data cubes” to drive extracts, this allows you to provide an intersection of different parts of an application database, for example ensure that my Claim Providers and Claimants have matching claims.
The ability to date shift, will keep your time sensitive data up to date just as if you were using current production data.

Datamaker™ provides a complete test data management system, allowing you to subset, scramble and generate data as you need it.

Subsetting Architecture