What is a database model?

A database model is a structured representation of a database. It acts as a snapshot of the database at a given point in time, capturing essential metadata such as any schemas, tables, columns, relationships, constraints and, other database-specific metadata.

The model does not contain actual data but rather defines how data is organized and the underlying layout of the database.

A database model serves as a reference that treatments use to act against.

Test Data Manager (TDM) needs read-only access of a live database instance to create a database model.

What is a treatment?

A treatment represents a set of changes that can be applied to the data in a database. Treatments are defined based on the database model, and are declarative description of the changes that will be made when the treatment is applied.

Type of treatments

There are two type of treatments available:

• Anonymization - the classification and masking of Personally Identifiable Information (PII).
• Subsetting - the extraction of data from one database (source) into another (target), preserving referential integrity.

Treating a database

To create a treatment for a database, first create a database model for that database. Next, create the required treatment against the database model. Once created the treatment can be applied to a database.

Multiple treatments can be created against a single database model.

To apply a treatment to a database follow the instructions provided in the run treatment screen.