![[Level:15]](http://www.vietnamesetestingboard.org/zbxe/modules/point/icons/default/15.gif "Point:7390point (68%), Level:15/30"){kind=icon}
AbrahamsWhat is database subsetting and what sort of techniques does
Grid-Tools use to create subset databases? Database subsetting is the
process of creating smaller, broken-down versions of production
databases to use for testing and development. This technique helps to
control data footprints and offers better manageability of production
data for non-production environments.
Datamaker™ contains a powerful database subsetting tool called Data Subset™. The tool allows the user to define sets of tables to be extracted, add in their own relationships and define selection criteria. In short, the Grid-Tools subsetting solution offers the user the ability to choose what data they might require for their subset. Gone are the days of making direct copies of production databases.
Data Subset™ also uses native database utilities to migrate the data, allowing the user to incorporate the generated scripts into their existing test data management framework. This is an attractive proposition when considering the importance of keeping structural and referential integrity
Data Subset™ can also mask or de-identify your data as it is being extracted from production. The process allows the user to identify what columns need to be secured and what functions need to be applied to enable this security. In the case of key columns the function will be automatically applied to related columns across your data model. In addition, the user's existing data manipulation functions can be incorporated as part of secure data obfuscation process.
